Efficient update methods for large volume data updates in...

Details Efficient update methods for large volume data updates in... Efficient update methods for large volume data updates in...

2008-01-22

2011-11-08

Hwa, Shyue Jiunn (Department: 2163)

Data processing: database and file management or data structures

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

C707S705000, C707SE17009, C707SE17045

Reexamination Certificate

active

08055609

ABSTRACT:
A system and method for ensuring large and frequent updates to a data warehouse. The process leverages a set of temporary staging tables to track the updates. A set of intermediate steps are performed to accomplish bulk deletions of the outdated changed records, and perform modifications to the map tables for models such as snowflake. Finally, bulk load operations load the updates and insert them into the final dimension tables. The process ensures performance comparable to insertion-only schemes with at most only slight performance degradation. Furthermore, a modified process is applied on the newfact data warehouse dimension model. The process can be readily adapted to handle star schema and other hierarchical data warehouse models.

REFERENCES:
patent: 6167405 (2000-12-01), Rosensteel, Jr. et al.
patent: 6438538 (2002-08-01), Goldring
patent: 6665654 (2003-12-01), Broden et al.
patent: 7739224 (2010-06-01), Weissman et al.
patent: 2003/0009295 (2003-01-01), Markowitz et al.
patent: 2004/0205727 (2004-10-01), Sit et al.
patent: 2005/0261933 (2005-11-01), Magnuson
patent: 2007/0036076 (2007-02-01), Boggs
patent: 2007/0239769 (2007-10-01), Fazal et al.
patent: 2007/0244736 (2007-10-01), Johnson
patent: 2008/0086446 (2008-04-01), Zhang et al.
Ester et al., “Incremental Clustering for Mining in a Data Warehousing Environment”, Proc. of 24thVLDB Conf., New York , 1998.
Kotidis et al., “DynaMat: A dynamic View Management System for Data Warehouses”, SIGMOD '99 Philadelphia, PA, pp. 371-382.
Riedewald et al., “Efficient Integration and Aggregation of Historical Information”, ACM SIGMOD 2002, Jun. 4-6, 2002, pp. 13-24.
Lau et al., “An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse” VLDB '06, Sep. 12-15, Seoul, Korea. pp. 703-714.

Affiliated with

Also associated with

Rating

Efficient update methods for large volume data updates in... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Efficient update methods for large volume data updates in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Efficient update methods for large volume data updates in... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4309662