Insert Picture Here Oracle Data Warehouse Strategic Update

<Insert Picture Here> Oracle Data Warehouse Strategic Update Ray Roccaforte

Oracle World 2010 Oracle Data Warehouse Strategic Update Ray Roccaforte Vice President, Data Warehouse and Analytic Technology

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Four Pillars of Oracle’s DW Strategy • • Oracle as a Systems Provider: Database Machine Maximum Leverage of Massive Hardware Capabilities Embedded Analytics Oracle as a DW Solutions Provider: • Exadata Intelligent Warehouse for Industries

Four Pillars of Oracle’s DW Strategy ØOracle as a Systems Provider: Database Machine • Maximum Leverage of Massive Hardware Capabilities • Embedded Analytics • Oracle as a DW Solutions Provider: • Exadata Intelligent Warehouse for Industries

Sun Oracle Database Machine • Database Machine eliminates the complexity of deploying database systems • Balanced configuration • Extreme performance and integrated analytics out of the box • Deploys in days rather than months • Pre-built, tested, standard, supportable configuration • Includes Hardware Installation & Site Planning • Software Configuration 6

Exadata Hardware Architecture Scaleable Grid of industry standard servers for Compute and Storage Database Grid • 8 compute servers (1 U) Storage Grid • 14 storage servers (2 U) • 100 TB High Speed disk, or 336 TB High Capacity disk Infini. Band Network • Redundant 40 Gb/s switches • Unified server & storage net © 2010 Oracle Corporation • 5 TB PCI Flash • Data mirrored across storage servers 7

New Exadata X 2 -8 • Full Rack Database Machine for large deployments • Consolidation, or Large OLTP and DW workloads • Complements existing X 2 -2 • 2 8 -socket Intel EX servers (Sun Fire X 4800) • Doubles Database CPU cores to 128 • Quadruples Database Memory to 2 TB • Oracle Solaris or Oracle Enterprise Linux • 10 GB Ethernet connectivity to Data Center • Same 14 storage servers, and Infini. Band Network • New Intel 6 -core CPUs in Storage Servers © 2010 Oracle Corporation 8

Four Pillars of Oracle’s DW Strategy • Oracle as a Systems Provider: Database Machine ØMaximum Leverage of Massive Hardware Capabilities • Embedded Analytics • Oracle as a DW Solutions Provider: • Exadata Intelligent Warehouse for Industries

Exadata Hybrid Columnar Compression • Data is grouped by column and then compressed • Query Mode for data warehousing • Optimized for speed • 10 X compression typical • Scans improve proportionally • Archival Mode for infrequently accessed data • Optimized to reduce space • 15 X compression is typical • Up to 50 X for some data 10 10

Sun Oracle Database Machine: Faster raw scans • Sun Oracle Database Machine provides semiconductor cache hierarchy Database DRAM Cache 400 GB raw capacity – up to 4 TB user data 100 GB/sec Exadata Smart Flash Cache 5 TB raw capacity – up to 50 TB user data 50 GB/sec Exadata disks 100 TB raw disk capacity 21 GB/sec 11

In-Memory Parallel Execution • Parallel query processing across tables which are cached in memory • How it works: • Oracle determines appropriate tables for caching • Tables are distributed across the buffer cache in all nodes • During queries, each node reads its local portion of the table • Full parallel bandwidth accessing data in memory • Not every database objects in a query must be in memory to leverage in-memory access 12 12

Exadata Flash Cache Frequently Used Data Infrequently Used Data • Exadata has 5 TB of Flash: 56 Flash Cards avoid disk controller bottlenecks • Automatically caches frequently-accessed ‘hot’ data in flash storage • Intelligently manages Flash: Gives speed of Flash at cost of disk • Exadata Flash Cache achieves: Over 1 million IO/sec from SQL (8 K), Submillisecond response times with 50 GB/sec query throughput

