Title :
Effects of update techniques on main memory database system performance
Author :
Yuwei Chen ; Jing Huang
Author_Institution :
Sch. of Comput. Sci., Oklahoma Univ., Norman, OK
Abstract :
Update technique is an important issue related to database recovery. In a main memory database environment, transaction execution can be processed without any I/O, and all I/O operations involved are for recovery purposes. The efficiency of update techniques therefore has an important impact on the performance of main memory database systems. We compared the techniques of immediate and deferred update based on a database machine, MARS. The simulation results showed that immediate update outperforms deferred update unless system failure is a frequent occurrence
Keywords :
database management systems; software performance evaluation; system recovery; transaction processing; MARS; database machine; database recovery; deferred update; immediate update; main memory database system performance; simulation results; system failure; transaction execution; transaction processing; update techniques; Algorithm design and analysis; Analytical models; Buffer storage; Computer Society; Computer crashes; Database machines; Database systems; Frequency; Mars; Transaction databases;
Journal_Title :
Knowledge and Data Engineering, IEEE Transactions on
