Persistent Client-Server Database Sessions

Database systems support recovery, providing high database availability. However, database applications may lose work because of a server failure. In particular, if a database server crashes, volatile server state associated with a client application’s session is lost and applications may require operator-assisted restart. This prevents masking server failures and degrades application availability. In this paper, we show how to provide persistent database sessions to client applications across server failures, without the application itself needing to take measures for its recoverability. This offers improved application availability and reduces the application programming task of coping with system errors. Our approach is based on (i) capturing client application’s interactions with the database server and (ii) materializing database session state as persistent database tables that are logged on the database server. We exploit a virtual database session. Our procedures detect data...

• Type: Conference
• Year: 2000
• Where: EDBT
• Authors: Roger S. Barga, David B. Lomet, Thomas Baby, Sanjay Agrawal
• Keywords: Computer Science, Database, Database Server, Database Sessions, EDBT 2000