Lec-87: Why Indexing is used | Indexing Beginning | DBMS
This video explains Why we need indexing from very basics. Concept of indexing is very important for GATE UGC NET and specially Interviews.
Lec-86: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS
► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal ►Subscribe to ou
Lec-85: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS
0:00 - Introduction 0:39 - Timestamp Ordering Protocol 3:08 - Timestamp of Transaction 3:38 - Read TS (RTS) 5:12 - Write TS (WTS) 6:24 - Rules of Timestamp ► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2:
Lec-84: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS
0:00 - Introduction 1:03 - Strict 2PL 7:06 - Rigorous 2PL 9:49 - Conservative 2PL ► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2j
Lec-83: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS
0:00 - Introduction 1:02 - Problem 1 4:13 - Problem 2 6:45 - Problem 3 8:57 - Problem 4 ► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4K
Lec-82: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS
► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal ►Subscribe to ou
Lec-81: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-2
0:00 - Introduction 0:25 - Problem 1 3:31 - Problem 2 5:44 - Problem 3 8:01 - Problem 4 ► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4K
Lec-80:Shared Exclusive Locking Protocol with Example in Hindi | Concurrency Control | DBMS | Part-1
► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal ►Subscribe to ou
Lec-79: Why View Serializability is Used | Introduction to View Serializability | DBMS
0:00 - Introduction 0:25 - Check Conflict Serializable 4:39 - View Serializable DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal ► Full course of DBMS https://www.y
Lec-78: Conflict Serializability | Precedence Graph | Transaction | DBMS
► Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y DBMS Notes: File 1: https://drive.google.com/file/d/14bXNQ8BRqYj_F5Q0h9kjCu5dBV_-Yc3h/view?… File 2: https://drive.google.com/file/d/1O4KdWod2jd3ja5kK62Fskqst-Wkz80R4/view?… Contributed by: Anurag Singhal ►Subscribe to ou