JP2000020376A - Method and system for exclusively controlling transaction system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method and a system for exclusive control with which work efficiency is improved and maintainability on the side of a server is improved by guaranteeing the update of data at the time point of reading data from a database on the server side through a client terminal. SOLUTION: In a client/server system, when reading data from a transaction data base 22 on the side of a server 20 to the client terminal, exclusive information related to the relevant data is held from read information before the update of the said data by an exclusive control system 21 on the server side, and control is performed so as not to simultaneously hold the said data among plural client terminals 10. When any transaction is finished on the side of the client terminal, it is reported from the client terminal to the server side and the exclusive control system on the server side deletes the exclusive information related to the data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to transaction processing of a client-server system, and more particularly to a method and system for performing exclusive control of transaction data.

[0002]

2. Description of the Related Art A server having a plurality of client terminals for performing transactions, a transaction database having transaction data accessed by the client terminals when executing the transactions,
In a client-server system where is connected to a network, when one client terminal controls update of the transaction database on the server side,
Generally, at the time of updating, confirmation of exclusion is performed.

That is, when data is updated by one client terminal, exclusive control is performed so that the same data is not updated simultaneously by another client terminal.

[0004]

In this case, in the conventional system, when a certain client terminal inputs and changes data from a transaction database on the server side, the data is already exclusive by another client terminal. When the control is performed, the data is locked, and the updated data can be written to the transaction database. It can be understood that the updating work is wasted only at the time of updating.

[0005] For this reason, the operator at the client terminal uses wasteful work time.

Therefore, in order to avoid such a situation as much as possible, it is possible to implement a mechanism that has exclusive information on the server side when the information before data update is read. When such a mechanism is implemented as it is in the conventional client-server method, when a failure occurs in the client terminal updating the data of the transaction database, exclusive information related to the data remains on the server side, and other client Since the data cannot be accessed from the terminal, the operation manager needs to maintain and manage the data.

As an exclusive control method for a client-server distributed database, for example, Japanese Patent Laid-Open No.
Japanese Patent No. 03142 discloses that if a transaction end process is not transmitted within a certain period of time after the start of a transaction process, the exclusive lock is released and abnormally terminated, and a long-term waiting time for another program to wait for access to the same exclusive control unit. A scheme is disclosed that prevents continuation.

Accordingly, the present invention has been made in view of the above-mentioned problems, and has as its object to guarantee the update of data at the time when data is read from a database on a server side at a client terminal, thereby improving work efficiency. And an exclusive control method and system for improving maintainability on the server side.

[0009]

In order to achieve the above object, the present invention provides a server having a plurality of client terminals for performing transactions, a transaction database having transaction data accessed by the client terminals when executing a transaction,
Is a method for exclusive control of a transaction in a client-server system connected to a network, wherein when the client terminal reads data from a transaction database on the server side, exclusive information about the data is read based on read information before updating the data. Is stored and managed on the server side, and the data is controlled so as not to be simultaneously stored in a plurality of client terminals.

In the present invention, when the transaction is completed at the client terminal, the client terminal notifies the server to that effect, and the server deletes the exclusive information on the data.

In the present invention, the server periodically monitors the state of the client terminal, and when a failure occurs between the client terminal and the server, the server retains the exclusive information held by the failed client terminal. Delete information.

[0012]

Embodiments of the present invention will be described. In a preferred embodiment of the present invention, a plurality of client terminals performing a transaction and a server including a transaction database having transaction data accessed by the client terminal when executing the transaction are provided by a LAN / WAN.
In a client-server system connected by an equal network, the client terminal and the server each include an exclusive control system for exclusive control of a transaction, and when the client terminal reads data from the transaction database on the server side,
The exclusive control system on the client side transfers the exclusive information on the data to the exclusive control system on the server side, holds the exclusive information on the exclusive control system on the server side, and, when the transaction ends on the client terminal side, The exclusive control system of the client terminal notifies the exclusive control system of the server to that effect, and deletes the exclusive information on the data held by the exclusive control system of the server. While the exclusion control system on the server side holds the exclusion information on the data, exclusion control is performed so that other client terminals do not hold the same data at the same time.

[0013] In an embodiment of the present invention, the exclusive control system of the server periodically transmits activation confirmation information to the client terminal to monitor the status, and the client terminal communicates with the server. The connection information is returned as a response when the startup confirmation is received from the server, and when the expected connection information is not returned from the client terminal in the exclusive control system on the server side, it is determined that a failure has occurred, The exclusive control system deletes the exclusive information held for the failed client terminal.

An embodiment of the present invention will be described with reference to the drawings. Referring to FIG. 1, in the embodiment of the present invention, the server-side exclusive control system holds the read status before the update as exclusive information, and deletes the read status when the transaction has completed the update. The other transaction and the client terminal can know that the other transaction has read for updating by referring to the exclusive control system at the time of reading before updating.

Further, the server monitors the connection status of the client terminal, so that even if a failure occurs in the client terminal, the exclusive information on the client terminal remains, so that the server cannot access from another client terminal. Occurrence can be avoided.

[0016]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing an embodiment of the present invention;

FIG. 1 is a diagram showing the configuration of an embodiment of the present invention. Referring to FIG. 1, one embodiment of the present invention includes a client terminal (also referred to simply as a “client”) 10 and exclusive control systems 11 and 21 on a server 20 side. Have. Although FIG. 1 shows only one client terminal for simplification, it is assumed that a plurality of client terminals are connected to the server.

When the client 10 starts using the transaction database 22, the exclusive control system 11
Notify the start of system use via.

The exclusive control system 21 on the server 20 side
The client 10 periodically refers to the exclusive control system 11 of the client 10 to monitor whether a normal operation is performed.

In the present embodiment, exclusive control is realized by providing exclusive control information 23 on the server 20 side. Also, control is performed so that the same data is not simultaneously held in a plurality of client terminals. Therefore, when the application on the client 10 reads the data from the transaction database 22 on the server 20, it passes the key information of the data to the exclusive control system 11 on the client 10. The exclusive control system 11 of the client 10 passes the key information to the exclusive control system 21 of the server 20.

When the exclusive control system 11 of the client 10 is notified that the transaction has been completed when the transaction is completed on the client 10 side, the exclusive control system 21 of the server 20 holds the exclusive control system 11 of the client 10. The exclusive information 23 on the data is deleted.

Next, the operation of one embodiment of the present invention will be described with reference to FIGS.

FIG. 2 is a diagram for explaining a procedure for confirming activation between a client and a server in one embodiment of the present invention. Referring to FIG. 2, when the client 10 starts,
The exclusive control system 11 on the client 10 side connects to the exclusive control system 21 on the server 20 side and notifies that it has started (connection information).

The exclusive control system 21 on the server 20 side operates at regular intervals.
Confirm the startup for.

Exclusive control system 1 on the client 10 side
1 returns the connection information in response to the activation confirmation from the server 20 side, and notifies that the server 20 is being activated (connection information).

FIG. 3 is a diagram for explaining the exclusive information writing process in one embodiment of the present invention. FIG.
, The client 10 stores data for transaction processing in the transaction database 22.
And the contents of the read data are passed to the exclusive control system 11 on the client 10 side.

Exclusive control system 1 on the client 10 side
1 is for the exclusive control system 21 on the server 20 side.
Request exclusive acquisition. The exclusive control system 21 of the server 20 writes and registers the exclusive information 23.

In this state, even if another client requests exclusion acquisition, the exclusion information 23 remains in the exclusion control system 21 on the server 20 side. Processing cannot be performed.
Thereby, exclusive control regarding the data can be realized.

FIG. 4 is a diagram for explaining an exclusive erasure process in one embodiment of the present invention. Referring to FIG. 4, when updating the data and ending the transaction, the client 10 requests the exclusive control system 21 of the server 20 to delete the exclusive information.

The exclusive control system 21 on the server 20 side
In response to the exclusive information deletion request, the exclusive information is deleted, and a request from another client terminal is made ready.

