DOI QR코드

DOI QR Code

Optimistic Concurrency Control with Update Transaction First for Broadcast Environment : OCC/UTF

방송환경에서 갱신 거래 우선 낙관적 동시성 제어 기법

  • Published : 2002.04.01

Abstract

Most of mobile computing systems allow mostly read-only transactions from mobile clients for retrieving various types of Information such as stock data, traffic information and news updates. Since previous concurrence control protocols, however, do not consider such a particular characteristics, the performance degradation occurs when previous schemes are applied to the broadcast environment. In this paper, we propose OCC/UTF(Optimistic Concurrence Control with Update Transaction First) that is most appropriate for broadcast environment. OCC/UTF lets a query transaction, that has already read the data item which was invalidated by update transaction, read again the same data item without the abort of the query transaction due to non-serializability. Therefore, serializable order is maintained and the query transaction is committed safely regardless of commitment of update transactions. In OCC/UTF, Clients need not require server to commit their query transactions. Because of broadcasting the validation reports including values updated recently to clients, it reduces the overhead of requesting recent values from the server and the server need not also re-broadcast the newest values. As a result, OCC/UTF makes full use of the asymmetric bandwidth. It can also improve transaction throughput by increasing the commit ratio of query transactions as much as possible.

대부분의 방송 환경 응용 시스템들은 클라이언트측에서 발생한 주로 주식 데이터, 교통 정보와 새로운 뉴스와 같은 여러 가지 다양한 정보를 검색하는 읽기전용 즉 질의 거래들을 허락한다. 그러나, 기존의 여러 가지 동시성 제어 기법들은 이러한 특수성을 고려하지 않음으로써 방송 환경에 적용될 때 성능 감소가 일어난다. 이 논문에서는 방송환경에서 가장 적절한 OCC/UTF(Optimistic Concurrency Control with Update Transaction First)를 제안한다. OCC/UTF는 갱신 거래에 의해 무효화된 데이터를 먼저 일기 연산한 질의 거래가 비직렬 가능성으로 인한 철회 없이 갱신된 새로운 값을 다시 읽는다. 그럼으로써 직렬 순서가 유지되어 갱신 거래의 완료와 상관없이 해당 질의 거래가 무사히 완료된다. 그 결과 첫째, 서버에게 질의 거래 완료 요구를 할 필요가 없으며 무효화 보고서 내에 갱신된 최신의 값을 포함하여 클라이언트들에게 방송함으로써 최근 데이터 값을 서버에게 요구하는 기회를 줄임과 동시에 서버는 새로운 값을 재방송할 필요가 없기 때문에 비대칭적 대역폭을 효율적으로 활용한다. 둘째, 질의 거래의 완료율을 최대한 높여 처리율을 향상시킬 수 있다.

Keywords

References

  1. S. Acharya, 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. M. Franklin and S. Zdonik, 'Data In Your Face : Push Technology in Prospective,' in Proceedings of 1998 ACM SIGMOD Conference, Seattle, 1998 https://doi.org/10.1145/276304.276360
  3. Pitoura, E. and Bhargava, B. 'Dealing with Mobility : Issues and Research Challenges,' Technical Report, Purdue Univ., Nov., 1993
  4. 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
  5. Pitoura, E. and Bhargava, B. 'Maintaing Consistency of Data in Mobile Distributed Environment,' in Proceeding of the 15th International Conference on Distributed Computing Systems, pp.404-413, 1995 https://doi.org/10.1109/ICDCS.1995.500045
  6. Xuan, P., O. Gonzalez, J. Fernandez & Ramamritham, K., 'Broadcast on Demand : Efficient and Timely Dissemination of Data in Mobile Environments,' in Proceedings of 3th IEEE Real-Time Technology Application Symposium, 1997 https://doi.org/10.1109/RTTAS.1997.601342
  7. J. Shanmugasundaram, A. Nithrakashyap, R. Sivasankaran, and K. Ramamritham, 'Efficient Concurrency control for Broadcast Environments,' ACM SIGMOD, 1999 https://doi.org/10.1145/304181.304190
  8. 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
  9. P. A. Bernstein, V. Hadzilacos and N. Goodman, 'Concurrency Control and Recovery in Database Systems,' Addison Wesley, Reading
  10. 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
  11. 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
  12. S. Lee, C. Hwang, W. Lee and H. Yu, 'Caching and Concurrency Control in a Mobile Client/Server computing Environment,' 한국정보과학회논문지, Vol.26, No.8, August, 1999
  13. 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
  14. P. M. Bover and M. J. Carey, 'Multiversion Query Locking,' Proceedings of the VLDB Conference,' Proceedings of the VLDB Conference, Vancouver, Canada, 1992
  15. P. Xuan, et. al, 'Broadcast on Demand-Efficient and Timely Dissemination of Data in Mobile Environments,' IEEE Real-Time Technology and Applications Symposium, pp.38-48, June, 1997 https://doi.org/10.1109/RTTAS.1997.601342