Abstract
On-time data management is becoming a key difficulty faced by the information infrastructure of most organizations. In fact, database applications for critical areas are increasingly giving more importance to the timely execution of transactions. Database applications with timeliness requirements have to deal with the possible occurrence of timing failures, when the operations specified in the transaction do not complete within the expected deadlines. In spite of the importance of timeliness requirements in database applications, typical commercial DBMS do not assure any temporal properties, not even the detection of the cases when the transaction takes longer than the expected/desired time. This paper discusses the problem of timing failure detection in database applications and proposes a transaction programming approach to help developers in programming database applications with time constraints. The paper illustrates the proposed programming model with a practical example using the Oracle 10g DBMS running a performance benchmark for real-time database applications.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Gray, J., Reuter, A.: Transaction Processing: Concepts and Techniques. The Morgan Kaufmann Series in Data Management Systems. Morgan Kaufmann, San Francisco (1993)
Vieira, M., Costa, A., Madeira, H.: TACID Transactions. In: IEEE/IFIP Intl Conference on Dependable Systems and Networks, 1st Workshop on Hot Topics in System Dependability (HotDep-05), Yokohama, Japan (June 2005)
Ramamritham, K.: Real-Time Databases. Intl Journal of Distributed and Parallel DBs (1996)
Ijzsoyoilu, G., Snodgrass, R.T.: Temporal and Real-Time Databases: A Survey., IEEE Transactions On Knowledge and Data Engineering (1995)
DiPippo, L., Wolfe, V.: Real-Time Databases. In: Database Systems Handbook, Multiscience Press, Brentwood (1997)
Special Section on Advances in Real-Time Database Systems. SIGMOD Record 25(1), 3–40 (1996)
Chandra, T., Toueg, S.: Unreliable Failure Detectors for Reliable Distributed Systems. Journal of the ACM 43(2), 225–267 (1996)
Dwork, L., Stockmeyer, L.: Consensus in the Presence of Partial Synchrony. Journal of the ACM (1988)
Cristian, F., Fetzer, C.: The Timed Asynchronous Distributed System Model. IEEE Transactions on Parallel and Distributed Systems (1999)
Veríssimo, P., Casimiro, A.: The Timely Computing Base Model and Architecture. Trans. on Computers - Special Issue on Asynch. Real-Time Systems (2002)
Lindström, J., Niklander, T.: Benchmark for Real-time Database Systems for Telecom. In: VLDB 2001 Intl Workshop on DB in Telecom. II, Rome, Italy (2001)
Oracle Corporation: Oracle® Database Concepts 10g Release 1 (10.1) (2003)
Vieira, M., Madeira, H.: Recovery and Performance Balance of a COTS DBMS in the Presence of Operator Faults. In: Intl Performance and Dependability Symposium (jointly organized with DSN-2002), IPDS2002, Bethesda, Maryland, USA (June 2002)
Transaction Processing Performance Council: TPC Benchmark C, Standard Specification, Version 5.4 (2005), available at: http://www.tpc.org/tpcc/
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vieira, M., Costa, A.C., Madeira, H. (2007). Towards Timely ACID Transactions in DBMS. In: Kotagiri, R., Krishna, P.R., Mohania, M., Nantajeewarawat, E. (eds) Advances in Databases: Concepts, Systems and Applications. DASFAA 2007. Lecture Notes in Computer Science, vol 4443. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-71703-4_24
Download citation
DOI: https://doi.org/10.1007/978-3-540-71703-4_24
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-71702-7
Online ISBN: 978-3-540-71703-4
eBook Packages: Computer ScienceComputer Science (R0)