Customer: leading Russian developer of workflow, document flow and business process management solutions.
Our team first got to know the Customer while working on a pilot project on deploying and updating the company’s applications from a hierarchic maven repository. The next task for the team was to develop plugins for the document management system interface (a local repository to store the downloaded files in the file system, and the dialog boxes to work with the files were created). The plugins were developed for Windows, Linux and Mac OS and adapted to the most popular browsers.
Our programmers are still working closely with their international development team. The project currently continues, and the product is constantly being enhanced. Our team is developing and supporting the “thin” Web client (high-level architectural solutions as well as their implementation of modules and visual components).
Customer: large company developing database migration solutions.
Task: Migrate a database from Oracle and Informix to IBM DB2, including the structure, the data itself and, most importantly, the business logic (stored procedures, functions and triggers).
The project was implemented stage by stage:
First stage, the RELEX team carried out the complete analysis of source code
Second stage included database structure migration and automatic migration of stored procedures using DB2 Migration Toolkit (MTK).
Third stage included manual correction of automatic migration errors, and migration of the most complicated code parts that could not be converted by MTK.
The team created unit tests, tested and debugged the code. The final stage was to optimize the code of the stored procedures.
Note: Apart from this project, our team has performed another 17 other database migrations.
Technologies: DB2, Oracle, MTK, Informix