Oracle Exadata

Last updated
Oracle Exadata
Original author(s) Oracle Corporation
Initial releaseOctober 2008
Operating system Oracle Linux
Platform Exadata Database Machine
License Commercial
Website www.oracle.com/exadata
Larry Ellison and a Exadata (2009) Larry Ellison and Exadata.jpg
Larry Ellison and a Exadata (2009)

The Oracle ExadataDatabase Machine (Exadata [1] ) is a computing platform optimized for running Oracle Databases.

Contents

Exadata is a combined hardware and software platform that includes scale-out x86-64 computer and storage servers, RoCE networking, RDMA-addressable memory acceleration, NVMe flash, and specialized software. [2]

Exadata was introduced in 2008 for on-premises deployment, and since October 2015, via the Oracle Cloud as a subscription service, known as the Exadata Database Service. [3]

Use cases

Exadata is designed to run Oracle Database workloads, such as an OLTP application running simultaneously with Analytics processing. Historically, specialized database computing platforms were designed for a particular workload, such as Data Warehousing, and poor or unusable for other workloads, such as OLTP. Exadata allows mixed workloads to share system resources fairly with resource management features allowing prioritized allocation, such as always favoring workloads servicing interactive users over reporting and batch, even if they are accessing the same data. Long running requests, characterized by Data Warehouses, reports, batch jobs and Analytics, are reputed to run many times faster compared to a conventional, non-Exadata database server. [2] [4] [5]

Release History

Exadata ReleasePrimary Software EnhancementsPrimary Hardware Enhancements
X10M - June 2023Exadata RDMA Memory (XRMEM) DRAM cache3x increase in compute cores (96-core AMD EPYC)
Oracle Linux 8 and UEK 6 kernel updates1.5x higher memory capacity
New In-Memory Columnar compression algorithm2.5x faster DDR5 memory
Optimized Smart Scan for more complex queries2.4x higher flash storage capacity (in all-flash storage)
Faster decryption and decompression22% more disk storage capacity
X9M - Sept, 2021Secure RDMA fabric isolationPCIe 4.0 dual-port active-active 100Gb RoCE network
Smart Flash Log write-back33% increase in compute cores
Storage Index and Columnar Cache persistence33% increase in memory capacity
Faster decryption and decompression Algorithms28% increase in disk capacity
Smart Scan performance optimizations1.8x greater internal fabric bandwidth (PCIe 4.0)
1.8x greater flash bandwidth (PCIe 4.0)
X8M - Sept, 2019RoCE: RDMA over Converged EthernetPersistent Memory (PMEM) in storage
Persistent Memory Data Accelerator100 Gbit/s internal fabric (2.5x increase)
Persistent Memory Commit Accelerator
KVM virtual machine support
X8 - April, 2019AIDE: Advanced Intrusion Detection EnvironmentStorage Server Extended (XT)
ML-based monitoring and auto-indexing40% increase in disk capacity
Real-time updates of optimizer statistics60% increase in storage processor cores
X7 - Oct, 2017In-memory database in flash storage2x increase in flash capacity
DRAM cache in storage25% increase in disk capacity
Large-scale storage software updates25 Gbit/s data center Ethernet support
Exadata Cloud@CustomerExadata Cloud Service on-premises
X6 - April, 2016Exafusion direct-to-wire OLTP protocol2x increase in flash capacity
Smart Fusion Block Transfer10% increase in compute cores
Smart Flash Log2x increase in memory capacity
Exadata Cloud ServiceExadata on Oracle Cloud Infrastructure (OCI)
X5 - Dec, 2014In-memory database fault tolerance2x increase in flash & disk capacity
Database snapshotsElastic configurations
Xen virtual machine supportAll-flash storage server option
NVMe flash protocol support50% increase in compute cores
IPv6 support50% increase in memory capacity
X4 - Nov, 2013Network Resource Management2x increase in flash capacity
I/O latency capping2x increase in memory capacity
Capacity-on-Demand licensing50% increase in compute cores
Active/Active InfiniBand (2x increase)33% increase in disk capacity
X3 - Sept, 2013Smart Flash Cache write-backEighth-Rack configuration
Improved management of slow disks/flash4x increase in flash capacity
Sub-second brownout after storage failure33% increase in compute cores
Simplified disk replacement75% increase in memory capacity
Bypass predictive disk failure2x increase in data center bandwidth
X2 - Sept, 2010Smart Flash Log8-socket (X2-8) configuration
Auto Service RequestStorage Expansion Rack
Secure Erase of storageHardware-based decryption
Platinum Services50% increase in compute cores
2x increase in memory capacity
50% increase in disk capacity
8x increase in data center bandwidth
v2 - Sept, 2009Storage IndexesFlash storage
Database-aware Smart Flash CacheQuarter-Rack configuration
Hybrid Columnar Compression2x increase in memory & disk capacity
3x increase in data center bandwidth
40 Gbit/s internal fabric (2x increase)
v1 - Sept, 2008Oracle Enterprise LinuxScale-out 4-socket compute servers
Smart Scan (storage offload)Scale-out 4-socket storage servers
IORM (I/O Resource Manager)20 Gbit/s internal fabric (InfiniBand)
Join filtering (Bloom filters)1 Terabyte disks
Incremental backup filtering1 Gbit/s data center network (Ethernet)
Smart file creation

