Service: re-engineering, implementation of new functionality, data transferring
Solution type: desktop application
Business area: ECM & document management solutions
Period: 05.2006-07.2007
Key problems
Document Archive Application is a flexible system used for storage, searching and retrieval of almost hundred fixed document types and an unlimited number of own ones. The main goal of the project was to convert database storage from Trip into MS SQL Server. Implementation was based on the previous version of the application.
The project had three tasks:
- Re-engineering database platform from Trip to MS SQL Server 2000/2005;
- Implementation of a new security system;
- Implementation of a migration utility to transfer data from the previous version (Trip) into the new version (MS SQL Server).
Solution
In the scope of the re-engineering task Arcadia rewrote data access layer of the Document Archive Application. A very important feature of the project phase was keeping functionality of the system untouched.
Implementation of a new access rights mechanism assumed creation of a new security subsystem and integration them into existing functionality.
Migration utility is a standalone application which was run only once for each customer. During migration data should be inserted according to new security rules. Arcadia's solution took data access component from previous and new versions creating the set of database calls to the both systems. For testing of the migration utility additional testing utility was implemented. The main goal of the utility is automatic generation of requests to both systems and comparison of the results.
Development tools
- MS Source Safe 6.0 / VSS Connect 1.5
- Test Track Pro v. 6.1
- IntelliJ IDEA 5.1, Ant
Technologies used
- Microsoft Windows XP/2003.
- Microsoft SQL Server 2000/2005 (Microsoft SQL Server 2000 JDBC Driver)
- Apache Tomcat 5.5
- Java 1.5.0
- JavaScript, XML, XSL
Duration and scope
13 months / ~39 person-months