Patent US7320001B1 successfully refreshed from Google Patents.
US7320001B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for visualizing information in a data warehousing environment
Assignee: Hon Hai Precision Industry Co Ltd
•
Filing: 2000-01-13
•
Granted: 2008-01-15
•
Expires: 2020-01-13
Abstract
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.
Inventors
- 👤 Li-Wen Chen
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 12:55
CPC Classifications
G; G06; G06Q; G06Q40/00; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/248; G06F16/26; G06Q10/00; G06Q10/06; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 11
Claim 1
Independent Claim
149 words
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.
Claim 2
Independent Claim
149 words
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.
Claim 3
Dependent Claim
62 words
The method of claim 1 , 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 from the customer profile groups; and creating at least one fact table further comprises: aggregating said business performance measures according to said customer profile hierarchy.
Claim 4
Dependent Claim
39 words
The method of claim 1 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.
Claim 5
Dependent Claim
80 words
The method of claim 1 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 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.
Claim 6
Dependent Claim
49 words
The method of claim 1 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.
Claim 7
Dependent Claim
26 words
The method of claim 1 wherein said information comprises at least one of telecommunications information, financial information, retail marketing information, insurance information, and health care information.
Claim 8
Dependent Claim
51 words
The method of claim 1 , 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.
Claim 9
Dependent Claim
43 words
The method of claim 1 , wherein the dynamically 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.
Claim 10
Dependent Claim
153 words
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.
Claim 11
Dependent Claim
153 words
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.
References Cited (Backward Citations)
US5615109A
Cited
US5799286A
Cited
US5832496A
Cited
US5767854A
Cited
US5848408A
Cited
US5978788A
Cited
US5794246A
Cited
US5905985A
Cited
US6377993B1
Cited
US6594653B2
Cited
US6161103A
Cited
US6212524B1
Cited
US6484179B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2011-01-14 | 2011-07-16 | 2012-01-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2015-01-14 | 2015-07-16 | 2016-01-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2019-01-14 | 2019-07-16 | 2020-01-15 | $7700.00 | Window Closed / Lapsed |