Docstoc

Grid

Document Sample
Grid Powered By Docstoc
					Thomas Kyte

thomas.kyte@oracle.com
Oracle Corporation
http://asktom.oracle.com
Resources
   metalink.oracle.com
   asktom.oracle.com
   otn.oracle.com
     –   Discussion forums
     –   Software download
     –   Documentation
     –   Technology Corners
   www.oracle.com/oramag
   groups.google.com
     –   comp.databases.oracle.*
   IOUG
    Introducing Oracle 10g
 Runs all your applications
 Stores all your information
 Highly
     Scalable
     Available
     Reliable
 Secure
 Easy to manage
                                   10G 10G
     –   Make individual systems
         self-managing
     –   Manage many servers at
         once
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
        Oracle Database 10g –
        Align Storage with the Business
 Problem: Islands of
  storage
    –   “My storage is 50% utilized
        and growing 30% a year”
                                                 CRM

                                      ERP




                                            DW
        Oracle Database 10g –
        Align Storage with the Business
 Problem: Islands of
  storage
    –   “My storage is 50% utilized
        and growing 30% a year”
 Solution: Groups of
  standard, modular disks
    –   Consolidated,
        Networked Storage
    –   Dynamically Provision
         Oracle Grid Storage Management
         Highly Available and Low Cost
 Oracle Automatic Storage
  Management
     –   Manages disk storage groups
     –   Mirrors, Stripes, Re-balances
     –   Huge reduction in labor cost
 Built-In Data Protection at Lowest
  Cost
     –   Disk Based Backup and
         Recovery
     –   Flashback in Time
     –   Site Recovery                   Automatic Storage   Disk Based
                                           Management         Backup &
                                                              Recovery
      Oracle DB 10g ULDB Stores All Your
      Data
 Database size limit raised
  to millions of Terabytes (8
                                         Relational
  Exabytes)                     Characters, Numbers and Dates
 Ultra Large Data Files –              Oracle Text
  Terabytes in single file        Text management and search
 Unlimited size LOB                 Oracle interMedia
  columns – Terabytes               Multimedia management

 Automatic Storage                   Oracle Locator
                                Location and Proximity Searching
  Management removes file
  system limits                            XML DB
                                Integrated Native XML Database

                                         OCS Files
                                       Low-cost and Easy


                                                            11
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
    Align Processing with the Business

 Problem: Islands of
  computation
    –   “My servers are 15%
        utilized“

                                         CRM

                              ERP




                                    DW
    Align Processing with the Business

 Problem: Islands of
  computation
    –   “My servers are 15%
        utilized“              ERP   CRM   DW
 Solution: Groups of
  industry standard
  servers
    –   Lowest cost, highest
        performance
    –   Capacity on demand
    –   Not Self-healing,
        Disposable
          Complete, Integrated Clusterware

 Complete Oracle cluster software
  solution
 Single-vendor support
 Low Cost
     –   No need to purchase additional
         software                           Services Framework
                                          Cluster Control/Recovery
     –   Easy to install, manage           Messaging and Locking
 High quality and functionality                Connectivity

  across all platforms
 Common event and management
  API‟s
     –   Multi-tier HA & minimal MTTR
 Support for third-party clusterware
Automatic Server Provisioning
 Push-button add/drop server to cluster
 Hands-free allocation and re-allocation of
  servers to services
   –   Automatic routing of service requests to
       appropriate server with lowest load
   –   On server failure, automatic re-allocation of
       surviving servers to services
 Works across all platforms
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
   Low Cost Fault Tolerance
            Computer
             Failures
Unplanned
Downtime      Data
            Failures


             System
 Planned    Changes
Downtime
             Data
            Changes
   Low Cost Fault Tolerance
            Computer    Oracle10g RAC
             Failures    Integrated
Unplanned                 clusterware
Downtime      Data         –   Integrated, less
            Failures           moving parts, better
                               tested
                         Faster failover
             System       between servers
 Planned    Changes        –   Single digit seconds
