Oracle Exadata Database Machine Případové studie v bankovnictví

(1)

(2)

Oracle Exadata Database Machine

Případové studie v bankovnictví

Ing. Josef Krejčí

Principal Sales Consultant, Engineered Systems

Oracle Czech

(3)

Co je Oracle Exadata Database Machine?

Všichni mluví o EXADATA …

• Inteligentní storage

• DB server

• DB options

• Spolehlivé řešení

• Úspěšný produkt

• Bedna pro data a Database

• Řešení, které Vám ušetří čas

(4)

Installation

Testing

Tuning

Operations

Upgrades

Design

Exadata spoří Váš čas v několika oblastech

1. Před-konfigurováno a optimalizováno pro

běh Oracle databáze

2. Rychlá instalace - připraveno pro migraci dat

po objednání do 28 kalendářních dnů (26+2)

3. Rychlá a snadná migrace databázových úloh

– infrastruktura jako celek otestována

4. Redukce optimalizačních kroků při stavbě

DB infrastruktur - vše maximálně vyladěno

5. Minimalizace výpadku - vše redundantní,

vyměnitelné za chodu.

6. Zjednodušení procedur správy (Patching,

Upgrades) - vše již otestováno - snížení rizika

(5)

(6)

Více než 7500 instalací po celém světě

50% datové sklady, 50% OLTP nebo smíšená zátěž

• Petabyte datové

sklady

• Financial Trading

řešení

• E-Commerce sítě

• Konsolidační

platforma pro

stovky databází

Public 6

(7)

ExadataTV

www.youtube.com/ExadataTV

• 30+ video referencí

(8)

Oracle Exadata zákazníci - reference

http://www.oracle.com/customers

(9)

(10)

Oracle Exadata Database Machine - instalace v ČR

Seznam v čase

10

Typ / Generace

Počet

Datum

OKsystem

Exadata V1 / Half Rack

1x

2009 Únor

Mailprofiler

Exadata X2-2 / Quarter Rack

1x

2012 Březen

Arrow

Exadata X3-2 /Eighth Rack

1x

2013 Únor

Homecredit

Exadata X3-2 / Eighth Rack

2x

2013 Květen

J&T banka

Exadata X3-2 / Eighth Rack

2x

2013 Červen

„Logistika“

Exadata X3-2 / Quarter Rack

3x

2013 Červenec

MMR

Exadata X3-2 / Eighth Rack

1x

2013 Srpen

J&T banka

Exadata X3-2 / Eighth Rack

1x

2013 Listopad

ČMSS

Exadata X4-2 / Eighth Rack

2x

2014 Leden

Arrow

Exadata X4-2 / Eighth Rack

1x

2014 Březen

EquaBank

Exadata X4-2 / Eighth Rack

2x

2014 Květen

„Logistika“

Exadata X4-2 / Eighth Rack

2x

2014 Květen

(11)

Oracle Exastack Program v České republice

Aplikační dodavatelé již pro vás Oracle Exadatu Database Machine otestovali

(12)

Případové studie

Finance

(13)

“

_{With our migration to Exadata we've}

seen a 17x performance improvement,

having made no changes to our

application.

”

–

Electronic Data Warehouse Head, BNP Paribas

Public 13

(14)

“With the implementation of Oracle Exadata Database

Machine, data processing performance improved

significantly, and the bank acquired the ability to analyze

increasing data volume in much shorter cycles. In

addition, compressing the data volume by 75% reduced

electrical usage and costs.”

–

Marcus Prätzas, Head FDW, Deutsche Bank

14

(15)

“We chose Oracle Exadata to help keep

us nimble by delivering a response

time of less than 100ms over petabytes

of data.”

–

Sehmuz Bayhan, CTO PayPal

15

(16)

“As the business seeks more services on

demand, we needed to provide that

resilient platform and Exadata provides us a

consolidated platform for database services

that can meet all those needs”

–

Nicolas Tan, Head, Infrastructure and Platform Services

16

(17)

Více a podrobněji v odpoledním bloku …

• Oracle Exadata Database Machine

Jaké jednoznačné výhody přináší pro finanční instituce

–

Tématický blok - Multichannel FrontEnd, sál Gracie od 15:00

(18)

(19)

(20)

Oracle Exadata Database Machine

Jaké jednoznačné výhody přináší pro finanční instituce

Ing. Josef Krejčí

Principal Sales Consultant, Engineered Systems

Oracle Czech

(21)

Safe Harbor Statement

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.

(22)

Exadata Delivers

The Shortest Time

To Value

(23)

Standardized and Simple to Deploy

• All Exadata Database Machines are the same

‒

Delivered ready-to-run

‒

Tested and documented

‒

Highly supportable

Deploy in Days, Not Months

‒

No unique configuration issues

‒

Identical to configuration used

by Oracle Engineering

• Runs existing OLTP and DW applications

‒

Full 30+ years of Oracle DB capabilities

‒

No Exadata certification required

• Leverages Oracle ecosystem

‒

Skills, knowledge base, people and partners

(24)

Exadata Saves Money on Design

• Purpose-Built for Database Workloads

–

30+ Years of Design Best Practices

–

A Balanced End-To-End Design

–

Carefully Selected Components

• High Availability and Scalability

–

Highly Available Design Maximizes Uptime

–

Field Upgradability Accommodates Growth

• Intelligent Storage Maximizes Investment

–

Software (Smart Scan, Flash Cache, HCC)

–

Hardware (InfiniBand, PCI Flash Cards)

Installation

Testing

Tuning

Operations

Upgrades

Design

Public 24

(25)

Exadata Saves Money on Installation

• Fully Functional System Delivered

–

Pre-Racked, Pre-Cabled, Pre-Tested

–

Complete Rack Rolls into Data Center

–

Your Configuration is Not Unique

• All Software is Pre-Installed

–

Software Installed To Your Specifications

–

Fully Stress-Tested At Customer Handoff

• Fully Documented Installation

–

Documentation Generated By Oracle

–

Installation Documents Delivered at Handoff

Design

Testing

Tuning

Operations

Upgrades

Installation

Public 25

(26)

Exadata Saves Money on Testing

• More Productive Technical Testing

–

Best Practices Used During Installation

–

Fully Patched to Latest Patchset

–

Technical Testing Minimized

• More Productive Functional Testing

–

High Performance Design Speeds Testing

–

Little Time Wasted on Performance Issues

• Faster Go-Live, Shorter Time To Value

–

Go-Live in Days/Weeks, not Months

–

Start Benefitting from Exadata Right Away

Installation

Tuning

Operations

Upgrades

_Design

Testing

Public 26

(27)

Exadata Saves Money on Tuning

• High Performance Day One

–

Extreme Performance was Pre-Validated

–

Remaining Issues may be in Logical Database Design

or in Sub-Optimal SQL Statements

• Lower Day-To-Day Tuning Effort

–

Exadata Design is Inherently Highly Efficient

–

DBAs Can Focus on Database Design Issues

• Single Management Framework

–

One Tool for Database and Hardware Mgmt

–

Visibility of All Components in the Stack

Installation

Testing

Operations

Upgrades

_Design

Tuning

Public 27

(28)

Exadata Saves Money on Operations

• Organizational Efficiency

–

Engineered Systems Reduce Complexity

–

Staff Can Focus on Adding Business Value

• Hot Swappable Components and Spares

–

Hot-Swappable Power Supplies and Fans

–

Additional Spare Disk(s) Onsite

–

Additional Spare Flash Card(s) Onsite

• Oracle Platinum Support (At No Cost)

–

Proactive Fault Notification

–

Fast Response Time and Resolution Time

Installation

Testing

Tuning

Maintenance

_Design

Operations

Public 28

(29)

Exadata Saves Money on Upgrades

• Patches Are Bundled Together

–

Patches are Delivered in Complete Sets

–

Oracle Ensures Patches Work Together

–

One Patch Bundle for All Components

• Rolling Upgrades are Possible

–

Database Upgrades with No Downtime

–

Storage Upgrades with No Downtime

• Oracle Platinum Support (At No Cost)

–

Oracle Can Do The Patching For You

–

Up To Four Times Per Year

Installation

Testing

Tuning

Operations

Design

Upgrades

Public 29

(30)

Installation

Testing

Tuning

Operations

Upgrades

Design

Exadata Saves Money Six Ways

1. Pre-Designed for Optimal Performance and

Management

2. Fast, Repeatable Installation – Done by

Oracle’s Own Experts

3. Faster, Easier Database Testing

4. Reduced Tuning Efforts, More focus on

Value-Add

5. Minimal Impact From Hardware Failure, Fast

Resolution to Issues

6. Simplified Patching and Upgrades –

Reduced Effort, Reduced Testing, Reduced

Risk

(31)

Deploy

new systems

in days.

Delivered

ready-to-run.

Reduce

administrative

complexity

and

Simplify

support

Eliminate

application

delays

, bottlenecks and long-running jobs

Shrink data center

through consolidation

Exadata’s IT and Business Benefits

Drive Better IT Practices and a More Productive Business

to questions faster and more predictably

Make more informed decisions

based on deeper analysis of data

for new service and product offerings

productivity

I.T.

Business

(32)

Breaking

Traditional

Database

Performance

Bottlenecks

Public 32

(33)

Traditional Database Deployment Issues

• Traditional architectures don’t scale

–

The separation of servers from storage across slow SANs can

bottleneck performance

–

Modern multi-core CPUs consume data 10x faster than SAN arrays

can deliver it

• Capital Costs

–

Storage arrays dominate the costs of DB deployments

• People Costs and Complexity

–

Deployments are very complex and must be tuned, tested, and

maintained by each customer

Servers

Storage

SAN

Bottleneck

(34)

Engineered For Extreme Database I/O

Database

CPUs

Memory

HBAs

Switches

Controllers

An unbalanced configuration

Exadata’s configuration

< 20%

Possible

Efficiency

100%

Possible

Efficiency

Disks

Database

CPUs

Memory

HBAs

Switches

Controllers

Disks

(35)

Exadata’s Technologies

Technologies – Prepackaged and Fully Supported

Public 35

• Databases Have Only Advanced

Incrementally for 10+ Years

• Suddenly, Many Technologies are

Revolutionizing the Industry

• _Exadata

_{Exploits Technologies}

_and

_Makes

Them Mainstream

–

Intelligent Storage

–

Flash Memory

–

Columnar Compression

–

_{Ultra Fast Networking}

(36)

Traditional Query Processing

Using Traditional Storage

Public 36

What Were

Yesterday

’

s

Sales?

SUM

Oracle Database

Storage Array

Retrieve

Entire Sales

Table

Select sum(sales)

where salesdate=

‘04-Jun-2014’

…

All Rows

returned

(37)

Exadata Query Offload

Using Exadata Storage Servers

Public 37

What Were

Yesterday

’

s

Sales?

SUM

Oracle Exadata Storage

Select sum(sales)

where salesdate=

‘04-Jun-2014’

…

Retrieve Sales

for Jun 04 2014

Oracle Database

Matching

Rows

returned

(38)

SAN Bottlenecks Restrict Databases

Fiber Channel Quickly Becomes a Bottleneck

Public 38

Database

Servers

Traditional

SAN

(39)

Exadata Has Ultra-Fast Storage Links

InfiniBand Delivers Unlimited Bandwidth

Public 39

Database Servers

Storage Servers

High Bandwidth,

Low Latency

40 Gigabit Links

(40 Gigabits read

and

write)

(40)

Disk Latency Slows Responsiveness

About 300 I/Os Per Second, Per Drive

Public 40

Seek Time

Rotational Delay

(41)

Smart Flash Cache Speeds Responsiveness

Hot Data Blocks are Cached In Flash Memory

Public 41

Hot Data Blocks

Sub-Millisecond Access

Automatically Managed

New

Zero Overhead

Flash Compression*

(42)

PayPal: Real-Time OLTP

Objectives

• Analyze 100% of payments for

risk in < 100 milliseconds

• 99.999% uptime

• 2x increase in transaction volume

Solution

• 3 Pods, each with two X2-8’s plus

two X2 Storage Expansion Racks,

and Active Data Guard to identical

standby configuration

Benefits

“We chose Oracle Exadata to help keep us nimble by

delivering a response time of less than 100ms over

petabytes

of data.”

-

Sehmuz Bayhan, CTO PayPal

2x Exadata X2-8

2x Storage Expansion

Faster

Applications

10x Faster

Overall

Maximum

Availability

99.99%

Increased

Payment

Volume

Reduced

Risk Exposure

99.99% Analysis

Active Data Guard

200% Increase

2x Exadata X2-8

2x Storage Expansion

• 300,000+ executions per second

• 40 ms (average) response times (99.99%)

Production (Primary Data Center)

Standby (DR Data Center)

24 Exadata

Systems in

total, across

3 “pods”

WAN @ 650+ miles

(30 ms)

120 TB database

X 3 = 360 TB total

Public 42

(43)

Deutsche Bank: Financial Data Warehouse

Business Objectives

• Disclosure

• RWA (Basel I / II)

• EC / EL / GVA

• Daily Derivatives

• Many more

Solution

• Establish real-time credit risk, regulatory law, and

internal management reporting to optimize credit

risk analysis, as the ability to perform daily

analyses of risk ratios is increasingly important

2010

211 Benefits

Storage

Savings

75%

reduced electrical usage

and costs

Started to add

Big Data

Extreme

Usage

1000s of

users

“With the implementation of Oracle Exadata Database Machine, data

processing performance improved significantly, and the bank acquired

the ability to analyze increasing data volume in much shorter cycles. In

addition, compressing the data volume by 75% reduced electrical usage

and costs.”

-

Marcus Prätzas, Head FDW, Deutsche Bank

Preprocess for DW

(44)

Commonwealth Bank of Australia

Business Objectives

•Cost Savings

•Rapid Provisioning

•Extreme Standardization

Solution

•Exadata for



Rapid, reliable deployments



Standardized environments

2011

Benefits

150% in 5

years

ROI

Rapid

Provisioning

Months to

Minutes

“As the business seeks more services on demand, we

needed to provide that resilient platform and Exadata

provides us a consolidated platform for database services

that can meet all those needs”

- Nicolas Tan, Head, Infrastructure and Platform Services

Enterprise servers

configured by CBA

Commodity

clusters

configured by CBA

Commodity clusters

_{configured by Oracle}

OPEX

50~60%

reduction

Simplified

Management

Two Oracle Homes

(45)

Automated Service

Request (ASR) and

Spares Kits

(46)

Automated Service Request (ASR)

Comprehensive

Fault Coverage

• CPU

• Disk Controllers

• Disks

• Flash Cards

• Flash Modules

• InfiniBand

• Cards

• Memory

• System Board

• Power Supplies

• Fans

Customer Data Center

Oracle Support Services

Product’s Auto-Diagnosis

Facility Sends SNMP trap to ASR

Manager

Service Request

is Created

FRU

Dispatched

by Support

Engineer

FRU Replaced by

Field Engineer

ASR

Manager

SR Creation Email

Notification to Customer

Fault Telemetry Securely

Transmitted to Oracle

SR routed to

Support

Engineer

Customer

Oracle Field

Engineer

ASR

Service

!

Fault

occurs

Public 46

(47)

Exadata’s

Unmatched Data

Security

(48)

Secure Database Machine

Complete Security Portfolio

Activity Monitoring

Database Firewall

Auditing and

Reporting

DETECTIVE

Redaction and

Masking

Privileged User

Controls

Encryption

PREVENTIVE

ADMINISTRATIVE

Sensitive Data

Discovery

Configuration

Management

Privilege Analysis

Legal HR Finance

Near-Zero Overhead for

fully encrypted database!



Application transparent



Decryption in hardware, not

software (5x faster)

(49)

(50)

(51)

Oracle Exadata Database Machine - zákazníci v ČR

Seznam v čase

51

Typ / Generace

Počet

Datum

OKsystem

Exadata V1 / Half Rack

1x

2009 Únor

Mailprofiler

Exadata X2-2 / Quarter Rack

1x

2012 Březen

Arrow

Exadata X3-2 /Eighth Rack

1x

2013 Únor

Homecredit

Exadata X3-2 / Eighth Rack

2x

2013 Květen

J&T banka

Exadata X3-2 / Eighth Rack

2x

2013 Červen

„Logistika“

Exadata X3-2 / Quarter Rack

3x

2013 Červenec

MMR

Exadata X3-2 / Eighth Rack

1x

2013 Srpen

J&T banka

Exadata X3-2 / Eighth Rack

1x

2013 Listopad

ČMSS

Exadata X4-2 / Eighth Rack

2x

2014 Leden

Arrow

Exadata X4-2 / Eighth Rack

1x

2014 Březen

„Finance“

Exadata X4-2 / Eighth Rack

2x

2014 Květen

„Logistika“

Exadata X4-2 / Eighth Rack

2x

2014 Květen

(52)

Kompetenční centrum ARROW ECS

www.arrowecs.cz/exadata

• Kdo Exadata DEMO využívá

–

Koncoví zákazníci

–

Partneři

• K čemu se Exadata DEMO využívá

–

Prezentace / workshopy

–

Testování aplikací ISVs - certifikace

–

Proof of Concept (PoC)

(53)

(54)