O'Reilly logo

Oracle Database 11g & MySQL 5.6 Developer Handbook by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

image

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required