Back to Browse

23. Two Phase Locking (2PL) | System Design

34.8K views
Sep 9, 2023
41:24

➡️ Notes: Shared in the Member Community Post (If you are Member of this channel, then pls check the Member community post, i have shared the Notes link there) ➡️ Join this channel to get access to member only perks: https://www.youtube.com/channel/UCDJ2HAZ_hW-DMJj_U0zN38w/join Topics i have covered: - Basic 2PL and its issues (Deadlock and Cascading Abort) - Conservative 2PL - Rigorous 2PL Distributed Concurrency Video link https://youtu.be/D3XhDu--uoI Chapters: 00:00 - Introduction 00:41 - Basic 2PL 08:56 - Deadlock, 1st Issues with Basic 2PL 14:30 - Timeout, Deadlock Prevention Strategy 16:30 - WFG(Wait for Graph), Deadlock Prevention Strategy 21:42 - Conservative 2PL, Deadlock Prevention Strategy 24:52 - TimeStamp, Deadlock Prevention Strategy 29:14 - Cascading Abort, 2nd Issue with Basic 2PL 32:37 - Rigorous or (Strong Strict 2PL), Cascading Abort Prevention Strategy 34:45 - Example of Each #concurrency #systemdesign #softwareengineer

Download

1 formats

Video Formats

360pmp468.0 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

23. Two Phase Locking (2PL) | System Design | NatokHD