System for visualizing information in a data warehousing environment

• US 7,007,029 B1
• Filed: 01/13/2000
• Issued: 02/28/2006
• Est. Priority Date: 01/15/1999
• Status: Expired due to Fees

• Current Assignee: Hon Hai Precision Industry Co., Ltd.
• Original Assignee: Metaedge
• Inventors: Chen, Li-Wen
• Primary Examiner(s): Colbert, Ella
• Application Number:
  US09/483,386
• Time in Patent Office: 2,238 Days
• Field of Search: 707/1, 707/10, 707/100, 707/104.1, 707/200, 707/206, 707/101, 707/201, 705/1, 705/5, 705/7, 705/14, 705/16, 705/26, 705/28, 705/30, 705/35, 705/39, 705/44, 705/10, 706/52, 717/5, 717/102, 717/104, 717/105
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957
• CPC Class Codes: G06Q 30/00 Commerce
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

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 system for graphically analyzing relationships in data from one or more data sources of an enterprise. The system can be used with many popular visualization tools, such as On Line Analytical Processing (OLAP) tools and the like. The system 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.

Claims

1. A computer program product for analyzing information in a first database, said first database organized according to a first data schema said computer program product comprising:

code for defining a virtual data model;

code for determining from the virtual data model a second data schema;

code for receiving as input a third data model definition;

code for creating a third database having a third data schema from the third data model;

code for creating a first mapping, that provides a translation for data from said first data schema to said second data schema;

code for creating a second mapping, that provides a translation for data from the second data schema to the third data schema;

code for selectively migrating information from at least one of the first database to the second database according to the first mapping, and the second database to the third database according to the second mapping;

wherein the virtual data model comprises a reverse star schema; and

a computer readable storage medium for holding the codes.

2. The computer program product of claim 1 wherein said first data schema comprises a star schema.

3. The computer program product of claim 1 wherein virtual data model comprises an identity centric data organization.

4. The computer program product of claim 3 wherein said identity is a customer identity.

5. The computer program product of claim 1 wherein said information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.

6. A computer program product comprising:

code for receiving a definition of a reverse star schema meta-model;

code for generating a data warehouse populated with the information from the source database and in accordance with the reverse star schema meta-model;

code for providing the data warehouse as a source database for creating the dynamically generated database;

code for receiving a definition of at least one of a plurality of customer profile groups;

code for receiving input indicating at least one quantity of interest in the information;

code for receiving a definition for a data model;

code for dynamically creating at least one generated database based upon the data model and configured to the quantity of interest, further comprising;

code for creating at least one first dimension table based upon the data schema and the quantity of interest; and

code for creating at least one fact table based upon the data schema and the quantity of interest and the information; and

code for displaying at least a portion of the dynamically generated database; and

a computer readable storage medium for containing the codes.

7. The computer program product of claim 6 further comprising code for generating a customer profile report and wherein the information comprises business performance measures, and wherein:

code for creating at least one first dimension table further comprises;

code for creating a customer profile hierarchy; and

code for creating at least one fact table further comprises;

code for aggregating said business performance measures according to said customer profile hierarchy.

8. The computer program product of claim 6 further comprising code for generating an operation report, and wherein the information comprises business performance measures, and wherein:

code for creating at least one fact table further comprises;

code for aggregating said business performance measures; and

code for filtering said customer profiles.

9. The computer program product of claim 6 further comprising code for generating a customer behavior report, and wherein the information comprises customer records, and wherein:

code for creating at least one first dimension table further comprises;

code for creating a at least one of a plurality of customer profiling dimensions based upon the at least one of a plurality of customer profile groups received; and

code for creating at least one fact table further comprises;

code for aggregating customer records based on said at least one of a plurality of customer profiling dimensions.

10. The computer program product of claim 6 further comprising:

code for creating a list of customers for each one of the plurality of customer profile groups;

code for creating at least one intermediary data structure to manage the list of customers; and

code for creating customer classification components in a meta model for each customer profile group.

11. The computer program product of claim 6 wherein said information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.

12. The computer program product of claim 6 wherein code for receiving a definition of at least one of a plurality of customer profile groups further comprises;

code for creating a list of customers for each one of the plurality of customer profile groups; and

