US 8,943,028 B2Granted

Database compression analyzer

AssigneeTeradata US, Inc.

InventorsCongnan Luo, Like Gao, Yu Long, Judy Wu, Michael Leon Reed

Life of this patent

Estimating the term…

Loading patent…

Abstract

Apparatus, systems, and methods may operate to receive requests to execute a plurality of compression and/or decompression mechanisms on one or more database objects; to execute each of the compression and/or decompression mechanisms, on a sampled basis, on the database objects; to determine comparative performance characteristics associated with each of the compression and/or decompression mechanisms; and to record at least some of the performance characteristics and/or derivative characteristics derived from the performance characteristics in a performance summary table. The table may be published to a storage medium or a display screen. Other apparatus, systems, and methods are disclosed.

Claims20

Dependent claims

An apparatus, comprising:

a processor;
a data acquisition module executable by the processor to receive a single request to execute, on a sampled basis, a plurality of compression and/or decompression mechanisms on at least one database object;
and
a processing module executable by the processor to:
execute each of the compression and/or decompression mechanisms, on the sampled basis, on the at least one database object;
determine comparative performance characteristics associated with each of the compression and/or decompression mechanisms;
determine derivative characteristics associated with each of the compression and/or decompression mechanisms based on the comparative performance characteristics, wherein the derivative characteristics include normalization of processing characteristics of at least one candidate system configured to perform the compression and/or decompression mechanisms, wherein the normalization of processing techniques of the candidate system is relative to other systems configured to perform the plurality of compression and/or decompression mechanisms;
and
record at least some of the comparative performance characteristics and/or derivative characteristics in a performance summary table to be published to at least one of a tangible storage medium or a display screen.

6 more elements

A processor-implemented method to execute on one or more processors that perform the method, comprising:

receiving, with the one or more processors, a single request to execute, on a sampled basis, a plurality of compression and/or decompression mechanisms on at least one database object;
executing, with the one or more processors, each of the compression and/or decompression mechanisms, on the sampled basis, on the at least one database object;
determining, with the one or more processors, comparative performance characteristics associated with each of the compression and/or decompression mechanisms;
determining, with the one or more processors, derivative characteristics associated with each of the compression and/or decompression mechanisms based on the comparative performance characteristics, wherein the derivative characteristics include normalization of processing characteristics of at least one candidate system configured to perform the compression and/or decompression mechanisms, wherein the normalization of processing characteristics of the candidate system is relative to other systems configured to perform the plurality of compression and/or decompression mechanisms;
recording, with the one or more processors, at least some of the comparative performance characteristics and/or derivative characteristics in a performance summary table to be published to at least one of a tangible storage medium or a display screen;
and
selecting, with the one or more processors, a compression and/or decompression mechanism to perform compression and/or decompression of the at least one database object based on at least one of the determined comparative performance characteristics and the determined derivative characteristics.

4 more elements

A processor-implemented method to execute on one or more processors that perform the method, comprising:

receiving, with the one or more processors, a single request to execute, on a sampled basis, a plurality of compression and/or decompression mechanisms on at least one database object;
executing, with the one or more processors, each of the compression and/or decompression mechanisms, on the sampled basis, on the at least one database object;
determining, with the one or more processors, comparative performance characteristics associated with each of the compression and/or decompression mechanisms;
determining, with the one or more processors, derivative characteristics associated with each of the compression and/or decompression mechanisms based on the comparative performance characteristics, wherein the derivative characteristics include normalization of processing characteristics of at least one candidate system configured to perform the compression and/or decompression mechanisms, wherein the normalization of processing techniques of the candidate system is relative to other systems configured to perform the plurality of compression and/or decompression mechanisms;
and
recording, with the one or more processors, the derivative characteristics in a performance summary table to be published to at least one of a tangible storage medium or a display screen.

3 more elements

Dependencies are inferred from the claim text.