Application Continuity

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Active Data Guard option or the Oracle Real Application Clusters option

Oracle Sharding

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: No limit on the number of either primary shards or standby shards if every shard has an Oracle Active Data Guard, Oracle GoldenGate, or Oracle RAC license. Without an Oracle Active Data Guard, Oracle GoldenGate, or Oracle RAC license, use is limited to three primary shards, with basic Data Guard standbys.

Authorized Cloud Environments, DBCS EE, and DBCS EE-HP: Use is limited to three primary shards; there is no limit on the number of standby shards.

DBCS EE-EP and ExaCS: No limit on the number of either primary shards or standby shards.

Oracle Fail Safe

Y

Y

N/A

N/A

N/A

N/A

N/A

N/A

Windows only

Oracle RAC One Node

Y

Y

Y

N

N

N

N

Y

EE and EE-Exa: Extra cost option

Oracle Data Guard—Redo Apply

N

Y

Y

N

Y

Y

Y

Y

Oracle Data Guard—Far Sync Standby

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Active Data Guard option

Oracle Data Guard—SQL Apply

N

Y

Y

N

Y

Y

Y

Y

Oracle Data Guard—Snapshot Standby

N

Y

Y

N

Y

Y

Y

Y

Oracle Data Guard—Real-Time Cascading Standbys

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Active Data Guard option

Oracle Active Data Guard

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Extra cost option

Rolling Upgrades—Patch Set, Database, and Operating System

N

Y

Y

N

Y

Y

Y

Y

Rolling Upgrade Using Active Data Guard

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Active Data Guard option

Online index rebuild

N

Y

Y

N

Y

Y

Y

Y

Online table organization

N

Y

Y

N

Y

Y

Y

Y

ALTER TABLE ... MOVE ONLINEoperations

Online table redefinition

N

Y

Y

N

Y

Y

Y

Y

Using the DBMS_REDEFINITIONpackage

Duplexed backup sets

N

Y

Y

N

Y

Y

Y

Y

Block change tracking for fast incremental backup

N

Y

Y

N

N

N

Y

Y

Unused block compression in backups

N

Y

Y

N

Y

Y

Y

Y

Block-level media recovery

N

Y

Y

N

Y

Y

Y

Y

Lost Write Protection

N

Y

Y

N

Y

Y

Y

Y

Automatic Block Repair

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Active Data Guard option

Parallel backup and recovery

N

Y

Y

N

Y

Y

Y

Y

Tablespace point-in-time recovery

N

Y

Y

N

Y

Y

Y

Y

Trial recovery

N

Y

Y

N

Y

Y

Y

Y

Fast-start fault recovery

N

Y

Y

N

Y

Y

Y

Y

Flashback Table

N

Y

Y

N

Y

Y

Y

Y

Flashback Database

N

Y

Y

N

Y

Y

Y

Y

Flashback Transaction

N

Y

Y

N

Y

Y

Y

Y

Flashback Transaction Query

N

Y

Y

N

Y

Y

Y

Y

Optimization for Flashback Data Archive

N

Y

Y

N

N

Y

Y

Y

Basic Flashback Data Archive is in all offerings

EE and EE-Exa: Optimization for Flashback Data Archive requires the Oracle Advanced Compression option

Online Datafile Move

N

Y

Y

N

Y

Y

Y

Y

Transaction Guard

N

Y

Y

N

Y

Y

Y

Y

Cross-platform Backup and Recovery

N

Y

Y

N

Y

Y

Y

Y

Global Data Services

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Active Data Guard option

Recovering tables and table partitions from RMAN backups

N

Y

Y

N

Y

Y

Y

Y

Oracle Streams

Y

Y

Y

Y

Y

Y

Y

Y

SE2: no capture from redo

Database Gateways

Y

Y

Y

Y

Y

Y

Y

Y

Database Gateway for ODBC is included in all offerings.

All other Database Gateway products are available for all offerings, but require a separate product license.

Messaging Gateway

N

Y

Y

N

Y

Y

Y

Y

Sharded Queues

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Partitioning option

