Patent ID: 9152683
Filing Date: 2015-10-06
Classification: G06F

Abstract:
1. A computer implemented method of managing access to rows of a database table, the method comprising: receiving a database query from a database client, the database query comprising a command to search for rows of the database table containing a given value in a given column, wherein the rows of the database table are stored in a first data table on a first storage media and a second data table on a second storage media, wherein the first storage media has a lower access speed than the second storage media; determining whether a value-existence structure contains the given value, the value-existence structure comprising a list of distinct values in the given column stored in the first data table, upon determining the value-existence structure contains the given value retrieving from the first data table the rows containing the given value and transmitting the rows of the first data table to the database client; and retrieving from the second data table any rows containing the given value in the given column and transmitting any retrieved rows of the second data table to the database client.