code for creating customer classification components in a meta model for each customer profile group.

13. The computer program product of claim 6, wherein the code for dynamically creating at least one generated database further comprises:

code for receiving an input from an on-line application processor (OLAP);

code for transforming the input into a database query based upon the data model; and

code for providing information in response to the database query.

14. A system for visualizing information, said system comprising:

an OLAP server;

at least one data source;

a data warehouse;

at least one decision support computer, interoperable with said data warehouse, said at least one data source and said OLAP server;

wherein said decision support computer is operatively disposed to;

create a mapping based upon a virtual meta-model schema, said mapping providing a translation for data in said at least one data source to said data warehouse;

migrate said data from said at least one data source to said data warehouse according to said mapping; and

provide said data to said OLAP server for display, wherein the virtual meta-model schema is a reverse star schema.

15. The system of claim 14 wherein said virtual virtual schema meta-model comprises an identity centric data organization.

16. The system of claim 15 wherein said identity is a customer identity.

17. The system of claim 14 wherein said information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.

18. The system of claim 14, wherein said decision support computer is operatively disposed to:

receive a selection of a targeted customer segment of interest as the quantity of interest;

generate at least one of a plurality of targeted customer segment tables based upon the dynamically generated database; and

provide the targeted customer segment tables to external applications.

19. A computer implemented method for analyzing information in a first database, said first database organized according to a first data schema, the method comprising a computer performing steps of:

defining a virtual data model;

determining from the virtual data model a second data schema;

receiving as input a third data model definition;

creating a third database having a third data schema from the third data model;

creating a first mapping, that provides a translation for data from said first data schema to said second data schema;

creating a second mapping, that provides a translation for data from the second data schema to the third data schema; and

selectively migrating information from at least one of the first database to the second database according to the first mapping, and the second database to the third database according to the second mapping;

wherein the virtual data model comprises a reverse star schema.

20. The method of claim 19 wherein said first data schema comprises a star schema.

21. The method of claim 19 wherein virtual data model comprises an identity centric data organization.

22. The method of claim 21 wherein said identity is a customer identity.

23. The method of claim 19 wherein said information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.

24. A computer implemented method, the method comprising a computer performing steps of:

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;

providing the data warehouse as a source database for creating the dynamically generated database;

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 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 and the quantity of interest and the information; and

displaying at least a portion of the dynamically generated database.

25. The method of claim 24 further comprising generating a customer profile report and wherein the information comprises business performance measures, and wherein:

creating at least one first dimension table further comprises;

creating a customer profile hierarchy; and

creating at least one fact table further comprises;

aggregating said business performance measures according to said customer profile hierarchy.

26. The method of claim 24 further comprising generating an operation report, and wherein the information comprises business performance measures, and wherein:

creating at least one fact table further comprises;

aggregating said business performance measures; and

filtering said customer profiles.

27. The method of claim 24 further comprising generating a customer behavior report, and wherein the information comprises customer records, and wherein:

creating at least one first dimension table further comprises;

creating a at least one of a plurality of customer profiling dimensions based upon the at least one of a plurality of customer profile groups received; and

creating at least one fact table further comprises;

aggregating customer records based on said at least one of a plurality of customer profiling dimensions.

28. The method of claim 24 further comprising:

creating a list of customers for each one of the plurality of customer profile groups;

creating at least one intermediary data structure to manage the list of customers; and

creating customer classification components in a meta model for each customer profile group.

29. The method of claim 24, wherein dynamically creating at least one generated database further comprises:

receiving an input from an on-line application processor (OLAP);

transforming the input into a database query based upon the data model; and

providing information in response to the database query.

30. A computer implemented method for visualizing information,

the method comprising a computer performing steps of:

creating at the computer, a mapping based upon a virtual meta-model schema, the mapping providing a translation for data from at least one data source to a data warehouse;

migrating data from the at least one data source to the data warehouse according to the mapping; and

providing the data to the OLAP server for display, wherein the virtual meta-model schema is a reverse star schema.

31. The method of claim 30, further comprising:

receiving a selection of a targeted customer segment of interest as the quantity of interest;

generating at least one of a plurality of targeted customer segment tables based upon the dynamically generated database; and

providing the targeted customer segment tables to external applications.