What’s New for 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

April 2024

Feature	Description
Dedicated Hosted Environment	Oracle NoSQL Database Hosted Environment offers a NoSQL environment that is dedicated to your tenancy with dedicated direct attached storage. You pay a fixed monthly hosted environment cost and are entitled to use all the write, read, and storage capacities offered by the environment.

October 2023

Feature	Description
Global Active tables	Oracle NoSQL Database Cloud Service supports a global active table architecture in which you can create tables, replicate them across multiple regions, and maintain synchronized data across the regional replicas.
Migrate/Copy data between Oracle NoSQL Database Cloud Service regions	Oracle NoSQL Database Migrator can be used to perform cross-region data migration.
Oracle NoSQL Database Migrator to work with tables that have identity columns	You can import the data from a valid source to a sink table (On-premises/Cloud Services) with an IDENTITY column using Oracle NoSQL Database Migrator.

May 2023

Feature	Description
Changes in terraform script for updating NoSQL table definition	While using Terraform scripts, the table schema can be updated based on new version of create table ddl statement instead of an alter table statement.That is to update the definition of a table, you use a new CREATE TABLE as the ddl_statement and internally the compiler parses the ddl and compares with the existing table definition and generates an equivalent alter table statement and applies it to the table.
Additional features available in IntelliJ plugin	The IntelliJ plugin for Oracle NoSQL Database offers these new features: Add new columns using form-based entry or supply DDL statements Drop Columns Create Indexes Drop Indexes Execute DML statements to update, insert, and delete data from a table
Additional features available in Visual Studio Code Extension	The Oracle NoSQL Database Visual Studio (VS) Code extension for Oracle NoSQL Database offers these new features: Add new columns using form-based entry or supply DDL statements Drop Columns Create Indexes Drop Indexes Execute DML statements to update, insert, and delete data from a table Download the Query Result after running the SELECT query into a JSON file Download each row of the result obtained after running the SELECT query into a JSON file

December 2022

Feature	Description
New Data Region location available	Oracle NoSQL Database Cloud Service is now available in a new region: Chicago in North America data region. See Data Regions and Associated Service URLs.
Migrator utility updates	Enhanced the migrator to support importing CSV files that conform to the RFC4180 standard. Users can create a NoSQL table that corresponds to CSV file fields either manually or through the migrator. The migrator now supports table creation with on-demand capacity and Import/Export of Child tables in NDCS. Additionally, it provides an option to specify OCI Object Storage service namespace for valid source and sinks.

Feature

Description

New Data Region location available

Oracle NoSQL Database Cloud Service is now available in a new region:

Chicago in North America data region.

See Data Regions and Associated Service URLs.

Migrator utility updates

Enhanced the migrator to support importing CSV files that conform to the RFC4180 standard. Users can create a NoSQL table that corresponds to CSV file fields either manually or through the migrator. The migrator now supports table creation with on-demand capacity and Import/Export of Child tables in NDCS. Additionally, it provides an option to specify OCI Object Storage service namespace for valid source and sinks.

September 29, 2022

Feature	Description
New functionality in OCI console	The following new functionality has been added in the OCI console Bulk upload of table rows: The Upload Data button in the Table details page allows bulk uploading of data from a local file into the table, via the browser. The Bulk upload feature is intended for loading less than a few thousand rows Query execution plan: You can now access the query execution plan for your SQL queries from the OCI console. On the Table Details page, you have a button to view the query execution plan.

Feature

Description

New functionality in OCI console

The following new functionality has been added in the OCI console

Bulk upload of table rows: The Upload Data button in the Table details page allows bulk uploading of data from a local file into the table, via the browser. The Bulk upload feature is intended for loading less than a few thousand rows
Query execution plan: You can now access the query execution plan for your SQL queries from the OCI console. On the Table Details page, you have a button to view the query execution plan.

September 2022

Feature	Description
New Data Region location available	Oracle NoSQL Database Cloud Service is now available in two new regions: Italy Northwest (Milan) in EMEA data region. Spain Central (Madrid) in EMEA data region. See Data Regions and Associated Service URLs.

Feature

Description

New Data Region location available

Oracle NoSQL Database Cloud Service is now available in two new regions:

Italy Northwest (Milan) in EMEA data region.
Spain Central (Madrid) in EMEA data region.

See Data Regions and Associated Service URLs.

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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: North America data region Montreal APAC data region Osaka Melbourne Hyderabad LAD data region Sao Paulo See Data Regions and Associated Service URLs.

Feature

Description

New Data Region locations available

Oracle NoSQL Database Cloud Service is now available in five new regions:

North America data region
1. Montreal
APAC data region
1. Osaka
2. Melbourne
3. Hyderabad
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: North America data region Toronto APAC data region Tokyo Seoul EMEA data region Amsterdam London See Data Regions and Associated Service URLs

Feature

Description

New Data Region locations available

Oracle NoSQL Database Cloud Service is now available in five new regions:

North America data region
1. Toronto
APAC data region
1. Tokyo
2. Seoul
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.
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.
New Data Region locations available	Oracle NoSQL Database Cloud Service is now available in five new regions: North America data region Ashburn APAC data region Mumbai Sydney EMEA data region Frankfurt Zurich See Data Regions and Associated Service URLs

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.

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.

New Data Region locations available

Oracle NoSQL Database Cloud Service is now available in five new regions:

North America data region
1. Ashburn
APAC data region
1. Mumbai
2. Sydney
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. Oracle Cloud Infrastructure console to create, manage, and monitor NoSQL tables and data. 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
Manage tables and table data from your Node.js application	Oracle NoSQL Database Cloud Service now provides a Node.js SDK that enables your Node.js application to create, update, and drop tables as well as add, read, and delete data in the tables.
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.
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 Associated Service URLs.

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.

Title and Copyright Information

What’s New for Oracle NoSQL Database Cloud Service

Oracle and/or its affiliates.

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.