Locking protocols for materialized aggregate join views Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, and Michael Watzke   View Paper (PDF)   Return to June 2005, Volume 17, Issue 6 Abstract The maintenance of materialized aggregate join views is a well-studied problem. However, to date the published literature has largely ignored the issue of concurrency control. Clearly, immediate materialized view maintenance with transactional consistency, if enforced by generic concurrency control mechanisms, can result in low levels of concurrency and high rates of deadlock. While this problem is superficially amenable to well-known techniques, such as fine-granularity locking and special lock modes for updates that are associative and commutative, we show that these previous high concurrency locking techniques do not fully solve the problem, but a combination of a "value-based" latch pool and these previous high concurrency locking techniques can solve the problem. ©2006 Association for Computing Machinery