Reengineering Project: Database Optimization and Migration

The purpose of this project is to help a growing company reform their static information system to a dynamic system compatible with growth. The solution consists of migrating the legacy system that they have in FileMaker to an open technology platform. To solve this specific problem “patterns” have been used and this project explains these general solution “patterns”. We understand patterns like a generic solution to persistent design problems. General solutions will not only be useful in this specific problem, but they will be useful in all kind of similar migration projects as well. This thesis gives a detailed explanation of how to apply these patterns into the AEMI specific problem and how they can be useful in the migration process. The solution of the problem then, is following the advice of “patterns” to achieve our goals; these goals are the requirements that are given from the company supervisor. After the migration process a redesign process must be done in order to organize the information. This redesign consists of organizing the migrated information as well as adding the new information in the correct place. This thesis focuses on the process of migrating from a legacy system to a MySQL system through the use of the generic solution called “patterns”. The final result is a MySQL database with all the old and new information together in a more adaptable platform for the company’s scalability