Inline view query rewrite using a materialized view

Details Inline view query rewrite using a materialized view Inline view query rewrite using a materialized view

2007-07-12

2010-12-14

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C711S101000

Reexamination Certificate

active

07853604

ABSTRACT:
A method allows a query, which contains an inline view, to be rewritten to use a materialized view. The materialized view has an inline view that is equivalent to the inline view of the query. However, the inline view of the materialized view varies textually from the inline view of the query.

REFERENCES:
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6199063 (2001-03-01), Colby et al.
patent: 6334128 (2001-12-01), Norcott et al.
patent: 6449606 (2002-09-01), Witkowski
patent: 6526403 (2003-02-01), Lin et al.
patent: 6629094 (2003-09-01), Colby et al.
patent: 7599925 (2009-10-01), Larson et al.
patent: 2004/0122814 (2004-06-01), Zhang et al.
patent: 2006/0122964 (2006-06-01), Yu et al.
patent: 2006/0230017 (2006-10-01), Larson et al.
patent: 2006/0271529 (2006-11-01), Dhamija et al.
patent: 2009/0228432 (2009-09-01), Thiyagarajan et al.
Randall G. Bello et al., “Materialized Views in Oracle,” Proceedings of the 24thVLDB Conference, New York, USA, 1998, pp. 659-664.
Dr. Lilian Hobbs, “Oracle Materialized View & Query Rewrite,” May 2005, pp. 1-25.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4156366