Cost-based query rewrite using materialized views

Details Cost-based query rewrite using materialized views Cost-based query rewrite using materialized views

2011-08-02

2011-08-02

Vy, Hung T (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S714000

Reexamination Certificate

active

07991765

ABSTRACT:
A system and method of rewriting a database query where the query contains an aggregate includes the following. If one or more aggregate materialized views are considered, rewriting the query using an aggregate materialized view. If one or more non-aggregate multi-table materialized views are considered, the query is rewritten using a multi-table materialized view. A join cost is determined for each such non-aggregate multi-table materialized view. If one or more non-aggregate single table materialized views are considered, the query is rewritten using the single table materialized view. A join cost is determined for each such non-aggregate single table materialized view. Finally, a current total cost is determined for use of various materialized views as a function of join cost, aggregation cost and spool cost to select a rewritten query.

REFERENCES:
patent: 6505188 (2003-01-01), Ghazal et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6618720 (2003-09-01), On Au et al.
patent: 6643636 (2003-11-01), Au et al.
patent: 6732096 (2004-05-01), Au
patent: 7676450 (2010-03-01), Ahmed et al.
patent: 7702627 (2010-04-01), Ahmed et al.
patent: 7809713 (2010-10-01), Su et al.
patent: 2007/0219951 (2007-09-01), Ahmed et al.
patent: 2008/0033914 (2008-02-01), Cherniack et al.

Affiliated with

Also associated with

Rating

Cost-based query rewrite using materialized views does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Cost-based query rewrite using materialized views, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Cost-based query rewrite using materialized views will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2643034