IBM Software Group DB 2 Data Warehouse Edition

® IBM Software Group DB 2 Data. Warehouse Edition Patrick SARFATY Channel Technical Sales IBM Software psarfaty@fr. ibm. com © IBM Corporation

IBM Software Group Information as a Service Moving From a Project-Based to a Flexible Architecture (SOA) Tools & Applications Dashboards Insight In-line, Real-time Insightful Relationships Standards based: e. g. , XQuery, JSR 170, JDBC, Web Services. . . Metadata Management Data & Content Business Context Information as a Service Real Time : e. g. , On Line Help, Synchronized Master Data… Extracted: e. g. Basel II, Business Optimization… Heterogeneous Applications & Information DB 2 abc… IBM Content Manager xyz… Oracle and more…

IBM Software Group IBM Information Management Software Delivering Value Beyond Traditional Repositories Information Delivered on Demand Based on Services Oriented Architecture § Data Services 4 DB 2, IDS, IMS, Cloudscape, U 2 § Content Services 4 Content Management Services 4 Content Integration Services § Information Integration Services 4 4 Federation Services Movement Services Transformation Services Quality Services… § Information Accelerators 4 4 4 Master Data Management Entity Analytics Information Warehousing Customizable Dashboards Industry Data Models

IBM Software Group What Is DB 2 Data Warehouse Edition? § An integrated platform for DB 2 warehouse-based analytics § All the infrastructure and tools to build analytic structures for data mining and OLAP in the warehouse -- and to develop web-based applications with embedded analytics § A vehicle to remove cost and complexity as barriers to enterprise analytics § The foundation for Information On Demand

IBM Software Group DWE v 9 Conceptual Architecture Solution Templates (Banking, Retail) § Integrated platform for warehouse-based analytics Design Studio (Eclipse) § Componentized architecture Admin Console (Web) § Shared Tooling & Metadata § Shared Run-time Infrastructure Warehousing Mining § Web-based embedded analytics Tool § Integrated Data Modeling, OLAP, OLAP In Line Analytics Data Mining, Warehousing Tool BI Infrastructure (Websphere App Server) DB 2 UDB for Linux, Unix and Windows

IBM Software Group Shared Eclipse-based BI Design Studio Control Flow SQL Generated From Data Flow Data Warehouse Project Enterprise Schema Data Flow

IBM Software Group DWE Design Studio - Overview SQL Tools (debug, deploy, etc. . . ) SQL Control. Flow Editor SQL Dataflow Editor Mining Tools (Visualization, models mgt. Deployment & code gen. ) Data Mining Editor Common operators Data Flow Editor Framework Data Exploration Tools OLAP Tools Rational Data Architect SQLModel 2, Server explorer, project explorer, physical DB model Eclipse Alpha. Blox Tools

IBM Software Group Analyze Model Cleanse Transform Rational Data Architect functions in DWE Discover, model, visualize, relate, and develop diverse and distributed data assets with one tool Eclipse based framework, common models for integration across the lifecycle DWE includes RDA plug-ins for physical data modeling Reverse engineer Navigation Discovery Visualization Physical Design Rules and Model Validation Data Architect Lifecycle management Compare and Sync Impact Analysis Data Admin Developer Edit Execute Debug Deploy Team Integration

IBM Software Group DWE Administration Console § Customer Needs 4 Integrated web based administration for all warehousing functions § Value Proposition 4 Single point of administration to reduce Warehousing TCO § Brand new in DWE 9. 1 4 Admin Console for RDAbased data modeling, SQL Warehousing, OLAP, data mining 4 Role based security 4 Leverage Web. Sphere Application Server

IBM Software Group OLAP in DWE Design Studio § Design Studio 4 Model and design cube views and MQTs – all of the function currently in OLAP Center 4 SQW data flows populate user-maintained MQTs or underlying star § Server explorer: 4 Show multidimensional objects in CV catalog tables § Project explorer 4 Define CV objects and forward engineer (create DDL script which loads CV XML metadata into CV catalog tables

IBM Software Group Data Mining in DWE Design Studio § The Data Mining editor extends the common Data. Flow framework to design and interactively test visual mining flows § § 4 Mining specific operators to build/test/use mining models 4 Highly interactive with the warehouse 4 Can generate SQL, java beans, data flows A subset of the mining operators can be embedded in the SQL Warehousing Tool editor as well Data exploration tools based on the mining tools, to display the statistics and distribution of the data

IBM Software Group Seamless integration of data modeling, SQL, mining in a common Data Warehouse project Data exploration components give you an overview on the content and quality of your data. DWE Design Studio Mining Editor from Design Interactive flow editor: Stepwise execution All SQL operators can be reused in the mining context to embedded applications

IBM Software Group Mining Scenario: prep, model, extract, visualize and score

IBM Software Group IBM Layered Data Architecture Business Access Layer Performance Layer Views providing business access to application neutral data model Analytic structures for OLAP and Auxiliary Data Structures, such as MQTs, Mining, MQTs Specific and Aggregates Indices, Application Tables SQW Application Neutral Data Model, near 3 rd NF, EII and EAI ETL Data Assets Layer

IBM Software Group Warehouse Building with DWE § Warehouse Administrators can: 1. Use visual modeling tool to optimize design of multilayered warehouse schema 2. Use their preferred ETL to bulk-load the Data Assets layer of warehouse -- with scale, speed and rich transformations from myriad enterprise data sources 3. Use SQW to maintain analytic structures in the Performance and Business Access layers – or to replace hand-coded SQL flows anywhere inside the warehouse Rational Data Architect Data. Stage or ISV ETL SQL Warehousing Tool

IBM Software Group DWE Design Studio – SQL Warehousing Tool SQL Operator palette Design Project DB source/target design (RDA) Production server view Property SQL Operator Connect to Data. Stage Server

IBM Software Group DWE with Data. Stage: Integration points Import Data. Stage Job as opaque Runtime object Export SQL to Data. Stage as CMD Operator Design Studio Control Flow Editor Meta. Data (EMF) Code. Gen/Optimizer FTP SQL DF DS Job Email Verify Run Time Websphere Data Flow Editor Extract SQL Join SQL DS Lookup subflow Application Server Data. Stage Server DB 2 Import Data. Stage Job as visual Subflow DWE Admin Console

IBM Software Group DB 2 Alphablox For end-users: § A web application, portal or dashboard with embedded analytics in an easy-to-use interactive interface For application developers: § A J 2 EE application for analysisoriented interaction § A set of analytic-focused extensions to the application server Alphablox within DWE: § New v 8. 4 § SQL generated by DWE Design Studio can be pasted into Alphablox pages for warehouse-based embedded analytics

IBM Software Group Summary and Wrap Up Questions?