Where was this SQL query executed? a static concept location approach

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution

Abstract

Concept location in software engineering is the process of identifying where a specific concept is implemented in the source code of a software system. It is a very common task performed by developers during development or maintenance, and many techniques have been studied by researchers to make it more efficient. However, most of the current techniques ignore the role of a database in the architecture of a system, which is also an important source of concepts or dependencies among them. In this paper, we present a concept location technique for data-intensive systems, as systems with at least one database server in their architecture which is intensively used by its clients. Specifically, we present a static technique for identifying the exact source code location from where a given SQL query was sent to the database. We evaluate our technique by collecting and locating SQL queries from testing scenarios of two open source Java systems under active development. With our technique, we are able to successfully identify the source of most of these queries.

Original languageEnglish
Title of host publicationProceedings of the 22nd IEEE International Conference on Software Analysis, Evolution, and Reengineering (SANER 2015)
PublisherIEEE Computer Society Press
Pages580-584
Number of pages5
ISBN (Print)9781479984695
DOIs
Publication statusPublished - 8 Apr 2015
Event22nd IEEE International Conference on Software Analysis, Evolution, and Reengineering, SANER 2015 - Montreal, Canada
Duration: 2 Mar 20156 Mar 2015

Conference

Conference22nd IEEE International Conference on Software Analysis, Evolution, and Reengineering, SANER 2015
CountryCanada
CityMontreal
Period2/03/156/03/15

Keywords

  • concept location
  • data-intensive systems
  • fault location
  • Hibernate
  • JDBC
  • SQL
  • static analysis

Fingerprint Dive into the research topics of 'Where was this SQL query executed? a static concept location approach'. Together they form a unique fingerprint.

  • Projects

    Student Theses

    Analyzing, Understanding and Supporting the Evolution of Dynamic and Heterogeneous Data-Intensive Software Systems

    Author: Meurice, L., 22 Jun 2017

    Supervisor: Cleve, A. (Supervisor), Englebert, V. (President), Lanza, M. (External person) (Jury), Mens, T. (External person) (Jury), Frenay, B. (Jury) & Vanhoof, W. (Jury)

    Student thesis: Doc typesDoctor of Sciences

    File

    Cite this

    Nagy, C., Meurice, L., & Cleve, A. (2015). Where was this SQL query executed? a static concept location approach. In Proceedings of the 22nd IEEE International Conference on Software Analysis, Evolution, and Reengineering (SANER 2015) (pp. 580-584). [7081881] IEEE Computer Society Press. https://doi.org/10.1109/SANER.2015.7081881