Support Policy

As the platform has been around since 2008, Oracle has published information related to the end-of-support for older Exadata generations. In Oracle's published document titled Oracle Hardware and Systems Support Policies, [6] they mention "After five years from last ship date, replacement parts may not be available and/or the response times for sending replacement parts may be delayed." To look up the "last ship date" of a particular Oracle Exadata generation, Oracle published a document titled Oracle Exadata - A guide for decision makers. [7]

Related Research Articles

<span class="mw-page-title-main">Oracle Corporation</span> American multinational computer corporation

Oracle Corporation is an American multinational computer technology company headquartered in Austin, Texas, United States. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells database software and technology, cloud engineered systems, and enterprise software products, such as enterprise resource planning (ERP) software, human capital management (HCM) software, customer relationship management (CRM) software, enterprise performance management (EPM) software, and supply chain management (SCM) software.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.

Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.

Software as a service is a software licensing and delivery model in which software is licensed on a subscription basis and is centrally hosted. SaaS is also known as on-demand software, web-based software, or web-hosted software.

Online transaction processing (OLTP) is a type of database system used in transaction-oriented applications, such as many operational systems. "Online" refers to that such systems are expected to respond to user requests and process them in real-time. The term is contrasted with online analytical processing (OLAP) which instead focuses on data analysis.

In database computing, Oracle Real Application Clusters (RAC) — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle database environments. Oracle Corporation includes RAC with the Enterprise Edition, provided the nodes are clustered using Oracle Clusterware.

SAP IQ is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts. Produced by Sybase Inc., now an SAP company, its primary function is to analyze large amounts of data in a low-cost, highly available environment. SAP IQ is often credited with pioneering the commercialization of column-store technology.

In computing, the term data warehouse appliance (DWA) was coined by Foster Hinshaw for a computer architecture for data warehouses (DW) specifically marketed for big data analysis and discovery that is simple to use and has a high performance for the workload. A DWA includes an integrated set of servers, storage, operating systems, and databases.

<span class="mw-page-title-main">Netezza</span> Provider of Integrated Data Warehouse Hardware and Software

IBM Netezza is a subsidiary of American technology company IBM that designs and markets high-performance data warehouse appliances and advanced analytics applications for uses including enterprise data warehousing, business intelligence, predictive analytics and business continuity planning.

<span class="mw-page-title-main">Cloud computing</span> Form of shared Internet-based computing

