Getting Started with pureQuery
TOC
PART I – OVERVIEW AND SETUP
Chapter 1 – Introduction to pureQuery
1.1 The big picture: What is pureQuery?
1.1.1 What’s in a name?
1.1.2 What do we mean by platform?
1.2 pureQuery application programming interfaces
1.3 pureQuery runtime
1.4 pureQuery application development environment
1.5 pureQuery monitoring services
1.6 Career path
1.7 The pureQuery community
1.7.1 Popular community Web sites
1.8 Competitive products
Chapter 2 – Installing pureQuery (Optim Development Studio)
2.1 Installation: The big picture
2.2 Installation prerequisites
2.3 Installing Optim Development Studio
2.3.1 Installing from the launchpad
2.3.2 Applying Optim Development Studio Fixpack 1
2.4 Running Optim Development Studio
2.4.1 Adding pureQuery support to projects
PART II – TOOLING
Chapter 3 – Code generation and customized Java Editor Integration
3.1 pureQuery Tooling: The big picture
3.1.1 Generating pureQuery code
3.2 Overview of the different types of wizards for code generation within the pureQuery tooling
3.2.1 Stored procedure code generation wizard
3.2.2 Generating or updating JUnit testcases for existing interfaces
3.3 SQL editor integration inside the Java editor
3.3.1 SQL validation within the Java editor
3.3.2 SQL semantic and syntactic content assist for SQL inside Java editor
3.3.3 Test and run SQL within your Java program
Chapter 4 – pureQuery tooling Views
4.1 pureQuery tooling: The big picture
4.2 SQL Outline view
4.2.1 Gather the SQL statements issued by the application
4.2.2 Gain insight into where SQL statements are issued within your application
4.2.3 Pages of the SQL Outline view
4.2.4 Enhanced impact analysis within database applications
4.3 Designing and binding packages for static SQL development
4.3.1 Designing database packages
4.3.2 Binding database packages
4.4 pureQuery Analysis view
4.5 Enforce data privacy from modeling through development
Chapter 5 – Developing for performance
5.1 Developing for performance: The big picture
5.2 Identify the time and frequency of execution and cost of a statement
5.2.1 Gathering and viewing performance metrics
5.2.2 Gathering and viewing explain data
5.3 Optimizing your application for performance
5.3.1 Optimize your applications by using Optim Query Tuner
5.4 Comparing performance results after optimizing your application
PART III – SECURITY, PERFORMANCE, AND INSIGHT
Chapter 6 – The Client Optimizer: pureQuery for Existing JDBC Applications
6.1 Client Optimizer: The big picture
6.2 Overview of how to use the Client Optimizer
6.3 JDBC driver requirements for using Client Optimizer functionality
6.4 pureQuery properties
6.5 Capturing SQL statements
6.5.1 pureQuery properties during capture
6.5.2 In practice: Capture SQL statements in the Human Resources Manager application
6.6 Processing the pureQueryXml file with the Configure utility
6.6.1 Specifying options for the Configure utility
6.6.2 Statement sets in pureQueryXml files
6.6.3 DDL statements
6.6.4 Files with the .org extension
6.6.5 Running the Configure utility
6.6.6 In practice: Configure the pureQueryXml file that was captured
6.7 Binding the SQL statements in the pureQueryXml file
6.7.1 In practice: Bind the SQL statements in your pureQueryXml file
6.8 Running an application while specifying a pureQueryXml file
6.8.1 Static execution
6.8.2 Captured-only execution
6.8.3 Replacing SQL statements with alternate statements
6.8.4 SQL literal substitution
6.8.5 Capturing during execution
6.8.6 In practice: Run the Human Resources Manager application while specifying the pureQueryXml file
6.9 Specifying alternate SQL statements for execution
6.10 SQL Literal substitution
6.10.1 Advantages of parameterized SQL statements
6.10.2 How to use pureQuery SQL literal substitution
6.11 Locating SQL statements in your application
6.12 Aspects of JDBC application that may cause problems during static execution
6.13 Advanced features
Chapter 7 – The StaticBinder Utility
7.1 The StaticBinder utility: The big picture
7.2 Binding from interfaces and pureQueryXml files
7.2.1 Binding from interfaces
7.2.2 Binding from pureQueryXml files
7.3 Specifying options for the StaticBinder utility
7.4 Specifying interfaces and pureQueryXml files in an archive file
7.5 Running the StaticBinder utility in IBM Optim Development Studio
7.6 Running the StaticBinder utility from the command line
7.6.1 Specifying database connection information
7.6.2 Specifying the interfaces and pureQueryXml files
7.6.3 Specifying additional options
7.6.4 Example commands for the StaticBinder utility
7.7 Advanced features
Chapter 8 – Extended Insight
8.1 Extended Insight: the big picture
8.2 Common Problems in Multi-Tiered Monitoring
8.3 Monitoring pureQuery Clients
8.3.1 More Monitored Layers
8.3.2 Identifying pureQuery Applications Using Extended Insight
8.4 Extended Insight For A Variety of Application Types
8.4.1 Monitoring Plain JDBC or CLI applications
8.4.2 Monitoring pureQuery Applications associated with pureQueryXml
PART IV – API, RUNTIME AND SERVICES
Chapter 9 – Persistence Frameworks and Data Access: Context for pureQuery
9.1 Persistence Frameworks and Data Access: the big picture
9.1.1 pureQuery and Persistence Frameworks
9.2 pureQuery APIs in Context
9.3 pureQuery Data Access Overview
9.3.1 pureQuery Beans as Transfer Objects
9.3.2 Advanced pureQuery bean assembly using pureQuery Handlers
9.3.3 Query over Collections with pureQuery
9.3.4 XML entity mapping with pureQuery
9.3.5 Overriding SQL Statements in Applications
Chapter 10 – Inline Programming Style
10.1 Inline programming style: The big picture
10.2 Instances of the com.ibm.pdq.runtime.Data interface
10.2.1 In practice: Overview of the “In practice” sections in this chapter
10.2.2 In practice: Create a Data object in the displayLogin() method
10.3 Executing SQL SELECT statements
10.3.1 Choosing the return type
10.3.2 Overriding the default cursor attributes
10.3.3 In practice: Execute a simple SELECT statement that uses cursor attributes — Complete the “Company Employees” screen
10.4 Executing SQL statement that have parameters
10.4.1 In practice: Specify a scalar as a parameter to an SQL statement– Complete the “Login” screen
10.4.2 In practice: Specify a pureQuery bean as a parameter to an SQL statement– Complete the “Employee Information” screen
10.5 Executing SQL statements that modify information in a database
10.5.1 Executing an SQL statement one time by using the method: int update (String sql, Object parameters)
Chapter 12 – Stored Procedures
12.1 Stored procedures: The big picture
12.2 The StoredProcedureResult interface
12.2.1 Getting the updated values of OUT and INOUT parameters
12.2.2 Getting the query results of the stored procedure
12.2.3 Closing the StoredProcedureResult object
12.3 Executing SQL stored procedure calls in the inline style
12.3.1 In practice: Use the inline style to execute a stored procedure — Complete the “Increase Employee Bonuses” screen
12.4 Executing SQL stored procedure calls in the annotated-method style
12.4.1 In practice: Use the annotated-method style to execute a stored procedure — Complete the “Increase Employee Bonuses” screen Chapter 13 – Handlers
13.1 Handlers: The big picture
13.2 Specifying handlers in the inline style
13.2.1 In practice: Specify a handler using the inline style — Complete the “Company Employees” screen
13.3 Specifying handlers in the annotated method style
13.3.1 Specifying handlers by using the @Handler annotation
13.3.2 Specifying handlers as method parameters
13.4 Writing handler implementation classes
13.4.1 Writing a ResultHandler<RES> implementation
13.4.2 Writing a RowHandler<ROW> implementation
13.4.3 Writing a CallHandlerWithParameters<CAL> implementation
13.4.4 How to write a ParameterHandler implementation
13.4.5 In practice: Write and specify a ParameterHandler implementation
PART V – BEST PRACTICES AND INTEGRATION
Chapter 14 – Best Practices
14.1 Best Practices: The big picture
14.2 Choose your style: inline vs annotated method style
14.3 Perform Joins with Table collation
14.4 Working with Exception categorization
14.5 Customizing the code generation templates
14.6 Recapture the SQL in your application
14.7 Custom handlers and annotated method style
Chapter 15 – pureQuery and pureXML
15.1 pureQuery and pureXML: The big picture
15.2 Give control to the SQL layer
15.3 Give control to the data access API
15.4 Give control to the application layer
Chapter 16 – pureQuery and JPA
16.1 pureQuery and JPA: The big picture
16.2 Static execution of JPA with pureQuery
16.3 Generating DB2 packages for JPA applications
16.4 Generating SQL statements
16.4.1 Creating and binding the packages
16.5 Running a JPA application using pureQuery
16.5.1 Running the application in static mode
Download : link
