System and method for automatically building an OLAP model in a relational database
First Claim
1. A method for automatically building metadata objects for use by a multidimensional analysis program from a set of query statements, comprising:
- analyzing the query statements to obtain usage metrics;
generating metadata of the multidimensional analysis program from the query statements by evaluating the usage metrics to select candidate metadata objects and defining one or more metadata objects from the candidate metadata objects; and
populating the metadata of the multidimensional analysis program by creating the one or more defined metadata objects.
2 Assignments
0 Petitions
Accused Products
Abstract
A system automatically generates OLAP metadata objects for a multidimensional analysis program such as OLAP from SQL statements without involving the database administrator, and eliminates the need for database administrators to manually perform this analysis and design. The system deconstructs a set of SQL statements into tables and aggregates metrics for measures and joins. It recognizes that the relational database structure contains both dimension tables and fact tables. Over many SQL statements, fact tables will have a large measure metric while dimension tables will have a low measure metric. Tables are linked based on large join metrics; small join metrics are ignored. The present system builds the OLAP cube model from the fact tables, dimension tables, and joins. The analysis of the SQL statements allows the system to map the hierarchies within the dimension table, and provides the system with information about attribute relationships and cubes.
-
Citations
30 Claims
-
1. A method for automatically building metadata objects for use by a multidimensional analysis program from a set of query statements, comprising:
-
analyzing the query statements to obtain usage metrics; generating metadata of the multidimensional analysis program from the query statements by evaluating the usage metrics to select candidate metadata objects and defining one or more metadata objects from the candidate metadata objects; and populating the metadata of the multidimensional analysis program by creating the one or more defined metadata objects. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer program product having instruction codes for automatically building metadata objects for use by a multidimensional analysis program from a set of query statements, comprising:
-
a first set of instruction codes for analyzing the query statements to obtain usage metrics; a second set of instruction codes for generating metadata of the multidimensional analysis program from the query statements by evaluating the usage metrics to select candidate metadata objects and defining one or more metadata objects from the candidate metadata objects; and a third set of instruction codes for populating the metadata of the multidimensional analysis program by creating the one or more defined metadata objects. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A system for automatically building metadata objects for use by a multidimensional analysis program from a set of query statements, comprising:
-
means for analyzing the query statements to obtain usage metrics; means for generating metadata of the multidimensional analysis program from the query statements by evaluating the usage metrics to select candidate metadata objects and defining one or more metadata objects from the candidate metadata objects; and means for populating the metadata of the multidimensional analysis program by creating the one or more defined metadata objects. - View Dependent Claims (22, 23, 24, 25, 26, 27, 28, 29, 30)
-
Specification