Downtime
             Data
            Changes
   New Economics for
   Data Protection & Recovery
            Computer
             Failures
Unplanned                Disk-Based Recovery
Downtime      Data
            Failures
                        Trade cheap disk space
                        for expensive downtime
             System
 Planned    Changes              Lets take a look
Downtime
             Data
            Changes

                                              20
         Flashback Database

                                   New strategy for point-in-time
                       Old          recovery
     Disk Write       Block        Flashback Log captures old
 New                 Version        versions of changed blocks
 Block                                 –   Think of it as a continuous
Version                                    backup
                  Flashback Log        –   Replay log to restore DB to time
                                       –   Restores just changed blocks
                                   It‟s fast - recovers in minutes, not
                                    hours
    Like a “Rewind” button         It‟s easy - single command
       for the Database             restore
                                       –   SQL> Flashback Database to
                                           „2:05 PM‟
                                      Fully automatic disk-
       Flash Backup                    based backup and
                                       recovery
                                         –   Set and Forget
                                      Nightly incremental
                                       backup rolls forward
                                       recovery area backup
                                         –   Changed blocks are
                                             tracked in production
                                             DB
Database Area   Recovery Area Tape       –   Full scan is never
                                             needed
                                         –   Dramatically faster
       Nightly Apply    Weekly        Use low cost ATA disk
             of        Archive to
       Incremental       Tape          array for recovery area
          Backup
And yet more Flashback

 Flashback Database
 Flashback Table
    –   Put table and related segments back as they was
 Flashback Row History
    –   Show me the values of this row for the last three hours
    –   Also great for optimistic concurrency control on the web
 Flashback Drop
    –   Undrop that table
 Flashback Transaction History
    –   Undo transaction xxx.yyy.zzz
   No Cost System Changes
            Computer
             Failures
                         GOAL: Allow any
Unplanned
Downtime                  change to the system
              Data
            Failures      with no downtime


             System      Online Reconfiguration
 Planned    Changes
                            Rolling Upgrades
Downtime
             Data
            Changes

                                               24
         Oracle Database 10g Highest Data
         Protection for Lowest CostData Guard
                                                    Redo
                                                   Shipping

                                    Flash Backup   Site Failure
                                                   Protection,
                                                      rolling
                                                    upgrades
                                      On Disk
                    Flashback         Backups

                                     Corruption
                   Flashback Logs
                                     Protection
