What's New in Oracle NoSQL Database Cloud Service

This document describes what's new in Oracle NoSQL Database Cloud Service on all infrastructure platform where it’s available.

The information is organized according to when a specific feature or capability became available. When new and changed features become available, Oracle NoSQL Database Cloud Service will be upgraded in the regions where Oracle Cloud services are hosted. You don’t need to request an upgrade to be able to use the new features — they come to you automatically.

Here’s an overview of new features and enhancements added recently to improve your Oracle NoSQL Database Cloud Service experience.

Topics

August 2022

Feature Description
New Data Region location available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Mexico Central (Queretaro) in LAD data region.

See Data Regions and Associated Service URLs.

Availability of Child Tables Table hierarchies (child tables) are available in the cloud. With the availability of table hierarchy, developers have additional flexibility when choosing the best data model to meet their business and application workload requirements. With child tables comes the ability to perform left outer join (nested table) queries.
Migrator utility updates Enhanced the migrator do support importing files from DynamoDB. The process is simple, export your DynamoDB tables as JSON files to AWS S3, then grab those files and import them into Oracle NoSQL.

June 2022

Feature Description
New Data Region location available Oracle NoSQL Database Cloud Service is now available in a new region:
  • France Central (Paris) in EMEA data region.

See Data Regions and Associated Service URLs.

Format change for JSON output Added pretty print JSON in the query section of the console.
New query driver in the console Removed the REST based query driver from the console and replaced it with a javascript driver. This adds significant more functionality to the console when it comes to querying your data.

February 2022

Feature Description
New Data Region location available Oracle NoSQL Database Cloud Service is now available in a new region:
  • South Africa Central (Johannesburg) in EMEA data region.

See Data Regions and Associated Service URLs.

Oracle NoSQL Database Migrator With this release, the NoSQL Database Migrator supports the below listed functionality:
  • Sink for Parquet - Export Oracle NoSQL Database table data as Parquet files.
  • Sink for Parquet in OCI Object storage - Export Oracle NoSQL Database table data as Parquet files to OCI object storage.
  • TTL Support - Export and import of Row TTL data.
  • New transformation includeFields.
For more details, see Overview of Oracle NoSQL Database Migrator in Using Oracle NoSQL Database Cloud Service.
Oracle NoSQL Database Visual Studio (VS) Code Extension You can use the new Oracle NoSQL Database Visual Studio (VS) Code Extension to browse tables and execute queries on your Oracle NoSQL Database Cloud Service instance or simulator. See About Oracle NoSQL Database Visual Studio Code Extension.
On Demand pricing model Oracle NoSQL Database Cloud Service added an on-demand pricing model. With this model, the service automatically scales the read and write capacities to meet dynamic workload needs. Customers don't need to provision the read or write capacities for each table/collection. The monthly billing captures the application's actual read and write capacities and charges accordingly.

December 2021

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in two new regions:
  • Sweden Central (Stockholm) in EMEA data region.
  • UAE Central (Abu Dhabi) in EMEA data region.

See Data Regions and Associated Service URLs.

November 2021

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in two new regions:
  • Marseille (France South ) in EMEA data region.
  • Singapore in APAC data region.

See Data Regions and Associated Service URLs.

New OCI IAM Identity Domains service The new OCI IAM services introduces identity domains. Identity domains are the next generation of IDCS instances (stripes). Each OCI IAM identity domain represents a stand-alone identity and access management solution.

October 2021

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Jerusalem (Israel) in EMEA data region.

See Data Regions and Associated Service URLs.

Manage tables and table data from your .NET application
You can now use the .NET SDK that enables your .NET application to create, update, and drop tables as well as add, read, and delete data in the tables. See

May 2021

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Brazil South East (Vinhedo) in LAD data region.

See Data Regions and Associated Service URLs.

February 2021

Feature Description
SQL new features
  • SQL string functions regex_like(any, string, string), regex_like(any, string)
  • IN operator, DISTINCT operator
  • untyped JSON Index
  • SQL ORDER BY and GROUP BY clause
Spring Data Driver
The Oracle NoSQL Database Cloud Service SDK for Spring Data provides POJO (Plain Old Java Object) centric modeling and integration between the Oracle NoSQL Database Cloud Service and the Spring Data Framework. The following features are currently supported by the Oracle NoSQL Database Cloud Service SDK for Spring Data.
  • Generic CRUD operations on a repository using methods in the CrudRepository interface.
  • Pagination and sorting operations using methods in the PagingAndSortingRepository interface.
  • Derived Queries.
  • Native Queries

For more information, see Oracle NoSQL Database SDK for Spring Data

December 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Chile Central (Santiago) in LAD data region.

See Data Regions and Associated Service URLs.

November 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Cardiff (UK) in EMEA data region.

See Data Regions and Associated Service URLs.

Always Free NoSQL Database Service

As part of the Oracle Cloud Free Tier, the Oracle NoSQL Database Cloud Service participates as an Always Free service.

  • You may have up to three Always Free NoSQL tables in your tenancy.
  • You can have both Always Free and regular tables in the same tenancy.
  • The Always Free NoSQL tables are displayed in the console with an “Always Free” label next to the table name.
  • An Always Free NoSQL table cannot be changed to a regular table or vice versa.

October 2020

Summary of October 2020 new features available in Oracle NoSQL Database Cloud Service.

Feature Description
Oracle NoSQL Database Migrator You can now use Oracle NoSQL Database Migrator to migrate NoSQL tables from one data source to another. This tool can operate on tables in Oracle Oracle NoSQL Database Cloud Service, Oracle NoSQL Database on-premise, and handle JSON and MongoDB-formatted JSON input files. With this release, NoSQL Database Migrator supports the below listed migration options:
  • Oracle NoSQL Database on-premise to Oracle NoSQL Database Cloud Service and vice-versa
  • Between two Oracle NoSQL on-premise Databases
  • Between two Oracle NoSQL Database Cloud Service Tables
  • JSON file to Oracle NoSQL Database on-premise and vice-versa
  • JSON file to Oracle NoSQL Database Cloud Service and vice-versa
  • MongoDB-formatted JSON file to an Oracle NoSQL Database table on-premise or cloud
For more details, see Overview of Oracle NoSQL Database Migrator in Using Oracle NoSQL Database Cloud Service.

September 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Dubai in EMEA data region.

See Data Regions and Associated Service URLs.

August 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • San Jose in North America data region.

See Data Regions and Associated Service URLs.

July 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Jeddah in EMEA data region.

See Data Regions and Associated Service URLs.

June 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in a new region:
  • Chuncheon in APAC data region

See Data Regions and Associated Service URLs.

May 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in five new regions:
  1. North America data region
    1. Montreal
  2. APAC data region
    1. Osaka
    2. Melbourne
    3. Hyderabad
  3. LAD data region
    1. Sao Paulo

See Data Regions and Associated Service URLs.

April 2020

Feature Description
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in five new regions:
  1. North America data region
    1. Toronto
  2. APAC data region
    1. Tokyo
    2. Seoul
  3. EMEA data region
    1. Amsterdam
    2. London

See Data Regions and Associated Service URLs

March 2020

Feature Description
Manage tables and table data from your Node.js applications You can now use the Node.js SDK that enable your Node.js applications to create, update, and drop tables as well as add, read, and delete data in the tables. See:
Manage tables and table data from your Go applications You can now use the Go SDK that enable your Go applications to create, update, and drop tables as well as add, read, and delete data in the tables. See:
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in five new regions:
  1. North America data region
    1. Ashburn
  2. APAC data region
    1. Mumbai
    2. Sydney
  3. EMEA data region
    1. Frankfurt
    2. Zurich

See Data Regions and Associated Service URLs

February 2020

Feature Description
Integration with Oracle Cloud Infrastructure.
Oracle NoSQL Database Cloud Service is completely integrated with Oracle Cloud Infrastructure. As a result, the following features are integrated into the NoSQL Database Cloud Service:
  • Oracle Cloud Infrastructure Identity and Access Management replaces Oracle Identity Cloud Service for implementing Identity, Permissions, and Compartments. See Managing Table Access and Security.
  • Oracle Cloud Infrastructure console to create, manage, and monitor NoSQL tables and data. See Using the Console to Manage Tables.
  • Oracle Cloud Infrastructure tags
  • Oracle Cloud Infrastructure auditing
  • Oracle Cloud Infrastructure search
  • Oracle Cloud Infrastructure limits and quotas
  • Oracle Cloud Infrastructure monitoring
Naming tables in your application code changes because of Oracle Cloud Infrastructure Identity and Access Management integration. Table naming has changed to fit in with Oracle Cloud Infrastructure compartments. For details, see About Compartments.
The Oracle NoSQL Database Cloud Service query language is updated with new features. The Oracle NoSQL Database Cloud Service query language is improvised with new feature updates. They are:
  • Enhanced query support for sorted and aggregated queries.
  • Support for geo_near in NoSQL Database queries.
  • Support for Identity columns.

September 2019

Feature Description
Use IntelliJ plug-in to quickly build and run queries You can now use the IntelliJ plug-in to browse tables and execute queries on your Oracle NoSQL Database Cloud Service instance or simulator. See IntelliJ Plug-in.
Universal Credit accounts do not use My Services Dashboard After signing into Oracle Cloud, you use the Oracle Cloud Infrastructure Console to access your service. Previously you were required to access the service from the My Services Dashboard.
New Data Region locations available Oracle NoSQL Database Cloud Service is now available in four new regions:
  • Canada Southeast (Toronto)
  • UK South (London)
  • South Korea Central (Seoul)
  • Japan East (Tokyo)

See Data Regions and the Associated Service Endpoints.

May 2019

Feature Description
Manage tables and table data from your Python application You can now use the Python SDK that enables your Python application to create, update, and drop tables as well as add, read, and delete data in the tables. See:

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.