Oracle
Oracle database is a relational database management system (RDBMS) from Oracle Corporation in 1977 by Lawrence Ellison and other engineers.
Oracle Release Versions
| 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 RedirectPartitioned Hybrid Tables Real-time Stats + Stats Only Queries |
The Oracle Database Product Family
Oracle Database is available in five editions, each suitable for different development and deployment scenarios. Oracle also offers several database options, packs, and other products that enhance the capabilities of Oracle Database for specific application purposes. This section describes the Oracle Database editions. The database enhancement products are described in Chapter 2, "Options and Packs".
Oracle Database Standard Edition One
It provides the base functionality for users that do not require Enterprise Edition's robust package.
Oracle Database Standard Edition One delivers unprecedented ease of use, power, and performance for workgroup, department-level, and Web applications. From single-server environments for small business to highly distributed branch environments, Oracle Database Standard Edition One includes all the facilities necessary to build business-critical applications.
Oracle Database Standard Edition
Oracle Database Standard Edition delivers the unprecedented ease of use, power, and performance of Standard Edition One, with support for larger machines and clustering of services with Oracle Real Application Clusters (Oracle RAC). Oracle RAC is not included in the Standard Edition of releases prior to Oracle Database 10g, nor is it an available option with those earlier releases.
Oracle Database Enterprise Edition
It is the most robust and secure edition. It offers all features, including superior performance and security.
Oracle Database Enterprise Edition provides the performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications. Oracle Database Enterprise Edition contains all of the components of Oracle Database, and can be further enhanced with the purchase of the options and packs described in Chapter 2, "Options and Packs".
Oracle Database Express Edition
It is the lightweight, free and limited Windows, and Linux edition.
Oracle Database Express Edition (Oracle Database XE) is an entry-level edition of Oracle Database that is quick to download, simple to install and manage, and is free to develop, deploy, and distribute. Oracle Database XE makes it easy to upgrade to the other editions of Oracle without costly and complex migrations. Oracle Database XE can be installed on any size machine with any number of CPUs, stores up to 4GB of user data, using up to 1GB of memory, and using only one CPU on the host machine. Support is provided by an online forum.
Oracle Lite
It is designed for mobile devices.
Oracle Database Personal Edition
It's comparable to the Enterprise Edition but without the Oracle Real Application Clusters feature.
Oracle Database Personal Edition supports single-user development and deployment environments that require full compatibility with Oracle Database Standard Edition One, Oracle Database Standard Edition, and Oracle Database Enterprise Edition.
Personal Edition includes all of the components that are included with Enterprise Edition, as well as all of the options that are available with Enterprise Edition, with the exception of the Oracle Real Application Clusters option, which cannot be used with Personal Edition. Personal Edition is available on Windows platforms only. The Management Packs are not included in Personal Edition.