Oracle Cloud Management Pack for Oracle Database

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Data Masking and Subsetting Pack

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Database Lifecycle Management Pack for Oracle Database

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Diagnostics Pack

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Tuning Pack

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: Extra cost option, also requires Oracle Diagnostics Pack

Oracle Real Application Testing

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: Extra cost option

Database Resource Manager

N

Y

Y

N

Y

Y

Y

Y

I/O Resource Management

N

N

Y

N

N

N

N

Y

Instance Caging

Y

Y

Y

N/A

N/A

N/A

N/A

N/A

SQL Plan Management

N

Y

Y

N

Y

Y

Y

Y

SQL Tuning Sets

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. The following subprograms, part of the DBMS_SQLTUNE package, provide an interface to manage SQL Tuning Sets and are part of the EE and EE-Exa offerings: ADD_SQLSET_REFERENCE, CAPTURE_CURSOR_CACHE_SQLSET, CREATE_SQLSET, CREATE_STGTAB_SQLSET, DELETE_SQLSET, DROP_SQLSET, LOAD_SQLSET, PACK_STGTAB_SQLSET, REMOVE_SQLSET_REFERENCE, SELECT_CURSOR_CACHE, SELECT_SQLSET, SELECT_WORKLOAD_REPOSITORY, UNPACK_STGTAB_SQLSET, UPDATE_SQLSET.

Oracle Fleet Patching and Provisioning

(formerly Rapid Home Provisioning)

N

Y

Y

N/A

N/A

N/A

N/A

N/A

EE and EE-ES: When deployed across multiple clusters, requires Oracle Database Lifecycle Management Pack for Oracle Database, Oracle Real Application Clusters, or Oracle RAC One Node on a per target basis

Infiniband Support

N

Y

Y

N

N

N

N

Y

Oracle Connection Manager

N

Y

Y

N

Y

Y

Y

Y

Available via a custom install of the Oracle Database client, usually installed on a separate machine or compute instance

Network Compression

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Compression option

Network Encryption (SSL/TLS)

Y

Y

Y

Y

Y

Y

Y

Y

Client Side Query Cache

N

Y

Y

N

Y

Y

Y

Y

Query Results Cache

N

Y

Y

N

Y

Y

Y

Y

PL/SQL Function Result Cache

N

Y

Y

N

Y

Y

Y

Y

Oracle TimesTen Application-Tier Database Cache

N

Y

Y

N

N

N

N

N

EE and EE-Exa: Extra cost option

Database Smart Flash Cache

N

Y

N/A

N/A

N/A

N/A

N/A

N/A

EE: Solaris and Oracle Linux only

Support for Oracle Exadata Storage Server Software

N

N

Y

N

N

N

N

Y

Adaptive Execution Plans

N

Y

Y

N

Y

Y

Y

Y

Concurrent Execution of UNION and UNION ALLBranches

N

Y

Y

N

Y

Y

Y

Y

Oracle Database In-Memory

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Extra cost option

In-Memory Column Store

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Database In-Memory option

In-Memory Column Store on Active Data Guard standby

N

N

Y

N

N

N

Y

Y

EE-Exa: Requires the Oracle Database In-Memory option and the Oracle Active Data Guard option

Fault Tolerant In-Memory Column Store

N

Y

Y

N

N

N

N

Y

EE: Requires Oracle Database Appliance, the Oracle Database In-Memory option, and the Oracle Real Application Clusters option

EE-Exa: Requires the Oracle Database In-Memory option and the Oracle Real Application Clusters option

In-Memory Aggregation

N

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Database In-Memory option

Attribute Clustering

N

Y

Y

N

Y

Y

Y

Y

Zone Maps

N

N

Y

N

N

N

N

Y

EE-Exa: Requires the Oracle Partitioning option

Oracle Real Application Clusters (Oracle RAC)

Y

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Extra cost option

Automatic Workload Management

Y

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Real Application Clusters option

Quality of Service Management

Y

Y

Y

N

N

N

Y

Y

EE and EE-Exa: Requires the Oracle Real Application Clusters option

Oracle NoSQL Database Basic Edition

N

Y

Y

N/A

N/A

N/A

