Dynamic multi-granularity locking mechanism based on transaction deadline