Scanning from Disk: Exadata Smart Scan • Exadata storage servers implement data intensive processing in storage • • Row filtering based on “where” predicate Column filtering Join filtering Incremental backup filtering Scans on Hybrid Columnar Compressed data Scans on encrypted data Data Mining model scoring • 10 x reduction in data sent to DB servers is common • No application changes needed • • 14 Processing is automatic and transparent Even if cell or disk fails during a query 14

Four Pillars of Oracle’s DW Strategy • Oracle as a Systems Provider: Database Machine • Maximum Leverage of Massive Hardware Capabilities ØEmbedded Analytics • Oracle as a DW Solutions Provider: • Exadata Intelligent Warehouse for Industries

Oracle In-Database Analytics • Analytics evaluated “close” to the data • Integrated • Secure Oracle OLAP: Analyze & Summarize • Smarter, Faster BI • Improved Developer Productivity • Embedded and Integrated Oracle Data Mining: Uncover & Predict • Advanced Predictive Analytics • Advanced Algorithms • Embedded and Integrated

In-Database Data Mining Exadata Smart Scan • Model scoring performed in the Exadata Storage Server • Dramatic (2 -5 X) performance improvements SELECT cust_id from customers WHERE region = ‘US’ AND prediction_probability(churnmod, ‘Y’, using *) > 0. 8;

Exadata Integration with SAS • Score SAS Models in Exadata • Import SAS models (via PMML) to Oracle Data Mining + • Logistic and Multiple Regression models available today • High-performance scoring in Exadata • Score directly against database tables • Model scoring is executed in storage tier using native Oracle DM capabilities

Oracle OLAP • Rapid Development of rich dimensional analytics • Enhances the analytic content of Business intelligence application • Excellent query performance for ad-hoc / unpredictable query • Fast, incremental updates of data sets • Embedded in the Oracle database instance and storage. • Safe, secure and manageable • Benefits from and enhances Exadata architecture • Automatically gets full benefit of Database Machine Flash Cache • OLAP query I/O tends to be high volume, random reads

Oracle OLAP 11 g Rich Calculations Delivered to SQL-Based BI Tools

OLAP MDX driver from Simba for MS Excel 2003 Excel 2010 Excel MDX Query MDX Parser MDX Provider Engine SQL Generator SQL Query of Cube © 2009 Oracle Corporation MDX Provider for Oracle OLAP

Four Pillars of Oracle’s DW Strategy • Oracle as a Systems Provider: Database Machine • Maximum Leverage of Massive Hardware Capabilities • Embedded Analytics ØOracle as a DW Solutions Provider: • Exadata Intelligent Warehouse for Industries

Exadata Intelligent Warehouse for Industries A Complete Data Warehouse Solution for Industries • Intelligence – Industry-specific data models – Packaged advanced analytics • . . . with Extreme Performance – Improve query performance 10 -100 x with Exadata • … at a Lower Cost – Simplify your infrastructure • … for Fast Results – Jumpstart development - deliver value quickly – Automatically exploit Oracle performance and analytic capabilities

Exadata Intelligent Warehouse Solution for Industries Packaged Experience and Technology Business Insight Extreme Performance Fast Time-to-Value • Leverage enterprise-wide data model for industries • Gain insights using prepackaged advanced analytics • Improve query performance 10 -100 x • Grow solution to virtually any scale • Jumpstart development and deliver value quickly • Lower risks

Exadata Intelligent Warehouse for Retail Packaged Experience and Technology Business Insight Extreme Performance Fast Results • Leverage enterprise data model for retail • Gain insights using prepackaged advanced analytics • Improve query performance 10 -100 x • Grow solution to virtually any scale • Jumpstart development and deliver value quickly • Lower risks Copyright © 2010, Oracle and / or its affiliates. All rights reserved.

Challenges We’re Hearing from Retailers Reduce Stock-outs Improve Margins With Localized Assortments Increase Share of Wallet Improve In-store Execution • Forecast demand inventory levels for better in-stock positions • Apply business intelligence behind every planning decision • Differentiate store assortments by customer profile of store locations • Unlock trends hidden in transaction data • Provide the right products all the time • Determine customer segments • Perform Market Basket analysis • Target promotions to enhance loyalty • Track key metrics for efficient store management • Optimize store staffing levels • Monitor shelf availability

Exadata Intelligent Warehouse for Retail Consolidated View of the Entire Business Sell Side • POS • Order Mgmt • Workforce Scheduling Buy Side Oracle Retail Data Model Inside • HR • Finance • Sales Forecasting • PO Mgmt • Warehouse • Pricing • Costing Outside • Partners • Suppliers • Distributors 1200+ Industry-specific Measures & KPIs

Interactive Dashboards and Reports Empowering End Users Example Analytics: Retail Anticipate out-of-stock using statistical forecasts Analyze comparative store performance over time Understand effectiveness of promotions by store Copyright © 2010, Oracle and / or its affiliates. All rights reserved. Analyze store traffic and shopper conversion rates by time of day Associate products using a market basket analysis 29

<Insert Picture Here> Exadata Intelligent Warehouse for Communications Same idea, but specific to Communications industry

Interactive Dashboards and Reports Empowering End Users Example Analyses: Communications Identify customers that are likely to churn Compare billed and actual CDRs to identify billing errors Copyright © 2010, Oracle and / or its affiliates. All rights reserved. Monitor dropped call rate over time to detect failing network elements Analyze sales growth over time by product and organization 31

Exadata Intelligent Warehouse Packaged Experience and Technology Business Insight Extreme Performance Fast Results • Leverage enterprise data model for Industries • Gain insights using prepackaged advanced analytics • Improve query performance 10 -100 x • Grow solution to virtually any scale • Jumpstart development and deliver value quickly • Lower risks Copyright © 2010, Oracle and / or its affiliates. All rights reserved.

Exadata Intelligent Warehouse Packaged Experience and Technology Business Insight Extreme Performance Fast Results • Leverage enterprise data model for Industries • Gain insights using prepackaged advanced analytics • Improve query performance 10 -100 x • Grow solution to virtually any scale • Jumpstart development and deliver value quickly • Lower risks Copyright © 2010, Oracle and / or its affiliates. All rights reserved.

Custom Solutions Key Implementation Tasks • Assemble Hardware • Install Specialized Software Design Data Model • Requirements Collection • ERD Specification Assemble & Configure System • Define tables, views, cubes, analytics • Implement indexes, partitions Implement Data Model Tune Performance • Ensure system is balanced • Modify performance structures (MVs, indexes, etc. ) • Create BI metadata • Implement reports and dashboards Define Metrics & Reports Challenges: • Design a data model that satisfies existing and future requirements • Employ a diverse skill set • Integrate, implement, administer and tune disparate technologies

Exadata Intelligent Warehouse Best Practice Implementation ASSEMBLED DESIGNED IMPLEMENTED FAST READY Sun Oracle Database Machine Oracle Retail Data Model Oracle Best Practice DW Methodology Sun Oracle Database Machine Oracle OBIEE Complete. Fast Results. Lower Risk. Benefits: • Utilize an enterprise data model for retail • Leverage your existing Oracle expertise • Implemented using Oracle data warehousing best practices

Fast Results Retail Performance Metrics and Insight out of the box Build from Scratch with Best of Breed Approach Oracle Exadata Intelligent Warehouse Training & Roll-out Define Metrics & Dashboards Data Integration Training & Roll-out Analysis and Design Define Metrics & Dashboards Data Integration Analysis and Design Sizing and Configuration months or years weeks or months Speed to Value, Simplified Deployment with predictable cost

Exadata Intelligent Warehouse Solution for Industries Packaged Experience and Technology Business Insight Extreme Performance Fast Time-to-Value

Summary: Oracle’s DW Strategy • • Oracle as a Systems Provider: Database Machine Maximum Leverage of Massive Hardware Capabilities Embedded Analytics Oracle as a DW Solutions Provider: • Exadata Intelligent Warehouse for Industries