International Business Machines Corporation

Marko Milek

Li Zhou

Richard Sefton Sidle

Sam Sampson Lightstone

Christina Marie Lee

Antti-Pekka Liedes

Ying-Pong Chen

Jussi Vuorento

Vijayshanker Raman

Leo Tat Man Lau

Adil Mohammad Sardar

Qing Song

Mark Donald Leitch

David Sciaraffa

In one embodiment, a method includes adding, by a computer processor, two or more compressed columns to one or more pages of a database. The adding is performed in parallel by a plurality of page-formatter threads. Each page-formatter thread adds data to the database from no more than a single compressed column.

Parallel load in a column-store database

A transactional database server is accessible by applications. Applications indicate whether access is made using an online protocol. Where the database server determines that a request received from an application is made using the online protocol, the server will return one of a set of defined error codes upon identified system resources being determined to be scarce. Applications monitor responses from the database server for the defined error codes. On receipt of one of the defined error codes an application will issue a commit to the database server to attempt to release system resources for use by applications.

Method for increasing system resource availability in database management systems

An apparatus, system, and method are disclosed for efficient adaptive parallel data clustering for loading data into a table by generating a hint-key for each of one or more records in the input data stream, ordering the one or more records in a first-level clustering agent to generate one or more record lists ordered by hint-key. The apparatus, system, and method simultaneously processes one or more record lists in a second-level clustering agent, outputs the one or more records of the one or more record lists clustered by the hint-key of the one or more records, stores, in a partial block cache, a plurality of partial blocks that are output by the second-level clustering agent, and stores, in a partial page cache, a plurality of last partial pages of the partial blocks that have been victimized from the partial block cache.

Apparatus, system, and method for efficient adaptive parallel data clustering for loading data into a table

Growing community of inventors

Singapore, Singapore

Marko Milek