Effects of Update Techniques on Main Memory Database System Performance

Authors:
Le Gruenwald;YuWei Chen;Jing Huang
Affiliations:
-;-;-
Venue:
IEEE Transactions on Knowledge and Data Engineering
Year:
1998

Citing 5
Cited 0

Introduction to simulation and SLAM II (2nd ed.)

Introduction to simulation and SLAM II (2nd ed.)
Concurrency control and recovery in database systems

Concurrency control and recovery in database systems
A Crash Recovery Scheme for a Memory-Resident Database System

IEEE Transactions on Computers
MMDB reload algorithms

SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Performance Measurement of Main Memory Database Recovery Algorithms Based on Update-in-Place and Shadow Approaches

IEEE Transactions on Knowledge and Data Engineering

Quantified Score

Hi-index	0.00

Visualization

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. In this paper, 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.