Integrating and Querying Source Code of Programs Working on a Database
Programs and a database's schema contain complex data and control dependencies that make modifying the schema along with multiple portions of the source code difficult to change. In this paper, the authors address the problem of exploring and analyzing those dependencies that exist between a program and a database's schema using keyword search techniques inside a DataBase Management System (DBMS). As a result, they present QDPC, a novel system that allows the integration and flexible querying within a DBMS of source code and a database's schema. The integration focuses on obtaining the approximate matches that exist between source files (classes, function and variable names) and the database's schema (table names and column names), and then storing them in summarization tables inside a DBMS.