Petros Manousis, Apostolos Zarras, Panos Vassiliadis, George Papastefanatos.

Extraction of Embedded Queries via Static Analysis of Host Code

Abstract

Correctly identifying the embedded queries within the source code of an information system is a significant aid to developers and administrators, as it can facilitate the visualization of a map of the information system, the identification of areas affected by schema evolution, code migration, and the planning of the joint maintenance of code and data. In this paper, we provide a solution to the problem of identifying the location and semantics of embedded queries with a generic, language-independent method that identifies the embedded queries of a data-intensive ecosystem, regardless of the programming style and the host language, and represents them in a universal, also language-independent manner that facilitates the aforementioned maintenance, evolution and migration tasks with minimal user effort and significant effectiveness.

Input

The "projects" we examined: Clementine, Drupal

In both projects we changed the changed parts of the code that were branch statements written with the help of "?", ":" symbols to code written with "if", "then", "else" keywords, according to the host language (C++ for Clementine, PHP for Drupal).

Output

Files containing the query results:

• Clementine SQL.
• Drupal SQL.