New in InterSystems IRIS 2023.2

InterSystems SQL: Safe Query Cancellation

This release introduces a new command for InterSystems SQL to cancel running statements safely and reclaim any resources used by the statement, including memory and temporary space: CANCEL QUERY. The CANCEL QUERY command accepts the statement ID as an argument. This ID is available using the SQL Process View (INFORMATION_SCHEMA.CURRENT_STATEMENTS) which was introduced in a previous release. CANCEL QUERY ensures that participating worker threads are released without accidentally interfering with a different statement if the target one has already ended, which was a risk with manually terminating a query prior to the introduction of this capability. The InterSystems IRIS Management Portal has been updated to leverage this new functionality.

Time Series Forecasting in IntegratedML (Experimental)

IntegratedML® can now be used for predicting future values for one or more time-dependent variables. The feature comprises new syntax for creating models (CREATE TIME SERIES MODEL), as well as for training models and consuming predictions (SELECT WITH PREDICTIONS). To use IntegratedML for time series forecasting, the source table or view must have a timestamp column that represents the collection time for the data. Time series models are only supported for the InterSystems AutoML and DataRobot providers; a future InterSystems IRIS release will extend this support to H20.

This feature is currently experimental; customers who are interested should apply to take part in the accompanying Early Access Program (https://www.intersystems.com/early-access-program/Opens in a new tab).

InterSystems Reports 2023.2

InterSystems Reports 2023.2 incorporates Logi Reports v23.2.Opens in a new tab New capabilities include:

• Increased functionality in Page Report Studio to enable customizations from Report Server.

• Additional Bookmark management.

This new component is available from WRC Software DistributionOpens in a new tab as InterSystems Reports Designer and InterSystems Reports Server 23.2.

InterSystems Adaptive Analytics 2023.2

InterSystems Adaptive Analytics 2023.2 incorporates AtScale version 2023.2Opens in a new tab. New capabilities include:

• Token-based authentication to support Microsoft PowerBI in Azure environment (as requested by InterSystems)

• Scheduling of aggregate builds on a per-cube basis at convenient times for better performance management

• Usage Metrics Dashboard

This new component is available from WRC Software DistributionOpens in a new tab as InterSystems Adaptive Analytics 2023.2.

SQL Performance Improvements

This release includes various performance enhancement across InterSystems SQL process which are 100% transparent to users:

• The Global Iterator is an internal module that shifts much of the work traversing indexes and data maps into the kernel, as opposed to leveraging ObjectScript. The use of the Global Iterator has been significantly expanded since the previous release of InterSystems IRIS.

• The Adaptive Parallel Execution framework (APE) was first introduced for queries involving columnar storage: rather than preparing and executing separate parallel subqueries, APE generates parallel worker code into the same cached query class as the main query. APE is now being expanded to an increasing number of query patterns which access regular (row) storage. This should lead to increased performance and manageability for your SQL-based applications.

For all of the preceding features, more enhancements are planned for future releases, gradually expanding the scope of these newer, more efficient query processing paradigms and frameworks.

Kernel-Level Performance Improvements

This release includes several kernel-level performance improvements that transparently benefit customer applications:

• Where possible, the global module now reads a set of physically contiguous big string blocks using a single, large IO operation. Big string blocks are used for storing long strings and columnar data.

• Mirroring now uses large asynchronous IO operations to read and write journal files through the agent channel, leading to a significant increase in mirror agent throughput.

End of Support for Windows Server 2012

Effective with this release, InterSystems IRIS no longer supports Windows Server 2012. To continue to run on a supported Microsoft server platform, please upgrade your operating system to Windows Server 2016, Windows Server 2019, or Windows Server 2022.