US Patent 7899839 Query rewrite with a remote object

Patent 7899839 was granted and assigned to Oracle on March, 2011 by the United States Patent and Trademark Office.

Overview Structured Data Issues Contributors Activity

Is a

Patent

Patent attributes

Current Assignee

Oracle

Patent Jurisdiction

United States Patent and Trademark Office

Patent Number

7899839

Date of Patent

March 1, 2011

Patent Application Number

11777231

Date Filed

July 12, 2007

Patent Primary Examiner

Charles Kim

Patent 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.