CUSTOM DATA MART CREATION

• US 20120173478A1
• Filed: 12/30/2010
• Published: 07/05/2012
• Est. Priority Date: 12/30/2010
• Status: Abandoned Application

• Current Assignee: Cerner Innovation, Inc. (Oracle Corporation)
• Original Assignee: Cerner Innovation, Inc. (Oracle Corporation)
• Inventors: JENSEN, BRETT FREDERICK, GOSCH, JODY, VITALE, JOHN, SCHARTZ, RAYMOND, PARKS, RUSSELL, HARRISON, CHARLES
• Application Number:
  US12/982,233
• Publication Number:
  US 20120173478A1
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Systems, methods, and computer-readable media for creating custom data marts are provided. A selection of at least one table from a data source stored within a data warehouse is received. A selection of at least one column from the at least one table is received. Joins are created based on the selections, metadata is created and stored, and physical schema is generated to store the data mart data. The custom data mart fact table is populated with data from the selected columns. Facilities are provided for the end-user to create an abstraction layer for business intelligence reporting needs.

Claims

1. Computer storage media having computer-executable instructions embodied thereon, that when executed, perform a method for facilitating the creation of custom data marts based on data stored in a data warehouse, the method comprising:

receiving a selection of a first table from a data source stored within the data warehouse;

receiving a selection of at least one column from the first table;

receiving a selection of a second table from a data source stored within the data warehouse;

receiving a selection of at least one column from the second table;

creating joins based on the selection of tables and columns; and

populating a custom data mart fact table with data from the selected columns and corresponding tables.

2. The media of claim 1, wherein joins include dimension joins and custom joins.

3. The media of claim 1, wherein the first table originates from a different data source than the second table.

4. The media of claim 1, wherein the first table originates from the same data source as the second table.

5. The media of claim 1, wherein the tables are sourced from operational data store tables, fact tables, or a combination thereof.

6. The media of claim 1, wherein creating joins includes loading all metadata associated with the selected tables and dynamically updating a schema associated with the custom data mart.

7. The media of claim 1, wherein populating a custom data mart comprises:

receiving a selection of a schedule from a user for populating a custom data mart

populating the custom data mart according to the selected schedule.

8. The media of claim 1, wherein populating a custom data mart comprises:

creating a schema based on the selected columns; and

populating the schema with data from the selected columns.

9. The media of claim 1, wherein the data is historical data.

10. The media of claim 1, further comprising creating a business intelligence semantic layer for facilitating the generation of reports.

11. The media of claim 10, further comprising receiving a report request for generating a report against the custom data mart.

12. Computer-readable media having computer-executable instructions embodied thereon that, when executed, produce a graphical user interface (GUI) for creating custom data marts, the GUI comprising:

a first display area configured for receiving a selection of at least one table associated with health care related data stored in a data warehouse;

a second display area configured for receiving a selection of at least one column stored within the at least one table;

a third display area configured for displaying a list of selected columns associated with a custom data mart; and

a fourth display area configured for receiving user-defined attributes for the custom data mart.

13. The GUI of claim 12, wherein the selected columns are selected from tables originating from separate data sources.

14. The GUI of claim 12, further comprising a fifth display area configured for displaying the custom data mart populated with data from the selected columns.

15. A computerized system for facilitating the creation of custom data marts, the system comprising:

at least one device transmitting health care related data to a server comprising at least one component;

a table selection component for receiving a selection of a table associated with the health care related data stored in a data warehouse;

a column selection component for receiving a selection of a column associated with the selected table;

a join component for creating joins based on the selection of tables and columns; and

a population component for populating the custom data mart with data from the selected columns.

16. The system of claim 15, further comprising a scheduling component for scheduling the population of the custom data mart with data from the selected columns.

17. The system of claim 15, further comprising a schema component for creating a schema based on the selected columns, wherein the schema is populated by the population component.

18. The system of claim 15, further comprising a business intelligence component for creating an abstraction layer for facilitating the generation of reports.

19. The system of claim 18, further comprising a reporting component for generating reports of the custom data mart facilitated by the abstraction layer.

20. The system of claim 15, wherein the data is historical data.