Querying external source code files of programs connecting to a relational database

  • Authors:
  • Carlos Garcia-Alvarado;Carlos Ordonez;Veerabhadran Baladandayuthapani

  • Affiliations:
  • University of Houston / EMC Greenplum, Houston, TX, USA;University of Houston, Houston, TX, USA;The University of Texas M.D. Anderson Cancer Center, Houston, TX, USA

  • Venue:
  • Proceedings of the 5th Ph.D. workshop on Information and knowledge
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

Multiple source code files reference metadata of an existing database. Consequently, any modification that needs to be done in the source code files or in the schema of a database requires asserting the impact of performing such change. This problem of data and control dependencies between a database system and source code has been tackled before by software engineering. Unfortunately, these solutions are cumbersome to implement by requiring a long execution time for obtaining the dependency analysis, and do not allow a flexible analysis of the resulting data. In this research, we present and formalize a novel approach for using keyword search algorithms to analyze the resulting references found between the source code and the database's schema. Our initial findings show that our algorithms are efficient to perform a rapid integration phase, allow complex analysis of the references inside the DBMS (e.g. computation of OLAP data cubes), and provide efficient ranking capabilities.