If we assume that we would need a 4-byte number to lock each user’s record to resolve our atomicity problems, we would require a total 36MB memory.
why does the lock require 4 bytes per row? do we need the storage even if the lock is not being used?