Please download the dossier by clicking on the dossier button x
×

DATA SYNCHRONIZATION METHOD, DATA SYNCHRONIZATION PROGRAM, DATABASE SERVER AND DATABASE SYSTEM

  • US 20100036894A1
  • Filed: 02/06/2009
  • Published: 02/11/2010
  • Est. Priority Date: 08/05/2008
  • Status: Abandoned Application
First Claim
Patent Images

1. A data synchronization method for synchronizing data between an active database and a standby database in a database system, the database system being redundantly configured by having an active server to update data according to a command from a client and a standby server to take over processing from the active server in the event of a failure of the active server;

  • wherein the active server has the active database and the standby server has the standby database;

    wherein the active server has, in addition to the active database, a resource utilization table, a resource utilization monitoring unit, a transaction control unit and a data reflection method selection unit; and

    wherein the standby server has a log data application unit in addition to the standby database;

    the method comprising the steps of;

    starting, when the transaction control unit receives an operation command for specifying and updating data content, a transaction to process the received operation command and then reflecting on the active database the content specified by the received operation command;

    collecting, by the resource utilization monitoring unit, at least utilization information on resources in each of the servers making up the database system or database operation information, and storing them in the resource utilization table;

    weighting, by the data reflection method selection unit, collected values in the resource utilization table by multiplying the collected values by assessment coefficients assigned to the individual collected values in an assessment coefficient table, summing up the weighted values to calculate an assessment value for each data reflection method, and determining the data reflection method whose assessment value is minimum;

    sending, by a log data transmission unit according to the determined data reflection method, log data that is reflected on the active database to the standby server, which forms one of the duplicated servers making up the redundant configuration; and

    reflecting, by the log data application unit, when a finalize command to finalize the transaction is transmitted from the client to the active server, the received log data on the standby database,wherein the data reflection method is defined by selecting one of log data content transmitting methods shown in (a) and (b);

    (a) Transmitting data log representing a content of data to be updated in the database but not an index log representing a content of index update to the content of data, the index log being created on the standby server side instead; and

    (b) Transmitting index log in addition to the data log.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×