Overview of developing and optimizing Java data access applications

With IBM® Data Studio, you develop or troubleshoot Java™ data access applications that use pureQuery™ Runtime. You can also use InfoSphere® Optim™ Performance Manager Extended Insight and InfoSphere Optim Query Workload Tuner to discover, diagnose, and resolve database performance problems.

pureQuery Runtime includes monitoring services that enable developers to quickly identify potential data access hot spots with IBM Data Studio. When you use Data Studio with InfoSphere Optim Performance Manager Extended Insight, you can analyze transaction response time across the various layers that have an impact on data access operations. You can view performance information for the application server, data server driver, network, and database server.

You can use InfoSphere Optim Performance Manager Extended Insight and InfoSphere Optim Query Workload Tuner to discover, diagnose, and resolve database performance problems.

In a development environment, pureQuery Runtime is included with IBM Data Studio and can be used to develop and optimize data access applications. The following illustration shows a pureQuery development environment when you use IBM Data Studio with other InfoSphere Optim tools:

Figure 1. pureQuery development environment with Data Studio and other InfoSphere Optim tools
pureQuery development environment with Data Studio and other InfoSphere Optim tools

Working with data access applications in Data Studio

Data Studio and pureQuery Runtime features support data access application development:
  • Full-featured IDE support with IBM Data Studio
  • pureQuery API support. The API supports features including:
    • Separating business logic from SQL statements
    • Creating nested beans that reflect the results of SQL statements that contains joins
    • Executing SQL statements in batches
    • Creating web application files such as WAR and EAR files that can execute SQL statements statically
  • Support for pureQuery Runtime files, including:
    • pureQueryXML file
    • StaticBinder utility options file
    • Configuration utility options file
  • Management of SQL Management repositories
  • Support for Java frameworks

The pureQuery API can help developers and DBAs work together efficiently. For example, in the SQL Outline view of Data Studio, a DBA can see SQL statements that are run by the application. In the view, the DBA can also display performance information for the SQL statements from InfoSphere Optim Performance Manager Extended Insight. In Data Studio, the DBA can tune poorly performing statements with InfoSphere Optim Query Workload Tuner.

To change SQL statements in the application, the developer can use the SQL Outline view to navigate to the SQL statements locations in the application.

Figure 2. The SQL Outline view in Data Studio
SQL Outline view in Data Studio

Feedback