Method and apparatus for using incompatible types of indexes to process a single query

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 6144957
SERIAL NO

09311181

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A method and apparatus for processing a query combines the use of different index types to minimize the rows of data that need to be retrieved from a table. A first index is accessed based on a query to produce a first result having a first format, for example a bitmap index outputting a bitmap. A second index, for example a B-tree index, is also accessed based on the query to produce a second result having a second format, for example a sequence of rowids. The first result is converted to a converted result having the second format, and the converted result and the second result are combined to obtain an end result. The end result can then be used to locate data that satisfies the query while minimizing the rows of data that need to be retrieved from a table during the query processing.

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

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • ORACLE INTERNATIONAL CORPORATION

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Cohen, Jeffrey Ira Sunnyvale, CA 25 472
Depledge, Michael San Jose, CA 18 947
Jakobsson, Hakan San Francisco, CA 33 1266
Ozbutun, Cetin San Carlos, CA 33 1417

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation