Note11-TranProc1

Note11-TranProc1 - CSc 134 Database Management and File...

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

View Full Document Right Arrow Icon
1 CSc 134 Database Management and  File Organization 11. Introduction to transaction  Processing Ying Jin Computer Science Department California state University, Sacramento
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Transaction A transaction is a logical unit of  database processing that includes  one or more access operations,  which is an atomic unit of work that is  either completed in its entirety or not  done at all.  Balance Transfer Example
Background image of page 2
3 Properties of Transactions ACID properties: Atomicity :   A transaction is an atomic unit of  processing; it is either performed in its entirety or not  performed at all. Consistency preservation :   A correct execution of  the transaction must take the database from one  consistent state to another. A consistent state of the database satisfies the constraints  specified in the schema as well as any other constraints  that should hold on the database.
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 ACID properties (cont.): Isolation
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/23/2012 for the course CSC 134 taught by Professor Lee during the Spring '12 term at CSU Chico.

Page1 / 13

Note11-TranProc1 - CSc 134 Database Management and File...

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

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