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 !
DEADWOOD 2014-07-07 Shivraj
with Tags: ibm X
ShivrajKumarSarsambi 270001HRB9 Tags:  dba ibm optim developer smart java xml purequery sql 1,089 Visits
In response to: How green are our softwares we use ?thanks Bob and all ! I am quite excited too :-)
ShivrajKumarSarsambi 270001HRB9 Tags:  green ibm db2 smarter_planet im smart 2 Comments 1,303 Visits
Taking a leaf out of the movie " The Age of Stupids " just concluded , I am quite enthralled to write my first post on dW blog regarding the green technologies we develop, we use , we buy , we sell ? Basically, " consumerism" is the buzz word of the human sustainence and for the economy to run smoothly.
In this rat-race, we have forgotten the way technologies we use are contributing to the global warming ! Although it seems trivial at the first place, this thing will be factor for us to work upon as we step into the next decade. It feels great that I am part of company which is smart and knows the advantages of developing smarter and greener products .
With all the philosophy shared, the main point I wish to share with you here is that how every software you use plays the role in saving energy to make the PLANET EARTH sustain the future generations ! Ponder upon this ,lets make our software the energy-saver , not the energy-guzzler !
Looking forward from every one to post your comment how your software is smarter and greener . Watch out here for more posts on DB2 and how it saves energy / resources as well as other topics of my interest. Time for me to save some energy by shutting down my laptop . :-)