FIG. 5 is a diagram for explaining erasure of exclusive information due to a terminal failure in one embodiment of the present invention.
Referring to FIG. 5, the exclusive control system 2 on the server 20 side
1 checks the client 10 for activation at regular intervals. The client 10 returns the connection information to the server 20 side upon receiving the activation confirmation from the server 20 side. While the connection information is correctly returned from the client 10, no special processing is performed. However, if the client 10 does not return the connection information due to some failure, the server-side exclusive control system 21 executes the processing in the client 10. It is determined that the exclusion has been stopped, and the exclusive information 23 held up to that point is deleted.

Thus, even if the client 10 is stopped due to a failure in the middle, it is possible to automatically prepare an environment in which another client terminal can update.

The communication method between the client and the server includes LAN (local area network), WA
N (wide area network) or the like can be used.

[0034]

As described above, according to the present invention,
The following effects are obtained.

The first effect of the present invention is that the client terminal compensates that the data read from the transaction database on the server side is always in an updatable state. That is, it is possible to reliably avoid the occurrence of the situation, and to improve data security and work efficiency.

The second effect of the present invention is that, by monitoring the terminal from the server, even when the connection between the client terminal and the server is disconnected due to a client terminal failure or the like, the exclusive information on the server side is automatically output. Since it is deleted, it is possible to minimize the influence on other client terminals.

[Brief description of the drawings]

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

FIG. 2 is a diagram for explaining the operation of one embodiment of the present invention, and is a diagram schematically showing an operation of confirming activation of a client terminal.

FIG. 3 is a diagram for explaining an operation of an embodiment of the present invention, and is a diagram schematically showing an exclusive information acquisition operation.

FIG. 4 is a diagram for explaining the operation of one embodiment of the present invention, and is a diagram schematically showing an exclusive information deleting operation.

FIG. 5 is a diagram for explaining the operation of one embodiment of the present invention, and is a diagram schematically showing an exclusive information deletion operation due to a terminal failure.

[Explanation of symbols]

 Reference Signs List 10 client (terminal) 11 exclusive control system 20 server 21 exclusive control system 22 transaction database 23 exclusive (control) information

Claims (7)

[Claims] An exclusive transaction control method in a client-server system, comprising: a plurality of client terminals for performing transaction processing; and a server having a transaction database having transaction data accessed by the client terminals when executing a transaction. When the client terminal reads data from the transaction database on the server side, the server side holds exclusive information on the data from the read information before updating the data, and the same data as the data is transmitted to a plurality of client terminals. An exclusive control method, characterized in that control is performed so as not to hold them at the same time. 2. The system according to claim 1, wherein, when the transaction is completed on the client terminal side, the client terminal notifies the server side of the completion, and the server deletes the exclusive information on the data. Or the exclusive control method according to 2. 3. The server periodically monitors the state of the client terminal, and when a failure occurs between the client terminal and the server, the server stores exclusive information held for the failed client terminal. 3. The exclusive control method according to claim 1, wherein the exclusive control method is deleted. 4. The exclusive information on the data includes key information of the data read from the database.
The exclusive control method according to any one of claims 1 to 3, wherein: 5. A client-server system in which a plurality of client terminals performing a transaction and a server including a transaction database having transaction data accessed by the client terminal when executing the transaction are connected via a network or the like. The client terminal and the server each have exclusive control means for exclusive control of a transaction. When the client terminal reads data from the transaction database on the server side, the exclusive control means on the client side transmits exclusive information on the data. When the transaction is transferred to the server-side exclusive control means, the server-side exclusive control means retains and manages the exclusive information, and when the client terminal ends a transaction, The exclusive control means of the client terminal notifies the exclusive control means of the server to that effect, deletes the exclusive information on the data held by the exclusive control means of the server, and the exclusive control means of the server side An exclusive control system, characterized in that control is performed such that another client terminal does not hold the same data at the same time while holding the exclusive information on the data. 6. An exclusive control means of the server periodically transmits start-up confirmation information to the client terminal to monitor the state, and the client terminal receives a start-up confirmation from the server side. When the connection information expected from the client terminal is not returned by the exclusive control means on the server side, it is determined that a failure has occurred. Delete exclusive information held for
The exclusive control system according to claim 5, wherein: 7. The exclusive control system according to claim 5, wherein the exclusive information on the data includes key information of the data.