I will explain about History of Oracle Database and Oracle versions in this article.
Those who do not know what is the Database and Relational Database management systems ( RDBMS ) can read the following article.
Oracle was founded on June 16, 1977 by Larry Ellison, Bob Miner and Ed Oates under the name Software Development Laboratories (SDL). Until 1979, the company did not succeed with this name, and in 1979, three adventurous friends who changed the company name to Relational Software Inc worked in Relational Software Inc. until 1982. The brilliant trio, which has consistently focused on Database management systems and made its first database trial with IBM, failed.
In one of the following experiments, the Oracle Database System developed under the leadership of Bob Miner. In 1982, the name of the company was identified with the name of its products and changed to Oracle Systems Corporation. It was changed to Oracle Corporation in 1995 and this name has continued to this day.
TOP Features according to Version of Oracle database from the first version are as follows.
|Version & Year||New Features|
|Oracle v2, 1979||First commercially SQL-based RDBMS|
|Oracle v3, 1983||Concurrency control, data distribution, scalability|
|Oracle v4, 1984||Multiversion read consistency|
|Oracle v5, 1985||Client/server computing Support & distributed database systems|
|Oracle v6, 1988||Row-level locking, scalability, online backup and recovery, PL/SQL, Oracle Parallel Server|
|Oracle 7, 1992||PL/SQL stored procedures, Triggers, Shared Cursors, Cost Based Optimizer, Transparent Application Failover|
|Oracle 8, 1997||Recovery Manager, Partitioning, Dataguard, Native internet protocols, Java, Virtual Private Database|
|Oracle 9, 2001||Oracle Real Application Clusters (RAC), Oracle XML DB, Data Mining, Streams, Logical Standby|
|Oracle 10gR1, 2003||Grid infrastructure, Oracle ASM, Flashback Database, Automatic Database Diagnostic Monitor|
|Oracle 10gR2, 2005||Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Transparent Data Encryption|
|Oracle 11gR1, 2007||Active Data Guard, Secure Files, Exadata|
|Oracle 11gR2, 2009||Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance|
|Oracle 12cR1, 2013||Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service|
|Oracle 12cR2, 2016||Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer|
|Oracle 18c, 2018||Autonomous Database, Data Guard Multi-Instance Redo Apply, Polymorphic Table Functions, Active Directory Integration|
|Oracle 19c, 2019||Automatic Indexing, Data-guard DML Redirect,Partitioned Hybrid Tables, Real-time Stats + Stats Only Queries|
RMAN (Recovery Manager), which is the backup and recover tool of Oracle database, and Partitioning feature, which makes a great contribution to the Database management system in terms of performance, were introduced with this version.
Disaster Recovery feature called Dataguard is released with Oracle 8.
The most important feature in this version is undoubtedly the Real Application Cluster (RAC) feature. With this feature, Oracle Instance, which is installed on multiple servers at the same time, provides high availability of databases, which we call high availability.
There is still no feature like RAC (active-active) in other RDBMS. The RAC feature has become a sine qua non for corporations, especially for customers with instant money flows such as banking and insurance, which we call business critical systems.
With Oracle 10g, we now have the ability to manage Oracle’s storage management from operating systems, which we now call Automatic Storage management. The Real application Cluster feature, which comes with Oracle 9, has been improved and the Grid Infrastructure feature has also come with 10g.
Flashback feature, which is one of the most important features for database administrators and shortens the recover on user errors, was also introduced with Oracle 10g.
Advanced Compression and Transparent Data Encryption are also introduced with Oracle 10g.
With this version, Exadata, which was designed as a database machine introduced by Oracle on the hardware side, was introduced. Oracle 11g was the first database version used in Exadata.
Active dataguard feature was introduced in this version for the disaster recovery feature of Dataguard databases.
Data Redaction, Hybrid Columnar Compression and Cluster File System are another feature of Oracle 11g.
Oracle has announced many different features with 12c version, it has already echoed in the market and the most important reason for this is that it announces Cloud feature. Now the concept of g (grid) in 10g and 11g has been replaced by c (cloud).
Oracle 12c’s TOP features are as follows.
- Oracle Multitenant
- Far Sync
- Online Datafile move
- Table Restore from Full Backup
- İnvisible Column
- Automatic Data Optimization
- Flex ASM
- Data Masking
- Multiple index for same column.
Autonomous Database and Data Guard Multi-Instance Redo Apply are the most important features in this version. Let’s look at what this feature is.
Oracle Autonomous Database is a cloud-based technology introduced in 2017, designed to automate many of the routine DBA tasks required to manage Oracle databases. In particular, Oracle says that database administrators (DBAs) will have the opportunity to do higher and more strategic tasks rather than routine and tedious tasks . Because lots of DBA tasks will be done by Oracle, thus Oracle will be a self-managed database.
Autonomous Database feature is provided as a cloud service created by machine learning algorithms called self-driving, self-safety and self-repair slogans.
- Automatic Indexing
- Data-guard DML Redirect
- Partitioned Hybrid Tables
- Real-time Stats + Stats Only Queries features.
I will continue to add new features and new versions in the future as soon as new version of Oracle has released.