Sciweavers

IDEAS
1997
IEEE

Accommodating Logical Logging under Fuzzy Checkpointing in Main Memory Databases

13 years 7 months ago
Accommodating Logical Logging under Fuzzy Checkpointing in Main Memory Databases
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 phy...
Seung-Kyoon Woo, Myoung-Ho Kim, Yoon-Joon Lee
Added 06 Aug 2010
Updated 06 Aug 2010
Type Conference
Year 1997
Where IDEAS
Authors Seung-Kyoon Woo, Myoung-Ho Kim, Yoon-Joon Lee
Comments (0)