Challenges and Perils of Testing Database Manipulation Code

Maxime Gobert, Csaba Nagy, Henrique Rocha, Serge Demeyer, Anthony Cleve

Résultats de recherche: Contribution dans un livre/un catalogue/un rapport/dans les actes d'une conférenceArticle dans les actes d'une conférence/un colloque

Résumé

Software testing enable development teams to maintain thequality of a software system while it evolves. The database manipu-lation code requires special attention in this context. However, it isoften neglected and suffers from software maintenance problems. In thispaper, we investigate the current state-of-the-practice in testing databasemanipulation code. We first analyse the code of 72 projects mined fromLibraries.io to get an impression of the test coverage for database code.We confirm that the database is poorly tested: 46% of the projects didnot cover with tests half of their database access methods, and 33%of the projects did not cover the database code at all. To understandthe difficulties in testing database code, we analysed 532 questions onStackExchange sites and deduced a taxonomy. We found that developersmostly look for insights on general best practices to test database accesscode. They also have more technical questions related to DB handling,mocking, parallelisation or framework/tool usage. This investigation laysthe basis for future research on improving database code testing
langue originaleAnglais
titreProceedings of the 33rd International Conference on Advanced Information Systems Engineering (CAiSE 2021)
EditeurSpringer
Nombre de pages17
Etat de la publicationPublié - 2021
Evénement33rd International Conference on Advanced Information Systems Engineering - Melbourne, Australie
Durée: 28 juin 20212 juil. 2021
Numéro de conférence: 33

Une conférence

Une conférence33rd International Conference on Advanced Information Systems Engineering
Titre abrégéCAISE '21
Pays/TerritoireAustralie
La villeMelbourne
période28/06/212/07/21

Empreinte digitale

Examiner les sujets de recherche de « Challenges and Perils of Testing Database Manipulation Code ». Ensemble, ils forment une empreinte digitale unique.

Contient cette citation