×

HISTORICAL DATA WAREHOUSING SYSTEM

  • US 20070136330A1
  • Filed: 10/11/2006
  • Published: 06/14/2007
  • Est. Priority Date: 02/08/2001
  • Status: Active Grant
First Claim
Patent Images

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 all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×