Versioning data warehouses

Details Versioning data warehouses Versioning data warehouses

2009-05-01

2011-12-13

Leroux, Etienne (Department: 2161)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

Reexamination Certificate

active

08078570

ABSTRACT:
A method, system, and computer program product are disclosed. Exemplary embodiments of the method, system, and computer program product may include hardware, process steps, and computer program instructions for supporting versioning in a data warehouse. The data warehouse may include a data warehouse engine for creating a data warehouse including a fact table and temporary tables. Updated or new data records may be transferred into the data warehouse and bulk loaded into the temporary tables. The updated or new data records may be evaluated for attributes matching existing data records. A version number may be assigned to data records and data records may be marked as being the most current version. Updated and new data records may be bulk loaded from the temporary tables into the fact table when a version number or a version status is calculated.

REFERENCES:
patent: 6003036 (1999-12-01), Martin
patent: 6353835 (2002-03-01), Lieuwen
patent: 6766326 (2004-07-01), Cena
patent: 6795821 (2004-09-01), Yu
patent: 2005/0131964 (2005-06-01), Saxena
patent: 2006/0020619 (2006-01-01), Netz et al.
patent: 2006/0026199 (2006-02-01), Crea
patent: 2007/0083572 (2007-04-01), Bland et al.
patent: 2007/0239769 (2007-10-01), Fazal et al.
patent: 2007/0260578 (2007-11-01), Ghosh
patent: 2010/0005114 (2010-01-01), Dipper

Affiliated with

Also associated with

Rating

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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4311814