Patent ID: 8886614
Filing Date: 2014-11-11
Classification: G06F

Abstract:
1. A method of executing a join plan that creates an intermediate table from two or more database tables within a database, the method comprising: identifying, by a processing module of a computer system, at least one projected and compressible column within one of the database tables to be joined by the join plan, the column containing data values to which the application of a compression data transformation results in a reduction in the size of the data values, wherein the database tables are stored on at least one data storage facility; identifying, by the processing module, a frequency of occurrences of at least some unique values in the compressible column; joining, by the processing module, the two or more database tables; and storing, by the processing module, results of the join in the intermediate table such that the compression data transformation is applied to at least some of the unique values in the compressible column for which the frequency has been identified.