V Locking Protocol for Materialized Aggregate Join Views on B-Tree Indices
Immediate materialized view maintenance with transactional consis tency is highly desirable to support real-time decision making. Nevertheless, due to high deadlock rates, such maintenance can cause significant performance degradation in the database system. To increase concurrency during such main tenance, we previously proposed the V locking protocol for materialized aggre gate join views and showed how to implement it on hash indices. In this paper, we address the thorny problem of implementing the V locking protocol on B tree indices. We also formally prove that our techniques are both necessary and sufficient to ensure correctness (serializability).
Gang Luo
IBM T.J. Watson Research Center
国际会议
11th International Conference,WAIM 2010(第十一届网络时代管理国际会议)
九寨沟
英文
768-780
2010-07-14(万方平台首次上网日期,不代表论文的发表时间)