Français
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.
6.1 Competition control
In a multi-user context,...
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Transactions
Conclusion
Bibliography
References
Standardization
- Technologies de l'information. Langage de base de données SQL - NF ISO/CEI 9075 - 9-94
Software
(non-exhaustive list)
UDB, DB2, IBM http://www.ibm.com/db2
SQL Server 2005, Microsoft http://www.microsoft.com/france/sql/sql2005/
Organizations
Transaction Processing Performance Council (TPC) http://www.tpc.org/
World Wide Web Consortium (W3C) http://www.w3.org/
The Ultimate Scientific and Technical Reference
