Method and system for data update synchronization by two-phase commit

An integrated management database system having a plurality of element databases for holding configuration information about an information system to be managed and an integrated database for integrally managing the plurality of element databases, wherein

• the integrated database comprises:
• a storage device including a non-transitory computer readable storage medium to store the integrated database;
• a configuration information database to collectively manage the configuration information held in the plurality of element databases;
• a configuration information holding unit to write the configuration information to the configuration information database;
• a priority input unit to accept priority information including a processing policy about each configuration information managed in the configuration information database;
• a priority database to hold priority information accepted by the priority input unit;
• an update registration and input unit to accept update and registration of data from an element database;
• a priority decision unit to refer to a processing policy for a two-phase commit protocol for update data held in the priority database, with respect to the update data accepted by the update registration and input unit, and to determine an element database for which a request to update the update data is to be issued;
• an update request communication unit to notify an element database determined to request the update by the priority decision unit of an update request of the update data;
• an updatability decision unit to receive a reply from an element database which has received an update request notification from the update request unit, and to determine commit or rollback of the updating process of the configuration information based on the reply;
• and
• an update process communication unit to notify the element database in the system and the configuration information database of commit or rollback of the configuration information based on a determination result of the updatability decision unit,
• wherein the processing policy is information for classification of the element database and configuration information database of the integrated database, into a priority element database, a reference element database, or an other element database, according to priority of the update data held by each of the element databases, the processing policy including a condition of determining a priority element database or a reference element database based on a mathematical expression for calculating a priority and on a calculated priority,
• wherein the mathematical expression includes as coefficients a point assigned to each of the element databases, a point assigned to the configuration information database of the integrated database, and a point assigned to a master element database holding the configuration information as a primary information source in the system, and
• wherein the update request communication unit determines each element database as a priority element database, a reference element database or an other element database, and notifies only the priority element database and the reference element database of the update request.

A method of update synchronization of an integrated management database system having a plurality of element databases for holding configuration information about an information system to be managed and an integrated database for integrally managing the plurality of element databases, the method comprising:

• a processing policy registering step to register, using a computer including at least one processor, a processing policy for a two-phase commit protocol in advance with respect to each data of the configuration information registered in a configuration information database collectively managing configuration information held by the plurality of element databases;
• an update requesting step to refer, using the computer, to a processing policy relating to update data stored in the configuration information database when the data is updated, and to transmit an update request only to a higher priority element database holding the update data;
• an updatability decision step to receive, via the computer, a response from an element database to which an update request has been transmitted in the update requesting step, and to determine whether or not the update is committed based on the received response;
• and
• an update process communicating step to instruct, via the computer, all element databases holding the update data to perform commit or rollback depending on the determination result in the updatability decision step,
• wherein the processing policy is information for classification of the element database and configuration information database of the integrated database into a priority element database, a reference element database, or an other element database, according to priority of the update data held by each of the element databases, the processing policy including a condition of determining a priority element database or a reference element database based on a mathematical expression for calculating a priority and on a calculated priority,
• wherein the mathematical expression includes as coefficients a point assigned to each of the element databases, a point assigned to the configuration information database of the integrated database, and a point assigned to a master element database holding the configuration information as a primary information source in the system, and
• wherein the update requesting step determines each element database as a priority element database, a reference element database or an other element database, and notifies only the priority element database and the reference element database of the update request.

An integrated database device which integrally manages a plurality of element databases stored on a storage device for holding configuration information about an information system to be managed, comprising:

• a configuration information database stored on a non-transitory computer readable storage medium to collectively manage the configuration information held in the plurality of element databases;
• processing policy registration unit for registering in advance a processing policy for a two-phase commit protocol for each of the configuration information registered in the configuration information database;
• update request unit for referring to the processing policy relating to update data registered in the processing policy registration unit when data stored in the configuration information database is updated, and transmitting an update request only to a higher priority element database holding the update data;
• updatability decision unit for receiving a response from the element database to which the update request unit transmitted the update request, and determining whether or not an update is committed based on the received response;
• and
• update process communication unit for instructing all element databases holding the update data to perform commit or rollback depending on the determination result of the updatability decision unit,
• wherein the processing policy is information for classification of the element database and configuration information database of the integrated database into a priority element database, a reference element database, or an other element database, according to priority of the update data held by each of the element databases, the processing policy including a condition of determining a priority element database or a reference element database based on a mathematical expression for calculating a priority and on a calculated priority,
• wherein the mathematical expression includes as coefficients a point assigned to each of the element databases, a point assigned to the configuration information database of the integrated database, and a point assigned to a master element database holding the configuration information as a primary information source in the system, and
• wherein the update request unit determines each element database as a priority element database, a reference element database or an other element database, and notifies only the priority element database and the reference element database of the update request.