![]() ![]() In addition, this chapter helps you understand the functionality of database management systems, with special reference to online transaction processing (OLTP). The purpose of this chapter is to introduce the fundamental technique of concurrency control, which provides database systems with the ability to handle many users accessing data simultaneously. In parallel with this chapter, you should read Chapter 20 of Thomas Connolly and Carolyn Begg, "Database Systems A Practical Approach to Design, Implementation, and Management", (5th edn.). Multiversion techniques based on timestamp orderingĪt the end of this chapter you should be able to:ĭescribe the nature of transactions and the reasons for designing database systems around transactions.Įxplain the causes of transaction failure.Īnalyse the problems of data management in a concurrent environment.Ĭritically compare the relative strengths of different concurrency control approaches.Multiversion concurrency control techniques.Concurrency control based on timestamp ordering.Wait-die or wound-wait deadlock prevention protocol.Ordering data items deadlock prevention protocol.Guaranteeing serialisability by two-phase locking (2PL).Locking techniques for concurrency control.Desirable properties of transactions (ACID).Uncommitted dependency (or dirty read / temporary update).Interleaved vs simultaneous concurrency.Transaction states and additional operations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |