- 공유 데이터베이스 환경에서 고성능 트랜잭션 처리를 위한 버퍼 무효화 기법
- ㆍ 저자명
- 김신희,배정미,강병욱
- ㆍ 간행물명
- 정보시스템연구
- ㆍ 권/호정보
- 1997년|6권 1호|pp.159-180 (22 pages)
- ㆍ 발행정보
- 한국정보시스템학회
- ㆍ 파일정보
- 정기간행물| PDF텍스트
- ㆍ 주제분야
- 기타
Database sharing system(DBSS) refers to a system for high performance transaction processing. In DBSS, the processing nodes are locally coupled via a high speed network and share a common database at the disk level. Each node has a local memory, a separate copy of operating system, and a DBMS. To reduce the number of disk accesses, the node caches database pages in its local memory buffer. However, since multiple nodes may be simultaneously cached a page, cache consistency must be ensured so that every node can always access the latest version of pages. In this paper, we propose efficient buffer invalidation schemes in DBSS, where the database is logically partitioned using primary copy authority to reduce locking overhead. The proposed schemes can improve performance by reducing the disk access overhead and the message overhead due to maintaining cache consistency. Furthermore, they can show good performance when database workloads are varied dynamically.