https://gpttutorpro.com/introduction-to-concurrency-control-in-databases/