N/A

N/A

Column-Level Encryption

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Security option

Tablespace Encryption

N

Y

Y

Y

Y

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Security option

Oracle Advanced Security

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Database Vault

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Label Security

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Enterprise User Security

N

Y

Y

N

Y

Y

Y

Y

EE, EE-Exa, DBCS EE, DBCS EE-HP, DBCS EE-EP, and ExaCS: Enterprise User Security is a feature for directory-based management of database users. It requires a corresponding Oracle Identity Management Directory Services Plus to be licensed.

Fine-grained Auditing

N

Y

Y

N

Y

Y

Y

Y

Privilege Analysis

N

Y

Y

N

Y

Y

Y

Y

Real Application Security

N

Y

Y

N

Y

Y

Y

Y

Redaction

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Security option

Transparent Sensitive Data Protection

N

Y

Y

N

Y

Y

Y

Y

Virtual Private Database

N

Y

Y

N

Y

Y

Y

Y

Storage Snapshot Optimization

N

Y

Y

N/A

N/A

N/A

N/A

N/A

EE and EE-Exa: Requires the Oracle Advanced Compression option

Oracle Spatial and Graph

Y

Y

Y

Y

Y

Y

Y

Y

Graph and Semantic Technologies (RDF/OWL)

Y

Y

Y

Y

Y

Y

Y

Y

Parallel spatial index builds

N

Y

Y

N

Y

Y

Y

Y

Multimaster replication of SDO_GEOMETRY objects

N

Y

Y

N

Y

Y

Y

Y

EE and EE-Exa: Single master/materialized view replication for SDO_GEOMETRY objects is supported

Partitioned spatial indexes

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Partitioning option

Oracle Partitioning

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle On-Line Analytical Processing (OLAP)

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Oracle Machine Learning (formerly Advanced Analytics)

Y

Y

Y

Y

Y

Y

Y

Y

Oracle Advanced Compression

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Extra cost option

Advanced Index Compression

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Compression option

Prefix Compression (also called Key Compression)

N

Y

Y

N

Y

Y

Y

Y

Hybrid Columnar Compression

N

Y

Y

N

Y

Y

Y

Y

EE: Requires ZFS, Axiom, or FS1 storage

Hybrid Columnar Compression Row-Level Locking

N

Y

Y

N

N

N

N

Y

EE: Requires ZFS or FS1 storage, and the Oracle Advanced Compression option

EE-Exa: Requires the Oracle Advanced Compression option

Exadata Flash Cache Compression

N

N

Y

N

N

N

N

Y

EE-Exa: Requires the Oracle Advanced Compression option

Heat Map

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Compression option or the Oracle Database In-Memory option

Automatic Data Optimization

N

Y

Y

N

N

Y

Y

Y

EE and EE-Exa: Requires the Oracle Advanced Compression option or the Oracle Database In-Memory option

Basic Table Compression

N

Y

Y

N

Y

Y

Y

Y

Deferred Segment Creation

N

Y

Y

N

Y

Y

Y

Y

Bitmapped index, bitmapped join index, and bitmap plan conversions

N

Y

Y

N

Y

Y

Y

Y

Parallel query/DML

N

Y

Y

N

Y

Y

Y

Y

Parallel statistics gathering

N

Y

Y

N

Y

Y

Y

Y

Parallel index build/scans

N

Y

Y

N

Y

Y

Y

Y

Parallel Data Pump Export/Import

N

Y

Y

N

Y

Y

Y

Y

In-Memory Parallel Execution

N

Y

Y

N

Y

Y

Y

Y

Parallel Statement Queuing

N

Y

Y

N

Y

Y

Y

Y

Parallel capture and apply via XStream

N

Y

Y

N

Y

Y

Y

Y

Transportable tablespaces, including cross-platform and full transportable export and import

N

Y

Y

N

Y

Y

Y

Y

Import of transportable tablespaces supported into SE2

Summary management—Materialized View Query Rewrite

N

Y

Y

N

Y

Y

Y

Y

Oracle Active Data Guard

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-EP, ExaCS

Oracle Active Data Guard includes the following features:

• Physical Standby with Real-time Query

• Fast Incremental Backup on Physical Standby

• Automatic Block Repair

• Active Data Guard Far Sync

• Global Data Services

• Real-Time Cascade

• Application Continuity

• Rolling Upgrade using Active Data Guard

Oracle Active Data Guard must be licensed on any standby databases with any of the above features in use, as well as the primary database. If there are additional standby databases in the Oracle Data Guard configuration that are not using any of the Oracle Active Data Guard features, those standby databases do not require an Oracle Active Data Guard license.

Oracle Advanced Compression

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Advanced Compression includes the following features:

• Advanced Row Compression

• Advanced LOB Compression

• Advanced LOB Deduplication

• RMAN Backup Compression (RMAN DEFAULT COMPRESS does not require the Oracle Advanced Compression option)

• Data Pump Export Data Compression (COMPRESSION=METADATA_ONLY does not require the Oracle Advanced Compression option)

• Heat Map

• Automatic Data Optimization

• Data Guard Redo Transport Compression

• Advanced Network Compression

• Optimization for Flashback Data Archive History Tables

• Storage Snapshot Optimization

• Online Move Partition (to any compressed format)

• Exadata Flash Cache Compression (This feature can be enabled only on Exadata storage servers, and all database processors that access the Exadata storage servers must be licensed for Oracle Advanced Compression.)

• Advanced Index Compression

• Hybrid Columnar Compression Row-Level Locking (Requires Exadata, Supercluster, ZFS, or FS1 storage)

Oracle Advanced Security

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Advanced Security includes the following features:

• Transparent Data Encryption (TDE) for tablespaces and columns (including Oracle SecureFiles)

• DataPump Export File encryption

• RMAN backup encryption to disk

• TDE master key storage in an Oracle Wallet or external Hardware Security Module

• Data Redaction of sensitive data returned to applications (Full, Partial, Regular Expression, and Random techniques)

Oracle Advanced Security includes a restricted use license for certain Oracle Enterprise Manager features. Refer to Oracle Advanced Security in "Restricted Use Licenses" for more information.

Note: Network encryption (native network encryption and SSL/TLS) and strong authentication services (Kerberos, PKI, and RADIUS) are no longer part of Oracle Advanced Security and are available in all licensed editions of all supported releases of Oracle Database.

Oracle Database In-Memory

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-EP, ExaCS

Oracle Database In-Memory includes the following features:

• In-Memory Column Store

• Fault Tolerant In-Memory Column Store (Requires Exadata, Supercluster, Oracle Database Appliance, or Exadata Cloud Service)

• In-Memory Aggregation

• Heat Map

• Automatic Data Optimization

Oracle Database Vault

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Database Vault includes the following features:

• Separation of Duties

• Realms

• Command Rules

• Trusted Paths

Oracle Database Vault includes special license rights for Oracle Label Security. Refer to Oracle Database Vault in "Special License Rights" for more information.

Oracle Database Vault includes a restricted use license for certain Oracle Enterprise Manager features. Refer to Oracle Database Vault in "Restricted Use Licenses" for more information.

Oracle Label Security

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Label Security includes the following features:

• Label based access control (LBAC)

• Multi-level security (MLS)

• Label factors for Oracle Database Vault (Confidential, Sensitive)

• User label authorizations (Confidential, Sensitive: PII)

• Data labels (Sensitive: PII)

Oracle Label Security includes a restricted use license for certain Oracle Enterprise Manager features. Refer to Oracle Label Security In "Restricted Use Licenses" for more information.

Oracle Machine Learning (formerly Advanced Analytics)

Included option: SE2, EE, EE-ES, DBCS SE, DBCS EE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Machine Learning includes the following features:

• In-database algorithms for Oracle Machine Learning for SQL (OML4SQL) (formerly Oracle Data Mining):

  • Model build (accessed via the DBMS_DATA_MINING package)

  • Data transformations (accessed via the DBMS_DATA_MINING_TRANSFORM package)

  • Model scoring (accessed via SQL Scoring functions)

  • Predictive Analytics (accessed via the DBMS_PREDICTIVE_ANALYTICS package)

