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.