Optim pureQuery Runtime for Linux, UNIX and Windows

The pureQuery platform is a high-performance data access platform that makes it easier to develop, optimize, secure, and manage data access.

It consists of:

• APIs built for ease of use and for simplifying the use of best practices

• Development tools, delivered in Optim Development Studio, for Java and SQL development

• A runtime, delivered in Optim pureQuery Runtime, for optimizing and securing database access and simplifying management tasks

Optim pureQuery Runtime

Optim pureQuery Runtime accelerates new or existing Java applications, even those applications in which the SQL is generated by a framework, such as Hibernate or OpenJPA. Seamlessly and transparently leverage the benefits of DB2 static SQL execution. Give DBAs the ability to optimize and lock down SQL without modifying the application. Provide the information necessary to quickly trace SQL back to its source.

Improve performance:

• Capture, review, share, and optimize SQL. Facilitate collaboration between developers and DBAs. Replace poor-performing SQL with optimized SQL.

• Reduce CPU overhead. In-house testing of DB2 static SQL using pureQuery Runtime reduced CPU per transaction up to 42% over using dynamic JDBC and up to 61% over dynamic SQL with .NET. Your results will depend on many factors related to system environment and the characteristics of the application.

Enhance security:

• Reduce exposure of sensitive data by using the authorization model associated with DB2 static SQL, which grants the EXECUTE privilege on individual packages rather than READ privilege on tables.

• Reduce the possibility of malicious SQL injection. Developers or DBAs can now restrict the SQL that will be executed, dynamically or statically.

Improve manageability:

• Leverage development metadata to trace an SQL statement to the original application source.

• Accelerate problem isolation tracing a performance issue to a specific DB2 static package providing better correlation between database workload and the originating application.

• Improve version control using DB2 static SQL packages to simplify reverting to previous levels without requiring changes to the application.

• Facilitate DB2 for z/OS reporting for capacity planning and charge-back accounting.

For any supported database, use pureQuery with any Java application with no change to existing application code.

Flexible on-ramps to pureQuery benefits include:

• For new applications, use the intuitive pureQuery API for development and deployment

• For existing Java applications (custom-built, framework-based, or packaged applications), use the pureQuery client optimization capability to capture running SQL and associated metadata, then use Optim Development Studio to visualize the correlation between application SQL and associated Java source code. Visualize the elapsed time and frequency of captured SQL. Launch Visual Explain to see the access path. Optimize and replace SQL statements without changing the application. For DB2, optionally bind the captured SQL into packages for static execution.

• For WebSphere Application Server 7 JPA applications, use unique integration with Data Studio pureQuery Runtime to introspect existing Java classes and gather up the SQL for binding into static packages without having to execute the application

Optim pureQuery Runtime can also be used to transform dynamic .NET applications that access DB2 into static ones. Use with any .NET-based language, including C# and VB.NET, Get all the benefits of static execution - improved performance, enhanced security, and improved manageability – with no change to the application.