ASM Mirroring       Human Error
                      Protection




 Storage Failure
   Protection
             Oracle10i High Availability Features

 Backup and Recovery  Backup and Recovery                  Data Guard (Cont)         Flashback
   – Automated Disk-    (Cont)                                 –   Fine-Grained             – Flashback Database
      Based Backup and          –   Incrementally                  Supplemental             – Flashback
      Recovery                      Updated Backups                Logging                    Reinstantiation
  –   Drop Database             –   Simplified Recovery        –   Named Data Guard         – Flashback Standby
  –   RMAN Database                 Through Resetlogs              Configurations             Database
      Deregistration            –   Restore Tolerates          –   Simplified Zero Data     – Flashback Table
  –   Backup of Standby             Corrupt or Missing             Loss for Data Guard      – Flashback Row
      Control File                  Backups                        SQL Apply                  History
  –   Automated TSPITR          –   Full Database Begin        –   Zero Downtime            – Flashback Drop
      Instantiation                 Backup Command                 Instantiation for SQL    – Flashback
                                –   Change-Aware                   Apply
  –   Simplified Recovery                                                                     Transaction History
      Manager Cataloging            Incremental Backups        –   Real Time Apply
      of Backup Files                                              Redo Data and          Online Operations
                               Data Guard                     –
                                                                                            – Enhanced Online
  –   Automated Channel                                            Archivelog
                                –   Data Guard Broker              Compression                Redefinition
      Failover for Backup           Support for RAC
      and Restore                                                                           – Improved Handling of
                                –   Automated LogMiner                                        DDL Locks on Busy
  –   Automated File                Configuration
      Creation During                                                                         Tables
      Recovery                  –   Log Miner Support for                                   – Signature-Based
                                    Index-Organized                                           Dependency Tracking
  –   Simplified Backups to         Tables
      Disk                                                                                    Using Synonyms
                                –   Secured Redo                                            – Rolling Upgrades
  –   Proxy Copy Backup             Transmission
      of Archivelogs                                                                          with Data Guard SQL
                                                                                              Apply
             Oracle10i High Availability Features

 Backup and Recovery  Backup and Recovery                  Data Guard (Cont)         Flashback
   – Automated Disk-    (Cont)                                 –   Fine-Grained             – Flashback Database
      Based Backup and          –   Incrementally                  Supplemental             – Flashback
      Recovery                      Updated Backups                Logging                    Reinstantiation
  –   Drop Database             –   Simplified Recovery        –   Named Data Guard         – Flashback Standby
  –   RMAN Database                 Through Resetlogs              Configurations             Database
      Deregistration            –   Restore Tolerates          –   Simplified Zero Data     – Flashback Table
  –   Backup of Standby             Corrupt or Missing             Loss for Data Guard      – Flashback Row
      Control File                  Backups                        SQL Apply                  History
  –   Automated TSPITR          –   Full Database Begin        –   Zero Downtime            – Flashback Drop
      Instantiation                 Backup Command                 Instantiation for SQL    – Flashback
                                –   Change-Aware                   Apply
  –   Simplified Recovery                                                                     Transaction History
      Manager Cataloging            Incremental Backups        –   Real Time Apply
      of Backup Files                                              Redo Data and          Online Operations
                               Data Guard                     –
                                                                                            – Enhanced Online
  –   Automated Channel                                            Archivelog
                                –   Data Guard Broker              Compression                Redefinition
      Failover for Backup           Support for RAC
      and Restore                                                                           – Improved Handling of
                                –   Automated LogMiner                                        DDL Locks on Busy
  –   Automated File                Configuration
      Creation During                                                                         Tables
      Recovery                  –   Log Miner Support for                                   – Signature-Based
                                    Index-Organized                                           Dependency Tracking
  –   Simplified Backups to         Tables
      Disk                                                                                    Using Synonyms
                                –   Secured Redo                                            – Rolling Upgrades
  –   Proxy Copy Backup             Transmission
      of Archivelogs                                                                          with Data Guard SQL
                                                                                              Apply
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
           Business Challenge –
           How to Scale DBA‟s to the Grid ?

                                 Installation
                                     6%
                                                Creation &
        Others
                                                Configuration 12 %
          15%




      Software                                  Data
Maintenance 6%                                  Loading 6%
                               Ongoing System
                               Management 55%




Source: IOUG 2001 DBA Survey
   Oracle10i System Management –
   Built-In Intelligent Infrastructure
 Automatic Workload Repository
    –   Automatically collects
        statistics, SQL workload,
        Feature usage
    –   Base-lining capability
    –   History
 Automatic Maintenance Tasks
    –   Pre-packaged, resource
        controlled
 Server-Generated Alerts
    –   Out-of-the-box, Push vs. Pull,
        Just-in-time
         Oracle10i System Management –
         Automatic SGA Management
                                                            Only 2 memory
                        Large Batch   Buffer Cache            parameters
