Thumbnail
Access Restriction
Open

Author Woo, Seungkyoon ♦ Ho, Myoung ♦ Yoon, Kim ♦ Lee, Joon
Source CiteSeerX
Content type Text
Publisher IEEE Computer Society
File Format PDF
Language English
Subject Domain (in DDC) Computer science, information & general works ♦ Data processing & computer science
Subject Keyword Fuzzy Checkpointing ♦ Log Record ♦ Main Memory Database ♦ Physical Logging Scheme ♦ Logical Logging Scheme ♦ Reapplying Rule ♦ Asynchronous Backup Activity ♦ Effective Method ♦ Analytic Analysis ♦ Log Data ♦ Physical Logging ♦ Hybrid Logging Method ♦ Recovery Work ♦ Recovery Time ♦ Physical Log Record
Description In Proceedings of the International Database Engineering and Applications Symposium
This paper presents a simple and effective method to reduce the size of log data for recovery in main memory databases. Fuzzy checkpointing is known to be very efficient in main memory databases due to asynchronous backup activities. By this feature, most recovery works in the past have used only physical logging schemes. Since the size of physical log records is quite large, physical logging schemes cause the recovery time to be much longer than that using logical logging schemes. In this paper, we propose a hybrid logging method that can accommodate logical logging under fuzzy checkpointing. This method significantly decreases the size of log data, and hence speeds up the recovery time. We also propose a reapplying rule in segmented MMDB, which reduces the number of log records for recovery. We evaluate the performance of the proposed methods through analytic analyses. The results show that we can reduce the size of log data to more than half, compared with those that use only physical logging.
Educational Role Student ♦ Teacher
Age Range above 22 year
Educational Use Research
Education Level UG and PG ♦ Career/Technical Study
Learning Resource Type Article
Publisher Date 1997-01-01