Log Management and Recovery Technique Using Status Information Table and Fuzzy Checkpoint in Client / Server Database Systems


The Transactions of the Korea Information Processing Society (1994 ~ 2000), Vol. 5, No. 2, pp. 259-269, Feb. 1998
10.3745/KIPSTE.1998.5.2.259,   PDF Download:

Abstract

In this paper, we propose improved techniques about logging, checkpointing, and recovery in a Client-Server database environment. In order to improve the performance of system, a) the log management and processing reduce by the Status Information Table (SIT), b) the dirty pages at clients are wirtten int the status information table when client log records arrive at the server. Our checkpoint scheme is that the server and the clients take checkpoints periodically to ensure correct operations The key features of our scheme are: 1)the server only contains Main-memory databases and a battery backup device log; this reduce the number of input/output achiveities for backup and recovery. 2) the client perform checkpoint; this makes the server acknowledge the page dirtied by the client. 3) database consistency guarantee even during checkpoint using Improved Fuzzy checkpoint. Finally, our system was compared with ESM-CS and ARIES/CSA.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
C. E. In and K. B. Oh, "Log Management and Recovery Technique Using Status Information Table and Fuzzy Checkpoint in Client / Server Database Systems," The Transactions of the Korea Information Processing Society (1994 ~ 2000), vol. 5, no. 2, pp. 259-269, 1998. DOI: 10.3745/KIPSTE.1998.5.2.259.

[ACM Style]
Choi Eui In and Koh Byung Oh. 1998. Log Management and Recovery Technique Using Status Information Table and Fuzzy Checkpoint in Client / Server Database Systems. The Transactions of the Korea Information Processing Society (1994 ~ 2000), 5, 2, (1998), 259-269. DOI: 10.3745/KIPSTE.1998.5.2.259.