HISTORICAL DATA WAREHOUSING SYSTEM
First Claim
1. A method, comprising:
- a) obtaining data from a source system;
b) pre-processing the obtained data by a stepwise operation to generate preprocessed data, wherein last operated upon data is recorded;
c) transforming the preprocessed data into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data, and d) storing the subject-oriented data in a data warehouse;
wherein the Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse.
2 Assignments
0 Petitions
Accused Products
Abstract
A method comprises obtaining data from a source system. Further, the obtained data is pre-processed by a stepwise operation to generate pre-processed data. The last operated upon data is recorded. In addition, the pre-processed data is transformed into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data. Additionally, the subject-oriented data is stored in a data warehouse. The Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse.
-
Citations
16 Claims
-
1. A method, comprising:
-
a) obtaining data from a source system;
b) pre-processing the obtained data by a stepwise operation to generate preprocessed data, wherein last operated upon data is recorded;
c) transforming the preprocessed data into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in the source system to link related pre-processed data, and d) storing the subject-oriented data in a data warehouse;
wherein the Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse. - View Dependent Claims (2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13)
-
-
14. A method, comprising:
-
a) obtaining data records from a source system;
b) pre-processing the obtained data records to generate pre-processed data records, wherein the pre-processing comprises operating on each data record in a serial manner, adding new data to a prior operated-on record with an entry being recorded for the last serially operated-on record;
c) transforming the pre-processed data records into related subject-oriented data records, wherein the transforming comprises linking related pre-processed data records together by way of reusable primary keys on the source system and dates within a Relational Database Management System in the source system; and
d) storing the related subject-oriented data records in a historical data warehouse;
wherein the Relational Database Management System dates are utilized for distinctly characterizing the subject-oriented data when a plurality of tables containing data with duplicate primary keys are combined in the data warehouse. - View Dependent Claims (7)
-
-
15. A method, comprising:
-
a) obtaining data records from a legacy source system;
b) pre-processing the obtained data records to generate pre-processed data records, wherein the pre-processing comprises operating on each data record in a stepwise manner, adding new data to a prior operated-on record with an entry being recorded for the record having the last stepwise operation c) transforming the pre-processed data records into related subject-oriented data records, wherein the transforming comprises linking related pre-processed data records together by way of reusable primary keys on the source system and dates obtained by scraping a Relational Database Management System of the legacy source system; and
d) storing the related subject-oriented data records in a data warehouse. - View Dependent Claims (16)
-
Specification