Andrew mendelsohn senior vice president database oracle corporation
This presentation is the property of its rightful owner.
Sponsored Links
1 / 33

Andrew Mendelsohn Senior Vice President Database Oracle Corporation PowerPoint PPT Presentation


  • 101 Views
  • Uploaded on
  • Presentation posted in: General

Andrew Mendelsohn Senior Vice President Database Oracle Corporation. Oracle Database 10 g : A Revolution in Database Technology. Oracle Database 10 g Goals. Highest Quality of Service Highest Availability, Reliability, Security Highest Performance, Scalability Half the Cost

Download Presentation

Andrew Mendelsohn Senior Vice President Database Oracle Corporation

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Andrew mendelsohn senior vice president database oracle corporation

Andrew MendelsohnSenior Vice President Database

Oracle Corporation


Andrew mendelsohn senior vice president database oracle corporation

Oracle Database 10g:A Revolution in Database Technology


Oracle database 10 g goals

Oracle Database 10g Goals

  • Highest Quality of Service

    • Highest Availability, Reliability, Security

    • Highest Performance, Scalability

  • Half the Cost

    • Lower hardware, software, labor costs

  • Easiest to Manage


Problem islands of computation

Problem: Islands of Computation

  • Limited scalability, no resource sharing

  • Must be configured for peak loads

  • Single point of failure

  • Slow to adjust to business needs

Sales

Files

HR

Procurement

Service

Supply

Chain

Financials


Grid computing eliminates islands of computation

Expensive Components

High incremental costs

Configured for peak

Single point of failure

Hard to change

Difficult to manage

Low cost, modular components

Low incremental costs

Capacity on demand

Fault tolerant

Flexible

Unified management

Grid Computing Eliminates Islands of Computation

Coordinated use of many small servers acting as one large computer.

IT Problem

Grid Solution


Andrew mendelsohn senior vice president database oracle corporation

Introducing


Oracle grid computing

Application Server

Grid

Storage Grid

Database Grid

Grid

Control

Oracle Grid Computing

  • Highest quality of service

  • Lowest cost

  • Easiest to Manage


Automatic storage management asm

Automatic Storage Management (ASM)

  • Eliminates need for conventional file system and volume manager

  • Capacity on demand

    • Add/drop disks online

  • Automatic I/O load balancing

    • Stripes data across disks to balance load

    • Best I/O throughput

  • Automatic mirroring

  • Easy

Automatic Storage

Management


Automatic storage management asm1

Automatic Storage Management (ASM)

  • Eliminates need for conventional file system and volume manager

  • Capacity on demand

    • Add/drop disks online

  • Automatic I/O load balancing

    • Stripes data across disks to balance load

    • Best I/O throughput

  • Automatic mirroring

  • Easy

Automatic Storage

Management


Automatic storage management summary

Automatic Storage Management Summary

  • Low Cost

    • Eliminates need for volume manager and file systems

    • Works well with inexpensive, modular storage

    • Better storage utilization

    • Easy – up to 50% less DBA/Sys Admin work

  • Fault tolerant

  • Raw disk performance

  • Capacity on demand

  • Automatic I/O load balancing


Storage grid highest data protection for lowest cost

Data Guard

Site Protection

Flashback

Human Error

Protection

Flash Recovery

Corruption Protection

ASMMirroring

StorageProtection

Storage Grid - Highest Data Protection for Lowest Cost


Database server grid real application clusters

Database Server Grid –Real Application Clusters

  • Runs Real Applications

  • Proven

    • Over 1000 production sites

    • Certified with leading apps

  • Runs on standard,low cost servers

  • Fault tolerant

ERP

CRM

DW


Andrew mendelsohn senior vice president database oracle corporation

“Cost savings as much as 25-50% in hardware and maintenance were real and undeniable.”

  • Gartner

Source: Gartner Early Adopters Experiences with Oracle9i RAC, Nov 2003


Database server grid integrated clusterware

Database Server Grid -Integrated Clusterware

  • Portable to all platforms

  • Low Cost

    • No need to purchase additional software

    • Easy to install, manage

  • Easy

    • Deploys in hours not days

    • Improved single system image

    • Single-vendor support

  • Remains open to third-party clusterware


Database server grid workload management

Database Server Grid –Workload Management

  • Push-button, online add/drop server to cluster

  • Automatic Load Balancing

    • Based on “service” concept

    • Automatic routing of service connection requests to appropriate server with lowest load

    • On server failure, automatic re-allocation of surviving servers to services

    • Dynamic load balancing when service levels not met (coming soon)


Grid fault tolerance

Grid Fault Tolerance

Fastest end-to-end application failover with Oracle 10g infrastructure

Database App. Server Total

Failover Detection Recovery Time

minutes

minutes

