System and method for identifying and constructing star joins for execution by bitmap ANDing
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Aug 15, 2000
Grant Date -
N/A
app pub date -
Oct 11, 1999
filing date -
Oct 11, 1999
priority date (Note) -
Expired
status (Latency Note)
Importance
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.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully