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.

主权项

1. A computer system for using parallel inserts to change a columnar table, comprising:
one or more processors, one or more computer-readable memories and one or more computer-readable, tangible storage devices; and program instructions, stored on at least one of the one or more computer-readable, tangible storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, to perform: 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;serially 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; andin response to processing the change statement,
determining whether an application is waiting for any sub-range;in response to determining that the application is waiting for any sub-range, giving the identified sub-range to the application; andin response to determining that the application is not waiting for any sub-range, releasing the sub-range.