International Business Machines Corporation

Charles Roy Bonner

Robert William Lyle

Maryela Evelin Weihrauch

John Joseph Campbell

Frances Hwa Villafuerte

Namik Hrle

James Zu-Chia Teng

Julie Ann Watts

Kalpana Shyam

San Yu Phoenix

Rows are inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for updating data of the inserted rows, wherein reserving the second space includes reserving the second space on the page responsive to inserting each of the rows.

Free space management in a database

A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row, so that the amount of space reserved for adding data to inserted rows grows as more rows are inserted. The page is marked full for the second space independently of whether the first space is full for inserting new rows. Data is added to rows on the page, responsive to detecting that the second space is full, by adding the data to one or more new pages, even though rows may still be inserted on the page using any remaining room in the first space on the page.

A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row.

A computer program product provides accurate statistics in real time. These statistics can be used to determine if a table space in a database management system (DBMS) requires maintenance operations such as reorganization, back up, fresh access path statistics, and/or larger disk space allocation. The DBMS maintains a set of values that provide indications of whether that operation is due on that object. The indicators are asynchronously externalized in dedicated database tables either periodically in user-specified intervals or at some predefined event such as stopping the database. When the user performs a database administration operation, the database management system resets the associated indicators, and reports objects that are in an exception state based on the indicators collected as described for each operation.

System and method for real time statistics collection for use in the automatic management of 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 processing a fetch request for a target row in a table that precedes as current row

A method, apparatus, and article of manufacture for a computer implemented technique for prefetching pages. Pages are prefetched from a database stored on a data storage device connected to a computer. Pages to be retrieved are identified. Identifiers for the identified pages are stored in multiple prefetch page lists. Concurrently, the retrieved pages are processed and prefetch commands are issued to alternating multiple prefetch page lists.

Optimized technique for prefetching LOB table space pages

A method, apparatus, and article of manufacture for a computer implemented reorganization system. A table space is reorganized in a database stored on a data storage device connected to a computer. When inserting or updating a LOB into a portion of the table space, a space map is marked to indicate whether the LOB was well inserted. When reorganizing the table space, when the space map indicates that a LOB was well inserted, reorganization of the portion of the table space in which the LOB was well inserted is avoided.

Technique to avoid processing well clustered LOB's during reorganization of a LOB table space

A apparatus, apparatus, and article of manufacture for a computer implemented inplace reorganization system. Data in a database is stored on a data storage device connected to a computer is reorganized. Large object data that needs to be reorganized within a table space is identified. One or more chunks in the table space are allocated to the identified large object data. In particular, a combination of full and partial chunks of space within the table space are allocated to contain the reorganized large object data. Then, the large object data is moved into the allocated chunks to reorganize the large object data inplace. Furthermore, the free space at the end of the table space may be reclaimed.

Growing community of inventors

San Jose, CA, United States of America

Charles Roy Bonner