Oracle
Database 19c
Copyright 2022, Faulkner Information Services. All
Rights Reserved.
Docid: 00011503
Publication Date: 2212
Publication Type: PRODUCT
Preview
Oracle’s Database 19c is a database management system that
allows corporate IT departments to control their large-scale computing
environments and developers to create enterprise-wide data management
programs and applications. Released in February 2019, it is the final
“long term support” release of the Oracle 12c family of products,
which also includes Oracle 18c. Currently, the company plans to
end support of the database in April 2027, and is currently offering
Oracle Database 21c as an “innovation release,” providing early
insight into the enhancements and new capabilities planned for the
product.
Report Contents:
Description
[return to top of this
report]
Related Faulkner Reports |
Oracle Company Profile |
Oracle’s Database 19c database-management system was created for
corporate IT departments to help them better manage large-scale computing
environments. The product allows each database plugged into the
multitenant architecture to look and feel like a standard Oracle database
to applications, allowing existing applications to run unchanged.
Vendor |
Oracle |
The open source system is Oracle’s flagship offering. It allows for
consolidation onto database clouds and engineered systems such as Oracle
Exadata and Oracle’s Database Appliance.
Database 19c offers database administration productivity
features for organizations looking to consolidate databases onto the cloud
without the need to modify or create new applications. It builds upon
previous releases and offers additional functionality for typical customer
use cases, including traditional transactions, real-time analytics, JSON
document stores, and Internet of Things (IoT) applications. It is also
designed for analytical database applications such as traditional and
real-time data warehouses and data marts, big data lakes, and graph
analytics. Database 19c lets users send write requests to the
standby, which are then redirected to the primary database, and then the
changes are shipped back to the standby.
New features offered in the release include an improved create
application wizard, REST-enabled SQL support, Web source modules, an
improved create page wizard, a new REST workshop, social sign-in
authentication, SQL quarantine, and workload capture and replay in a PDB,
among other features.
19c features:
- Application development
- Incremental capabilities in the areas of performance, security, and
high availability - Business intelligence and data warehousing
- Compression and archiving
- Oracle RAC and grid infrastructure
- Security
- Spatial and graph representation
- Unstructured data analysis
Oracle Database 19c is available in three main on-premise
editions for enterprise use – Standard Edition 2, Enterprise,
and Enterprise Edition on Engineered Systems.
Each is compatible with the other editions and shares the same database
engine architecture. This allows organizations to upgrade database
platforms as necessary. NOTE: Oracle Standard Edition
and Oracle Standard Edition One are no longer available for purchase.
Table 1 compares Oracle’s Database 19c editions.
Edition | Standard Two | Enterprise | Enterprise on Engineered Systems |
---|---|---|---|
Description | Includes features necessary to develop workgroup, department-level, and Web applications. |
Provides performance, availability, scalability, and security for developing applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications. |
Oracle Database Enterprise Edition software installed on an on-premises engineered system (Oracle Exadata Database Machine or Oracle Database Appliance). |
High Availability Features |
|||
Fail Safe | Y | Y | N |
Fast-Start Fault Recovery | N | Y | Y |
Flashback Table, Database, and Transaction Query |
N | Y | Y |
Application Continuity | N | Y | Y |
Performance and Scalability Features |
|||
Real Application Clusters | N | Option | Option |
Query Results Cache | N | Y | Y |
Adaptive Execution Plans | N | Y | Y |
Automatic Workload Management | Option | Option | Option |
Oracle In-Memory Database Cache | N | Option | Option |
In-Memory Aggregation | N | Option | Option |
Security Features | |||
Data Masking | N | Y | Y |
Real Application Security | N | Y | Y |
Oracle Database Vault | N | Option | Option |
Oracle Advanced Security | N | Option | Option |
Oracle Label Security | N | Option | Option |
Enterprise User Security | N | Y | Y |
Virtual Private Database | N | Y | Y |
Fine Grained Auditing | N | Y | Y |
Redaction | N | Option | Option |
Transparent Data Encryption | N | Option | Option |
Manageability Features |
|||
Real Application Testing | N | Option | Option |
SQL Plan Management | Y | Y | Y |
Database Resource Manager | N | Y | Y |
I/O Resource Management | N | N | Y |
Instance Caging | Y | Y | Y |
Data Warehouse and Business Intelligence Features |
|||
Advanced Compression | N | Option | Option |
OLAP | N | Option | Option |
Partitioning | N | Option | Option |
Oracle Machine Learning | Y | Y | Y |
Automatic Data Optimization | N | Y | Y |
Parallel Statistics Gathering | N | Y | Y |
Summary Management | N | Y | Y |
Integration Features | |||
Database Gateways | Y | Y | Y |
Messaging Gateway | N | Y | Y |
AQ Sharded Queues | Y | Y | Y |
Spatial and Graph Data |
|||
Oracle Spatial and Graph | Y | Y | Y |
Property Graph and RDF Graph Technologies |
Y | Y | Y |
Parallel Spatial Index Builds | N | Y | Y |
Multimaster Replication of SDO_GEOMETRY Objects |
N | Y | Y |
Partitioned Spatial Indexes | N | Y | Y |
Figure 1 shows Database 19c enterprise architecture.
Figure 1. Database 19c Enterprise Architecture
Source: Oracle
Figure 2 depicts the new Active Standby DML Redirect offered in Database
19c.
Figure 2. Database 19c Active Standby DML
Redirect
Source: Oracle
Oracle also offers many different options to extend Database 19c
to meet specific performance, availability, security, compliance, data
warehousing, and manageability requirements. Some of Database 19c‘s
options are listed in Table 2.
Feature | Description |
---|---|
Active Data Guard | Offloads resource-intensive activities, from a production database to one or more synchronized standby databases. |
Advanced Compression | Delivers compression rates of 2-4X, across all data and application types. |
Advanced Security | Helps comply with privacy and regulatory mandates. |
Database In-Memory | Automatically synchronizes data between the cache and the Oracle Database to ensure data consistency. |
Database Vault | Addresses regulatory mandates and increase the security of existing applications. |
Label Security | Classifies data and mediating access to data, based on classification. |
Multitenant | Consolidates data and code from multiple databases without altering existing data or applications. |
OLAP | Calculates engine that supports advanced analytical applications, including planning, budgeting, forecasting, sales, and marketing, to identify key business trends and model business scenarios. |
Partitioning | Offers methods including interval, reference, list, and range, and provides composite partitions of two methods, such as order data (range) and region (list), or region (list) and customer type (list). |
Real Application Clusters | Allows a single database to run across a cluster of servers, providing fault tolerance, performance, and scalability without having to change applications. |
Real Application Clusters One Node | Offers a single-node version of Real Application Clusters for standardizing on a single deployment model. |
Real Application Testing | Combines workload capture and replay with a SQL performance analyzer, to test changes against real-life workloads, then fine tune changes before putting them into production. |
TimesTen Application-Tier Database Cache | Caches subsets of the database to improve response time in the application tier. |
Support
[return to top of this
report]
Oracle’s support options include training, consulting, and outsourced IT
services. Online support services include a FAQ section, tutorials,
documentation, e-mail support, and a telephone directory. Numerous
independent user groups for Oracle Database 19c also exist.
Pricing
[return to top of this
report]
The costs for Oracle’s Database 19c products are
configuration-dependent. Oracle should be contacted directly regarding all
price inquiries by e-mailing sales@oracle.com.
Customers can upgrade to 19c‘s new multitenant architecture or
upgrade with the current architecture. Customers have a choice of upgrade
paths and tools depending on what release they currently have.
Competitors
[return to top of this
report]
Oracle’ database-management systems market competition includes IBM DB2,
SAP database technology, and Teradata Integrated Data Warehouses, among
others.
Web Links
[return to top of this
report]
- Broadcom: https://www.broadcom.com/
- IBM: https://www.ibm.com/
- Oracle: https://www.oracle.com/
- SAP: https://www.sap.com/
- Teradata: https://www.teradata.com/
[return to top of this
report]