Method and apparatus for optimizing query generation by selectively utilizing attributes or key values
US6192357A · kind A · utility
18Cited by
18References
6Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Nov 3, 1998 |
| Grant date | Feb 20, 2001 |
| Priority date | — |
| Expiry date | Nov 3, 2018 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99943
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method of joining two or more sets of data in a database is provided wherein certain dimensions in the fact data are designated as being forced dimensions, and wherein for each forced dimension, a set of entries is created in the fact data each with the same key values in all of the dimensions other than the forced dimension, and each with a different member of the set of values existing in the fact data for that dimension, if and only if at least one entry exists in the fact data with the same set of key values in the dimensions other than the forced dimension.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.