Compression analyzer

• US 9,559,720 B2
• Filed: 09/28/2012
• Issued: 01/31/2017
• Est. Priority Date: 04/30/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kemp, Jesse, Macnicol, Roger, Marwah, Vineet, Kapoor, Vikram, Ganesh, Amit, Kulkarni, Sachin, Shergill, Kam, Bhattacharyya, Manosiz
• Primary Examiner(s): Ahn, Sangwoo
• Application Number:
  US13/631,575
• Publication Number:
  US 20130036101A1
• Time in Patent Office: 1,586 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: H03M 7/30 Compression speech analysis-synthesis for redundancy reduction G10L19/00; for image communication H04N; Expansion; Suppression of unnecessary data, e.g. redundancy reduction

Abstract

Techniques are described herein for automatically selecting the compression techniques to be used on tabular data. A compression analyzer gives users high-level control over the selection process without requiring the user to know details about the specific compression techniques that are available to the compression analyzer. Users are able to specify, for a given set of data, a “balance point” along the spectrum between “maximum performance” and “maximum compression”. The point thus selected is used by the compression analyzer in a variety of ways. For example, in one embodiment, the compression analyzer uses the user-specified balance point to determine which of the available compression techniques qualify as “candidate techniques” for the given set of data. The compression analyzer selects the compression technique to use on a set of data by actually testing the candidate compression techniques against samples from the set of data. After testing the candidate compression techniques against the samples, the resulting compression ratios are compared. The compression technique to use on the set of data is then selected based, in part, on the compression ratios achieved during the compression tests performed on the sample data.

Claims

1. A method comprising:

prior to storing a set of data in a table, performing the steps of;

obtaining data that indicates a selected balance point along a spectrum between maximum performance and maximum compression;

wherein the selected balance point is one of a plurality of user-selectable balance points along the spectrum between maximum performance and maximum compression;

wherein the plurality of user-selectable balance points include at least one balance point that corresponds to neither maximum performance nor maximum compression;

performing a plurality of tests on a subset of data from the set of data to determine compression ratios produced by applying each of a plurality of compression techniques to the subset of data;

wherein the table has a plurality of columns;

wherein the set of data includes a plurality of rows;

wherein, in a first test of the plurality of tests, the plurality of rows are not sorted;

wherein, in a second test of the plurality of tests, the plurality of rows are sorted based on a particular column of the plurality of columns;

selecting a particular compression technique to apply to the set of data based, at least in part, on;

the compression ratios produced by each of the plurality of compression techniques; and

the selected balance point;

compressing the set of data using the particular compression technique to produce compressed data; and

storing the compressed data in the table;

wherein the method is performed by one or more computing devices.

2. The method of claim 1 wherein the step of obtaining data includes receiving user input that selects the selected balance point.

3. The method of claim 1 further comprising determining how many sorting options to test based, at least in part, on the selected balance point, wherein each sorting option of the sorting options specifies a column to sort the set of data in the table before performing the plurality of tests.

4. The method of claim 1 further comprising:

determining to use phase-group representatives during said testing based, at least in part, on the selected balance point;

during said testing, applying a first compression technique specified in a first phase group as being representative of the first phase group; and

during said testing, applying a second compression technique specified in a second phase group as being representative of the second phase group.

5. The method of claim 1 further comprising determining which column-groups to test based, at least in part, on the selected balance point.

6. The method of claim 1,

wherein performing the plurality of tests includes:

performing the first test in which the plurality of rows are ordered according to a first ordering; and

performing the second test in which the plurality of rows are ordered according to a second ordering that is different than the first ordering.

7. The method of claim 1,

wherein performing a plurality of tests includes performing tests based on two or more phase groups;

wherein performing the tests based on two or more phase groups includes;

applying a first compression technique from a first phase group to the subset of data to produce first compressed results, and

applying a second compression technique from a second phase group on the first compressed results to produce second compressed results;

wherein the first compression technique is different than the second compression technique.

8. A method comprising:

prior to storing a set of data in a table, performing the steps of;

obtaining data that indicates a selected balance point along a spectrum between maximum performance and maximum compression;

wherein the selected balance point is one of a plurality of user-selectable balance points along the spectrum between maximum performance and maximum compression;

wherein the plurality of user-selectable balance points include at least one balance point that corresponds to neither maximum performance nor maximum compression;

wherein each of the plurality of user-selectable balance points corresponds to a candidate pool of compression techniques;

performing a plurality of tests on a subset of data from the set of data to determine compression ratios produced by applying each of a plurality of compression techniques to the subset of data;

wherein only those compression techniques that belong to the candidate pool of the selected balance point are tested during the plurality of tests;

selecting a particular compression technique to apply to the set of data based, at least in part, on;

the compression ratios produced by each of the plurality of compression techniques; and

the selected balance point;

compressing the set of data using the particular compression technique to produce compressed data; and

storing the compressed data in the table;

wherein the method is performed by one or more computing devices.

9. A method comprising:

prior to storing a set of data in a table, performing the steps of;

obtaining data that indicates a selected balance point along a spectrum between maximum performance and maximum compression;

wherein the selected balance point is one of a plurality of user-selectable balance points along the spectrum between maximum performance and maximum compression;

