System and method for automatically building an OLAP model in a relational database
First Claim
1. A method for automatically building a model for use by a multidimensional analysis program from a set of query statements, comprising:
- analyzing the query statements;
generating metadata of the multidimensional analysis program from the query statements; and
populating the metadata of the multidimensional analysis program.
4 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 a model for use by a multidimensional analysis program from a set of query statements, comprising:
-
analyzing the query statements;
generating metadata of the multidimensional analysis program from the query statements; and
populating the metadata of the multidimensional analysis program. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer program product having instruction codes for automatically building a model 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;
a second set of instruction codes for generating metadata of the multidimensional analysis program from the query statements; and
a third set of instruction codes for populating the metadata of the multidimensional analysis program. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A system for automatically building a model for use by a multidimensional analysis program from a set of query statements, comprising:
-
means for analyzing the query statements;
means for generating metadata of the multidimensional analysis program from the query statements; and
means for populating the metadata of the multidimensional analysis program. - View Dependent Claims (22, 23, 24, 25, 26, 27, 28, 29, 30)
-
Specification