JPH07253948A - Transaction service mode switching system - Google Patents

Abstract

PURPOSE:To offer reference system transaction service completely at a high speed even not in a reference and update system transaction service time zone. CONSTITUTION:When a host computer 1 updates a data base 11 by a data base reference and update means 12, an updated transaction acquisition means 13 stores updated transaction information in an updated transaction storage file 14. After the reference and update system transaction service ends, an updated transaction transmitting means 15 sends the updated transaction information in the updated transaction storage file 14 to a backup computer 2. Once receiving the updated transaction information, an updated transaction receiving means 22 stores it in an updated transaction storage file 23. A backup data base update means 24 updates a backup data base 21 with the updated transaction information in the updated transaction storage file 23.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a business service form switching system, and more particularly to a reference / update system business in which a database is provided in a host computer and the database is referenced and updated based on a reference request and an update request from a terminal device. The present invention relates to a business service form switching method in an online transaction processing system operated in a service time zone and a reference business service time zone that only refers to a database based on a reference request from a terminal device.

[0002]

2. Description of the Related Art A conventional online transaction processing system, as shown in FIG.
01 to the terminal device 103 via the communication network 104. The host computer 101 includes a database 111 and database reference / update means 112.
And the update transaction transmission means 113, and the terminal device 103 includes the backup database 13
1, the process switching unit 132, the backup database reference unit 133, and the backup database updating unit 134.

In such a conventional online transaction processing system, the database reference / update means 112 is used for the database 111 of the host computer 101.
The update transaction information updated by means of the update transaction transmitting means 113 is transmitted to the terminal device 103, and the backup database updating means 134 updates the backup database 131 so that the contents of the database 111 and the contents of the backup database 131 match. After the end of the reference / update-related business service time zone of the database 111 of the host computer 101, the backup database 13 by the backup database reference means 133 of the terminal device 103.
They provided reference-related business services such as information inquiries and book prints only by referring to 2.

[0004]

In the above-described conventional online transaction processing system, since the backup database 131 is provided in the terminal device 103, the same contents are stored in the backup database 131 when the data capacity of the database 111 becomes large. There is a problem in that the terminal device 103 cannot provide a perfect reference-type business service because it cannot be held.

The backup database 131 has a complicated structure due to the unique structure of the terminal device 103, and in particular, since the processing capacity of the terminal device 103 is inferior to that of the host computer 101, it is updated when the update transaction information becomes large. There is a problem that the processing time becomes long.

Further, since the reference-related business service by the terminal device 103 can be used only by the terminal device 103 having a backup function such as the backup database 131, when the reference-related business service is performed by a plurality of terminal devices 103, each terminal device 103 There is a problem that the device 103 needs a backup function.

On the other hand, in order to provide a complete and high-speed reference-related business service, the operating time of the host computer 101 may be extended, but the large-sized host computer 1
In the case of 01, the operation cost is high, and even if only a part of the function of the host computer 101 is used, it is necessary to operate the entire computer system, resulting in a large cost burden.

In view of the above points, an object of the present invention is to have a backup database having the same contents as the database of the host computer in another computer (hereinafter referred to as a backup computer) that is operating even during the reference system service time period. Therefore, it is to provide a business service form switching method capable of performing a reference business service completely and rapidly even outside the reference / update business service time zone.

It is another object of the present invention to provide a business service form switching method that enables a reference business service outside the reference / update business service time zone by using a terminal device having no backup function.

Further, a business service form switching method capable of performing the reference business service perfectly and rapidly even outside the reference / update business service time zone without increasing the operation cost of the online transaction processing system. To provide.

As a prior art, a distributed processing method in an inquiry response type information service system (Japanese Patent Laid-Open No. 4-3).
In this distributed processing method, the distributed information database of the relay device (including the terminal with the distributed processing function) is pre-populated with information of a type frequently inquired from the information database of the host computer. In response to an inquiry from the terminal received and held, if there is information of the type in the held information, that information is returned to the terminal, otherwise the inquiry is sent to the host computer. However, unlike the present invention, the processing is not divided into different computers and divided by the business service time zone.

[0012]

A business service form switching system of the present invention comprises a database in a host computer, and a reference / update system for referring and updating a database based on a reference request and an update request from a terminal device. In an online transaction processing system operated in a business service time zone and a reference business service time zone that only refers to a database based on a reference request from a terminal device, the online transaction processing system is also operated in the reference business service time zone. A backup computer is connected to the host computer and the terminal device via a communication path, and the host computer refers to the database based on a reference request from the terminal device or based on an update request from the terminal device. Database reference / update means for updating the database The backup computer includes update transaction acquisition means for extracting update transaction information of the database when updating the database, and update transaction transmission means for transmitting the update transaction information extracted by the update transaction acquisition means to the backup computer. A backup database holding a copy of the database, an update transaction receiving means for receiving update transaction information transmitted from the host computer, and the backup database by the update transaction information received by the update transaction receiving means. The backup database updating means for updating and the backup request based on the reference request input from the terminal device. And a backup database reference means for referring to the up database.

