Rewriting a query to use a set of materialized views and...

Details Rewriting a query to use a set of materialized views and... Rewriting a query to use a set of materialized views and...

2003-01-07

2008-10-21

Mizrahi, Diane D. (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07440963

ABSTRACT:
An approach for processing a query in a database system is disclosed. An original query is determined to be partially satisfied by a materialized view. The original query is transformed using a set operation (i.e., union and intersection) on the materialized view and either another materialized view or a base table.

REFERENCES:
patent: 6618719 (2003-09-01), Andrei
patent: 6850933 (2005-02-01), Larson et al.
patent: 2002/0120598 (2002-08-01), Shadmon et al.
Nathan Folkert et al., Optimizing refresh of a set of materialized views Aug. 2005, ACM NY NY, pp. 1043-1054.
Chang-Sup Park, Myoung Ho Kim, Yoon-Joon Lee; Rewriting OLAP Queries Using Materialized Views and Dimension Hierarchies in Data Warehouses; 2001 IEEE; pp. 515-523.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4000813