Method And System For Providing Business Intelligence Data

• US 20130124241A1
• Filed: 11/14/2012
• Published: 05/16/2013
• Est. Priority Date: 11/15/2011
• Status: Active Grant

• Current Assignee: pVelocity, Inc.
• Original Assignee: pVelocity, Inc.
• Inventors: YEUNG, Vivien, LU, Kang, LEE, Michael, PAROUSIS, Bill, ZHANG, Keling
• Granted Patent: US 10,102,236 B2
• Time in Patent Office: Days
• US Class Current: 705/7.11
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management

Abstract

A computer implemented method for data mining and providing business intelligence data including generating by an analytics server one or more dimensions from source data imported from a computer readable medium, wherein the one or more dimensions define categories into which portions of the normalized data can be grouped; generating by the analytics server one or more measures from the source data linked to the one or more dimensions; storing by the analytics server the one or more dimensions and the one or more measures in a plurality of tables arranged in one of a snowflake and a star schema; determining by the analytics server relationship information between one or more measures and one or more dimensions in each of the plurality of tables; storing by the analytics server the relationship information on the computer readable medium; calculating by the analytics server a total cost of at least one product based on the relationship information; and, querying by a computer system in communication with the analytics server for the change in total cost of the at least one product based on a change in any one of the measures.

Claims

1. A system for data mining and providing business intelligence data comprising

an analytics server including a computer readable medium having a data file stored thereon, said data file consisting of said data aggregated from one or more data sources in the form of source data;

wherein said analytics server includes computer readable instructions stored on said computer readable medium for;

generating one or more dimensions from said source data, wherein said one or more dimensions define categories into which portions of said normalized data can be grouped;

generating one or more measures from said source data linked to said one or more dimensions;

storing said one or more dimensions and said one or more measures in a plurality of tables arranged in one of a snowflake and a star schema;

determining relationship information between one or more measures and one or more dimensions in each of said plurality of tables;

storing said relationship information on said computer readable medium;

calculating a total cost of at least one product based on said relationship information;

one or more computing devices in communication with said analytics server, and including a module stored on a further computer readable medium having instructions thereon for;

querying and receiving data from said analytics server

wherein said querying comprises querying for the change in total cost of said at least one product based on a change in any one of said measures.

2. The system according to claim 1, wherein said step of determining relationship information comprises determining relationship information between any one of said one or more measures and an additional any one of said one or more measures selected from said one or more measures linked to the same dimension.

3. The system according to claim 1, wherein said step of determining relationship information comprises determining relationship information between any one of said one or more measures and an additional any one of said one or more measures selected from one or more measures linked to a different dimension.

4. The system according to claim 1, wherein said step of determining relationship information comprises determining a plurality of relationships between any one or more of said measures and dimensions.

5. The system according to claim 4, wherein each of said plurality of tables contains one or more dimensions and measures related to a component or process required to produce an end product.

6. The system according to claim 5, wherein each of said plurality of tables has a cost associated therewith, wherein said cost is a percentage of a total cost required to produce said end product.

7. The system according to claim 6, wherein said relationship information includes each said costs, and said computer readable instructions further include storing said costs in a costs table.

8. The system according to claim 7, wherein said computer readable instructions further includes instructions for responding to a query by said one or more computing devices by determining a total product cost based on an identified change in one or more measures and said percentage of said total cost as stored in said costs table.

16. The method according to claim 7, further comprising responding by said analytics server to a query by said one or more computing devices by determining a total product cost based on an identified change in one or more measures and said percentage of said total cost as stored in said costs table.

9. A computer implemented method for data mining and providing business intelligence data comprising

generating by an analytics server one or more dimensions from source data imported from a computer readable medium, wherein said one or more dimensions define categories into which portions of said normalized data can be grouped;

generating by said analytics server one or more measures from said source data linked to said one or more dimensions;

storing by said analytics server said one or more dimensions and said one or more measures in a plurality of tables arranged in one of a snowflake and a star schema;

determining by said analytics server relationship information between one or more measures and one or more dimensions in each of said plurality of tables;

storing by said analytics server said relationship information on said computer readable medium;

calculating by said analytics server a total cost of at least one product based on said relationship information;

querying by a computer system in communication with said analytics server for the change in total cost of said at least one product based on a change in any one of said measures.

10. The method according to claim 9, wherein said step of determining relationship information comprises determining relationship information between any one of said one or more measures and an additional any one of said one or more measures selected from said one or more measures linked to the same dimension.

11. The method according to claim 9, wherein said step of determining relationship information comprises determining relationship information between any one of said one or more measures and an additional any one of said one or more measures selected from one or more measures linked to a different dimension.

12. The method according to claim 9, wherein said step of determining relationship information comprises determining a plurality of relationships between any one or more of said measures and dimensions.

13. The method according to claim 12, wherein each of said plurality of tables contains one or more dimensions and measures related to a component or process required to produce an end product.

14. The method according to claim 13, wherein each of said plurality of tables has a cost associated therewith, wherein said cost is a percentage of a total cost required to produce said end product.

15. The method according to claim 14, wherein said relationship information includes each said costs, and said computer readable instructions further include storing said costs in a costs table.