Query optimization using materialized views in database...

Details Query optimization using materialized views in database... Query optimization using materialized views in database...

2006-12-14

2009-10-20

Mizrahi, Diane (Department: 2617)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07606827

ABSTRACT:
Systems, methods and computer program products for optimization of query evaluation using materialized views in a database management system (DBMS) are described herein. During a pre-optimization phase, building blocks are generated that can be used to generate valid partial execution plans, where at least one of the building blocks can be a materialized view. During an enumeration phase, a plurality of execution plans for the query are generated using the building blocks. Some of the execution plans may include materialized views.

REFERENCES:
patent: 6356890 (2002-03-01), Agrawal et al.
patent: 7139783 (2006-11-01), Hinshaw et al.
patent: 2005/0125398 (2005-06-01), Das et al.
patent: 2006/0224564 (2006-10-01), Yu et al.
patent: 2008/0071785 (2008-03-01), Kabra et al.
A.Y.Halevy, “Answering Queries Using Views: A Survey,” Dept. of Computer Science and Engineering,The FLDB Journal, 10:270-294, 2001.

Affiliated with

Also associated with

Rating

Query optimization using materialized views in database... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query optimization using materialized views in database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query optimization using materialized views in database... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4134445