Dynamic partial uncompression of a database table

An apparatus comprising:

• at least one processor;
• a memory coupled to the at least one processor;
• a database table residing in the memory that includes at least one portion that is compressed and at least one portion that is uncompressed;
• an uncompression mechanism residing in the memory and executed by the at least one processor that performs the steps of:
• executing a query to the database table;
• determining a first portion of the database table is a first compressed portion that satisfies the query;
• determining whether the query includes a parameter that specifies to skip compressed portions;
• in response to determining the query does not include the parameter that specifies to skip the compressed portions, uncompressing the first compressed portion in response to the first compressed portion satisfies the query;
• a display mechanism residing in the memory and executed by the at least one processor that performs the steps of:
• displaying a result set for the query;
• in response to the result set for the query includes compressed data, performing the steps of:
• in response to the query includes the parameter that specifies to skip compressed portions, not including the first compressed portion in the displayed result set;
• and
• in response to the query does not include the parameter that specifies to skip compressed portions, including the uncompressed first portion in the displayed result set.

An article of manufacture comprising:

• an uncompression mechanism that determines a first portion of a database table is a first compressed portion that satisfies a query to the database table that includes the first compressed portion and at least one uncompressed portion, determines whether the query includes a parameter that specifies to skip compressed portions, and in response to determining the query includes the parameter that specifies to skip compressed portions, displaying a first result set for the query that does not include the first compressed portion, and in response to determining the query does not include the parameter that specifies to skip compressed portions, uncompressing the first compressed portion and displaying a second result set for the query that includes the uncompressed first portion;
• a display mechanism that displays a result set that includes compressed data and determines when and how to display the compressed data in the result set;
• and
• non-transitory computer-readable media bearing the uncompression mechanism.