JPH11175385A - Method for data inquiry and update in distributed data base environment - Google Patents

Abstract

PROBLEM TO BE SOLVED: To immediately inquire information of a host data base from a distributed processing computer and to performs an update process in a short time by copying information of the host data base and generating a local data base, and reflecting update information from the distributed process computer on the local data base. SOLUTION: An authentication inquiry process 4 performs retrieval from an inquiry information data base 8 as the local data base. A contract changing process 5 registers update information in an update process registration queue 9 according to information for a contract change. A local data base update process 10 reads in the update process registration queue 9 at constant intervals of time and updates the inquiry information data base 8 according to the update information in an unprocessed registration queue. An on-line user program 11 also performs a process similarly to the local data base update process 10 to update an inquiry information data base 14 as a host data base.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to querying and updating a host database for voice response processing on a distributed processing computer.

[0002]

2. Description of the Related Art Conventionally, as a technique for inquiring or updating a host database from a distributed processing computer, a method realized by file transfer between the host computer and the distributed computer and a distributed database function supported by a database management system are used. There is a method of realizing the method, a method of realizing a communication function between a host computer and a distributed computer via a common network protocol, and the like.

In the file transfer method, information required for an inquiry is extracted from a host database and transferred to a distributed computer. On the distributed processing computer side, the contents of the host database can be queried by updating the local database based on the received file.
The information updated in the local database is transferred to a host computer as a file, and the host computer receives the information and updates the host database based on the received information.

[0004] The distributed database function supported by the database management system usually differs between the database management system on the host computer and the database management system on the distributed processing computer. Only can be realized.

A method for realizing a communication function between a host computer and a distributed computer via a common network protocol is a program on the host computer and a program on a distributed processing computer.
Communication is performed by CP / IP, and queries and updates of the respective databases are performed by the respective programs.

[0006]

However, in the method using file transfer, in order to refer to the host database, it is necessary to transfer all data other than the data necessary for reference to the local database and update the data. Heavier. Also, when updating from a distributed processing computer, the time difference between updating the local database and the host database becomes large.

Further, the distributed database function supported by the database management system cannot be realized unless the database management system on the host computer and the database management system on the distributed processing computer have a common interface for performing distributed processing.

Further, a method of realizing a communication function between a host computer and a distributed computer via a common network protocol cannot be easily realized because communication processing and referencing and updating of a database are created by a user program. There is.

[0009] An object of the present invention is to immediately query information of a host database from a distributed processing computer,
An object of the present invention is to provide a method capable of easily realizing an update process in a short time.

[0010]

In order to achieve the above object, the present invention provides a local database created by copying information of a host database existing in a host computer and updating information from a distributed processing computer locally. By reflecting the information in the database, the information corresponding to the query is held, and by inquiring the local database, a result almost equal to that in the case of querying the information in the host database can be obtained.

Further, according to the present invention, update information relating to an inquiry is registered in an update processing registration queue, and based on information in the update processing registration queue, a local database is updated and an online user program on a host computer is updated. Is used to update the host database of the host computer.

[0012]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a system configuration diagram showing an embodiment of the present invention.

This system comprises a voice response device 1, a distributed processing computer 2, a host computer 12, an inquiry information database 8 positioned as a local database, an update processing registration queue 9, and an inquiry database 14 positioned as a host database. Has become.

The distributed processing computer 2 performs communication processing 3
Authentication inquiry processing 4, contract change processing 5, mainframe GateWay processing 6, file transfer / database update processing 7, and local database update processing 10.
And an online user program 11.

The host computer 12 has an online update program 13.

The communication processing 3 has a communication function for exchanging information with the voice response processing device 1. The communication processing 3 receives inquiry information and information for changing a contract, and transmits a response of the processing result to a voice response. The information is exchanged with the apparatus, and the inquiry information is passed to the authentication inquiry processing 4 and the information for contract change is passed to the contract change processing 5. The authentication inquiry processing 4 includes the voice response processing device 1
Based on the inquiry information received from, the inquiry information database 8 which is a local database is searched, and the processing result is passed to the voice response processing device 1 via the communication process 3. The contract change processing 5 registers update information in the update processing registration queue 9 based on the information for contract change received from the voice response processing device 1.

The update process registration queue 9 is as shown in FIG. 2, and includes voice response management information for identifying a request from the voice response processing device, a function code for identifying the update content, and an authentication inquiry. From the authentication information for storing the contents received in the processing 4, the contract information 1 to n to be changed, the processing status for storing the update results of the local database and the host database, and the error information for storing the contents of the error that occurred during the update. Become.

The main frame GateWay processing 6 is as follows.
An online user program generally used in a mainframe computer is realized in a distributed environment, and is provided on a server machine. The online user program 11 is a mainframe GateW
An instruction for reference and update is issued via the ay process 6, and the host database 14 is actually updated by the online update program 13 in the host computer 12.

The local database update processing 10 and the online user program 11 operate asynchronously with the authentication inquiry processing 4 and the contract change processing 5 so that the response time of the exchange with the voice response processing device 1 is not affected. It is devised. The local database update process 10 reads the update process registration queue 9 at regular time intervals, and updates the query information database 8 as a local database based on the update information of the unprocessed registration queue. Similarly to the local database update process 10, the online user program 11 reads the update process registration queue 9 at regular time intervals,
The query information database 14, which is a host database, is updated based on the update information of the unprocessed registration queue.

File transfer / database update processing 7
Extracts the content updated by the host computer from the query information database 14 as the host database, transfers the updated content to the distributed processing computer 2 by the file transfer function, and reflects the updated information in the query information database 8 as the local database.

Next, an outline of a processing procedure from receipt of an inquiry from the voice response apparatus to registration of update processing will be described. FIG. 3 is a flowchart showing an outline of a processing procedure from reception of an inquiry from the voice response apparatus to registration of update processing.

In FIG. 3, first, authentication information is received from the voice response device (step 21), the authentication information is queried in a local database, and it is checked whether the contract change processing can be performed (step 22). The result of the check is transmitted to the voice response device (step 23). Thereafter, if the contract change can be performed, the contract change information is registered in the update processing registration queue 9 (steps 24 and 2).
5) If the contract must not be changed, nothing is done and the process ends (step 24).

Next, an outline of a procedure for updating the information registered in the update processing registration queue 9 to the local database and the host database will be described. FIG. 4 is a flowchart showing an outline of a procedure for updating the information registered in the update processing registration queue 9 to the local database and the host database.

In FIG. 4, first, contract change information is extracted from the update processing registration queue 9 (step 3).
1) The contract contents on the local database are changed (step 10), the online user program is started (step 32), the contract contents on the host database are also changed (step 33), and the local database is changed. If an error occurs due to the change or the change of the host database (step 34), error information is output (step 35). If you are changing your contract on both the distributed and host computers,
Since an error may occur due to a difference in update timing, information for recovery is output to this error information.

[0026]

According to the present invention, like the voice response processing,
In a system in which an immediate response is required, a response can be made only to a local database inquiry process even for a request process involving an update to the host database.

Further, if there is an environment capable of executing a mainframe online program, a system that can easily access information in the host database can be constructed without a distributed database management system.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram for performing voice response processing according to an embodiment of the present invention.

FIG. 2 is an explanatory diagram for explaining a schematic configuration of an update processing registration queue.

FIG. 3 is a flowchart showing an outline of a processing procedure from reception of an inquiry from the voice response device to registration of an update process.

FIG. 4 is a flowchart showing an outline of a procedure for updating information registered in an update processing registration queue into a local database and a host database.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Voice response processing apparatus, 2 ... Distributed processing computer, 3 ... Communication processing, 4 ... Authentication inquiry processing, 5 ... Contract change processing, 6 ... Mainframe GateWay processing, 7 ... File transfer / database update processing, 8 ... Inquiry information Database (local database), 9: update processing registration queue, 10: local database update processing, 11: online user program, 12: host computer, 13: online update program, 14: inquiry information database (host database).

Claims (1)

[Claims] An inquiry is made to information of a local database stored in a distributed processing computer which is created by copying information of a host database existing in a host computer, responding to an inquiry to the distributed processing computer, and updating information relating to the inquiry. Is registered in the update registration queue,
Updating the local database based on the information in the update registration queue asynchronously and updating the host database of the host computer using an online user program on the host computer in a distributed database environment Method.