×

OPTIMIZING ACCESS TO A DATABASE BY UTILIZING A STAR JOIN

  • US 20070083490A1
  • Filed: 09/27/2006
  • Published: 04/12/2007
  • Est. Priority Date: 09/29/2005
  • Status: Active Grant
First Claim
Patent Images

1. A method for use in optimizing a database query for a star database schema including at least one fact table and at least one dimension table, in which the database query includes an IN-List condition, where the method includes:

  • transforming the IN-List into a relation;

    joining the relation with the dimension table to produce a join result; and

    joining the join result to the fact table.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×