wonderfully tedius Concurrency Control

https://www.linkedin.com/posts/bytebytego_systemdesign-coding-interviewtips-activity-7268158266227019776-hylk?utm_source=share&utm_medium=member_desktop

transaction-isolation-level

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/odbc/reference/develop-app/transaction-isolation-levels?view=sql-server-ver16

transactions-safe

https://learn.microsoft.com/en-us/dotnet/framework/data/transactions/committing-a-transaction-in-single-phase-and-multi-phase

data-Recvoery

ARIES(Algorithms for Recovery and Isolation Exploiting Semantics) Recovery Algorithm

https://en.wikipedia.org/wiki/Write-ahead_logging

also how to recover from crash during recovery!!!

Git Concurrency in GitHub Desktop

https://github.blog/news-insights/git-concurrency-in-github-desktop/?utm_source=chatgpt.com

Challenge notes:

~~Build a platform to allow million user to query live among a table with billions row in seconds or less in a RElational Database~~

Build a platform that allows millions of users to query a live relational database table containing billions of rows in seconds or less