Question

short note on concurrency control

Answer 1

In this Phase 1 Discussion Board 2 (P1 DB2) on the topic “Advanced Database Concepts”, there are two primary processes (1) transaction management and (2) concurrency control in database management system (DBMS):Transaction management (TM) handles all transactions properly in DBMS. Database transactions are the events or activities such as series of data read/write operations on data object(s) stored in database system (Larson, Blanas, Diaconu, Freedman, Patel, & Zwilling, 2011).Concurrency control (CC) is a process to ensure that data is updated correctly and appropriately when multiple transactions are concurrently executed in DBMS (Connolly & Begg, 2015).