With the advent of IBM Datastudio pureQuery Runtime and the latest 2.2 version renamed to IBM Optim pureQuery Runtime, life of the Java as well as SQL developers along with DBA's , infact entire data-driven application development team has eased to a marked extent .
I came across a really good article Smoothly Blending Java and SQL with pureQuery where Rick has explained , with apt-snapshots how the feature is a boon to the new-age developers who love to be lazy but rely on smart tools and technologies to assist them or even the veteran developers who have slogged a lot in their early days to develop their app but waited for something like a magic stick for their task. Guess what , this is just the right tool which serves their purpose and ofcourse, I wish to be the former one . :-)
To start with few points ,
i.Any SQL statements are treated just as a plain string in traditional JDBC programming methodology, but pureQuery sees them the way they are , sounds good, right ?
Yes ofcourse, giving it the priority , there is tremendous code-typing reduction, enhanced productivity and lot of happy faces among the programmer community , well that's what is the intent of this great offering from IBM .
ii. Seamless mode change from dynamic to static with four obvious phases of capturing dynamic SQL statements, configuring and binding them to execute in a static fashion and giving an XML /JSON file as output helps in performance improvement . Around 25 % improvement quoted by customers is remarkable , and this is achieved at the deployment phase, not at development phase . Are you in love with pureQuery now ? Wait then, I have one more thing to share which will roll you off your couch ! .
iii. Laced well along with IBM Optim Developer Studio , there are many wizards which will not only just help you in CRUD code generation, but it helps in customizing and evolving it as you go down-the line. Having all SQL statements generated in one file will make DBA life easier, and tracking them in the application which will be easy in turn to tune the performance is icing-on the cake.
That's it from my side. As of now, I have worked on (ii) point extensively. I love to explore more on this
Wish many more such products come to life , and make life easier for the agile teams to create smarter applications !
with Tags: purequery X
ShivrajKumarSarsambi 270001HRB9 Tags:  dba ibm optim developer smart java xml purequery sql 1,065 Visits