Historical data warehousing system

Details Historical data warehousing system Historical data warehousing system

2006-11-28

2006-11-28

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07143099

ABSTRACT:
Utilizing change data capture methodology, a computer facilitated historical data warehousing system accepts transactional/operational data having no directly tied dates from a legacy source system and processes that data into a subject-oriented format that is optimized for analytical and query reports via a two step process comprised of pre-processing and transforming. The pre-processing step entails a serial modification of data with only the last modification being recorded. The transforming step involves linking related data by utilizing reusable primary keys and dates obtained from an RDBMS in an operation system of the legacy source system that supplied the transactional/operational data.

REFERENCES:
patent: 5381332 (1995-01-01), Wood
patent: 5515098 (1996-05-01), Carles
patent: 5696906 (1997-12-01), Peters et al.
patent: 5765142 (1998-06-01), Allred et al.
patent: 5799286 (1998-08-01), Morgan et al.
patent: 5822410 (1998-10-01), McCausland et al.
patent: 5884284 (1999-03-01), Peters et al.
patent: 6138121 (2000-10-01), Costa et al.
patent: 6385604 (2002-05-01), Bakalash 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: 6892210 (2005-05-01), Erickson et al.
patent: 2002/0016771 (2002-02-01), Carothers et al.
patent: 2003/0225736 (2003-12-01), Bakalash et al.

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-3630695