Oracle9i

Oracle 10g

< 1 minute

seconds

seconds

seconds


Low cost servers hp tpc c benchmark

Low Cost Servers - HP TPC-C Benchmark

1,184,893

1,008,144

$7.9 MTotal Cost

$2.6 MTotal Cost

TPM-C

Same 1.5 GHz Itanium2 CPUs

Source http://www.tpc.org - Audited Results


Oracle rac 10g only solution for enterprise grids

Oracle RAC 10g - Only Solution for Enterprise Grids

  • Mission Critical Quality of Service on Industry Standard, Low Cost Servers

  • Integrated clusterware makes RAC easy for everyone

  • Fault tolerant, scales all applications

  • Capacity on demand

  • Automatic load balancing


Oracle 10 g grid management one half to one tenth the cost

ERP

EMAIL

DW

Oracle 10g Grid ManagementOne-half to one-tenth the cost

  • Self-Managing Database

  • OEM Grid Control

    • Grid-wide operations

    • Scale from one to hundreds of systems with little incremental cost


Business challenge how to scale dba s to the grid

Creation & Configuration 12 %

Business Challenge – How to Scale DBA’s to the Grid ?

Installation 6%

Others

15%

DataLoading 6%

Software Maintenance 6%

Ongoing System Management 55%

Source: IOUG 2001 DBA Survey


Oracle database 10 g self managing database

Oracle Database 10gSelf-managing Database

  • Built-in Intelligent Infrastructure

    • Code instrumentation

    • Workload repository

  • Automation of Routine Tasks

    • Automatic disk-based backup and recovery

    • Automatic optimizer statistics collection

    • Automatic PGA and SGA Memory Management

    • Automatic Storage Management

  • Tools to Empower the DBA

    • Automatic Database Diagnostic Monitor

    • Automatic Tuning Optimizer

  • Lots more …


Andrew mendelsohn senior vice president database oracle corporation

“Sophisticated Simplicity.”

  • Infoworld

Source: Infoworld.com, March 22, 2004


Andrew mendelsohn senior vice president database oracle corporation

“Oracle has clearly gone farther than any other vendor to instrument the database and provide expert advice to administrators.”

  • Charlie Gary, Meta Group

Source: Source: META Group “Oracle 10g: Managing Reality”, December 17, 2003


Oracle oem 10 g grid control

ERP

EMAIL

DW

Oracle OEM 10g Grid Control

  • Manages the Oracle Grid environment

  • Scales to thousands of servers

  • Application Service Level Management

  • Configuration Management

    • Provisioning

    • Cloning

    • Patch Management


Andrew mendelsohn senior vice president database oracle corporation

“We now can manage hundreds of servers throughout the world from within one powerful management console.”

  • Warwick CalkinNational Manager, Telstra IT Infrastructure and Operations


Business intelligence on the grid

Business Intelligence on the Grid

  • Lower Cost

    • Leverage hardware, software, labor savings

    • Manage millions of terabytes

  • Intelligence when you need it

    • Cross-platform transportable tablespaces

    • Asynchronous change data capture

  • More value from your data

    • Mature OLAP, Data Mining

    • Improved SQL Analytics – SQL Model Clause


Html db rapid web development tool

HTML DB –Rapid Web Development Tool

  • Builds database-driven Web applications

  • For non-programmers

  • App developers and app users just need a web browser

  • Addresses MS Access proliferation problem

    • Supports hosted development and deployment environment


Oracle database 10 g performance metrics

PLSQL up to 2x

Table Scans up to 2x

SQL Profile Tuning huge

Floating point math up to 10x

Bulk LOB Update up to 3x

Import up to 15x

Export up to 35%

Incremental backup up 10x

Parallel media recovery 2-4x

Backup compression 17x

Infiniband interconnect ½ latency, 2x block transfer

TPC-C

1.2 million on RAC, 1 million SMP

Best absolute and best on 4-way Intel

+28% on same hardware

Oracle Database 10g Performance Metrics


Easy transition to the grid

Easy Transition to the Grid

  • Oracle 10g preserves investment

    • Runs all existing apps on clusters

    • Moves data to new platforms as fast as FTP

    • Low risk - Start small and add capacity on demand

ERP

EMAIL

DW


Oracle 10 g grid computing

ERP

EMAIL

DW

Oracle 10g Grid Computing

  • Half the Cost

    • Low cost, modular storage and servers

    • Complete, integrated software infrastructure

    • Half the labor cost

  • Highest Quality of Service

  • Rapidly Adjust to Business Needs

    • Capacity on demand

    • Load balancing

  • Easy to Manage


Andrew mendelsohn senior vice president database oracle corporation

“The best thing about the Grid is that it is unstoppable.”

The Economist

June 2001

2


  • Login