System and method for identifying and constructing star joins fo

Details System and method for identifying and constructing star joins fo System and method for identifying and constructing star joins fo

1999-10-11

2000-08-15

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 3, G06F 1730

Patent

active

061050202

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.

REFERENCES:
patent: 5519859 (1996-05-01), Grace
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5551031 (1996-08-01), Cheng et al.
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5668987 (1997-09-01), Schneider
patent: 5761657 (1998-06-01), Hoang
patent: 5790818 (1998-08-01), Martin
patent: 5835634 (1998-11-01), Abrams
patent: 5845276 (1998-12-01), Emerson et al.
patent: 5848408 (1998-12-01), Jakobson et al.
patent: 5905985 (1999-05-01), Malloy et al.
patent: 5926818 (1999-07-01), Malloy
patent: 5940818 (1999-08-01), Malloy et al.
patent: 5943668 (1999-08-01), Malloy et al.
patent: 5960428 (1999-09-01), Lindsay et al.
patent: 5963932 (1999-10-01), Jakobson et al.
patent: 5978788 (1999-11-01), Castelli et al.
patent: 5978796 (1999-11-01), Malloy et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6003024 (1999-12-01), Bair et al.
patent: 6003036 (1999-12-01), Martin

Affiliated with

Also associated with

Rating

System and method for identifying and constructing star joins fo does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for identifying and constructing star joins fo, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for identifying and constructing star joins fo will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2018234