JP7079573B2 - Optimistic exclusive processing serialization device, optimistic exclusive processing serialization method, and optimistic exclusive processing serialization program - Google Patents

Description

The present invention relates to an optimistic exclusive processing serialization apparatus, an optimistic exclusive processing serialization method, and an optimistic exclusive processing serialization program.

Patent Document 1 discloses a configuration in which an input transaction itself is provided with an attribute of whether or not a lock is acquired and operates in advance, and optimistic exclusive control for lock acquisition is applied as a pre-stage of transaction execution. Has been done.

Japanese Unexamined Patent Publication No. 2016-95638

However, in the above Patent Document 1,
Not only is it necessary to preset the attribute of whether or not to acquire a lock in the transaction itself, but it is also a normal optimistic concurrency control between transactions that operate without acquiring a lock. There was a problem of closing it.

The present invention has been made in view of the above problems, and the optimistic exclusive processing itself is made consistent with the robustness of the exclusive processing by serializing the exclusive processing by a plurality of users by utilizing the transaction characteristics of the database. It is an object of the present invention to provide an optimistic exclusive processing serialization device, an optimistic exclusive processing serialization method, and an optimistic exclusive processing serialization program that enable the assurance of sex.

In order to solve the above-mentioned problems and achieve the object, the optimistic exclusive processing serialization device according to the present invention is an optimistic exclusive processing serialization device including a storage unit and a control unit, and the storage unit. Is provided with a target data storage means for storing the target data, and the control unit is stored in the target data storage means and a transaction execution means for executing a transaction for the target data stored in the target data storage means. Another transaction execution means for executing another transaction different from the transaction for the target data, and when an object is created in the transaction, a request to create an object with the same name as the object in the other transaction is requested. The exclusive check means to detect, the standby means for suspending the execution of the other transaction and waiting when the request for creating the object with the same name is detected in the other transaction by the exclusive check means, and the transaction execution means. When the execution of the transaction is completed, the transaction is committed, and when an error occurs in the execution of the transaction by the transaction execution means, the transaction is committed by the transaction confirmation means for rolling back the transaction and the transaction confirmation means. Alternatively, when it is rolled back, it is provided with a wait release means for canceling the wait of the other transaction by the wait means.

Further, in the optimistic exclusive processing serialization device according to the present invention, when the transaction is committed, the control unit updates the target data stored in the target data storage means based on the transaction. It is characterized by further comprising means and limiting means for limiting the update of the target data updated by the updating means.

Further, in the optimistic exclusive processing serialization device according to the present invention, the control unit notifies the user of the other transaction of the target list of the target data which is the execution target of the transaction, and the notification means. When the target data included in the target list notified by the notification means is selected as the overwriting update target by the user, the overwriting update target specifying means for specifying the target data of the overwriting update target. Further, when the target data of the overwriting update target is specified by the overwriting update target specifying means, the updating means further releases the restriction by the limiting means, and the target is based on the other transaction. It is characterized in that the target data of the overwriting update target stored in the data storage means is updated.

Further, the optimistic exclusive processing serialization device according to the present invention is characterized in that the transaction determination means further deletes the object when the execution of the transaction is completed by the transaction execution means.

Further, the optimistic exclusive processing serialization device according to the present invention is characterized in that the transaction determination means further deletes the object when an error occurs in the execution of the transaction by the transaction execution means.

Further, the optimistic exclusive processing serialization method according to the present invention is an optimistic exclusive processing serialization method for causing an optimistic exclusive processing serialization device including a storage unit and a control unit to execute the storage unit. Provides a target data storage means for storing target data, a transaction execution step for executing a transaction for the target data stored in the target data storage means, which is executed by the control unit, and the target data storage means. Another transaction execution step to execute another transaction different from the transaction for the stored target data, and when an object is created in the transaction, create an object with the same name as the object in the other transaction. An exclusive check step for detecting a request, a waiting step for suspending execution of the other transaction and waiting when a request for creating the object with the same name is detected in the other transaction in the exclusive check step, and a waiting step for the transaction. When the execution is completed, the transaction is committed, and when an error occurs in the execution of the transaction, the transaction confirmation step for rolling back the transaction and the transaction for which the transaction is committed or rolled back in the transaction confirmation step. , The wait release step for canceling the wait of the other transaction, and the like.

Further, the optimistic exclusive processing serialization program according to the present invention is an optimistic exclusive processing serialization program for being executed by an optimistic exclusive processing serialization device including a storage unit and a control unit, and is the storage unit. Is provided with a target data storage means for storing the target data, and in the control unit, a transaction execution step for executing a transaction for the target data stored in the target data storage means and a transaction execution step stored in the target data storage means. Another transaction execution step to execute another transaction different from the transaction for the target data, and when an object is created in the transaction, a request to create an object with the same name as the object in the other transaction is requested. When the exclusive check step to be detected and the request to create the object with the same name are detected in the other transaction in the exclusive check step, the execution of the other transaction is interrupted and waits, and the execution of the transaction is performed. When completed, the transaction is committed, and when an error occurs in the execution of the transaction, the transaction confirmation step for rolling back the transaction, and when the transaction is committed or rolled back in the transaction confirmation step, the transaction is described. It is characterized by executing a wait release step for canceling a wait for another transaction.

According to the present invention, by performing the optimistic exclusive processing with respect to the optimistic exclusive processing, the optimistic exclusive processing can be occupied and serialized, so that the disadvantage of the optimistic exclusive processing can be avoided. It works. Further, according to the present invention, there is an effect that pessimistic exclusive processing can be realized by applying the property of a relational database management system (RDMS). Further, according to the present invention, it is possible to suppress the waiting time from the start of processing to the end of the exclusive check, not from the data acquisition to the end of update, so that it is possible to reduce the waiting time of lock waiting. Further, according to the present invention, unlike the pessimistic exclusion process, there is an effect that a strong and reliable lock release can be performed even at the time of an error. Further, according to the present invention, there is an effect that selective exclusion based on a user's judgment can be executed.

FIG. 1 is a diagram showing an example of simultaneous update by a plurality of people. FIG. 2 is a diagram showing an example of pessimistic exclusion processing. FIG. 3 is a diagram showing an example of optimistic exclusion processing. FIG. 4 is a diagram showing an example of optimistic exclusion processing. FIG. 5 is a block diagram showing an example of the configuration of the optimistic exclusive processing serialization device. FIG. 6 is a flowchart showing an example of the processing of the optimistic exclusive processing serialization apparatus in the present embodiment. FIG. 7 is a diagram showing an example of an optimistic exclusive processing serialization flow in the present embodiment. FIG. 8 is a diagram showing an example of an exclusive transaction in the present embodiment. FIG. 9 is a diagram showing an example of standby processing in the present embodiment. FIG. 10 is a diagram showing an example of standby processing in this embodiment. FIG. 11 is a diagram showing an example of optimistic concurrency control in the present embodiment. FIG. 12 is a diagram showing an example of optimistic concurrency control in the present embodiment. FIG. 13 is a diagram showing an example of the selective overwriting update process in the present embodiment.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
First, an example of the conventional database update process will be described with reference to FIGS. 1 to 4. FIG. 1 is a diagram showing an example of simultaneous update by a plurality of people. FIG. 2 is a diagram showing an example of pessimistic exclusion processing. 3 and 4 are diagrams showing an example of optimistic exclusion processing.

As shown in FIG. 1, in the conventional database update process, when a plurality of people (UserA and UserB) simultaneously update the slip data (J001) stored in the database, the sales based on J001 Inconsistencies may occur in which is double-counted.

Further, as shown in FIG. 2, in the conventional pessimistic exclusive processing, when it is detected that the processing of UserA uses J001 first by referring to the exclusive table, the processing of J001 by the processing of UserB is performed. Calling is disabled, and by explicitly locking the data, the operation of another person (UserB) can be blocked, and after the UserA processing is completely completed, the exclusive table can be cleared and the UserB processing operation can be performed. I was doing it.

As described above, in the conventional pessimistic exclusive processing, data lock is performed at the time of data acquisition by using some method. As a result, in the conventional pessimistic exclusive processing, while one user is calling, the other user is always in the lock waiting state. Further, in the conventional pessimistic exclusive processing, when the calling user closes the browser in the Web application or disconnects the connection, the data remains locked. ..

That is, in the conventional pessimistic exclusive processing, the frequency of lock release failures in the Web application is high, so that the data consistency can be maintained, but the load of releasing the data as needed is high. In addition, in the conventional pessimistic exclusive processing, a lock wait occurs, which induces a time-out of the website and affects the system operation of the user. Optimistic exclusion processing was adopted.

On the other hand, as shown in FIG. 3, in the conventional optimistic exclusive processing, even if the processing of UserA uses J001 first, when it is detected that the processing of UserB updates J001 first, That is, if the time stamp at the time of data acquisition of J001 and the current time stamp are different before the processing of UserA processing is completed, UserB's first-come-first-served basis becomes valid and UserA's processing is discarded (rollback). Was there.

In this way, in the conventional optimistic exclusive processing, the lock is not applied, but since the check is performed at the end of the processing, the time required for the processing is wasted when the result is NG. ..

Further, as shown in FIG. 4, in the conventional optimistic exclusive processing, when the processing of UserA performs data processing for only one slip (J001) while the processing of UserA is processing a large amount of data, the processing of UserA is the update date and time. If all the processing of UserB is completed during the confirmation, the processing of UserA is already confirming the update date and time, but the change of the update date and time due to the processing of UserB cannot be detected, and the sales to J001 are as it is. Inconsistencies that were double-counted could occur.

As described above, in the conventional optimistic exclusive processing, there is a possibility that the check may be bypassed when the updates occur at the same time or when the processing amount is large. That is, in the conventional optimistic exclusive processing, due to the large scale of data or the complexity of the processing content, the update is discarded after a considerable amount of time has passed, or the exclusive check time overlaps. , There were cases where the check did not work properly.

As described above, in the past, in Web products and the like that perform batch update processing for a considerable amount of slips, when a plurality of users are competing for data to be processed at the same time, the optimistic exclusive processing has reached its limit. In addition, in the past, when reliable pessimistic concurrency control was applied, it was necessary to wait for the update completion of other users, which required unnecessary waiting time for the user, and optimistic concurrency with relaxed conditions. When control was applied, it was difficult to clear the two points of having to abandon concurrency at the same time.

Therefore, in the present embodiment, robustness, consistency, and exclusive detection time, which are disadvantages of optimistic exclusive processing adopted in Web products and the like where it is difficult to apply pessimistic exclusive control to data, can be eliminated. ..

[2. Constitution]
An example of the configuration of the optimistic exclusive processing serialization device 100 according to the present embodiment will be described with reference to FIG. FIG. 5 is a block diagram showing an example of the configuration of the optimistic exclusive processing serialization device 100.

The optimistic exclusive processing serialization device 100 is a commercially available desktop personal computer. The optimistic exclusive processing serialization device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer. It may be a portable information processing device such as.

The optimistic exclusive processing serialization device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the optimistic exclusive processing serialization device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the optimistic exclusive processing serialization device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the optimistic exclusive processing serialization device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 includes a target data database 106a.

The target data database 106a stores the target data. Here, the target data may be master data or the like that is updated (revised) by a plurality of people at once. The target data is slip data, corporate data, personal data, unit price data, budget data subject to budget revision, target data subject to target revision, product data, product data, real estate data, tenant data, or It may be contract data or the like. Here, the corporate data may be customer data, business partner data, or the like that is the target of credit revision work or the like. In addition, personal data may be customer data subject to credit revisions, settlement conditions or address changes, or employee data subject to personnel / salary operations such as salary bonus assessment, personnel evaluation or entry / exit. good. Further, the unit price data may be trading unit price data, contract unit price data, retail price data, retail price data, cost unit price data, etc., which are subject to unit price revision. Further, the real estate data may be building data, room data, or the like. For example, the target data may be master data such as a unit price or lending in buying and selling, a unit price or a fixed price of a service contract, or a batch change of a partition rate or a cost price when the low price method is adopted.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a touch panel). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114 or a printer 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The control unit 102 is a CPU or the like that collectively controls the optimistic exclusive processing serialization device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 has a transaction execution unit 102a, an exclusive check unit 102b, a standby unit 102c, a transaction confirmation unit 102d, a standby release unit 102e, a notification unit 102f, and an overwriting update target specific unit. It includes 102 g, an update unit 102h, and a restriction unit 102i.

The transaction execution unit 102a executes a transaction for the target data stored in the target data database 106a. Here, the transaction execution unit 102a may execute a transaction different from the transaction for the target data stored in the target data database 106a.

When an object is created in a transaction, the exclusive check unit 102b detects a request for creating an object having the same name as the object in another transaction.

When the exclusive check unit 102b detects a request to create an object with the same name in another transaction, the standby unit 102c suspends the execution of the other transaction and makes it wait.

The transaction confirmation unit 102d commits the transaction when the transaction execution unit 102a completes the execution of the transaction, and rolls back the transaction when an error occurs in the transaction execution by the transaction execution unit 102a. Here, the transaction confirmation unit 102d may further delete the object when the transaction execution unit 102a completes the execution of the transaction. Further, the transaction confirmation unit 102d may delete the object when an error occurs in the transaction execution by the transaction execution unit 102a.

When the transaction is committed or rolled back by the transaction confirmation unit 102d, the wait release unit 102e releases the wait for another transaction by the wait unit 102c.

The notification unit 102f notifies the user of another transaction of the target list of the target data to be executed by the transaction. Here, the notification unit 102f may notify the user of another transaction by displaying the target list of the target data, which is the execution target of the transaction, on the output device 114.

When the target data included in the target list notified by the notification unit 102f is selected as the overwriting update target by the user, the overwriting update target specifying unit 102g specifies the target data to be overwritten and updated. Here, the overwriting update target specific unit 102g is the overwriting update target when the target data included in the target list notified by the notification unit 102f is selected as the overwriting update target by the user via the input device 112. The target data of may be specified.

When the transaction is committed, the update unit 102h updates the target data stored in the target data database 106a based on the transaction. Here, when the target data to be overwritten and updated is specified by the overwritten update target specifying unit 102g, the updating unit 102h further releases the restriction by the limiting unit 102i, and based on another transaction, the target data database 106a. The target data to be updated in the overwriting stored in may be updated.

The restriction unit 102i restricts the update of the target data updated by the update unit 102h.

[3. Concrete example]
Specific examples of this embodiment will be described with reference to FIGS. 6 to 13.

[Optimistic exclusive processing serialization]
Here, an example of optimistic exclusive processing serialization in the present embodiment will be described with reference to FIG. FIG. 6 is a flowchart showing an example of the processing of the optimistic exclusive processing serialization device 100 in the present embodiment.

As shown in FIG. 6, when the update instruction for the slip data is input by the user A via the input device 112, the transaction execution unit 102a executes an exclusive transaction for the slip data stored in the target data database 106a (). Step SA-1). The transaction execution unit 102a executes the exclusive transaction between steps SA-1 and SA-4, or between steps SA-1 and SA-10, in parallel with other processes.

Then, when the table is created in the transaction, the exclusive check unit 102b detects a request to create a table having the same name as the table in another transaction different from the exclusive transaction (step SA-2).

Then, the control unit 102 determines whether or not the request for creating the table with the same name is detected in another exclusive transaction by the exclusive check unit 102b (step SA-3).

Then, when the control unit 102 determines that the request for creating the table with the same name is not detected in another exclusive transaction (step SA-3: No), the control unit 102 shifts the process to step SA-4.

Then, when the transaction confirmation unit 102d completes the execution of the exclusive transaction by the transaction execution unit 102a, the table is deleted and the exclusive transaction is committed, and when an error occurs in the execution of the exclusive transaction by the transaction execution unit 102a, the transaction execution unit 102a deletes the table. Roll back the exclusive transaction (step SA-4).

Then, the control unit 102 determines whether or not the exclusive transaction has committed (step SA-5).

Then, when the control unit 102 determines that the exclusive transaction has not committed (rolled back) (step SA-5: No), the control unit 102 ends the process.

On the other hand, when the control unit 102 determines that the exclusive transaction has committed (step SA-5: Yes), the control unit 102 shifts the process to step SA-6.

Then, the update unit 102h updates the slip data stored in the target data database 106a by executing an actual processing (actual update processing) transaction for the slip data stored in the target data database 106a based on the exclusive transaction. (Step SA-6).

Then, the restriction unit 102i restricts the update of the slip data updated by the update unit 102h (step SA-7), and ends the process.

On the other hand, when the control unit 102 determines that the request for creating the table with the same name is detected in another exclusive transaction (step SA-3: Yes), the control unit 102 shifts the process to step SA-8.

Then, the standby unit 102c suspends the execution of another exclusive transaction and makes it wait (step SA-8).

Then, the notification unit 102f notifies the user B of another exclusive transaction by displaying the slip list of the slip data to be executed of the exclusive transaction on the output device 114 so as to be selectable (step SA-9).

Then, when the transaction confirmation unit 102d completes the execution of the exclusive transaction by the transaction execution unit 102a, the table is deleted and the exclusive transaction is committed, and when an error occurs in the execution of the exclusive transaction by the transaction execution unit 102a, the transaction execution unit 102a deletes the table. Roll back the exclusive transaction (step SA-10).

Then, the control unit 102 determines whether or not the exclusive transaction has committed (step SA-11).

Then, when the control unit 102 determines that the exclusive transaction has not committed (rolled back) (step SA-11: No), the control unit 102 shifts the process to step SA-12.

Then, the wait release unit 102e cancels the wait of another exclusive transaction by the wait unit 102c (step SA-12), and resets the another exclusive transaction for which the wait is released (execution is restarted) as a new exclusive transaction. Then, the process is shifted to step SA-2.

On the other hand, when the control unit 102 determines that the exclusive transaction has committed (step SA-11: Yes), the control unit 102 shifts the process to step SA-13.

Then, the standby release unit 102e releases the wait for another transaction by the standby unit 102c (resumes execution) (step SA-13).

Then, the update unit 102h updates the slip data stored in the target data database 106a by executing an actual processing transaction for the slip data stored in the target data database 106a based on the exclusive transaction (step SA-). 14).

Then, the restriction unit 102i restricts the update of the slip data updated by the update unit 102h (step SA-15).

Then, the overwriting update target specifying unit 102g determines whether or not the slip data included in the slip list notified by the notification unit 102f is selected by the user B as the overwriting update target via the input device 112 (step). SA-16).

Then, when the slip data included in the slip list is not selected as the overwrite update target by the user B (step SA-16: No), the overwriting update target specifying unit 102g ends the process.

On the other hand, when the slip data included in the slip list is selected as the overwrite update target by the user B (step SA-16: Yes), the overwriting update target specifying unit 102g shifts the process to step SA-17.

Then, the overwriting update target specifying unit 102g specifies the slip data to be overwritten and updated selected by the user B (step SA-17).

Then, the update unit 102h releases the restriction by the restriction unit 102i, and based on another transaction, executes an actual processing transaction for the slip data to be overwritten and updated stored in the target data database 106a, thereby executing the target data database. The slip data to be overwritten and updated stored in 106a is overwritten (step SA-18), and the process is terminated.

Here, the details of optimistic exclusive processing serialization will be described with reference to FIGS. 7 to 13.

First, an example of optimistic exclusion processing in the present embodiment will be described with reference to FIGS. 7 and 8. FIG. 7 is a diagram showing an example of an optimistic exclusive processing serialization flow in the present embodiment. FIG. 8 is a diagram showing an example of an exclusive transaction in the present embodiment.

As shown in FIG. 7, in the present embodiment, the exclusive transaction is executed based on the update instruction for the target data (J001) by UserA, and the table a is created. Here, in the present embodiment, since the table a has already been generated in the exclusive transaction of UserA, if the table with the same name is generated in another transaction, the lock is applied until the preceding transaction is confirmed. Using the function, the exclusive transaction of UserB is forcibly waited by the creation of table a until the exclusive transaction of UserA is confirmed (rollback or commit). This creates a situation in which only one person can reliably perform the optimistic exclusive processing operation in the present embodiment. Here, in the present embodiment, while the processing of UserB is waiting, the exclusive transaction of UserA may perform the exclusive check and the processing for notifying the successor of its own update target. Then, in the present embodiment, when the exclusive transaction of UserA commits, the exclusive transaction of UserA shifts to the update by the actual processing transaction as it is, and the exclusive transaction of UserB resumes the creation of the waiting table a. Then, in the present embodiment, when the result of rewriting in the actual processing transaction of UserA is confirmed by the exclusive check, all the processing of UserA is discarded.

Further, as shown in FIG. 8, in the exclusive transaction in the present embodiment, the transaction is rolled back in the optimistic exclusive processing serialization device 100 assuming an exclusive check error and an abnormal termination (abnormal system processing). SB-1 (for example, a process of automatically rolling back when an explicit commit is not made due to a server failure or the like) may be implemented. As a result, in the present embodiment, there may be no request for creating the table a by rollback.

Further, as shown in FIG. 8, in the exclusive transaction in the present embodiment, the table a is deleted before the commit in the own exclusive transaction that created the table a, assuming that the exclusive check ends normally (normal implementation processing). Processing SB-2 to be performed may be implemented. As a result, in the present embodiment, it is possible to create a situation in which the table a is absent in the database after the commit through the process of deleting the table a before the commit.

That is, if a transaction is committed and table a already exists, and an attempt is made to create table a in another transaction, a database error will occur. Therefore, in order to perform the creation process, table a is manually deleted. However, in the exclusive transaction in the present embodiment, this situation is avoided by a two-stage stance.

As described above, in the present embodiment, the lock waiting waiting time, which is a demerit of the pessimistic exclusive processing, is made to wait only during the optimistic exclusive processing, thereby processing the actual processing transaction. The waiting time is suppressed to the extent that it does not match the amount. Further, in the present embodiment, also in terms of inadvertent lock, if the exclusive transaction of UserA commits in the state where the table a exists, the exclusive transaction of UserB becomes an error due to the creation of the table with the same name. When the update process of UserA is completed normally, the exclusive transaction is committed after the deletion of table a is performed. Therefore, the exclusive transaction of UserB is prevented from becoming an error by surely disappearing the table a. There is. Further, in the present embodiment, the exclusive transaction of UserA is rolled back at the time of an error including a server error, so that the table a is not created by the processing of UserA, so that the exclusive transaction of UserB is an error. I try not to become.

Further, an example of the standby process in the present embodiment will be described with reference to FIGS. 9 and 10. 9 and 10 are diagrams showing an example of the standby process in the present embodiment.

As shown in FIG. 9, in the present embodiment, when the process of UserA creates the table a in the exclusive transaction at the time of the exclusive check, the process of another user can create the table a having the same name. , UserA processing needs to release the transaction, and the request for creating the table a by the processing of another user is waited until the transaction is released. Therefore, in the present embodiment, in the process of UserB, when the creation request of the table a is made at the time of its own exclusive check, a temporary wait occurs until the preceding UserA finishes the exclusive check. That is, from the processing of UserA, only oneself is performing the exclusive check when the request for creating its own table a is passed.

Further, as shown in FIG. 10, in the present embodiment, when a subsequent UserC appears, a forced wait for UserC processing occurs until the exclusive transaction of UserA and the exclusive transaction of UserB are completed. Therefore, the same exclusive check by the processing of a plurality of users is not applied in the same time zone.

Further, an example of optimistic exclusive control in the present embodiment will be described with reference to FIGS. 11 and 12. 11 and 12 are diagrams showing an example of optimistic concurrency control in this embodiment.

As shown in FIG. 11, in the present embodiment, even if the processing of UserB is executed after the exclusive transaction of UserA and the actual processing transaction, the update date and time rewritten by UserA and the update date and time when the data is acquired by UserB are used. Is compared, so the optimistic exclusive check discards all UserB processing.

Further, as shown in FIG. 12, in the present embodiment, when UserB tries to record another slip, a wait occurs at the time of creating the table a, but the processing of UserA is not the rewritten slip data but another slip. Since the slip data is referred to, the UserB processing can transition to the actual processing transaction via the exclusive transaction.

Further, with reference to FIG. 13, an example of the selective overwriting update process in the present embodiment will be described. FIG. 13 is a diagram showing an example of the selective overwriting update process in the present embodiment.

As shown in FIG. 13, in the present embodiment, when an exclusive error is detected by the exclusive transaction of UserA, the result list (target slip list) for each slip is notified to the UserB side during the exclusive transaction of UserB. Then, as shown in FIG. 13, in the present embodiment, for a slip whose status can be overwritten by detecting an error, it is selected at the discretion of UserB, and processing is continued after receiving the slip to be overwritten again. can do. That is, FIG. 13 shows an example in which UserB selects J001 as the overwriting update target when J001 and J002 are updated by the processing of UserA and J004 is deleted, and after the processing of UserB is completed. As for the state of the target data, the overwriting update by UserB processing is reflected for J001, the update by UserA processing is reflected for J002, the update by UserB processing is reflected for J003, and the deletion by UserA processing is reflected for J003. It will be in the reflected state.

For example, in a business such as transportation business where vehicles are allocated for a large number of orders, not only the slips that are input each time but also the assigned slips so that multiple dispatchers can deliver efficiently. There are cases where you are engaged in vehicle dispatching work while reviewing including, and there is a high possibility that the person in charge who updated later is dispatching the vehicle based on the latest information, and the person in charge updated earlier Since it is desirable to judge the validity of the data and update it to the latest data, there is a possibility that the business will not be able to turn around if it is a complete second win or a complete first win. Therefore, in this embodiment, if the exclusive processing is not implemented, it will be a complete second win, and if the exclusive processing is implemented, it will be a complete first win. , In the case of a matter that you want to partially overwrite with your own update at the discretion of the operator at the time of slip correction, it is possible to implement selective win-win update.

In this way, conventionally, when an exclusive error occurs, re-input or the like is performed at that point, but in the present embodiment, the user returns the error result and whether or not to overwrite the updated value of the user as the latest. It is possible to selectively renew the win after leaving it to the side.

Further, in the conventional optimistic exclusive processing, the standby release of another user is executed at the timing when all the updates are completed, but in the present embodiment, the update actual process is separated and the wait release is performed before the update actual process. By doing this, it is possible to minimize the waiting time of the user for the exclusive check.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the optimistic exclusive processing serialization device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the optimistic exclusive processing serialization device 100, particularly each processing function performed by the control unit 102, all or any part thereof may be interpreted and executed by the CPU and the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is optimistically excluded as necessary. It is read mechanically by the processing serialization device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the optimistic exclusive processing serialization device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is also possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the optimistic exclusive processing serialization device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. good. Further, the optimistic exclusive processing serialization device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful in industries such as the food industry, the distribution industry, the building materials industry, or the transportation industry, which require simultaneous processing of a large amount of data.

100 Optimistic exclusive processing serialization device 102 Control unit 102a Transaction execution unit 102b Exclusive check unit 102c Standby unit 102d Transaction confirmation unit 102e Wait release unit 102f Notification unit 102g Overwriting update target specific unit 102h Update unit 102i Restriction unit 104 Communication interface unit 106 Storage unit 106a Target data database 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

An optimistic exclusive processing serialization device equipped with a storage unit and a control unit.
The storage unit is
Target data storage means for storing target data,
Equipped with
The control unit
A transaction execution means for executing a transaction for the target data stored in the target data storage means, and a transaction execution means.
Another transaction execution means for executing a transaction different from the transaction for the target data stored in the target data storage means, and another transaction execution means.
If an object is created in the transaction before the update of the target data based on the transaction and the other transaction is completed, an exclusive check for detecting the creation request of the object with the same name as the object in the other transaction is detected. Means and
If the exclusive check means detects a request to create the object with the same name in the other transaction before the update of the target data based on the transaction and the other transaction is completed, the execution of the other transaction is interrupted and waits. Waiting means to make
A notification means for notifying a user of the other transaction of the target list of the target data which is the execution target of the transaction, and
When the execution of the transaction is completed by the transaction execution means, the transaction is committed, and when an error occurs in the execution of the transaction by the transaction execution means, the transaction confirmation means for rolling back the transaction and the transaction confirmation means.
When the transaction is committed or rolled back by the transaction confirmation means, the wait release means for canceling the wait of the other transaction by the wait means and the wait release means.
When the transaction is committed, the update means for updating the target data stored in the target data storage means based on the transaction, and the update means.
A limiting means for limiting the update of the target data updated by the updating means, and a limiting means.
When the target data included in the target list notified by the notification means is selected as the overwriting update target by the user, the overwriting update target specifying means for specifying the target data of the overwriting update target and the overwriting update target specifying means.
Equipped with
The update means
Further, when the target data to be updated by the overwriting is specified by the overwriting update target specifying means, the restriction by the limiting means is released, and the data stored in the target data storage means is stored based on the other transaction. An optimistic exclusive processing serialization device characterized by updating the target data to be updated. The transaction confirmation means is
Further, the optimistic exclusive processing serialization device according to claim 1 , wherein when the execution of the transaction is completed by the transaction execution means, the object is deleted. The transaction confirmation means is
Further, the optimistic exclusive processing serialization device according to claim 1 or 2 , wherein when an error occurs in the execution of the transaction by the transaction execution means, the object is deleted. An optimistic exclusive processing serialization method for causing an optimistic exclusive processing serialization device including a storage unit and a control unit to execute the serialization.
The storage unit is
Target data storage means for storing target data,
Equipped with
It is executed by the control unit.
A transaction execution step for executing a transaction for the target data stored in the target data storage means, and a transaction execution step.
A separate transaction execution step for executing a transaction different from the transaction for the target data stored in the target data storage means, and a separate transaction execution step.
If an object is created in the transaction before the update of the target data based on the transaction and the other transaction is completed, an exclusive check for detecting the creation request of the object with the same name as the object in the other transaction is detected. Steps and
If a request to create the object with the same name is detected in the other transaction in the exclusive check step before the update of the target data based on the transaction and the other transaction is completed, the execution of the other transaction is interrupted. A wait step to make it wait and
A notification step for notifying a user of the other transaction of the target list of the target data which is the execution target of the transaction, and a notification step.
A transaction confirmation step that commits the transaction when the execution of the transaction is completed and rolls back the transaction when an error occurs in the execution of the transaction.
When the transaction is committed or rolled back in the transaction confirmation step, the wait release step for canceling the wait for another transaction and the wait release step.
When the transaction is committed, an update step for updating the target data stored in the target data storage means based on the transaction, and an update step.
A restriction step that restricts the update of the target data updated in the update step, and a restriction step.
When the target data included in the target list notified in the notification step is selected as the overwriting update target by the user, the overwriting update target specifying step for specifying the target data of the overwriting update target ,
Including
In the update step
Further, when the target data of the overwriting update target is specified in the overwriting update target specifying step, the restriction in the restriction step is released, and the data is stored in the target data storage means based on the separate transaction. An optimistic exclusive processing serialization method characterized by updating the target data to be updated. An optimistic exclusive processing serialization program for execution by an optimistic exclusive processing serialization device including a storage unit and a control unit.
The storage unit is
Target data storage means for storing target data,
Equipped with
In the control unit
A transaction execution step for executing a transaction for the target data stored in the target data storage means, and a transaction execution step.
A separate transaction execution step for executing a transaction different from the transaction for the target data stored in the target data storage means, and a separate transaction execution step.
If an object is created in the transaction before the update of the target data based on the transaction and the other transaction is completed, an exclusive check for detecting the creation request of the object with the same name as the object in the other transaction is detected. Steps and
If a request to create the object with the same name is detected in the other transaction in the exclusive check step before the update of the target data based on the transaction and the other transaction is completed, the execution of the other transaction is interrupted. A wait step to make it wait and
A notification step for notifying a user of the other transaction of the target list of the target data which is the execution target of the transaction, and a notification step.
A transaction confirmation step that commits the transaction when the execution of the transaction is completed and rolls back the transaction when an error occurs in the execution of the transaction.
When the transaction is committed or rolled back in the transaction confirmation step, the wait release step for canceling the wait for another transaction and the wait release step.
When the transaction is committed, an update step for updating the target data stored in the target data storage means based on the transaction, and an update step.
A restriction step that restricts the update of the target data updated in the update step, and a restriction step.
When the target data included in the target list notified in the notification step is selected as the overwriting update target by the user, the overwriting update target specifying step for specifying the target data of the overwriting update target ,
To execute ,
In the update step
Further, when the target data of the overwriting update target is specified in the overwriting update target specifying step, the restriction in the restriction step is released, and the data is stored in the target data storage means based on the separate transaction. An optimistic exclusive processing serialization program for updating the target data to be updated .

Images