Optimistic Concurrency Control based on 2-Version and TimeStamp for Broadcast Environment : OCC/2VTS

방송환경에서 이중 버전과 타임스탬프에 기반을 둔 낙관적 동시성 제어 기법

  • Lee, Uk-Hyun (Dept.of Computer Science, Graduate School of Chonnam National Universityisy) ;
  • Hwang, Bu-Hyun (Dept.of Computer Science, Chonnam National University)
  • 이욱현 (전남대학교 대학원 전산학과) ;
  • 황부현 (전남대학교 전산학과, 전남대학교 정보통신연구소)
  • Published : 2001.04.01

Abstract

The broadcast environment is asymmetric communication aspect that is typically much greater communication capacity available from server to clients than in the opposite direction. In addition, most of mobile computing systems only allow the generation of read-only transactions from mobile clients for retrieving different types of information such as stock data, traffic information and news updates. Since previous concurrency control protocols, however, do not consider such a particular characteristics, the performance degradation occurs when those schemes are applied to the broadcast environment having quite a high data contention. In this paper, we propose OCC/2VTS (Optimistic Concurrency Control based on 2-Version and TimeStamp) that is most appropriate for broadcast environment. OCC/2VTS lets each client process and commit query transactions for itself by using two version data in cache. If the values of appropriate data items are not changed twice by invalidation report after a query transaction starts, the query transaction is committed safely independent of commitment of update transactions. OCC/2VTS decreases the number of informing server for the purpose of commitment. Due to broadcasting the validation reports including updated recent values, it reduces the opportunity of requesting a recent data values of server as well. As a result, OCC/2VTS makes full use of the asymmetric bandwidth. It also improves transaction throughput by increasing the query transaction commit ratio as much as possible.

방송환경은 서버(server)와 클라이언트간 대역폭이 서버에서 클라이언트쪽으로는 크고 클라이언트에서 서버쪽으로의 대역폭은 상대적으로 많이 작은 비대칭적(asymmetric) 특수한 환경이다. 또한 대부분의 방송 환경 응용시스템들은 클라이언트측에서 발생한 주로 주식 데이터, 교통 정보와 새로운 뉴스와 같은 여러 가지 다양한 정보를 검색하는 읽기전용 즉 질의 거래들을 허락한다. 그러나, 기존의 여러 가지 동시성 제어 기법들은 이러한 특수성을 고려하지 않음으로써 꽤 높은 데이터 경쟁 상태의 방송 환경에 적용될 때 성능 감소가 일어난다. 이 논문에서는 방송환경에서 가장 적절한 OCC/2VTS(Optimistic Concurrency Control based on 2-Version and TimeStamp)를 제안한다. OCC/2VTS는 캐쉬 내에 두 버전을 사용함으로써 타임스탬프 기법으로 클라이언트가 질의 거래를 자체 해결 할 수 있도록 하였다. 질의 거래 시작 후 2번의 무효화 방송을 통해 읽기 연산 대상 데이터 항목의 값이 바뀌지 않는다면 질의 거래가 갱신 거래의 완료와 상관없이 무사히 완료된다. 그 결과 첫째, 서버에게 완료 요구를 위해 정보를 보내는 기회가 감소하고 무효화 보고서 내에 갱신된 최신의 값을 포함하여 클라이언트들에게 방송함으로써 최근 데이터 값을 서버에게 요구하는 기회를 줄여 비대칭적 대역폭을 효율적으로 활용한다. 둘째, 질의 거래의 완료율을 최대한 높여 처리율을 향상시킨다.

Keywords

References

  1. S. Acharva, M. Franklin and S. Zdonik, 'Balancing Push and Pull for Data Broadcast,' Proceedings of ACM SIGMOD Conference on Management of Data, May 1997 https://doi.org/10.1145/253260.253293
  2. S. Acharya, R. Alonso. M. Franlikn and S. Zdonik, 'Broad-cast Disks: Data Management for Asymmetric Communication Environments,' Proceedings of ACM SIGMOD Conference on Management of Data, May 1997
  3. S. Acharya, M. Franklin and S. Zdonik, 'Disseminating Updates on Broadcast Disks,' Proceedings of the 22nd VLDB Conference, Mumbai, India, 1996
  4. D. Aksoy, M. Franklin, 'On-Demand Broadcast Scheduling,' Technical Report, CS-TR-3854, University of Maryland, 1997
  5. D. Barbara and T. Imielinsky, 'Sleepers and Workholics : Caching in Mobile Environment,' Proceedings of ACM SIGMOD Conference on Management of Data, pp.1-12, June 1994
  6. J. Cay, K Tan and B. C. Ooi, 'On Incremental Cache Coherency Schemes in Mobile Computing Environments,' Proceedings of the 13th International Conference on Data Engineering, pp.114-123, April 1997 https://doi.org/10.1109/ICDE.1997.581744
  7. C. F. Fong, C. S. Lui and M. H. Wong, 'Quantifying Complexity and Performance Gains of Distributed Caching in a Wireless Network Environment,' Proceedings of the 13th International Conference on Data Engineering, pp.104-113, April 1997 https://doi.org/10.1109/ICDE.1997.581743
  8. J. Jing, A. Elmagarmid, A. Helal and R. Alonso, 'Bit-Sequences: An Adaptive Cache Invalidation Method in Mobile Client/Server Environment,' ACM/Baltzer Mobile Networks and Applications, Vol.2, No.2, 1997 https://doi.org/10.1023/A:1013616213333
  9. K.L.Wu, P.S.Yu and M.S,Chen, 'Energy-efficient Caching for Wireless Mobile Computing,' Proceedings of the 12th International Conference on Data Engineering, pp.336-343, Feb 1996 https://doi.org/10.1109/ICDE.1996.492181
  10. M. J. Franklin, M. J. Carey and M. Livny, 'Transactional Client-Server Cache Consistency: Alternatives and Performance,' ACM Transactions on Database Systems, Vol.22. No.3, pp.315-363, September 1997 https://doi.org/10.1145/261124.261125
  11. D. Barbara, 'Certification Reports : Supporting Transactions in Wireless Systems,' Proceedings of the 17th International Conference on Distributed Computing Systems, pp. 466-473, May 1997 https://doi.org/10.1109/ICDCS.1997.603384
  12. Y. Lee and S. Moon, 'Commit-Reordering Validation Scheme for Transaction Scheduling in Client-Server Based Teleputing Systems: COREV,' Proceedings of International Conference on Information and Knowledge Management, pp.59-66, 1997 https://doi.org/10.1145/266714.266858
  13. E. Pitoura, 'Supporting Read-Only Transactions in Wireless Broadcasting,' Proceedings of the 9th International Workshop on Database and Expert Systems Applications, pp.428-433, 1998 https://doi.org/10.1109/DEXA.1998.707435
  14. E. Pitoura and P. Chrysanthis, 'Scalable Processing of Read-Only Transactions in Broadcast Push,' International Conference on Distributed Computing Systems, Austin, 1999 https://doi.org/10.1109/ICDCS.1999.776545
  15. S. Lee, C. Hwang, W. Lee and H. Yu, 'Caching and Concurrency Control in a Mobile Client/Server Computing Environment,' , 한국정보과학회 논문지, Vo1.26, No.8, August 1999
  16. J. Shanmugasundaram, A. Nithrakashyap, R. Sivasankaran, and K. Ramamritham, 'Efficient Concurrency Control for Broadcast Environments,' ACM SIGMOD, 1999 https://doi.org/10.1145/304182.304190
  17. P. A. Bernstein, V. Hadzilacos and N. Goodman, 'Concurrency Control and Recovery in Database Systems,' Addison Wesley, Reading, Massachusetts, 1987
  18. P. M. Bober and M. J. Carey. 'Multi version Query Locking,' Proceedings of the VLDB Conference, Vancouver, Canada, August 1992
  19. W. Weihl, 'Distributed Version Management for Read-Only Actions,' IEEE Transactions on Software Engineering, 13(1), January 1987
  20. M. Franklin and S. Zdonik, 'Data In Your Face: Push Technology in Prospective'. in Proceedings of 1998 ACM SIGMOD Conference, Seattle, 1998
  21. S. Hameed and N. H. Vaidya, 'Efficient Algorithms for Scheduling Single and Multiple Channel Data Broadcast,' Technical Report 97-002, Department of Computer Science, Texas, A&M University. Feb 1997
  22. T. Imielinski and B. R. Badrinath, 'Mobile Wireless Computing : Challenges in Data Management,' Communications of the ACM, Vol.37, No.10, Oct. 1994 https://doi.org/10.1145/194313.194317
  23. T. Imielinski, S. Viswanathan and B.R. Badrinath, 'Data on Air: Organization and Access,' IEEE Transactions on Knowledge and Data Engineering, Vol 9, No.3, pp.353-372 https://doi.org/10.1109/69.599926
  24. H. V. Leong and Si, A, 'Data broadcasting strategies over multiple unreliable wireless channels,' in Proceedings of the 4th International Conference on Information and Knowledge Management. pp.96-104. November 1995 https://doi.org/10.1145/221270.221339
  25. T. Harder, 'Observations on Optimistic Concurrency Control Schemes,' Information Systems, Vol.9, No.2, pp.111-120, 1984 https://doi.org/10.1016/0306-4379(84)90020-6
  26. Information Systems v.9 no.2 Observations on Optimistic Concurrency Control Schemes T.Harder