JPH01217620A - Data base control system - Google Patents

Abstract

PURPOSE:To lighten the load on a user required for production of an application program by using a data control program to perform the transfer and the exclusive process of transactions. CONSTITUTION:A data control program 52 receives a transaction 105b from an application program 51 and performs an exclusive process to inhibit the processing of other transactions against the corresponding data on its own data base 53 by means of a record or block excluding function included in an OS. In a secondary system, a data control program 62 performs an exclusive process to a data base 63 at reception of the transaction 105d. In such a way, the load is extremely reduced for the application program that has so far taken charge of those said processes.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a database management method in an online information processing system, and in particular, to a database management method for connecting two or more online information processing systems and for each online information processing system to have a The present invention relates to a database management method when simultaneously updating specific data of databases having the same content.

[Conventional technology]

In the online information processing method, two or more online information processing systems (hereinafter simply referred to as online systems) are installed side by side and connected through communication lines, etc., and each online system is equipped with a database with the same content. When updating specific data in a database in an online system, update the online system notator base and simultaneously update the databases of other online systems to ensure that the contents of all databases match. In many cases, the database is maintained by leaving it open. For example, a bank's online system (online banking system) is a notable example of this.

In the online system as described above, a conventional management method for updating data in a database is as illustrated in FIG. 2.

