New Features
This section includes new features and enhancements.
If a new feature or enhancement relates to a Zendesk request, the associated Zendesk reference number is displayed, for example (10118).
New Features in NuoDB 5.0
A sub-set of these features may be available in maintenance releases for prior versions.
Added new database process metrics
The new database metrics are:
-
CleanObjectsBytes
-
DirtyObjectsBytes
-
IncomingMessagesBytes
-
OutstandingObjectRequests
For more information, see Metrics Published by Database Processes.
Added logging category sql-results
The sql-results
logging category logs query results to facilitate debugging and diagnostics.
For more information, see Description of Logging Options.
Improved Storage Manager (SM) write throttle memory management
The SM write throttle mechanism was improved to use memory more efficiently allowing for greater overall SM reliability and resilience by reducing memory oscillation and out of memory related process shutdown events. (12214, 12237, 12238)
Added support for Java 17
The Administrative Process (AP) and JDBC driver can now use the Java 17 Runtime Environment. For more information, see System Requirements.
Optimized queries with parameterized LIKE
predicates
Improved runtime performance for queries with parameterized LIKE
predicates through outer to inner join optimization when applicable, and applied further optimizations if the parameter started without a wildcard.
Added JSON built-in functions (12047, 12052, 13049)
The following JSON built-in functions were added:
-
IS_VALID_JSON
-
JSON_CONTAINS
-
JSON_CONTAINS_PATH
-
JSON_EXTRACT
-
JSON_EXISTS
-
JSON_MERGE_PATCH
-
JSON_OBJECT
-
JSON_QUERY
-
JSON_UNQUOTE
-
JSON_VALUE
For more information, see SQL JSON String Functions.
Improved JSON function runtime performance
Added support for the RapidJSON library which delivers significantly improved runtime performance when executing JSON functions.
Added the REOPTIMIZE ALWAYS|NEVER
query hint to allow application control of SQL recompilation behavior
For more information, see REOPTIMIZE Hint.
If deploying in Kubernetes, users can now specify the location of the nuoadmin.conf
file
For more information, see NuoDB command start admin
.
Added Kubernetes multi-tenancy support
Upgraded the Fabric8 Kubernetes client to version 5.12.2 in the NuoDB container image. The new support allows the creation of two NuoDB Admin domains in the same Kubernetes namespace.
Improved archive synchronization performance
Archive synchronization performance has been improved for a new or out-of-date archive. Database load imposed by archive synchronization has been reduced by:
-
Reducing writes to the journal on the SYNCING Storage Manager (SM)
-
Reducing memory overhead for archive synchronization on both the SYNCING SM and the RUNNING SMs
-
Reducing the processing of messages on both the SYNCING SM and the RUNNING SM
Added support for computed columns
For more information on computed columns and optionally how to use them to partition a table, see ALTER TABLE and CREATE TABLE.
Added a new Date/Time data type TIMESTAMP WITHOUT TIME ZONE
For more information, see SQL Date and Time Types.