wherein the plurality of user-selectable balance points include at least one balance point that corresponds to neither maximum performance nor maximum compression;

performing a plurality of tests on a subset of data from the set of data to determine compression ratios produced by applying each of a plurality of compression techniques to the subset of data;

selecting a particular compression technique to apply to the set of data based, at least in part, on;

the compression ratios produced by each of the plurality of compression techniques; and

the selected balance point;

compressing the set of data using the particular compression technique to produce compressed data; and

storing the compressed data in the table;

wherein the method is performed by one or more computing devices;

wherein the table has a plurality of columns;

wherein the set of data includes a plurality of rows;

wherein, in a first test of the plurality of tests, the plurality of rows are sorted based on a first column of the plurality of columns, wherein the first test applies a particular sequence of one or more compression techniques to data for the first column of the plurality of columns; and

wherein, in a second test of the plurality of tests, the plurality of rows are sorted based on a second column of the plurality of columns, wherein the second test applies said particular sequence of one or more compression techniques to the data for the first column of the plurality of columns.

10. A non-transitory computer-readable storage storing instructions which, when executed by one or more processors, cause:

prior to storing a set of data in a table, performing the steps of;

obtaining data that indicates a selected balance point along a spectrum between maximum performance and maximum compression;

wherein the selected balance point is one of a plurality of user-selectable balance points along the spectrum between maximum performance and maximum compression;

wherein the plurality of user-selectable balance points include at least one balance point that corresponds to neither maximum performance nor maximum compression;

performing a plurality of tests on a subset of data from the set of data to determine compression ratios produced by applying each of a plurality of compression techniques to the subset of data;

wherein the table has a plurality of columns;

wherein the set of data includes a plurality of rows;

wherein, in a first test of the plurality of tests, the plurality of rows are not sorted;

wherein, in a second test of the plurality of tests, the plurality of rows are sorted based on a particular column of the plurality of columns;

selecting a particular compression technique to apply to the set of data based, at least in part, on;

the compression ratios produced by each of the plurality of compression techniques; and

the selected balance point;

compressing the set of data using the particular compression technique to produce compressed data; and

storing the compressed data in the table.

11. The non-transitory computer-readable storage of claim 10 wherein the step of obtaining data includes receiving user input that selects the selected balance point.

12. The non-transitory computer-readable storage of claim 10 wherein:

each of the plurality of user-selectable balance points corresponds to a candidate pool of compression techniques; and

only those compression techniques that belong to the candidate pool of the selected balance point are tested during the plurality of tests.

13. The non-transitory computer-readable storage of claim 10 further comprising instructions for determining how many sorting options to test based, at least in part, on the selected balance point, wherein each sorting option of the sorting options specifies a column to sort the set of data in the table before performing the plurality of tests.

14. The non-transitory computer-readable storage of claim 10 further comprising instructions for:

determining to use phase-group representatives during said testing based, at least in part, on the selected balance point;

during said testing, applying a first compression technique specified in a first phase group as being representative of the first phase group; and

during said testing, applying a second compression technique specified in a second phase group as bring representative of the second phase group.

15. The non-transitory computer-readable storage of claim 10 further comprising instructions for determining which column-groups to test based, at least in part, on the selected balance point.

16. The non-transitory computer-readable storage of claim 10,

wherein performing the plurality of tests includes:

performing the first test in which the plurality of rows are ordered according to a first ordering; and

performing the second test in which the plurality of rows are ordered according to a second ordering that is different than the first ordering.

17. The non-transitory computer-readable storage of claim 10,

wherein performing a plurality of tests includes performing tests based on two or more phase groups;

wherein performing the tests based on two or more phase groups includes;

applying a first compression technique from a first phase group to the subset of data to produce first compressed results, and

applying a second compression technique from a second phase group on the first compressed results to produce second compressed results;

wherein the first compression technique is different than the second compression technique.

18. A non-transitory computer-readable storage storing instructions which, when executed by one or more processors, cause:

prior to storing a set of data in a table, performing the steps of;

obtaining data that indicates a selected balance point along a spectrum between maximum performance and maximum compression;

wherein the selected balance point is one of a plurality of user-selectable balance points along the spectrum between maximum performance and maximum compression;

wherein the plurality of user-selectable balance points include at least one balance point that corresponds to neither maximum performance nor maximum compression;

performing a plurality of tests on a subset of data from the set of data to determine compression ratios produced by applying each of a plurality of compression techniques to the subset of data;

selecting a particular compression technique to apply to the set of data based, at least in part, on;

the compression ratios produced by each of the plurality of compression techniques; and

the selected balance point;

compressing the set of data using the particular compression technique to produce compressed data; and

storing the compressed data in the table;

wherein the table has a plurality of columns;

wherein the set of data includes a plurality of rows;

wherein, in a first test of the plurality of tests, the plurality of rows are sorted based on a first column of the plurality of columns, wherein the first test applies a particular sequence of one or more compression techniques to data for the first column of the plurality of columns; and

wherein, in a second test of the plurality of tests, the plurality of rows are sorted based on a second column of the plurality of columns, wherein the second test applies said particular sequence of one or more compression techniques to the data for the first column of the plurality of columns.