1 / 25

Exadata X3 Database In-Memory Machine

donar
Download Presentation

Exadata X3 Database In-Memory Machine

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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.

  2. Exadata X3 Database In-Memory Machine Henry HanDirector, Oracle

  3. Oracle Exadata Database Machine • Best Platform for… • Data Warehousing • OLTP • Database Cloud Oracle’s strategic platform for ALL Database workloads

  4. Exadata Architecture Complete Database platform using standard servers for Compute and Storage • Scale-Out Database Servers • 8x 2-socket, or 2x 8-socket Xeondatabase servers • Oracle Database, ASM, RAC; Linux or Solaris • Standard Ethernet to data center • Scale-Out Intelligent Storage Servers • 2-socket storage servers, Exadata Storage Software • Up to 500 terabytes disk per rack • 56 PCI Flash memory cards per rack • InfiniBand Network • Unified internal connectivity ( 40 Gb/sec )

  5. Highly Engineered and Standardized Less Risk, Better Results • Hundreds of engineer years spent optimizing and hardening the system end-to-end • Frees I/T talent to focus on business needs • Standard platform improves support experience • Runs all existing Oracle Database workloads Ready- to-Run

  6. 24/7 support Specialized Engineered Systems Support Team 2-hour onsite response to hardware issues1 New Updates and Upgrades for Database, Server, Storage, and OS software My Oracle Support proactive support portal "Phone home" automated service requests (ASR) Better support for the complete Oracle stack Includes higher support levels for Database software Proactive remote monitoring for faults Industry leading service level response times: 5 Minute Fault Notification 15 Minute Restoration or Escalation to Development 30 Minute Joint Debugging with Development Oracle Engineers perform quarterly patching and updates Available for recent configurations on Exadata Superior Database & Exadata Support ORACLE PLATINUM SERVICES Complete. Integrated. Proactive. High Availability. No Additional Cost. 1 Covered system must be within an Oracle two-hour service area to receive two-hour response as a standard service.

  7. Key Exadata InnovationsExtreme Performance at Lowest Cost • Smart Scale-Out Storage • InfiniBand connected servers • Smart Scan query offload • Hybrid Columnar Compression • 10x compression for warehouses • 15x compression for archives uncompressed + + + Data remains compressed for scans and in Flash compress • Smart PCI Flash Cache • Transparent cache in front of disk • Accelerates random I/O up to 30x • Quadruples data scan rate primary DB Space Savings Cascade to Copies standby dev test backup

  8. 1000s of Deployments at Leading Companies Half are Warehouses, Half are OLTP or Mixed Workloads • Petabyte Warehouses • SAP, E-business Suite, PeopleSoft, Siebel, JDE • Regulatory Reporting • Online Financial Trading • E-Commerce Sites • Consolidation of 100s of Databases

  9. Exadata Evolution X2-8 2010 V2 2009 V1 2008 Warehouse OLTP & VLDB Scale-Up Smart Storage InfiniBand Scale-Out Flash Columnar 80-core SMPs

  10. Exadata X3 | Database In-Memory Machine X3 2012 2009 2010 2008 Massive Flash All I/Os to Flash Scale-Up OLTP & VLDB Warehouse Database On Disk Database In-Memory

  11. Exadata X3 Database In-Memory Machine 2 or 4 TB DRAM • X3 mass memory hierarchy delivers extreme performance • Automatically moves all active data from disk to memory • DRAM memory expanded to 2 or 4 TB for hottest data • 4 to 40 TB of compressed user data • Flash memory expanded 4X to 22 TBper rack • 40 to 200 TB of compressed user data – ALL active data • 1.5 Million SQL random read I/Os per second for OLTP • Comparable to 15,000 disk drives in 150 array frames • 100 GB/sec SQL data scan rate for reporting and warehouses • Comparable to 1,000 disk drives in 10 array frames Hottest Data 22 TB PCI FLASH Active Data 500 TB DISK Cold Data

  12. Exadata Smart Flash CacheWrite-Back Cache Accelerates Write Performance 20X 1 Million 8K flash write IOPs from SQL • New software caches write I/Os in flash memory • Now all reads and writes of active data go to flash • 1 Million 8K flash write I/Os per second on an X3 rack • Comparable to 10,000 disks on 100 array frames • 20X more writes than previous Exadata version • New software also provides 10x write improvement on existing V2 and X2 systems • Cache is persistent and fully redundant • Also improves database availability by accelerating write intensive recovery

  13. Exadata Flash Performance Scales Linearly Storage Array Architecture Limits Flash Performance • Exadata scales using • True Scale-Out • InfiniBand • Smart Storage 100 Query Throughput Gigabytes per Second

  14. Extreme Performance and Low Cost • Extreme Performance dramatically lowers cost • Workloads that require huge traditional systems run on small Exadatas • Hardware needed for an application is often reduced 10x • Exadata also delivers Extreme Capacity • Huge disk footprint for large or less active data • 500 TB of disk per rack for historical data, low activity data, images, documents, backups, etc. • Columnar compression expands disk and memory capacity 10x • Blend of tiers gives highest performance at lowest cost • Placing all data in DRAM would cost $20M just for chips Disks for Capacity Flash for I/Os DRAM for Throughput Cost of DiskI/Os of FlashSpeed of DRAM

  15. Business Benefits of Database In-Memory Machine • Sub-millisecond latency • Interactive OLTP with millions of users • Sub-second analytics • Real-time decision making, instant reports • 10x faster parallel jobs • Quarter close, payroll, supply planning, field inventory, pricing, route planning, sub-ledger accounting Hottest Data Active Data Cold Data

  16. Exadata Database Cloud HR • Exadata has the unique ability to run many databases supporting multiple workloads in a single cloud platform • High-end OLTP, Warehousing, batch, reporting, backups, … • All at the same time • X3 database in-memory delivers extreme performance for all workloads • Also prevents one workload from overloading disks leading to poor performance for all EDW CRM ERP Supply Chain All Workloads, All Applications SAP, Siebel, PeopleSoft, JDE,E-business Suite, Fusion Applications Data Mart

  17. Exadata X3 Details Faster Bigger All X3 Database Machines • Same Architecture as Exadata X2 • Same Price as Exadata X2 22 TBof Flash Memory per Rack 4X Larger Flash Memory Exadata Smart Flash Write Caching 20X More Write Performance 33% More Data Throughput 100 GB/sec running SQL 10% to 30% Lower Power Up to 3 Kilowatt Reduction per Rack X3-2 Database Servers 8-CoreXeon® SandyBridge E5-2690 33% Faster Database CPUs 75% More Memory 1 TB to 2 TB per Rack 40X 10Gb ports per Rack Full 10Gb Ethernet to Data Center 10% to 20% Lower Power

  18. Seamless Upgrades and Expansions Upgrade Example X3-2 Half to Full Upgrade in 2012 • A single Database Machine can have servers from different generations • Databases and Clusters can span across multiple hardware generations • New software runs on older hardware X2-2 Qtr to Half Upgrade in 2011 V2 Initial Quarter Rack deployed in 2010

  19. Introducing Exadata Eighth Rack X3

  20. NEWExadata X3-2 Eighth Rack Faster Than 2010 Quarter-Rack, 2008 Half-Rack LowestCost • Lowest Cost Exadata Configuration • Hardware List price $200K: 60% of Quarter Rack • 16 Database Cores, 54 TB Disk, 2.4 TB PCI Flash • Highly Available configuration with all Exadata features • Brings Exadata Extreme Performance to smaller workloads, development, test, disaster recovery • Hardware Identical to Quarter-Rack • Half CPU Cores, Disks, and Flash Cards Disabled • Half the Database and Exadata Software Licenses • Upgrade to Quarter-Rack with software command

  21. Complete Family of Database Machines Oracle Exadata X3-22, 4, and 8 database nodes Oracle Exadata X3-82 (80 core) database nodes4 TB DRAM Eighth Quarter Half Full Multi-Rack Field UpgradeableSupports Multiple Generations of Hardware

  22. Summary • 4th Generation Database Machine • X3 Database In-Memory Machine • All Active Data in Memory • Exadata Database Cloud • New Entry-level Eighth Rack X3

More Related