© 2007 ibm corporation ® tools? you want tools - we got them! alice ma -...

© 2007 IBM Corporation

®

TOOLS? You want Tools - We got them!

Alice Ma - [email protected] Studio Enabling Architect PE, HPU & DSA

IBM Software Group | Information Management software

2

Agenda

Business Needs

Integrated Data Management

– Pain points

– Segment strategy

Product Overviews

– Features, Roles, Value

Looking Forward

– Key YE deliveries

Summary


3

What do Businesses Have?

Operate

Govern

DesignCA ERwin

IBM Rational Data Architect

Embarcadero ER/Studio

Sybase PowerDesigner

Embarcadero Rapid SQL

Quest TOAD

IBM Data Studio Developer

Oracle JDeveloper

Microsoft Visual Studio

Sybase PowerBuilder

Quest InTrust

IBM Rational ClearCase

IBM DB2 tools

Oracle Database Management Packs Quest Central

Oracle Partitioning

Embarcadero DBArtisan

IBM Optim

Develop

Deploy

A Collection of Disparate, Single-Purpose Products

Optimize

CA administration tools

Solix EDMS

IBM Optim Data Growth Solution


4

Integrated Data Management Vision

Providing end-to-end data lifecycle management

Facilitating cross-organizational collaboration for business alignment

Integrating via common user interfaces, common components and services, and shared policies, models, and metadata

An integrated, modular data management environment designed to increase organizational productivity and effectiveness while

improving the quality of service, cost of ownership, and governance of diverse data, databases, and data-driven applications


5

Discover Model Relate

Monitor Diagnose

Administer

Create Test Tune

InstallConfigureChange

TuneArchiveEvolve

ProtectRetainAudit

Managing the value of your data throughout its lifetime…from requirement to retirement


6

IBM Integrated Data Management

Design, Development, Deployment, Operations, Optimization, Governance

Supporting Enterprise Environments


7

Enabling Collaboration and Alignment Across Roles

DataArchitect

Logical Modeling

Physical Modeling

Integration Modeling

Data Modeling

Application Developer

Data Access:

Java objects

Web services

Web 2.0

Application Development

DatabaseDeveloper

Stored Procedures

SQL

XQuery

User Defined Functions

Database Development

Database Administrator

Configuration

Performance Management

Change Management

Availability Management

Database Administration

Security and Privacy Management

Archive and Retention Management

Auditing

Data Governance

Data Steward

Rational Software Delivery Platform

Tivoli Service

Management Platform

Business Analyst

Enterprise Architect

Systems Administrator

Network Administrator

Compliance Administrator


8

Rational Data Architect

Data Studio Developer

Optim Test Data Management

Optim Data Growth Solutions

The broadest range of capabilities for managing the value of your data throughout its lifetime

DB2 Performance Expert Data Studio pureQuery Runtime

Data Studio Administrator

z/OS Tools Portfolio

DB2 Audit Management Expert Database Encryption Expert

Optim Data Privacy Solutions


9

Integrated Data Management Today - Powerful Capabilities


– Collaborative data design to improve data quality and enterprise consistency

Data Studio Developer and pureQuery Runtime

– Enhance productivity up to 50% while improving code quality and providing expert-equivalent performance for Java data access

Database tools

– Administration and security management for achieving service level agreements

Optim Solutions for Data Growth, Data Privacy and Test Data Management

– Improve performance, control costs, reduce risks

– Control data growth, streamline test data management, mask confidential data, manage data retention and destruction

– Speed application upgrades, enable safe application retirement


®

Product Overviews


11

Governing the business process of software

and systems delivery

Decades of proven processexpertise & customer success

IBM Rational softwareA strategic partner in business innovation & transformation

Go

vern

an

ce &

lif

ecy

cle

man

agem

en

t

Business flexibility

Global capability

Time to market

Risk & compliance management

Business imperativesBusiness innovation& transformation

Alignment

Control

Efficiency

Holly A Hayes

I think it is key to talk about the Rational integration strategy and value


12

Rational

ClearQuest

Creates businessprocess model

Create & manage software delivery requirements

Create architectural model enabling

the tasks from BPM to be automated

Implement new& integrate existing services

Extending Rational for Data-Driven Applications

Business Analyst

Software Architect

RequirementsAnalyst

Developer

WebSphereBusiness Modeler

RationalRequisitePro

RationalSoftware Modeler

RationalApplication Developer Rational

ClearQuest

RationalSoftware Architect

Transform Models to Code


Data Architect

Data Access Developer

Implement newprocedures and services

Link requirements to data assets

Transform between business items and data model

RationalData Architect

Create or reverse engineer logical and physical models

Transform between software and data models

Optim Test Data Manager


Extract test data from production systems


13


Rational Data Architect is a collaborative, data design solution to discover, model, relate, and standardize diverse data assets.

Key Features

Create logical and physical data models

Discover, explore, and visualize the structure of data sources

Discover or identify relationships between disparate data sources

Compare and synchronize the structure of two data sources

Analyze and enforce compliance to enterprise standards

Support heterogeneous databases

Leverage integration with the Rational Software Delivery Platform, IBM Information Server, and IBM Industry Models


14

Rational

ClearQuest







Business Analyst

Software Architect

RequirementsAnalyst

Developer





ClearQuest




Data Architect












15

IBM Data Studio Developer

Enhance developer productivity – Generate a data access layer using Java objects,

JSON, or, XML

– Drag and drop creation of Web services for any SQL, XQuery, or stored procedure

– Provide a seamless SQL/Java experience including SQL assistance, validation, execution, and analysis

– Enhance problem isolation correlating problem SQL with issuing code, even when using frameworks that generate the SQL

Provide expert-equivalent performance for Java data access – Facilitate use of JDBC and SQL data access best

practices

– Improve DB2 performance, predictability, and manageability by enabling transparent activation of static SQL (i.e. no change to the application)

IBM Data Studio Developer is an integrated database development environment that speeds application design, development, and deployment while increasing data access performance and manageability.

“IBM Data Studio enables us to bridge the gap between object-oriented design and relational database technology. As a result, we can speed the development of high quality applications and improve developer productivity by between 25 and 50 percent”


16

Deploying with pureQuery – Performance and Control

Transparent use of static SQL for new and existing DB2 applications– Make response time predictable and stable by locking in the SQL access path

pre-execution, rather than re-computing at access time– Limit user access by granting execute privileges on the packages rather than

access privileges on the table– Capture additional workload information based on package statistics to aid

forecasting accuracy and capacity planning– Drive down DB cycles to increase overall capability

Choose between dynamic or static execution at deployment time, rather than development time

"The ability to use static SQL with pureQuery is huge. Recently, I worked with a client who could reduce CPU usage by 7 percent thanks to this one feature." — David Beulke, Pragmatic Solutions Inc.


17

Data Studio pureQuery Runtime for z/OS

In-house testing shows double-digit reduction in CPU costs over dynamic JDBC

IRWW – an OLTP workload, Type 2 driver (local call)

Cache hit ratio between 70 and 85%

42% reduction in CPU per transaction over dynamic JDBC


18

Rational

ClearQuest







Business Analyst

Software Architect

RequirementsAnalyst

Developer





ClearQuest




Data Architect












19

Optim Test Data Management and Data Privacy Solutions

Create targeted, right-sized test databases–Refresh, reset, and maintain test environments – quickly and easily–Extract complete, referentially intact business objects–Compare data to pinpoint and resolve application defects faster–Accelerate release schedule

De-identify sensitive information–Substitute confidential information with fictionalized data–Protect private data in non-production environments–Provide contextual, application-aware, persistent data masking

Production or Clone

ExtractLoad

Insert / UpdateCompare

Extracted Files Mask

Masked Files

Development

Test

AnonymousAnalysis

IBM Optim Test Data Management and Data Privacy Solutions increases software quality based on test data that accurately reflects production systems while

protecting client privacy and sensitive information.

-- ---- ---- ---- ------- ------ ---- ---- ---- ------- ----

CUSTOMERS

-- -- ------ -- --------- ------ -- ------ -- --------- ------ -- ------ -- --------- ------ -- ------ -- --------- ----

ORDERS

-- ---- ---- ---- ------- ------ ---- ---- ---- ------- ------ ---- ---- ---- ------- ------ ---- ---- ---- ------- ------ ---- ---- ---- ------- ----

DETAILS


20

Administration Strategic Priorities

Give the DBA more control

– E.g. Client optimization - bind the SQL to DB2 for static execution without changing a single line of application code.

Bring the information together

– e.g. Performance warehouse plus pureQuery outline

Provide task-specific flows and context

– E.g. Data Studio Administrator guided change management

Make tools smarter

– E.g. DB2 Optimization Expert for z/OS advisors

Facilitate strategic planning

– E.g. Optim Data Growth Solutions data archival and application migration support


21

Database Administration DB2 Administration Tool DB2 Object Comparison Tool DB2 Administration Toolkit SAP Edition DB2 Storage Management Utility

Utilities Management DB2 Utilities Suite DB2 Automation Tool DB2 Automation Toolkit SAP Edition DB2 Utilities Enhancement Tool DB2 High Performance Unload

Data Governance IBM Optim Data Growth IBM Optim Data Privacy IBM Optim Test Data Management DB2 Audit Management Expert IBM Database Encryption Expert Data Encryption for DB2 and IMS

Performance Management OMEGAMON XE DB2 Performance Expert OMEGAMON XE DB2 Performance Monitor DB2 Buffer Pool Analyzer DB2 Optimization Expert DB2 Query Monitor DB2 Performance Toolkit SAP Edition

Application Management Rational Data Architect Data Studio Developer DB2 Path Checker DB2 Bind Manager DB2 SQL Performance Analyzer DB2 Table Editor

Backup and Recovery Application Recovery Tool for

IMS and DB2 Databases DB2 Archive Log Accelerator DB2 Change Accumulation Tool DB2 Cloning Tool DB2 Log Analysis Tool DB2 Object Restore Tool DB2 Recovery Expert

Business Intelligence IBM DataQuant IBM QMF DB2 Web Query Tool

Information Integration WebSphere Classic Data Event Publisher WebSphere Classic Federation Server WebSphere Classic Replication Server WebSphere DataStage WebSphere Replication Server DataMirror

DB2 for z/OS Tools Portfolio


22

Database Administration DB2 Control Center Data Studio (Administration Console) Data Studio Administrator

Utilities Management DB2 High Performance Unload

Data Governance IBM Optim Data Growth IBM Optim Data Privacy DB2 Audit Management Expert IBM Database Encryption Expert

Performance Management DB2 Performance Expert DB2 Query Patroller

Application Management Rational Data Architect Data Studio Developer IBM Optim Test Data Management DB2 Table Editor

Backup and Recovery DB2 Recovery Expert

Information Integration IBM Information Server DataMirror

DB2 for Linux, UNIX, Windows Tools Portfolio

Business Intelligence Data Warehouse Edition DB2 Web Query Tool


23

IBM Data Studio Administrator

Automates forward and reverse schema engineering between models, the database, and DDL

Synchronizes, copies, clones, or merges database schema definitions from the source to the target

Manages complex structural changes while preserving data, privileges, all dependent objects, and application binding

Integrates with Rational Data Architect for seamless transition from logical to physical design

IBM Data Studio Administrator improves DBA productivity and reduces application outages by automating and simplifying complex DB2 structural

changes.


24

Data Studio Administrator Value

Enhances DBA productivity and accelerates complex changes– Guides DBA through the process flow– Automates script development

Reduces errors and downtime– Automates dependency identification

Ensures data and process integrity – Handles data and privilege migration

Fosters teamwork and alignment– Integrates with RDA logical data model – Integrates with Rational Software Delivery Platform V7

Enhances auditability– Reporting and documentation

Holly A Hayes

Should review with Juff. I sent some suggestions to him yesterday, but this is a little elaboration.


25

DB2 Performance Expert

DB2 application monitoring

DB2 WLM monitoring

DB2 engine monitoring

OS monitoring

Partition analysis

Realtime and historical data

Dashboards and alerts

2

IBM DB2 Performance Expert provides a single point for monitoring, analysis and control of multiple DB2 instances to improve service level management.


26

DB2 Performance Expert Value

Manage to service level agreements via customized views and key performance indicators

Drill down into application and SQL detail for problem isolation

Analyze deadlocks and long running queries

Detect skews in partitions

Analyze history for trends, impact of configuration changes, and capacity planning


27

Active

HistoricalRetrieveRetrieved

Archives

Reporting Data

Historical Data

Reference Data

Archive

Optim Data Growth Solution

Freed

Addresses data growth, application retirement, data retention compliance Complete business object provides historical reference snapshot of business activity Storage device independence enables storage cost optimization Immutable file format enables data retention compliance

IBM Optim Data Growth Solution facilitates application growth, application upgrades, application retirement, and retention management.

Application Application XML ODBC / JDBC

Universal Access to Application Data


28

Database Encryption Expert

What it offers

– Encrypts online and offline data without sacrificing performance

– Limits privileged user access to sensitive data

Benefits

– Helps maintain compliance with government and industry data privacy acts (like PCI)

– Protects data from exposure in the event of a data breach

– Minimizes the security risk of data backups and replicated data being exposed if lost or stolen


29

Audit Capabilities

DB2 Audit Management Expert

– In-depth auditing of the DB2 system

– Answers who, what, when, where, how re: database objects and users

– Separates auditor and DBA roles and privileges

Tivoli Compliance InSight Manager

– End-to-end auditing spanning database, operating system, application and network

– Provides compliance dashboard for monitoring compliance posture and risk exposure

– Collects, stores, investigates and retrieves logs

– Monitors privileged users


®

Looking ForwardKey 2008 deliverables


31

Rational Data Architect 7.5

Target September

Alignment with Rational SDP 7.5

Enhanced diagramming layout

Model-driven governance

– Enables designers to specify compliance requirements at data design time and propagate to physical implementations for consistent deployment

– Extends domain model for specifying compliance attributes e.g. privacy or retention

– Populates Optim directory


32

Any Questions ?

Thank You

© 2007 ibm corporation ® tools? you want tools - we got them! alice ma -...

Documents