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

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.

CodeCritics applied to database schema: Challenges and first results

“…It requires to reverse engineer the DB schema and to analyse its properties. Adaptation of software engineering approaches to DB have already shown their efficiency [4], [9], [10] but these approaches never take into account views and functions and do not detect smells.…”

Automated representation, guality assessment, visualization, and adaptation to change for data intensive ecosystems

“…In another line of research, Cleve et al perform a research on query extraction using the traces of the queries that were executed in the DBMS during the execution of a program. In [59], the authors try to identify the file name and the line number at that file where a query was executed. The authors, using the traces, try to identify the specific location in the source code of a project that a query was executed.…”