Oracle_Database

Oracle Database

Oracle Database

Proprietary database management system

Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model[4] database management system produced and marketed by Oracle Corporation.

Quick Facts Developer(s), Initial release ...

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-prem, on-cloud, or as a hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware (Exadata on-prem, on Oracle Cloud or at Cloud at Customer).[5]

Oracle Database uses SQL query language for database updating and retrieval.[6]

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 CIA-funded project Ellison had worked on while formerly employed by Ampex.[7]

Releases and versions

Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release, Oracle Database 23c, stands for "Cloud". Previous releases (e.g. Oracle Database 10g and Oracle9i Database) have used suffixes of "g" and "i" which stand for "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".[8] For each database release, Oracle also provides an Express Edition (XE) that is free to use.[9]

Oracle Database release numbering has used the following codes:

More information Oracle Database Version, Initial Release Version ...

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)[30] 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).[31] 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.

Market position

A 2016 Gartner report claimed to show Oracle holding #1 RDBMS market share worldwide based on the revenue share ahead of its four closest competitors – Microsoft, IBM, SAP and Teradata .[32][verification needed][clarification needed] A 2021 Gartner Magic Quadrant report named Oracle a leader in Cloud Database Management Systems.[33]

Competition

In the market for relational databases, Oracle Database competes against commercial products such as IBM Db2 and Microsoft SQL Server. 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 closely[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.

See also

References

  1. [1]
    "Oracle Database 23c: The Next Long Term Support Release".
  2. [2]
    Lextrait, Vincent (March 2016). "The Programming Languages Beacon, v16". Archived from the original on 30 May 2012. Retrieved 15 December 2016.
  3. [3]
    "OTN Standard License", Technical network, Oracle
  4. [4]
    "Multimodel Database with Oracle Database 12c Release 2" (PDF). Oracle. Archived (PDF) from the original on 14 April 2017. Retrieved 1 March 2017.
  5. [5]
    "Exadata" (PDF), Technical network, Oracle
  6. [6]
    Roeser, Mary Beth; Adams, Drew; Ashdown, Lance; Baby, Thomas; Baer, Hermann; Baskan, Yasin; Bayliss, Nigel; Chen, Shuo; Belden, Eric. "Oracle and Standard SQL". Oracle Help Center. Retrieved 9 June 2023.
  7. [7]
    "Welcome to Larryland". The Guardian. Archived from the original on 25 August 2016. Retrieved 19 December 2009.
  8. [8]
    Julie Bort (29 September 2014). "Larry Ellison Is A Billionaire Today Thanks to the CIA". Business Insider. Archived from the original on 16 January 2017. Retrieved 13 January 2017.
  9. [9]
    "Free Oracle Database for Everyone". Oracle. Retrieved 19 February 2024.
  10. [10]
    "Oracle Database 23c Free - Developer Release". Oracle Corporation. Retrieved 3 April 2023.
  11. [11]
    "Oracle Database 23c on OCI Base Database Service". Oracle Corporation. Retrieved 19 September 2023.
  12. [12]
    "Oracle Database 21c". Oracle Help Center. Retrieved 9 December 2020.
  13. [13]
    Hardie, William (23 September 2021). "Oracle Database 21c Now Available On Linux". Oracle Database Insider. Retrieved 17 December 2023.
  14. [14]
    Giles, Dominic (13 February 2019). "Oracle Database 19c Now Available on Oracle Exadata". Oracle Database Insider. Retrieved 27 April 2021.
  15. [15]
    Hardie, William (25 April 2019). "Oracle Database 19c Now Available on Linux". Oracle Database Insider. Archived from the original on 5 April 2024. Retrieved 27 April 2021.
  16. [16]
    "Oracle Database 18c : Now available on the Oracle Cloud and Oracle Engineered Systems". Oracle Database Insider. 16 February 2018. Retrieved 28 April 2021.
  17. [17]
    Zagar, Adriana (23 July 2018). "Oracle Database 18c Now Available For On-Premises". Oracle Community. Archived from the original on 8 August 2020. Retrieved 16 January 2020.
  18. [18]
    "Oracle Announces General Availability of Oracle Database 12c, the First Database Designed for the Cloud". Oracle. 1 July 2013. Archived from the original on 9 September 2013. Retrieved 9 September 2013.
  19. [19]
    "Oracle® Database 11g Release 2 is Now Available". Oracle. 1 September 2009. Archived from the original on 5 April 2018. Retrieved 4 April 2018.
  20. [20]
    "Oracle Announces General Availability of Oracle® Database 10g Release 2". Oracle. 11 July 2005. Archived from the original on 5 April 2018. Retrieved 4 April 2018.
  21. [21]
    Biggs, Maggie (5 October 1998). "Oracle8 on Linux shows promise". InfoWorld. Retrieved 7 September 2019.
  22. [22]
    Nash, Kim (3 October 1994). "Oracle users ponder product overload". Infoworld. IDG Enterprise. Retrieved 30 July 2020.
  23. [23]
    O'Brien, Timothy (29 April 1991). "Oracle8 on Linux shows promise". InfoWorld. Retrieved 7 September 2019.
  24. [24]
    Mace, Scott (30 January 1989). "DOS Version of Professional Oracle 5.1B Adds SQL Report Writer". InfoWorld. Retrieved 7 September 2019.
  25. [25]
    Webster, Robin (13 November 1984). "PC Relational Database? New Answer is Oracle". PC Magazine. Retrieved 1 July 2019.
  26. [26]
    Gralike, Marco (4 April 2006). "Back to the future (Oracle 4.1 VM appliance)". amis.nl. Archived from the original on 1 July 2019. Retrieved 1 July 2019.
  27. [27]
    Data Processing Digest Volumes 29-30. Data Processing Digest. 1983. p. 2.
  28. [28]
    Departments of Informatics. "Oracle V2". Virtual Exhibitions in Informatics. University of Klagenfurt. Archived from the original on 30 September 2019. Retrieved 30 September 2019.
  29. [29]
    Maheshwari, Sharad (2007). Introduction to SQL and PL/SQL. Firewall Media. p. 12. ISBN 9788131800386.
  30. [30]
    Baransel, Emre (2013). Oracle Data Guard 11gR2 Administration Beginner's Guide. Packt Publishing Ltd. ISBN 9781849687911. Archived from the original on 23 November 2016. Retrieved 15 January 2014. You should not get confused between Critical Patch Update (CPU) and Security Patch Update (SPU) as CPU terminology has been changed to SPU from October 2012.
  31. [31]
    "Patch Delivery Methods for Oracle Database 12c Release 2 (12.2.0.1) and Later Versions". Docs.oracle.com. Retrieved 16 March 2022.
  32. [32]
    Heudecker, Nick; Feinberg, Donald; Adrian, Merv (25 July 2017). "State of the Operational DBMS Market, 2017". Gartner. Retrieved 15 December 2017.
  33. [33]
    "Magic Quadrant for Cloud Database Management Systems". Gartner. Retrieved 18 April 2022.
Wikimedia Commons has media related to Oracle Database.
Wikibooks has a book on the topic of: Oracle database
Wikiversity has learning resources about Oracle Database
Share this article:

This article uses material from the Wikipedia article Oracle_Database, and is written by contributors. Text is available under a CC BY-SA 4.0 International License; additional terms may apply. Images, videos and audio are available under their respective licenses.