Further, the business service form switching method of the present invention comprises a database in the host computer, and a reference / update system business service time zone in which the database is referenced and updated based on a reference request and an update request from the terminal device. In an online transaction processing system operated in the reference business service time zone that only refers to the database based on the reference request from
A backup computer, which operates even during the reference-related business service hours, is connected to the host computer and the terminal device via a communication path, and the host computer is referred to the database based on a reference request from the terminal device. Or a database reference / update means for updating the database based on an update request from the terminal device, an update transaction acquisition means for extracting update transaction information of the database when updating the database, and an update transaction acquisition means And an update transaction storing file for storing the update transaction information fetched by the update transaction information transmitting the update transaction information stored in the update transaction storage file to the backup computer. Backup database for holding a copy of the database in the backup computer, update transaction receiving means for receiving update transaction information transmitted from the host computer, and the update transaction receiving means. An update transaction storage file that stores the received update transaction information, a backup database updating unit that updates the backup database with the update transaction information of the update transaction storage file, and the backup based on a reference request from the terminal device. Backup database reference means for referring to the database.

[0014]

The present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a business service form switching system according to an embodiment of the present invention. The business service form switching method of this embodiment includes a database 11 in the host computer 1, and refers to and updates the database 11 based on a reference request and an update request sent from the terminal device 3 via the communication network 4. In the online transaction processing system to be carried out, the backup computer 2 which is in operation even after the reference / update business service period of the host computer 1 is terminated is connected to the host computer 1 and the terminal device 3 through the leased line 5 and the line network 4. Is configured. The backup computer 2 and the host computer 1 may be connected via the line network 4 instead of the dedicated line 5.

The host computer 1 refers to the database 11 based on the reference request input from the terminal device 3 or updates the database 11 based on the update request input from the terminal device 3. Update means 12 and database 1 when updating database 11
1. Update transaction acquisition unit 13 for extracting the update transaction information of No. 1, update transaction storage file 14 for storing the update transaction information extracted by the update transaction acquisition unit 13, and backup of the update transaction information stored in the update transaction storage file 14. An update transaction transmitting means 15 for transmitting to the computer 2 and a host computer control terminal device 16 are provided.

The backup computer 2 has a backup database 21 for holding a copy of the database 11 of the host computer 1, an update transaction receiving means 22 for receiving the update transaction information transmitted from the host computer 1, and an update transaction receiving means 22. The update transaction storage file 23 for storing the update transaction information received by the backup database update means 24 for updating the backup database 21 with the update transaction information in the update transaction storage file 23.
A backup database reference means 25 for referring to the contents of the backup database 21 based on a reference request input from the terminal device 3, and a backup computer control terminal device 26. The backup computer 2 is preferably compatible with the host computer 1. In this way, the software of the host computer 1 (in particular, the reference procedure part of the database) can be diverted to the backup computer 2. Has the advantage of being easy to create software. In addition, the backup computer 2
It is preferable that the processes other than the reference business service are processed in parallel for a long time so that new operating costs are not incurred.

The terminal device 3 includes a computer selecting means 31 for selecting whether the terminal device 3 is connected to the host computer 1 or the backup computer 2, an input device 32, a display device 33, and a printing device 34. I have it.

Referring to FIG. 2, the processing of the update transaction acquisition means 13 is the update presence / absence determining step S131.
And an update transaction acquisition step S132 and an update transaction information writing step S133.

Referring to FIG. 3, the processing of the update transaction transmitting means 15 is the transmission instruction determination step S151.
And update transaction information reading step S152
And update transaction information end determination step S15
3 and update transaction information transmission step S154
Consists of.

Referring to FIG. 4, the processing of the update transaction receiving means 22 includes an update transaction information receiving step S221, an update transaction information end determination step S222, and an update transaction information writing step S223.

Referring to FIG. 5, the processing of the backup database updating means 24 includes an update instruction presence / absence determining step S241, an update transaction information reading step S242, an update transaction information end determining step S243, and a backup database updating step S244. Become.

Next, the operation of the business service mode switching system of the present embodiment thus configured will be described.

In the reference / update business service time zone, the operator of the terminal device 3 selects the host computer 1 by the computer selection means 31. As a result, the terminal device 3 and the host computer 1 are logically connected.

When the operator inputs a reference request from the input device 32 of the terminal device 3, the reference request is transmitted to the host computer 1 via the line network 4 to refer to the database.
The database 11 is referred to by the updating unit 12, the reference data is returned to the terminal device 3, and is displayed on the display device 33 or printed on the printing device 34.

