A Cache Consistency Control for B-Tree Indices in a Database Sharing System

데이타베이스 공유 시스템에서 B-트리 인덱스를 위한 캐쉬 일관성 제어

  • Published : 2001.10.01

Abstract

A database sharing system (DSS) refers to a system for high performance transaction processing. In the DSS, the processing nodes are coupled via a high speed network and share a common database at the disk level. Each node has a local memory and a separate copy of operating system. To reduce the number of disk accesses, the node caches data pages and index pages in its memory buffer. In general, B-tree index pages are accessed more often and thus cached at more processing nodes, than their corresponding data pages. There are also complicated operations in the B-tree such as Fetch, Fetch Next, Insertion and Deletion. Therefore, an efficient cache consistency scheme supporting high level concurrency is required. In this paper, we propose cache consistency schemes using identifiers of index pages and page_LSN of leaf page. The propose schemes can improve the system throughput by reducing the required message traffic between nodes and index re-traversal.

데이타베이스 공유 시스템(Database Sharing System:Dss)은 고성능의 트랜잭션 처리를 위해 제안된 구조이다. DSS에서 고속의 통신망으로 연결된 노드들은 별도의 메모리와 운영체제를 가지며, 데이타베이스를 저장하고 있는 디스크 모든 노드에 의해 공유된다. 빈번한 디스크 액세스를 피하기 위해 각 노드는 최근에 액세스한 데이타 페이지와 인덱스 페이지들을 자신의 메로리 버퍼에 캐싱한다. 일반적으로 B-트리 인덱스페이지들은 데이타 페이지에 비해 빈번하게 캐싱되고, Fetch, Fetch Next, 삽입, 그리고 삭제와 같은 복잡한 연산을 수행하므로, 높은 동시성을 지원하는 효율적인 캐쉬 일관성 기법이 필요하다. 본 논문에서는 DSS에서 B-트리 인덱스 페이지의 식별자와 리프 페이지의 PageLSN을 사용한 캐쉬 일관성 기법을 제안한다.

Keywords

References

  1. M. Carey, M. Franklin and M. Zaharioudakis, 'Adaptive, Fine-Grained Sharing in a Client-Server OODBMS : A Callback-Based Approach,' ACM Trans. on Database Syst., Vol.22, No.4, pp.570-627, 1997 https://doi.org/10.1145/278245.278249
  2. A. Dan and P. Yu, 'Performance Analysis of Buffer Coherency Policies in a Multisystem DataSharing Environment, IEEE Trans. on Parallel and Distributed Syst., Vol.4, No.3, pp.289-305, 1993 https://doi.org/10.1109/71.210812
  3. D. DeWitt and J. Gray, 'Parallel Database Systems : The Future of High Performance Database Systems,' Comm. ACM, Vol.35, No.6, pp.85-98, 1992 https://doi.org/10.1145/129888.129894
  4. V. Gottemukkala, E. Omiecinski and U. Ramachandran, 'Relaxed Index Consistency for a Client-Server Database,' in : Proc. 12th lnt. Conf. on Data Eng. pp.352-361, 1996 https://doi.org/10.1109/ICDE.1996.492183
  5. J. Gray and A. Reuter, 'Transaction Processing : Concepts and Techniques,' Morgan Kaufmann Publishers, 1993
  6. C. Mohan et al., 'ARIES : A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging,' ACM Trans. on Database Syst., Vol.17, No.1, pp.94-162, 1992 https://doi.org/10.1145/128765.128770
  7. C. Mohan and F. Levine, 'ARIES/IM : An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging,' in : Proc. ACM SIGMOD, pp.371-380, 1992 https://doi.org/10.1145/130283.130338
  8. C. Mohan and I. Narang, 'Recovery and Coherency Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transaction Environment,' in : Proc. 17th Int. Conf. VLDB, pp.193-207, 1991
  9. C. Mohan and I. Narang, 'Locking and Latching Techniques for Transaction Processing Systems Supporting the Shared Disks Architecture,' IBM Research Report, 1995
  10. E. Rahm, 'Empirical Performance Evaluation of Concurrency and Coherency Control Protocols for Database Sharing Systems,' ACM Trans. on Database Syst., Vol.18, No.2, pp.333-377, 1993 https://doi.org/10.1145/151634.151639
  11. H. Schwetman, 'CSIM User's Guide for use with CSIM Revision 16,' MCC, 1992
  12. M. Zaharloudakis and M. Carey, 'Highly Concurrent Cache Consistency for Indices in Client-Server Database Systems,' in : Proc. ACM SIGMOD, pp.50-61, 1997 https://doi.org/10.1145/253262.253269