Overview
InfoSphere Optim pureQuery Runtime for Linux, UNIX and Windows provides a high-performance data access platform focused on optimizing, securing and simplifying applications.
InfoSphere Optim pureQuery Runtime provides a runtime environment and application programming interface that enhances the performance of existing in-house database client applications written using Java or C without having to modify them . It also helps in rapid development of new applications.
- Captures critical client information that can be used by a database administrator to locate clients and optimize their interaction with the database.
- Helps rapidly build database, applications, when used in conjunction with IBM Data Studio
- Facilitates developer and DBA collaboration to improve the security, performance, and manageability of Java or .NET applications.
- Simplifies the use of best practices for SQL and JDBC, improving application performance.
- Provides Nested Query Beans, a feature that eases development of application code which executes and handles results from an SQL statement with joins.
- In house testing shows pureQuery Static APIs doubled the throughput of the DB2 for Linux, UNIX and Windows database server in comparison to JDBC. In addition, compared to JDBC, pureQuery Client Optimization Static and pureQuery API Static (Method Style) increased the throughput of the DB2 for Linux, UNIX and Windows database server by 60 and 66% respectively.
