Integrated Data Management Product Strategy and Vision

1. Integrated Data Management Product Strategy and Vision Curt Cotner IBM Fellow Vice President and CTO for IBM Database Servers cotner@us.ibm.com

2. Disclaimer • © Copyright IBM Corporation 2009. All rights reserved. • U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. • THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY.  WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON IBM’S CURRENT PRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUT NOTICE.  IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR REPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR SOFTWARE. • IBM, the IBM logo, ibm.com, and DB2 are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml • Other company, product, or service names may be trademarks or service marks of others.

3. Develop Design Optimize Operate Govern Deploy Embarcadero ER/Studio IBM InfoSphere Data Architect Quest Spotlight Oracle Tuning Pack Sybase PowerDesigner IBM Optim Data Growth Solution CA ERwin IBM Data Studio Developer Guardium Quest InTrust Solix EDMS Oracle JDeveloper IBM Optim Quest TOAD Embarcadero Rapid SQL Quest Central IBM Comparison Tool for DB2 z/OS Oracle Vault Data Studio Administrator Oracle DiagnosticPack BMC Patrol EmbarcaderoChange Manager IBM DB2 tools Oracle Change Management Pack What do Businesses Have?A Collection of Disparate, Single-Purpose Products

4. The gaps create risk … • Loss of customers • Average customer churn rate up 2.5% after a breach • Loss of revenue • $197 USD per customer record leaked • Average cost was ~ $6.3 million / breach in this study • Average cost for financial services organizations was 17% higher than average • Fines, penalties or inability to conduct business based on non-compliance • PCI • Sarbanes-Oxley (SOX)‏ • HIPAA • Data Breach Disclosure Laws • Gramm-Leach-Bliley Act • Basel II Source: “2007 Annual Study: Cost of a Data Breach” , The Ponemon Institute

5. Driven by the increasing numbers of physical systems, system managementhas become the main component of IT costs and is growing rapidly Many Servers, Much Capacity, Low Utilization =$140B unutilized server assets

6. What do Businesses Need?An integrated environment to span today’s flexible roles • Manage data throughout its lifecycle • From design to sunset • Manage data across complex IT environments • Multiple interrelated databases, applications and platforms • Facilitate cross-functional collaboration • Within IT • Among Line of Business, Compliance functions • Across disparate skill sets • Optimize business value • Respond quickly to emerging opportunities • Improve quality of service • Reduce cost of ownership • Mitigate risk

7. Integrated Data Management – What’s Different? DBAs Testers Application Manager AppDev Data Architect • Produce enterprise-ready applications faster • Improve data access, speed iterative testing and empower collaboration across the lifecycle • Consistently achieve service level targets • Automate and simplify operations with contextual intelligence across the solution stack • Support business growth • Accommodate new initiatives without expanding infrastructure • Simplify application upgrades, consolidation and retirement • Facilitate alignment, consistency and governance • Upfront business policies and standards; share, extend, and apply throughout the lifecycle

8. Design Develop Optimize Govern Policies Models Metadata Deploy Operate The broadest range of capabilities for managing the value of your data throughout its lifetime InfoSphere Data Architect InfoSphere Discovery Optim Development Studio Optim Data Growth Solutions Optim Test Data Management Optim Query Tuner (a.k.a. Optimization Expert) DB2 Optim Data Privacy Solutions DB2 Performance Expert and Extended Insight Feature Optim pureQuery Runtime Optim Database Administrator Guardium DB2 Audit Management Expert Database Encryption Expert

9. 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 across heterogeneous databases • Integration with the Rational Software Delivery Platform, Optim, IBM Information Server, and IBM Industry Models InfoSphere Data Architect InfoSphere Data Architect is a collaborative, data design solution to discover, model, relate, and standardize diverse data assets.

10. Automate Data Design via Model-driven Transformation Rational Software Architect • Built-in transformation • Compare and sync facilitates merge SOLUTION ARCHITECT UML Optim Database Administrator WebSphere Business Modeler InfoSphere Data Architect XSD PDM INTEGRATION DEVELOPER DATA ARCHITECT DATABASE ADMINISTRATOR

11. Streamline building test databases, improve application quality, cut IT costs and accelerate solution delivery Optim Optim Test Data Management Solution • Accelerate time to market • Create “right sized” test databases • Extract referentially intact subsets • Compare baseline data against test results to pinpoint and resolve application defects faster • Edit test data to create error and boundary conditions • Easily refresh, reset and maintain test environments • Cut storage costs • Reduce storage requirements by using smaller subsets for testing • Enable compliance • De-identify or mask data Production or Clone Extract Dev QA Test

12. Data is masked with realistic but fictional information Enterprise Challenge: Data PrivacyOptim Data Privacy Solution • Application-aware masking capabilities ensure data is realistic but fictional • Prepackaged data masking routines make it easy to de-identify elements • E.g. credit card numbers & email addresses

13. Provision fictionalized test data Define privacy policies Analyse use of sensitive data Data Architect Tester Developer Aligning Around Data Privacy • Define policies once and reuse • Flow definitions to team members • Drive consistent practices around privacy

14. Retrieved Universal Access to Application Data Optim Data Growth Solution • Complete business object provides historical reference snapshot of business activity • Storage device independence enables storage cost optimization • Immutable file format enables data retention compliance 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

15. Guardium -- Non-invasive, real-time monitoring SQL Server • Non-invasive architecture • Outside database • Minimal performance impact • No DBMS or application changes • Cross-DBMS solution • 100% visibility including local DBA access • Enforces separation of duties • Does not rely on DBMS-resident logs that can be erased by attackers, rogue insiders • Granular, real-time policies & auditing • Who, what, when, how • Automated compliance reporting, sign-offs & escalations (SOX, PCI, NIST, etc.) 15 DB2

16. Managing the entire lifecycle of security, risk, compliance 16

17. Design Develop Optimize Govern Models Policies Metadata Deploy Operate Deploy without DisruptionOptim Database Administrator • Enhance DBA productivity and accelerate complex changes while ensuring data and process integrity • Automatically manages dependent objects • Saves and restores data for extended alters • Generates needed maintenance commands • Reduce errors and downtime • Provides impact analysis visualization • Factors in impacts and side effects automatically • Automatically generates commands to undo changes • Foster teamwork and enhance auditability • Integrated into Rational Software Delivery Platform • Document changes for collaboration and audit Deploy Install, configure, change, promote DatabaseAdministrator

18. Optim Database Administrator Improves DBA productivity and reduces application outages by automating and simplifying complex DB2 structural changes including change-in-place as well as database migration scenarios. • Models, automates and deploys complex schema changes • Identifies dependencies and analyzes impact to mitigate deployment risk • Preserves data, dependent objects, privileges, and application binding • Synchronizes, copies, clones, or merges database schema definitions from the source to the target • Documents changes for collaboration and audit • Enables undo or restart -- if needed • Manages common database maintenance tasks

19. Data & Object Movement • Value Proposition – • Copying database objects and data between homogeneous and heterogeneous databases within Optim Development Studio and Optim Database Administrator • Key Features • Copy objects at various levels – complete databases to a fixed number of rows from a single table • Action performed in Data Source Explorer – Copy/Paste and Drag/Drop • Can automatically copy rows from related tables using: • RI in database • Data Architect model • Optim application models • Optim Discovery • Can optionally annonymize the rows using Optim Test Database Manager

20. Optim Performance Manager - Overview dashboard Enlarge ( Shows average and max values in the selected timeframe ) Open details ( shows timeseries in the selected timeframe ) • Focus on specific database to see key performance indicators

21. Optim Performance Manager - Active SQL dashboard Show top running statements at a point in time according to selected metric, e.g. Elapsed time. “Tune” launches Query Tuner “Identify Workloads” refers to defined workloads in Extended Insight

22. Optim Performance Manager – Reporting • Reporting • ... gives you the flexibility you need to adapt OPM on your own environment • coming with sample reports for - disk space usage - system configuration - top resource using SQL statements - DB connections • easy to modify and adapt to your environment because report definition stored in XML document • can be saved and shared as PDF with your colleagues • a graphical report builder will also follow soon

23. Optim Query TunerandOption Workload Tuner for z/OS

24. Optim Query Tuner Key Features at a Glance Query Tuner User Interface Eclipse Workload Advisors Query Based Tools and Advisors Capture Workload Environ Workload Report Query Tools Query Advisors Formatter Annotation Capture Query Environ. Query Advisor Index Advisor Workload Statistics Advisor Workload Index Advisor Workload Query Advisor Access Path Graph Query Report Visual Plan Hint Statistics Advisor Access Path Advisor ProfileMonitor Workload Control Center Database

25. IBM Optim Query Tuner key functions

26. Understanding Query with Query Annotation Original and transformed Query Formatted, reorganized query text Annotations (catalog stats, cost estimation)

27. VISUAL PLAN HINT

28. Provide hints for AccessType

29. ACCESS PLAN GRAPH (APG)The Access Plan Graph screen displays the access path on the right, and relevant statistics on the left.

30. Query Advisor Predicate that should be considered for re-write to get better performance Re-write advice and details

31. Access Path Advisor

32. STATISTICS ADVISOR

33. Index Advisor Index Recommendations DDL to create the new index statement

34. Database Support by Product (as of today) DB2 for z/OS DB2 for LUW DB2 for i IDS Oracle SQL Server Sybase MySQL Data Studio a a a a alphaworks derivative Data Studio Administration Console a a OpenAdmin Tool InfoSphere Data Architect a a a a a a a a Optim Development Studio a a a a a Optim pureQuery Runtime a a a a a Optim Query Tuner a + Workload a Optim Database Administrator DB2 Admin Tool/Object Compare a Optim Test Data Management a a a a a a a Optim Data Privacy a a a a a a a Optim Data Growth a a a a a a a Optim Performance Manager Omegamon a OPM Extended Edition a Database Encryption Expert EE for DB2 and IMS a a Vormetrics Vormetrics Vormetrics

35. IBM Data Studio • www.ibm.com/software/data/studio • FAQs / Tutorials • Downloads • Forum / Blogs • Join the IBM Data Studio user community • Data Studio Book • http://bit.ly/dstudiobook NEW!!!