Modelling database lock-contention in architecture-level performance simulation

Authors:
Philipp Merkle;Christian Stier
Affiliations:
Karlsruhe Institute of Technology (KIT), 76131 Karlsruhe, Germany;Karlsruhe Institute of Technology (KIT), 76131 Karlsruhe, Germany
Venue:
Proceedings of the 5th ACM/SPEC international conference on Performance engineering
Year:
2014

Citing 7
Cited 0

A mean value performance model for locking in databases: the no-waiting case

Journal of the ACM (JACM)
Database System Implementation

Database System Implementation
The Palladio component model for model-driven performance prediction

Journal of Systems and Software
Database system performance evaluation models: A survey

Performance Evaluation
Predicting transaction quality for balanced data consistency and performance

Proceedings of the 18th international doctoral symposium on Components and architecture
Performance and resource modeling in highly-concurrent OLTP workloads

Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data
Performance modelling of database contention using queueing petri nets

Proceedings of the 4th ACM/SPEC International Conference on Performance Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

Databases are the origin of many performance problems found in transactional information systems. Performance suffers especially when databases employ locking to isolate concurrent transactions. Software performance models therefore need to reflect lock contention in order to be a credible source for guiding design decisions. We propose a hybrid simulation approach that integrates a novel locking model into the Palladio software architecture performance simulator. Our model operates on a row level and is tailored to be used with architecture-level performance models. An experimental evaluation leads to promising results close to the measured performance.