Function and importance of transactions.



Lecture Objectives 

 Function and importance of transactions. 

 Properties of transactions. 

 Concurrency Control 

 Meaning of serializability. 

 How locking can ensure serializability. 

 Deadlock and how it can be resolved. 

 How timestamping can ensure serializability. 

 Optimistic concurrency control. 

 Granularity of locking.

Lecture Objectives 

 Recovery Control 

 Some causes of database failure. 

 Purpose of transaction log file. 

 Purpose of checkpointing. 

 How to recover following database failure. 

 Alternative models for long duration transactions.

Related Questions in others category