Database control method, database control apparatus, and recording medium

Patent metadata

Field	Value
Publication number	US-2018025017-A1
Application number	US-201715629965-A
Country	US
Kind code	A1
Filing date	Jun 22, 2017
Priority date	Jul 25, 2016
Publication date	Jan 25, 2018
Grant date	—

Abstract

A database control method includes generating a second database in which recorded contents of a first database are copied, when detecting an update program for updating a first control program configured to control the first database set as a transmission destination of a request for processing transmitted by a terminal apparatus; generating a second control program by updating the first control program using the update program; setting the transmission destination to both the first database and the second database; executing the processing on the first database using the first control program; executing the processing on the second database using the second control program; setting the transmission destination to the second database when a first result of the processing on the first database and a second result of the processing on the second database match; and executing processing on the second database using the second control program when receiving the request.

First claim

What is claimed is:

1 . A database control method executed by a processor included in a control apparatus coupled to a terminal apparatus, the database control method comprising:
generating a second database in which recorded contents of a first database are copied, when detecting an update program used to update a first control program configured to control the first database set as a transmission destination of a request for processing transmitted by the terminal apparatus; generating a second control program by updating the first control program using the update program; setting the transmission destination of the request to both the first database and the second database; executing the processing on the first database using the first control program; executing the processing on the second database using the second control program; setting the transmission destination to only the second database among the first database and the second database when a first result of the processing on the first database and a second result of the processing on the second database match; and executing processing on the second database using the second control program when receiving the request from the terminal apparatus.

2 . The database control method according to claim 1 , wherein
the first result includes first time information indicating a time when the first result is obtained, and a first value of the first result, and the second result includes second time information indicating a time when the second result is obtained, and a second value of the second result, wherein the database control method further comprising
executing processing of matching up the second time information with the first time information when the first time information and the second time information differ.

3 . The database control method according to claim 2 , wherein the executing processing of matching the second time information with the first time information includes:
specifying a first time included in first log information, and a second time included in second log information and is the same as the first time, by referring to the first log information indicating a history of operation of the first database and includes the first time information, and to the second log information indicating a history of operation of the second database and includes the second time information, and determining whether the first result and the second result match by comparing a result corresponding to the first time included in the first result and a result corresponding to the second time included in the second result.

4 . The database control method according to claim 1 ,
wherein the setting the transmission destination to only the second database includes deleting the first database.

5 . The database control method according to claim 1 , further comprising
deleting the second database when the first result of the processing on the first database and the second result of the processing on the second database do not match.

6 . The database control method according to claim 1 , further comprising
outputting a result of comparing the first result of the processing on the first database and the second result of the processing on the second database.

7 . The database control method according to claim 6 ,
wherein the outputting includes outputting a message, which notifies of replacing the first database with the second database when the first result of the processing on the first database and the second result of the processing on the second database match.

8 . The database control method according to claim 6 ,
wherein the outputting includes outputting a message, which requests for cancellation of application of the update program when the first result of the processing on the first database and the second result of the processing on the second database do not match.

9 . A control apparatus, comprising:
a memory; and a processor coupled to the memory and configured to:
generate a second database in which recorded contents of a first database are copied, when detecting an update program used to update a first control program configured to control the first database set as a transmission destination of a request for processing transmitted by a terminal apparatus,
generate a second control program by updating the first control program using the update program,
set the transmission destination of the request to both the first database and the second database,
execute the processing on the first database using the first control program,
execute the processing on the second database using the second control program,
set the transmission destination to only the second database among the first database and the second database, when a first result of the processing on the first database and a second result of the processing on the second database match, and
execute processing on the second database using the second control program when receiving the request from the terminal apparatus.

10 . A non-transitory computer-readable recording medium storing a program that causes a processor included in a control apparatus coupled to a terminal apparatus to execute a process, the process comprising:
generating a second database in which a recorded content of a first database are copied, when detecting an update program used to update a first control program configured to control the first database set as a transmission destination of a request for processing transmitted by the terminal apparatus; generating a second control program by updating the first control program using the update program; setting the transmission destination of the request to both the first database and the second database; executing the processing on the first database using the first control program; executing the processing on the second database using the second control program; setting the transmission destination to only the second database among the first database and the second database, when a first result of the processing on the first database and a second result of the processing on the second database match; and executing processing on the second database using the second control program when receiving the request from the terminal apparatus.

Assignees

• Fujitsu Ltd

Inventors

• Sugizaki Takashi
• Takeuchi Susumu
• Tanaka Yuta
• Magome Shigeto
• Kobune Hiroyuki

Classifications

• G06F16/162

  Delete operations (erasing in storage systems G06F3/0652) · CPC title

• G06F16/1734 Primary

  Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs · CPC title

• G06F16/489

  using time information · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title