Sadas Engine – Release note

WITH Clause: Introduced the WITH clause, which can be added before a SELECT statement to define aliases for complex subqueries that are referenced multiple times within the SELECT statement.

Customizable LOG for Splunk: Introduced functionality to create a specialized (and customizable) LOG compatible with Splunk.

String Similarity and Distance Functions: Introduced functions to measure similarity and distance between strings. The implemented metrics include Sørensen-Dice, Levenshtein, Jaro-Winkler, and Longest Common Subsequence (LCSeq).

Shared SPOOL mechanism for INSERTs: Created a mechanism for INSERT operations such that the insertion spool can be used for commits and by another consumer to feed other tables. It is now possible to define shared SPOOLs between databases. These SPOOLs can be used to feed tables (LOAD FROM SPOOL).

Extended Syntax for APPEND, REWRITE, LOAD: Enhanced these commands with the option to specify CHECKFILE for compliance checking of the file before loading.

Support for Compressed input streams: It is now possible to use compressed data streams in .gz format for a direct table loading.

REBUILD TABLE Command: Introduced the REBUILD TABLE command to attempt the recovery of a corrupted table.

Query Result Export: Added the syntax [APPEND] INTO '' to export the result set of a query to a file.

SET VARIABLE PAGING_SIZE AUTO: Introduced this command to optimize the performance of SELECT * FROM by automatically configuring the best value for RPAG in the current session.

TRANSPOSE Clause: Introduced the TRANSPOSE clause to obtain the transpose of a result set, e.g., SELECT TRANSPOSE CITY, COUNT(*) FROM ANAGRAFE GROUP BY CITY.

DBLINK: Added the ability to define DBLINK for performing IMPORT TABLE or APPEND TABLE operations from remote database sources.

New commands for partialization: Introduced commands for describe managing database partialization. PARTIALIZE TO BY DESC SYS_PARTIALIZATIONS

Added parameters for concurrency management.

Default Table CTL values for newly created tables can now be specified in the settings.

Join Attribute Projection: Projection conditions for join attributes (INNER or implicit) are automatically added on all tables involved in the join to improve performance.

Error Reporting in Loading Processes: Improved error reporting during table loading processes.

Query Performance: Enhanced the performance of queries involving aggregation and sorting operators.

Segment Management: Extended segment management capabilities, allowing DDL operations directly on the segment head.

Database Restore Synonyms: The DB restore process now correctly updates any external synonyms pointing to the same DB.

BACKUP & RESTORE Path Management: Columns stored in paths different from the table's main path are now correctly managed by BACKUP & RESTORE.

Various Bug Fixes

Automatic Data Partitioning Segments functionalities extended with the introduction of automatic mechanisms for horizontal partitioning

Sadas Gateway: GATEWAY mode introduction for Sadas Listener module (clustering of one or more Sadas Engine instances distributed on different physical machines)

Log management: Introduction of a rotation mechanism for log files

General improvement of performances and stability

Communication encryption

SnapShot: is to manage distinct photographs (snapshots) of data having the same logical structure (table) but referring to distinct moments in time.

Partitioned Table: Segmentation in Sadas offers the DBA the possibility of being able to physically divide and physically distribute the records of high-cardinality historical archives on distinct volumes (segments), while at the same time keeping the logical unit level (table) unchanged when used in writing of queries for end users.

Data Dictionary

New SQL functions: Set functions (GROUPNUM, INTEGRAL), aggregate functions (GROUPINTEGRAL, SUMINTEGRAL) general functions (REGEXP, DATEDIFF_WORKDAY)

Like index up to 20 times faster