Databases are computer systems designed for storing data.
This note serves as a link to connect database-related notes.
- ACID
- Optimistic LockingOptimistic Locking
Optimistic Locking in [[Database]] systems is a locking mechanism that relies on data versions to stop updates based on stale data.
For example:
user A fetches account data which says amount: 1.../Pessimistic LockingPessimistic Locking
Pessimistic Locking in [[Database]] systems is a locking mechanism that relies on exclusive locks to ensure two transactions don't update rows at the same time.
For example:
user A fetches acco... - Database IndexDatabase Index
[[Database]] indexes are data structures that databases keep on the side to improve the speed of reading the primary data, at the cost of increased storage usage and speed of writes.
Indexes are d...
Status: #🌱 Tags: #🗺️