Invention Grant
- Patent Title: Using parallel insert sub-ranges to insert into a column store
-
Application No.: US15227383Application Date: 2016-08-03
-
Publication No.: US10176205B2Publication Date: 2019-01-08
- Inventor: Walter D. Alvey , Chandrasekaran Mohan , Steven R. Pearson , James J. Seeger, Jr. , Richard S. Sidle , Adam J. Storm , Roger L. Q. Zheng
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Konrad, Raynes, Davda & Victor LLP
- Agent Janaki K. Davda
- Main IPC: G06F17/24
- IPC: G06F17/24 ; G06F17/30

Abstract:
Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.
Public/Granted literature
- US20160342635A1 USING PARALLEL INSERT SUB-RANGES TO INSERT INTO A COLUMN STORE Public/Granted day:2016-11-24
Information query