Transoft database modernization solutions allow organizations to rapidly replace proprietary legacy file sytems with modern Relational Database Management Systems (RDBMS) such as Oracle or Microsoft SQL Server.

The solutions can be implemented without significant change to existing applications, and they utilize middleware products which have been specifically desgined to work between legacy applications and a RDBMS. The middleware layer provides either an easy to implement API to replace existing program I/O statements, or in some cases can automatically intercept existing I/O statements, which means there is no code change required.

Performance is optimized by adopting an elegant server-based architecture providing the following benefits:

• Stateless transactions, increasing throughput and scalability
• Database connection pooling improving performance and reducing system overheads
• Pre-prepared queries, providing maximum performance optimization
• Lock management to mimic legacy application locks
• Data type translation enabling data to be stored as native RDBMS data types, while preserving the data types in legacy programs

Modernizing existing legacy data to a RDBMS enables organizations to improve data integrity and robustness and readily share this data with other applications. It is easy to implement data warehousing and business intelligence projects, plus database high availability solutions.