| 发明名称 |
USING PARALLEL INSERT SUB-RANGES TO INSERT INTO A COLUMN STORE |
| 摘要 |
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. |
| 申请公布号 |
US2015213073(A1) |
申请公布日期 |
2015.07.30 |
| 申请号 |
US201414542248 |
申请日期 |
2014.11.14 |
| 申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
ALVEY Walter D.;MOHAN Chandrasekaran;PEARSON Steven R.;SEEGER, Jr. James J.;SIDLE Richard S.;STORM Adam J.;ZHENG Roger L.Q. |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method, comprising:
creating a list of sub-ranges for a columnar table; receiving a change statement for one or more rows to be inserted into the columnar table; and for each of the received change statements,
identifying a sub-range from the list of sub-ranges; andserially inserting data 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. |
| 地址 |
Armonk NY US |
