Incremental refresh of materialized views containing rank...

Details Incremental refresh of materialized views containing rank... Incremental refresh of materialized views containing rank...

2006-09-19

2006-09-19

Robinson, Greta (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07111020

ABSTRACT:
Techniques are provided for improving efficiency of database systems, and in particular, to refreshing materialized views maintained by database systems and rewriting queries to access the materialized views. According to the approaches, a ranked materialized view is incrementally refreshed, and during the incremental refresh operation, rows in the partitions of the materialized view are ranked within the partitions.

REFERENCES:
patent: 5963959 (1999-10-01), Sun et al.
patent: 6125360 (2000-09-01), Witkowski et al.
patent: 6134543 (2000-10-01), Witkowski et al.
patent: 6272502 (2001-08-01), Lieuwen et al.
patent: 6477525 (2002-11-01), Bello 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.
patent: 6882993 (2005-04-01), Lawande et al.
patent: 7007006 (2006-02-01), Zilio et al.
Kuno et al., Incremental Maintenance of Materialized Object-Oriented Views in MultiView: Strategies and Performance Evaluation, Knowledge and Data Engineering, IEEE Transactions on, vol. 10, Issue 5, Sep.-Oct. 1998, pp. 768-792.
Oracle Corporation, “Create Materialized View,” copyright 1996-2001, Oracle9i SQL Reference, Release 1(9.0.1), Part #A90125-01, pp. 1-22.
Goldstein, Jonathan et al., “Optimizing Queries Using Materialized Views: A Practical, Scalable Solution,” (2001)ACM Press Special Interest Group on Management of Data, pp. 331-342.
Valluri, Satyanarayana, R. et al., “View Relevance Driven Materialized View Section in Data Warehousing Environment” (2002),Australian Computer Society, Inc.Darlinghurst , Australia, pp. 187-196.
Harumi A. Kuno and Elke A. Rundensteiner (1996), Using Object-Oriented Principles to Optimize Update Propagation to Materialized Views, pp. 310-317.

Affiliated with

Also associated with

Rating

Incremental refresh of materialized views containing rank... 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 containing rank..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Incremental refresh of materialized views containing rank... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3528676