Method for visualizing information in a data warehousing environment
First Claim
1. A method for analyzing information in at least one source database, said method comprising:
- receiving a definition of a reverse star schema meta-model;
generating a data warehouse populated with the information from the source database and in accordance with the reverse star schema meta-model;
receiving a definition of at least one of a plurality of customer profile groups;
receiving input indicating at least one quantity of interest in the information;
receiving a definition for a data model;
dynamically creating at least one generated database based upon the data warehouse and the data model and configured to the quantity of interest, further comprising;
creating at least one first dimension table based upon the data schema and the quantity of interest; and
creating at least one fact table based upon the data schema, the quantity of interest and the information; and
displaying at least a portion of the dynamically generated database.
2 Assignments
0 Petitions
Accused Products
Abstract
According to the invention, techniques for visualizing customer data contained in databases, data marts and data warehouses. In an exemplary embodiment, the invention provides a method for graphically analyzing relationships in data from one or more data sources of an enterprise. The method can be used with many popular visualization tools, such as On Line Analytical Processing (OLAP) tools and the like. The method is especially useful in conjunction with a meta-model based technique for modeling the enterprise data. The enterprise is typically a business activity, but can also be other loci of human activity. Embodiments according to the invention can display data from a variety of sources in order to provide visual representations of data in a data warehousing environment.
-
Citations
9 Claims
-
1. A method for analyzing information in at least one source database, said method comprising:
-
receiving a definition of a reverse star schema meta-model; generating a data warehouse populated with the information from the source database and in accordance with the reverse star schema meta-model; receiving a definition of at least one of a plurality of customer profile groups; receiving input indicating at least one quantity of interest in the information; receiving a definition for a data model; dynamically creating at least one generated database based upon the data warehouse and the data model and configured to the quantity of interest, further comprising; creating at least one first dimension table based upon the data schema and the quantity of interest; and creating at least one fact table based upon the data schema, the quantity of interest and the information; and displaying at least a portion of the dynamically generated database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer readable medium comprising one or more instructions for causing a processor to perform the steps of:
-
receiving a definition of a reverse star schema meta-model; generating a data warehouse populated with the information from a source database and in accordance with the reverse star schema meta-model; receiving a definition of at least one of a plurality of customer profile groups; receiving input indicating at least one quantity of interest in the information; receiving a definition for a data model; dynamically creating at least one generated database based upon the data warehouse and the data model and configured to the quantity of interest, further comprising; creating at least one first dimension table based upon the data schema and the quantity of interest; and creating at least one fact table based upon the data schema, the quantity of interest and the information; and displaying at least a portion of the dynamically generated database.
-
Specification