ProHoster > Blog > Administration > Release InterSystems IRIS 2019.1

Release InterSystems IRIS 2019.1

Mid March came out new version of InterSystems IRIS 2019.1 data platform

We present to your attention a list of changes in Russian. A complete list of changes and Upgrade Checklist in English can be found at link.

Improvements in InterSystems Cloud Manager

InterSystems Cloud Manager is a utility for easily deploying InterSystems IRIS installations in the cloud. In release 2019.1, ICM has the following features:

Client languages

The release includes new modules for working with InterSystems IRIS:

Improved scalability and distributed cluster management

A distributed cluster in InterSystems IRIS shares data and cache across multiple servers, providing flexible, cost-effective scalability for querying and adding data. This release includes the following improvements:

  • Support for more scripts for SQL. Nodes can now be added to the cluster at any time, regardless of the database schema and keys used. After adding a node, the data can be rebalanced (offline). Read more - "Rebalance Sharded Data Across Additional Shard Data Servers».
  • The Management Portal has a new page with cluster overview and configuration.
  • New API for creating a consistent cluster backup. Read more - "Coordinated Backup and Restore of Sharded Clusters».
  • The new Java utility for bulk data loading is also optimized for working with a cluster.

Improvements in SQL

This release includes significant improvements in the speed and ease of use of SQL.

  • Auto-parallelization of suitable queries. Read more - "System Wide Parallel Query Processing».
  • New TUNE TABLE command for configuring a table via the SQL interface. Read more - "TUNE TABLE».
  • Improvements to SQL Shell, which now allows you to view schemas, tables, and views defined or available in the current scope. Read more - "Using the SQL Shell Interface».
  • Query Plan View now shows subplans of compound plans when parallelized and when querying a cluster.
  • You can now add options to the query body to override the SQL system settings for that query. Read more - "comment options».
  • With each release, InterSystems includes various SQL enhancements that are invisible to the application. In 2019.1, especially many of these improvements were added to the query optimizer and code generator. Together with the automatic parallelization of user queries, this should significantly improve the performance of applications using InterSystems IRIS SQL.

Improvements in Analytics

  • Ability to set partial dates in Business Intelligence. For example, specify a date for which only the year or year and month are known. Read more - "Partial Dates».
  • New %SQLRESTRICT construct for filtering data via SQL inside an MDX query.

Improvements in integration capabilities

There are many improvements in this release that make it easier to configure and troubleshoot products:

  • Search and view all the paths a message can take in a production. Read more - "Viewing Interface Maps».
  • Finding places where product components refer to other product components. Read more - "Finding Interface References».
  • Testing data transformations. In the test dialog, you can now set values ​​for the aux, context, and process objects, as if the transformation were called with initialized objects. More «Using the Transformation Testing Page».
  • DTL editor. New actions - switch/case. Possibility group actions и add comments to transformations.
  • Now you can send a message to the rule and see the result of the execution without running the message through all the products. Read more - "Testing Routing Rules».
  • Ability to download messages from Message Viewer to your local computer. Read more - "Exporting Messages».
  • Ability to download log events to the local computer. Read more - "Introduction to the Event Log Page».
  • In the rule editor, you can now add comments to rules and open and edit transformations that are used in the edited rule.
  • The Queue Wait Alert setting now specifies the amount of time after which a message that is queued for a production item or an active message generates an alert. Previously, this timeout only applied to messages in the production item's queue. Read more - "Queue Wait Alert».
  • Restricting access to "System Defaults". Administrators can set up users to edit, view, or delete default settings. Read more - "Security for System Default Settings».
  • Ability to export products to a local computer. Read more - "Exporting a Production».
  • It is possible to deploy products from a local computer. Read more - "Deploying a Production on a Target System».
  • Extended navigation on the product settings page. Links have been added to bookmarks on the product setup page to quickly open related items in a separate window. On the Queue tab, clicking on a message number opens the trace. On the Messages tab, clicking on a session number opens the trace. On the Processes tab, clicking on the message number opens the trace, and on the process number, a window with process details.
  • New options in the Add Business Product Item Wizard. Users can now automatically assign system defaults if fields are left blank and set a packet prefix to generate routing rules. Read more - "Wizard Options».

System performance and capabilities

  • Significant scalability and performance improvements, particularly for large non-uniformly distributed memory access (NUMA) systems. These improvements include scalability changes in statistics collection and global buffer management, performance improvements in subscript-level mapping of globals, and other optimizations to avoid bypassing pointer blocks. To enable these improvements, changes have been made to the system and memory usage statistics described in checklist for this release. These improvements increase the amount of memory allocated for global buffer metadata by 64 bytes per buffer on Intel systems and by 128 bytes on IBM Power. For example, for an 8K block buffer, the growth would be 0,75% for Intel systems. These improvements have also resulted in minor changes to how statistics are displayed in the utilities and the Management Portal.
  • Key Management Interoperability Protocol (KMIP). Starting with this release, InterSystems IRIS can be an industrial key management server client. KMIP, an OASIS standard, gives the power of centralized key management. You can use KMIP server keys to encrypt both the database and individual items. KMIP server keys are available in the same way as keys stored in files, for example, to encrypt log files. InterSystems IRIS supports copying keys from the KMIP server to local files to create local backups. Read more - "Managing Keys with the Key Management Interoperability Protocol (KMIP)»
  • New DataMove utility for transferring data from one database to another while changing global display settings. Read more - "Using DataMove with InterSystems IRIS».
  • Support for strings longer than 3'641'144 in JSON objects.
  • Support for connecting IRIS Studio with Caché and Ensemble.
  • Support for the SPNEGO (Microsoft Integrated Windows Authentication) protocol for HTTP connections. Now %Net.HttpRequest can use HTTP 1.1 Windows authentication to connect to a secure server. Users provide access credentials, or %Net.HttpRequest will attempt to use the current context. Supported authentication schemes are Negotiate (Kerberos & NTLM), NTLM, and Basic. Read more - "Providing Authentication».
  • Performance improvements for logging and asynchronous I/O.

For users with support, release 2019.1 is available for download in the Online Distributions section of the site wrc.intersystems.com.

Anyone can try the new version by installing the Community Edition container, which available at dockerhub.com.

Source: habr.com

Add a comment