Reverse Engineering PL/SQL Legacy Code - An Experience Report.

Martin Habringer, Michael Moser, Josef Pichler

Research output: Contribution to conferencePaperpeer-review

9 Citations (Scopus)


The reengineering of legacy code is a tedious endeavor. Automatic transformation of legacy code from an old technology to a new one preserves potential problems in legacy code with respect to obsolete, changed, and new business cases. On the other hand, manual analysis of legacy code without assistance of original developers is time consuming and error-prone. For the purpose of reengineering PL/SQL legacy code in the steel making domain, we developed tool support for the reverse engineering of PL/SQL code into a more abstract and comprehensive representation. This representation then serves as input for stakeholders to manually analyze legacy code, to identify obsolete and missing business cases, and, finally, to support the re-implementation of a new system. In this paper we briefly introduce the tool and present results of reverse engineering PL/SQL legacy code in the steel making domain. We show how stakeholders are supported in analyzing legacy code by means of general-purpose analysis techniques combined with domain-specific representations and conclude with some of the lessons learned.

Original languageEnglish
Number of pages4
Publication statusPublished - 4 Dec 2014


  • program comprehension
  • reverse engineering
  • source code analysis


Dive into the research topics of 'Reverse Engineering PL/SQL Legacy Code - An Experience Report.'. Together they form a unique fingerprint.

Cite this