 |
ransaction models depend on transactions, which are ACID-compliant blocks of code. Flip back to Chapter 1 for more detail on the properties of ACID-compliant transactions. This chapter defines common transactions and demonstrates how they work. We’ll focuses on how ACID-compliant transactions work in a Multiversion Concurrency Control (MVCC) system, such as a commercial database. MVCC prevents one user from inadvertently interfering with or harming another user’s work. |
The smallest transaction in a database is a single SQL statement that inserts, ...
Get Oracle Database 11g & MySQL 5.6 Developer Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