When the operator inputs an update request from the input device 32 of the terminal device 3, the update request is transmitted to the host computer 1 via the line network 4, and the database reference / update means 12 updates the database 11. . At this time, the update transaction acquisition means 13
It is monitored whether or not the database 11 has been updated (step S131). If the database 11 is updated, the updated record of the database 11 is acquired as an update transaction (step S132), and file type information and the like are added. It is stored in the update transaction storage file 14 as update transaction information (step S133).

When the reference / update system business service time period ends, the operator of the host computer 1 inputs a transmission instruction of update transaction information from the host computer control terminal device 16.

Upon receiving the instruction to transmit the update transaction information (YES in step S151), the update transaction transmitting means 15 reads the update transaction information from the update transaction storage file 14 (step S152) and backs up via the dedicated line 5. Process of transmitting to computer 2 (step S154)
When the update transaction information ends (YES in step S153), the process ends.

When the transmission of the update transaction information is completed, the operator of the host computer 1 operates from the host computer control terminal device 16 to the host computer 1
Stop running.

On the other hand, in the backup computer 2,
The update transaction receiving means 22 receives the update transaction information from the host computer 1 (step S221), and the update transaction storage file 2
3 is repeated (step S223), and when the update transaction information ends (step S22)
If the answer is 2, the process ends.

When the reception of the update transaction information is completed, the operator of the backup computer 2 inputs an instruction to update the backup database 21 from the backup computer control terminal device 26.

Backup database updating means 24
Receives the update instruction for the backup database 21 (YES in step S241), reads the update transaction information from the update transaction storage file 23 (step S242), and repeats the process of updating the backup database 21 (step S244). When the information ends (Yes in step S243), the process ends.

As described above, the contents of the database 11 of the host computer 1 and the contents of the backup database 21 of the backup computer 2 match.

Immediately after the start of the reference-related business service time zone,
The operator of the terminal device 3 uses the computer selection means 31.
The backup computer 2 is selected by. As a result, the terminal device 3 and the backup computer 2 are logically connected.

During the reference-related business service time zone, only the reference-related business service that does not involve updating the backup database 21 can be selected from the menu of the reference / update-related business service. When the operator makes a reference request from the input device 32 of the terminal device 3, the reference request is transmitted to the backup computer 2 via the line network 4, the backup database reference means 25 refers to the backup database 21, and the reference data is referred to as the terminal device. It is returned to the printer 3 and displayed on the display device 33 or printed on the printing device 34.

A method of updating the backup database 21 with the update transaction information will be described with reference to FIG. In the host computer 1, when the database reference / update means 12 updates the record # 3 of the file a and the record # 2 of the file b in the database 11, the update transaction acquisition means 13
Outputs the updated records # 3 and # 2 to which the file type information a and b are added as update transaction information to the update transaction storage file 14. The update transaction information is transferred to the backup computer 2 by the update transaction sending means 15.
And is stored in the update transaction storage file 23 by the update transaction receiving means 22 of the backup computer 2. The backup database updating means 24 reads the update transaction information from the update transaction storage file 23, and from the added file type information a and b, the file a in which the records # 3 and # 2 to be updated in the backup database 21 are stored. b is determined, the updated records # 3 and # 2 are read from the respective files a and b, and the records # 3 and # 2 of the update transaction information are updated.

As an example of application of the business service form switching method of the present embodiment, there is a resident recording system of a local government.
The Resident Record System stores information on residents in the database based on the Basic Resident Register Act, updates the database by notification of changes such as moving out or moving, and edits and issues the resident card from the database in response to the request of the residents. It is a system that does.

[0038] In the local government, all reference / update-related business services including reference and update of the database such as issuance of resident's card, acceptance of transfer notification, etc. are performed in response to requests such as introduction of two days off weekly and improvement of resident services. There has been a discrepancy between the reference / update-related business service time zone and the reference-related business service time zone in which the reference-related business service is performed only by referring to the database such as issuance of a residence certificate. The reference / update related business service time zone is usually from 9:00 to 17:00 on Monday to Friday (weekdays), while the reference related business service time zone includes Saturdays and weekdays after 17:00.

Therefore, when the business service form switching method of this embodiment is introduced, the reference / update system business service such as issuance of a resident's card and acceptance of a transfer notification is performed by the host computer 1 during the reference / update system service time zone. , The database 11 is updated. The information updated by the transfer is also reflected in the backup database 25 of the backup computer 2. After 17:00 on weekdays and on Saturdays,
The backup computer 2 provides only reference-related business services such as issuance of a resident card.

