System and Method for Aggregating Raw Data into a Star Schema

• US 20100023546A1
• Filed: 07/25/2008
• Published: 01/28/2010
• Est. Priority Date: 07/25/2008
• Status: Active Grant

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Silsby, Joseph M.
• Granted Patent: US 8,401,990 B2
• Time in Patent Office: Days
• US Class Current: N/A
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method for aggregating raw data into a star schema comprises receiving data from a data source. The data is aggregated into star schema objects, based on a user-defined metadata schema. The star schema objects are stored into a star schema database.

Claims

1. A method, comprising:

receiving data from a data source;

aggregating the data into star schema objects, based on a user-defined metadata schema; and

storing the star schema objects into a star schema database.

2. The method of claim 1, wherein the star schema database is generated in approximately real time using the user-defined metadata schema.

3. The method of claim 1, wherein the star schema objects comprise statistics relating to the data.

4. The method of claim 3, further comprising generating reports based on the statistics.

5. The method of claim 4, further comprising communicating the reports to a user.

6. The method of claim 1, wherein receiving data comprises retrieving filtered records from a data storage medium.

7. A system, comprising:

an interface being operable to receive data from a data source;

a processor being operable to aggregate the data into star schema objects, based on a user-defined metadata schema; and

a star schema database operable to store the star schema objects.

8. The system of claim 7, wherein the star schema database is generated in approximately real time using the user-defined metadata schema.

9. The system of claim 7, wherein the star schema objects comprise statistics relating to the data.

10. The system of claim 9, wherein the processor is further operable to generate reports based on the statistics.

11. The system of claim 10, wherein the interface is further operable to communicate the reports to a user.

12. The system of claim 7, further comprising a data storage medium, and wherein the data comprises filtered records store in the data storage medium.

13. Logic encoded in a computer readable medium and being operable, when executed on a processor, to:

receive data from a data source;

aggregate the data into star schema objects, based on a user-defined metadata schema; and

store the star schema objects into a star schema database.

14. The logic of claim 13, wherein the star schema database is generated in approximately real time using the user-defined metadata schema.

15. The logic of claim 13, wherein the star schema objects comprise statistics relating to the data.

16. The logic of claim 15, wherein the logic is further operable to generate reports based on the statistics.

17. The logic of claim 16, wherein the logic is further operable to communicate the reports to a user.

18. The logic of claim 13, wherein the data comprises filtered records in a data storage medium.