11/5/12

Developing High Performance Database Applications with pureQuery and IBM Data Studio


NoSQL data stores are in focus when it comes to high performance data applications. However, for many organizations relational databases are the mainstay of infrastructure, and we need to get them executing efficiently as well. In previous years, the enthusiasm around various object-relational mapping has been partly replaced with healthy skepticism. Explicit control over SQL became an important feature, especially when we are dealing with established databases that are not created from scratch by developers.

NoSQL data stores are in focus when it comes to high performance data applications. However, for many organizations relational databases are the mainstay of infrastructure, and we need to get them executing efficiently as well. In previous years, the enthusiasm around various object-relational mapping has been partly replaced with healthy skepticism. Explicit control over SQL became an important feature, especially when we are dealing with established databases that are not created from scratch by developers.

When working in a DB2 environment, pureQuery is a particularly attractive solution through its combination of explicit SQL control, high performance, and excellent tooling. This year I will be speaking on pureQuery and at the IBM Information on Demand 2012 conference in Las Vegas.

Update: The slides of the talk are now on the slideshare, but the really interesting part of the talk, not captured in the slides, is in the hands on demo, where we build a DB2 backed application in a matter of minutes and then profile and optimize SQL performance.