A client-based logging technique using backward analysis of log in client/server environment
The existing recovery technique using the logging technique in client/server database systems only administers the log as a whole in a server. This recovery technique contains the logging record transmission cost on transactions that are potentially executed in each client and increases network traffic. In this paper, a logging technique for redo-only log is suggested. The new technique removes redundant before-images and supports client-based logging to eliminate the transmission cost of the logging record. Also, in the case of a client crash, redo recovery through a backward client analysis log is performed in a self-recovering way. In the case of a server crash, the after-images of pages which need recovery through simultaneous backward analysis log are only transmitted and redo recovery is accomplished through the received after-image and backward analysis log. We also select a comparison model to estimate the performance of the proposed recovery technique. Finally, in this paper, the superiority of the suggested technique was proved by comparing and analyzing redo time and recovery time of various techniques under changing number of clients and updated operations.
client-based logging log recovery transaction redo backward log analysis