IBM pureQuery

pureQuery software is a key differentiator of the IBM Integrated Data Management portfolio. It provides a high-performance data access platform that makes it easier to develop, optimize, secure, and manage data access.

pureQuery is a cross-lifecycle technology. It can:

Reduce cost

• Get more from existing hardware and software investments by reducing CPU usage per transaction for access to DB2 - up to 42% for when compared to dynamic JDBC
• Migrate more function to IBM System z® Integrated Information Processor (zIIP) and System z Application Assist Processor (zAAP) to lower costs of applications that access DB2 for z/OS data

Reduce time to market for new Java applications for DB2, Informix Dynamic Server, and Oracle databases

• Improve productivity up to 50% using developer friendly tooling
• Balance productivity and control – Developers and DBAs can access and edit generated SQL to provide maximum efficiency
• Enable developer and DBA collaboration by bridging the gap between the Java world and the database world by providing traceability and relationship information between the database and the Java application.

Improve quality of service for new and existing applications

• Lock in access plans for guaranteed service levels
• Speed up problem isolation from days to minutes with enhanced monitoring capabilities
• Improve impact analysis and capacity planning
• Manage and monitor applications
  • Lock in access plans for guaranteed service levels
  • Speed up problem isolation from days to minutes with enhanced monitoring capabilities
  • Improve impact analysis and capacity planning
  • Manage and monitor applications to meet service level agreements more easily and effectively

  
  Enhance security
  

  • Minimize or eliminate SQL injection risk with ability to allow execution only of approved SQL
  • Limit user access to adhere to the principle of least privilege by granting privileges only for required application SQL, not access to the entire table.
  • Improve audit readiness