• Oracle Machine Learning for R (OML4R) (formerly Oracle R Enterprise) (integration with open-source R):

  • OML4R Transparency Layer: Allows an R user to explore and prepare database-resident data using R language syntax and functions

  • OML4R interface to in-database machine learning algorithms

  • Embedded R Execution: Enables execution of user-defined R functions in database spawned and controlled R engines, also enabling data- and task- parallel execution

  • All OML4R functionality is invoked using the ORE package

Oracle Multitenant

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Multitenant includes the following features:

• For EE and PE, the ability to have up to 252 pluggable databases per multitenant container database

• For EE-Exa, DBCS EE-HP, DBCS EE-EP, and ExaCS, the ability to have up to 4096 pluggable databases per multitenant container database

A restricted use license for Oracle Multitenant is included with all Oracle Database offerings. Refer to Oracle Multitenant in "Restricted Use Licenses" for more information.

Oracle On-Line Analytical Processing (OLAP)

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle On-Line Analytical Processing (OLAP) includes the following features:

• OLAP Cube Definition, Storage, and Querying

• OLAP API and Metadata

• OLAP Cube Materialized Views

• Analytic Workspaces

• SQL Access to OLAP Cubes

Oracle Partitioning

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Partitioning includes the following features:

• Table Partitions and Subpartitions

• Global and Local Index Partitions and Subpartitions

• Sharded Queues

• Zone Maps (Available only on EE-Exa and ExaCS – requires Exadata or Supercluster)

Oracle RAC One Node

Extra cost option: EE, EE-Exa

Included option: SE2, ExaCS

Oracle RAC One Node includes the following features:

• Database Cold Failover to another node in the cluster in case of server or instance failure

• Online migration of the database instance to another server

• Support for online rolling upgrades of the database, grid infrastructure, and OS homes

• Online upgrade to Oracle Real Application Clusters

• Policy-managed Server Pools

• Quality of Service Management

• Application Continuity

Oracle Real Application Clusters (Oracle RAC)

Extra cost option: EE, EE-Exa

Included option: SE2, DBCS EE-EP, ExaCS

Oracle Real Application Clusters (Oracle RAC) includes the following features:

• All of the features included with Oracle RAC One Node

• Real Application Clusters scaling to multiple servers

• Connection Load Balancing

• Fast Connection Failover

• Hot Cluster Failover

Oracle Real Application Testing

Extra cost option: EE, EE-Exa

Included option: PE, DBCS EE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Real Application Testing includes the following features:

• Database Replay

• SQL Performance Analyzer (SPA)

• Database Consolidation Workbench

Database Replay

• The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.

• Use of Capture and Replay ASH Analytics Reports, Compare Period ADDM Reports, and Replay Compare Period Reports also requires an Oracle Diagnostics Pack license.

• An Oracle Real Application Testing license permits you to access Database Replay functionality through Oracle Enterprise Manager, as well as through the following database server command-line APIs: DBMS_WORKLOAD_CAPTURE package and DBMS_WORKLOAD_REPLAY package. The use of the DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT() function also requires a license for Oracle Diagnostics Pack.

SQL Performance Analyzer (SPA)

An Oracle Real Application Testing license permits you to access SQL Performance Analyzer functionality through Oracle Enterprise Manager, as well as through the following database server command-line API: DBMS_SQLPA package, which is part of the Oracle Real Application Testing option.

Database Consolidation Workbench

• Database Consolidation Workbench, introduced in Oracle Enterprise Manager Cloud Control 13c, provides a data-driven and systematic approach to consolidation by eliminating guess work and human errors. Database Consolidation Workbench has three key capabilities: consolidation planning, database migration, and performance validation.

• Use of the consolidation planning feature of Database Consolidation Workbench requires an Oracle Diagnostics Pack license.

• Use of the database migration feature of Database Consolidation Workbench requires an Oracle Database Lifecycle Management Pack for Oracle Database license.

• An Oracle Real Application Testing license permits you to access the following links on the Database Consolidation Workbench page in Oracle Enterprise Manager:

  • From the Enterprise menu, select Consolidation, then select Database Consolidation Workbench.

  • On the database target home page, select the Administration menu, then select Database Consolidation Workbench.

  • All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Consolidation Workbench.

