O'Reilly logo

Introduction to Database Systems by ITL Education Solutions Limited

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

CHAPTER 9

INTRODUCTION TO TRANSACTION PROCESSING

After reading this chapter, the reader will understand:

  • The four desirable properties of a transaction, which include atomicity, concurrency, isolation, and durability
  • The various states that a transaction passes through during its execution
  • Why the transactions are executed concurrently
  • Anomalies due to interleaved execution of transactions
  • The various possible schedules of executing transactions
  • The concept of serializable schedules
  • Different ways of defining schedule equivalence, which include result equivalence, conflict equivalence, and view equivalence
  • Use of precedence graph in testing schedules for conflict serializability
  • The recoverable and cascadeless schedules
  • SQL transaction statements ...

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