6. Transactions
A transaction is an application program consisting of a sequence of SQL instructions (database modification and query). It ends with a commit or a rollback. The DBMS is a multi-user software application that allows the simultaneous execution of several transactions to improve database availability. In addition, it provides each transaction with an execution environment that appears to be isolated from other transactions. The aim of transaction optimization is to detect and resolve undesirable effects that one transaction may produce on other transactions, such as slowing down or preventing validation. Next, we present the mechanisms that control concurrent access to the database and their impact on performance.
In a multi-user context, the DBMS must control concurrent...
You do not have access to this resource.
Exclusive to subscribers. 97% yet to be discovered!
Already subscribed?
Log in!
Ongoing reading
Transactions
Bibliography
References
-
(1) - Oracle Real Application Clusters 10g : Technical White Paper. - Oracle (2005).
-
(2) - ÖZSU (T.), VALDURIEZ (P.) - Principles of Distributed Database Systems. - Prentice Hall (1999).
-
(3) - SQL Server 2005 Analysis...
Standardization
- Technologies de l'information. Langage de base de données SQL - NF ISO/CEI 9075 - 9-94
Organizations
Transaction Processing Performance Council (TPC)http://www.tpc.org/
World Wide Web Consortium (W3C)http://www.w3.org/
You do not have access to this resource.
Exclusive to subscribers. 97% yet to be discovered!
Already subscribed?
Log in!