Historical data warehousing system

Details Historical data warehousing system Historical data warehousing system

2006-10-11

2010-02-16

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07664741

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.

REFERENCES:
patent: 5890154 (1999-03-01), Hsiao et al.
patent: 6138121 (2000-10-01), Costa et al.
patent: 6324546 (2001-11-01), Ka et al.
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6421667 (2002-07-01), Codd et al.
patent: 6510432 (2003-01-01), Doyle
patent: 6587857 (2003-07-01), Carothers et al.
patent: 6714945 (2004-03-01), Foote et al.
patent: 6735591 (2004-05-01), Khan
patent: 6892210 (2005-05-01), Erickson et al.
patent: 7113923 (2006-09-01), Brichta et al.
patent: 7143099 (2006-11-01), Lecheler-Moore et al.
patent: 7206805 (2007-04-01), McLaughlin, Jr.
patent: 2002/0016771 (2002-02-01), Carothers et al.
patent: 2002/0184210 (2002-12-01), Khan
patent: 2003/0225736 (2003-12-01), Bakalash et al.
Office Action Summary from U.S. Appl. No. 09/780,123 mailed on Jun. 15, 2005.
Advisory Action Summary from U.S. Appl. No. 09/780,123 mailed on Mar. 15, 2006.
Final Office Action Summary from U.S. Appl. No. 09/780,123 mailed on Dec. 27, 2005.
Notice of Allowance from U.S. Appl. No. 09/780,123 mailed on Jul. 11, 2006.

Affiliated with

Also associated with

Rating

Historical data warehousing system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Historical data warehousing system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Historical data warehousing system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4228731