Apparatus for visualizing information in a data warehousing environment

• US 7,233,952 B1
• Filed: 01/13/2000
• Issued: 06/19/2007
• Est. Priority Date: 01/15/1999
• Status: Expired due to Fees

• Current Assignee: Hon Hai Precision Industry Co., Ltd.
• Original Assignee: Hon Hai Precision Industry Co., Ltd.
• Inventors: Chen, Li-Wen
• Primary Examiner(s): Colbert, Ella
• Application Number:
  US09/483,182
• Time in Patent Office: 2,714 Days
• Field of Search: 707/1, 707/10, 707/100, 707/101, 707/104.1, 707/200, 707/201, 707/206, 705/1, 705/5, 705/7, 705/14, 705/16, 705/26, 705/28, 705/30, 705/35, 705/39, 705/44, 705/52, 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: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• 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 apparatus for graphically analyzing relationships in data from one or more data sources of an enterprise. The apparatus can be used with many popular visualization tools, such as On Line Analytical Processing (OLAP) tools and the like. The apparatus 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. An apparatus comprising:

a memory,

a bus,

a processor, coupled to the memory by the bus, the processor operative to carry out the steps of;

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

receiving a definition of at least one customer profile group;

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

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 with information from the data warehouse based upon the data model, the customer profile group and configured to the quantity of interest; and

displaying at least a portion of the dynamically generated database.

2. The apparatus of claim 1 wherein the processor is further operative to carry out the steps of:

generating a customer profile report and wherein the information comprises business performance measures;

creating at least one first dimension table, including;

creating a customer profile hierarchy; and

creating at least one fact table, including;

aggregating business performance measures according to the customer profile hierarchy.

3. The apparatus of claim 1, wherein the information comprises business performance measures, and wherein the processor is further operative to carry out the steps of:

generating an operation report;

creating at least one fact table, including;

aggregating the business performance measures; and

filtering the customer profiles.

4. The apparatus of claim 1, wherein the information comprises customer records, and wherein the processor is further operative to carry out the steps of:

generating a customer behavior report;

creating at least one first dimension table, including;

creating at least one customer profiling dimension based upon the at least one customer profile group received; and

creating at least one fact table, including;

aggregating customer records based on at least one customer profiling dimension.

5. The apparatus of claim 1, wherein the processor is further operative to carry out the steps of:

creating a list of customers for each customer profile group;

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

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

6. The apparatus of claim 1 wherein the information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.

7. The apparatus of claim 1, wherein the processor is further operative to carry out the steps of:

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

generating at least one targeted customer segment table based upon the dynamically generated database; and

providing the targeted customer segment table to external applications.

8. The apparatus of claim 1, wherein dynamically generating a 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.

9. A computer implemented method, comprising a computer performing the following steps:

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

receiving a definition of a customer profile group;

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

receiving input indicating a quantity of interest in the information;

receiving a definition for a data model;

dynamically creating a dynamically generated database from information in the data warehouse based upon the data model, customer profile group and configured to the quantity of interest; and

displaying at least a portion of the dynamically generated database.

10. The method of claim 9, further comprising:

generating a customer profile report and wherein the information comprises business performance measures;

creating at least one first dimension table, including;

creating a customer profile hierarchy; and

creating at least one fact table, including;

aggregating business performance measures according to the customer profile hierarchy.

11. The method of claim 9, wherein the information comprises business performance measures, the method further comprising:

generating an operation report;

creating at least one fact table, including;

aggregating the business performance measures; and

filtering the customer profiles.

12. The method of claim 9, wherein the information comprises customer records, the method further comprising:

generating a customer behavior report;

creating at least one first dimension table, including;

creating at least one customer profiling dimension based upon the at least one customer profile group received; and

creating at least one fact table, including;

aggregating customer records based on at least one customer profiling dimension.

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

14. A computer readable medium, carrying one or more sequences of instructions, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:

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

receiving a definition of a customer profile group;

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

receiving input indicating a quantity of interest in the information;

receiving a definition for a data model;

dynamically creating a dynamically generated database from information in the data warehouse based upon the data model, customer profile group and configured to the quantity of interest; and

displaying at least a portion of the dynamically generated database.

15. The computer readable medium of claim 14, further comprising instructions for carrying out the steps of:

generating a customer profile report and wherein the information comprises business performance measures;

creating at least one first dimension table, including;

creating a customer profile hierarchy; and

creating at least one fact table, including;

aggregating business performance measures according to the customer profile hierarchy.

16. The computer readable medium of claim 14, wherein the information comprises business performance measures, the computer readable medium further comprising instructions for carrying out the steps of:

generating an operation report;

creating at least one fact table, including;

aggregating the business performance measures; and

filtering the customer profiles.

17. The computer readable medium of claim 14, wherein the information comprises customer records, the computer readable medium further comprising instructions for carrying out the steps of:

generating a customer behavior report;

creating a first dimension table, including;

creating a customer profiling dimension based upon the definition of a customer profile group received; and

creating a fact table, including;

aggregating customer records based on the customer profiling dimension.

18. The computer readable medium of claim 14 wherein information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.