Towards a safe method for computing dependencies in database-intensive systems

Csaba Nagy, János Pántos, Tamás Gergely, Árpád Beszédes

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Citations (Scopus)

Abstract

Determining dependencies between different components of an application is useful in lots of applications (e. g., architecture reconstruction, reverse engineering, regression test case selection, change impact analysis). However, implementing automated methods to recover dependencies has many challenges, particularly in systems using databases, where dependencies may arise via database access. Furthermore, it is especially hard to find safe techniques (which do not omit any important dependency) that are applicable to large and complex systems at the same time. We propose two techniques that can cope with these problems in most situations. These methods compute dependencies between procedures or database tables, and they are based on the simultaneous static analysis of the source code, the database schema and the SQL instructions. In this paper, we quantitatively and qualitatively evaluate the methods on real-life data, and also evaluate them on some of their potential applications.

Original languageEnglish
Title of host publicationProceedings - 14th European Conference on Software Maintenance and Reengineering, CSMR 2010
PublisherIEEE Computer Society
Pages166-175
Number of pages10
ISBN (Print)9780769543215
DOIs
Publication statusPublished - Jan 1 2010

Publication series

NameProceedings of the European Conference on Software Maintenance and Reengineering, CSMR
ISSN (Print)1534-5351

    Fingerprint

Keywords

  • CRUD matrix
  • Databases
  • Program analysis
  • Program dependencies
  • SEA relations

ASJC Scopus subject areas

  • Software

Cite this

Nagy, C., Pántos, J., Gergely, T., & Beszédes, Á. (2010). Towards a safe method for computing dependencies in database-intensive systems. In Proceedings - 14th European Conference on Software Maintenance and Reengineering, CSMR 2010 (pp. 166-175). [5714431] (Proceedings of the European Conference on Software Maintenance and Reengineering, CSMR). IEEE Computer Society. https://doi.org/10.1109/CSMR.2010.29