DATABASE-TRANSPARENT NEAR ONLINE ARCHIVING AND RETRIEVAL OF DATA
First Claim
Patent Images
1. A computer implemented method of managing access to a first data table, the method comprising:
- receiving a database query from a database client, the database query comprising a command to search for one or more matching rows containing a given value in a given column;
verifying if a value-existence structure contains the given value, the value-existence structure comprising a list of distinct values stored in the first data table, wherein each distinct value in the value-existence structure is associated with a respective indicator identifying the column of the first data table in which the distinct value is stored; and
upon determining the value-existence structure contains the given value and the respective indicator indicates that the given value is stored in the given column, retrieving from the first data table the matching rows containing the given value in the given column, and transmitting the matching rows of the first data table to the database client.
1 Assignment
0 Petitions
Accused Products
Abstract
Method, program products and apparatus are disclosed for optimizing access to a data table. A value-existence structure is used to determine whether the data table contains rows for a given database query. The value-existence structure may be useful, for example, for managing transparent access to an online database and a nearline database.
-
Citations
21 Claims
-
1. A computer implemented method of managing access to a first data table, the method comprising:
-
receiving a database query from a database client, the database query comprising a command to search for one or more matching rows containing a given value in a given column; verifying if a value-existence structure contains the given value, the value-existence structure comprising a list of distinct values stored in the first data table, wherein each distinct value in the value-existence structure is associated with a respective indicator identifying the column of the first data table in which the distinct value is stored; and upon determining the value-existence structure contains the given value and the respective indicator indicates that the given value is stored in the given column, retrieving from the first data table the matching rows containing the given value in the given column, and transmitting the matching rows of the first data table to the database client. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer readable storage medium storing a program, which, when executed on a processor, performs an operation for managing access to a first data table, the operation comprising:
-
receiving a database query from a database client, the database query comprising a command to search for one or more matching rows containing a given value in a given column; verifying if a value-existence structure contains the given value, the value-existence structure comprising a list of distinct values stored in the first data table, wherein each distinct value in the value-existence structure is associated with a respective indicator identifying the column of the first data table in which the distinct value is stored; and upon determining the value-existence structure contains the given value and the respective indicator indicates that the given value is stored in the given column, retrieve from the first data table the matching rows containing the given value in the given column, and transmitting the matching rows of the first data table to the database client. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system, comprising:
-
a processor; and a memory storing a database management system tool for managing access to a first data table, which when executed on the processor is configured to perform an operation, comprising; receiving a database query from a database client, the database query comprising a command to search for one or more matching rows containing a given value in a given column, verifying if a value-existence structure contains the given value, the value-existence structure comprising a list of distinct values stored in the first data table, wherein each distinct value in the value-existence structure is associated with a respective indicator identifying the column of the first data table in which the distinct value is stored, and upon determining the value-existence structure contains the given value and the respective indicator indicates that the given value is stored in the given column, retrieving from the first data table the matching rows containing the given value in the given column, and transmitting the matching rows of the first data table to the database client. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification