A Concurrency Control Method for Data Broadcasting in Mobile Computing Environment

이동 컴퓨팅 환경에서 데이타 방송을 위한 동시성 제어 기법

  • 윤혜숙 (충남대학교 전기정보통신공학부) ;
  • 김영국 (충남대학교 전기정보통신공학부)
  • Published : 2004.04.01

Abstract

Data broadcast has received much attention as a very efficient method for disseminating data items in mobile environment with large number of mobile clients. In this approach, a database server periodically and continuously broadcasts data items through wireless channels and clients perform read-only transactions by accessing necessary data items from the air. While broadcasting, the server must also process update transactions on the database, which raises an obstacle for client's accessing consistent data. In this research, we propose a new algorithm SCDSC(Serialization Checking with DirtySet on Commit) which is an alternative for solving the concurrency control problem efficiently. The SCDSC is a kind of optimistic concurrency control in that a client checks the consistency of data using a DirtySet as a part of data broadcast when it commits its transaction. In each broadcast cycle, the server updates and disseminates the DirtySet with newly changed data items for last few cycles in the sliding window approach. We perform an analysis and a simulation study to evaluate the performance of our SCDSC algorithm in terms of data consistency and data currency.

수많은 이동 클라이언트가 있는 이동 사용자 환경에서 데이타 방송 기법은 매우 효과적인 데이타 전달 방식으로 주목을 받고 있다. 이 방식에서 데이타베이스 서버는 데이타를 무선채널을 통해 주기적으로 배포하며 클라이언트는 필요한 데이타를 선택적으로 액세스하는 읽기 전용 트랜잭션을 수행한다. 한편, 서버에서는 데이타 방송과 병행해서 데이타베이스 갱신도 수행하므로 플라이언트가 일관성 있는 데이타를 액세스할 수 있으려면 동시성제어 문제가 해결되어야 한다. 본 연구에서는 이러한 동시성제어 문제를 효율적으로 해결하는 알고리즘인 SCDSC(Serialization Checking with DirtySet on Commit) 기법을 제안한다. SCDSC는 이동 클라이언트에서 다중 데이타를 요구하는 읽기 트랜잭션을 커미트할 때 일반 데이타와 함께 방송된 DirtySet을 점검하여 일관성을 유지하는 일종의 낙관적 동시성 제어기법이다. DirtySet은 일정 방송주기 동안 변경된 데이타 집합으로 방송주기가 바뀔 때마다 슬라이딩 윈도우 방식으로 서버에서 갱신되어 배포된다. 또한, 제안하는 알고리즘의 성능을 데이타 일관성(data consistency) 및 현재성(data currency) 관점에서 분석하고 시뮬레이션을 통해 알아본다.

Keywords

References

  1. S. Acharya, M. Franklin, S. Zdonik, 'Balancing Push and Pull for Data Broadcast,' in Proceedings of ACM SIGMOD, Tucson, Arizona, May 1997 https://doi.org/10.1145/253262.253293
  2. K.Y. Lam, E. Chan, and M.W. Au, 'Broadcast of Consistent Data to Read-Only Transactions from Mobile Clients,' in Proceedings of 2nd IEEE Workshop on Mobile Computing Systems and Applications, New Orleans, Louisiana, USA, 1999
  3. M.W. Au, E. Chan, and K.Y. Lam, 'Concurrency Control For Mobile System With Data Broadcast,' Journal of Interconnection Networks, 2001
  4. K.Y. Lam, E. Chan, H.W. Leong, and M.W. Au, 'Broadcasting Consistent Data to Mobile Clients with Local Cache,' in Proceedings of 2000 International Conference on Management of Data (COMAD 2000), India, December 2000
  5. E. Pitoura, 'Supporting Read-Only Transactions in Wireless Broadcasting,' in Proceedings of the DEXA '98 Workshop on Mobility in Databases and Distributed Systems, August 1998
  6. O. Ulusoy, 'Real-Time Data Management for Mobile Computing,' International Workshop on Issues and Applications of Databases Technology (IADT'98), Berlin, Germany, July 1998
  7. Ersan Kayan, O. Ulusoy, 'An Evaluation of Real-Time Transaction Management Issues in Mobile Database Systems,' The Computer Journal(Special Issue on Mobile Computing), vol.42, no.6, 1999 https://doi.org/10.1093/comjnl/42.6.501
  8. Bernstein, P.A., Hadzilacos, V. Goodman, N., Concurrency Control and Recovery in Database System, Addison-Wesley Publishing Company, 1987
  9. J. Shanmugasundaram, A. Nithrakashyap, R. Sivasankaran, and K. Ramamritham, 'Efficient Concurrency Control for Broadcast Environments,' ACM SIGMOD International Conference on Management of Data, 1999 https://doi.org/10.1145/304182.304190
  10. S. Acharya, R. Alonso, M. Franklin and S. Zdonik, 'Broadcast Disks: Data Management for Asymmetric Communication Environments,' in Proceedings of ACM SIGMOD, 1995 https://doi.org/10.1145/223784.223816
  11. T. Imielinski, et al., 'Data on Air: Organization and Access,' IEEE TKDE, 9(3): 353-372, 1997 https://doi.org/10.1109/69.599926
  12. E. Pitoura and B. Bhargava, 'Maintaining Consistency of Data in Mobile Distributed Environment,' in Proceedings of the 15th International Conference on Distributed Computing Systems, pp. 404-413, 1995
  13. K. Stathatos, N. Roussopoulosand, J.S. Baras, 'Adaptive Data Broadcasting Using Air-Cache,' Proceedings of the 1st International Workshop on Satellite-based Information Service, Rye, NY, 1996
  14. E. Pitoura and B. Bhargava, 'Data Consistency in Intermittently Connected Distributed Systems,' in IEEE Transaction on Knowledge and Data Engineering, 11(6), pp. 896-915, Nov/Dec 1999 https://doi.org/10.1109/69.824602
  15. J. Fernandez and K. Ramamritham, 'Adaptive Dissemination of Data in Time-Critical Asymmetric Communication Environments,' Proceedings of the 11th Euromicro Conference on Real-Time Systems, Sep. 1998 https://doi.org/10.1109/EMRTS.1999.777466