Online
Users    Buffer Cache      Jobs                             Advisor helps
                                                              set parameters
                                      Large Pool
         Large Pool                                         Automatically
                                                              resizes with
         SQL Cache                    SQL Cache
                                                              changes in
                                                     SGA Pool workload
          Java Pool                    Java Pool
                                                            Maximize usage
                                                     PGA Pool

            sort                         sort
                                                              of available
                                                              memory
        Oracle10i System Management –
        Self Optimizing SQL Management
 Oracle Query Optimizer
    –   Comprehensive set of access paths, adaptive search strategy
    –   All cost-based transformations
    –   Preconfigured task to collect object and system statistics
    –   If no statistics available, are collected at parse-time
 Automatic memory allocations, automatic degree of
  parallelism
 Automatic identification and capture of high-load SQL
    –   Automatic SQL Tuning
    –   Automatic SQL Analysis
    –   SQL Access Advisor
     Oracle10i System Management –
     Self Optimizing SQL Management
     Packaged           Custom
       Apps              Apps
                                         Automated capture
           High-load SQL                  and identification of
                                          high-load SQL
     Automatic Tuning Optimizer
                                         Automatic SQL
Auto SQL      Auto SQL       Access
 Tuning       Analysis       Advisor      Tuning
                                         Automatic SQL
                                          Analysis
Packaged       Custom        Custom
  Apps          Apps          Apps       SQL Access Advisor
   +             +              +
  SQL           SQL         Indexes &
 Profile       Advice          MVs


           Well-tuned SQL
     Oracle10g System Management –
     Automatic Database Diagnostic
     Monitor (ADDM)
 Performance expert
  in a box
 Automatically
  provides database-
  wide performance
  diagnosis, including
  RAC
 Pinpoints root cause
  and non-problem
  areas
 Runs proactively
Scalable Software Maintenance –
Discover and Analyze Configurations
 Complete inventory of all Oracle software
     –   Versions
     –   Patch levels
   Oracle product configuration details
   Search and compare configurations
   Change tracking
   Reference configurations
    Scalable Software Maintenance -
    Automated Software Cloning
     Reduce manual labor in software life-cycle
           –    From hours to minutes
     Automate mass provisioning of reference
      systems



    Select Software (and         2       Clone to
1                                        Selected
    Instances) to Clone
                                         Targets



                                     3
                                             Update
                                            Inventory
    Scalable Software Maintenance -
    Automated Patch Management
     Real-time discovery of new patches
            –   Security patch rapid deployment dramatically reduces
                vulnerabilities
     Automatic staging and application
            –   From hours to minutes
     Rolling RAC upgrade



                                   2         Determine
                                            Applicability


                                        3        Apply Patch


                                                4
                                                      Update
1   Patch Published
                                                     Inventory
              Oracle10g Manageability Features

 Infrastructure              Server Configuration              Instance Tuning                 Application Tuning
   –   Easy OracleJVM             –   Automated Storage             –   User-Initiated Buffer Cache   – SQLAccess Advisor
       Monitoring                     Management                        Flushing                      – Materialized View Tuning
   –   SYSAUX Tablespace              Configuration                 –   Database Resource Manager       API
   –                              –   Automated RAC Services            - Adaptive Consumer Group – SQL Tuning Advisor
       Enhanced Wait Model
   –   Database Features Usage        Configuration                     Mapping                       – Enhanced SQLAccess
                                  –   Simplified Upgrade for        –   Database Resource Manager
       Tracking                                                                                         Advisor
   –                                  RAC and OPS Databases             - Fixed CPU Quota             – Automatic Optimizer
       Enhanced Database Time
                                  –   Automated Enterprise          –   New Performance Overview
       Model                                                                                            Statistics Collection
   –                                  Manager Configuration             Charts in Oracle Enterprise
       Top Consumers
                                  –   Automated Portable                Manager                     Backup and Recovery
       Performance Monitoring &                                                                       – Enhanced RMAN Reporting
                                      Clusterware Installation      –   Improved SQL Reporting
       Diagnostic
                                  –                                     Using Oracle Enterprise       – Backup Compression
   –   JDBC: End-to-end               Automated Configuration
                                      of Recovery Area                  Manager                       – Bounded Backup Window
       Java/J2EE Tracing
                                  –                                 –   Integration of Resource       – Manage RMAN Scripts
   –   SQLJ: End-to-end               Out-of-the-box LDAP
       Java/J2EE Tracing              Configuration                     Manager and Profiles          – Recovery Area Full Alert
                                  –                                 –   Automated Checkpoint
   –   Automated Routine              Simplified Initialization
                                                                        Tuning                      Storage Management
       Administration Tasks           Parameters                                                      – Multiple Default Temporary
                                  –                                 –   Transaction Rollback &
   –   Proactive Server-based         Easy Upgrade                                                      Tablespace Support for
                                  –                                     Recovery Monitoring
       Alerts and Notifications       Upgrade Information Tool                                          SQL Operations
                                                                    –   Database Performance
   –   Database Statistics and    –   Simplified Database Install                                     – Automated Storage
       Workload Respository       –
                                                                        Analyzer
                                      User Default Tablespace                                           Management
                                                                    –   Redo Logfile Sizing Advisor
   –   Threshold-Based Alerts                                                                         – Rename Tablespace
                                                                    –   Automated SGA Memory
                                                                        Tuning
              Oracle10g Manageability Features

 Infrastructure              Server Configuration              Instance Tuning                 Application Tuning
   –   Easy OracleJVM             –   Automated Storage             –   User-Initiated Buffer Cache   – SQLAccess Advisor
       Monitoring                     Management                        Flushing                      – Materialized View Tuning
   –   SYSAUX Tablespace              Configuration                 –   Database Resource Manager       API
   –                              –   Automated RAC Services            - Adaptive Consumer Group – SQL Tuning Advisor
       Enhanced Wait Model
   –   Database Features Usage        Configuration                     Mapping                       – Enhanced SQLAccess
                                  –   Simplified Upgrade for        –   Database Resource Manager
       Tracking                                                                                         Advisor
   –                                  RAC and OPS Databases             - Fixed CPU Quota             – Automatic Optimizer
       Enhanced Database Time
                                  –   Automated Enterprise          –   New Performance Overview
       Model                                                                                            Statistics Collection
   –                                  Manager Configuration             Charts in Oracle Enterprise
       Top Consumers
                                  –   Automated Portable                Manager                     Backup and Recovery
       Performance Monitoring &                                                                       – Enhanced RMAN Reporting
                                      Clusterware Installation      –   Improved SQL Reporting
       Diagnostic
                                  –                                     Using Oracle Enterprise       – Backup Compression
   –   JDBC: End-to-end               Automated Configuration
                                      of Recovery Area                  Manager                       – Bounded Backup Window
       Java/J2EE Tracing
                                  –                                 –   Integration of Resource       – Manage RMAN Scripts
   –   SQLJ: End-to-end               Out-of-the-box LDAP
       Java/J2EE Tracing              Configuration                     Manager and Profiles          – Recovery Area Full Alert
                                  –                                 –   Automated Checkpoint
   –   Automated Routine              Simplified Initialization
                                                                        Tuning                      Storage Management
       Administration Tasks           Parameters                                                      – Multiple Default Temporary
                                  –                                 –   Transaction Rollback &
   –   Proactive Server-based         Easy Upgrade                                                      Tablespace Support for
                                  –                                     Recovery Monitoring
       Alerts and Notifications       Upgrade Information Tool                                          SQL Operations
                                                                    –   Database Performance
   –   Database Statistics and    –   Simplified Database Install                                     – Automated Storage
       Workload Respository       –
                                                                        Analyzer
                                      User Default Tablespace                                           Management
                                                                    –   Redo Logfile Sizing Advisor
   –   Threshold-Based Alerts                                                                         – Rename Tablespace
                                                                    –   Automated SGA Memory
                                                                        Tuning
             Oracle10g Manageability Features
             (continued)
 Network Management            Space, Object,             Database Utilities              Scheduler
  –   Back Up Directory Naming   Transaction Mgmt               –   SQL*Plus - SPOOL            –   Core Scheduler Features
      Entries to Local Naming    –   Automatic Undo Retention       CREATE, REPLACE, and        –   Usability and
                                     Tuning                         APPEND Options                  Manageability
      File
                                 –   Segment Shrink Advisor     –   SQL*Plus - Show Recycle     –
  –   Dynamic Connection                                                                            Monitoring
                                 –   Segment Size Estimation        Bin                         –   Recovery
      Manager Configuration                                     –
                                 –   Online Segment Shrink          SQL*Plus -                  –   Support for Jobs in a
  –   Easy Connect Naming
                                 –
                                                                    DBMS_OUTPUT After
      Method                         Proactive Tablespace                                           Clustered Environment
                                                                    SELECT
                                     Management                                                 –   Job Processing
  –   Easy OCI/JDBC Install                                     –   SQL*Plus - SET
                                 –   Undo Advisor                                               –   ILMS Support
  –   Improved Network Outage                                       SQLPROMPT Runtime
                                                                    Variable Substitution       –   Increased Throughput
      Detection
                                                                –   SQL*Plus -                  –   Redo Minimization
  –   Automated LDAP
                                                                    COMPATIBILITY               –   Dynamic Slave Pool
      Discovery for Clients                                         Command Line Option
  –   Improved Connection                                       –   SQL*Plus - Run glogin.sql
      Manager Access Rules                                          and login.sql After Each
  –   Automated Shared Server                                       CONNECT
      Configuration                                             –   iSQL*Plus Input
  –   Simplified Shared Server                                      Prompting
      Configuration Parameters
             Oracle10g Manageability Features
             (continued)
 Network Management            Space, Object,             Database Utilities              Scheduler
  –   Back Up Directory Naming   Transaction Mgmt               –   SQL*Plus - SPOOL            –   Core Scheduler Features
      Entries to Local Naming    –   Automatic Undo Retention       CREATE, REPLACE, and        –   Usability and
                                     Tuning                         APPEND Options                  Manageability
      File
                                 –   Segment Shrink Advisor     –   SQL*Plus - Show Recycle     –
  –   Dynamic Connection                                                                            Monitoring
                                 –   Segment Size Estimation        Bin                         –   Recovery
      Manager Configuration                                     –
                                 –   Online Segment Shrink          SQL*Plus -                  –   Support for Jobs in a
  –   Easy Connect Naming
                                 –
                                                                    DBMS_OUTPUT After
      Method                         Proactive Tablespace                                           Clustered Environment
                                                                    SELECT
                                     Management                                                 –   Job Processing
  –   Easy OCI/JDBC Install                                     –   SQL*Plus - SET
                                 –   Undo Advisor                                               –   ILMS Support
  –   Improved Network Outage                                       SQLPROMPT Runtime
                                                                    Variable Substitution       –   Increased Throughput
      Detection
                                                                –   SQL*Plus -                  –   Redo Minimization
  –   Automated LDAP
                                                                    COMPATIBILITY               –   Dynamic Slave Pool
      Discovery for Clients                                         Command Line Option
  –   Improved Connection                                       –   SQL*Plus - Run glogin.sql
      Manager Access Rules                                          and login.sql After Each
  –   Automated Shared Server                                       CONNECT
      Configuration                                             –   iSQL*Plus Input
  –   Simplified Shared Server                                      Prompting
      Configuration Parameters
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
    Transportable Tablespaces –
    Fastest Way to Provision Data

 Oracle can unplug and plug database data files
   –   Move and share data without unload and reload
   –   Plug/unplug performance independent of
       tablespace size
   –   Mount read-only tablespaces on multiple
       databases

 Now Works Cross-Platform!



                                         24
 Oracle10g Data Pump


 High performance import and export
   –   60% faster than 9i export (single thread)
   –   15x-20x faster than 9i import (single thread)
 Scales with parallel threads
 Network transfer data between databases
  with no intermediate representation
   –   Eg: no disk
