Accessing data from asynchronously maintained index

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 7814117
APP PUB NO 20080249990A1
SERIAL NO

11784341

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A method and apparatus for computing queries in a way that is consistent with an index and the underlying base table is provided. A query is computed such that it is consistent with the state of an index and base table as of the last point at which the index and table were synchronized. For example, if an index is maintained asynchronously then it is not necessarily consistent with its base table when a query is to be run against the table and the index. Therefore, the query is computed such that it will be consistent with the last point at which the index and the table were synchronized. In one embodiment, a System Change Number (SCN) of the last successful synchronization operation is used to perform a flashback query on the table.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
ORACLE INTERNATIONAL CORPORATION500 ORACLE PARKWAY REDWOOD CITY CA 94065

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Agarwal, Nipun Santa Clara, US 310 5233
Baby, Thomas Foster City, US 50 805
Chandrasekar, Sivasankaran Palo Alto, US 68 1865

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation