1 / 32

TOOLS? You want Tools - We got them!

TOOLS? You want Tools - We got them!. Alice Ma - ama@us.ibm.com Data Studio Enabling Architect PE, HPU & DSA. Agenda. Business Needs Integrated Data Management Pain points Segment strategy Product Overviews Features, Roles, Value Looking Forward Key YE deliveries Summary.

easter
Download Presentation

TOOLS? You want Tools - We got them!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TOOLS? You want Tools - We got them! Alice Ma - ama@us.ibm.com Data Studio Enabling Architect PE, HPU & DSA

  2. Agenda • Business Needs • Integrated Data Management • Pain points • Segment strategy • Product Overviews • Features, Roles, Value • Looking Forward • Key YE deliveries • Summary

  3. A Collection of Disparate, Single-Purpose Products What do Businesses Have? CA ERwin Design IBM Rational Data Architect Quest TOAD Develop Oracle JDeveloper Embarcadero ER/Studio IBM Data Studio Developer Sybase PowerDesigner Embarcadero Rapid SQL Optimize Sybase PowerBuilder Microsoft Visual Studio Oracle Partitioning Deploy IBM Optim Data Growth Solution IBM Rational ClearCase Solix EDMS Quest InTrust Govern IBM Optim Operate CA administration tools Quest Central Oracle Database Management Packs Embarcadero DBArtisan IBM DB2 tools

  4. Integrated Data Management Vision 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 • 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

  5. Managing the value of your data throughout its lifetime…from requirement to retirement Discover Model Relate TuneArchive Evolve Create Test Tune Monitor Diagnose Administer InstallConfigureChange ProtectRetainAudit

  6. Supporting Enterprise Environments Design, Development, Deployment, Operations, Optimization, Governance IBM Integrated Data Management

  7. Data Steward Enabling Collaboration and Alignment Across Roles Tivoli Service Management Platform Rational Software Delivery Platform Data Modeling Database Development Database Administration Application Development Logical Modeling Physical Modeling Integration Modeling Data Access: Java objects Web services Web 2.0 Stored Procedures SQL XQuery User Defined Functions Configuration Performance Management Change Management Availability Management Business Analyst Enterprise Architect Systems Administrator Network Administrator Compliance Administrator Application Developer Data Architect Database Administrator Database Developer Security and Privacy Management Archive and Retention Management Auditing Data Governance

  8. The broadest range of capabilities for managing the value of your data throughout its lifetime Rational Data Architect Data Studio Developer Optim Data Growth Solutions Optim Test Data Management DB2 Performance Expert Data Studio pureQuery Runtime z/OS Tools Portfolio Data Studio Administrator DB2 Audit Management Expert Database Encryption Expert Optim Data Privacy Solutions

  9. Integrated Data Management Today - Powerful Capabilities • Rational Data Architect • 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

  10. Product Overviews

  11. IBM Rational softwareA strategic partner in business innovation & transformation Business imperatives Business innovation& transformation • Global capability Governing the business process of software and systems delivery • Alignment • Control • Efficiency • Business flexibility Governance & lifecycle management • Time to market • Risk & compliance management Decades of proven processexpertise & customer success

  12. Business Analyst RequirementsAnalyst Data Architect Data Access Developer Database Administrator Software Architect Developer Extending Rational for Data-Driven Applications Creates businessprocess model WebSphereBusiness Modeler Transform between business items and data model Create & manage software delivery requirements Link requirements to data assets RationalRequisitePro Create architectural model enablingthe tasks from BPM to be automated RationalSoftware Modeler Transform between software and data models Create or reverse engineer logical and physical models Transform Models to Code RationalSoftware Architect RationalData Architect Implement new& integrate existing services Implement newprocedures and services RationalApplication Developer Data Studio Developer Rational ClearQuest Extract test data from production systems Rational ClearQuest Optim Test Data Manager

  13. 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 Rational Data Architect Rational Data Architect is a collaborative, data design solution to discover, model, relate, and standardize diverse data assets.

  14. Business Analyst RequirementsAnalyst Data Architect Data Access Developer Database Administrator Software Architect Developer Extending Rational for Data-Driven Applications Creates businessprocess model WebSphereBusiness Modeler Transform between business items and data model Create & manage software delivery requirements Link requirements to data assets RationalRequisitePro Create architectural model enablingthe tasks from BPM to be automated RationalSoftware Modeler Transform between software and data models Create or reverse engineer logical and physical models Transform Models to Code RationalSoftware Architect RationalData Architect Implement new& integrate existing services Implement newprocedures and services RationalApplication Developer Data Studio Developer Rational ClearQuest Extract test data from production systems Rational ClearQuest Optim Test Data Manager

  15. IBM Data Studio Developer IBM Data Studio Developer is an integrated database development environment that speeds application design, development, and deployment while increasing data access performance and manageability. • 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 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. Business Analyst RequirementsAnalyst Data Architect Data Access Developer Database Administrator Software Architect Developer Extending Rational for Data-Driven Applications Creates businessprocess model WebSphereBusiness Modeler Transform between business items and data model Create & manage software delivery requirements Link requirements to data assets RationalRequisitePro Create architectural model enablingthe tasks from BPM to be automated RationalSoftware Modeler Transform between software and data models Create or reverse engineer logical and physical models Transform Models to Code RationalSoftware Architect RationalData Architect Implement new& integrate existing services Implement newprocedures and services RationalApplication Developer Data Studio Developer Rational ClearQuest Extract test data from production systems Rational ClearQuest Optim Test Data Manager

  19. 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 CUSTOMERS -- ---- ---- ---- ------- ------ ---- ---- ---- ------- ---- Extracted Files Masked Files ORDERS -- -- ------ -- --------- ------ -- ------ -- --------- ------ -- ------ -- --------- ------ -- ------ -- --------- ---- Mask Extract DETAILS -- ---- ---- ---- ------- ------ ---- ---- ---- ------- ------ ---- ---- ---- ------- ------ ---- ---- ---- ------- ------ ---- ---- ---- ------- ---- Optim Test Data Management and Data Privacy Solutions 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. Production or Clone Load Insert / Update Compare Development Test AnonymousAnalysis

  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. DB2 for z/OS Tools Portfolio Application Management • Rational Data Architect • Data Studio Developer • DB2 Path Checker • DB2 Bind Manager • DB2 SQL Performance Analyzer • DB2 Table Editor Database Administration • DB2 Administration Tool • DB2 Object Comparison Tool • DB2 Administration Toolkit SAP Edition • DB2 Storage Management Utility Backup and Recovery • Application Recovery Tool forIMS 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 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 Utilities Management • DB2 Utilities Suite • DB2 Automation Tool • DB2 Automation Toolkit SAP Edition • DB2 Utilities Enhancement Tool • DB2 High Performance Unload Information Integration • WebSphere Classic Data Event Publisher • WebSphere Classic Federation Server • WebSphere Classic Replication Server • WebSphere DataStage • WebSphere Replication Server • DataMirror • 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 Business Intelligence • IBM DataQuant • IBM QMF • DB2 Web Query Tool

  22. DB2 for Linux, UNIX, Windows Tools Portfolio Application Management • Rational Data Architect • Data Studio Developer • IBM Optim Test Data Management • DB2 Table Editor Database Administration • DB2 Control Center • Data Studio (Administration Console) • Data Studio Administrator Backup and Recovery • DB2 Recovery Expert Performance Management • DB2 Performance Expert • DB2 Query Patroller Utilities Management • DB2 High Performance Unload • Data Governance • IBM Optim Data Growth • IBM Optim Data Privacy • DB2 Audit Management Expert • IBM Database Encryption Expert Business Intelligence • Data Warehouse Edition • DB2 Web Query Tool Information Integration • IBM Information Server • DataMirror

  23. IBM Data Studio Administrator IBM Data Studio Administrator improves DBA productivity and reduces application outages by automating and simplifying complex DB2 structural changes. • 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

  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

  25. DB2 Performance Expert IBM DB2 Performance Expert provides a single point for monitoring, analysis and control of multiple DB2 instances to improve service level management. • DB2 application monitoring • DB2 WLM monitoring • DB2 engine monitoring • OS monitoring • Partition analysis • Realtime and historical data • Dashboards and alerts 2

  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. Retrieved Universal Access to Application Data Optim Data Growth Solution IBM Optim Data Growth Solution facilitates application growth, application upgrades, application retirement, and retention management. Archives Archive Freed Historical Data Reference Data Historical Retrieve Reporting Data Active Application Application XML ODBC / JDBC • 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

  28. 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 Database Encryption Expert

  29. 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 Audit Capabilities

  30. 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

More Related