ch10-1 - Chapter 10 Introduction to Transaction Management...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DB must be in a consisten state DB may be in an inconsistent state during this execution DB must be in a consistent state Chapter 10 Introduction to Transaction Management Chapter 10 Introduction to Transaction Management Transaction , is a sequence of database operations organized in a basic unit for keeping database consistent and reliable . A database is in a consistent state if it follows Entity integrity E Referential integrity R Domain value constraints D etc. Execution Begin End of T of T A temporary inconsistent state of a transaction should not be exposed to other transactions. A database should be in a consistent state even if there are a number of concurrent transactions accessing the database. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 10 Introduction to Transaction Management A database is reliable if it is resilient and capable of recovering. A transaction is a sequence of read and write operations on a DB with some special properties (ACID). An SQL statement is a transaction.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/23/2009 for the course DBST 663 taught by Professor Tba during the Spring '09 term at MD University College.

Page1 / 6

ch10-1 - Chapter 10 Introduction to Transaction Management...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online