CodeCritics applied to database schema: Challenges and first results

Julien Delplanque 1, 2 Anne Etien 1 Olivier Auverlot 3 Tom Mens 2 Nicolas Anquetil 1 Stéphane Ducasse 1
1 RMOD - Analyses and Languages Constructs for Object-Oriented Application Evolution
Inria Lille - Nord Europe, CRIStAL - Centre de Recherche en Informatique, Signal et Automatique de Lille (CRIStAL) - UMR 9189
2 Software Engineering Lab
3 CRIStAL - Centre de Recherche en Informatique, Signal et Automatique de Lille (CRIStAL) - UMR 9189
Abstract : —Relational databases (DB) play a critical role in many information systems. For different reasons, their schemas gather not only tables and columns but also views, triggers or stored functions (i.e., fragments of code describing treatments). As for any other code-related artefact, software quality in a DB schema helps avoiding future bugs. However, few tools exist to analyse DB quality and prevent the introduction of technical debt. Moreover, these tools suffer from limitations like the difficulty to deal with some entities (e.g., functions) or dependencies between entities. This paper presents research issues related to assessing the software quality of a DB schema by adapting existing source code analysis research to database schemas. We present preliminary results that have been validated through the implementation of DBCritics, a prototype tool to perform static analysis on the SQL source code of a database schema. DBCritics addresses the limitations of existing DB quality tools based on an internal representation considering all entities of the database and their relationships.
Keywords : database software quality database critics design smells quality assessment
Type de document :
Communication dans un congrès
IEEE 24th International Conference on Software Analysis, Evolution and Reengineering (SANER), Feb 2017, Klagenfurt, Austria. pp.432 - 436, 2017, 〈10.1109/SANER.2017.7884648〉
Liste complète des métadonnées

Littérature citée [8 références]  Voir  Masquer  Télécharger
https://hal.inria.fr/hal-01596247
Contributeur : Lse Lse <>
Soumis le : mercredi 27 septembre 2017 - 14:13:16
Dernière modification le : mardi 3 juillet 2018 - 11:34:55
Document(s) archivé(s) le : jeudi 28 décembre 2017 - 14:04:28

Fichier

Delp17a-Saner-CodeCritics-Appl...
Fichiers produits par l'(les) auteur(s)

Identifiants

Collections

INRIA2017 | INRIA | CRISTAL

Citation

Julien Delplanque, Anne Etien, Olivier Auverlot, Tom Mens, Nicolas Anquetil, et al.. CodeCritics applied to database schema: Challenges and first results. IEEE 24th International Conference on Software Analysis, Evolution and Reengineering (SANER), Feb 2017, Klagenfurt, Austria. pp.432 - 436, 2017, 〈10.1109/SANER.2017.7884648〉. 〈hal-01596247〉

Exporter

BibTeX TEI DC DCterms EndNote

Partager

Métriques

Consultations de la notice

212

Téléchargements de fichiers

50

Contact


archive-ouverte@inria.fr