Expression replacement in virtual columns

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 8046352
APP PUB NO 20090150366A1
SERIAL NO

11951918

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

Techniques are described herein for replacing a part of an expression in a query to a database with a virtual column. A virtual column is defined by the database to contain results of a defining expression. A part of an expression in a query is replaced with a virtual column whose defining expression is equal to the part of the expression in the query. The part of an expression in a query can be the entire expression. When an expression in a query can be replaced with more than one replacement expression involving virtual columns, the replacement expression with the least cost of query processing is selected.

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 M/S 50P7 REDWOOD SHORES CA 94065

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Basu, Subhransu Fremont, US 14 230
Bedi, Harmeek Singh Redwood City, US 11 240

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation