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 6.0.2
Added Log-Structured Archive (LSA) to improve Storage Manager (SM) write performance
For more information, see Log-Structured Archive (LSA).
Added Merge Tree indexing to improve performance for random insert or update operations
For more information, see Merge Tree Indexing.
Merge Tree indexing is supported only for non-unique indexes. |
nuoarchive check
now displays LSA atom statistics
To display the quantities and a size histogram of each type of atom in LSA, use nuoarchive check --show-stats
.
For more information, see NuoDB Archive - Checking.
Added support for Java 21
Added Java 21 runtime support for the Administrative Process (AP) and the JDBC driver. For more information, see System Requirements.
Added additional logging information to nuoadmin.log
during database upgrade
During a database upgrade, the messages logged to nuoadmin.log
include the storage group ID on which the update has been applied.
Added the SYSTEM.MULTIINDEXES
pseudo table to view information about Merge Tree indexes and their components
For more information, see MULTIINDEXES System Table Description.
Added the following fields to the LASTSTATEMENT
system table
-
HASHHITS
-
HASHINSERTS
-
HASHPROBES
For more information, see LASTSTATEMENT System Table Description.
Added the following fields to the TABLES
system table
-
AUTOCREATESTATS
-
NORECOMPUTE
For more information, see TABLES System Table Description.
Added the following fields to the CONNECTIONS
system table
-
COORDINATORCONNID
-
COORDINATORNODEID
-
COORDINATORHANDLE
For more information, see CONNECTIONS System Table Description.
Added the following system tables
-
COLUMNGROUPS
-
COLUMNGROUPFIELDS
For more information, see COLUMNGROUPS System Table Description, and COLUMNGROUPFIELDS System Table Description.
Added the VALUESBETWEEN
and DATAAFFINITYMAPPING
built-in table functions
For more information, see SQL Table Functions.
Added additional BEFORE/AFTER
DDL event triggers for sequences, procedures, functions, views, users, and schemas
For more information, see DROP TRIGGER, CREATE TRIGGER, and TRIGGERS System Table Description.
Added DEFAULT
as an alias for the UNPARTITIONED
storage group
For more information, see Predefined Storage Groups.
Added the BUILTINFUNCTIONS
systems table
For more information, see BUILTINFUNCTIONS System Table Description.
Added a new capability to remove the identity property of a generated column (13738)
For more information, see Remove the Identity Property of a Generated Column.
Added the nuoarchive check --show-disk-stats
option
For more information, see NuoDB Archive - Checking.
Added the nuoarchive restore --restore-archive
option to replace the nuoarchive restore --restore-dir
option
For more information, see NuoDB Archive - Restoring.
Added the --archive-type
argument to nuocmd
subcommands
To specify the type of archive used to restore, use the nuocmd restore archive --archive-type <archive_type>
argument, and to specify the type of archive used to start a containerized SM, use the nuocmd start sm --archive-type <archive_type>
argument.
For more information, see NuoDB Command Reference and Docker-specific NuoDB Command Reference.
Added the FOR UPDATE WAIT <lock_timeout_in_sec>
clause in SELECT
statements
For more information, see SELECT.
New Features Previously Included in NuoDB 5.1.x Releases
Applied additional logging obfuscation for SQL statements (14132)
Upgrade to the current release to apply the latest NuoDB security patches.
Added support for Hibernate 6 generated SQL statements with JOIN group syntax (13781)
Hibernate 6 generated JOIN group syntax that wraps join predicates in parentheses was not supported in NuoDB.
For example, Hibernate 6 generated SQL query such as, SELECT * FROM a JOIN (b JOIN c on x) on y
, is now supported.
Added the Right Hash Outer Join
execution operator for faster query execution
For more information, see Execution Plan Operators.
Added Spill to Disk support for hash join and hash grouping operators to reduce memory usage for large hash operations
For more information, see Execution Plan Operators and Supported Spill to Disk Operations.
Added lock-wait-timeout
to the SYSTEM.CONNECTIONPROPERTIES
pseudo table to view the lock wait timeout value for an existing connection
See the example on Connection Properties.
Improved the performance and execution times for SQL queries that include variables
SQL queries that include variables are now recompiled to generate a more optimized execution plan, resulting in better performance and faster execution times.
Added SQL syntax support for RIGHT OUTER join operations
For more information, see SELECT and RIGHT OUTER Join Operations.
Improved the performance and execution times for SQL queries that include variables in LIKE
SQL queries that include a variable in the LIKE
operator are now considered for reoptimization by the v3 optimizer
.
Improved the performance of SQL queries by extending the range of indexes for 'Bitmap intersections'
The optimizer will consider more 'Bitmap intersections' than before, providing additional opportunities to find an optimal access path. In particular, if a specific index is chosen to satisfy a property such as a join predicate or ordering, it will now check if that index can be further improved by intersecting it with additional indices.
Added the licenseFilePath
property to configure the path to the NuoDB license file
For more information, see Setting nuoadmin.conf
Properties.
Added the EXPLAIN (ANALYZE_GRAPH {ON|OFF})
option to debug performance characteristics of complex query plans
The EXPLAIN (ANALYZE_GRAPH {ON|OFF})
option displays the Graphviz representation of the explain plan.
Use any Graphviz viewer to produce a graphical representation of the explain plan to aid in debugging and troubleshooting complex query plans.
For more information, see EXPLAIN.
Optimized the execution of SQL queries that includes timestamp literals
When executing a SQL query that includes a comparison operation of a string or a timestamp to a date literal, a performance optimization has been added by converting the operand opposite the date literal to a date.
Enabled the use of Optimizer Hints in SQL Data Manipulation Language (DML) statements
For more information, see Using Optimizer Hints.
Added support for Common Table Expression (CTE) using the WITH
statement
For more information, see WITH.
Improved the performance of grouping and aggregation operations using the Hash grouping
execution plan operator
For more information, see Execution Plan Operators.