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

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

DOI QR Code

Transaction Management Using Update Protocol in Fully Replicated Databases

완전중복 데이터베이스에서 갱신 규약을 적용한 거래 관리

  • Published : 2002.02.01
Download PDF
⟨ Previous Next ⟩

Abstract

We propose a new concurrency control algorithm for enhancing the degree of parallelism of the transactions in fully replicated databases designed to improve the availability and the reliability. The update transactions can be logically decomposed of a read-only transaction and a write-only transaction. In our algorithm, a set of read operations of an update transaction is treated as a read-only transaction and the read-only transaction reads data items in the site to which it is submitted. And a set of write operations of the update transaction is treated as a write-only transaction and it is submitted to all corresponding sites after the update transaction has been completed. By using the proposed update protocol, all write-only transactions can execute at all sites atomically. The proposed algorithm can have transactions execute concurrently at the site to which they are submitted and, after the completion of each transaction, the update protocol is performed for updating their data items and checking their serializability. Therefore, the degree of parallelism of the transactions can be improved. Especially, if the probability of conflict among transactions is low, we can expect the higher degree of their parallelism.

본 논문은 가용성(Availability)과 신뢰성(Reliability)을 향상시키기 위한 완전중복 데이터베이스에서 거래들의 병행성(Parallelism)의 정도를 높이기 위한 동시성제어 알고리즘을 제안하고 있다. 갱신거래는 논리적으로 판독전용 거래와 갱신전용 거래로 이루어 졌다고 할 수 있다. 제안된 알고리즘에서는 판독연산들을 판독전용 거래로 취급하여 거래가 제출된 사이트에 있는 자료항목을 읽게 하고 갱신할 자료항목들을 모아 갱신전용 거래를 만들어 갱신규약을 통하여 모든 사이트에서 원자적으로 갱신이 이루어지도록 하고 있다. 제안된 알고리즘은 각 사이트에서 거래들이 동시에 수행될 수 있게 함으로서 거래들의 병행수행정도를 향상시킬 수 있다. 특히, 거래들 사이의 충돌빈도가 낮다면 보다 높은 병행수행 정도를 얻을 수 있다.

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. F. Pedone, A. Schiper, 'Optimistic Atomic Broadcast,' In Proceedings of the 16th International Symposium on Distributed Computing, September, 1998
  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
  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
  9. P. A. Bernstein, N Goodman, 'An Algorithm for Concurrency Control and Recovery in Replicated Distributed Database,' ACM Trans. on Database Systems, Vol.9, pp.596-615, 1984 https://doi.org/10.1145/1994.2207
  10. M. Oszu and P. Valduriez, Principles of Distributed database management, Prentice-Hall, 1991
  11. J. Gray, P. Homan, H. Korth, and R. Obermark. 'A Strawman Analysis of the Probability of Wait and Deadlock,' Technical Report RJ2131, IBM San Jose Research Laboratory, 1981
  12. 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
  13. 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
  14. P. Alsberg, and J. Day, 'A Principle for Resilient Sharing of Distributed Resource,' In Proceeding of the International Conference on Software Engineering, Oct. 1976
  15. M. Stonebraker, 'Concurrency Control and Consistency of Multiple Copies of Data in Distributed INGRES,' IEEE Transactions on Software Engineering, SE-5 : 188-194, May. 1979 https://doi.org/10.1109/TSE.1979.234180
  16. A. Schiper and M. Raynal, 'From Group Communication to Transaction in Distributed System,' Communications of the ACM, 39(4) : 84-87, Apr. 1996 https://doi.org/10.1145/227210.227230
  17. 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, pp484-495, 1998 https://doi.org/10.1145/276304.276347
  18. 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
  19. P. Chundi, D. J. Rosenkratz, and S. S. Ravi, 'Deferred Updates and Data Placement in Distributed Databases,' In Proceedings of the Twelveth International Conference on Data Engineering, New Orleans, Louisianal, 1996 https://doi.org/10.1109/ICDE.1996.492196