Oracle Exadata

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

Oracle Exadata (Exadata [1] ) is a computing system optimized for running Oracle Databases.

Contents

Exadata is a combined hardware and software platform that includes scale-out x86-64 compute 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 on Dedicated Infrastructure, [3] and Exadata Database Service on Exascale Infrastructure. [4] Exadata Cloud@Customer [5] is a hybrid cloud (on-premises) deployment of Exadata Database Service.

Starting December, 2023, Exadata Database Service became available for Microsoft Azure, Google and AWS public clouds within the Oracle Database@Azure, Oracle Database@Google Cloud and Oracle Database@AWS multicloud partnerships.

Use cases

Exadata is designed to run all Oracle Database workloads, such as OLTP, Data Warehousing, Analytics, and AI Vector processing, often with multiple consolidated databases running simultaneously.

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 specializes in mixed workloads sharing system resources with resource management features for prioritization, such as favoring workloads servicing interactive users over reporting and batch. Long running requests, characterized by Data Warehouses, reports, batch jobs and Analytics, are reported to run many times faster compared to a conventional, non-Exadata database server. [6] [7]

Release History

Exadata ReleasePrimary Software EnhancementsPrimary Hardware Enhancements
Database@AWSExadata Database Service available with AWS
X11M - Jan 2025AI Vector search acceleration - up to 55% faster25% faster compute core performance
Analytics scan throughput increase - 2.2x faster33% greater server memory bandwidth
Transaction processing acceleration - 25% faster11% faster storage core performance
OLTP read latency acceleration - up to 21% faster (14 microseconds)PCIe 5 performance-optimized flash
Intelligent power management - reduce CPU cores, cap power consumption, optimize power utilizationX11M-Z database and storage servers
Available on-premises, Oracle Cloud, Cloud@Customer and multicloud (Azure, Google Cloud, AWS)
Database@Google CloudExadata Database Service available with Google Cloud
Exadata Exascale

July, 2024

Fully elastic pay-per-use architecture. Users specify the cores and storage capacity needed, reducing entry-level infrastructure costs for Exadata Database Service and aligning costs with usageNone
Large pools of shared compute and storage allow databases to quickly scale over time without concern for server-based size limitations or disruptive migrations
Rapid and efficient database snapshots and thin cloning
Database@AzureExadata Database Service available with Microsoft Azure
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 100 Gb 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 Database 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, [8] 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. [9]

Each generation of the Oracle Zero Data Loss Recovery Appliance shares components with similar generations of Exadata.

Related Research Articles

Oracle Corporation is an American multinational computer technology company headquartered in Austin, Texas. Co-founded in 1977 by Larry Ellison, who remains executive chairman, Oracle was the third-largest software company in the world in 2020 by revenue and market capitalization. The company's 2023 ranking in the Forbes Global 2000 was 80.

<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 DB2 until 2017, when it changed to its present form. In the early days, it was sometimes wrongly styled as DB/2 in a false derivation from the operating system OS/2.

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

<span class="mw-page-title-main">Amazon Web Services</span> On-demand cloud computing company

Amazon Web Services, Inc. (AWS) is a subsidiary of Amazon that provides on-demand cloud computing platforms and APIs to individuals, companies, and governments, on a metered, pay-as-you-go basis. Clients will often use this in combination with autoscaling. These cloud computing web services provide various services related to networking, compute, storage, middleware, IoT and other processing capacity, as well as software tools via AWS server farms. This frees clients from managing, scaling, and patching hardware and operating systems. One of the foundational services is Amazon Elastic Compute Cloud (EC2), which allows users to have at their disposal a virtual cluster of computers, with extremely high availability, which can be interacted with over the internet via REST APIs, a CLI or the AWS console. AWS's virtual computers emulate most of the attributes of a real computer, including hardware central processing units (CPUs) and graphics processing units (GPUs) for processing; local/RAM memory; hard-disk (HDD)/SSD storage; a choice of operating systems; networking; and pre-loaded application software such as web servers, databases, and customer relationship management (CRM).

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">Univa</span> Software company

Univa was a software company that developed workload management and cloud management products for compute-intensive applications in the data center and across public, private, and hybrid clouds, before being acquired by Altair Engineering in September 2020.

<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 the most demanding analytic 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 "a paradigm for enabling network access to a scalable and elastic pool of shareable physical or virtual resources with self-service provisioning and administration on-demand," according to ISO.

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

<span class="mw-page-title-main">AppScale</span> American cloud infrastructure software company

AppScale is a software company that offers cloud infrastructure software and services to enterprises, government agencies, contractors, and third-party service providers. The company commercially supports one software product, AppScale ATS, a managed hybrid cloud infrastructure software platform that emulates the core AWS APIs. In 2019, the company ended commercial support for its open-source serverless computing platform AppScale GTS, but AppScale GTS source code remains freely available to the open-source community.

