The Oracle NoSQL Database Blog covers all things Oracle NoSQL Database. On-Prem, Cloud and more.

  • May 4, 2021

Oracle NoSQL Database 21.1

Tim Goh
Principal Product Manager

We are excited to announce the availability of Oracle NoSQL Database, Enterprise Edition (EE) Version 21.1. This release comes with new powerful features for enterprises to meet the increasingly competitive business global environment and challenges.


Oracle NoSQL Database is a flexible, multi-model, multi-region, hybrid-cloud, active-active database designed to provide a highly available, scalable, performant, and reliable data management solution to meet today's most demanding workloads. Focusing on simplicity and developer productivity, deploying in hybrid-cloud or on-premise environments is automated and completes with just a few clicks. The built-in cross-region replication can be enabled in minutes to deploy a fully active-active system.

Oracle NoSQL Database is well-suited for high volume and velocity workloads, like Internet of Things, customer 360, online advertising, fraud detection, consumer scale persistent session management, user personalization, and online gaming. Developers can use a single application interface to build applications quickly that run anywhere.



Conflict-Free Replicated Data Type - Oracle NoSQL Database supports Multi-Region tables, enabling active-active data replication across geographically distributed NoSQL deployments. Building on the strength of the Multi-Region table feature, the new CRDT feature adds a new technique to handle update coordination. The existing conflict resolution approach uses a built-in rule to decide which region's update is considered final. With Oracle NoSQL Database’s new conflict-free replicated data type (CRDT for short), updates across regions will converge on the correct value, using the commutative properties of addition. The new MR_COUNTER datatype, a subtype of the INTEGER, LONG, or NUMBER data types, is used to identify the field as a CRDT; enabling independent updates across regions without the need for coordination or conflict resolution. An MR_COUNTER field enables each region to automatically converge on the correct state of that field without requiring any conflict resolution code or user intervention. Data changes in different regions occur concurrently and are not synchronized with one another. In essence, changes are merged across regions by the system. Fields specified as MR_COUNTER can be incremented or decremented and can serve as a general-purpose counter across multiple regions. More details.

Nested Array / Map Indexing - Oracle NoSQL Database is designed with rich indexing capability for query performance and flexibility. This feature adds the ability to index into nested arrays and maps in addition to the existing single field and composite (more than 1 field) indexes. This feature creates an index on a data field inside an array which in turn is present inside another array. Real-world use cases that are modeled as schema-less JSON in the database often come with deeply nested data sources capturing the hierarchical relationship. With this feature, there is no need for developers to re-design the data model. Deeply nested and high cardinality data can be kept in its original form and indexed to achieve high performance during queries. More details.

Spring Data Support - The Oracle NoSQL Database SDK for Spring Data is available now for both on-premises and cloud deployments. It provides POJO (Plain Old Java Object) centric modeling and integration between the Oracle NoSQL Database and the Spring framework. This feature provides the Java developer the ability to write application code as a "repository style" data access layer. Additionally, the Spring Data module maps these repository operations to Oracle NoSQL Database API calls, thus saving the developer from writing repetitive and monotonous code. Developers focus on writing high value business logic instead of database access code. This SDK is available on GitHub.

Functions on Row and Index Size - Oracle NoSQL Database's functions on rows feature extracts additional table properties that are not part of the schema. Such insights on tables are vital in managing and maintaining a performant NoSQL cluster. This feature supports two new functions. The row_storage_size() function extracts the persistent storage size (in bytes) used by the given row(s) of data. The index_storage_size() function extracts the persistent storage size (in bytes) used by the index for the given row(s) of data. Knowing the storage size of rows and indexes is critical in adjusting the storage capacity aspect of a NoSQL cluster. More details.



Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.