Dynamic Analysis of SQL Statements for Data-Intensive Applications Reverse Engineering

Authors:
Anthony Cleve;Jean-Luc Hainaut
Affiliations:
-;-
Venue:
WCRE '08 Proceedings of the 2008 15th Working Conference on Reverse Engineering
Year:
2008

Citing 0
Cited 4

A conceptual approach to database applications evolution

ER'10 Proceedings of the 29th international conference on Conceptual modeling
Fault localization for data-centric programs

Proceedings of the 19th ACM SIGSOFT symposium and the 13th European conference on Foundations of software engineering
Database semantics recovery through analysis of dynamic SQL statements

Journal on data semantics XV
Extending ER models to capture database transformations to build data sets for data mining

Data & Knowledge Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

Analyzing SQL statements brings invaluable information that can be used in various applications such as program understanding and database reverse engineering. While static SQL statements are fairly easy to analyze, dynamic SQL statements most often require dynamic analysis techniques that may prove more difficult to implement. This paper addresses the problem of dynamic SQL query analysis in the context of software and database reverse engineering. It explores the use of dynamic analysis techniques such as aspect-based tracing and SQL trace analysis for extracting implicit information about both the program behavior and the database structure.