arrow
Return

Locking protocols for materialized aggregate join views

delete2005-06-01
delete9
delete
OA
AI
G
Gang Luo
J
Jeffrey F. Naughton
DOI:10.1109/TKDE.2005.96delete
deleteOriginal
deleteShare
deleteSave
View PDF
Abstract

Abstract

En 中文
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.
Keywords:
concurrency
relational databases
transaction processing
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

IEEE Transactions on Knowledge and Data Engineering cover
IEEE Transactions on Knowledge and Data Engineering
IF:
10.4
Papers:
6.8K
Citations:
3.2W

Organization

No organization information available
Cited Papers

Cited Papers

A xeno-transplantable plasma cell leukemia line with a split translocation of the IgH gene
err2003-07-01
err0
PREAI
errKaneyuki Ohbayashi; Masafumi Taniwaki; Manabu Ninomiya; Hitoshi Kiyoi; Shinsuke Iida; Ryuzo Ueda; Tomoki Naoe
errShare
errSave
err
IF0
err
err0
PREAI
err
errShare
errSave
no more