OPTIMIZING ACCESS TO A DATABASE BY UTILIZING A STAR JOIN
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.
2 Assignments
0 Petitions
Accused Products
Abstract
A database query is optimized for a star database schema that includes at least one fact table and at least one dimension table, where the database query includes an IN-List condition. During optimization, the IN-List is transformed into a relation and the relation is joined with the dimension table to produce a join result. The join result is then joined to the fact table.
-
Citations
30 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A database system for accessing a database, the database system including:
-
a parallel processing system including one or more nodes;
multiple CPUs, each of the one or more nodes providing access to one or more of the CPUs;
multiple virtual processes, each of the one or more CPUs providing access to one or more of the virtual processes, each process configured to manage data stored in one of a plurality of data-storage facilities;
an optimizer for 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, the optimizer configured to;
transform the IN-List into a relation;
join the IN-List relation with the dimension table to produce a join result; and
joining the join result to the fact table. - View Dependent Claims (17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
-
Specification