OLTP COMPRESSION OF WIDE TABLES

摘要

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.

主权项

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; andwherein said plurality of rows includes segmented rows, each segmented row of said 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.