DI-UMONS : Dépôt institutionnel de l’université de Mons

Recherche transversale
(titres de publication, de périodique et noms de colloque inclus)
2017-02-21 - Colloque/Article dans les actes avec comité de lecture - Anglais - 5 page(s)

Delplanque Julien, Etien Anne, Auverlot Olivier, Mens Tom , Anquetil Nicolas, Ducasse Stéphane, "CodeCritics Applied to Database Schema: Challenges and First Results" in IEEE International Conference on Software Analysis, Evolution, and Reengineering, Klagenfurt, Austria, 2017

  • Codes CREF : Informatique appliquée logiciel (DI2570), Informatique générale (DI1162), Analyse de systèmes informatiques (DI2572)
  • Unités de recherche UMONS : Génie Logiciel (S852)
  • Instituts UMONS : Institut de Recherche en Technologies de l’Information et Sciences de l’Informatique (InforTech)
Texte intégral :

Abstract(s) :

(Anglais) 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.

Identifiants :
  • FNRS : T.0022.13

Mots-clés :
  • (Anglais) design smells
  • (Anglais) database software quality
  • (Anglais) database critics
  • (Anglais) quality assessment