Patent ID: 8126900
Filing Date: 2012-02-28
Classification: G06F

Abstract:
1. A method for use in a database system, comprising: receiving a transaction that selects values of a column of a first table based on one or more conditions, the column in the first table being according to a first data type, wherein the first table is stored in a storage subsystem of the database system, wherein the received transaction specifies an enumerated list of values to select the values of the column of the first table; in response to the one or more conditions of the received transaction, transforming the first data type to a second, different data type; storing the selected values of the column according to the second data type in a second table that is stored in the storage subsystem; determining a domain of the selected values of the column based on the one or more conditions of the received transaction; selecting the second data type based on the domain of the selected values of the column, wherein the second data type has a smaller storage requirement than the first data type; and compressing the selected values of the column in the second table, wherein compressing the selected values of the column in the second table comprises performing value list compression of the column in the second table based on the enumerated list.