System and method for identifying and constructing star joins for execution by bitmap ANDing
US6105020A · kind A · utility
51Cited by
21References
25Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Oct 11, 1999 |
| Grant date | Aug 15, 2000 |
| Priority date | — |
| Expiry date | Oct 11, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for a relational database system for identifying star joins in a query and for breaking the query down for bitmap ANDing. The fact table of the star join is located, and cycles between and within dimension tables are broken. Then, the minimal set of tables necessary to execute the star join is identified, and the dimension tables that should appear in the bitmap ANDing plan are also identified. A bitmap ANDing plan is then generated, or, if the query does not qualify for bitmap ANDing, a conventional execution plan is generated.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.