New in InterSystems IRIS 2022.3
This page describes the new and enhanced features in the 2022.3 release of InterSystems IRIS®, which is a Continuous Delivery (CD) release.
For a more exhaustive list of the changes included in this release, refer to the Upgrade ChecklistOpens in a new tab.
Enhancing Developer Experience
SQL Development
InterSystems SQL now offers a machine-readable format for query plans. Using this new option, the $SYSTEM.SQL.Explain() method will now produce a JSON-based rendering of the query plan with significantly more detail on the plan itself as well as the tables and indexes it accesses. Where the previous XML-based format used simple English phrases to describe different steps, the new format is easier to consume for tools that wish to perform more thorough analysis or graphical rendering of query plans.
This release introduces an opt-in capability to sample runtime parameters for SQL statements. The Statement Index already records a rich set of metadata such as detailed runtime statistics and query plans for each statement, which typically has any literals substituted for placeholders that parameterize the cached query code. Now, the statement index can be extended with a sampling of the actual runtime values for those parameters. These can then be combined with the normalized statement text to, for example, build a representative workload that can be run against another deployment, for example to benchmark a new hardware environment or experiment with a different set of indexes for the schema.
InterSystems SQL now supports CREATE SCHEMA and DROP SCHEMA commands to include in scripts for setting up and tearing down your application environment.
Enhancing Analytics and AI
This release provides the following enhancements to analytics and AI:
-
Updated version of InterSystems Reports (Logi Report 19.2): Key improvements are:
-
Bookmark feature - save parameters and filters on a web report
-
Report Studio available on the Report Server to provide additional report editing directly from Server
-
For more details, see: https://devnet.logianalytics.com/hc/en-us/articles/9898557594903-Logi-Report-v19-2-Release-NotesOpens in a new tab
-
-
Updated version of Adaptive Analytics (AtScale 2022.3) Key improvements are:
-
Support for the timeline feature in Microsoft Excel
-
Data Catalog API to expose the AtSCale Semantic Layer to data catalog vendors
-
For more details, see https://documentation.atscale.com/installer/I2022.3.0/release-notes/new-features-and-improvementsOpens in a new tab (requires login)
-
Enhancing Speed, Scale, and Security
This release offers full elasticity for Sharded clusters. DBAs can now call an API method to mark a shard for removal. The method offloads data from the designated shard to other data nodes in the cluster and automatically disconnects the node when all data buckets have been successfully moved to other shards. This process leverages the same mechanism as Online Rebalancing, meaning users can continue to query sharded tables and ingest data into them while the data is being moved.
Platform Updates
This release adds support for the following new server platforms:
-
Oracle Linux 9
-
SUSE 15 SP4