IBM Information Management Accelerate information on demand with

IBM Information Management Leveraging Information to Create Business Value Insightful, Relevant Information When and Where it’s Needed Information On Demand − Optimize Each Transaction − Call Centers, Field Ops OLAP & Data Mining − Merchandising, Inventory, Operations Query & Reporting − Financials, Sales 1 Help Solve Crimes by Delivering Suspect List to Detectives Arriving at the Crime Scene Optimizing Police Force Deployments Crime Rate Reports © 2007 IBM Corporation

IBM Information Management Dynamic Warehousing A New Approach to Leveraging Information On Demand to Optimize Real-Time Processes OLAP & Data Mining to Dynamic Understand Why and Warehousing Recommend Future Action Dynamic Warehousing Requires: 1. Real-time access – in context Traditional Data 2. Analytics – as part of a business process Warehousing 3. Unstructured information – extracted knowledge Query & Reporting 4. Extended infrastructure – tightly integrated to Understand What Happened 2 © 2007 IBM Corporation

IBM Information Management More Examples of Dynamic Warehousing in Action Enabling Information On Demand for Business Advantage Traditional warehousing Insurance fraud analysis and reporting Reporting on customer issues Historical sales analysis and reporting 3 Dynamic warehousing Identifying potentially fraudulent claims prior to approval and payment Transforms healthcare Identifying possible related issues, churn risk and crosssell opportunities while engaged with the customer Transforms customer service Discovering relevant customer information to identify cross sell opportunities and improve negotiating position at the point of sale Transforms sales effectiveness © 2007 IBM Corporation

IBM Information Management Why is it a challenge for organizations to leverage information effectively? Information distributed in silos across the organization Volume and variety of information increasing Velocity of business driving real-time requirements Not accurate Not complete Not trusted Not timely Increased need to aggregate and analyze information dynamically 4 © 2007 IBM Corporation

IBM Information Management Creates challenges for traditional warehousing Not just for traditional query and reporting purposes anymore Warehouses must now: § Address expanding needs for analytics and information on demand § Leverage ALL types of information, including unstructured § Serve increasing numbers and types of applications and users, with varying service level demands mixed workload environments and the constantly changing needs of different business constituents require more dynamic warehousing capabilities Increasingly 5 © 2007 IBM Corporation

IBM Information Management IBM provides more than just a warehouse DB 2 Warehouse provides extended capabilities and value Embeddable analytics (Inline and as a Service) Beyond traditional structured data Multidimensional analysis Data mining and visualization Generate and leverage knowledge from unstructured information IBM DB 2 Traditional Warehouse warehouse OLTP Benefits of a transactional data server foundation Deep compression Optimized for real-time access, High availability and reliability Scalable, secure and auditable Reduced storage costs Better disk utilization Query speed improvement Unstructured Structured DW DBMS Dedicated warehousing Shared-nothing architecture Advanced data partitioning Workload management “As a direct effect of the mixed workload, with continuous loading and the increase in automated transactions from the functional analytics in OLTP, the transactional DBMSs have an edge that challenges the DW DBMSs (such as Teradata)” 6 Gartner Data Warehouse Magic Quadrant, 2006 © 2007 IBM Corporation

IBM Information Management Dynamic warehousing Extending beyond the warehouse to enable information on demand Information integration Search and text analytics Enterprise data modeling Process management Dynamic Warehouse Industry perspective Master data management 7 © 2007 IBM Corporation

IBM Information Management How IBM Enables Dynamic Warehousing Integrated offerings to enable information on demand Search & Text Analytics Omni. Find™ Analytics Edition Enterprise Data Modeling Rational® Data Architect Information Integration Information Server IBM DB 2 Warehouse Process Mgmt File. Net BPM Web. Sphere BPM Industry Perspective IBM industry data models MDM WS Customer Center WS Product Center SOA Infrastructure IBM Global Services 8 © 2007 IBM Corporation

IBM Information Management New Capabilities and Offerings to Enable Dynamic Warehousing Announced March 13, 2007 § IBM Balanced Warehouse. TM Solutions – Multiple classes of offerings § New and Enhanced Packaging Offerings – Advanced Edition, Enhanced Base Edition § New SMB Offerings – Available from partners § Embedded Analytics – Extended insight capabilities with integrated tooling § New Offering for Unstructured Analytics – IBM Omni. Find Analytics Edition § Seamless Integration of Information Server & RDA – Integrated tooling § New and Enhanced Industry Data Models – New Health Plan and enhanced Insurance data model § New Features for Warehousing on System z – Query & reporting feature enhancement and performance improvements § New Services Offerings – GBS strategic planning & design and GTS implementation assistance 9 © 2007 IBM Corporation

IBM Information Management Business Advantage through Information on Demand Faster access to information improves business performance Challenge Company profile § Integrate disparate data sources to support more accurate store and product performance analysis § A leading specialty retailer of children’s clothing § Speed responsiveness to changing business conditions and better understand store and product performance information Business benefits Key to success § An integrated end-to-end retail warehousing solution with pre-existing industry models and embedded analytics that could generate insight into all aspects of the core business 10 § Drastically reduced model development time and decreased query time from days to just seconds, helping speed responsiveness to variable business conditions § Ability to address customer needs and behavior analyses, fraud detection, and store location and merchandising optimization through a single platform © 2007 IBM Corporation

IBM Information Management Business Advantage through Information on Demand Visibility into relevant information improves customer service and sales Challenge § Consolidate claims transactions— from several thousand providers with structured and unstructured data distributed across multiple systems—into a single data warehouse instance § Develop a centralized view of medical provider information— including unstructured data—to improve terms negotiation leverage Key to success § In-context delivery of knowledge from structured and unstructured information distributed across the organization and beyond 11 Company profile § An independent, not-for-profit health benefits company serving more than five million people Business benefits § Single view into all “revenue” for a provider across multiple programs, identification of provider requests for new facilities and access to existing contracts during negotiations § Categorization and understanding of customer service issues and access to provider demographic and service offerings for improved support © 2007 IBM Corporation