JP6023733B2 - Service providing system and data recovery method - Google Patents

Description

  The present invention relates to a technique for recovering data.

  Currently, there are service providing systems that provide various services to terminal devices such as telephone terminals. As shown in FIG. 6, the service providing system 1 includes, for example, a DB server 100, a plurality of service providing servers 200, and an operation system (OpS) 300. In this example, two service providing servers 200a and 200b that provide different services are described. Such a service providing server 200 has different requirements for data depending on the nature of the service to be provided, such as always using only the latest data or using even past data. Hereinafter, an outline of the operation of the conventional service providing system 1 will be described.

  Based on the data request from the terminal device 3, the service providing server 200 provides the retained data to the terminal device 3 if the corresponding data is retained, and if not retained, the service providing server 200 requests the terminal ID ( A data request signal including a telephone number and the like is transmitted to the DB server 100. Then, the DB server 100 provides data corresponding to the terminal ID in the transmitted data request signal to the service providing server 200 that is the request source. Further, when there is a data operation related to the service order from the operation system 300 to the DB server 100, the DB server 100 transmits the updated data to the service providing server 200 in the past after updating the corresponding data. If so, send it.

  Here, the operation when data in operation becomes unavailable due to a catastrophic disaster or the like will be described. As illustrated in FIG. 7, the DB server 100 recovers data from a backup file that has been held in the past, and then updates the recovery data to the latest state with the difference data re-entered from the operation system 300.

JP 2013-218481 A JP 2009-252148 A

  Here, when a data request signal is transmitted from the service providing server 200 to the DB server 100 while the difference data is reintroduced, on the service providing server 200 side, the data transmitted from the DB server 100 is backed up for the signal. Since it cannot be determined whether the data is immediately after restoration by file or the latest data after re-inputting the differential data, the service providing server 200a that uses only the latest data is allowed to download the old data before the re-input of the differential data. End up.

  The present invention has been made in view of the above circumstances, and an object of the present invention is to make it possible to handle the availability of data on the service providing server side and to enable an autonomous operation until it is restored to the latest data.

  In order to solve the above problems, a service providing system according to claim 1 includes a database server for storing data, a service providing server for providing a service using the data, and an operation system for operating the database server. In the service providing system, the operation system includes means for transmitting the recovery schedule data information indicating the recovery schedule data to be restored to the database server, and after transmitting the recovery schedule data information, Means for transmitting differential data for updating to the database server, the database server corresponding to the data indicated by the planned recovery data information among a plurality of data recovered using backup data Set recovery identifier indicating recovery in progress Means for canceling the setting of the restoring identifier after receiving the difference data, and if the restoring identifier is set in the data requested from the service providing server, the restoring identifier is assigned to the service Means for transmitting to the providing server and transmitting only the data when the setting of the recovering identifier is canceled, and the service providing server repeatedly requests data until the recovering identifier is no longer assigned. And a means for determining whether or not the data should be used based on the presence or absence of the restoring identifier after receiving the data from the database server.

  The data recovery method according to claim 2 is a data recovery method performed by a database server for storing data, a service providing server for providing a service using the data, and an operation system for operating the database server. And a step of transmitting the recovery schedule data information indicating the recovery schedule data to be restored to the database server by the operation system, and the recovery schedule among the plurality of data restored by using the backup data by the database server Setting a recovery-in-progress identifier indicating that the data indicated by the data information is being recovered, and requesting data by the service providing server, and providing the service by the database server The data requested from the server If the recovery-in-progress identifier is set, the step of giving the recovery-in-progress identifier and transmitting to the service providing server, and after receiving data from the database server by the service providing server, Determining whether it is necessary to use the data based on the presence or absence of the recovery-in-service identifier, and transmitting, by the operation system, differential data for updating the recovery-scheduled data to the database server. And canceling the setting of the restoring identifier after receiving the difference data by the database server, and repeatedly requesting data until the restoring identifier is no longer given by the service providing server. And identifying during recovery by the database server If the setting of is released and summarized in that a step, which transmits only data to the service providing server.

  According to the present invention, it is possible to handle the availability of data on the service providing server side and to enable an autonomous operation until the data is restored to the latest data.

It is a figure which shows the functional block structure of DB server. It is a figure which shows the functional block structure of a service provision server. It is a figure which shows the functional block structure of an operation system. It is a sequence diagram which shows the processing flow at the time of a severe disaster occurrence. It is a figure referred at the time of description of FIG. It is a figure which shows the whole structure of a service provision system. It is a figure which shows the conventional operation | movement image at the time of a severe disaster occurrence.

  Hereinafter, an embodiment for carrying out the present invention will be described with reference to the drawings.

  As shown in FIG. 6, the service providing system according to the present embodiment operates a DB server 100 that stores data, a service providing server 200 that provides a service using the data, and the DB server 100. The operation system 300 is configured.

  FIG. 1 is a diagram showing a functional block configuration of the DB server 100 according to the present embodiment. The DB server 100 includes a backup file storage unit 11 that stores a backup file of data, a first recovery unit 12 that recovers data using the backup file, and a server that manages a data recovery state in the DB server 100 A state management unit 13, a flag setting unit 14 for assigning / non-assigning a restoration schedule flag to the data scheduled to be updated to the latest state, a second restoration unit 15 for updating the data to the latest state with difference data from the latest data, And a data transmission unit 16 for transmitting data.

  FIG. 2 is a diagram showing a functional block configuration of the service providing server 200 according to the present embodiment. The service providing server 200 includes a data request unit 21 that requests data relating to the provided service, a data use necessity determination unit 22 that determines whether or not the received data is necessary based on the presence or absence of a recovery flag attached to the data, , And is configured.

  FIG. 3 is a diagram showing a functional block configuration of the operation system 300 according to the present embodiment. The operation system 300 includes a data list transmission unit 31 that transmits a data list to be restored and a data transmission unit 32 that transmits difference data from the latest data.

  Next, an operation (data recovery method) when a severe disaster occurs in the service providing system 1 according to the present embodiment will be described. FIG. 4 is a sequence diagram showing a processing flow when a severe disaster occurs. FIG. 5 is a diagram referred to when explaining the processing flow.

  First, in step S <b> 1, the first restoration unit 12 of the DB server 100 restores data using the backup file read from the backup file storage unit 11.

  Next, in step S <b> 2, the server state management unit 13 of the DB server 100 automatically transitions the server state of the DB server 100 to the recovering state after the data is recovered with the backup file.

  Subsequently, in step S3, the data list transmission unit 31 of the operation system 300 transmits the data list to be restored before retransmitting the difference data from the latest data to the DB server 100. In this recovery schedule data list, information on data updated between the time of backup and the present time is described.

  Thereafter, in step S4, the flag setting unit 14 of the DB server 100 detects data matching the data in the recovery scheduled data list from the plurality of data recovered in step S1, and assigns a recovery schedule flag to the detected data. .

  When a data request signal is transmitted from the data request unit 21 of the service providing server 200 after step S4, the data transmission unit 16 of the DB server 100 adds a recovery schedule flag to the requested data in step S5. If so, send a recovery flag.

  Thereafter, in step S6, the data use necessity determination unit 22 of the service providing server 200 refers to the data transmitted from the DB server 100, and the data is determined based on whether or not a recovery flag is assigned to the data. Determine whether or not to use.

  If the service providing server 200 is a server that always uses only the latest data, it is determined that the received data is not used. In step S7, the data requesting unit 21 of the service providing server 200 The data request signal is repeatedly transmitted to the DB server 100 until is no longer given.

  After that, when difference data (difference data relating to data included in the recovery scheduled data list) is transmitted from the data transmission unit 32 of the operation system 300 in step S8, the flag setting unit 14 of the DB server 100 in step S9 Then, the setting of the recovery schedule flag is canceled, and the second recovery unit 15 of the DB server 100 updates the data recovered in step S1 to the latest state using the received difference data.

  Thereafter, in step S10, the server state management unit 13 of the DB server 100 automatically transitions the server state of the DB server 100 to the recovery completion state. If there is a data request signal from the service providing server 200, the DB server 100 in step S11. The data transmission unit 16 100 transmits the latest data updated in step S9. At this time, since the setting of the recovery schedule flag is cancelled, only the data is transmitted without attaching the recovery in progress flag.

  Thereafter, the service providing server 200 provides a service corresponding to the data request from the terminal device 3 using the received latest data. In step S6, if the service providing server 200 is a server to be used even if it is past data, the service is provided using the data with the recovery schedule flag as it is.

  As described above, according to the present embodiment, the operation system 300 transmits the recovery schedule data list to the DB server 100, and the DB server 100 uses the recovery schedule data list among a plurality of data recovered using the backup data. A restoration schedule flag is assigned to the indicated data, and when the restoration schedule flag is assigned to the data requested from the service providing server 200, a restoration in progress flag is assigned and transmitted, and the service providing server 200 Because it determines the necessity of using the received data based on the presence or absence of the recovery flag, and repeatedly requests data until the recovery flag is no longer given, the service providing server can handle the availability of data and the latest Autonomous operation can be enabled until data is restored.

  Finally, the DB server 100, the service providing server 200, and the operation system 300 described in the present embodiment can be realized by a computer including a memory and a CPU. Also, each of these operations can be constructed as a program, installed in a computer and executed, or distributed via a communication network.

DESCRIPTION OF SYMBOLS 1 ... Service provision system 3 ... Terminal device 100 ... DB server (database server)
DESCRIPTION OF SYMBOLS 11 ... Backup file memory | storage part 12 ... 1st recovery part 13 ... Server state management part 14 ... Flag setting part 15 ... 2nd recovery part 16 ... Data transmission part 200 ... Service provision server 21 ... Data request part 22 ... Data use Necessity determination unit 300 ... operation system 31 ... data list transmission unit 32 ... data transmission unit S1 to S11 ... step

Claims (2)

In a service providing system comprising a database server for storing data, a service providing server for providing a service using the data, and an operation system for operating the database server,
The operation system includes:
Means for transmitting recovery schedule data information indicating recovery schedule data to be restored to the database server;
Means for transmitting difference data for updating the recovery schedule data to the database server after transmitting the recovery schedule data information;
The database server is
Of the plurality of data recovered using backup data, a recovery identifier indicating recovery is set for the data indicated by the recovery planned data information, and the recovery identifier is set after receiving the differential data. Means to cancel,
When the recovery request identifier is set in the data requested from the service providing server, the recovery target identifier is assigned and transmitted to the service providing server, and the recovery identifier setting is canceled Has means for transmitting only data,
The service providing server includes:
Means for repeatedly requesting data until no identifier is given during recovery;
Means for determining whether it is necessary to use the data based on the presence or absence of the restoring identifier after receiving data from the database server;
A service providing system comprising: In a data recovery method performed by a database server for storing data, a service providing server for providing a service using the data, and an operation system for operating the database server,
By the operation system,
Transmitting recovery schedule data information indicating the recovery schedule data to be restored to the database server,
By the database server,
Setting a recovery-indicating identifier indicating that recovery is being performed on the data indicated by the recovery-scheduled data information among a plurality of data recovered using backup data,
By the service providing server,
Requesting data, and
By the database server,
When the recovery identifier is set in the data requested from the service providing server, the recovery providing identifier is assigned and transmitted to the service providing server,
By the service providing server,
After receiving data from the database server, determining whether it is necessary to use the data based on the presence or absence of the recovery identifier,
By the operation system,
Transmitting difference data for updating the recovery schedule data to the database server,
By the database server,
Removing the setting of the restoring identifier after receiving the difference data,
By the service providing server,
Repeatedly requesting data until the recovery identifier is no longer given,
By the database server,
A step of transmitting only data to the service providing server when the setting of the restoring identifier is canceled;
A data recovery method comprising:

Images