Performance modeling of nested transactions in database systems

  • Authors:
  • Hossam S. Hassanein;Mohamed E. El-Sharkawi

  • Affiliations:
  • Department of Computing and Information Science, Queen's University, Kingston, Ontario,K7L 3N6 Canada;Department of Information Systems, Faculty of Computers & Information, Cairo University, Orman, Giza, Egypt

  • Venue:
  • CASCON '00 Proceedings of the 2000 conference of the Centre for Advanced Studies on Collaborative research
  • Year:
  • 2000

Quantified Score

Hi-index 0.00

Visualization

Abstract

The nested transaction model was introduced to satisfy the requirements of advanced database applications. Moreover, it is currently the basic transaction model for new databases like workflow systems, mobile databases, and objectrelational databases. Though there are several performance evaluation studies of different concurrency control mechanisms in nested transactions, effects of transaction parameters on the overall system performance have not received any attention. In this paper, we study the effects of transactions characteristics on system performance. We developed a detailed simulation model and conducted several experiments to measure the impact of transactions characteristics on the performance. First, the effect of the number of leaves on the performance of nested transactions is investigated under different shaping parameters. Also, effects of the depth of the transaction tree on the system performance are investigated.