Facilitating Identification of Star Schemas in Database Environments
First Claim
Patent Images
1. A computer readable medium carrying one or more sequences of instructions for causing a system to facilitate identification of a star schema for a database, wherein a schema of said database defines a plurality of tables in said database, wherein execution of said one or more sequences of instructions by one or more processors contained in said system causes said system to perform the actions of:
- receiving a first query requiring a first join of a first table and a second table, wherein said first table and said second table are contained in said plurality of tables; and
including a first relationship associating said first table and said second table in said star schema.
1 Assignment
0 Petitions
Accused Products
Abstract
Facilitating identification of star schemas in database environments. In an embodiment, queries are examined to determine the joins required. The two tables of each join are added as a relationship in the star schema.
-
Citations
14 Claims
-
1. A computer readable medium carrying one or more sequences of instructions for causing a system to facilitate identification of a star schema for a database, wherein a schema of said database defines a plurality of tables in said database, wherein execution of said one or more sequences of instructions by one or more processors contained in said system causes said system to perform the actions of:
-
receiving a first query requiring a first join of a first table and a second table, wherein said first table and said second table are contained in said plurality of tables; and including a first relationship associating said first table and said second table in said star schema. - View Dependent Claims (2, 3, 4)
-
-
5. A method of faciliating identification of a star schema for a database, wherein a schema of said database indicates a plurality of relationships existing among a plurality of tables in said database, wherein said method comprises:
-
receiving a plurality of queries, wherein each of said plurality of queries specifies a corresponding one of a plurality of subset of relationships, said subset of relationships being contained in said plurality of relationships; and generating said star schema as including said plurality of subset of relationships. - View Dependent Claims (6, 7, 8, 9)
-
-
10. An apparatus for facilitating identification of a star schema for a database, wherein a schema of said database indicates a plurality of relationships existing among a plurality of tables in said database, wherein said apparatus comprises:
-
means for receiving a plurality of queries, wherein each of said plurality of queries specifies a corresponding one of a plurality of subset of relationships, said subset of relationships being contained in said plurality of relationships; and means for generating said star schema as including said plurality of subset of relationships. - View Dependent Claims (11, 12, 13, 14)
-
Specification