METHODS AND SYSTEMS FOR METADATA DRIVEN DATA CAPTURE FOR A TEMPORAL DATA WAREHOUSE
First Claim
Patent Images
1. A system comprising:
- a data warehouse; and
a platform independent data warehouse load application operable to run on said system, said load application comprising a sequencing unit configured to utilize timestamp data from incoming data to be stored in said data warehouse and a relational algebra of set operators to identify and sequence net changes between the incoming data and data previously stored within said data warehouse, said load application configured to non-intrusively load the identified and sequenced net changes into said data warehouse.
1 Assignment
0 Petitions
Accused Products
Abstract
A system is described that includes a data warehouse and a platform independent data warehouse load application operable to run on the system. The load application includes a sequencing unit configured to utilize timestamp data from incoming data to be stored in the data warehouse and a relational algebra of set operators to identify and sequence net changes between the incoming data and data previously stored within the data warehouse. The load application is configured to non-intrusively load the identified and sequenced net changes into the data warehouse.
-
Citations
21 Claims
-
1. A system comprising:
-
a data warehouse; and a platform independent data warehouse load application operable to run on said system, said load application comprising a sequencing unit configured to utilize timestamp data from incoming data to be stored in said data warehouse and a relational algebra of set operators to identify and sequence net changes between the incoming data and data previously stored within said data warehouse, said load application configured to non-intrusively load the identified and sequenced net changes into said data warehouse. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method of loading a data warehouse, said method comprising:
-
analyzing a set of incoming data with respect to itself and an existing data warehouse; identifying and sequencing any net change data between the incoming data and the existing data warehouse using a relational algebra set of operators; normalizing said net changes with respect to a primary key within a table and a time period that varies with the sequences of rows within the primary key; and applying any net change data as an update to the data warehouse. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer program embodied on a computer readable medium for loading a data warehouse with net change data, said program comprising a code segment that:
-
utilizes an autocoder to dynamically generate code to analyze a set of incoming data with respect to itself and an existing data warehouse; identifies and sequences net changes between the incoming data and data previously stored within the data warehouse; and loads the identified and sequenced net changes into the data warehouse. - View Dependent Claims (20, 21)
-
Specification