That is, two online systems 1 and 2 are connected via a data communication line, etc., and the other online system (main system) 1 receives change data (this is used to update specific data in the database 13). transaction) 101a is input, the transaction 101a is input to the main system 1 (the two online systems are on equal footing, but the online system in which the transaction was input is the main system, and the other online system is the slave system. The application program (a program that the user creates himself/herself for the business process) 11 of the main system 1 receives the application program 11, performs necessary processing such as a validity check, and stores the data in the operation system (O8) of the main system 1. Management program 1
2 as a transaction 101b, and the data management program 12 sends this as a transaction 101d to the database 13 to update the corresponding data. In parallel with this, application program 1
1 is sent to the application program 21 of the slave system 2 as a transaction 101c, the application program 21 receives it, performs the necessary processing, and passes it to the data management program 22 as a transaction 101e, and the data management program 22 sends it as a transaction 101f. The data is sent to the database 23 as an update process for the corresponding data.

When the update processing by the transactions 101d and 101f is completed in the database 13 and the database 23, update result notifications 102d and 1o2a are sent to the data management programs 12 and 22, respectively. send these to the corresponding application programs 11 and 21 as update result notifications 102e and 102b, respectively. The application program 21 receives this update result notification 102b and sends it to the application program 11 as an update result notification 102c. Application program 1
1 is update result notification 1 from the data management program 12
When 02e is received, it is temporarily put on hold and waits for the update result notification 102c from the application program 21 of the slave system 2, and when both are received, the update result notification 1 is sent.
Issue 03 and wait for the next transaction to be input. When specific data in the databases 13 and 23 is being updated in the main system 1 or the slave system 2 by a transaction from one terminal device connected to them, when the same data is updated from another terminal device, In order to prevent the data from being rewritten due to access, the application programs 11 and 12 manage the access status (access state) of the databases 13 and 23, respectively, and perform update processing only when they are in an updatable state. You are in control as much as possible.

[Problem to be solved by the invention]

As mentioned above, in conventional database management methods in online systems, application programs send and receive transaction and update result notifications and manage database access status, which places a heavy burden on each user in creating application programs. It has the disadvantage that it is multiplied by

The problem to be solved by the present invention, in other words, the purpose of the present invention is to eliminate the drawbacks of the database management method in the conventional online system as described above, and to reduce the burden when creating application programs. The objective is to provide a database management method that allows for

[Means to solve the problem]

In the database management method of the present invention, a plurality of online information processing systems are interconnected, each of the plurality of online information processing systems is provided with a database with the same content, and one of the plurality of online information processing systems is In a database management method in which predetermined data in the databases of all of the plurality of online information processing systems are simultaneously updated by inputting a transaction from a terminal device connected to any one of the online information processing systems, the transaction The online information processing system that inputs the information is the main system,
When the remaining online information processing system is a slave system, the data management program in the operating system receives the transaction through the application program of the main system, and at the time of receiving the transaction, the data in its own database is Exclusive processing for prohibiting update processing of the corresponding data by other transactions is performed by activating a record exclusion function or block exclusion function possessed by the operation system, and the update processing of the database by the transaction is performed, and the update processing is performed. In parallel with the processing, the transaction is sent to the slave system, and each slave system receives the transaction using a data management program in its own operating system, performs the exclusive processing on its own database, and processes the transaction according to the transaction. A database update process is performed, the main system and the slave system receive an update result notification from their respective databases informing the completion of the update process, and the slave system sends the update result notification to the data management program of the main system. When the data management program of the main system receives all the update processing notifications, the data management program of the main system releases the exclusive processing of the online information processing system of its own and executes the exclusive processing of the main system. The method includes sending the update processing notification to the terminal device via the application program.

〔Example〕

Next, the present invention will be explained with reference to the drawings.

FIG. 1 is a block diagram showing one embodiment of the present invention.

In the embodiment shown in FIG. 1, two online systems are connected to each other, and a transaction is entered into the online system shown on the left side of the system. Therefore, in this embodiment, the online system on the left side is the main system, and the online system on the right side is the slave system.

As shown in FIG. 1, when a transaction 105 & is received from any one of the plurality of terminal devices connected to the main system 5, this transaction 105a is first transferred to the application program of the main system 5. 51 receives it, performs necessary processing such as validity checking, and then sends it as transaction 105b.
The data is passed to the data management program 52 inside. The data management program 52 sends this as a transaction 105C to the database 53 of the main system to update the corresponding data, and at the same time sends this as a transaction 105C to the data management program 62 in C18 of the slave system 6.
give it to The data management program 62 uses this as a transaction 105e in the database 6 of the slave system 6.
3 to update the corresponding data. Therefore, at this point, the database of the main system 5 and the database 63 of the slave system 6 are updated to have the same contents.

When the data update by the transaction 105c or 105e in the databases 53 and 63 is completed, update result notifications 106c and 1 are sent to notify this fact.
06a are data management programs 52 and 62, respectively.
sent to. The data management program 62 receives the update result notification 106a and sends it to the data management program 52 of the main system 5 as an update result notification 106b. When the data management program 52 of the main system 5 receives the update result notification 53 from the database 53 of its own system, it puts it on hold until the arrival of the update result notification 106b from the data management program 62 of the slave system 6. Wait, and when both are ready, the application program 51
The update result notification 107a is passed to. The application program 51 sends this to the terminal device as an update result notification 107b and waits for input of the next transaction. In this series of operations, the application program 61 of the slave system 6 is not involved in the update processing operation of the database 63.

In the above operation, the data management program 52 receives transaction 1 from the application program 51.
When receiving 05b, the record exclusion function provided in O8 (a function that prohibits reading data from other terminal devices when data is read for the purpose of rewriting, until the reading operation is completed; The corresponding data in the own database 53 can be accessed using the block exclusion function (similarly, the function that prohibits data reading in units of physical records of the storage device). In the slave system 6, when the data management program 62 receives the transaction 105d, exclusive processing is performed on the database 63. These exclusive processes are canceled when the data management program 62 in the slave system 6 receives the update result notification 106a from its own database 63, and in the main system 5, the data management program 52 releases the data from its own database 53. The update result notification 106c from the data management program 63 of the slave system 6 and the update result notification 106b from the data management program 63 of the slave system 6 are both released.

The above embodiment is an example in which there are two online systems, but the same applies to the case where there are three or more systems, and data management of all other online systems is performed from the data management program of the main system that inputs the transaction. The purpose can be achieved by transferring the transaction to the program, waiting for the completion of updating the databases of all online systems, and then releasing exclusive processing for the own online system.

〔Effect of the invention〕

As described above, the database management method of the present invention greatly reduces the burden on application programs that were traditionally responsible for these processes by having the data management program perform transaction transfer and exclusive processing. It has the effect of being able to
Therefore, there is an effect that the burden on the user for creating an application program can be reduced.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing an embodiment of the database management method of the present invention, and FIG. 2 is a block diagram showing an example of a conventional database management method. 1,5...Main system, 2,6...Slave system, 11.21,51.61...Application program, 12,22,52.62...
...Data management program, 13, 23, 53, 63
...Database. Agent Patent Attorney Uchi Hara Oto/l)6 Q °/6Otsu6 ・10OtsuC//()7(
L "1076: Wose v1 Ki Tomoe 1 Insect 'Ilj'
1st eye

Claims (1)

[Claims] A plurality of online information processing systems are interconnected, each of the plurality of online information processing systems is provided with a database with the same content, and any one of the plurality of online information processing systems In a database management method in which a transaction is input from a terminal device connected to one online information processing system and predetermined data in the database of all of the plurality of online information processing systems is updated simultaneously, the transaction is input. When the online information processing system is the main system and the remaining online information processing systems are the slave systems, the data management program in the operation system receives the transaction through the application program of the main system, and receives the transaction. At the time when the database is updated by the transaction, exclusive processing is performed to prohibit update processing of the corresponding data in the own database by other transactions by using the record exclusion function or block exclusion function possessed by the operation system. The transaction is sent to the slave system in parallel with the update process, and each slave system receives the transaction with a data management program in its own operating system and performs the exclusive process on its own database. The main system and the slave system receive an update result notification from their respective databases informing them of the completion of the update process, and the slave system receives the update result notification from the respective databases. When the data management program of the main system receives all the update processing notifications, the data management program of the main system cancels the exclusive processing of the online information processing system of the main system. A database management method comprising: canceling the update process notification to the terminal device via the application program of the main system.