Invention Grant
- Patent Title: OLTP compression of wide tables
-
Application No.: US13797063Application Date: 2013-03-12
-
Publication No.: US09646053B2Publication Date: 2017-05-09
- Inventor: Vineet Marwah , Ajit Mylavarapu , Amit Ganesh
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20140279959A1 OLTP COMPRESSION OF WIDE TABLES Public/Granted day:2014-09-18
Information query