Immediate maintenance of materialized views

Details Immediate maintenance of materialized views Immediate maintenance of materialized views

2008-12-19

2011-11-22

Mofiz, Apu (Department: 2161)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

C707S610000, C707S690000, C707S736000, C709S248000

Reexamination Certificate

active

08065269

ABSTRACT:
A system, method, and computer program product are provided for immediately updating a materialized view in a relational database management system. The method includes the steps of creating a materialized view defined over a base table, executing an update statement on the base table, computing a delta of the base table by comparing images of the base table before execution of the update statement and after execution of the update statement, computing a delta of the materialized view based on the delta of the base table, and updating the materialized view using the delta of the materialized view.

REFERENCES:
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6134543 (2000-10-01), Witkowski et al.
patent: 6353828 (2002-03-01), Ganesh et al.
patent: 6484159 (2002-11-01), Mumick et al.
patent: 6546402 (2003-04-01), Beyer et al.
patent: 6708179 (2004-03-01), Arora
patent: 6882993 (2005-04-01), Lawande et al.
patent: 7020649 (2006-03-01), Cochrane et al.
patent: 7111020 (2006-09-01), Gupta et al.
patent: 7467128 (2008-12-01), Larson et al.
patent: 7734602 (2010-06-01), Folkert et al.
patent: 7822712 (2010-10-01), Robinson et al.
patent: 7895186 (2011-02-01), Yu
Hanov et al, “Refactoring MySQL to Support Materialized Views”, University of Waterloo, 2008.
Yeung et al, “Multiagent Immediate Incremental View Maintenance for Data Warehouses”, IEEE Transactions on Systems, vol. 35, No. 2, Mar. 2005.

Affiliated with

Also associated with

Rating

Immediate maintenance of materialized views does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Immediate maintenance of materialized views, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Immediate maintenance of materialized views will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4309824