Abstract: A database-rearranging program which is capable of rearranging a database while maintaining high reliability, without stopping services provided by the database. When a request for rearranging the copy source database is input, a record copying module sequentially selects pages in the copy source database, and the records in the selected page are copied to the copy destination database. Further, the record copying module sets a progress of copying of each page of the copy source database to a page status management table. Thereafter, when a request for writing updated records is input, a record writing module refers to the page status management table, and when a page of the copy source database in which the updated records should be written is in an uncopied status, the updated records are written in the page of the copy source database, and when the same is in a copied status, the updated records are written in the copy source database and the copy destination database.

Abstract: A database reorganization program to reorganize a database with minimizing memory consumption. When a command for reorganizing a database is issued, a record reorganization unit sequentially selects a page of a basic area with reference to an index, and moves the records of the selected page into new destination pages of an expanded database with reference to an expansion index. In addition, the record reorganization unit updates a page state table showing a reorganization progress for each page of the database.

Abstract: When generating initial data for carrying out replication of a table for replication, a replication data generating function establishes a correspondence between content of each row of the table and a physical row number, and outputs the physical row number of each row. A replication data reflecting function includes the physical row number from a replication source in a portion of the row and fetches the initial data. Fetching the initial data enables to establish a correspondence of rows in the replication source and the replication destination even if the table does not include a unique key.

Abstract: A database reorganization program to reorganize a database with minimizing memory consumption. When a command for reorganizing a database is issued, a record reorganization unit sequentially selects a page of a basic area with reference to an index, and moves the records of the selected page into new destination pages of an expanded database with reference to an expansion index. In addition, the record reorganization unit updates a page state table showing a reorganization progress for each page of the database.

Abstract: An edition number management unit manages an edition number management table to which an edition number is registered for each page which is a minimum unit for exclusively controlling a basic database, and updates the relevant edition number in the edition number management table in accordance with update processing of a page. When receiving a search processing request, a search processing unit executes search processing of the basic database, notifies an AI server, which is a search-processing request source, of search results, and notifies the AI server of edition numbers of the searched pages for storage.

Abstract: A recording medium includes a program causing a computer to execute the steps of (a) predicting a data storage condition of a database from a record operation, (b) computing a number of relocatable areas and a number of areas in an expansion direction based on the data storage condition predicted in step (a), and (c) detecting operation timing with respect to the database based on the numbers computed in step (b).

Abstract: A database-rearranging program which is capable of rearranging a database while maintaining high reliability, without stopping services provided by the database. When a request for rearranging the copy source database is input, a record copying module sequentially selects pages in the copy source database, and the records in the selected page are copied to the copy destination database. Further, the record copying module sets a progress of copying of each page of the copy source database to a page status management table. Thereafter, when a request for writing updated records is input, a record writing module refers to the page status management table, and when a page of the copy source database in which the updated records should be written is in an uncopied status, the updated records are written in the page of the copy source database, and when the same is in a copied status, the updated records are written in the copy source database and the copy destination database.

Abstract: A database copy apparatus, a database copy method and a recording medium recorded with a database copy program, which increases the generality of database copying irrespective of the database structure, by partitioning a copy source database into predetermined regions, and copying records and inter-record connection relations contained in the respective regions to a copy target database, and extracting from the copy source database the inter-record connection relations respectively contained in different regions, and duplicating the inter-record connection relations copied to the copy target database, based on the extracted connection relations.

Abstract: A recording medium includes a program causing a computer to execute the steps of (a) predicting a data storage condition of a database from a record operation, (b) computing a number of relocatable areas and a number of areas in an expansion direction based on the data storage condition predicted in the step (a), and (c) detecting operation timing with respect to the database based on the numbers computed in the step

Abstract: A system for relocating records in a database having a prime region and an overflow region in parallel with a service processing. The system is provided with a database relocation utility which acquires exclusive access to regions of the prime region and the overflow region for which the service processing has not acquired exclusive access. The system saves a predetermined number of records of the prime region and the overflow region into a data save area. Thereafter, the system relocates the records by packing them in one of the prime region and the overflow region.