The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 12, 2016
Filed:
Sep. 14, 2012
Guilian Wang, San Diego, CA (US);
Olli Pekka Kostamaa, Santa Monica, CA (US);
Gary Allen Roberts, Carlsbad, CA (US);
Steven Cohen, Redondo Beach, CA (US);
John R. Catozzi, San Diego, CA (US);
Guilian Wang, San Diego, CA (US);
Olli Pekka Kostamaa, Santa Monica, CA (US);
Gary Allen Roberts, Carlsbad, CA (US);
Steven Cohen, Redondo Beach, CA (US);
John R. Catozzi, San Diego, CA (US);
Teradata US, Inc., Dayton, OH (US);
Abstract
A database system may implement compression management of tables in the database system. The compression management may include determination of a pattern of usage of various database tables in the database system. Based on this pattern of usage, the database tables may be selected as candidates for compression or decompression at the appropriate time. In one example, the pattern of usage may be based on the contents of a query log of the database system. The compression management may also include evaluation of various compression strategies to apply to a candidate database table. Each compression strategy may be evaluated to determine if application to a database table or a portion of the database table would be beneficial based on various conditions. The compression management may also include consideration of each available compression strategy to be applied solely or in combination with one another.