loading...
Measuring and Optimizing a System for Persistent Database Sessions
Heidelberg, Germany April 02-April 06
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2001.91481017th International Conference on Data ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Roger S. Barga, Microsoft Corporation
David B. Lomet, Microsoft Corporation
Abstract: High availability for both data and applications is rapidly becoming a business requirement. While database systems support recovery, providing high database availability, applications may still lose work because of server outages. When a server crashes, volatile state associated with the application's database session is lost and the application may require operator-assisted restart. This exposes server failures end-users and always degrades application availability. Our Phoenix/ODBC system supports persistent database sessions that can survive a database crash without the application being aware of the outage, except for possible timing considerations. This improves application availability and eliminates application programming needed to cope with database crashes. Phoenix/ODBC requires no changes to database system, data access routines, or applications. Hence, it can be deployed any application that uses ODBC to access a database. Further, our generic approach can be exploited for a variety of data access protocols. In this paper, we describe the design Phoenix/ODBC and introduce an extension to optimize response time and reduce overhead for OLTP workloads. We present performance evaluation using TPC-C and TPC-H benchmarks that demonstrate Phoenix/ODBC's extra overhead is modest.
Citation:
Roger S. Barga, David B. Lomet, "Measuring and Optimizing a System for Persistent Database Sessions," icde, pp.0021, 17th International Conference on Data Engineering (ICDE'01), 2001
Usage of this product signifies your acceptance of the Terms of Use.