Stress Testing of Transactional Database Systems

Abstract : Transactional database management systems (DBMS) have been successful at supporting traditional transaction processing workloads. However, web-based applications that tend to generate huge numbers of concurrent business operations are pushing DBMS performance over their limits, thus threatening overall system availability. Then, a crucial question is how to test DBMS performance under heavy workload conditions. Answering this question requires a testing methodology to set up non-biased conditions for pushing a particular DBMS over its normal performance limits (i.e., to stress it). In this article, we present a stress testing methodology for DBMS to search for defects in supporting very heavy workloads. Our methodology leverages distributed testing techniques and takes into account the various biases that may affect the test results. It progressively increases the workload along with several tuning steps up to a stress condition. We validate our methodology with empirical studies on two popular DBMS (one proprietary, one open-source) and detail the defects that have been found.
Type de document :
Article dans une revue
Journal of Information and Data Management, Brazilian Computer Society, 2013, 4 (3), 〈http://hdl.handle.net/10993/9919〉
Liste complète des métadonnées

Littérature citée [1 références]  Voir  Masquer  Télécharger

https://hal.inria.fr/hal-01018103
Contributeur : Eduardo Cunha de Almeida <>
Soumis le : jeudi 3 juillet 2014 - 16:08:26
Dernière modification le : jeudi 24 mai 2018 - 15:59:21
Document(s) archivé(s) le : vendredi 3 octobre 2014 - 11:45:59

Fichier

SBBD-StressTesting.pdf
Fichiers produits par l'(les) auteur(s)

Identifiants

  • HAL Id : hal-01018103, version 1

Citation

Jorge Augusto Meira, Eduardo Cunha de Almeida, Gerson Sunyé, Yves Le Traon, Patrick Valduriez. Stress Testing of Transactional Database Systems. Journal of Information and Data Management, Brazilian Computer Society, 2013, 4 (3), 〈http://hdl.handle.net/10993/9919〉. 〈hal-01018103〉

Partager

Métriques

Consultations de la notice

753

Téléchargements de fichiers

274