The Community for Technology Leaders
Green Image
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.
Concurrency, relational databases, transaction processing.

G. Luo, J. F. Naughton, M. W. Watzke and C. J. Ellmann, "Locking Protocols for Materialized Aggregate Join Views," in IEEE Transactions on Knowledge & Data Engineering, vol. 17, no. , pp. 796-807, 2005.
80 ms
(Ver 3.3 (11022016))