The Design And Implementation Of Database Refactoring On PE System

With new technology and new ideas improving quickly in software industry, the refactoring of software is becoming more and more common. Database refactoring can be seen very often in this field. Most of the business software is coupled with their database, which is the reason why the database schema is too difficult to modify. In addition, data migration may cause database refactoring, too.In this paper, the design and implementation of database refactoring is introduced. Firstly, this paper introduces the theory of refactoring and database refactoring. Then, take the refactoring of the PE system, complex software used in finance area, for example, we make current system known by introducing the background, system architecture, current database, reasons for refactoring, risk analysis and so on. Secondly, based on the code review and database analysis, we chose the proper strategy, designed, implemented, validated it, and made a success. In addition, this paper emphasizes on the challenge and solution. By doing this, we improve the database design, consolidate several database instances, improve the database performance, and prove the way for the work in next phase and the development of client business in the future.This paper addresses a whole logical technology for the large historied system and gives a detailed example. The success in this project proves that database refactoring for a complex, large-size system without document is feasible. The author joined in this project in the very beginning, and took part in the design, implementation, validation work, and also make effort in the test, resolving deadlock and improving performance.