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.
IOS Press, Inc.
6751 Tepper Drive
Clifton, VA 20124
Tel.: +1 703 830 6300
Fax: +1 703 830 2300 firstname.lastname@example.org
(Corporate matters and books only) IOS Press c/o Accucoms US, Inc.
For North America Sales and Customer Service
West Point Commons
Lansdale PA 19446
Tel.: +1 866 855 8967
Fax: +1 215 660 5042 email@example.com