The Optimal Locking Problem in a Directed Acyclic Graph, [report]

Henry F. Korth
1981 unpublished
We assume a multiple granularity database locking scheme similar to that of Gray, et al. [1975] in which a rooted directed acyclic graph is used to represent the levels of granularity. We prove that even if it is known in advance exactly what database references the transaction will make, it is MP-complete to find the optimal locking strategy for the transaction.
doi:10.21236/ada324623 fatcat:aksxvmve7bfdvpkxdzipxqyj5m