https://gpttutorpro.com/distributed-concurrency-control-in-databases/