Patent ID: 9158818
Filing Date: 2015-10-13
Classification: G06F

Abstract:
1. A non-transitory computer readable storage medium storing one or more sequences of instructions for causing a system to facilitate identification of a star schema defining a structure for storing a desired data in a data warehouse, said desired data being already stored in a database organized as a normalized schema, wherein said normalized 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 and a second query directed to said database organized as said normalized schema; examining said first query to determine 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 wherein said first join is according to said normalized schema, wherein said examining also examines said second query to determine a third join of a seventh table and an eighth table, wherein said seventh table and said eighth table are contained in said plurality of tables, wherein said third join is according to said normalized schema; and forming said star schema for said data warehouse by including a first relationship associating said first table and said second table in said star schema based on said examining of said first query in response to said receiving said first query, said forming also including a sixth relationship associating said seventh table and said eighth table in said star schema based on said examining of said second query in response to said receiving of said second query, whereby said star schema includes both of said first relationship and said sixth relationship.