Oracle Streams Oracle

              Oracle Streams moves or copies
                  tablespaces faster than FTP
                        Detach, move, attach
                          with one command

              Same platform or cross platform
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
10g Real Time Warehouse Asynchronous CDC


                        Logical                            DW
           Based on   Change Data                         Tables
Archived    Streams
   log
  files                               Transform
                                       SQL, PL/SQL,
                                          Java

                  SQL interface to change data
                  Publish/subscribe paradigm
                  Parallel access to log files, leveraging
   OLTP            Oracle Streams
    DB            Parallel transformation of data
               Oracle10g Business Intelligence
               Features
 Real Time Data               VLDB                            Summary Management                  OLAP
  Warehousing                      –   Bigfile Tablespace           –   Summary Management            –   Parallel AGGREGATE
   –   Asynchronous Change         –   Enhanced Partition               OLAP Query Performance            Command
       Data Capture                    Management in Enterprise         Improvements                  –   Parallel SQL IMPORT
   –                                   Manager                      –   Summary Management -              Command
       Cross-Platform
       Transportable               –   Global Partitioned Indexes       Enhanced Partition-aware      –   PL/SQL Creation of
       Tablespaces                     - Hash Partitioning              Materialized View Refresh         Analytic Workspaces
   –                               –                                –   Summary Management -          –
       Enhanced Table                  Partitioned Index-                                                 Intra-Dimensional
       Functions                       Organized Tables - List          EXPLAIN PLAN Shows                (Attribute) Aggregation
   –   External Tables Unload          Partitioning                     Materialized View Access      –   Enhanced Composite
   –                               –   Partitioned Index-           –   Summary Management -              Dimensions Indexing
       Enhanced MERGE
       Functionality                   Organized Tables - LOB           Enhanced Dimensions           –   PL/SQL OLAP Measure
                                       Support                      –   Summary Management -
   –   Data Pump Export and                                                                               Calculation Definition
       Import Utilities            –   Partitioned Index-               Nested Materialized View      –   Complete Analytical
   –                                   Organized Tables - Global        Refresh                           Workspace Management
       Parallel Data Pump Export
                                       Index Maintenance            –   Summary Management -
       and Import                                                                                     –   Multi-Writer Support
                                   –   Enhanced Bitmap Index            Enhanced PCT Refresh
   –   SQL*Loader Direct Path                                                                         –   XML Interface for Analytic
                                       Performance and Space        –   Summary Management -
       Load Support for ROWID                                                                             Workspace
       Datatype                        Management                       Query Rewrite Uses
   –
                                   –   Local Partitioned Indexes        Multiple Materialized
       SQL*Loader Direct Path                                           Views
       Load Support for VARRAY         Manageability
       Datatype                        Improvements
   –   SQL*Loader Direct Path
       Load Support for
       XMLType Tables
               Oracle10g Business Intelligence
               Features
 Real Time Data               VLDB                            Summary Management                  OLAP
  Warehousing                      –   Bigfile Tablespace           –   Summary Management            –   Parallel AGGREGATE
   –   Asynchronous Change         –   Enhanced Partition               OLAP Query Performance            Command
       Data Capture                    Management in Enterprise         Improvements                  –   Parallel SQL IMPORT
   –                                   Manager                      –   Summary Management -              Command
       Cross-Platform
       Transportable               –   Global Partitioned Indexes       Enhanced Partition-aware      –   PL/SQL Creation of
       Tablespaces                     - Hash Partitioning              Materialized View Refresh         Analytic Workspaces
   –                               –                                –   Summary Management -          –
       Enhanced Table                  Partitioned Index-                                                 Intra-Dimensional
       Functions                       Organized Tables - List          EXPLAIN PLAN Shows                (Attribute) Aggregation
   –   External Tables Unload          Partitioning                     Materialized View Access      –   Enhanced Composite
   –                               –   Partitioned Index-           –   Summary Management -              Dimensions Indexing
       Enhanced MERGE
       Functionality                   Organized Tables - LOB           Enhanced Dimensions           –   PL/SQL OLAP Measure
                                       Support                      –   Summary Management -
   –   Data Pump Export and                                                                               Calculation Definition
       Import Utilities            –   Partitioned Index-               Nested Materialized View      –   Complete Analytical
   –                                   Organized Tables - Global        Refresh                           Workspace Management
       Parallel Data Pump Export
                                       Index Maintenance            –   Summary Management -
       and Import                                                                                     –   Multi-Writer Support
                                   –   Enhanced Bitmap Index            Enhanced PCT Refresh
   –   SQL*Loader Direct Path                                                                         –   XML Interface for Analytic
                                       Performance and Space        –   Summary Management -
       Load Support for ROWID                                                                             Workspace
       Datatype                        Management                       Query Rewrite Uses
   –
                                   –   Local Partitioned Indexes        Multiple Materialized
       SQL*Loader Direct Path                                           Views
       Load Support for VARRAY         Manageability
       Datatype                        Improvements
   –   SQL*Loader Direct Path
       Load Support for
       XMLType Tables
              Oracle10g Business Intelligence
              Features (Continued)
 Data Mining                 Bio-informatics
   –                             – DOUBLE and FLOAT
       Frequent Itemsets
   –
                                   Datatypes
       Attribute Importance
                                 – BLAST Queries
       Algorithms
                                 – Statistical Functions
   –   Enhanced Adaptive Bayes
                                 – Document Clustering
       Network
                                 – Document Clustering Non-
   –   JSR-73 RI & TCK - Java      negative Matrix
       Data Mining                 Factorization
   –   Multi-User Access Control – Document Clustering
   –   Complete Oracle Data        Neural Nets
       Mining Management         – Document Named Entity
   –   Enhanced Model Seeker       Extraction
                                 – Support Vector Machines
   –   PMML Producers /
                                 – Taxonomy Builder
       Consumers
   –   Enhanced Data           SQL Analytics
       Preprocessing             – Grouped Table Outer Join

   –                             – Increased Number of
       Data Mining Rapid
       Application Development     Aggregates per Query
                                 – SQL Interrow Calculations
                                 – Upsert Through SQL
                                   Interrow Calculations
              Oracle10g Business Intelligence
              Features (Continued)
 Data Mining                 Bio-informatics
   –                             – DOUBLE and FLOAT
       Frequent Itemsets
   –
                                   Datatypes
       Attribute Importance
                                 – BLAST Queries
       Algorithms
                                 – Statistical Functions
   –   Enhanced Adaptive Bayes
                                 – Document Clustering
       Network
                                 – Document Clustering Non-
   –   JSR-73 RI & TCK - Java      negative Matrix
       Data Mining                 Factorization
   –   Multi-User Access Control – Document Clustering
   –   Complete Oracle Data        Neural Nets
       Mining Management         – Document Named Entity
   –   Enhanced Model Seeker       Extraction
                                 – Support Vector Machines
   –   PMML Producers /
                                 – Taxonomy Builder
       Consumers
   –   Enhanced Data           SQL Analytics
       Preprocessing             – Grouped Table Outer Join

   –                             – Increased Number of
       Data Mining Rapid
       Application Development     Aggregates per Query
                                 – SQL Interrow Calculations
                                 – Upsert Through SQL
                                   Interrow Calculations
Oracle Database 10g –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
       Application Development on the Grid

 Improved PL/SQL
  Performance
 Database Web
  Services
 HTML DB
   –   Low Cost, Hosted,
       Web Based
       Development
       Environment
     HTML DB and the Grid - Business
     Problem
 Departmental and LOB data
  sharing and information
  tracking
 Lots and lots of desktop
  databases
 Fragmented
 Inaccurate
 Untimely
 Vulnerable
   HTML DB – the Perfect “Killer App”
   for the Grid ?

 Productivity of a
  Desktop Database
 Infrastructure of an
  Enterprise Database
 Built for the Web
 Leverages the Grid
Thank You
Questions and Answers ?

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:32
posted:6/27/2011
language:English
pages:55