banner



Home  ›  When Was Oracle Datasbe Service 12.2 Launched

When Was Oracle Datasbe Service 12.2 Launched

Written By Tuesday, June 7, 2022 Add Comment Edit

Proprietary database management organisation

Oracle Database
Oracle logo.svg
Developer(south) Oracle Corporation
Initial release 1979; 43 years ago  (1979)
Stable release

19c[1]Edit this on Wikidata / thirteen February 2019; iii years ago  (13 February 2019)

Written in Assembly language, C, C++[2]
Type Multi-model database
License Proprietary[3]
Website world wide web.oracle.com/database/

Oracle Database (unremarkably referred to every bit Oracle DBMS, Oracle Democratic Database, or simply as Oracle) is a multi-model[iv] database management system produced and marketed past 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-prem, on-deject, or as hybrid deject installation. It may be run on third political party servers as well as on Oracle hardware (Exadata on-prem, on Oracle Cloud or at Deject at Customer [5])

History [edit]

Larry Ellison and his ii friends and quondam 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 proper name Oracle comes from the code-proper name of a CIA-funded projection Ellison had worked on while formerly employed past Ampex.[6]

Releases and versions [edit]

Oracle products follow a custom release-numbering and -naming convention. The "c" in the electric current release, Oracle Database 21c, stands for "Deject". Previous releases (e.g. Oracle Database 10g and Oracle9i Database) accept used suffixes of "m" and "i" which stand up for "Grid" and "Internet" respectively. Prior to the release of Oracle8i Database, no suffixes featured in Oracle Database naming conventions. Notation that there was no v1 of Oracle Database, equally co-founder Larry Ellison "knew no one would want to buy version i".[7]

Oracle Database release numbering has used the following codes:

Oracle
Database
Version 		Initial
Release
Version 		Initial
Release
Date 		Concluding
Patchset / RU
Version 		Last
Patchset / RU
Date 		Marquee
Features
Old version, no longer maintained: Oracle v2 2.3 1979 First commercially available SQL-based RDBMS implementing some bones SQL queries and simple joins[8]
Old version, no longer maintained: Oracle v3 iii.1.3 1983 Concurrency control, information distribution, and scalability
One-time version, no longer maintained: Oracle v4 4.1.4.0 1984 4.1.4.iv Multiversion read consistency. First version available for MS-DOS.[9] [10]
Old version, no longer maintained: Oracle v5 5.0.22 (5.one.17) 1985 5.ane.22 Support for client/server computing and distributed database systems. First version available for Os/2.[11]
Erstwhile version, no longer maintained: Oracle v6 6.0.17 1988 six.0.37 Row-level locking, scalability, online backup and recovery, PL/SQL. First version available for Novell Netware 386.[12]
Old version, no longer maintained: Oracle 6.two 6.2.0 Oracle Parallel Server
Quondam version, no longer maintained: Oracle7 7.0.12 June 1992 PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost-Based Optimizer
Onetime version, no longer maintained: Oracle 7.ane 7.1.0 May 1994 Parallel SQL Execution. First version available for Windows NT.[13]
Erstwhile version, no longer maintained: Oracle 7.2 seven.ii.0 May 1995 Shared Server, XA Transactions, Transparent Application Failover
Quondam version, no longer maintained: Oracle vii.3 7.3.0 February 1996 vii.three.iv Object-relational database
Sometime version, no longer maintained: Oracle8 Database viii.0.3 June 1997 8.0.6 Recovery Manager, Partitioning. Offset version available for Linux.[14]
Sometime version, no longer maintained: Oracle8i Database 8.ane.five.0 1998 8.1.7.4 August 2000 Native internet protocols and Java, Virtual Private Database
Old version, no longer maintained: Oracle9i Database 9.0.i.0 2001 9.0.1.5 December 2003 Oracle Real Awarding Clusters (RAC), Oracle XML DB
Former version, no longer maintained: Oracle9i Database Release 2 9.2.0.1 2002 nine.2.0.8 April 2007 Avant-garde Queuing, Data Mining, Streams, Logical Standby
Old version, no longer maintained: Oracle Database 10chiliad Release 1 10.1.0.2 2003 10.i.0.5 February 2006 Automated Database Management, Automatic Database Diagnostic Monitor, Filigree infrastructure, Oracle ASM, Flashback Database
Old version, no longer maintained: Oracle Database 10g Release ii 10.2.0.one July 2005[fifteen] 10.two.0.5 April 2010 Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Data Guard Fast-First Failover, Transparent Data Encryption
Old version, no longer maintained: Oracle Database elevenk Release 1 xi.1.0.6 September 2007 11.1.0.7 September 2008 Active Data Guard, Secure Files, Exadata
Older version, however yet maintained: Oracle Database 11g Release 2 xi.2.0.1 September 2009[sixteen] 11.two.0.four August 2013 Edition-Based Redefinition, Data Redaction, Hybrid Columnar Compression, Cluster File Arrangement, Golden Gate Replication, Database Apparatus
Older version, yet however maintained: Oracle Database 12c Release one 12.1.0.1 July 2013[17] 12.one.0.2 July 2014 Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service
Older version, yet withal maintained: Oracle Database 12c Release ii 12.ii.0.i August 2016 (cloud)

March 2017 (on-prem)

12.two.0.ane March 2017 Native Sharding, Zero Information Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer
Former version, no longer maintained: Oracle Database 18c 18.1.0 // 12.two.0.2 February 2018 (cloud, Exadata)[eighteen]

July 2018 (other)[xix]

eighteen.17.0 Jan 2022 Polymorphic Tabular array Functions, Agile Directory Integration, Transparent Application Continuity, Approximate Peak-N Query Processing, PDB Snapshot Carousel, Online Merging of Partitions and Subpartitions
Older version, nonetheless still maintained: Oracle Database 19c 19.1.0 // 12.2.0.three February 2019 (Exadata)[20]

Apr 2019 (Linux)[21] June 2019 (deject)

Active Data Guard DML Redirection, Automated 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, Nothing-Downtime Filigree Infrastructure Patching, Finer-Granularity Supplemental Logging, Automated PDB Relocation
Current stable version: Oracle Database 21c 21.ane.0 December 2020 (cloud)[22]

Baronial 2021 (Linux)[23]

Blockchain Tables, Multilingual Engine - JavaScript Execution in the Database, Binary JSON Information Blazon, Per-PDB Data Guard Physical Standby (aka Multitenant Information Guard), Per-PDB GoldenGate Change Capture, Cocky-Managing In-Memory, In-Retention Hybrid Columnar Scan, In-Memory Vector Joins with SIMD, Sharding Counselor Tool, Property Graph Visualization Studio, Automated Materialized Views, Automatic Zone Maps, SQL Macros, Gradual Password Rollover

Legend:

Old version

Older version, still maintained

Latest version

Latest preview version

Future release

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

See My Oracle Back up (MOS) note Release Schedule of Current Database Releases (Doctor ID 742060.1) for the current Oracle Database releases and their patching stop dates.

Patch updates and security alerts [edit]

Prior to Oracle Database 18c, Oracle Corporation released Disquisitional Patch Updates (CPUs) and Security Patch Updates (SPUs)[24] 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).[25] RUs commonly contain security, regression (bug), optimizer, and functional fixes which may include characteristic extensions as well. RURs include all fixes from their corresponding RU but simply add together new security and regression fixes. However, no new optimizer or functional fixes are included.

Market position [edit]

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

Competition [edit]

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 marketplace on Microsoft Windows platforms. Even so, 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 functioning-optimizing server-technologies (for instance, Linux on IBM Z). Niche commercial competitors include Teradata (in data warehousing and business intelligence), Software AG'south ADABAS, Sybase, and IBM's Informix, amid 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 such open up-source software relational and non-relational database systems 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 caused Lord's day Microsystems, owner of MySQL, in 2010. Database products licensed every bit open up-source are, by the legal terms of the Open Source Definition, free to distribute and free of royalty or other licensing fees.

See too [edit]

  • Comparison of relational database management systems
  • Comparing of object–relational database management systems
  • Database direction organisation
  • List of relational database direction systems
  • List of databases using MVCC

