Visualizing SQL Execution Traces for Program Comprehension

Student thesis: Master typesMaster in Computer science

Abstract

Software maintenance and evolution are important and sensitive activities becoming ubiquitous nowadays. They constitute complex processes due to different factors (lack of money/time/documentation or merely a bad programming work) but those processes are indispensable to keep software systems adapted to ever-changing business needs and technological platforms. Program comprehension is a typical initial phase of software maintenance and evolution. Indeed, understanding existing software systems is a preliminary step that is required before making any changes to them. Furthermore, when understanding data-intensive programs, the communication between those programs and their database constitutes an important aspect that is largely unexplored by the program comprehension research community.
This Master's thesis aims to address this issue by proposing a novel toolsupported approach that consists in analysing the database manipulation behaviour of data-intensive programs. The proposed approach combines the use of dynamic program analysis and software visualization techniques. Thanks to our approach, we bring a new way to automatically support data-intensive program comprehension, with the goal to reduce the costs of this process.
Date of Award17 Jun 2013
Original languageEnglish
Awarding Institution
  • University of Namur
SupervisorAnthony Cleve (Supervisor)

Keywords

  • dynamic analysis
  • visualization
  • SQL
  • program comprehension

Cite this

'