oracle en entel summit 2010

SOFTWARE

HARDWARE HARDWARE

COMPLETE

Leandro PeraltaSenior Sales Consultant – Oracle

Exadata: Extreme Performance

Complete

Open

Copyright ©2009, Oracle. All Rights Reserved, Oracle Confidential

Open

Integrated

Why Oracle

345,000 enterprises trust Oracle

with their most vital and strategic asset

- INFORMATION -

#1 Database for Data Warehouse#1 Database

Enterprise Database & Data Warehouse Market

Market Shares - IDC DW Market Share 2008

Oracle

49%

IBM 22%

Microsoft 17%

Other 12%

Gartner DataQuest July 2009

based on Total Software Revenue

#1 Database for Data Warehouse#1 Database

Continuous Innovation: Acquisitions

Enterprise Content

Management

Performance

Management

Identity & Access

Management

Middleware Platform

and ManagementBusiness Intelligence

Data Integration

(pending)


Operating Systems Systems Management Virtual Machines

(pending)

“The Exadata Database Machine is well

on its way to being the most successful

new product launch in Oracle’s 30 year


new product launch in Oracle’s 30 year

history,”Oracle CEO, Larry Ellison

Which are the drivers of IT

Infrastructure ?


IT Priorities for Challenging and Changing Times

• Examine and cut capital expenditures

• Become more efficient to reduce operating costs

• Deliver even better service, system availability and


• Deliver even better service, system availability and

performance

Which is the bottleneck pain

within IT infrastructure ?


Current IT Infrastructures Impede Cost Reduction

and Efficiency

• Dedicated silos are

inefficient

• Sized for peak loadMiddleware


• Constrained performance

• Difficult to scale

• Expensive to manage

Database

Storage

Dedicated Stacks


EXADATA V2EXADATA V2The Fastest OLAP Database MachineThe Fastest OLAP Database Machine

The First OLTP Database MachineThe First OLTP Database Machine

4 hours

EXADATA: New Paradigm for Business


4 days

• End-to-End Solution provided by one supplier

• High Performance Database Environment of Hardware and Software

• It is not a hardware comparison, it is a new computing architecture

• New Paradigm for Database Business Solution

• Business Benefits is the key of this solution

Massively Parallel GridData Warehousing and OLTP

The Architecture of the Future


Exadata Hardware Architecture

Database Grid

• 8 compute servers Storage Grid

• 14 storage servers

Scaleable Grid standard servers for Compute and Storage

• Eliminates long-standing tradeoff between Scalability, Availability, Cost


• 64 Intel cores

• 576 GB RAM

•14 storage servers

112 Intel cores in storage

• 100 TB SAS disk, or336 TB SATA disk

•5 TB PCI Flash

•Data mirrored across storage servers

InfiniBand Network

• 3 36-port 40Gb/s switches

• Unified Net- servers & storage

• 324 FC Ports equivalent

Start Small and Grow


Full Rack

Half Rack

Balanced Incremental Scaling

for OLTP and DW

Quarter Rack

Sun Oracle Database Machine:

Optimized for large scans

1 TB

with hybrid columnar

compression

10 TB of user data

Requires 10 TB of IO

100 GB

with partition pruning


20 GB

with Storage Indexes

5 GB

with Smart Scans

Subsecond

On Database

Machine

2000X less data needs to be processed

Sun Oracle Database MachineExtreme Performance for all Data Management

• Best for Data Warehousing• Parallel query on memory or Flash

• Compressed 4TB of data in DRAM, 50 TB in flash

• 10x compressed tables with storage offload

• Overall up to 5X faster than 11.1 for Warehousing

• Best for OLTP• Only database that scales real-world applications on grid


• Only database that scales real-world applications on grid

• Smart flash cache provides 1 million IOs per second

• Compressed 1.2 TB of data in DRAM, 15 TB in Flash

• Up to 50x compression for archival data

• Secure, fault tolerant

• Best for Database Consolidation• Only database machine that runs and scales all workloads

• Predictable response times in multi-database, multi-

application, multi-user environments

On average 5x faster than a heavily tuned Teradata

system on a real world workload of 64 queries

• Teradata without tuning was

on average 8x slower than a

Database Machine without

tuning

Financial Institution – US


tuning

• Longest running query ran

12x faster on Database

machine (no tuning required)

A Full Rack DB Machine was on average 3x faster

than Netezza’s 2 rack NPS10200

• A full rack database machine

outperforms a Netezza

NPS10200 by 9x on

Retail – APAC


analyzing 3TB for cross

selling analysis

• Database machine loads data

on average 25% faster

On average 26x faster than DB2

• Benchmark workload with 21 Business Objects queries

• Longest running query on DB2 runs 47x faster on a

Information & Technology – US


DB2 runs 47x faster on a Database Machine

• Less tuning, DB2 schema with 200 indexes, DB Machine with only 12 indexes

Exadata 23x faster than their actual arquitecture

and 15x faster than the competitor in average

• Telecommunication Sector

• Total of 10 process that were processed and compared

Telecommunication (V2) – Chile -

100

120

140

98.58

140

Total Time of Execution


processed and compared

• Exadata Full Rack used

• Obtained up to 96X improvement.

(hours)

0

20

40

60

80

Exadata

CompetitorActual

6.28

oracle en entel summit 2010

Technology

database machine

rights reserved

oracle confidential

exadata

database

data

oracle

copyright