<span class="mw-page-title-main">Data processing unit</span> Programmable electronic component

A data processing unit (DPU) is a programmable computer processor that tightly integrates a general-purpose CPU with network interface hardware. Sometimes they are called "IPUs" or "SmartNICs". They can be used in place of traditional NICs to relieve the main CPU of complex networking responsibilities and other "infrastructural" duties; although their features vary, they may be used to perform encryption/decryption, serve as a firewall, handle TCP/IP, process HTTP requests, or even function as a hypervisor or storage controller. These devices can be attractive to cloud computing providers whose servers might otherwise spend a significant amount of CPU time on these tasks, cutting into the cycles they can provide to guests.

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel, to handle large scale data sets and database migrations. Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on big data data sets stored by a column-oriented DBMS principle. Redshift allows up to 16 petabytes of data on a cluster.

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

Cloud computing enables users to access scalable and on-demand computing resources via the internet, utilizing hardware and software virtualization. It is a rapidly evolving technology capable of delivering extensible services efficiently, supporting a wide range of applications from personal storage solutions to enterprise-level systems. Despite its advantages, cloud computing also faces several challenges. Privacy concerns remain a primary issue, as users often lose direct control over their data once it is stored on servers owned and managed by cloud providers. This loss of control can create uncertainties regarding data privacy, unauthorized access, and compliance with regional regulations such as the General Data Protection Regulation (GDPR), the Health Insurance Portability and Accountability Act (HIPAA), and the California Consumer Privacy Act (CCPA). Service agreements and shared responsibility models define the boundaries of control and accountability between the cloud provider and the customer, but misunderstandings or mismanagement in these areas can still result in security breaches or accidental data loss. Cloud providers offer tools, such as AWS Artifact, Azure Compliance Manager, and Google Assured Workloads, to assist customers in managing compliance requirements.

Hybrid transaction/analytical processing (HTAP) is a term created by Gartner Inc., an information technology research and advisory company, in its early 2014 research report Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation. As defined by Gartner:

Hybrid transaction/analytical processing (HTAP) is an emerging application architecture that "breaks the wall" between transaction processing and analytics. It enables more informed and "in business real time" decision making.

Autoscaling, also spelled auto scaling or auto-scaling, and sometimes also called automatic scaling, is a method used in cloud computing that dynamically adjusts the amount of computational resources in a server farm - typically measured by the number of active servers - automatically based on the load on the farm. For example, the number of servers running behind a web application may be increased or decreased automatically based on the number of active users on the site. Since such metrics may change dramatically throughout the course of the day, and servers are a limited resource that cost money to run even while idle, there is often an incentive to run "just enough" servers to support the current load while still being able to support sudden and large spikes in activity. Autoscaling is helpful for such needs, as it can reduce the number of active servers when activity is low, and launch new servers when activity is high. Autoscaling is closely related to, and builds upon, the idea of load balancing.

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

<span class="mw-page-title-main">IBM Cloud</span> Cloud computing services provided by IBM

IBM Cloud is a set of cloud computing services for business offered by the information technology company IBM.

<span class="mw-page-title-main">Ampere Computing</span> American fabless semiconductor company

Ampere Computing LLC is an American fabless semiconductor company based in Santa Clara, California that develops processors for servers operating in large scale environments. It was founded in 2017 by Renée James.

AWS Graviton is a family of 64-bit ARM-based CPUs designed by the Amazon Web Services (AWS) subsidiary Annapurna Labs. The processor family is distinguished by its lower energy use relative to x86-64, static clock rates, and lack of simultaneous multithreading. It was designed to be tightly integrated with AWS servers and datacenters, and is not sold outside Amazon.

References

  1. ↑ Various (July 11, 2024). "Oracle Exadata". oracle.com. Retrieved July 11, 2024.
  2. ↑ Pedregal-Martin, Cristobal. "Exadata: Why and What".
  3. ↑ Various (July 11, 2024). "Oracle Exadata Database Service on Dedicated Infrastructure". oracle.com. Retrieved July 11, 2024.
  4. ↑ Various (July 11, 2024). "Exadata Database Service on Exascale Infrastructure". oracle.com. Retrieved July 11, 2024.
  5. ↑ Various (July 11, 2024). "Oracle Exadata Cloud@Customer". oracle.com. Retrieved July 11, 2024.
  6. ↑ Various (July 11, 2024). "Exadata Customer Success Stories". oracle.com. Retrieved July 11, 2024.
  7. ↑ Various (July 11, 2024). "Gartner Peer Insights: Oracle Exadata Database Machine". Gartner.com. Retrieved July 11, 2024.
  8. ↑ "Oracle Hardware and Systems Support Policies" (PDF). Retrieved March 5, 2021.
  9. ↑ Various. "Oracle Exadata - A guide for decision makers" (PDF). oracle.com. Retrieved July 11, 2024.
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.