InfoSphere® Optim™ pureQuery® Runtime provides a set of APIs
and also provides pureQuery client
optimization features. You can use pureQuery Runtime
to manage SQL statements that are issued from Java™, DB2® ODBC/CLI,
or Microsoft .NET applications.
You use the pureQuery APIs
to develop Java data access
applications or modify existing Java applications.
You use pureQuery client
optimization to manage SQL statements that are issued from existing Java, DB2 ODBC/CLI,
or Microsoft .NET applications. pureQuery Runtime supports
the following capabilities:
- Simplify the use of best practices for SQL and JDBC, which improves
application performance.
- Optimize existing JDBC, ODBC/CLI, and .NET applications without
changing application code.
- Help rapidly build Java data
access applications with IBM® Data
Studio.
- Facilitate developer and DBA collaboration to improve the security,
performance, and manageability of data access applications.
- Capture critical client information that can be used by a database
administrator to locate clients and optimize their interaction with
the database.
The following diagram shows how to use the pureQuery API and pureQuery client optimization with data
access applications:
Figure 1. The
process when using pureQuery API
and pureQuery client optimization
with data access applications
You can use the pureQuery API
and pureQuery client optimization
either separately or together in Java applications.
ODBC/CLI, and .NET applications support only pureQuery client optimization.
- pureQuery API
- With the pureQuery API,
you develop Java data access
applications that define Java interfaces
with Java annotations. Each
interface supplies an SQL statement to execute when an interface method
is invoked. In Data Studio, you can quickly create Java applications. Data Studio provides an integrated
development environment with Java and
SQL support to develop and manage data access applications. pureQuery Runtime is included
with Data Studio and can be used to develop and manage data access
applications.
- pureQuery client optimization
- With pureQuery client
optimization, you capture the SQL statements that are issued by Java, ODBC/CLI, or .NET applications.
The statements are captured in a pureQueryXML file. You configure
the pureQueryXML file with the pureQuery Configure
utility. pureQuery Runtime
uses the information in the configured pureQueryXML file and the values
pureQuery Runtime properties that you set to control the execution
of the application SQL statements. You can configure and mange pureQueryXML
files and manage pureQuery Runtime properties with Data Studio or
with command-line utilities.
You can use pureQuery Runtime
to control the execution of SQL statements when the statements are
run dynamically or statically. The steps that bind and execute SQL
statements statically are optional. Running SQL statements statically
on a DB2 database can improve
application performance and security.