DBMS

Interactive Explainers

• ACID Properties
• Vertical vs. Horizontal Scaling
• Normalization vs Denormalization
• Indexing
• Shared Lock vs Exclusive Lock
• Conflict Serializability
• Concurrency Control Protocols

Questions:

• When multiple users try to modify the exact same record at the exact same millisecond, how do you prevent lost updates and corrupted data without tanking database performance?
• 2,00,000 users add Maggi to their cart simultaneously. There are only 340 packets in the dark store. How do we prevent 1,99,660 broken hearts at checkout without crashing the app?

See also: SQL notes in their own repository.