×

Encoded-vector indices for decision support and warehousing

  • US 5,706,495 A
  • Filed: 05/07/1996
  • Issued: 01/06/1998
  • Est. Priority Date: 05/07/1996
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method of optimizing an SQL query in a computer having a memory, the SQL query being performed by the computer to retrieve data from a relational database stored in the memory, the relational database comprising one or more tables of data, each of the tables comprising one or more intersecting rows and columns of data, the method comprising the steps of:

  • (a) storing a vectorized index in the memory of the computer for values in one or more of the columns of a particular table in the relational database, wherein the vectorized index comprises a plurality of positions, and 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; and

    (b) performing the query in the memory of the computer using the stored vectorized index.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×