Oracle Database: Difference between revisions

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
VisualWikitext
imported>Ylee
 
imported>DigitalIceAge
new key for Category:Oracle Cloud Services: "Database" using HotCat
 
(One intermediate revision by one other user not shown)
Line 14: Line 14:
| genre = [[Multi-model database]]
| genre = [[Multi-model database]]
| programming language = [[Assembly language]], [[C (programming language)|C]], [[C++]]<ref>{{cite web |url= http://www.lextrait.com/Vincent/implementations.html |title= The Programming Languages Beacon, v16 |last= Lextrait |first= Vincent |date= March 2016 |access-date= 15 December 2016 |archive-url= https://archive.today/20120530/http://www.lextrait.com/Vincent/implementations.html |archive-date= 30 May 2012 |url-status= dead }}</ref>
| programming language = [[Assembly language]], [[C (programming language)|C]], [[C++]]<ref>{{cite web |url= http://www.lextrait.com/Vincent/implementations.html |title= The Programming Languages Beacon, v16 |last= Lextrait |first= Vincent |date= March 2016 |access-date= 15 December 2016 |archive-url= https://archive.today/20120530/http://www.lextrait.com/Vincent/implementations.html |archive-date= 30 May 2012 |url-status= dead }}</ref>
| license = [[Proprietary software|Proprietary]]<ref>{{Citation | publisher = Oracle | work = Technical network | url = http://www.oracle.com/technetwork/licenses/standard-license-152015.html | title = OTN Standard License}}</ref>
| license = [[Proprietary software|Proprietary]]<ref>{{Citation | publisher = Oracle | work = Technical network | url = https://www.oracle.com/technetwork/licenses/standard-license-152015.html | title = OTN Standard License}}</ref>
| website = {{URL |https://www.oracle.com/database/}}
| website = {{URL |https://www.oracle.com/database/}}
}}
}}
Line 26: Line 26:
== History ==
== History ==


[[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 [[Central Intelligence Agency|CIA]]-funded project Ellison had worked on while formerly employed by [[Ampex]];<ref>{{cite web|url=https://www.theguardian.com/g2/story/0,3604,215072,00.html|title=Welcome to Larryland|work=The Guardian|access-date=2009-12-19|archive-url=https://web.archive.org/web/20160825232818/https://www.theguardian.com/g2/story/0,3604,215072,00.html|archive-date=25 August 2016|url-status=live}}</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.{{r|rdbmsearlyyearsoh20070612}}
[[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, later [[Oracle Corporation]]. SDL developed the original version of the Oracle software. The name ''Oracle'' comes from the code-name of a [[Central Intelligence Agency]]-funded project Ellison had worked on while formerly employed by [[Ampex]];<ref>{{cite web|url=https://www.theguardian.com/g2/story/0,3604,215072,00.html|title=Welcome to Larryland|work=The Guardian|access-date=2009-12-19|archive-url=https://web.archive.org/web/20160825232818/https://www.theguardian.com/g2/story/0,3604,215072,00.html|archive-date=25 August 2016|url-status=live}}</ref> the CIA was Oracle's first customer, and allowed the company to use the code name for the new product.<ref name="rdbmsoracle20070612">{{Cite interview |interviewer=Luanne Johnson |title=RDBMS Workshop: Oracle |type=PDF |url=https://www.computerhistory.org/collections/catalog/102746581 |access-date=2025-06-01 |publisher=Computer History Museum |date=2007-06-12}}</ref>
 
Ellison wanted his database to be compatible with [[IBM System R]], but that company's [[Don Chamberlin]] declined to release its error codes.{{r|rdbmsearlyyearsoh20070612}} By 1985 Oracle advertised, however, that "Programs written for [[SQL/DS]] or [[DB2]] will run unmodified" on the many non-IBM mainframes, minicomputers, and microcomputers its database supported "Because all versions of ORACLE ''are'' identical".<ref name="oracle19850520">{{Cite magazine |date=1985-05-20 |title=Oracle announces portable version of IBM SQL/DS and DB2 |url=https://books.google.com/books?id=ygHfUXZWXlcC&pg=PA47#v=onepage&q&f=true |access-date=2025-06-07 |magazine=Computerworld |page=47 |type=Advertisement |volume=XIX |issue=20}}</ref>


=== Releases and versions ===
=== Releases and versions ===


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>{{cite web
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 Ellison "knew no one would want to buy version 1".<ref>{{cite web
| title= Larry Ellison Is A Billionaire Today Thanks to the CIA
| title= Larry Ellison Is A Billionaire Today Thanks to the CIA
| author= Julie Bort
| author= Julie Bort
Line 55: Line 57:
! Marquee <br /> Features
! Marquee <br /> Features
|-
|-
|{{Version |c |Oracle Database 23ai (LTR)}}
|{{Version |c |Oracle AI Database 26ai (LTR)}}
|23.26.0
|Starting with Release Update 23.26.0, released in October 2025, Oracle Database 23ai is replaced by Oracle AI Database 26ai.
Applying Release Update 23.26.0 to an existing Oracle Database 23ai deployment converts it to Oracle AI Database 26ai without requiring a separate database upgrade or application re-certification<ref>{{Cite web |title=Release Schedule of Current Database Releases |url=https://support.oracle.com/knowledge/Oracle%20Database%20Products/742060_1.html |access-date=2025-11-14 |website=support.oracle.com}}</ref>
|
|
|-
|{{Version |co |Oracle Database 23ai (LTR)}}
|23.4.0
|23.4.0
|On May 2, 2024, Oracle Database 23ai<ref>{{cite web|title=Announcing Oracle Database 23ai: General Availability|url=https://blogs.oracle.com/database/post/oracle-23ai-now-generally-available|access-date=2024-05-02|website=Oracle Corporation|language=en}}</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.
|From Release Update 23.26.0 onward, 23ai is replaced by Oracle AI Database 26ai<ref>{{Cite web |title=Release Schedule of Current Database Releases |url=https://support.oracle.com/knowledge/Oracle%20Database%20Products/742060_1.html |access-date=2025-11-14 |website=support.oracle.com}}</ref>
On May 2, 2024, Oracle Database 23ai<ref>{{cite web|title=Announcing Oracle Database 23ai: General Availability|url=https://blogs.oracle.com/database/post/oracle-23ai-now-generally-available|access-date=2024-05-02|website=Oracle Corporation|language=en}}</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:  
Oracle Database 23c (23.2 and 23.3) was released in 2023:  
Line 71: Line 81:
|
|
|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
|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
|
|-
|-
| {{Version |co |Oracle Database 19c (LTR)}}
| {{Version |co |Oracle Database 19c (LTR)}}
Line 170: Line 181:
| June 1992
| June 1992
|
|
| PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost-Based Optimizer
| Distributed 2-phase commit,{{r|rdbmsoracle20070612}} PL/SQL stored procedures, triggers, shared cursors, cost-based optimizer
|-
|-
| {{Version |o |Oracle 6.2}}
| {{Version |o |Oracle 6.2}}
Line 182: Line 193:
| 1988
| 1988
| 6.0.37
| 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 [[NetWare#NetWare 3.x|Novell Netware 386]].<ref>{{cite magazine |last=O'Brien |first=Timothy |date=1991-04-29 |title=Oracle8 on Linux shows promise |url=https://books.google.com/books?id=Gw0EAAAAMBAJ&pg=PA2 |magazine=[[InfoWorld]] |access-date=2019-09-07 }}</ref>
| Row-level locking, [[symmetric multiprocessor|SMP]] scalability / performance, storing of undo in database,{{r|rdbmsoracle20070612}} online backup and recovery, B*Tree indexes, [[PL/SQL]] executed from compiled programs (C etc.). First version available for [[NetWare#NetWare 3.x|Novell Netware 386]].<ref>{{cite magazine |last=O'Brien |first=Timothy |date=1991-04-29 |title=Oracle unveils data base for Novell NetWare 386 LANs |url=https://books.google.com/books?id=Gw0EAAAAMBAJ&pg=PA2 |magazine=[[InfoWorld]] |access-date=2019-09-07 }}</ref>
|-
|-
| {{Version |o |Oracle v5}}
| {{Version |o |Oracle v5}}
Line 188: Line 199:
| 1985
| 1985
| 5.1.22
| 5.1.22
| Support for [[Client-server computing|client/server computing]] and [[distributed database|distributed database systems]]. First version available for [[OS/2]]. Correlated sub-queries<ref>{{cite magazine |last=Mace |first=Scott |date=1989-01-30 |title=DOS Version of Professional Oracle 5.1B Adds SQL Report Writer |url=https://books.google.com/books?id=MzoEAAAAMBAJ&pg=PA6 |magazine=[[InfoWorld]] |access-date=2019-09-07 }}</ref>
| C2 security certification. Support for [[distributed database|distributed database systems]]{{r|rdbmsoracle20070612}} and [[Client-server computing|client/server computing]]. First version available for [[OS/2]]. Correlated sub-queries.<ref>{{cite magazine |last=Mace |first=Scott |date=1989-01-30 |title=DOS Version of Professional Oracle 5.1B Adds SQL Report Writer |url=https://books.google.com/books?id=MzoEAAAAMBAJ&pg=PA6 |magazine=[[InfoWorld]] |access-date=2019-09-07 }}</ref> DOS version supports [[extended memory]].{{r|rdbmsoracle20070612}}
|-
|-
| {{Version |o |Oracle v4}}
| {{Version |o |Oracle v4}}
Line 194: Line 205:
| 1984
| 1984
| 4.1.4.4
| 4.1.4.4
| Multiversion read consistency. First version available for [[MS-DOS]].<ref>{{cite magazine |last=Webster |first=Robin |date=1984-11-13 |title=PC Relational Database? New Answer is Oracle |url=https://books.google.com/books?id=-Ukz6hjZEA4C&pg=PA57 |magazine=[[PC Magazine]] |access-date=2019-07-01 }}</ref><ref>{{cite web |url=https://technology.amis.nl/2006/04/04/back-to-the-future-oracle-41-vm-appliance/ |title=Back to the future (Oracle 4.1 VM appliance) |last=Gralike |first=Marco |date=2006-04-04 |website=amis.nl |access-date=2019-07-01 |archive-url=https://web.archive.org/web/20190701142355/https://technology.amis.nl/2006/04/04/back-to-the-future-oracle-41-vm-appliance/ |archive-date=1 July 2019 |url-status=live }}</ref>
| Multiversion read consistency. [[Halloween Problem]] solved. Improved concurrency.{{r|rdbmsoracle20070612}} First version available for [[MS-DOS]]<ref>{{cite magazine |last=Webster |first=Robin |date=1984-11-13 |title=PC Relational Database? New Answer is Oracle |url=https://books.google.com/books?id=-Ukz6hjZEA4C&pg=PA57 |magazine=[[PC Magazine]] |access-date=2019-07-01 }}</ref><ref>{{cite web |url=https://technology.amis.nl/2006/04/04/back-to-the-future-oracle-41-vm-appliance/ |title=Back to the future (Oracle 4.1 VM appliance) |last=Gralike |first=Marco |date=2006-04-04 |website=amis.nl |access-date=2019-07-01 |archive-url=https://web.archive.org/web/20190701142355/https://technology.amis.nl/2006/04/04/back-to-the-future-oracle-41-vm-appliance/ |archive-date=1 July 2019 |url-status=live }}</ref> and [[IBM mainframe]].{{r|rdbmsoracle20070612}}
|-
|-
| {{Version |o |Oracle v3}}
| {{Version |o |Oracle v3}}
Line 200: Line 211:
| 1983
| 1983
|
|
| [[Concurrency control]], data distribution, and [[scalability]]. Re-written in C for portability to other operating systems, including [[UNIX]].<ref>{{cite book |date=1983 |title=Data Processing Digest Volumes 29-30 |url=https://books.google.com/books?id=eygmAQAAIAAJ&q=oracle+unix |publisher=[[Roger Sisson|Data Processing Digest]] |page=2}}</ref>
| [[Concurrency control]], data distribution, and [[scalability]]. Re-written in C for portability to other operating systems, including [[UNIX]].<ref>{{cite book |date=1983 |title=Data Processing Digest Volumes 29-30 |url=https://books.google.com/books?id=eygmAQAAIAAJ&q=oracle+unix |publisher=[[Roger Sisson|Data Processing Digest]] |page=2}}</ref>{{r|rdbmsoracle20070612}}
|-
|-
| {{Version |o |Oracle v2}}
| {{Version |o |Oracle v2}}
Line 206: Line 217:
| 1979
| 1979
|
|
| First commercially available SQL [[Relational database|RDBMS]]. Basic SQL queries, simple joins<ref name="VEI-Kuni-OraR2">{{cite web|url=http://cs-exhibitions.uni-klu.ac.at/index.php?id=403|title=Oracle V2|website=Virtual Exhibitions in Informatics|publisher=University of Klagenfurt|author=Departments of Informatics|access-date=30 September 2019|url-status=live|archive-date=30 September 2019|archive-url=https://web.archive.org/web/20190930122821/http://cs-exhibitions.uni-klu.ac.at/index.php?id=403}}</ref> and <code>CONNECT BY</code> joins. Written in [[assembly language]] for the [[PDP-11]] to run in 128KB of [[Random-access memory|RAM]].<ref>{{cite book |last=Maheshwari |first=Sharad |date=2007 |title=Introduction to SQL and PL/SQL |url=https://books.google.com/books?id=V1eMhnTq2BYC&pg=PA12 |publisher=Firewall Media |page=12 |isbn=9788131800386}}</ref> Ran on PDP-11 and [[VAX]]/VMS in PDP-11 compatibility mode.
| First commercially available SQL [[Relational database|RDBMS]]. Basic SQL queries, simple joins<ref name="VEI-Kuni-OraR2">{{cite web|url=http://cs-exhibitions.uni-klu.ac.at/index.php?id=403|title=Oracle V2|website=Virtual Exhibitions in Informatics|publisher=University of Klagenfurt|author=Departments of Informatics|access-date=30 September 2019|url-status=live|archive-date=30 September 2019|archive-url=https://web.archive.org/web/20190930122821/http://cs-exhibitions.uni-klu.ac.at/index.php?id=403}}</ref> and <code>CONNECT BY</code> joins. Atomic role-level SQL statements. Rudimentary [[concurrency control]] and [[database integrity]]. No [[query optimizer]]. Written in [[assembly language]] for the [[PDP-11]]{{r|rdbmsoracle20070612}} to run in 128KB of [[Random-access memory|RAM]].<ref>{{cite book |last=Maheshwari |first=Sharad |date=2007 |title=Introduction to SQL and PL/SQL |url=https://books.google.com/books?id=V1eMhnTq2BYC&pg=PA12 |publisher=Firewall Media |page=12 |isbn=9788131800386}}</ref> Ran on PDP-11 and [[VAX]]/VMS in PDP-11 compatibility mode.{{r|rdbmsoracle20070612}}
|-
|-
| colspan="6" | <small>{{Version |l |show=111100}} '''LTR''' = ''Long-Term Release'', '''IR''' = ''Innovation Release''</small>
| colspan="6" | <small>{{Version |l |show=111100}} '''LTR''' = ''Long-Term Release'', '''IR''' = ''Innovation Release''</small>
Line 228: Line 239:


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.
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.
==Reception==
The ''[[Rosen Electronics Letter]]'' in February 1983 stated that Oracle was "the most comprehensive offering we've seen" among databases, with good marketing and substantial installed base encouraging developers to write software for it. The newsletter especially approved of the user interface, noting the "simplicity of setting up 'programs'—queries, data manipulation, updates—without actually programming".<ref name="rosen19830222">{{Cite news |date=1983-02-22 |title=DBMS and the workstation: Oracle gets close |url=https://cdn.oreillystatic.com/radar/r1/02-83.pdf |access-date=2025-06-05 |work=[[The Rosen Electronics Letter]] |pages=3-5}}</ref>


== See also ==
== See also ==
Line 261: Line 275:
[[Category:Relational database management software for Linux]]
[[Category:Relational database management software for Linux]]
[[Category:Cloud infrastructure]]
[[Category:Cloud infrastructure]]
[[Category:Oracle Cloud Services]]
[[Category:Oracle Cloud Services|Database]]
[[Category:Database management systems]]
[[Category:Database management systems]]

Latest revision as of 21:17, 24 December 2025

Script error: No such module "For".

Template:Short description Script error: No such module "Unsubst". Script error: No such module "Infobox". Script error: No such module "Check for unknown parameters".Script error: No such module "Check for conflicting parameters".

Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model[1] 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).[2]

Oracle Database uses SQL for database updating and retrieval.[3]

History

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, later Oracle Corporation. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a Central Intelligence Agency-funded project Ellison had worked on while formerly employed by Ampex;[4] the CIA was Oracle's first customer, and allowed the company to use the code name for the new product.[5]

Ellison wanted his database to be compatible with IBM System R, but that company's Don Chamberlin declined to release its error codes.[6]Template:R/superscript By 1985 Oracle advertised, however, that "Programs written for SQL/DS or DB2 will run unmodified" on the many non-IBM mainframes, minicomputers, and microcomputers its database supported "Because all versions of ORACLE are identical".[7]

Releases and versions

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 Ellison "knew no one would want to buy version 1".[8][6] For some database releases, Oracle also provides an Express Edition (XE) that is free to use.[9][10]Template:R/superscript

Oracle Database release numbering has used the following codes:

Template:Version LTR = Long-Term Release, IR = Innovation Release
Oracle
Database
Version 		Initial
Release
Version 		Initial
Release
Date 		Terminal
Version 		Marquee
Features
Template:Version 23.26.0 Starting with Release Update 23.26.0, released in October 2025, Oracle Database 23ai is replaced by Oracle AI Database 26ai.

Applying Release Update 23.26.0 to an existing Oracle Database 23ai deployment converts it to Oracle AI Database 26ai without requiring a separate database upgrade or application re-certification[11]

Template:Version 23.4.0 From Release Update 23.26.0 onward, 23ai is replaced by Oracle AI Database 26ai[12]

On May 2, 2024, Oracle Database 23ai[13] 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[14] September 2023 Oracle Database on Base Database Service[15]

AI Vector Search[16] (includes new Vector data type, Vector indexes, and Vector SQL operators/functions), JSON Relational Duality,[17] 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 December 2020 (cloud)[18]

August 2021 (Linux)[19]

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 February 2019 (Exadata)[20]

April 2019 (Linux)[21]
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 February 2018 (cloud, Exadata)[22]

July 2018 (other)[23]

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 July 2013[24] 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 September 2009[25] 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 July 2005[26] 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.[27]
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.[28]
Template:Version 7.0.12 June 1992 Distributed 2-phase commit,[5]Template:R/superscript PL/SQL stored procedures, triggers, 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, SMP scalability / performance, storing of undo in database,[5]Template:R/superscript online backup and recovery, B*Tree indexes, PL/SQL executed from compiled programs (C etc.). First version available for Novell Netware 386.[29]
Template:Version 5.0.22 (5.1.17) 1985 5.1.22 C2 security certification. Support for distributed database systems[5]Template:R/superscript and client/server computing. First version available for OS/2. Correlated sub-queries.[30] DOS version supports extended memory.[5]Template:R/superscript
Template:Version 4.1.4.0 1984 4.1.4.4 Multiversion read consistency. Halloween Problem solved. Improved concurrency.[5]Template:R/superscript First version available for MS-DOS[31][32] and IBM mainframe.[5]Template:R/superscript
Template:Version 3.1.3 1983 Concurrency control, data distribution, and scalability. Re-written in C for portability to other operating systems, including UNIX.[33][5]Template:R/superscript
Template:Version 2.3 1979 First commercially available SQL RDBMS. Basic SQL queries, simple joins[34] and CONNECT BY joins. Atomic role-level SQL statements. Rudimentary concurrency control and database integrity. No query optimizer. Written in assembly language for the PDP-11[5]Template:R/superscript to run in 128KB of RAM.[35] Ran on PDP-11 and VAX/VMS in PDP-11 compatibility mode.[5]Template:R/superscript
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 alerts

Prior to Oracle Database 18c, Oracle Corporation released Critical Patch Updates (CPUs) and Security Patch Updates (SPUs)[36] 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).[37] 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.

Competition

In the market for relational databases, Oracle Database competes against commercial products such as IBM Db2 and Microsoft SQL Server.[10] 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 closelyScript error: No such module "Unsubst". 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.

Reception

The Rosen Electronics Letter in February 1983 stated that Oracle was "the most comprehensive offering we've seen" among databases, with good marketing and substantial installed base encouraging developers to write software for it. The newsletter especially approved of the user interface, noting the "simplicity of setting up 'programs'—queries, data manipulation, updates—without actually programming".[38]

See also

Script error: No such module "Portal".

References

<templatestyles src="Reflist/styles.css" />

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ Script error: No such module "citation/CS1".
  3. ↑ Script error: No such module "citation/CS1".
  4. ↑ Script error: No such module "citation/CS1".
  5. ↑ a b c d e f g h i j Script error: No such module "citation/CS1".
  6. ↑ a b Script error: No such module "citation/CS1".
  7. ↑ Script error: No such module "Citation/CS1".
  8. ↑ Script error: No such module "citation/CS1".
  9. ↑ Script error: No such module "citation/CS1".
  10. ↑ a b Script error: No such module "citation/CS1".
  11. ↑ Script error: No such module "citation/CS1".
  12. ↑ Script error: No such module "citation/CS1".
  13. ↑ Script error: No such module "citation/CS1".
  14. ↑ Script error: No such module "citation/CS1".
  15. ↑ Script error: No such module "citation/CS1".
  16. ↑ Script error: No such module "citation/CS1".
  17. ↑ Script error: No such module "citation/CS1".
  18. ↑ Script error: No such module "citation/CS1".
  19. ↑ Script error: No such module "citation/CS1".
  20. ↑ Script error: No such module "citation/CS1".
  21. ↑ Script error: No such module "citation/CS1".
  22. ↑ Script error: No such module "citation/CS1".
  23. ↑ Script error: No such module "citation/CS1".
  24. ↑ Script error: No such module "citation/CS1".
  25. ↑ Script error: No such module "citation/CS1".
  26. ↑ Script error: No such module "citation/CS1".
  27. ↑ Script error: No such module "Citation/CS1".
  28. ↑ Script error: No such module "Citation/CS1".
  29. ↑ Script error: No such module "Citation/CS1".
  30. ↑ Script error: No such module "Citation/CS1".
  31. ↑ Script error: No such module "Citation/CS1".
  32. ↑ Script error: No such module "citation/CS1".
  33. ↑ Script error: No such module "citation/CS1".
  34. ↑ Script error: No such module "citation/CS1".
  35. ↑ Script error: No such module "citation/CS1".
  36. ↑ Script error: No such module "citation/CS1".
  37. ↑ Script error: No such module "citation/CS1".
  38. ↑ Script error: No such module "citation/CS1".

Script error: No such module "Check for unknown parameters".

External links

Script error: No such module "Side box". Script error: No such module "Side box". Script error: No such module "Side box".

Script error: No such module "Navbox". Script error: No such module "Navbox".

Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=Oracle_Database&oldid=4692961"