Product overview

These documents provide a general overview of InfoSphere Optim pureQuery Runtime.

Installing

These documents provide information about how to install InfoSphere Optim pureQuery Runtime.

Developing applications with pureQuery technology

Use these documents to learn how to best use pureQuery Runtime to simplify and enhance the performance of your data access applications.

  • Getting Started with pureQuery (e-book) In this free book, learn what pureQuery is and how to use Data Studio to create Java database applications with the pureQuery API. You also learn how to use pureQuery to optimize existing Java database applications and Java Persistence API (JPA) and Hibernate applications. You can download a sample Java application that is used in the book.
  • Write high performance, Java data access applications, Part 1: Introducing pureQuery annotated method data access objects This article explains why a developer might choose to write a pureQuery data access object with data access object (DAO) interfaces and annotated methods. The article discusses some of the differences between using pureQuery annotated methods and pureQuery built-in inline methods, and gives a brief overview of the most powerful features of pureQuery annotated methods.
  • Write high performance Java data access applications, Part 2: Introducing pureQuery built-in inline methods This article explains the key features of inline methods and why a developer might choose to use them. For example, with inline methods, SQL or XQuery statements can be created inline within the code as a Java string object and passed as a string parameter to the pureQuery Data interface method.
  • Write high performance Java data access applications, Part 3: pureQuery API best practices This article summarizes some best practices for pureQuery development and provides real-world scenarios that illustrate how to implement these practices.
  • Developing a Java application that uses pureQuery annotated methods This tutorial introduces some of the features in Data Studio that you can use to develop an application that uses pureQuery annotated methods with data access object (DAO) interfaces.
  • Example of pureQuery nested beans These example Java classes and interface use pureQuery nested beans to return data from an SQL query that contains a join predicate. The pureQuery annotations on the class properties define the hierarchy of the nested beans. The query is used as an inline SQL Query and as a Java interface. The example includes JUnit test methods for the pureQuery nested beans.
  • Using the IBM Integration Module for Hibernate and pureQuery This article describes using InfoSphere Optim pureQuery Runtime and the IBM Integration Module with Hibernate applications. pureQuery Runtime and the IBM Integration Module simplify the process of generating DB2 static SQL for Hibernate applications. pureQuery Runtime also enables Hibernate applications that access DB2 or Informix data sources to benefit from the pureQuery heterogeneous batching feature. This article includes a downloadable sample application.
  • Auto-tuning Hibernate applications with pureQuery Runtime This article describes auto-tuning Hibernate applications with InfoSphere Optim pureQuery Runtime. Auto-tuning for Hibernate automates the most common problems faced by users of Hibernate, which is to optimize the database access patterns of Hibernate in each use case of the application without manual intervention.
  • Using the IBM Integration Module for iBATIS and pureQuery This article describes combining InfoSphere Optim pureQuery Runtime and the IBM Integration Module with iBATIS applications. pureQuery Runtime and the IBM Integration Module simplify the process of generating DB2 static SQL for iBATIS applications. pureQuery Runtime also enables iBATIS applications that access DB2 or Informix to benefit from the pureQuery heterogeneous batching feature. This article includes a downloadable sample application.

pureQuery client optimization

These documents provide information about how to enable pureQuery client optimization.

  • Getting Started with pureQuery (e-book) In this free e-book, learn what pureQuery is and how to use Data Studio to create Java database applications with the pureQuery APIs. You also learn how to use pureQuery to optimize existing Java database applications and Java Persistence API (JPA) and Hibernate applications. You can download a sample Java application that is used in the book.
  • Enable a Java application with pureQuery client optimization In these topics, learn how to configure pureQuery Runtime to capture SQL statements from a Java application. You also learn how to configure pureQuery Runtime to control SQL statements that are run by an application and bind SQL statements to a DB2 database.
  • Optimize applications on a single application server node This first article of a two-part series describes options for pureQuery property settings when you are using pureQuery client optimization in a single-node application server environment in which one or more applications are sharing multiple data sources. This article assumes that you are familiar with the pureQuery client optimization process and with setting web application properties for WebSphere Application Server or another application server environment.
  • Optimizing applications in clustered environments This second article of a two-part series focuses on how to set client optimization properties in complex web environments, such as an environment with clustered application servers. This article assumes that you are familiar with the pureQuery client optimization process and with setting web application properties in WebSphere Application Server or another application server environment.
  • Automate pureQuery client optimization with WebSphere applications Learn how to automate the pureQuery client optimization process with Apache Ant script technologies.
  • Deploying pureQuery client optimization applications These information center topics contain information about the benefits of using pureQuery client optimization, the steps you follow to deploy pureQuery client optimization, example scenarios, and guidance information.

Configuration

These documents provide information about how to configure InfoSphere Optim pureQuery Runtime.

Troubleshooting

The resources in this section provide information about identifying and solving problems.