Oracle Spatial and Graph

Included option: PE, SE2, EE, EE-ES, DBCS SE, DBCS EE, DBCS EE-HP, DBCS EE-EP, ExaCS

Oracle Spatial and Graph includes the following features:

• Geospatial Data Features

• Graph Database Features

Geospatial Data Features

• SPATIAL_VECTOR_ACCELERATION to significantly improve 2D and 3D spatial vector query performance

• Classes in packages other than the oracle.spatial.geometry (sdoapi.jar) and oracle.spatial.util (sdoutil.jar) packages of the Spatial Java API

• Linear Referencing System (LRS) support

• GeoRaster Storage, Indexing, and Querying

• Network Data Model

• Topology Data Model

• Spatial analysis and mining subprograms (SDO_SAM package)

• Spatial Routing Engine

• Geocoding Engine

• Spatial Web Services including OpenLS support, including support for geocoding, mapping, business directory (Yellow Pages), and driving directions (routing) services, Web feature service (WFS) support (SDO_WFS_PROCESS and SDO_WFS_LOCK packages), and Catalog services for the Web (CSW) support (SDO_CSW_PROCESS package)

• 3-D Geometry, Surface, Triangulated irregular network (TIN), and Point Cloud Storage, Indexing, and Querying

• GeoJSON

Graph Database Features

Graph database features include the following models:

• A property graph to model and analyze relationships found in social networks, cyber security, utilities and telecommunications, life sciences and clinical data, and knowledge networks. Typical graph analyses encompass graph traversal, recommendations, finding communities and influencers, and pattern matching. Its features include:

  • A scalable graph database

  • Data import from relational, CSV, GraphML, GraphSON, GML sources

  • Parallel bulk load and export of property graph data in Oracle-defined flat files format

  • A parallel, in-memory graph analytics engine with over 40 built-in analytics that include ranking, centrality, recommender, community detection, path finding

  • Developer-based APIs based upon Tinkerpop Blueprints, and Java graph APIs

  • Text search and query through integration with Oracle Text, Apache Lucene, and optionally, SolrCloud

  • Scripting languages support for Groovy and Python

  • Manageability through a Groovy-based console to execute Java and Tinkerpop Gremlin APIs

• A Network Data Model (NDM) graph to model and analyze link-node graphs to represent physical and logical networks used in transportation, utilities, and telco. Its features include:

  • A storage model to represent graphs and networks in link and node tables

  • Java APIs to perform analysis in memory

  • Numerous graph analysis functions including shortest path, within cost, nearest neighbors, traveling salesman, spanning tree, and more

  • Explicit storage and connectivity of the graph with link- and node-level attributes

  • Support for directed and undirected graphs with or without cost

• An RDF Semantic Graph to model and analyze data represented as triples for social network, linked data, and other semantic applications. Its features include:

  • Graph relationships represented as triples in compressed, partitioned tables

  • Indexing, querying, and ontology management

  • RDFS, OWL, and user-defined inferencing (parallel, batch, and incremental)

  • Support for SPARQL 1.1 and mixed SPARQL and SQL queries

  • Enhanced Open Source Tools including Jena, Sesame, Joseki Web Services

Oracle Spatial and Graph includes a restricted use license for Oracle Partitioning. Refer to Oracle Spatial and Graph in "Restricted Use Licenses" for more information.

Oracle TimesTen Application-Tier Database Cache

Extra cost option: EE, EE-Exa

Included option: PE

Oracle TimesTen Application-Tier Database Cache includes the following features:

• Data access using PL/SQL, JDBC, ODBC, ttClasses, OCI, and Pro*C/C++ interfaces

• Transaction Log API (XLA) for change notification

• Multi-node Cache Grid

• Automatic data synchronization with the Oracle database

• Transactional replication between the in-memory cache databases

• Automated failure detection and database failovers

• TimesTen Extension for Oracle SQL Developer

• TimesTen Plug-in for Oracle Enterprise Manager