Dynamic partial uncompression of a database table

摘要

A database dynamic partial uncompression mechanism determines when to dynamically uncompress one or more compressed portions of a database table that also includes uncompressed portions. A query may include an express term that specifies whether or not to skip compressed portions. In addition, a query may include associated information that specifies whether or not to skip compressed portions, and one or more thresholds that may be used to determine if the system is too busy to perform uncompression. A display mechanism may also determine whether or not to display compressed portions. The uncompression may occur at the database server or at a client. The database dynamic partial uncompression mechanism thus performs dynamic uncompression in a way that preferably uncompresses one or more compressed portions of a partially compressed database table only when the compressed portions satisfy a query and/or need to be displayed.

主权项

1. A computer-implemented method for processing a query to a database table that includes at least one portion that is compressed and at least one portion that is uncompressed, the method comprising the steps of:
(A) determining which portions of the database table satisfy the query; (B) determining whether utilization of a processor executing the query exceeds a predetermined threshold; (C) determining whether utilization of memory exceeds a predetermined threshold; (D) determining whether IO count exceeds a predetermined threshold; (E) determining whether the query includes a parameter that specifies to skip compressed portions; (F) determining whether stored data relating to the query indicates to skip compressed portions; (G) if any of (B), (C), (D), (E) and (F) are true, displaying a result set for the query that does not include the compressed portions; and (H) if all of (B), (C), (D), (E) and (F) are false, displaying a result set for the query that includes uncompressed information corresponding to the compressed portions, wherein the uncompressed information is generated on a client computer system coupled to a database server that includes the database table.