Oracle Exalytics Briefing

(1)

Oracle Exalytics Briefing

Dave Miller, Mythics Enterprise Architect Greg Mika, Mythics Enterprise Architect

March 5, 2014

(2)

Agenda

• Introductions

• About Mythics

• Exalytics Overview

• Demonstration

• Scenario – BI Modernization

• Mythics Technology Innovation Center and Enterprise Architecture Team

• Review

• Questions

(3)

Oracle Reseller

• Efficiency

• Contracts

• Relationships

Value Added Partner

• Certifications

• Consulting

• Training

Oracle Systems Integrator

• Hardware

• Architects

• Pre‐Sales

• Innovation

Oracle Reseller

• Efficiency

• Contracts

• Relationships

Value Added Partner

• Certifications

• Consulting

• Training

Oracle Systems Integrator

• Hardware

• Architects

• Pre‐Sales

• Innovation

The Evolution of Mythics

3

mythics.com

2000 2006 2013

The Mythics Value to Oracle & Our Customers

(4)

One Company for Any Oracle Need

4

(5)

Mythics Consulting Core Capabilities

5

• 800+ engagements across multiple vertical markets &

agencies

• Diverse technical backgrounds with common Oracle thread

• Strong project management capabilities

• Key relationships with Oracle product development

• Highly skilled team with

numerous Oracle specializations

Organizational Focus

Award winning consulting group with experience across a

wide array of Oracle solution areas.

Enterprise Infrastructure Cloud Services

High Availability / Disaster Recovery Engineered Systems: Exadata/Exalogic/ODA Managed Services

Fusion Middleware

WebCenter Content and Portal Oracle BPM/SOA

Custom ADF WebLogic Server

BI & Data Warehousing OBIEE

Data Mart Development

Tactical Data Warehouse Support IV&V

Security & Identity Management Identity & Access Management FISMA Compliance, HSPD‐12 CAC/PIV enablement

Applications

Oracle COTS Implementations Application / Modernization

(6)

What is Exalytics?

• Formally named Exalytics In-Memory Machine

• An Oracle Engineered System (Combination of hardware and software optimized and engineered to maximize performance, scalability, and reliability) purpose-built for Analytics, Business Intelligence, and Enterprise Performance Management.

• X3-4 (Intel) T5-8 (SPARC)

6

Confidential & Proprietary – © Mythics, Inc.

• 2 TB RAM

• 2.4 TB Flash

• 40 Xeon CPU cores

• 1 Gb, 10 Gb, 40 Gb Net

• 5.4 TB Local disk + 8 Gb FC to SAN

• 4 TB RAM

• 3.2 TB Flash

• 128 SPARC CPU cores

• 1 Gb, 10 Gb, 40 Gb Net

• 7.4 TB Local disk + 8 Gb FC to SAN

• Zero Overhead Virtualization

•Oracle BI EE

•Times10

•BI Apps

•Hyperion/Essbase

•Endeca

•R

•Mobile

(7)

Extra Slides

5.4 TB Disk RAID 5.4 TB Disk

RAID

Exalytics X3-4 : Front

(8)

Extra Slides

8Gb Fibre Channel

1GbE Net 1GbE

Net

10GbE Net 10GbE

Net

40Gb Infiniband

40Gb Infiniband ILOM

ILOM

Exalytics X3-4 : Back

(9)

Reduce operational cost and risk with fully tested to

bottom stack of optimized hardware and software

Provide fastest performance for business intelligence applications, EPM applications, and large-scale mobile deployments

Dramatically faster response time - enabled through storing data in main memory and flash

Deliver lightning-fast performance

& infinite data-scale with world's fastest database machine

Instantly identify outliers and patterns in large, complex data sets through speed-of-thought visual exploration

Seamless migration of existing OBIEE and Essbase Applications

What are the Benefits of Exalytics?

(10)

• Intelligent Adaptive In-Memory Cache

– Decides what gets stored in-memory – Adapts to changes in analytic

workload

• In-Memory Database

– Oracle TimesTen Database

– Advanced Columnar Compression – In-Memory Analytic Functions

2 TB or 4 TB RAM

TimesTen In-Memory Database for

Exalytics Intelligent

In-Memory Cache

How Does it Work for Traditional BI?

(11)

BI Server

OLTP & ODS

Systems Data Warehouse

Data Mart Packaged

Applications (Oracle, SAP, Others)

Excel

XML/Office Business Process SourcesOLAP

Exadata Unstructured &

Semi-Structured

Common Enterprise Information Model

Interactive

Dashboards Reports &

Publishing Query &

Analysis Detect &

Alert

Office Search Embedded Mobile

Scorecards

How Does it Work for Traditional BI - Before

(12)

TimesTen for Exalytics TimesTen for

Exalytics BI Server

with

Detailed Usage Tracking

BI Server Script Summary

Advisor

Cache Miss Cache Hit

Scheduled Refresh Aggregate

Selection Usage Analysis

OLTP & ODS

Systems Data Warehouse

Data Mart Packaged

Applications (Oracle, SAP, Others)

Excel

XML/Office Business Process SourcesOLAP

Exadata Unstructured &

Semi-Structured

Common Enterprise Information Model

Interactive

Dashboards Reports &

Publishing Query &

Analysis Detect &

Alert

Office Search Embedded Mobile

Scorecards

How Does it Work for Traditional BI - After

(13)

Demo

(14)

What Else Can Exalytics Do?

OBI EE + Times10

•Where did I Spend?

•How much did I spend?

•What did I buy?

•Was it a legitimate purchase?

Hyperion + Essbase

•If I spend this much in the past how much will I spend in the future?

•What if I refresh Hardware every 4 years instead of 3?

•What if I upgrade RAM in year 3 and upgrade every 5 years?

R

•Can statistical analysis tell me the best time to buy?

•Who are the best vendors to use based on historical pricing?

Endeca

•If I mine my help desk tickets can I see which brands have the most problems? What types of problems?

•What is the

sentiment on Social Media for the

vendors that I use?

(15)

BI Modernization Scenario

• Bought piecemeal over time leading to separate components on separate servers

• Procurement /Spend Analytics on IBM

• OBIEE on Linux

• Hyperion Planning on Windows

• Costly, Inefficient, Challenging to Support

• Each has separate DR environment

• Different HW/OS vendors for Support

• Disk and traditional networking infrastructure struggles to meet performance goals

• Can’t take full advantage of Exadata

• Are you able to do statistical analysis or examine unstructured data? How about Mobile?

BI Apps

OBIEE

Hyperion Planning

Prod

BI Apps

OBIEE

Hyperion Planning

DR

Current State

(16)

BI Modernization Scenario

• Hardware and Software Engineered Together

• Procurement /Spend Analytics, OBIEE, and Hyperion Planning on one Exalytics – 40+

cores, 2TB+ RAM, 2TB+ Flash

• Simple, Efficient, Easy to Support

• Single DR platform

• Support = One Throat to Choke

• Bundled Patches are easily applied

• Performance SLAs are met (CPUs + RAM + Flash + Infiniband + In‐Memory Software)

• Exadata and Mobile access ‐ out of the box

• Endeca for unstructured analytics, R for statistical analysis – out of the box

Exadata

Data Center DR Data Center

Future State

Exadata BI Apps, OBIEE, Hyperion, Endeca BI Apps, OBIEE,

Hyperion, Endeca

(17)

Technology Innovation Center and Mythics Enterprise Architecture Team

People and Resources to Support Oracle Customers

17

Product Detail

Exadata X2 At Tech Center

Exadata X3 Onsite, Offsite

Exalytics ^{Full Stack}

ODA Mobile, Tech Center

ZFS Storage With Exadata

X Series Blades At Tech Center, OVM Cluster

OVM Cluster At Tech Center, OEM, Endeca, EBS, EPM

Mythics EA Team

•Brent Seaman

•Dave Miller

•Randy Hardee

• Greg Mika

•Ted Nanayakara

•Pradip Tyagi

100+ Years ORCL Exp.

mythics.com

(18)

Oracle Exalytics In‐Memory Machine

Extreme performance Oracle business intelligence platform

• Fastest OLAP Query, Reporting & Analysis

• Fastest Financial and Operational Planning

• Best BI & EPM Cost/Performance

• BI Apps / EPM Apps Are Certified

(19)