Patent ID: 9002796
Filing Date: 2015-04-07
Classification: G06F

Abstract:
1. A database management method 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 database management method comprising: a first step whereby the first database management apparatus, when optional data is added to the first database, appends the storage location information from the first list to the data; a second step whereby the first database management apparatus transmits the data to which the storage location information has been appended to the second database management apparatus and issues a request to add the data to the second database management apparatus; a third step whereby the second database management apparatus adds 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; a fourth step whereby the first database management apparatus, when data stored in the first database is updated or deleted, refers to the index and appends the storage location information in the second database to the data, transmits the data to the second database management apparatus, and requests an update or deletion of the data; and a fifth step whereby the second database management apparatus updates or deletes 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.