International Business Machines Corporation

Stephen Walter Turnbaugh

James Zu-Chia Teng

Craig Alan Friske

Gary Howard Sockut

Balakrishna Raghavendra Iyer

Namik Hrle

James Z Teng

You-Chin Gene Fuh

Julie Ann Watts

Kalpana Shyam

Jeffrey Allen Berger

Akira Shibamiya

Sauraj Goswami

San Yu Phoenix

Michael R Shadduck

Various embodiments of a computer-implemented method, system and computer program product maintain a logical page having a predetermined size. Data is added to an uncompressed area of the logical page. The uncompressed area of the logical page is associated with an uncompressed area of a physical page. The logical page also has a compressed area associated with a compressed area of a physical page. In response to exhausting the uncompressed area, data in the uncompressed area is included in the compressed area. The uncompressed area is adjusted.

Compressibility checking avoidance

A method and system for formatting space in a storage device for a database system is disclosed. The method and system include formatting a first increment for creating a database file and asynchronously formatting at least one subsequent increment for the database file in a background of the database system.

Method and system for performing asynchronous preformatting in a database system

Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

Method, system, and program for using control data structures when performing operations with respect to a database

A method and apparatus for online reorganization of a database which does not prevent a process from accessing the database during the data reorganization. The invention uses a non-blocking drain to lock on a database, unloads a copy of the data contained in the database, reorganizes the copied data, loads the reorganized data into a shadow location, applies log records to the shadow location data so that the reorganized data may be adjusted for any changes to the database after the data was copied and reorganized, and then replaces the data in the database with the reorganized data. The non-blocking drain does not prevent other requests on the database from being processed while the reorganization lock is in place, except briefly when the reorganized data replaces the data in the database.

Non-blocking drain method and apparatus for use in processing requests on a resource

Non-blocking drain method and apparatus used to reorganize data in a

Growing community of inventors

Hollister, CA, United States of America

Stephen Walter Turnbaugh