Database management method, database management system and database management program

A database management system comprising:

• a first database management apparatus including a primary memory where a first database is disposed;
• and
• a second database management apparatus including a secondary memory where a second database is disposed are coupled via a network and the first and second database management apparatuses copy stored data to and from one another,
• the first database management apparatus including a first list which holds storage location information indicating a write destination in the second database for data which is added to the first database,
• the first database management apparatus further comprising an index including storage location information which indicates the storage location of the data in the second database which associates the data stored by the first database with the data stored by the second database,
• wherein the first database management apparatus, when optional data is added to the first database, is configured to append the storage location information from the first list to the data;
• the first database management apparatus is configured to transmit the data to which the storage location information has been appended to the second database management apparatus and issue a request to add the data to the second database management apparatus;
• the second database management apparatus is configured to add the data to the storage location in the second database indicated by the storage location information appended to the data in response to the data addition request from the second database management apparatus;
• the first database management apparatus, when data stored in the first database is updated or deleted, is configured to refer to the index and append the storage location information in the second database to the data, transmit the data to the second database management apparatus, and request an update or deletion of the data;
• the second database management apparatus is configured to update or delete the data which exists in the storage location of the second database indicated by the storage location information in response to the data update or deletion request from the first database management apparatus;
• the second database management apparatus comprises a second list which holds the storage location information held in the first list;
• the second database management apparatus is configured to add the data to a storage location other than the storage location indicated by the storage location information held in the second list if a request to add data to the second database is made, and append the storage location information of the storage location where the data is added to the data and transmits the resulting data to the first database management apparatus;
• and
• the first database management apparatus is configured to add the storage location information to the index and add the data to the in-memory database if the data and the storage location information appended to the data are received.

A non-transitory computer readable storage medium storing a computer-readable program for a system in which a first database management apparatus including a primary memory where a first database is disposed and a second database management apparatus including a secondary memory where a second database is disposed are coupled via a network and the first and second database management apparatuses copy stored data to and from one another,

• the first database management apparatus including a first list which holds storage location information indicating a write destination in the second database for data which is added to the first database,
• the first database management apparatus further comprising an index including storage location information which indicates the storage location of the data in the second database which associates the data stored by the first database with the data stored by the second database,
• the computer-readable program comprising:
• computer-readable instructions to append, by the first database management apparatus, the storage location information from the first list to the data, when optional data is added to the first database;
• computer-readable instructions to transmit, by the first database management apparatus, the data to which the storage location information has been appended to the second database management apparatus and issue, by the first database management apparatus, a request to add the data to the second database management apparatus;
• computer-readable instructions to add, by the second database management apparatus, the data to the storage location in the second database indicated by the storage location information appended to the data in response to the data addition request from the second database management apparatus;
• computer-readable instructions, when data stored in the first database is updated or deleted, to
• refer, by the first database management apparatus, to the index;
• append, by the first database management apparatus, the storage location information in the second database to the data;
• transmit, by the first database management apparatus, the data to the second database management apparatus;
• and
• request, by the first database management apparatus, an update or deletion of the data;
• and
• computer-readable instructions to update or delete, by the second database management apparatus, the data which exists in the storage location of the second database indicated by the storage location information in response to the data update or deletion request from the first database management apparatus,
• wherein the second database management apparatus comprises a second list which holds the storage location information held in the first list,
• wherein the second database management apparatus adds the data to a storage location other than the storage location indicated by the storage location information held in the second list if a request to add data to the second database is made, and appends the storage location information of the storage location where the data is added to the data and transmits the resulting data to the first database management apparatus,
• wherein the first database management apparatus adds the storage location information to the index and adds the data to the in-memory database if the data and the storage location information appended to the data are received.