Data Warehouses in DBMS
Data Warehouses 1. INTRODUCTION 2. TYPES 3. COMPONENTS 4. ARCHITECTURE
Read more
Deadlock in detailed
NOTES https://drive.google.com/file/d/1btqHxrLrai2P9aZgfodqPdzNEjt9bws_/view?usp=sharing
Read more
STARVATION & DEADLOCKS IN DBMS
VIDEO https://www.youtube.com/watch?v=q43c5q8hmnM&t=60s NOTES https://drive.google.com/file/d/1xTqbJghYNFOPrtUwFW-xbpuejhiQQapd/view?usp=sharing
Read more
CONCURRENCY CONTROL #3
VIDEO https://www.youtube.com/watch?v=E_s7iYBXT1Q NOTES https://drive.google.com/file/d/1qq12pknY2U1ECiaS5GB-M7Ee892aD06V/view?usp=sharing
Read more
concurrency control #2,locked based protocol
NOTES https://drive.google.com/file/d/1FfcP6jzJypc6uL-ncN0Gk0w4Qcgo3rBY/view?usp=sharing VIDEO https://www.youtube.com/watch?v=qWpGsr0oBmo&t=508s
Read more
concurrency control in DBMS
Concurrency control in DBMS https://www.youtube.com/watch?v=3riIEJqrroo&t=10s Introduction of Concurrency Control (Concurrency Meaning- parallelism) Concurrency control is the procedure in DBMS for managing simultaneous( parallel ) operations without conflicting with each other. Concurrency control is used to address such conflicts which mostly occur wi…
Read more
Operations and states of Transaction in DBMS
Operations of Transaction: The main operations of the transaction: Read(X) : Read operation is used to read the value of X from the database and store it in a buffer in the main memory. Write(X) : Write operation is used to write or update the value back to the database from the buffer. Example:- Debit transaction from an account : 1. R(X); 2. X = X - 500; …
Read more
Social Plugin