It’s only been a few months since our last release, and my team and I have been busy taking our products closer to realizing the Integrated Data Management vision for integrated lifecycle development and heterogeneous database support.
So what's different in this release? With the announcement and release of Optim Development Studio 2.2 (formerly Data Studio Developer), we added:
- Features that help developers and DBAs work together to create high performing Java data access code with high productivity, on Oracle, DB2, and Informix Dynamic Server databases.
- Speedy iterative testing
- Enhanced impact analysis
- Support for building and debugging SQL/PL procedures to run against either DB2 9.7 or Oracle databases.
As the architect for pureQuery tools, I wrote a new developerWorks article that goes into some detail on the new capabilities, mostly from a pureQuery perspective. (You can see more about the other Oracle support capabilities in Venkatesh's blog.) I’ll give you some highlights of this release from a pureQuery perspective in hopes that it will convince you to go read the article and download the trial code!
Some of the important features –
Oracle pureQuery support
The big news of course is support for pureQuery capabilities for Oracle databases – pureQuery code generation, SQL content assist, validation and all the editing capabilities ( now also available for JDBC, and native SQL in JPA and Hibernate applications), client optimization, dependency analysis, hot spot analysis. If you aren’t familiar with these capabilities, my article does review them.
The screenshot below shows a sample pureQuery application that was run against Oracle. Using the SQL outline (formerly called pureQuery outline), you can see the performance metrics from the Oracle queries. You can also see predicted cost using the EXPLAIN Data option. (That EXPLAIN Data option is new for DB2 and IDS as well.)
Visibility of data privacy attributes to developers
The other interesting integration work that was done is the ability to maintain data privacy attributes from modeling through development and test. Anson Kokkat touched on this in his recent blog. Production databases often contain sensitive information such as credit card numbers or social security numbers. When data architects create data models for such databases using InfoSphere Data Architect, they can identify which attributes or columns contain sensitive information and specify appropriate privacy policies to be used with them.
By associating this model with their database, developers can easily see which columns are identified as containing sensitive information and this can help them maintain compliance in how they handle that data in their applications. This protection also extends further to their applications - they can see how those private columns are being used in context to ensure they are not doing something inappropriate, such as printing out data in those columns.
The screenshot below shows the private columns in the SQL outline (a little padlock icon is used to indicate a private column), their privacy properties, and how you can navigate to the model to get more information.
Other key capabilities include:
- Ability to copy and paste objects or data subsets as an aid to developers. If you need something more heavy duty, the copy/paste wizard can generate a script that can be used with Optim Test Data Management solutions. (Note that this capability is currently available only with DB2 LUW 9.7 and Oracle.)
- For DB2, you can now specify that literals be replaced with parameter markers as part of the SQL capture process. Because this makes the statement less ‘unique’ it is now eligible to be bound statically. This was a requirement we had from several customers. Also, we’ve made a lot of enhancements in package management to give you more granularity in identifying and rebinding only packages that have been impacted by a change. In addition, you can bind in the background.
There are really a lot more enhancements, but you’ll need to read the article – I don’t have room to list everything here. We’re also working on some videos that will show these features in action.