NoSQL Database Cloud

The following features have been added to Oracle NoSQL Database Cloud:

• Oracle NoSQL Database Cloud Service is now available in these new regions:
  • Boardman in North America data region.
  • Desmoines in North America data region.
  • Quincy in North America data region.
  • Shawnee in North America data region.
  • Dallas in North America data region.
  • Abilene in North America data region.
  • Riyadh in EMEA data region.
  • Dublin in EMEA data region.
  • Kulai in APAC data region.
  • Batam in APAC data region.
• Global Active tables:
  • Oracle NoSQL Database Cloud Service supports freezing the schema of a table that does not contain a JSON column.
• RUST SDK:
  • Oracle NoSQL Database Cloud Service supports Rust SDK that enables your Rust applications to create, update, and drop tables as well as add, read, and delete data in the tables.
• NoSQL Database Migrator release 1.7.0 supports the following additional authentication options:
  • Session token-based authentication.
  • OKE Workload Identity Authentication (WIA).
• NoSQL Database Migrator release 1.6.5 includes a new configuration parameter to support importing TTL data from the following sources:
  • DynamoDB-Formatted JSON File.
  • DynamoDB-Formatted JSON File stored in AWS S3.
• The Visual Studio Code plugin for Oracle NoSQL Database Cloud Service offers these new features:
  • Create child tables using form based entry or supply DDL statements.
  • Convert a singleton table to a Global Active table.
  • Freeze/UnFreeze Schema.
  • Add/Delete/View Replicas.
  • Edit Reserved Capacity such as Provisioned or On Demand Capacity.
  • Highlight syntax and autocomplete SQL query.
  • Interactive JSON viewer with expandable tree nodes and real-time search functionality for seamless data exploration.
• Oracle NoSQL Database Cloud Service supports the following additional authentication methods:
  • Token-based Authentication: Allows you to create and use a temporary session token to authenticate and access Oracle Cloud Infrastructure resources (OCI).
  • OKE Workload Identity-based Authentication: Allows you to grant K8s pods policy-driven access to OCI resources using OCI Identity and Access Management (IAM).
• Dedicated Hosted Environment:
  • Oracle NoSQL Database Hosted Environment is supported, which 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.

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

• US Midwest (Chicago)in North America data region.
• Serbia Central (Jovanovac) in EMEA data region.
• Mexico Northeast (Monterrey) in LAD data region.
• Chile West (Valparaiso) in LAD data region.
• Colombia Central (Bogota) in LAD data region.

The following new feature is now available in Oracle NoSQL Database Cloud Service:

• Global Active Tables: An active/active set of table replicas across a choice of cloud regions, for local read and write performance of globally distributed applications. Additionally, it offers application resiliency and continuity with seamless Disaster Recovery (DR).

The following features have been added to Oracle NoSQL Database Cloud:

• Changes in Terraform script for updating NoSQL table definition: While using Terraform scripts, the table schema can be updated based on the 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 the 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

The following are the new features/changes are available in Oracle NoSQL Database Cloud Service:

• 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 sources and sinks.

The following new functionality has been added to 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.

The following are the new features are available in Oracle NoSQL Database Cloud Service:

• 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.

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

• Mexico Central (Queretaro) in LAD data region.

Oracle NoSQL Database Cloud is now available in the following regions:

• France Central (Paris)

The following are the new features/changes are available in Oracle NoSQL Database Cloud Service:

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

The following are the new features available in Oracle NoSQL Database Cloud Service:

• 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.

The following are the new features available in Oracle NoSQL Database Cloud Service:

• Oracle NoSQL Database Visual Studio Code Extension - You can now 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.

Oracle NoSQL Database Cloud is now available in the following regions:

• South Africa Central (Johannesburg)