Towards the Automatic Extraction of Structural Business Rules from Legacy Databases
Working Conference on Reverse Engineering WCRE Sep
Abstract--- One of the most important problems in the evolution of legacy systems is the loss of knowledge about them. In this paper, we present an approach for extracting structural business rules from legacy databases. We used the technique to recover business rules from SIFI (SIstema Fiduciario Integrado), an existing legacy system, implemented mostly in PL/SQL and Oracle Forms. Four employees of the company that know the system and its domain evaluated the extracted rules in order to assess the precision of the extraction technique. The results show that 29% of recovered rules are correct structural business rules, 36% correspond to implementation rules, and 35% are incomplete or incorrect rules. The recovery technique proves to be prac