Patent ID: 7664741

Claim:
A method, comprising: a) obtaining data from a source system; b) pre-processing, utilizing a pre-processor, the obtained data by a stepwise operation to generate pre-processed data, wherein the pre-processing comprises recording only last operated upon obtained data whereby data recording is avoided during data addition for efficiency purposes; c) transforming the pre-processed data into subject-oriented data by utilizing reusable primary keys and Relational Database Management System dates in an operating system 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; wherein the dates within the Relational Database Management System of the source system are obtained by log-scraping the Relational Database Management System.