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.

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
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 migrationsNone
Rapid and efficient database snapshots and thin cloningNone
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 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, [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]

Related Research Articles

Oracle Corporation is an American multinational computer technology company headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. In 2023, the company’s seat in Forbes Global 2000 was 80. The company sells database software and cloud computing. Oracle's core application software is a suite of 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, Customer Experience Commerce 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 DB2 until 2017, when it changed to its present form.

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

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.

<span class="mw-page-title-main">Oracle Linux</span> Linux distribution by Oracle

Oracle Linux is a Linux distribution packaged and freely distributed by Oracle, available partially under the GNU General Public License since late 2006. It is compiled from Red Hat Enterprise Linux (RHEL) source code, replacing Red Hat branding with Oracle's. It is also used by Oracle Cloud and Oracle Engineered Systems such as Oracle Exadata and others.

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

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> Database management system

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.

Cloud-based integration is a form of systems integration business delivered as a cloud computing service that addresses data, process, service-oriented architecture (SOA) and application integration.

<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 management is the management of cloud computing products and services.

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.

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, virtual machines, or physical servers. 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.

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

<span class="mw-page-title-main">TPC-C</span> Benchmark used to compare the performance of OLTP systems

TPC-C, short for Transaction Processing Performance Council Benchmark C, is a benchmark used to compare the performance of online transaction processing (OLTP) systems. This industry standard was published in August 1992, and eventually replaced the earlier TPC-A, which was declared obsolete in 1995. It has undergone a number of changes to keep it relevant as computer performance grew by several orders of magnitude, with the current version as of 2021, 5.11, released in 2010. In 2006, a newer OLTP benchmark was added to the suite, TPC-E, but TPC-C remains in widespread use.

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.