Patent · US Active

Using parallel insert sub-ranges to insert into a column store

US9442913B2 · kind B2 · utility

0Cited by

4References

12Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Walter D. Alvey · San Jose, US
Chandrasekaran Mohan · Saratoga, US
Steven R. Pearson · Portland, US
James Seeger · Portland, US
Richard S. Sidle · Ottawa, CA
Adam J. Storm · Toronto, CA
Roger L. Q. Zheng · King City, CA

Key dates

Filing date	Jan 30, 2014
Grant date	Sep 13, 2016
Priority date	—
Expiry date	Mar 24, 2035

Classification

Technology area (CPC G)Physics
CPC primaryG06F40/177
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.