Exploitation of subsumption in optimizing scalar subqueries

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 6339768
SERIAL NO

09133335

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

An optimization technique for SQL queries. A query is analyzed to determine whether it includes one or more scalar subqueries and one or more existential subqueries. The scalar subqueries and the existential subqueries are transformed into join operations using subsumption, and the join operations are merged into a single join query block. The join query block can then be executed in the computer to efficiently retrieve data from the relational database.

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

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
INTERNATIONAL BUSINESS MACHINES CORPORATIONNEW ORCHARD ROAD ARMONK NY 10504

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Leung, Ting Yu San Jose, CA 29 1441
Pirahesh, Mir Hamid San Jose, CA 63 3893

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation