18 th International Conference on Knowledge-Based and Intelligent Information & Engineering Systems - KES2014 An implementation of concurrency control between batch update and online entries

Databases of business systems are generally updated by two methods: the online entries reflect the input from a lot of terminals immediately; the batch update updates a great deal of data in a lump. Here, the batch update usually takes time. So, in the case where it is performed as a single transaction by using the lock, the conflicting online entries wait for a long while. For this problem, we had proposed the temporal update method, and showed the both can be executed concurrently by it. However, to process them by a serializable schedule, the execution timing of the online entries has to be divided by the batch update. So, it raises a problem that there are still latencies of some online entries by this. In this article, we propose four concurrency control methods to shorten this wait. And, we show their implementations and evaluation results. Moreover, we show the appropriate method should be chosen based on the operational requirements c