OLTP compression of wide tables

• US 9,646,053 B2
• Filed: 03/12/2013
• Issued: 05/09/2017
• Est. Priority Date: 03/12/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Marwah, Vineet, Mylavarapu, Ajit, Ganesh, Amit
• Primary Examiner(s): Hasan, Syed
• Assistant Examiner(s): ABRAHAM, AHMED M
• Application Number:
  US13/797,063
• Publication Number:
  US 20140279959A1
• Time in Patent Office: 1,519 Days
• Field of Search: 707793, 707795, 707763, 707765
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination

Abstract

A data block stores one or more rows of a database table or relation. An entire row may not fit in a data block. Part of the row is stored in one data block, and another part is stored in another data block. Each row part is referred to herein as a row segment and the data blocks are referred to as row-segmented data blocks. Data block dictionary compression is used to compress row-segmented data blocks. Each data block contains a dictionary that is used to compress rows in the data block, including row segments. The dictionary in a data block is used to compress row segments in the data block. Hence, multiple dictionaries may be used to decompress a row comprised of row segments.

Claims

1. A method comprising steps of:

a database server storing a plurality of rows in a plurality of data blocks, wherein storing said plurality of data blocks includes;

compressing said plurality of rows in said plurality of data blocks using token dictionary compression and a plurality of token dictionaries; and

wherein said plurality of rows includes a plurality of segmented rows, each segmented row of said plurality of segmented rows comprising a plurality of chained row segments, each row segment of said plurality of chained row segments containing one or more column values of said each segmented row;

wherein each data block of said plurality of data blocks stores a respective token dictionary of said plurality of token dictionaries that maps tokens only to column values stored in said each data block;

wherein a particular segmented row of particular segmented rows in a first data block of said plurality of data blocks comprises a first row segment stored in said first data block and a second row segment that is stored in a second data block of said plurality of data blocks, wherein said first row segment is stored in association with a row segment link that refers to said second row segment and that is stored in said first data block;

wherein said first row segment is encoded according to the respective token dictionary stored in said first data block and wherein said second row segment is encoded according to the respective token dictionary stored in said second data block.

2. The method of claim 1, the steps further including decoding said particular segmented row, wherein decoding said particular row segment includes decoding said first row segment according to the respective token dictionary of said first data block and decoding said second row segment according to the respective token dictionary of said second data block.

3. The method of claim 1, wherein a first segmented row of said plurality of segmented rows comprises at least two row segments stored in a same data block of said plurality of data blocks.

4. The method of claim 1, wherein a first segmented row of said plurality of segmented rows comprises at least two row segments stored in different data blocks of said plurality of data blocks.

5. A non-transitory computer-readable medium storing one or more instructions which when executed by one or more processors cause:

a database server storing a plurality of rows in a plurality of data blocks, wherein storing said plurality of data blocks includes;

compressing said plurality of rows in said plurality of data blocks using token dictionary compression and a plurality of token dictionaries; and

wherein said plurality of rows includes a plurality of segmented rows, each segmented row of said plurality of segmented rows comprising a plurality of chained row segments, each row segment of said plurality of chained row segments containing one or more column values of said each segmented row;

wherein each data block of said plurality of data blocks stores a respective token dictionary of said plurality of token dictionaries that maps tokens only to column values stored in said each data block;

wherein a particular segmented row of a particular segmented rows in a first data block of said plurality of data blocks comprises a first row segment stored in said first data block and a second row segment that is stored in a second data block of said plurality of data blocks, wherein said first row segment is stored in association with a row segment link that refers to said second row segment and that is stored in said first data block;

wherein said first row segment is encoded according to the respective token dictionary stored in said first data block and wherein said second row segment is encoded according to the respective token dictionary stored in said second data block.

6. The non-transitory computer-readable medium of claim 5, the one or more instructions including instructions that, when executed by said one or more processors, cause decoding said particular segmented row, wherein decoding said particular row segment includes decoding said first row segment according to the respective token dictionary of said first data block and decoding said second row segment according to the respective token dictionary of said second data block.

7. The non-transitory computer-readable medium of claim 5, wherein a first segmented row of said plurality of segmented rows comprises at least two row segments stored in a same data block of said plurality of data blocks.

8. The non-transitory computer-readable medium of claim 5, wherein a first segmented row of said plurality of segmented rows comprises at least two row segments stored in different data blocks of said plurality of data blocks.