Datasheet

IBM Software 7
Help simplify and protect applications
with InfoSphere Optim pureQuery Runtime
InfoSphere Optim pureQuery Runtime provides a runtime
environment and application programming interfaces (APIs)
to enhance performance of existing in-house applications
written in Java, Microsoft .NET or C without application code
changes, and to speed development of new applications.
Use InfoSphere Optim pureQuery Runtime to:
• Facilitate rapid development and deployment of new
performance-optimized applications
• Lock in access plans and performance for SQL statements
with static execution of SQL statements
• Replace poorly performing SQL with optimized SQL
• Enhance security by reducing exposure of sensitive data
• Improve manageability by quickly tracing performance issues
and enhancing version control
InfoSphere Optim pureQuery Runtime offers important
advantages over other available frameworks. It provides static
execution even to your existing Java Database Connectivity
(JDBC) applications without requiring any code modication.
In addition, the tool builds on user SQL statements for
generating application code, so the developer retains full
control over the kind of SQL statements employed in the
applications built.
Assess the impact of application and
infrastructure changes before moving
to production
To further improve database and application performance,
IBM offers InfoSphere Optim Query Capture and Replay,
which helps IT staff create realistic SQL performance testing
scenarios easily. It captures production workloads and replays
them in nonproduction environments, complete with change
impact reports, to facilitate SQL performance testing that
helps mitigate risks and accelerate time to market.
Modernizingthedatadevelopmentenvironmentwith
InfoSphereOptimpureQueryRuntime
Software and services provider ETNA needed to modernize
its data development environment to meet a growing
demand for services. To ensure consistent performance
from business-critical Java applications, the company
wanted to track SQL statements through the application
and database to identify, diagnose and resolve performance
problems. At the same time, the company wanted to reduce
storage and administrative costs and improve collaboration
among architects, DBAs and developers.
The solution was to deploy IBM Data Studio with IBM
InfoSphere Optim pureQuery Runtime. The company
achieved predictable, consistent application response times
and developed a reliable process for tracing SQL statements
through both the Java application and the database.
Integrated rapid application deployment (RAD) and data
management offerings helped reduce hardware and
administrative costs, and aligned the work of developers
and DBAs. Overall, the company decreased development
time, bringing functionality to market sooner.
“Data Studio and InfoSphere Optim
pureQuery Runtime are must-haves for
organizations using Java. These powerful,
scalable solutions stabilize performance by
allowing both static and dynamic SQL
execution without application changes.”
—Dalibor Harmina, IT architect, ETNA