Incremental data warehouse updating

Details Incremental data warehouse updating Incremental data warehouse updating

2007-10-18

2010-10-26

Le, Debbie (Department: 2168)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

C707S695000

Reexamination Certificate

active

07822712

ABSTRACT:
Processes, systems and computer programs for data management. New fact data is received, e.g., at a data warehouse, and the new fact data is aggregated to incrementally update a first version of a materialized view (a pre-computed aggregation of data), the updated materialized view being a second version of the materialized view. While aggregating the new data, the first version of the materialized view is provided for serving by a query subsystem. After aggregating the new data to the materialized view, the second version of the materialized view is provided for serving by the query subsystem thereafter. At least one version of the materialized view is available for serving by the query subsystem even during aggregation.

REFERENCES:
patent: 6064999 (2000-05-01), Dalal
patent: 6353835 (2002-03-01), Lieuwen
patent: 6493708 (2002-12-01), Ziauddin et al.
patent: 6882993 (2005-04-01), Lawande et al.
patent: 7010523 (2006-03-01), Greenfield et al.
patent: 7139783 (2006-11-01), Hinshaw et al.
patent: 7181440 (2007-02-01), Cras et al.
patent: 7266549 (2007-09-01), de Souza et al.
patent: 7440969 (2008-10-01), Schmitt
patent: 7469241 (2008-12-01), Bellamkonda et al.
patent: 7523124 (2009-04-01), Lavdas et al.
patent: 7580944 (2009-08-01), Zhuge et al.
patent: 2002/0194163 (2002-12-01), Hopeman et al.
patent: 2003/0036809 (2003-02-01), Landman et al.
patent: 2003/0083925 (2003-05-01), Weaver et al.
patent: 2005/0060300 (2005-03-01), Stolte et al.
patent: 2005/0235001 (2005-10-01), Peleg et al.
patent: 2006/0047696 (2006-03-01), Larson et al.
patent: 2006/0122964 (2006-06-01), Yu et al.
patent: 2006/0168515 (2006-07-01), Dorsett et al.
patent: 2006/0224564 (2006-10-01), Yu et al.
patent: 2007/0226264 (2007-09-01), Luo et al.
patent: 2008/0040382 (2008-02-01), Morris et al.
patent: 2008/0148367 (2008-06-01), Hilerio et al.
patent: 2009/0019005 (2009-01-01), Hu et al.
patent: 2009/0100336 (2009-04-01), Powley et al.
Sachin Kulkarmo et. al, “Concurrent Maintenance of Views Using Multiple Versions”, Aug. 2, 2004, pp. 1-6.
“Choosing the Attributes for the Dimension Tables”IBM Informix Database Design and Implementation Guide[online] Nov. 2, 2005 <URL: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp? topic=/com.ibm.ddi.doc/ddi232.htm> [retrieved Aug. 6, 2009], 2 pages.
“The Dimension Tables” IBM Red Brick Warehouse 6.3 Information Center, IBM Corp [online] Mar. 2004 <URL: http://publib.boulder.ibm.com/infocenter/rbhelp/v6r3/index.jsp?topic=/com.ibm.redbrick.doc6.3/ssg/ssg14.htm> [retrieved Aug. 6, 2009], 2 pages.
“Distributed Hash Table” Wikipedia [online] Jun. 10, 2007 <URL: www.en.wikipedia.org/wiki/Distriblited—hash—table> [retrieved Jun. 12, 2007], 5 pages.
Fan, Hao et al., “Using AutoMed Metadata in Data Warehousing Environments,” DOLAP 2003, ACM Sixth International Workshop on Data Warehousing and OLAP, New Orleans, Louisiana, USA, Nov. 7, 2003, Proceedings, Retrieved from the Internet, URL:<http://www.dcs.bbk.ac.uk/˜ap/pubs/dolap03.pdf>, 8 page.
Forsman, Sarah, “OLAP Council White Paper” [online] 1997 <URL: http://www.symcorp.com/downloads/OLAP—CouncilWhitePaper.pdf> [retrieved Aug. 6, 2009], 5 pages.
“Java Programming: Section 12.3 (Map Classes)” Internet FAQ Archive [online] <URL:http://72.14.253.104/search?q=cache:VxilWYuu5ncJ:www.faqs.org/docs/javap/c12/s3.html> [retrieved Jun. 12, 2007], 7 pages.
Kimball, Ralph et al.,The Data Warehouse Toolkit Second Edition(1996), John Wiley and Sons, Inc., ISBN 0-471-20024-7, Chapter 1, pp. 1-19.
“Logical Design in Data Warehouses”Oracle9i Data Warehousing Guide, Release 2 (9.2) [online] <URL: http://download.oracle.com/docs/cd/B10501—01/server.920/a96520/logical.htm> [retrieved Mar. 23, 2009], 6 pages.
“OLAP Cube” Wikipedia, the Free Encyclopedia [online]Apr. 24, 2007 <URL: www.en.wikipedia.org/wiki/OLAP—cube>, [retrieved May 15, 2007], 3 pages.
Pike, R. et al. “Interpreting the Data: Parallel Analysis With Sawzall”Scientific Programming, vol. 13, No. 4 (2005), pp. 277-298.
Vaisman, Alejandro et al., “A Temporal Query Language for OLAP: Implementation and a Case Study”DBPL 2001. Rome, Italy, Sep. 2001, pp. 78-96.
Weir, Rob et al., “Best Practice for Implementing a Data Warehouse: A Review for Strategic Alignment”DMDW 2003, Berlin, Germany [online] <URL: http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-77/05—Weir.pdf> [retrieved Aug. 6, 2009], 14 pages.
USPTO, First Action Interview Pilot Program Communication for U.S. Appl. No. 11/874,622, May 27, 2010, 27 pages.

Affiliated with

Also associated with

Rating

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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4201830