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（万方平台首次上网日期，不代表论文的发表时间）