Auxiliary relation for materialized view

Details Auxiliary relation for materialized view Auxiliary relation for materialized view

2006-08-15

2006-08-15

Alam, Shahid (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07092951

ABSTRACT:
Auxiliary relations are used to maintain a materialized view. The materialized view comprises results of some operation performed between two or more base relations of a parallel database management system comprising a plurality of nodes. The two or more base relations are distributed to the nodes according to some partitioning strategy. Each auxiliary relation is partitioned according to the join attribute in the materialized view definition. During join or other operations involving the relations, the auxiliary relations, not the base relations, are used to construct join results and to maintain the materialized view.

REFERENCES:
patent: 5897632 (1999-04-01), Dar et al.
patent: 6026390 (2000-02-01), Ross et al.
patent: 6295533 (2001-09-01), Cohen
patent: 6339769 (2002-01-01), Cochrane et al.
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6353835 (2002-03-01), Lieuwen
patent: 6477534 (2002-11-01), Acharya et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6484159 (2002-11-01), Mumick et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6532470 (2003-03-01), Cochrane et al.
patent: 6594653 (2003-07-01), Colby et al.
patent: 6732107 (2004-05-01), Luo et al.
patent: 2003/0093407 (2003-05-01), Cochrane et al.
Segev et al., Maintaining materialized views in distributed databases, 1989, IEEE, 262-270.
Segev et al., Updating Distributed Materialized Views, 1989, IEEE, 173-184.
Dallan Quass et al., Making View Self-Maintainable for Data Warehousing, 1996, IEEE, 158-169.
J. Albrecht et al., Supporting Hot Spots with Materialized Views, 2000, Springer-Verlag, 47-56.
Wilburt J. Labio et al., “Physical Database Design 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

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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3665269