Determining materialized view coverage

Details Determining materialized view coverage Determining materialized view coverage

2005-03-08

2005-03-08

Mizrahi, Diane D. (Department: 2175)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

06865569

ABSTRACT:
A method and apparatus determines (1) if a materialized view can be used to respond to a query for data stored in one or more base tables of a database system; and/or (2) if the materialized view needs to be updated in response to an update query. A query expression tree represents the query, and a materialized view expression tree represents the materialized view. The components of the query expression tree are compared with components of the materialized view expression tree to determine if the materialized view covers the query that is, the tuples in the result of the query expression are a subset of the tuples in the result of the materialized view expression.

REFERENCES:
patent: 6026390 (2000-02-01), Ross et al.
patent: 6493699 (2002-12-01), Colby et al.
Wilburt J. Labio et al., “Physical Database Designs for Data Warehouses,” ICDE, pp. 277-288 (1997).
Dallan Quass et al., “Making Views Self-Maintainable for Data Warehousing,” PDIS, pp. 158-169 (1996).
Dallan Quass et al., “On-Line Warehouse View Maintenance,” SIGMOD, pp. 393-404 (1997).
D. Agrawal et al., “Efficient View Maintenance at Data Warehouses,” pp. 417-427 (1997).
Yue Zhuge et al., “The Strobe Algorithms for Multi-Souce Warehouse Consistency,” pp. 146-157 (1996).
Patrick Valduriez, “Join Indices,” ACM Transactions on Databae Systems, vol. 12, No. 2, pp. 218-246 (Jun. 1987).
Jennifer Widom, “Research Problems in DAta Warehousing,” CIKM, pp. 25-30 (1995).
Richard Winter, “B2B Active Warehousing: Data on Demand,” Teradata Review Fall 2000, pp. 1-5, printed from http://www.teradatamagazine.com (2000).
Nick Roussopoulos, “Materialized Views and Data Warehouses,” SIGMOD Record 27(1), pp. 21-26 (1998).
Kenneth A. Ross et al., “Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time,” SIGMOD, pp. 447-458 (1996).
TPC Benchmark™R, Standard Specification Revision 2.1.0, pp. 1-144 (1993).
Jose A. Blakeley et al., “Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates,” ACM Transactions on Database Systems, vol. 14, No. 3, pp. 369-400 (Sep. 1989).
Surajit Chaudhuri et al., “An Overview of Data Warehousing and OLAP Technology,” SIGMOD Record 26(1), pp. 65-74 (1997).
Latha S. Colby et al., “Supporting Multiple View Maintenance Policies,” SIGMOD, pp. 405-416 (1997).
Venky Harinarayan et al., “Implementing Data Cubes Efficiently,” SIGMOD, pp. 205-216 (1996).
H.V. Jagadish et al, “View Maintenance Issues for the Chronicle Data Model,” PODS, pp. 113-124 (1995).

Affiliated with

Also associated with

Rating

Determining materialized view coverage does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3443787