Reusing optimized query blocks in query processing

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 7246108
APP PUB NO 20060026115A1
SERIAL NO

10901272

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

Techniques for reusing optimized query blocks in query processing are provided. The techniques include checking a data structure to determine whether a previously-generated query block information record corresponding to an already-processed first inner query block exists in the data structure, where the already-processed first inner query block corresponds to the first inner query block in a first state in an already-processed form. If the previously-generated query block information record exists in the data structure, then query block information is established for the first inner query block in the first state based on the previously-generated query block information record. Then a cost is determined for a semantically equivalent query that includes the first inner query block in the first state based on the query block information for the first inner query block in the first state.

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 MAIL STOP 5OP7 REDWOOD SHORES CA 94065

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Ahmed, Rafi Fremont, CA 74 1716

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation