Abstract: A method, apparatus, and article of manufacture for a computer implemented technique for deferring large object access with intermediate results. A query is executed in a database stored on a data storage device connected to a computer. A control structure representing an expression in the query is generated. An intermediate result is generated by retrieving data for the query that is not represented by the control structure. Then, a result table is built using the processed intermediate result and the control structure.

Abstract: A method, apparatus, article of manufacture, and a memory structure for configuring a database management system to operate with multiple key versions is disclosed. The method comprises the steps of accessing key information comprising self-describing key data and an associated version indicator, generating key conversion/comparison information from the accessed key information, and storing the key conversion/comparison information in a memory accessible to the database management system. The apparatus comprises a means for performing the above-entitled operations, and the article of manufacture comprises a program storage device tangibly embodying instructions for performing the operations.

Abstract: A method, apparatus, article of manufacture, and a memory structure for configuring a database management system to operate with multiple key versions is disclosed. The method comprises the steps of storing first key information comprising a first key format and an associated version indicator, when a command altering the key format is accepted, storing altered key information comprising the altered key format and the incremented version indicator in the index page set, and storing altered key information in an index catalog. The apparatus comprises a means for performing the above-entitled operations, and the article of manufacture comprises a program storage device tangibly embodying instructions for performing the operations.

Abstract: 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.