Oracle Database

Template:For

Template:Short description Template:Use dmy dates {{#invoke:Infobox|infobox}}Template:Template other{{#invoke:Check for unknown parameters | check | showblankpositional=1 | unknown = Template:Main other | preview = Page using Template:Infobox software with unknown parameter "_VALUE_"|ignoreblank=y | AsOf | author | background | bodystyle | caption | collapsetext | collapsible | developer | discontinued | engine | engines | genre | included with | language | language count | language footnote | latest preview date | latest preview version | latest release date | latest release version | latest_preview_date | latest_preview_version | latest_release_date | latest_release_version | licence | license | logo | logo alt | logo caption | logo upright | logo size | logo title | logo_alt | logo_caption | logo_upright | logo_size | logo_title | middleware | module | name | operating system | operating_system | other_names | platform | programming language | programming_language | released | replaced_by | replaces | repo | screenshot | screenshot alt | screenshot upright | screenshot size | screenshot title | screenshot_alt | screenshot_upright | screenshot_size | screenshot_title | service_name | size | standard | title | ver layout | website | qid }}Template:Main other

Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> database management system produced and marketed by Oracle Corporation.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-premises, on-cloud, or as a hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware (Exadata on-premises, on Oracle Cloud or at Cloud at Customer).<ref>Template:Citation</ref>

Oracle Database uses SQL for database updating and retrieval.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>

HistoryEdit

Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while formerly employed by Ampex;<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> CIA was Oracle's first customer. Ellison wanted his database to be compatible with IBM System R, but the company's Don Chamberlin declined to release its error codes.Template:R

Releases and versionsEdit

Oracle products follow a custom release-numbering and -naming convention. The "ai" in the current release, Oracle Database 23ai, stands for "Artificial Intelligence". Previous releases (e.g. Oracle Database 19c, 10g, and Oracle9i Database) have used suffixes of "c", "g", and "i" which stand for "Cloud", "Grid", and "Internet" respectively. Prior to the release of Oracle8i Database, no suffixes featured in Oracle Database naming conventions. There was no v1 of Oracle Database, as co-founder Larry Ellison "knew no one would want to buy version 1".<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref><ref name="rdbmsearlyyearsoh20070612">Template:Cite interview</ref> For some database releases, Oracle also provides an Express Edition (XE) that is free to use.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>Template:R

Oracle Database release numbering has used the following codes:

Oracle Database Version	Initial Release Version	Initial Release Date	Terminal Version	Marquee Features
Template:Version LTR = Long-Term Release, IR = Innovation Release
Template:Version	23.4.0	citation	CitationClass=web }}</ref> was released on Oracle Cloud Infrastructure (OCI) as cloud services, including OCI Exadata Database Service, OCI Exadata Database Cloud@Customer, and OCI Base Database Service. It is also available in Always Free Autonomous Database. Oracle Database 23c (previously released in 2023) was renamed to Oracle Database 23ai (23.4) due to the significant additional engineering effort to add features that bring AI capabilities to the data in Oracle Database. Oracle Database 23c (23.2 and 23.3) was released in 2023: April 2023 (Linux) Oracle Database Free - Developer Release<ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref> September 2023 Oracle Database on Base Database Service<ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref>		citation	CitationClass=web }}</ref> (includes new Vector data type, Vector indexes, and Vector SQL operators/functions), JSON Relational Duality,<ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref> JSON Schema Validation, Transactional Microservices Support, OKafka, Operational Property Graphs, Support for SQL/PGQ, Schema Privileges, Developer Role, In-database SQL Firewall, TLS 1.3 Support, Integration with Azure Active Directory OAuth2, True Cache for mid-tier caching, Readable Per-PDB Standby, Globally Distributed Database with active-active RAFT-based replication, Real-time SQL Plan Management, Priority Transactions, SQL Syntax Simplification, Schema Annotations, Data Use Case Domains, Column Value Lock-free Reservations
Template:Version	21.1.0	citation	CitationClass=web }}</ref> August 2021 (Linux)<ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref>		Blockchain Tables, Multilingual Engine - JavaScript Execution in the Database, Binary JSON Data Type, Per-PDB Data Guard Physical Standby (aka Multitenant Data Guard), Per-PDB GoldenGate Change Capture, Self-Managing In-Memory, In-Memory Hybrid Columnar Scan, In-Memory Vector Joins with SIMD, Sharding Advisor Tool, Property Graph Visualization Studio, Automatic Materialized Views, Automatic Zone Maps, SQL Macros, Gradual Password Rollover
Template:Version	19.1.0 // 12.2.0.3	citation	CitationClass=web }}</ref> April 2019 (Linux)<ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref> June 2019 (cloud)		Active Data Guard DML Redirection, Automatic Index Creation, Real-Time Statistics Maintenance, SQL Queries on Object Stores, In-Memory for IoT Data Streams, Hybrid Partitioned Tables, Automatic SQL Plan Management, SQL Quarantine, Zero-Downtime Grid Infrastructure Patching, Finer-Granularity Supplemental Logging, Automated PDB Relocation
Template:Version	18.1.0 // 12.2.0.2	citation	CitationClass=web }}</ref> July 2018 (other)<ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref>	18.17.0 January 2022	Polymorphic Table Functions, Active Directory Integration, Transparent Application Continuity, Approximate Top-N Query Processing, PDB Snapshot Carousel, Online Merging of Partitions and Subpartitions
Template:Version	12.2.0.1 March 2017	August 2016 (cloud) March 2017 (on-premises)	12.2.0.1 March 2017	Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer
Template:Version	12.1.0.1	citation	CitationClass=web }}</ref>	12.1.0.2 July 2014	Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service
Template:Version	11.2.0.1	citation	CitationClass=web }}</ref>	11.2.0.4 August 2013	Edition-Based Redefinition, Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance
Template:Version	11.1.0.6	September 2007	11.1.0.7 September 2008	Active Data Guard, Secure Files, Exadata
Template:Version	10.2.0.1	citation	CitationClass=web }}</ref>	10.2.0.5 April 2010	Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Data Guard Fast-Start Failover, Transparent Data Encryption
Template:Version	10.1.0.2	2003	10.1.0.5 February 2006	Automated Database Management, Automatic Database Diagnostic Monitor, Grid infrastructure, Oracle ASM, Flashback Database
Template:Version	9.2.0.1	2002	9.2.0.8 April 2007	Advanced Queuing, Data Mining, Streams, Logical Standby
Template:Version	9.0.1.0	2001	9.0.1.5 December 2003	Oracle Real Application Clusters (RAC), Oracle XML DB
Template:Version	8.1.5.0	1998	8.1.7.4 August 2000	Native internet protocols and Java, Virtual Private Database
Template:Version	8.0.3	June 1997	8.0.6	Recovery Manager, Partitioning. First version available for Linux.<ref>Template:Cite magazine</ref>
Template:Version	7.3.0	February 1996	7.3.4	Object-relational database
Template:Version	7.2.0	May 1995		Shared Server, XA Transactions, Transparent Application Failover
Template:Version	7.1.0	May 1994		Parallel SQL Execution. First version available for Windows NT.<ref>Template:Cite magazine</ref>
Template:Version	7.0.12	June 1992		PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost-Based Optimizer
Template:Version	6.2.0			Oracle Parallel Server
Template:Version	6.0.17	1988	6.0.37	Row-level locking, scalability / performance, online backup and recovery, B*Tree indexes, PL/SQL executed from compiled programs (C etc.). First version available for Novell Netware 386.<ref>Template:Cite magazine</ref>
Template:Version	5.0.22 (5.1.17)	1985	5.1.22	Support for client/server computing and distributed database systems. First version available for OS/2. Correlated sub-queries<ref>Template:Cite magazine</ref>
Template:Version	4.1.4.0	1984	4.1.4.4	Multiversion read consistency. First version available for MS-DOS.<ref>Template:Cite magazine</ref><ref>{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref>
Template:Version	3.1.3	1983		Concurrency control, data distribution, and scalability. Re-written in C for portability to other operating systems, including UNIX.<ref>Template:Cite book</ref>
Template:Version	2.3	1979		First commercially available SQL RDBMS. Basic SQL queries, simple joins<ref name="VEI-Kuni-OraR2">{{#invoke:citation/CS1\|citation	CitationClass=web }}</ref> and `CONNECT BY` joins. Written in assembly language for the PDP-11 to run in 128KB of RAM.<ref>Template:Cite book</ref> Ran on PDP-11 and VAX/VMS in PDP-11 compatibility mode.
Template:Version LTR = Long-Term Release, IR = Innovation Release

The Introduction to Oracle Database includes a brief history on some of the key innovations introduced with each major release of Oracle Database.

See My Oracle Support (MOS) note Release Schedule of Current Database Releases (Doc ID 742060.1) for the current Oracle Database releases and their patching end dates.

Patch updates and security alertsEdit

Prior to Oracle Database 18c, Oracle Corporation released Critical Patch Updates (CPUs) and Security Patch Updates (SPUs)<ref>Template:Cite book</ref> and Security Alerts to close security vulnerabilities. These releases are issued quarterly; some of these releases have updates issued prior to the next quarterly release.

Starting with Oracle Database 18c, Oracle Corporation releases Release Updates (RUs) and Release Update Revisions (RURs).<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> RUs usually contain security, regression (bug), optimizer, and functional fixes which may include feature extensions as well. RURs include all fixes from their corresponding RU but only add new security and regression fixes. However, no new optimizer or functional fixes are included.

CompetitionEdit

In the market for relational databases, Oracle Database competes against commercial products such as IBM Db2 and Microsoft SQL Server.<ref name="rdbmslateryears20070612">Template:Cite interview</ref> Oracle and IBM tend to battle for the mid-range database market on Unix and Linux platforms, while Microsoft dominates the mid-range database market on Microsoft Windows platforms. However, since they share many of the same customers, Oracle and IBM tend to support each other's products in many middleware and application categories (for example: WebSphere, PeopleSoft, and Siebel Systems CRM), and IBM's hardware divisions work closelyTemplate:Citation needed with Oracle on performance-optimizing server-technologies (for example, Linux on IBM Z). Niche commercial competitors include Teradata (in data warehousing and business intelligence), Software AG's ADABAS, Sybase, and IBM's Informix, among many others.

In the cloud, Oracle Database competes against the database services of AWS, Microsoft Azure, and Google Cloud Platform.

Increasingly, the Oracle database products compete against open-source software relational and non-relational database systems such as PostgreSQL, MongoDB, Couchbase, Neo4j, ArangoDB and others. Oracle acquired Innobase, supplier of the InnoDB codebase to MySQL, in part to compete better against open source alternatives, and acquired Sun Microsystems, owner of MySQL, in 2010. Database products licensed as open-source are, by the legal terms of the Open Source Definition, free to distribute and free of royalty or other licensing fees.

ReferencesEdit

Template:Reflist

External linksEdit

Template:Sister project Template:Sister project Template:Wikiversity

Overview provided by Oracle Corporation.

Template:Databases Template:Oracle