This preview shows page 1. Sign up to view the full content.
Unformatted text preview: followed by selecting only combinations of tuples satisfying r.A = s.B , where A and B are attributes or sets of attributes of relations r and s , respectively. 5. Atomicity : Either all operations of the transaction are reflected properly in the database, or none are. (Responsibility of the recovery system in the database system) Consistency : Execution of a transaction in isolation preserves the consistency of the database. (Responsibility of application programmers) Isolation : Even though multiple transactions may execute concurrently, the system guarantees that each transaction is unaware of other transactions executing concurrently in the system. (Responsibility of the concurrency-control system in the database system) Durability : After a transaction completes successfully, the changes it has made to the database persist, even if there are system failures. (Responsibility of the recovery system in the database system)...
View Full Document
This note was uploaded on 01/11/2012 for the course CS CS4482 taught by Professor Drlee during the Winter '11 term at City University of Hong Kong.
- Winter '11