developerWorks spaces: IBM Integrated Data Management Community (Optim and Data Studio)

developerWorks > My developerWorks > Spaces >
	Integrated Data Management (Optim and Data Studio)
	Tags for this space:


View the non-JavaScript version


Welcome guest	\|	Sign in

Home

Articles & Tutorials

Downloads here!

Overall

What is Optim? Integrated data management? This tab is organized by data development lifecycle phases: design, develop, deploy, operate, optimize, and govern. Start here for the big picture.

Integrated Data Management 'big picture': Holly Hayes does her usual great job pulling the story together.
What's new and cool in Optim Development Studio: You won't want to miss this!
Organizations thrive on Data: Great overview article on IDM in Systems Magazine.
Jump start enterprise modernization efforts with Optim: Online exclusive in Systems Magazine.
Simply Manage the Data: Curt Cotner writes on how Optim solutions can simplify database management in a System z environment (page 27)
Optim 2.2 packaging: Get your questions answered on free vs. fee, product names, supported databases and more.
NEW!! Using Integrated Data Management to meet Service Level Objectives: Draft redbook focuses on pureQuery and performance management solutions.

Design

Discover, harvest, model, and relate information to drive a common semantic understanding of the business.

Best Practices: Information Modeling with Rational Data Architect Version 7: Great information.
Use IBM Rational Data Architect to take control of your DB2 database: Good for initial hands-on learning.
Migrating from CA ERwin to InfoSphere Data Architect: Wow, best practices and good detail from someone who has worked with both products.
Use Rational Data Architect to define and enforce data object naming standards: Really good use case for benefit of RDA.
Rational Data Architect skills series: Set of tutorial includes heterogeneous integration, generating SQL/XML queries, and discovering schemas.
Extend your RDA models: Series: Updated for IDA 7.5.2
Use RDA with Informix Dynamic Server: Tutorial.
The Information Perspective for SOA Design: Multipart. Great for architects.
Sharing a common vocabulary across InfoSphere Foundation Tools: InfoSphere Data Architect, Business Glossary and Information Server.
Use Optim software to manage privatized test data from design to deployment: Data privacy scenario with Optim Test Data Management and Data Privacy.

Deploy

Install, configure, change, and promote applications, services, and databases into production

Data Studio Administrator series: Two-part article series highlighting integration with RDA (now IDA) and how to use DSA for database version control.
Optimize your existing JDBC applications with pureQuery: This tutorial gives you all the basics of the client optimization feature in Data Studio Developer.
What's New in Data Studio Administrator 2.1: Learn about such things as copy and paste of tables and commands and utilities.
Optimize your existing .NET applications using pureQuery: Client optimization is not just for Java any more.
Oops! Restoring your Database with Data Studio Administrator: Our fictional JK Enterprise DBA saves the day.
Data migration and change management using Data Studio Administrator: Our fictional JK Enterprise DBA uses the new copy and paste capability to migrate to test, make a change, and move back to production.
Using Data Studio Administrator and DB2 High Performance Unload for fast and efficient data and sche: Our fictional JK Enterprise DBA migrates data quickly and easily with High Performance Unload.
Optimize Enterprise Generation Language (EGL) applications using pureQuery and Data Studio Developer: his article describes how pureQuery and Data Studio Developer can be used to optimize data access for DB2 LUW and z/OS with EGL Java applications.
Using command templates in Optim Database Administrator: Customize the command templates for use in the SQL and XQuery editor.

Optimize

Provide pro-active planning and optimization for applications and workloads including trend analysis, capacity and growth planning, and application retirement including executing strategies to meet future requirements.

Optim Data Growth Solution web site
DB2 for z/OS 9: New Tools for Query Optimization: Popular redbook about Optimization Service Center and DB2 Optimization Expert for z/OS.
Performance of Data Studio pureQuery Runtime for z/OS: Yes, using static SQL can optimize performance and here are some numbers from our testing.
Developers and DBAs working together on query tuning: Ray Willoughby blogs on how using DB2 Optimization Expert for z/OS enables collaboration.
More pureQuery performance: Now for .NET: Good numbers!
Access Optim archive file data using Cognos: Keep online data growth under control while maintaining ability to report on archive files.
NEW! Query tuning is not just for hardcore DBAs: Sign in to Database Magazine to see this article on Optim Query Tuner and Optim Development Studio.
NEW! Use Integrated Data Management to meet Service Level Objectives: Draft redbook focuses on pureQuery and performance management solutions.

Group space

Overview

Join space

	Description: The IBM Optim and Data Studio portfolio provide leading-edge integrated data management capabilities, making it easier to manage data-centric tasks across the lifecycle spanning design, development, deployment, management, optimization, and governance. This space will serve as a central hub of information and conversation about Integrated Data Management products, technologies, and best practices.
	Objective: Provide links to key Integrated Data Management articles, tutorials, videos and more. Connect with other users.
	Audience: Data Architects Database Administrators Data Stewards Database developers Java developers
	Group type: Public
	Date created: 19 Sep 2007

	Show member list

developerWorks spotlights

	Free trial download: Lotus Notes, Domino Designer, and Domino Administrator clients V8.5

	Event: Impact 2009

	Conference: Lotusphere 2009 -- complete coverage

developerWorks offers

More offers

Develop - Runtime & API

Introducing pureQuery annotated method style: Lets you make static and dynamic decision at deploy time.
Introducing pureQuery inline style: Slick and easy.
pureQuery API best practices: Examples illustrating how you can get the most out of pureQuery.
Migrating from EJB2 to pureQuery: Real life experience and results from a major IBM product's move to pureQuery.
Leverage pureQuery static with WebSphere JPA: New in WebSphere 7.
Smoothly blending SQL and Java with pureQuery: New DevX article.
Handling pureXML data in pureQuery

Develop - Tools

Code, generate, test, tune, and package data access layers, database routines, and data services.

What's new and COOL in Optim Development Studio 2.2: So cool it's hot! Use it with the trial software available from the Downloads here! tab.
Overview of pureQuery tools: Great tooling introduction. See the 1.2 Data Studio Overview to get the latest information (link below).
pureQuery and rapid application development: UPDATED for 2.1. Includes very cool pureQuery features.
Use Data Studio with IDS: Good tutorial targeting Informix Dynamic Server users.
Debug stored procedures on DB2 for z/OS: Unified Debugger on the client.
Using common connections in Data Studio: UPDATED for 2.2! Now also supported in IDA!
Exploring Data Studio Developer UI: Detailed look at changes in 2.1 because of new Data Tools Platform.
Optimizing EGL applications with Data Studio Developer: Use client optimization with Enterprise Generation Language.
Query tuning is not just for hardcore DBAs: Subscribe to Database Magazine and check out the article on Optim Query Tuner and Development Studio
Developing with PL/SQL in IBM Data Studio 2.2 and Optim Development Studio 2.2: Learn how to develop PL/SQL Routines for Oracle using Optim Development Studio.

Develop - Web services

Unlock business functions using DB2 for z/OS stored procedures and Data Web Services: NEW! Part 2 just added includes UDFs and file data.
DB2 9 for z/OS: Deploying SOA Solutions: Redbook. Includes information about using WebSphere DataPower SOA appliances.
Build Data Web services: Overview article.
Transforming Business Logic into Web Services Using DB2 9.5 and IBM Data Studio: Part of a bigger series you probably want to check out.
Using WebSphere DataPower SOA appliances to enable Information as a Service pattern: Very cool stuff! And yeah, it's super easy to do with Data Studio Developer. More on that later....
Deploying Data Web Services on WebSphere Data Power appliance: Step by step....
Integration between XML Forms Generator and Data Studio: The integration between XFG and Data Studio can enable you to generate XForms/XHTMLs from Data Web Services generated by Data Studio Developer.
Redpaper: Getting Started with Web Services on DB2 for z/OS: Based on Data Studio 2.1.
Build an intelligent eForms solution based on DB2 pureXML, Lotus Forms, and Web services

Operate

Administer databases to meet service level agreements and security requirements while providing responsive service to emergent issues.

Health, availability, and problem determination using IBM Data Studio: Step-by-step tutorial on using the web-based administration console feature.
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS product site
More Z tools
End to end database monitoring with DB2 Performance Expert
Oops! Restoring your database using Data Studio Administrator
Top 6 Tips for a succesful DB2 Performance Expert Deployment
Getting started with DB2 Performance Expert Extended Insight Feature

Govern

Establish, communicate, execute, and audit policies and practices to protect and retain data in compliance with government, industry, or organization requirements and regulations.

DB2 Audit Management Expert web site
Optim Data Privacy solution web site
IBM Database Encryption Expert web site
Use IBM Database Encryption Expert to protect your sensitive data: Technical article.
De-identify flat files using Optim Data Privacy Solution and InfoSphere Federation Server: Technical article.
NEW! Use Optim software to manage privatized test data from design to deployment: The end to end scenario iwth IDA, ODS, TDM

About IBM

Privacy

Contact

Integrated Data Management (Optim and Data Studio)