Book Chapter10.1007/3-540-46439-5_32
Persistent Client-Server Database Sessions
Roger Barga,David B. Lomet,Thomas Baby,Sanjay Agrawal +3 more
- 27 Mar 2000
- pp 462-477
TL;DR: This paper shows how to provide persistent database sessions to client applications across server failures, without the application itself needing to take measures for its recoverability, and presents early results from a performance evaluation on the costs to persist and recover ODBC database sessions.
read more
Abstract: 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 database server failure and re-map the virtual session to a new session into which we install the saved old session state once the server has recovered. This integrates database server recovery and transparent session recovery. The result is persistent client-server database sessions that survive a server crash without the client application being aware of the outage, except for possible timing considerations. We demonstrate the viability of this approach by describing the design and implementation of Phoenix/ODBC, a prototype system that provides persistent ODBC database sessions; and present early results from a performance evaluation on the costs to persist and recover ODBC database sessions.
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
Citations
Patent
Spoken language interface
Michael Gadd,Keiron Trott,Heung Wing Tsui,Mark Stairmand,Mark Lascelles,David Horowitz,Peter Lovatt,Peter Phelan,Kerry Robinson,Gordon Sim +9 more
- 28 Feb 2002
TL;DR: In this article, a spoken language interface comprises an automatic speech recognition system (22) and a text to speech system (26) controlled by a voice controller (19), the ASR and TTS are connected to a telephony system which receives user speech via a communications link.
348
Patent
Universal data management interface
Jasmin Cosic
- 04 Mar 2005
TL;DR: A universal data management interface (UDMI) as discussed by the authors is a system that allows multiple virtual databases that reside in a single database to be available as a network service, allowing multiple users to access, manage, and manipulate data within each of the multiple standard database management systems.
158
Patent
Data reduction techniques in a flash-based key/value cluster storage
David Meiri,Anton Kucherov,Vladimir Shveidel +2 more
- 31 Mar 2014
TL;DR: In this article, a method for splitting empty RAID stripes into sub-stripes and storing pages into the substripes based on a compressibility score is proposed, where pages are stored in a temporary location.
105
Patent
System and method for enabling a client application to operate offline from a server
Theron Tock
- 17 Sep 2003
TL;DR: In this paper, a client application registers a request entry with a scheduler, informing the scheduler of associated application callback, and then invokes this application callback when a network connection is available for use, and the client application then sends the request to the server.
96
Patent
Persistent stateful component-based applications via automatic recovery
Roger Barga,David B. Lomet +1 more
- 29 Jun 2004
TL;DR: In this paper, a virtual component is re-mapped to a new physical component, and the operations required to recreate a component and reinstall state up to the point of the last logged interaction is replayed from the log automatically.
93
References
Principles of transaction-oriented database recovery
Theo Haerder,Andreas Reuter +1 more
TL;DR: A terminological framework is provided for describing different transactionoriented recovery schemes for database systems in a conceptual rather than an implementation-dependent way by introducing the terms materialized database, propagation strategy, and checkpoint, and a means for classifying arbitrary implementations from a unified viewpoint.
ARIES: a transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging
TL;DR: ARIES as discussed by the authors is a database management system applicable not only to database management systems but also to persistent object-oriented languages, recoverable file systems and transaction-based operating systems.
The Recovery Manager of the System R Database Manager
Jim Gray,Paul McJones,M. W. Blasgen,Bruce G. Lindsay,Raymond A. Lorie,T. G. Price,Franco Putzolu,Irving L. Traiger +7 more
TL;DR: The recovery subsystem of an experimental data management system is described and evaluated and the DO-UNDO-REDO protocol allows new recoverable types and operations to be added to the recovery system.
Enhancing throughput over wireless LANs using channel state dependent packet scheduling
Pravin Bhagwat,Partha P. Bhattacharya,Arvind Krishna,Satish K. Tripathi +3 more
- 24 Mar 1996
TL;DR: This work compares a variety of channel state dependent packet (CSDP) scheduling methods with a view towards enhancing the performance of the transport layer sessions and indicates that by employing a CSDP scheduler at the wireless LAN device driver level, significant improvement in the channel utilization can be achieved in typical wireless LAN configurations.
382
Patent
System and method for representing named data streams within an on-disk structure of a file system
Kayuri Patel,Mark Muhlestein +1 more
- 08 Sep 2003
TL;DR: In this article, a technique for on-disk representations of multiple named data streams for a file system of a network storage appliance is proposed, where files are described by inodes of which there may be various types, including directory and regular modes.
198
Related Papers (5)
Jim Gray,Andreas Reuter +1 more
- 01 Jan 1992
Carol L. Colrain,Stefan Heinrich Roesch,Kevin S. Neel +2 more
- 07 Sep 2012
Roger Barga,David B. Lomet +1 more
- 29 Jun 2004