Patent Document ID: 7610272
Application ID: 10999744
Patent Status: 1

Claim One:
1. A computer-implemented method of improving a query of a relational database, the method comprising: providing a table T stored in the relational database, the table T having X number of columns and Y number of rows; generating a sampling column having Y cells, wherein each cell includes a sampling value for each of the Y rows in the table T, the sampling value, stored on a storage medium, representative of whether a query of the relational database will sample a corresponding one of the Y rows, the sample value of each of the Y rows comprising a first value when the row is not part of a sample, a second value when the row is part of a first sample, and a third value when the row is part of a second sample; appending the sampling column to the table T stored in the relational database, the table including the appended sampling column to enable the query; and providing, when a row is added to the table T, one of the first value, the second value, or the third value, to the row in the sampling column.