Cloud computing is the on-demand availability of computer system resources, especially data storage and computing power, without direct active management by the user. Large clouds often have functions distributed over multiple locations, each of which is a data center. Cloud computing relies on sharing of resources to achieve coherence and typically uses a pay-as-you-go model, which can help in reducing capital expenses but may also lead to unexpected operating expenses for users.

<span class="mw-page-title-main">Vertica</span> Software company

Vertica is an analytic database management software company. Vertica was founded in 2005 by the database researcher Michael Stonebraker with Andrew Palmer as the founding CEO. Ralph Breslauer and Christopher P. Lynch served as CEOs later on.

Exalogic is a computer appliance made by Oracle Corporation, commercially available since 2010. It is a cluster of x86-64-servers running Oracle Linux or Solaris preinstalled.

<span class="mw-page-title-main">PureSystems</span>

PureSystems is an IBM product line of factory pre-configured components and servers also being referred to as an "Expert Integrated System". The centrepiece of PureSystems is the IBM Flex System Manager in tandem with the so-called "Patterns of Expertise" for the automated configuration and management of PureSystems.

HP ConvergedSystem is a portfolio of system-based products from Hewlett-Packard (HP) that integrates preconfigured IT components into systems for virtualization, cloud computing, big data, collaboration, converged management, and client virtualization. Composed of servers, storage, networking, and integrated software and services, the systems are designed to address the cost and complexity of data center operations and maintenance by pulling the IT components together into a single resource pool so they are easier to manage and faster to deploy. Where previously it would take three to six months from the time of order to get a system up and running, it now reportedly takes as few as 20 days with the HP ConvergedSystem.

<span class="mw-page-title-main">SingleStore</span>

SingleStore is a proprietary, cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system (RDBMS) that features ANSI SQL support, it is known for speed in data ingest, transaction processing, and query processing.

<span class="mw-page-title-main">SAP HANA</span> Database management system by SAP

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as the software running a database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics and includes extract, transform, load (ETL) capabilities as well as an application server.

Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that provides a series of modular cloud services including computing, data storage, data analytics and machine learning, alongside a set of management tools. It runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, and Google Docs, according to Verma, et.al. Registration requires a credit card or bank account details.

Cloud management is the management of cloud computing products and services.

Serverless computing is a cloud computing execution model in which the cloud provider allocates machine resources on demand, taking care of the servers on behalf of their customers. "Serverless" is a misnomer in the sense that servers are still used by cloud service providers to execute code for developers. However, developers of serverless applications are not concerned with capacity planning, configuration, management, maintenance, fault tolerance, or scaling of containers, VMs, or physical servers. Serverless computing does not hold resources in volatile memory; computing is rather done in short bursts with the results persisted to storage. When an app is not in use, there are no computing resources allocated to the app. Pricing is based on the actual amount of resources consumed by an application. It can be a form of utility computing.

<span class="mw-page-title-main">Oracle Cloud</span> Cloud computing service

Oracle Cloud is a cloud computing service offered by Oracle Corporation providing servers, storage, network, applications and services through a global network of Oracle Corporation managed data centers. The company allows these services to be provisioned on demand over the Internet.

References

  1. ↑ Various (June 2023). "Oracle Exadata Database Machine X10M" (PDF). oracle.com. Retrieved June 22, 2023.
  2. 1 2 Pedregal-Martin, Cristobal. "Exadata: Why and What".
  3. ↑ Spendolini, Brian (2019). Oracle Database Exadata Cloud Service: A Beginner's Guide. Amazon.com: Oracle Press. ISBN   978-1260120875.
  4. ↑ "Exadata Customer Success Stories" . Retrieved July 16, 2018.
  5. ↑ Various. "Gartner Peer Insights: Oracle Exadata Database Machine". Gartner.com. Retrieved August 8, 2018.
  6. ↑ "Oracle Hardware and Systems Support Policies" (PDF). Retrieved March 5, 2021.
  7. ↑ "Oracle Exadata - A guide for decision makers" (PDF). Retrieved December 1, 2020.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.