Query rewrite with a remote object

Details Query rewrite with a remote object Query rewrite with a remote object

2011-03-01

2011-03-01

Kim, Charles (Department: 2161)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C026S003000

Reexamination Certificate

active

07899839

ABSTRACT:
A query statement, issued to a local database server, is re-written. The query references at least one of a first or a second object. The first object is remote with respect to the local database server, for accessing a first materialized view that is local or remote with respect to the local database server. The second object is local with respect to the local database server, to access a second materialized view that is remote with respect to the local database server. Rewriting the query can include dynamically tracking a staleness state associated with one or more of the materialized views.

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: 2005/0210010 (2005-09-01), Larson 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.
Praveen Kumar and Murali Thiyagarajan, “Supporting Aggregate Expressions in Query Rewrite,” pp. 1-18.
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

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2723427