Data warehouse with a domain fact table

• US 8,311,975 B1
• Filed: 02/28/2011
• Issued: 11/13/2012
• Est. Priority Date: 02/28/2011
• Status: Active Grant

• Current Assignee: Bluegalaxy LLC
• Original Assignee: Allan Michael Gonsalves
• Inventors: Gonsalves, Allan Michael
• Primary Examiner(s): LEROUX, ETIENNE PIERRE
• Application Number:
  US13/037,034
• Time in Patent Office: 624 Days
• Field of Search: 707/2, 707/3, 707/200, 707/606
• US Class Current: 707/606
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A data warehouse includes a plurality of master data tables. The master data tables include surrogate identifiers. Each surrogate identifier (SID) identifies a master data table domain inside a master data table from the plurality of master data tables. A plurality of dimension tables use the surrogate identifiers to link to the master data table domains within the master data tables. A fact table stores dimension identifiers (DIM IDs) that provide links to the dimension tables. A domain fact table stores aggregated data aggregated from data stored in the master data tables. The aggregated data is accessible from the domain fact table using surrogate identifiers, without using DIM IDs stored in the fact table.

Claims

1. A data warehouse comprising:

a plurality of master data tables, the master data tables including surrogate identifiers, each surrogate identifier (SID) identifying a master data table domain inside a master data table from the plurality of master data tables;

a plurality of dimension tables, the dimension tables using the surrogate identifiers to link to the master data table domains within the master data tables;

a fact table, the fact table storing dimension identifiers (DIM IDs) that provide links to the dimension tables; and

,

a domain fact table, the domain fact table storing aggregated data aggregated from data stored in the master data tables, the aggregated data being accessible from the domain fact table using surrogate identifiers, without using DIM IDs stored in the fact table.

2. A data warehouse as in claim 1 wherein the aggregated data are arranged as key performance indicators tracked by high level management of a company.

3. A data warehouse as in claim 1, additionally comprising:

a user interface unit through which a user sets up technical definitions, data processing approach and business rules to be followed during the population of the domain fact table with data.

4. A data warehouse as in claim 1, additionally comprising:

a user interface unit through which a user sets up technical definitions, data processing approach and business rules to be followed during the population of the domain fact table with data; and

,

a master data processing unit that processes data based on the business rules, the technical definitions and the data processing approach set up by the user interface unit.

5. A data warehouse as in claim 1, additionally comprising:

a user interface unit through which a user sets up technical definitions, data processing approach and business rules to be followed during the population of the domain fact table with data;

a master data processing unit that processes data based on the business rules, the technical definitions and the data processing approach set up by the user interface unit; and

,

domain interface acting as a bridge between the master data processing unit and the domain fact table, the domain interface building mapping rules between the master data processing unit and the domain fact table, the domain interface also performing validations.

6. A data warehouse as in claim 5, wherein the domain fact table is one of a plurality of domain fact tables.

7. A data warehouse as in claim 5, wherein the domain fact table is one of a plurality of domain fact tables and the domain interface is one of a plurality of domain interfaces.

8. A data warehouse as in claim 5, wherein the domain fact table is one of a plurality of domain fact tables and the domain interface is one of a plurality of domain interfaces, each domain fact table in the plurality of domain fact tables being associated with a dedicated domain interface from the plurality of domain interfaces.

9. A data warehouse as in claim 1, additionally comprising:

a child master data table accessible from the domain fact table.

10. A data warehouse as in claim 1, wherein the domain fact table is one of a plurality of domain fact tables.

11. A data warehouse as in claim 1 wherein rows of data in the domain fact table consist of a surrogate identifier and a key performance indicator.

12. A data warehouse as in claim 1 wherein aggregated data comprises a selective set of master data from at least one application set that helps to meets reporting requirements of a user.

13. A method for organizing and accessing data in a data warehouse, the method comprising:

arranging the data in a plurality of master data tables, the master data tables including surrogate identifiers, each surrogate identifier (SID) identifying a master data table domain inside a master data table from the plurality of master data tables;

storing the surrogate identifiers in a plurality of dimension tables, the dimension table using the surrogate identifiers to link to the master data table domains within the master data tables;

storing dimension identifiers (DIM IDs) within a fact table, the (DIM IDs) providing links to the dimension tables; and

,

storing, in a domain fact table, aggregated data aggregated from a subset of the data stored in the master data tables, the aggregated data being accessible from the domain fact table using surrogate identifiers, without using DIM IDs stored in the fact table.

14. A method as in claim 13, additionally comprising:

providing a user interface unit through which a user sets up technical definitions, data processing approach and business rules to be followed during the population of the domain fact table with data.

15. A method as in claim 13, additionally comprising:

providing a user interface unit through which a user sets up technical definitions, data processing approach and business rules to be followed during the population of the domain fact table with data; and

,

providing a master data processing unit that processes data based on the business rules, the technical definitions and the data processing approach set up by the user interface unit.

16. A method as in claim 13, additionally comprising:

providing a user interface unit through which a user sets up technical definitions, data processing approach and business rules to be followed during the population of the domain fact table with data;

providing a master data processing unit that processes data based on the business rules, the technical definitions and the data processing approach set up by the user interface unit; and

,

providing domain interface to act as a bridge between the master data processing unit and the domain fact table, the domain interface building mapping rules between the master data processing unit and the domain fact table, the domain interface also performing validations.

17. A method as in claim 13, wherein the domain fact table is one of a plurality of domain fact tables.

18. A method as in claim 13 wherein the aggregated data is obtained from an external source or from data already existing in the data warehouse and placed both in the domain fact table and the master data tables.

19. A method as in claim 13 wherein the aggregated data are arranged as key performance indicators tracked by high level management of a company.

20. A data warehouse comprising:

a plurality of master data tables, the master data tables including surrogate identifiers, each surrogate identifier (SID) identifying a master data table domain inside a master data table from the plurality of master data tables;

a domain fact table, the domain fact table storing aggregated data aggregated from data stored in the master data tables, the aggregated data being accessible from the domain fact table using surrogate identifiers, without using dimension identifiers (DIM IDs) stored in a fact table; and

,

a child master data table accessible from the domain fact table.