The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.06 - June (2005 vol.17)
pp: 796-807
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.
INDEX TERMS
Concurrency, relational databases, transaction processing.
CITATION
Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael W. Watzke, "Locking Protocols for Materialized Aggregate Join Views", IEEE Transactions on Knowledge & Data Engineering, vol.17, no. 6, pp. 796-807, June 2005, doi:10.1109/TKDE.2005.96
21 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool