会议专题

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