A batch Update Method of Database for Mass Data during Online Entry

In business systems, databases are usually updated by two methods: the online entry is used for update from many terminals concurrently; the batch update is used to update a great deal of data in a lump. Since online entry updates a small amount of data, concurrency control can be performed by locking the data. On the other hand, the batch update locks a great deal of data for a long while. So, if it’s performed concurrently with online entry, it’s performed as the mini-batch that divides the update to shorten the lock time of each unit. However, because this method cannot treat the entire batch update as a single transaction, various constraints occur on system operations. In this paper, we propose a batch update method utilizing the transaction time database that manages the history of time series of its data. And, we show that the ACID property of the transaction can be maintained by this method as a whole batch update.