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
A recovery algorithm for a high-performance memory-resident database system
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
ACM Transactions on Database Systems (TODS)
Implementation techniques for main memory database systems
SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
System M: A Transaction Processing Testbed for Memory Resident Data
IEEE Transactions on Knowledge and Data Engineering
Main Memory Database Systems: An Overview
IEEE Transactions on Knowledge and Data Engineering
Incremental Recovery in Main Memory Database Systems
IEEE Transactions on Knowledge and Data Engineering
An Evaluation of Starburst's Memory Resident Storage Component
IEEE Transactions on Knowledge and Data Engineering
Checkpointing Memory-Resident Databases
Proceedings of the Fifth International Conference on Data Engineering
Post-crash Log Processing for Fuzzy Checkpointing Main Memory Databases
Proceedings of the Ninth International Conference on Data Engineering
Recovering from Main-Memory Lapses
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Dalí: A High Performance Main Memory Storage Manager
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Hi-index | 0.00 |
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 onlv 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.