트랜잭션 우선 순위 상승을 이용한 분산 실시간 병행수행제어 기법

A Distributed Real-Time Concurrency Control Scheme using Transaction the Rise of Priority

  • 이종설 (삼성전자 무선사업부) ;
  • 신재룡 (충북대학교 정보퉁신공학과) ;
  • 조기형 (충북대학교 전기전자공학부) ;
  • 유재수 (충북대학교 전기전자공학부)
  • Lee, Jong-Sul (Wireless Business Part, Samsung Electronics Corporation) ;
  • Shin, Jae-Ryong ;
  • Cho, Ki-Hyung (Dept. of Electrical Elecronic Engineering, Chungbuk National University) ;
  • Yoo, Jae-Soo (Dept. of Electrical Elecronic Engineering, Chungbuk National University)
  • 발행 : 2001.09.01

초록

실시간 데이터베이스 시스템이 분산환경으로 확장됨에 따라 기존의 실시간 병행수행 제어 기법을 분산환경으로 적용할 필요성이 대두되었다. 이에 본 논문에서는 중복 저장(replication)을 지원하는 분산 실시간 데이터베이스 시스템을 위한 효율적인 병행수행 제어 기법을 제안한다. 제안하는 기법은 중복 저장을 지원하는 분산 실시간 환경에서 완료준비 단계에 도달한 트랜잭션의 우선 순위를 상승시킴으로써 트랜잭션의 완료를 최대한 보장하며 완료 준비 단계에서 재시작 되는 트랜잭션을 줄이고 잠금 지연 시간을 최소화한다. 도한, 우선 순위가 상승된 트랜잭션이 점유한 데이터에 대한 대여(lending)를 허용함으로써 데이터를 차용(borrowing)한 트랜잭션의 대기시간이 감소되고 전체적인 시스템 성능이 향상되었다. 제안한 기법에 대한 성능 평가에서는 Firm 실시간 데이터베이스 환경에서 2단계 완료 기법을 기반으로 DO2PL_PA와 MIRROR 기법을 대상으로 트랜잭션의 도착율, 크기, 쓰기 가능성 및 데이터 중복율에 대한 마감시한 초과비율을 비교한다.

As real-time database systems are extended to the distributed computing environment, the need to apply the existing real-time concurrency control schemes to the distributed computing environment has been made. In this paper we propose an efficient concurrency control scheme for distributed real-time database system. Our proposed scheme guarantees a transaction to commit at its maximum, reduces the restart of a transaction that is on the prepared commit phase, and minimizes the time of the lock holding. This is because it raises the priority of the transaction that is on the prepared commit phase in the distributed real-time computing environment. In addition, it reduces the waiting time of a transaction that owns borrowed data and improves the performance of the system, as a result of lending the data that the transaction with the raised priority holds. We compare the proposed scheme with DO2PL_PA(Distributed Optimistic Two-Phase Locking) and MIRROR(Managing Isolation in Replicated Real-time Object Repositories) protocol in terms of the arrival rate of transactions, the size of transactions, the write probability of transactions, and the replication degree of data in a firm-deadline real-time database system based on two-phase commit protocol. It is shown through the performance evaluation that our scheme outperforms the existing schemes.

키워드

참고문헌

  1. C. Mohan, B. Lindsay and R. Obermarck, 'Transaction Management in the R* Distributed Database Management System,' ACM TODS, 11(4), 1986 https://doi.org/10.1145/7239.7266
  2. Franaszek, P.A., Haritsa, J.R., Robinson, J.T. and Thomasian, A., 'Distributed concurrency control based on limited wait-depth,' Parallel and Distributed Systems, IEEE Transactions on Volume: 4, Page(s): 1246-1264, 1993 https://doi.org/10.1109/71.250103
  3. Kwok-Wa Lam, Lee, V.C.S., Kam-Yiu Lam and Sheung-Lun Hung 'Parallel and Distributed Real-Time Systems,' Proceedings of the 4th International Workshop on, Page(s): 122-125, 1996
  4. Michael J. Carey. and Miron Livny. 'Distributed Concurrency Control Performance: A Study of Algorithm, Distribution, and Replication,' Proceedings of the 14th VLDB Conference, Los Angels, California Page(s): 13-25, 1988
  5. Thomasian, A., 'Distributed optimistic concurrency control methods for high-performance transaction processing,' Knowledge and Data Engineering, IEEE Transactions on Volume: 10, 1, Jan.-Feb., 1998 https://doi.org/10.1109/69.667102
  6. Baothman, F., Sarje, A.K. and Joshi, R.C., 'On optimistic concurrency control for RTDBS,' TENCON '98. 1998 IEEE Region 10 International Conference on Global Connectivity in Energy, Computer, Communication and Control Volume: 2, Page(s): 615-618 vol.2, 1998 https://doi.org/10.1109/TENCON.1998.798291
  7. Son, S., 'Advances In Real-Time Systems,' Prentice Hall, 1995
  8. Xiong, M., Ramamritham, K., Haritsa, J. and Stankovic, J., 'MIRROR: A State-Conscious Concurrency Control Protocol in Replicated Real-time Database,' Technical Report 98-36, Department of Computer Science, University of Massachusetts at Amherst, 1998
  9. Carey, M., and Linvy, M., 'Conflict Detection Tradeoffs for Replicated Data,' ACM Transactions on Database Systems, Vol. 16, Page(s): 703-746, 1991 https://doi.org/10.1145/115302.115289
  10. Haritsa, J. R., Carey, M.J. and Livny, M., 'Dynamic real-time optimistic concurrency control,' Real-Time Systems Symposium, Proceedings., 11th, Page(s): 94-103, 1990 https://doi.org/10.1109/REAL.1990.128734
  11. Gupta, R., Haritsa, J., Ramamritham, K. and Seshadri, S., 'Commit processing in distributed real-time database systems,' Real-Time Systems Symposium, 17th IEEE, Page(s): 220-229, 1996 https://doi.org/10.1109/REAL.1996.563719