Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-04-19
2005-04-19
Mizrahi, Diane D. (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06882993
ABSTRACT:
A method is provided for incrementally refreshing a materialized view after multiple operations on a row of a base table of the materialized view, by determining an equivalent operation for the multiple operations and refreshing the materialized view according to the equivalent operation. The method is applicable to a materialized view based on multiple base tables on which multiple operations have been performed. The step of determining the equivalent operation can include identifying rows for which an earliest operation is a DELETE operation, or rows for which a latest operation is an INSERT operation, or a combination of the two. The step of refreshing the materialized view includes performing an inverse operation of the equivalent operation to determine a pre-update state of the row, and refreshing the materialized view based on the pre-update state. Additional embodiments are provided which enhance the performance of materialized view refresh queries.
REFERENCES:
patent: 5963959 (1999-10-01), Sun et al.
patent: 6496819 (2002-12-01), Bello et al.
patent: 6546402 (2003-04-01), Beyer et al.
patent: 6708179 (2004-03-01), Arora
patent: 6763352 (2004-07-01), Cochrane et al.
Jonathan Goldstein et al., Optimizing queries using materialized views: a practical solution, 2001, ACM Press Specia Interest Group on Management of Data, pp. 331-342.*
Satyanarayana R. Valluri et al., View relevance driven materialized view selection in data warehousing environment, 2002, Austrialian Computer Society, Inc. Darlinghurst, Australia, pp. 187-196.*
Oracle Corporation, “Create Materialized View” copyright 1996-2001, Oracle 9i Reference Release 1(9.0.1) Part #A90125-01, pp. 1-22).
Dageville Benoit
Gupta Abhinav
Lawande Shilpa
Henkhaus John D.
Hickman Palermo & Truong & Becker LLP
Mizrahi Diane D.
Oracle International Corporation
LandOfFree
Incremental refresh of materialized views with joins and... 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 refresh of materialized views with joins and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Incremental refresh of materialized views with joins and... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3439172