PDF4PRO ⚡AMP

Modern search engine that looking for books and documents around the web

Example: air traffic controller

Chapter 13. Concurrency Control

Chapter 13. Concurrency ControlTable of contents Objectives Introduction Context Concurrent access to data concept of transaction Transaction states and additional operations Interleaved Concurrency Interleaved vs simultaneous Concurrency Genuine vs appearance of Concurrency Read and write operations Need for Concurrency Control The lost update problem Uncommitted dependency (or dirty read / temporary update) Inconsistent analysis Other problems Need for recovery Transaction problems Desirable properties of transactions (ACID) Atomicity Consistency Isolation Durability or permanency Serialisability Schedules of transactions Serial schedules Non-serial schedules Serialisable schedule Locking techniques for Concurrency Control Types of locks Binary locks Shared and exclusive locks Use of the locking scheme Guaranteeing serialisabilit

recovery are necessary in a database system is then discussed. The concept of an atomic transaction and additional concepts related to transaction processing in database systems are introduced. The concepts of atomicity, consistency, isolation and durability – the so-called ACID properties that are considered desirable in transactions - are ...

Loading..

Tags:

  Database, System, Concept, Database system

Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Spam in document Broken preview Other abuse

Transcription of Chapter 13. Concurrency Control

Related search queries