Application of Queueing Network Models in the Performance Evaluation of Database Designs
Electronic Notes in Theoretical Computer Science, vol.232, no.C, pp.101-124, 2009 (Scopus)
- Publication Type: Article / Article
- Volume: 232 Issue: C
- Publication Date: 2009
- Doi Number: 10.1016/j.entcs.2009.02.053
- Journal Name: Electronic Notes in Theoretical Computer Science
- Journal Indexes: Scopus
- Page Numbers: pp.101-124
- Keywords: Database design performance, queueing networks
- Ankara Yıldırım Beyazıt University Affiliated: No
Abstract
In this paper, we model database designs using queueing networks, giving visibility to the dynamic behaviour of the database design and allowing the database designer to experiment with different design decisions. Our approach is to abstract away the more detailed levels of the database system design by concentrating on the information that is available to the database designer at design time. It differs from other methods of database system performance evaluation in that the performance assessment is specifically targeted at the database design, not at the database system software architecture. We present a bottleneck evaluation of the Transaction Processing Performance Council TPC-C benchmark under different workload conditions and demonstrate how this affects database design decisions. © 2009 Elsevier B.V. All rights reserved.