Fxfi System Re-engineering Research And Practice

Acting as backbone system of the most enterprise applications, database has key responsibility to store, operate and secure business sensitive even mission critical data. Technology of Stored Procedures in Database was developed around 1990's and was applied to many of the financial application systems at that time. Since the developing of the technology and business process, there are more and more requirements on refactonng those application systems.Software Re-engineering is a method to refactor the legacy systems. It includes Reverse Engineering, Forward Engineering and Transformation. The application system Foreign Exchange Flow Indicator (FXFI) from State Street Associates is a typically legacy system. All its functionalities are implemented by the Stored Procedures in Oracle database. In order to make enhancements on the statistics model of FXFI, make it applied to the new business rules, and have more technical improvements on the maintainability, scability and platform independency, project of re-engineering on FXFI was issued in SSZUTC.This paper applied the general model of software re-engineering to FXFI refactonng project. It describes the detail steps of the re-engineering process on FXFI in three separated phases: Reverse Abstracting, Re-design and Optimizing, and Forward Implementation. Based on the practice on refactonng FXFI, this paper introduced and explored a common approach, which can be used in the re-engineering on Stored-Procedure-based database application systems. And some of the technical issues during this approach, as well as some thoughts for the future research were also discuss in this paper.