Oracle/DB2 integration with MTS and stress testing
|
Our client
Our client is a Canadian company, which had an integration application with two legacy databases, Oracle and DB2.
Project Outline
Alierra Software’s main goal was to coordinate two-phase commit (2PC) with multiple Oracle 8i, Oracle 9i and DB2 database servers. With multisite updates, two phases commit protocol, and coordinated distributed transactions, an application is able to update data on multiple remote database servers with guaranteed integrity.
The Solution
On the first stage of the project, Alierra Software’s specialists carefully examined all the system requirements to find out a way to perform the integration. As a result of the analysis, the software for COM+ and MTS components was installed to work with Oracle and DB2 databases. The transactional object for 2PC was created, allowing compensators to implement a simplified version of the DTC 2PC interfaces, prepare/notify and clean up resources in case of commit or initiate compensatory action in case of abort.
Stress testing showed that the solution is capable of seamless processing of Two-Phase Commit Transactions for Oracle and DB2 servers. This architecture offers broad benefits, such as enhanced scalability, security, and application logic reuse.
Client Benefits
- MTS & COM+ distributed 2PC transaction with Oracle and DB2
- Enhanced security
- Significant decrease of the risks of deploying systems
- MStress testing of COM+/MTS
Tools and Technologies
- COM+/MTS
- Oracle 8i, Oracle 9i
- DB2 Universal Database
- SilkPerformer
Project Statistics
- Efforts: 16 man/month
- Project duration: 4 months
|