In the above embodiment, the host computer 1 sends the update transaction information all at once to the backup computer 2 immediately after the end of the reference / update related business service time zone, and the backup computer 2 also uses the update transaction information based on the update transaction information. Although the back database 21 is collectively updated by the backup computer 21, the update database is sent from the host computer 1 to the backup computer 2 each time it occurs, and the backup database is also sent every time the update transaction information is sent to the backup computer 2. 21
May be updated. This has the advantage that the update transaction storage file 14 in the host computer 1 and the update transaction storage file 23 in the backup computer 2 become unnecessary.

[0041]

As described above, according to the present invention, the backup computer is connected to the host computer and the terminal device via the communication path, and the host computer is provided with the database reference / update means, the update transaction acquisition means and the update transaction transmission means. By providing the backup computer with the backup database, the update transaction receiving means, the backup database updating means, and the backup database reference means, the reference / updating business service can be completely and quickly performed outside the reference / update business service time zone. The effect is that it can be done.

Further, there is an effect that the reference business service can be provided outside the reference / update business service time zone by using the terminal device having no backup function.

Furthermore, by using a computer that performs parallel processing of processes other than the reference business service as the backup computer, the operating time of the host computer can be shortened and online transaction processing can be performed without activating a new backup computer. This has the effect of reducing the operating cost of the system as a whole.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a business service form switching system according to an embodiment of the present invention.

FIG. 2 is a flowchart showing a process of an update transaction acquisition unit in FIG.

FIG. 3 is a flow chart showing a process of an update transaction transmitting means in FIG.

FIG. 4 is a flowchart showing a process of an update transaction receiving means in FIG.

5 is a flowchart showing a process of a backup database updating unit in FIG. 1. FIG.

FIG. 6 is a diagram illustrating an example of a backup database update procedure in the business service mode switching method according to the embodiment.

FIG. 7 is a block diagram showing an example of a conventional business service form switching system.

[Explanation of symbols]

 1 Host Computer 2 Backup Computer 3 Terminal Device 4 Communication Network (Communication Route) 5 Dedicated Line (Communication Route) 11 Database 12 Database Reference / Update Means 13 Update Transaction Acquisition Means 14 Update Transaction Storage File 15 Update Transaction Sending Means 16 Host Computer Control Terminal device 21 Backup database 22 Update transaction receiving means 23 Update transaction storage file 24 Backup database updating means 25 Backup database reference means 26 Backup computer control terminal device 31 Computer selecting means 32 Input device 33 Display device 34 Printing device

Claims (4)

[Claims] 1. A host computer is provided with a database, and based on a reference / update business service time zone for referring and updating the database based on a reference request and an update request from the terminal device, and a reference request from the terminal device. In an online transaction processing system operated in a reference business service time zone that only refers to a database, a backup computer that is also operated in the reference business service time zone is connected to the host computer and the terminal device via a communication path. Connected to the host computer, database reference / update means for referring to the database based on a reference request from a terminal device or updating the database based on an update request from the terminal device, Update the database when updating the database Update transaction acquisition means for extracting transaction information and update transaction transmission means for transmitting the update transaction information extracted by the update transaction acquisition means to the backup computer are provided, and a copy of the database is retained in the backup computer. A backup database, update transaction receiving means for receiving update transaction information transmitted from the host computer, backup database updating means for updating the backup database with the update transaction information received by the update transaction receiving means,
A business service form switching method comprising: a backup database reference means for referring to the backup database based on a reference request input from a terminal device. 2. A host computer is provided with a database, and based on a reference / update-related business service time zone for referring and updating the database based on a reference request and an update request from the terminal device, and a reference request from the terminal device. In an online transaction processing system operated in a reference business service time zone that only refers to a database, a backup computer that is also operated in the reference business service time zone is connected to the host computer and the terminal device via a communication path. Connected to the host computer, database reference / update means for referring to the database based on a reference request from a terminal device or updating the database based on an update request from the terminal device, Update the database when updating the database Update transaction acquisition means for fetching transaction information, update transaction storage file for storing update transaction information fetched by this update transaction acquisition means, and update transaction information stored in this update transaction storage file for transmission to the backup computer An update transaction transmitting unit that stores a copy of the database in the backup computer, an update transaction receiving unit that receives update transaction information transmitted from the host computer, and an update transaction receiving unit. The update transaction storage file that stores the update transaction information received by Backup database updating means for updating the backup database according to update transaction information of the storage file, and backup database referring means for referring to the backup database based on a reference request from the terminal device. Business service form switching method. 3. The update transaction transmitting means transmits the update transaction information of the update transaction storage file based on a transmission instruction from the host computer control terminal device, and the backup database updating means transmits from the backup computer control terminal device. 3. The business service form switching method according to claim 2, wherein the backup database is updated based on update transaction information of the update transaction storage file based on an update instruction. 4. The business service form switching system according to claim 1, wherein the host computer and the backup computer are connected via a dedicated line.