Invention Grant
- Patent Title: Optimal sort key compression and index rebuilding
-
Application No.: US15658671Application Date: 2017-07-25
-
Publication No.: US10671586B2Publication Date: 2020-06-02
- Inventor: Yong Sik Kwon , Kunsoo Park , Cheol Yoo
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F16/22 ; G06F16/23

Abstract:
A system and method, including determining, by a processor, distinction bit positions for index keys of a database index; determining, by the processor, concatenation of the bits of the index keys; and generating a record of the concatenation. Other systems and methods include collecting, by a processor, index keys of a database index in parallel, wherein data pages of a target table are evenly distributed to a plurality of processor cores; scanning, by each of the cores the data pages to extract compressed keys and corresponding record identifiers; sorting, by a plurality of the processor cores, pairs of the compressed key and corresponding record identifier in accordance with a parallel sorting algorithm; generating an index tree in a bottom-up fashion; and storing a record of the generated index tree.
Public/Granted literature
- US20190034467A1 OPTIMAL SORT KEY COMPRESSION AND INDEX REBUILDING Public/Granted day:2019-01-31
Information query