Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Select a language:

  • Close [x]
  • Close [x]

Introduction to IBM Optim Development Studio and pureQuery Runtime

Discover the rich data management and development features

Date:  07 Oct 2011 (Published 24 May 2011) |Level: Intermediate |

Sign in to save your progress (Learn more)

Saving your progress (Learn more)

1. Install IBM Optim Development Studio and pureQuery Runtime

IBM Optim Development Studio (previously called Data Studio Developer) and Optim pureQuery Runtime together provide an integrated development environment to speed up your data access design, development, and deployment while also increasing your data access efficiency and performance.

Download: IBM Optim Development Studio and Optim pureQuery Runtime V2.2.1(Free trial)Item marked not complete - Click to mark complete

2. Explore the key capabilities

In a series of free online technical briefings, get familiar with the Optim portfolio. Then watch a 35-minute, 5-part video series showcasing what's new in Version 2.2 of Optim Development Studio.

Watch: Virtual Tech Briefings on Optim Solutions for Integrated Data ManagementItem marked not complete - Click to mark complete

Watch: What's New in Optim Development Studio V2.2(35 min.)Item marked not complete - Click to mark complete

3. Code Java apps using pureQuery methods

Optim Development Studio helps you develop Java applications that use pureQuery annotated methods. Learn how to create a pureQuery-enabled Java project in Optim Development Studio, add support for pureQuery, and generate code and SQL directly from a database table. Then modify the generated interface, test it, and use the SQL Outline to navigate between the Java source code and SQL. And finally, gather SQL performance data, view it in the SQL Outline, and bind the SQL for static execution.

Read: Create a Java project and generate codeItem marked not complete - Click to mark complete

Read: Modify and test the interfaceItem marked not complete - Click to mark complete

Read: Gather performance data and bind the SQLItem marked not complete - Click to mark complete

4. Manage your database routines and test deployments

Create and manage your database routines and adopt routine templates more simply. And deploy artifacts to your test environment more easily with the Optim Development Studio test deployment management framework.

Read: Routine development simplifiedItem marked not complete - Click to mark complete

Read: Test deployment simplifiedItem marked not complete - Click to mark complete

5. Collaborate to improve performance and stability

With Optim Development Studio, developers, architects, and database administrators (DBAs) can collaborate in new and productive ways in heterogeneous database environments with Oracle and IBM databases, and improve performance, security, control, and maintenance.

Read: Fast track your application development on heterogeneous databasesItem marked not complete - Click to mark complete

Read: Use enhanced administrative control for client optimizationItem marked not complete - Click to mark complete




Rate this content



Give us feedback

Submission failed. Please try again.

Please complete one of the following questions before submitting.

1. Are you finished with this knowledge path?

       

2. How much did you learn?

           

3. Tell us more

  • What did you like/dislike?
  • What can we do better?

2500 characters left

Disabled Submit button

Close [x]

developerWorks: Sign in


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 

All information submitted is secure.

Close [x]

Save your progress Green checked checkmark

When you sign in, we will save this item to your developerWorks community home page and track your progress so you know what you've completed and where to resume when you return.

For a list of your saved items, see your My Home > My saved items page.

Close [x]

Thank you for your feedback. We appreciate your sharing your opinion with us.

Close [x]

Do you want to save your progress?

, Sign in to save your progress

Close [x]

Save your progress

Sorry. Our server is not available, and we cannot display your saved progress at this time.

Your progress will be displayed when the server is available again. Any previous progress is retained, and additional progress is being tracked.

If your most recent progress is not displayed within 24 hours, you can click the checkmark to indicate completion.

About this knowledge path

Get started with IBM Optim Development Studio and Optim pureQuery Runtime, an integrated development environment for designing, developing, deploying, and managing database applications with optimal performance. This knowledge path is especially suited to database application developers who want to learn more about the rich data management and development features of Optim Development Studio and pureQuery Runtime.

Activities in this path

  1. Install IBM Optim Development Studio and pureQuery Runtime
  2. Explore the key capabilities
  3. Code Java apps using pureQuery methods
  4. Manage your database routines and test deployments
  5. Collaborate to improve performance and stability

Related resources

Share this page:

  • Close [x]

Follow developerWorks:

  • Close [x]
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=755639
publish-date=10072011