Invention Grant
- Patent Title: Optimizing column based database table compression
-
Application No.: US15244923Application Date: 2016-08-23
-
Publication No.: US10235100B2Publication Date: 2019-03-19
- Inventor: Sudhir Verma
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Maschoff, Buckley & Talwalkar LLC
- Main IPC: G06F3/06
- IPC: G06F3/06 ; G06F17/30

Abstract:
Various embodiments of systems and methods for optimizing in-memory column based database table compression. A system may receive a parsed in-memory columnar database table as an input and reads an aggregated compression score from memory corresponding to the parsed database table. A total compression score may be computed iteratively for the database table in order to determine whether the total compression score is greater than the aggregated compression score. When the total compression score determined to be greater than the aggregated compression score, the aggregated compression score is assigned to a best compression score. To optimize in-memory database table compression, the given database table may be compressed using the best compression score.
Public/Granted literature
- US20180060374A1 OPTIMIZING COLUMN BASED DATABASE TABLE COMPRESSION Public/Granted day:2018-03-01
Information query