International Business Machines Corporation

Arthur Marais

Nigel G Slinger

John Benjamin Tobler

Daniel Kozin

Christopher J Munson

Wen J Zhu

Meichi M Lin

Maggie M Lin

Timothy E McAllister

According to one embodiment of the present invention, a system for processing a database query stores one or more result sets for one or more first database queries in a data store. The system receives a second database query and compares the second database query to the one or more first database queries to determine presence of a corresponding result set in the data store for the second database query. The system provides the corresponding result set from the data store for the second database query based on the comparison. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manners described above.

Dynamic result set caching with a database accelerator

According to one embodiment of the present invention, a system inserts data into a database object. The system associates the database object with a parameter specifying materialization of data for the database object. The system inserts data into the database object and materializes the data in accordance with the parameter to provide access to the data from the database object, wherein the parameter specifies a portion of the data to be materialized upon insertion. Embodiments of the present invention further include a method and computer program product for inserting data into a database object in substantially the same manners described above.

Database insert with deferred materialization

According to one embodiment of the present invention, a system includes a processor to copy an object of a database system. The system determines one or more portions of the object that are active and reside within a buffer pool of the database system, and copies the determined portions of the object from the buffer pool. Remaining portions of the object that are non-active are copied from database storage. A copy of the object is created from the copied object portions. Embodiments of the present invention further include a method and program product for copying an object of a database system in substantially the same manner described above.

Producing an image copy of a database object based on information within database buffer pools

According to one embodiment, a computer-implemented method of decompressing compressed data is described. A first decompression dictionary is analyzed, the first decompression dictionary including a plurality of chains each with uncompressed data portions distributed in a non-contiguous manner within the first decompression dictionary based on an addressing scheme, where the uncompressed data portions of each chain form a corresponding uncompressed version of compressed data. A second decompression dictionary is generated by combining the uncompressed data portions of each of the chains in the first decompression dictionary to form uncompressed versions of compressed data and instructions are inserted within the second decompression dictionary to decompress compressed data. The compressed data are decompressed by applying the compressed data to the second decompression dictionary. Embodiments further include a system and computer program product for decompressing compressed data in substantially the same manner described above.

Growing community of inventors

Montgomery, TX, United States of America

Arthur Marais