References [edit]

  1. ^ "Oracle Database 19c : At present bachelor on Oracle Exadata". 13 February 2019. Retrieved 23 Dec 2020.
  2. ^
  3. ^ "OTN Standard License", Technical network, Oracle
  4. ^ "Multimodel Database with Oracle Database 12c Release ii" (PDF). Oracle. Archived (PDF) from the original on 14 April 2017. Retrieved 1 March 2017.
  5. ^ "Exadata" (PDF), Technical network, Oracle
  6. ^ "Welcome to Larryland". The Guardian. Archived from the original on 25 August 2016. Retrieved 19 Dec 2009.
  7. ^ Julie Bort (29 September 2014). "Larry Ellison Is A Billionaire Today Thank you to the CIA". Business Insider. Archived from the original on 16 Jan 2017. Retrieved 13 January 2017.
  8. ^ Departments of Informatics. "Oracle V2". Virtual Exhibitions in Informatics. Academy of Klagenfurt. Archived from the original on 30 September 2019. Retrieved 30 September 2019.
  9. ^ Webster, Robin (13 November 1984). "PC Relational Database? New Reply is Oracle". PC Mag . Retrieved 1 July 2019.
  10. ^ Gralike, Marco (4 April 2006). "Dorsum to the future (Oracle 4.i VM apparatus)". amis.nl. Archived from the original on 1 July 2019. Retrieved 1 July 2019.
  11. ^ Mace, Scott (30 January 1989). "DOS Version of Professional person Oracle 5.1B Adds SQL Report Writer". InfoWorld . Retrieved 7 September 2019.
  12. ^ O'Brien, Timothy (29 Apr 1991). "Oracle8 on Linux shows promise". InfoWorld . Retrieved 7 September 2019.
  13. ^ Nash, Kim (3 October 1994). "Oracle users ponder production overload". Infoworld. IDG Enterprise. Retrieved 30 July 2020.
  14. ^ Biggs, Maggie (5 Oct 1998). "Oracle8 on Linux shows hope". InfoWorld . Retrieved 7 September 2019.
  15. ^ "Oracle Announces General Availability of Oracle® Database 10g Release two". 11 July 2005. Archived from the original on 5 April 2018. Retrieved 4 April 2018.
  16. ^ "Oracle® Database 11g Release 2 is Now Bachelor". one September 2009. Archived from the original on 5 April 2018. Retrieved 4 April 2018.
  17. ^ "Oracle Announces General Availability of Oracle Database 12c, the First Database Designed for the Deject". 1 July 2013. Archived from the original on nine September 2013. Retrieved 9 September 2013.
  18. ^ "Oracle Database 18c : Now bachelor on the Oracle Cloud and Oracle Engineered Systems". blogs.oracle.com. 16 February 2018. Retrieved 28 April 2021.
  19. ^ Zagar, Adriana (23 July 2018). "Oracle Database 18c Now Available For On-Premises". Archived from the original on 8 Baronial 2020. Retrieved 16 Jan 2020.
  20. ^ Giles, 1Dominic (13 Feb 2019). "Oracle Database 19c Now Available on Oracle Exadata". blogs.oracle.com . Retrieved 27 April 2021.
  21. ^ Hardie, William (25 April 2019). "Oracle Database 19c Now Bachelor on Linux". blogs.oracle.com . Retrieved 27 April 2021.
  22. ^ "Oracle Database 21c". Oracle Assistance Center . Retrieved 9 Dec 2020.
  23. ^ https://blogs.oracle.com/database/mail/oracle-database-21c-available-at present-on-linux[ bare URL ]
  24. ^ Baransel, Emre (2013). Oracle Data Guard 11gR2 Administration Beginner'southward Guide. Packt Publishing Ltd. ISBN9781849687911. Archived from the original on 23 November 2016. Retrieved 15 January 2014. Y'all should non get dislocated between Disquisitional Patch Update (CPU) and Security Patch Update (SPU) every bit CPU terminology has been changed to SPU from October 2012.
  25. ^ "Patch Delivery Methods for Oracle Database 12c Release ii (12.2.0.1) and Later Versions". Docs.oracle.com. Retrieved 16 March 2022.
  26. ^ Heudecker, Nick; Feinberg, Donald; Adrian, Merv (25 July 2017). "State of the Operational DBMS Market, 2017". Gartner . Retrieved fifteen December 2017.
  27. ^ "Magic Quadrant for Deject Database Management Systems". Gartner . Retrieved 18 Apr 2022.

External links [edit]

  • Overview provided by Oracle Corporation.

When Was Oracle Datasbe Service 12.2 Launched,

Source: https://en.wikipedia.org/wiki/Oracle_Database

Posted by: clementsenty1997.blogspot.com

0 Response to "When Was Oracle Datasbe Service 12.2 Launched"

Post a Comment

Subscribe to: Post Comments (Atom)

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel