Invention Grant
- Patent Title: Column data compression schemes for scaling writes and reads on database systems
-
Application No.: US16141572Application Date: 2018-09-25
-
Publication No.: US11537571B2Publication Date: 2022-12-27
- Inventor: Rohitashva Mathur
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Wong & Rees LLP
- Agent Zhichong Gu
- Main IPC: G06F16/215
- IPC: G06F16/215 ; G06F16/22 ; G06F16/23 ; G06F16/2455 ; H03M7/46 ; H03M7/30

Abstract:
A request for performing a data storing operation directed to a database table that comprises a plurality of table columns is received. Columnar compression metadata is accessed to identify one or more table columns in the database table, each of the one or more table columns being designated to store compressed columnar values. The columnar compression metadata is used to apply one or more columnar compression methods to generate, from one or more uncompressed columnar values received with the request for the data storing operation, one or more compressed columnar values to be persisted in the one or more table columns in the database table. A database statement is executed to persist the one or more compressed columnar values in the one or more table columns in the database table.
Public/Granted literature
- US20200097571A1 COLUMN DATA COMPRESSION SCHEMES FOR SCALING WRITES AND READS ON DATABASE SYSTEMS Public/Granted day:2020-03-26
Information query