The KIPS Transactions:PartD (정보처리학회논문지D)

Korea Information Processing Society (한국정보처리학회)
권호 표지
DOI QR코드

DOI QR Code

Design of ALTIBASE(TM) Storage Manager for High Performance and High Availability

고성능 고가용성을 위한 ALTIBASE(TM) 자료저장 관리기의 설계

  • Published : 2003.10.01
Download PDF
⟨ Previous Next ⟩

Abstract

Main memory database systems use the different implementation techniques to sturucture and organize the user dta and system catalogs, since traditional database systems are optimized for the characteristics of disk storage environment. We present, in this paper, the design considerations for our main memory database system $ALTIBASE^{TM}$ that is currently applied to the time-critical applications. We focus on the design issues of storage manager in $ALTIBASE^{TM}$. The major components are introduced, and features and characteristics of transaction management and recovery method are described. We also present the database replication mechanism and its conflict resolution mechanism for high availability and performance. In order to evaluate our transaction performance, we show various experimental reports as measured by the TPS.

기존 디스크 기반 데이터베이스 관리 디스트를 주저장 장치로 활용하는 특징적 환경 때문에 주기억 상주 데이터베이스 관리 시스템의 메모리 관리, 인덱스 관리, 자료저장 관리 기능 등에 대한 설계 및 구현 기술이 기본적으로 다르다. 본 논문에서는 현재 상용 시스템으로 사용되고 있는 $ALTIBASE^{TM}$ 주기억 상주 DBMS 의 설계 및 구현 내용을 기술한다. 특히 자료저장 관리기의 세부 구성요소에 대한 구조적 특징가 주요 기능인 트랜잭션 처리 기법과 회복 관리 기법에 대하여 기존 DBMS 의 기능가 비교 설명하며, 고가용성을 위한 데이터베이스 이중화 기능 및 이중화 작업 시 발생하는 트랜잭션 충돌 해결 방법에 대하여 설명한다. 또한 $ALTIBASE^{TM}$ 시스템의 성능을 측정하기 위하여 다양한 환경에서 실험된 TPS 결과를 보인다.

Keywords

References

  1. D. Agrawal and V. Krishnaswamy, 'Using Multiversion Data for Non-Interfering Execution of Wirte-Only Transactions,' Proc. of the ACM SIGMOD International Conference on Management of Data, 1991
  2. P. M. Bober and M.J. Carey, 'Multiversion Query Locking,' Proc. of the 18th Conference on Very Large Database, 1992
  3. P. Bohannon, D. F. Lieuwen, R. Rastogi, A. Silberschatz, S. Seshadri, and S. Sudarshan, 'The Architecture of the Dali Main-Memory Storage Manager,' Multimedia Tools and Applications, 4(2), 1997 https://doi.org/10.1023/A:1009662214514
  4. P. Bohannon, J. Parker, R. Rastogi, S. Seshadri, A. snberschatz, and S. Sudarshan, 'Distributed Multi-Level Recovery in Main-Memory Databases,' Proc. of the International Conference on Parallel and Distributed Information Systems, 1996 https://doi.org/10.1109/PDIS.1996.568666
  5. H. Garcia-Molina and K. Salem, 'Main Memory Database Systems: An Overview,' IEEE Transactions on' Knowledge and Data Engineering, 4(6), 1993 https://doi.org/10.1109/69.180602
  6. H. V. jagadish, A. Silberschatz and S. Sudarshan, 'Recovering Main Memory Lapses,' Proc. of the 19th Conference on Very Large Databases, 1993
  7. C. Mohan, 'Repeating History Beyond AREIS,' Proc. of the 25th International Conference on Very Large Databases, 1999
  8. C. Mohan, D. Haderle, B. Lindsay, H. Pirahesh, and P. Schwarz. 'ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging'. ACM Trans. Database Syst., 17(1):94-162, Mar. 1992 https://doi.org/10.1145/128765.128770
  9. K. Ramamritham and P. K. Chrysanthis, 'A Taxonomy of Correctness Criteria in Database Applications,' VLDB Journal, 5(1), 1996 https://doi.org/10.1007/s007780050017
  10. R. Rastogi, S. Seshadri, P. Bohannon, D. W. Leinbaugh, A. Silberschatz and S. Sudarshan, 'Logical and Physical Versioning in Main Memory Databases,' Proc. of the 23rd International Conference on Very Large Databases, 1997
  11. B. Kemme, G. Alonso, 'A New Approach to Developing and Implementing Eager Database Replication Protocols,' ACM Transaction On Database Systems, September, 2000 https://doi.org/10.1145/363951.363955
  12. J. Gray, P. Helland, D. Shasha, 'The Dangers of Replication and a Solution,' In Proc. of the ACM SIGMOD, pp.568-574, 1996 https://doi.org/10.1145/233269.233330