Effects of shaping characteristics on the performance of nested transactions

The nested transaction model was introduced to satisfy the requirements of advanced database applications. Moreover, it is currently the basic transaction model for new database applications like workflow systems and new database systems like mobile databases and object-relational databases. Though...

Full description

Saved in:
Bibliographic Details
Published in:Information and software technology 2001-08, Vol.43 (10), p.579-590
Main Authors: El-Sayed, Assmaa A., Hassanein, Hossam S., El-Sharkawi, Mohamed E.
Format: Article
Language:English
Subjects:
Concurrency control
Database management systems
Evaluation
Nested transactions
Performance evaluation
Performance measures
Simulation
Studies
Transactions
Two-phase locking
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The nested transaction model was introduced to satisfy the requirements of advanced database applications. Moreover, it is currently the basic transaction model for new database applications like workflow systems and new database systems like mobile databases and object-relational databases. Though there are several performance evaluation studies of different concurrency control mechanisms in nested transactions, the 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.
ISSN:0950-5849
1873-6025
DOI:10.1016/S0950-5849(01)00164-1