Invention Grant
- Patent Title: Adaptive index leaf block compression
-
Application No.: US14572765Application Date: 2014-12-16
-
Publication No.: US10366067B2Publication Date: 2019-07-30
- Inventor: Kam Shergill , Vineet Marwah
- 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
- Agent Daniel D. Ledesma
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/22

Abstract:
Techniques for compressing leaf blocks of an index are provided. The decision whether (and/or how much) to compress leaf blocks of an index is performed on a per block basis. Thus, for example, some leaf blocks of the index may be compressed while other leaf blocks of the index may be uncompressed. As another example, different leaf blocks of an index may be compressed a different amount. In one technique, a set of index entries is identified for storage in a leaf block. Multiple estimates of potential space savings are calculated for compressing the set of index entries, one estimate for each different variation of a compression technique. The compression technique variation that is associated with the most space savings is selected and applied to the set of index entries. Thus, some techniques prevent negative compression altogether. Additionally, users require no knowledge of the underlying data to perform optimal compression.
Public/Granted literature
- US20160171053A1 ADAPTIVE INDEX LEAF BLOCK COMPRESSION Public/Granted day:2016-06-16
Information query