Invention Grant
- Patent Title: Compression units in an index block
-
Application No.: US15267759Application Date: 2016-09-16
-
Publication No.: US11789923B2Publication Date: 2023-10-17
- Inventor: Kam Shergill , Ankita Kumar , Himanshu Chatterjee , Vineet Marwah , Srinivas Vemuri
- 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 Becker Bingham Ledesma LLP
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22

Abstract:
A method and apparatus for compression units in an index block is provided. A particular leaf block of a database index for a table is generated. The particular leaf block corresponds to a particular range of key values. A compression scheme is determined for a plurality of index entries with key values within the particular range. A compression unit that includes a plurality of compressed index entries is generated by applying the compression scheme to the plurality of index entries. Compression metadata describing the compression scheme is generated. The compression unit and the compression metadata is stored in the particular leaf block. In response to a request, at least a portion of the compression unit is decompressed to access one or more index entries.
Public/Granted literature
- US20170116280A1 COMPRESSION UNITS IN AN INDEX BLOCK Public/Granted day:2017-04-27
Information query