Application of Queueing Network Models in the Performance Evaluation of Database Designs

Authors:
Rasha Osman;Irfan Awan;Michael E. Woodward
Affiliations:
Department of Computing, University of Bradford, Bradford, West Yorkshire, UK;Department of Computing, University of Bradford, Bradford, West Yorkshire, UK;Department of Computing, University of Bradford, Bradford, West Yorkshire, UK
Venue:
Electronic Notes in Theoretical Computer Science (ENTCS)
Year:
2009

Citing 19
Cited 1

A modeling study of the TPC-C benchmark

SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
Workload models for DBMS performance evaluation

CSC '85 Proceedings of the 1985 ACM thirteenth annual conference on Computer Science
I/O reference behavior of production database workloads and the TPC benchmarks—an analysis at the logical level

ACM Transactions on Database Systems (TODS)
Performance Engineering of Software Systems

Performance Engineering of Software Systems
Database Management Systems

Database Management Systems
Database tuning: principles, experiments, and troubleshooting techniques

Database tuning: principles, experiments, and troubleshooting techniques
Performance Modeling of Distributed and Replicated Databases

IEEE Transactions on Knowledge and Data Engineering
A Method for Design and Performance Modeling of Client/Server Systems

IEEE Transactions on Software Engineering
Software Engineering (7th Edition)

Software Engineering (7th Edition)
Model-Based Performance Prediction in Software Development: A Survey

IEEE Transactions on Software Engineering
Software Engineering: A Practitioner's Approach

Software Engineering: A Practitioner's Approach
Characteristics of production database workloads and the TPC benchmarks

IBM Systems Journal - End-to-end security
Database Systems: An Application Oriented Approach, Complete Version (2nd Edition)

Database Systems: An Application Oriented Approach, Complete Version (2nd Edition)
Characterization of the data access behavior for TPC-C traces

ISPASS '04 Proceedings of the 2004 IEEE International Symposium on Performance Analysis of Systems and Software
Fundamentals of Database Systems (5th Edition)

Fundamentals of Database Systems (5th Edition)
Data base system performance prediction using an analytical model (invited paper)

VLDB '81 Proceedings of the seventh international conference on Very Large Data Bases - Volume 7
Self-tuning database technology and information services: from wishful thinking to viable engineering

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
DB2 design advisor: integrated automatic physical database design

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Automatic SQL tuning in oracle 10g

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Towards predicting query execution time for concurrent and dynamic database workloads

Proceedings of the VLDB Endowment

Quantified Score

Hi-index	0.00

Visualization

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.