Multiple column order preserving compression
View Patent ↗Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: performing order preserving compression of a multiple column index table of a database to provide an encoded index table sorted by an initial column, wherein the multiple column index table includes the initial column and one or more subsequent column; and determining, in dependence on a result of the performing the order preserving compression, at least one modification factor for respective ones of the one or more subsequent column.
1. A computer implemented method comprising:
performing order preserving compression of a multiple column index table of a database to provide an encoded index table sorted by an initial column, wherein the multiple column index table includes the initial column and one or more subsequent column;
determining, in dependence on a result of the performing the order preserving compression, at least one modification factor for respective ones of the one or more subsequent column;
storing the at least one modification factor to the database;
receiving a query;
examining the query and determining, based on the examining, that the query references a subsequent column of the one or more subsequent column;
responsively to the determining that the query references the subsequent column, retrieving from the database a modification factor for the subsequent column; and
processing the query with use of the modification factor for the subsequent column.
2. The computer implemented method of claim 1 , wherein the determining, in dependence on a result of the performing the order preserving compression, at least one modification factor for respective ones of the one or more subsequent column includes transforming a row of the multiple column index table, wherein the transforming includes zeroing out bits of the row.
3. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes zeroing out bits of the query.
4. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes transforming bits of the query into ones.
5. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes multiplying a row of the encoded index table by the modification factor for the subsequent column.
6. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes comparing a row of the encoded index table to the query.
7. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes comparing a row of the encoded index table to the query, wherein the comparing includes transforming the row of the encoded index table using the modification factor for the subsequent column, and further transforming the query.
8. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes comparing a row of the encoded index table to the query, wherein the comparing includes transforming the row of the encoded index table using the modification factor for the subsequent column to output a transformed row, and further transforming the query to output expressions for minimum and maximum bounds for the query, and wherein the comparing includes flagging the row as a matched pointed to row when the transformed row is within the minimum and maximum bounds.
9. The computer implemented method of claim 1 , wherein the processing the query with use of the modification factor for the subsequent column includes comparing a row of the encoded index table to the query, wherein the comparing includes transforming the row of the encoded index table using the modification factor for the subsequent column to output a transformed row, and further transforming the query to output expressions for minimum and maximum bounds for the query, and wherein the comparing includes flagging the row as a matched pointed to row when the transformed row is within the minimum and maximum bounds, and wherein the method further includes accessing underlying leaf page stored table data of the database using a row ID of the row responsively to the flagging.
10. The computer implemented method of claim 1 , wherein subsequent column of the one or more subsequent column is a second column of the multiple column index table.
11. The computer implemented method of claim 1 , wherein subsequent column of the one or more subsequent column is an nth column of the multiple column index table.
12. The computer implemented method of claim 1 , wherein storage of modification factors including the at least one modification factor is optimized by providing a common factor for all rows.
13. The computer implemented method of claim 1 , wherein storage of modification factors including the at least one modification factor is optimized by truncating a precision of the modification factor to as many bits as is needed to achieve query execution.
14. A system comprising:
a memory;
at least one processor in communication with the memory; and
program instructions executable by one or more processor via the memory to perform a method comprising:
performing order preserving compression of a multiple column index table of a database to provide an encoded index table sorted by an initial column, wherein the multiple column index table includes the initial column and one or more subsequent column;
determining, in dependence on a result of the performing the order preserving compression, at least one modification factor for respective ones of the one or more subsequent column;
storing the at least one modification factor to the database;
receiving a query;
examining the query and determining, based on the examining, that the query references a subsequent column of the one or more subsequent column;
responsively to the determining that the query references the subsequent column, retrieving from the database a modification factor for the subsequent column; and
processing the query with use of the modification factor for the subsequent column.
15. The system of claim 14 , wherein the determining, in dependence on a result of the performing the order preserving compression, at least one modification factor for respective ones of the one or more subsequent column includes transforming a row of the multiple column index table, wherein the transforming includes zeroing out bits of the row.
16. The system of claim 14 , wherein the processing the query with use of the modification factor for the subsequent column includes zeroing out bits of the query.
17. The system of claim 14 , wherein the processing the query with use of the modification factor for the subsequent column includes transforming bits of the query into ones.
18. The system of claim 14 , wherein the processing the query with use of the modification factor for the subsequent column includes multiplying a row of the encoded index table by the modification factor for the subsequent column.
19. The system of claim 14 , wherein the processing the query with use of the modification factor for the subsequent column includes comparing a row of the encoded index table to the query.
20. A computer program product comprising:
a computer readable storage medium readable by one or more processing circuit and storing instructions for execution by one or more processor for performing a method comprising:
performing order preserving compression of a multiple column index table of a database to provide an encoded index table sorted by an initial column, wherein the multiple column index table includes the initial column and one or more subsequent column;
determining, in dependence on a result of the performing the order preserving compression, at least one modification factor for respective ones of the one or more subsequent column;
storing the at least one modification factor to the database;
receiving a query;
examining the query and determining, based on the examining, that the query references a subsequent column of the one or more subsequent column;
responsively to the determining that the query references the subsequent column, retrieving from the database a modification factor for the subsequent column; and
processing the query with use of the modification factor for the subsequent column.