1. Release Notes
  2. New Features in Release 18.3

New Features in Release 18.3

Querying GeoJson Data

Introduced support for a number of built-in functions in SQL queries to interpret JSON objects that represent geographical locations as specified in the GeoJSON specification (https://tools.ietf.org/html/rfc7946).

Support for Namespaces

Starting this release users can create namespaces. Tables can be created for a particular namespace. If users do not specify a namespace at the time of table creation the tables are placed under the default namespace of sysDefault. Prior to this release there was no concept of namespace in Oracle NoSQL Database. All tables created using prior releases will be placed in sysDefault namespace on upgrade.

IDENTITY Column Support

Users can create a table with an IDENTITY column for which the system will automatically generate numeric values using a sequence generator.

Support for INSERT and UPSERT in SQL Query

Support for INSERT and UPSERT statements has been added in SQL queries.

Support for Sequence Aggregation Functions in SQL Query

The following new functions have been added to support sequence aggregation operations in SQL queries: seq_count, seq_sum, seq_avg, seq_min, and seq_max.

Admin Web Service

Oracle NoSQL Database Admin can now be started as a web service that processes Admin CLI commands through a REST API over the HTTP and HTTPS protocol. The input and output to the Admin Web Service is in JSON format. This feature is intended to help DevOps and other NoSQL admins automate administrative operations. See REST API for Administering Oracle NoSQL Database.

Data Migrator - Preview

This release includes a preview version of the Data Migrator utility, which allows users to migrate their data into Oracle NoSQL Database that is either in JSON or MongoDB JSON formats. This utility will be integrated into the Oracle NoSQL Database IMPORT/EXPORT utility in future releases. See the MIGRATOR-README.txt found in the doc subdirectory of the Oracle NoSQL Database package for its usage.

Monitoring Using ELK Framework

Oracle NoSQL Database can be setup to generate logs that can be used by the popular ELK (Elasticsearch - Logstash - Kibana) framework to visually monitor NoSQL clusters.

Support for Encryption at Rest

Oracle NoSQL Database can be setup to encrypt its data using dm-crypt, a kernel-level disk encryption mechanism available for Linux.