Journal of KIISE:Databases (한국정보과학회논문지:데이타베이스)

Korean Institute of Information Scientists and Engineers (한국정보과학회)
권호 표지

An Efficient Real-Time Concrrency Control Algorithm using the Feasibility Test

실행가능성검사를 이용한 효율적인 실시간 동시성제어알고리즘

  • Lee, Seok-Jae (Dept. of Information Communication Engineering, Chungbuk National University) ;
  • Sin, Jae-Ryong (Dept. of Information Communication Engineering, Chungbuk National University) ;
  • Song, Seok-Il (Dept. of Information Communication Engineering, Chungbuk National University) ;
  • Yu, Jae-Su (Dept. of Electrical Elecronic Computer Engineering, Chungbuk National University) ;
  • Jo, Gi-Hyeong (Dept. of Electrical Elecronic Computer Engineering, Chungbuk National University) ;
  • Lee, Byeong-Yeop
  • 이석재 (충북대학교 정보통신공학과) ;
  • 신재룡 (충북대학교 정보통신공학과) ;
  • 송석일 (충북대학교 정보통신공학과) ;
  • 유재수 (충북대학교 전기전자 및 컴퓨터공학부) ;
  • 조기형 (충북대학교 전기전자 및 컴퓨터공학부) ;
  • 이병엽 (대우정보시스템 CRM사업팀)
  • Published : 2002.08.01
Download PDF
⟨ Previous Next ⟩

Abstract

The 2PL-HP(Two Phase Locking with High Priority) method has been used to guarantee preceding process of a high priority transaction(HPT) in real-time database systems. The method resolves a conflict through aborting or blocking of a low priority transaction(LPT). However, if HPT is eliminated in a system because of its deadline missing, an unnecessary aborting or blocking of LPT is occurred. Recently, to resolve the problem, a concurrency control algorithm using alternative version was proposed. However, the algorithm must always create the alternative version and needs an addtional technique to manage complex alternative versions. In this paper, we propose an efficient concurrency control algorithm that prevents needless wastes of resources and eliminates unnecessary aborting or blocking of LTP. And it is shown through the performance evaluation that the proposed concurrency control algorithm outperforms the existing concurrency control algorithm using alternative version.

실시간 데이타베이스 시스템에서 높은 우선 순위를 갖는 트랜잭션(High Priority Transaction; HPT)의 선행 처리를 보장하기 위해 2PL-HP(Two Phase Locking with High Priority) 방법이 사용된다. 이 방법은 충돌 발생 시 낮은 우선 순위를 갖는 트랜잭션(Low Priority Transaction; LPT)을 철회 또는 대기시킴으로써 충돌을 해결한다. 그러나 HPT가 마감시간을 지키지 못해서 시스템에서 제거되는 경우에는 LPT의 불필요한 철회 및 대기가 발생된다. 최근에 이러한 문제를 해결하고자 대체버전을 이용한 동시성 제어 알고리즘이 제안되었다. 그러나 이 알고리즘은 항상 대체 버전을 생성해야하며, 또한 복잡한 대체 버전을 관리하기 위한 기법이 추가적으로 요구된다. 본 논문에서는 불필요한 자원의 낭비를 막고 LPT의 불필요한 철회 및 대기를 제거할 수 있는 효율적인 동시성제어 알고리즘을 제안한다. 그리고 성능평가를 통해 제안하는 동시성제어 알고리즘이 기존의 대체버전을 이용한 동시성제어 알고리즘에 비해 성능이 우수함을 보인다.

Keywords

References

  1. Ben Kao and Hector Garcia-Molina, 'An Overview of Real-Time Database Systems,' In Sang H. Son, editor, Advances in Real-Time Systems, chapter 19. Prentice Hall, 1995
  2. Krithi Ramamritham, 'Real-Time Databases,' International Journal of Distributed and Parallel Databases, 1 (2), 1993 https://doi.org/10.1007/BF01264051
  3. G. Ozsoyoglu and R. Snodgrass, 'Temporal and Real-Time Databases: A Survey,' IEEE Transactions on Knowledge and Data Engineering, 7(4):pp.513-532, August 1995 https://doi.org/10.1109/69.404027
  4. N. Redding 'Network Services Databases,' in Proc. of IEEE Global Telecommunications Conference, pp.1336-1340, 1986
  5. R. M. Sivasankaran, B. Purimetla, J. A. Stankovic and K. Ramamritham, 'Network Services Databases A distributed active real-time database applications,' in Proc. of IEEE workshop on Real-Time Applications, pp.184-187, 1993 https://doi.org/10.1109/RTA.1993.263090
  6. S. Hvasshovd, O. Torbjornsem, 'The ClustRa Telecon Databases High Availability, High Throughput, and real-time response,' in Proc. of 21th VLDB, pp.469-477, 1995
  7. John Voelcker, 'How computers helped stampede the stock market,' IEEE Spectrum, Vol.24, pp.30-33, 1987
  8. Jayant R. Haritsa, Michael J. Carey, and Miron Livny, 'Dynamic real-time optimistic concurrency control,' in Proc. of Real-Time Systems Symposium. pp.94-103, 1990 https://doi.org/10.1109/REAL.1990.128734
  9. Jayant R. Haritsa, Michael J. Carey and Miron Livny, 'Earliest Deadline Scheduling for real-time database systems,' In Proc. of Real-Time Systems Symposium, pp.232-242, 1991 https://doi.org/10.1109/REAL.1991.160378
  10. D. Hong, M. Kim, and S. Chakravarthy, 'Incorporating load factor into the scheduling of soft real-time transactions for main memory database,' in Proc. of RTCSA'96, pp.60-66, 1996 https://doi.org/10.1109/RTCSA.1996.554961
  11. Liu C. L., Layland J. W, 'Scheduling Algorithms for Multi-programming In Hard real-time Environment,' 1976
  12. Stankovic J, Spuri M, Natale M D, 'Implications of Classical Scheduling Results for Real-Time Systems,' 1995
  13. Sha L, Rajkumar R, Son S H, Chang C H, 'A Real-Time Locking Protocol,' 1991
  14. Abbott R, Garcia-Molina H, 'Scheduling Real-time Transactions: A Performance Evaluation,' ACM Transactions on Database Systems, 17(3):pp.513-560, 1992 https://doi.org/10.1145/132271.132276
  15. Jayant R. Haritsa, Michael J. Carey and Miron Livny, 'Data Access Scheduling in Firm Realtime Database Systems,' 1992
  16. Lee J, 'Concurrency Control Algorithms for Real-time Database Systems,' 1994
  17. Jayant R. Haritsa, Michael J. Carey and Miron Livny, 'On Being Optimistic About Real-Time Constraints,' In Proceedings of the ACM Symposium on Principles of Database Systems, April 1990 https://doi.org/10.1145/298514.298585
  18. J. Huang, A. Stankovic, 'Experimental Evaluation of Real-Time Concurrency Control Schemes,' Proceedings of the 17th VLDB Conference, pp. 35-46, 1991
  19. Rakesh Agrawal, Michael J. Carey and Miron Livny, 'Concurrency control performance modeling: alternatives and implications,' ACM TODS, Vol.12, No.4, pp.609-654, 1987 https://doi.org/10.1145/32204.32220
  20. Jiandong Huang, John A. Stankovic, Krithi Ramamritham and Don Towsley, 'Experimental evaluation of real-time optimistic concurrency control schemes,' In Proc. of 17th VLDB, pp.35-46, 1991
  21. J. Lee and Sang H. Son, 'Using dynamic adjustment of serialization order for real-time database systems,' in Proc. of Real-Time Systems Symposium. pp.66-75, 1993 https://doi.org/10.1109/REAL.1993.393514
  22. Robbert Abbott and Hector Garcia Molina, 'Scheduling real-time transactions with disk resident data,' in Proc. of 15th VLDB, pp.385- 396, 1989
  23. D. Hong, Sharma Chakravarthy, Theodore Johnson, 'Locking Based Concurrency Control for Integrated Real-Time Database Systems,' RTDB'96, pp.138-143, 1996
  24. Anthony Chiu, Ben Kao, Kam-yiu Lam, 'Comparing two-phase locking and optimistic concurrency control protocols in multiprocessor real-time databases,' Parallel and Distributed Real-Time Systems, pp141-148, 1997 https://doi.org/10.1109/WPDRTS.1997.637965
  25. W. Richard Stevens, 'Advanced Programming in the UNIX Environment,' pp427-550, Addison-Wesley, 1992
  26. 홍동권, '대체 버전을 이용한 펌 실시간 데이타베이스 동시성 제어 방법', 한국정보처리학회논문지, 제5권 제6호, pp.1377-1389, 1998
  27. Albert Mo Kim Cheng, 'Scheduling Transactions in Real-Time Database Systems,' Compcon Spring '93, Digest of Papers, pp222-231, 1993 https://doi.org/10.1109/CMPCON.1993.289670
  28. Patrick E. O'Neil, Krithi Ramamritham, Calton Pu, 'A Two-Phase Approach to Predictably Scheduling Real-Time Transactions,' 1994
  29. Yoshifumi Manabe, Shigemi Aoyagi, 'A Feasibility Decision Algorithm for Rate Monotonic and Deadline Monotonic Scheduling,' 1st Real-Time Technology and Applications Symposium, pp212-218, 1995 https://doi.org/10.1109/RTTAS.1995.516218