Encoded-vector indices for decision support and warehousing

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 5706495
SERIAL NO

08643998

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A method, apparatus, and article of manufacture for optimizing SQL queries in a relational database management system using a vectorized index. The vectorized index represents values in one or more of the columns of a particular table in the relational database. The vectorized index is comprised of a plurality of positions, wherein each of the positions comprises a linear array that represents a value for the specified columns in a corresponding row of the particular table in the relational database. To use the vectorized index, SQL operations are converted to a series of bit-vector operations on that index, where the result of the bit-vector operations is a list of row positions in the table.

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
Chadha, Atul Milpitas, CA 10 572
Goel, Piyush Monte Sereno, CA 27 904
Gupta, Ashish Saratoga, CA 293 4635
Harinarayan, Venkatesh Stanford, CA 6 328
Iyer, Balakrishna Raghavendra San Jose, CA 44 3771

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation