International Business Machines Corporation

Walter Duke Alvey

Richard Sefton Sidle

Adam J Storm

Chandrasekaran Mohan

Steven Robert Pearson

James John Seeger, Jr

Roger L Q Zheng

Ronald Jason Barber

Yi Ding

Ping Li

Matthew Albert Huras

Randy Mitchell Nakagawa

James J Seeger

David C Smith

Priya Baliga

Sam B Lightstone

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.

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

According to one embodiment of the present invention, a method for processing a query in a column database is provided. The method for analyzing test results may include a computer, associating a first set of metadata values with a set of records in a table, wherein each record has an associated state indicated by a metadata value. The method may further include the computer receiving a query to return one or more records of the set of records. The method may further include the computer determining that one or more records in the set of records satisfies the query. The method may further include the computer determining whether at least a first record in the one or more records that satisfies the query is in a returnable state based, at least in part, on the metadata value.

Query handling in a columnar database

Embodiments relate to database systems. An aspect includes deferring row insert operations until occurrence of a triggering event. One method includes receiving a row insert for a tuple into a column group store table, where the tuple includes one or more tuplets and each of the tuplets corresponds to a column group in the column group store table. The method also includes copying at least one of the tuplets into an insert buffer that is specific to one of the column groups in the column group store table. The method also includes deferring the row insert into the column group store table until an occurrence of one or more triggering events. The method also includes flushing the row insert into storage associated with the column group store table, in response to the occurrence of the one or more triggering events.

Buffering inserts into a column store database

A method, information handling system, and computer program product to simulate conditions in a software module, by identifying, in the software module, whether a simulation environment has been activated, encountering a simulation point in the software module, the simulation point including one or more simulation parameters, and in response to identifying that the simulation environment has been activated and the simulation point has been encountered: invoking a simulation module, the invoking including passing the simulation parameters to the simulation module, comparing, at the simulation module, the simulation parameters with one or more active simulation entries, and returning a simulated condition from the simulation module to the software module in response to the comparing.

System and method to simulate conditions and drive control-flow in software

Growing community of inventors

San Jose, CA, United States of America

Walter Duke Alvey