The KIPS Transactions:PartD (정보처리학회논문지D)

Korea Information Processing Society (한국정보처리학회)
권호 표지
DOI QR코드

DOI QR Code

Concurrency Control Using the Update Graph in Replicated Database Systems

중복 데이터베이스 시스템에서 갱신그래프를 이용한 동시성제어

  • Published : 2002.08.01
Download PDF
⟨ Previous Next ⟩

Abstract

Replicated database system was emerged to resolve the problem of reduction of the availability and the reliability due to the communication failures and site errors generated at centralized database system. But if update transactions are many occurred, the update is equally executed for all replicated data. Therefore, there are many problems the same thing a message overhead generated by synchronization and the reduce of concurrency happened because of delaying the transaction. In this paper, I propose a new concurrency control algorithm for enhancing the degree of parallelism of the transaction in fully replicated database designed to improve the availability and the reliability. To improve the system performance in the replicated database should be performed the last operations in the submitted site of transactions and be independently executed update-only transactions composed of write-only transactions in all sites. I propose concurrency control method to maintain the consistency of the replicated database and reflect the result of update-only transactions in all sites. The superiority of the proposed method has been tested from the respondence and withdrawal rate. The results confirm the superiority of the proposed technique over classical correlation based method.

중앙집중형 데이터베이스는 데이터 관리가 용이하나 통신장애나 사이트 고장시 전체시스템 중지로 인해 신뢰성과 가용성문제가 발생한다. 이러한 문제를 해결하기 위해서 중복데이터베이스가 출현되었다. 그러나 갱신거래가 많이 발생되는 경우에는 중복 데이터에 대해서 갱신이 동일하게 이루어져야 하므로 동기화로 인한 메시지부담과 거래가 지연됨에 따라 동시성이 감소되는 문제가 발생하게 된다 이 논문은 가용성과 신뢰성을 향상시키기 위한 완전 중복 데이터베이스에서 거래들의 병행성의 정도를 높이기 위한 동시성제어 알고리즘을 제안한다. 중복 데이터 베이스에서 시스템 성능을 향상시키기 위해서는 거래가 제출된 사이트에서 마지막 연산까지 수행시키고, 기록 연산들로 구성된 갱신 전용거래를 모든 사이트에서 독립적으로 수행하도록 한다. 각 사이트에서 수행되는 갱신전용거래의 일관성은 모든 사이트에서 갱신그래프를 유지하여 보장한다. 제안하는 동시성 제어 기법은 각 사이트에서 거래들이 동시에 수행할 수 있게 함으로써 거래들의 병행수행정도를 향상시킬 수 있다. 제안하는 동시성 제어 기법의 실제 구현 및 실험을 통한 결과를 분석하여 기존의 방법보다 보다 더 빠른 응답률과 더 적은 철회율을 가져옴을 성능 평가를 통해 우수성을 보여준다.

Keywords

References

  1. D. Agrawal, G. Alonso, A. E. Abbadi, 'Exploiting Atomic Broadcast in Replicated Databases,' In Proceedings of EuroPar(EuroPar'97), Passau(Germany), 1997
  2. P. A. Bernstein, V. Hadzilacos, N. Goodman, Concurrency Control and Recovery in Database Systems, Addison Wesley, 1987
  3. B. Kemme, G. Alonso, 'A Suite of Database Replication Protocols Based on Group Communication Primitive,' In Proceedings of the 18th International Conference on Distributed Computing Systems (ICDCS), Amsterdam, The Netherlands, May, 1998
  4. B. Kemme, F. Pedone, 'Processing Transactions over Optimistic Atomic Broadcast Protocols,' In Proceedings of the International Conference on Distributed Computing Systems, Austin Texas, June, 1999 https://doi.org/10.1109/ICDCS.1999.776544
  5. A. Kumar, A. Segev, 'Cost and Availability tradeoff in Replicated Concurrency Control,' ACM Transactions on Database Systems, pp.102-131, March, 1993 https://doi.org/10.1145/151284.151287
  6. M. Wiesmann, F. Pedone, A. Schiper, B. Kemme, and G. Alonso, 'Understanding Replication in Databases and Distributed Systems,' In Proceedings of 20th International Conference on Distributed Computing Systems, pp.264-274, 2000 https://doi.org/10.1109/ICDCS.2000.840959
  7. J. Gray, P. Helland, D. Shasha, 'The Dangers of Replication and a Solution,' In Proc. of the ACM SIGMOD, pp.568-574, 1996 https://doi.org/10.1145/233269.233330
  8. Y. Breitbart, R. Komondoor, R. Rastogi, S. Seshadri, A. Silberschatz, 'Update Propagation Protocols for Replication Databases,' In Proc. of the ACM SIGMOD, pp.97-108, 1999 https://doi.org/10.1145/304182.304191
  9. B. Kemme, F. Pedone, G. Alonso, A. Schiper, 'Using Optimistic Atomic Broadcast in Transaction Processing Systems,' Technical Report No.325, Department of Computer Science, ETH Zurich, Mar., 1999
  10. B. Kemme, and G. Alonso. 'A Suite of Database Replication Protocols Based on Group Communication Primitives,' In proceedings of the 18th International Conference on Distributed Computing System (ICDCS), Amstergam, The Netherlands, May, 1998 https://doi.org/10.1109/ICDCS.1998.679498
  11. M. Stonebraker, 'Concurrency Control and Consistency of Multiple Copies of Data in Distributed INGRES,' IEEE Transactions on Software Engineering, pp.188-194, May, 1979 https://doi.org/10.1109/TSE.1979.234180
  12. Todd Anderson, Y. Breitbart, Henry F. Korth, Avishai Wool, 'Replication, Consistency, and Practicality : Are These Mutually Exclusive?,' In Procs. of ACM SIGMOD International Conf. on Management of Data, Seattle, WA, Vol.27, No.2, pp.484-495, 1998 https://doi.org/10.1145/276304.276347
  13. Y. Breitbart and Henry F. Korth. 'Replication and Consistency : Being Lazy Helps Sometimes,' In Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Tucson, Arizona, 1997 https://doi.org/10.1145/263661.263681
  14. J. Holliday, D. Agrawal, A. e. Abbadi, 'The Performance of Database Replication using Atomic Broadcast Group Communication,' Techinical Report TRCS 99-11, The University of California at Santa Barbara, 1999
  15. M. Wiesman, F. Pedone, A. Schiper. 'A Systematic Classification of Replicated Database Protocols Based on Atomic Broadcast,' In Proceedings of the 3rd Europeean Research Seminar of Advances in Distributed Systems, Madeira, April, 1999
  16. M. Wiesmann, F. Pedone, A. Schiper, B. Kemme, and G. Alonso, 'Database Replication Techniques : A Three Parameter Classification,' In Proceedings of 19th IEEE Symposium on Reliable Distributed Systems, Numberg, Germany, October, 2000 https://doi.org/10.1109/RELDI.2000.885408
  17. B. Kemme, G. Alonso, 'A New Approach to Developing and Implementing Eager Database Replication Protocols,' ACM Transaction On Database Systems, September, 2000 https://doi.org/10.1145/363951.363955
  18. Oracle Corporation, 500, Oracle Parkway, Redwoord City, CA 94065, Oracle8i Advances Replication, November, 1998
  19. 최희영, 황부연, '중복데이터베이스 시스템에서 낙관적인 원자적 방송을 이용한 동시성제어', 정보처리학회논문지D, Vol.8-D, No.5, pp.543-552, October, 2001