Abstract: An information processing apparatus acquires first manipulation information formed by a first data manipulation language for a plurality of record types on which a data manipulation is to be performed, in an NDB having a data structure in which a parent-child relationship is formed between record types, analyzes a relationship between the plurality of record types by using relationship definition information in which item information, parent identifying information and child ordering information are defined for each record type, generates second data manipulation information formed by a second data manipulation language for the NDB, on the basis of the analyzed relationship and the first manipulation information, and outputs the generated second data generation information to the NDB.

Abstract: A logical record of a source logical page is moved to a space area or a deletion area in a destination logical page. The source logical page is sequentially set forward from the logical page immediately before the last stored logical page in a subrange. The destination logical page is sequentially set backward from the leading logical page in the subrange. When a logical record is moved, exclusive control is performed in logical page units only on the source logical page and the destination logical page. The access by online operations is not prohibited on other logical pages not exclusively controlled in the same subrange.

Abstract: A computer-readable recording medium containing a database copying program for making a copy of a database on a remote computer being connected over a network, without causing a delay in replying to an application program. A mirroring unit copies data written on a plurality of local disks onto corresponding remote disks in the same sequence as the data was written. Upon reception of a data writing request, a data writing unit stores the data in a local disk selected as a current disk. When the data stored in the current disk reaches a maximum data capacity, the current disk manager switches the current disk to another local disk. In addition, when the data stored in the current disk reaches the maximum data capacity, an operation information manager stores operation information requesting backup of the data stored in the current disk, in a local disk selected as an operation information storage disk.

Abstract: A database restructuring apparatus which is capable of migrating a database without depending on a method of managing the database and without interrupting practical online services. Copying section copies data from a current database to a switching destination database. When data update access to the current database by current database access section occurs during copy processing by the copying section, data updating section determines whether or not data to be accessed has been copied. If the data has not been copied yet, the data updating section performs data update processing on the current database, whereas if the data has already been copied, the data updating section performs data update processing on both the current database and the switching destination database. After completion of the copy processing, switching section switches the distribution destination of an online electronic message to switching destination database access section.

Abstract: A logical record of a source logical page is moved to a space area or a deletion area in a destination logical page. The source logical page is sequentially set forward from the logical page immediately before the last stored logical page in a subrange. The destination logical page is sequentially set backward from the leading logical page in the subrange. When a logical record is moved, exclusive control is performed in logical page units only on the source logical page and the destination logical page. The access by online operations is not prohibited on other logical pages not exclusively controlled in the same subrange.

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: A backup method of a computer system capable of recovery independently by a backup center alone, even if reorganization of a DB cannot be completed due to a disaster of some kind.

Abstract: A computer-readable recording medium containing a database copying program for making a copy of a database on a remote computer being connected over a network, without causing a delay in replying to an application program. A mirroring unit copies data written on a plurality of local disks onto corresponding remote disks in the same sequence as the data was written. Upon reception of a data writing request, a data writing unit stores the data in a local disk selected as a current disk. When the data stored in the current disk reaches a maximum data capacity, the current disk manager switches the current disk to another local disk. In addition, when the data stored in the current disk reaches the maximum data capacity, an operation information manager stores operation information requesting backup of the data stored in the current disk, in a local disk selected as an operation information storage disk.

Abstract: A database restructuring apparatus which is capable of migrating a database without depending on a method of managing the database and without interrupting practical online services. Copying section copies data from a current database to a switching destination database. When data update access to the current database by current database access section occurs during copy processing by the copying section, data updating section determines whether or not data to be accessed has been copied. If the data has not been copied yet, the data updating section performs data update processing on the current database, whereas if the data has already been copied, the data updating section performs data update processing on both the current database and the switching destination database. After completion of the copy processing, switching section switches the distribution destination of an online electronic message to switching destination database access section.

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 data migration system that enables a database system to migrate from a network data model to a relational data model in a short development time, without degradation in data integrity. A record migration unit creates target records for the relational data model. The records are arranged in the same way as they originally were in the network data model before data migration has been made. A primary key addition unit then adds a primary key to each of the target records so that they can be uniquely identified. To preserve the original parent-child relationships between records, a relation key addition unit selects each child record from among the target records, identifies the parent of the child record by referring to the pointers added to corresponding source records, and gives a value of the primary key of the parent record to the child record as a relation key thereof.

Abstract: A system for changing a logical data structure of a network type database in which an owner record is linked to member records by set-information identifying positions of the member records, the system includes a first unit for changing of a definition of a logical data structure of the network type database; and a second unit, when a member record to be linked to or linked to the owner record is added to or erased from the network type database in accordance with a changed logical data structure obtained by the first unit, for adding or erasing set-information of the added or erased member record to or from the set-pointer portion of the owner record, wherein an area of the set-pointer portion is changed in accordance with a variable-length management.