发布新帖

查找

InterSystems 官方
· 一月 31, 2023

InterSystems announces General Availability of InterSystems IRIS, IRIS for Health, HealthShare Health Connect, & InterSystems IRIS Studio 2022.3

InterSystems is pleased to announce the 2022.3 release of InterSystems IRIS Data Platform, InterSystems IRIS for Health, HealthShare Health Connect, and InterSystems IRIS Studio are now Generally Available (GA).

2022.3 is a Continuous Delivery (CD) release. Many updates and enhancements have been added in 2022.3, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. The new FHIR SQL Builder and enhancements to Columnar Storage are included, but both are still experimental features (not for production, with an active Early Access Program in place).  

 

Release Highlights

Platform Updates

InterSystems IRIS Data Platform 2022.3 expands support to include the following new & updated operating systems for production workloads:

  • Oracle Linux 9
  • SUSE 15 SP4.

SQL Enhancements

InterSystems IRIS 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 indices it accesses. Where the previous XML-based format used simple English phrases to describe different steps, the new format is easier to consumer 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 indices for the schema. 

InterSystems IRIS SQL now supports CREATE SCHEMA and DROP SCHEMA commands to include in scripts for setting up and tearing down your application environment.  

Speed, Scale, & Security

This release offers full elasticity for InterSystems IRIS Sharded clusters. DBAs can now call an API method to mark a shard for removal. Once this method is issued, data immediately gets offloaded from the designated shard to other data nodes in the cluster and automatically disconnect 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.  

Analytics & 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
  • 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

More details on all these features are available through these links below:

 

How to get the software

As usual, CD releases come with classic installation packages for all supported platforms, as well as container images in Docker container format.  For a complete list, refer to the Supported Platforms document.

Installation packages and preview keys are available from the WRC's Continuous Delivery Releases site or through the evaluation services website.

InterSystems IRIS Studio is available from the Components distribution page.

Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface.

yesFor additional information about docker commands, please see this post:: Announcing the InterSystems Container Registry web user interface. The build number for this developer preview release is 2022.3.0.606.0


FHIR SQL Builder

As we described before, FHIR SQL Builder is an experimental feature and is part of an active EAP (Early Access Program).To get access to this feature, please, email Patrick Jamieson, Product Manager for IRIS for Health at patrick.jamieson@intersystems.com.

3 Comments
讨论 (3)2
登录或注册以继续
文章
· 一月 30, 2023 阅读大约需 1 分钟

JSONfile-to-Global #2

The power of the presented tool becomes visible with a large JSON file.
The example I have prepared is composed of the daily results of AoC 2023.
Anonymization makes it usable for demo purposes.
As the original, it is an uninterrupted sequence of bytes without any NewLine or similar.
6 660 895 Bytes raw in sequence (as by NTFS). With this content (shrinked):

 
It is loaded into an %DynamicObject using the method %FromJSONfile.
If you try to investigate that object using ZWRITE  you end with <MAXSTRING>
And this is perfectly correct. The maximum string size is exceeded.

If you iterate down to the embedded JSON objects this conflict is gone as they are only ~30kB
The mystery is exercised by %Stream.DynamicCharacter which acts in the background.

The resulting Global is as huge as its source.
But now you can navigate and examine the individual elements.
A snapshot from SMP in the resulting Global top subscript

and total:

I had to run this from Terminal as SMP failed after a few 10000 lines and used this single line instead:

s g="^json" f i=1:1 s g=$q(@g,1,v) q:g=""  w i,":",?8,g,?78,"= ",v,!
ObjectScript
ObjectScript

Video

GitHub

1 Comment
讨论 (1)1
登录或注册以继续
文章
· 一月 30, 2023 阅读大约需 2 分钟

JSONfile-to-Global #1

The similarity between JSON objects + arrays and Globals in IRIS or Caché is evident.
With small and medium size JSON objects navigation across %Dynamic Objects is comfortable.
But with large and/or deep cascaded objects it becomes a challenge.

The presented tool offers 3 variants

  • loading an already existing %Dyamic object or Array into a global of your choice
  • loading a %Stream containing a JSON object into a global of your choice
  • loading an external File containing a JSON object into a global of your choice

How to use it

USER>read str
{"id":306904,"last_star_ts":0,"completion_day_level":{},"global_score":0,"local_score":0,"stars":0,"name":"name_1"}
USER>set jsn={}.%FromJSON(str)
USER>write ##class(rcc.jstog).toglobal(jsn,"^jsn")
1
USER>zwrite ^jsn
^jsn("global_score")=0
^jsn("id")=306904
^jsn("last_star_ts")=0
^jsn("local_score")=0
^jsn("name")="name_1"
^jsn("stars")=0

USER>zzjson jsn
{
  "id":306904,
  "last_star_ts":0,
  "completion_day_level":{
  },
  "global_score":0,
  "local_score":0,
  "stars":0,
  "name":"name_1"
}
USER>

from an already existing Stream, it's like this


USER>write ##class(rcc.jstog).stream(jsonstream,"^jsstr")
1

and from a file it is this method:


USER>set filename="/opt/irisbuild/src/data/demo.json"
USER>write ##class(rcc.jstog).file(filename)  ; using default gloabel ^jsom
1
USER>

File content:
 

Global content:

This might not look so spectacular.
But see and try the difference with a 6 MB sized JSON Object.

Video

GitHub

1 Comment
讨论 (1)1
登录或注册以继续
文章
· 一月 27, 2023 阅读大约需 1 分钟

Global-Streams-to-SQL #3

Seeing results in SMP or Terminal

If you run the suggested queries from Terminal in  SQL shell you see:



This is not so thrilling as the Stream OID doesn't show the content.
So I have added a dump function to show the stream  rcc.dumps(<column name>)
of course dumping of binaries doesn't make much sense in terminal so CHR and CZIP are typical.
see:


And it works even in SMP { IRIS for Windows (x86-64) 2022.3 (Build 589U)  } processing in foreground


 

Online Demo:  SuperServer Port for external ODBC / JDBC is 60001

I hope for your votes in the contest.

讨论 (0)1
登录或注册以继续
InterSystems 官方
· 一月 24, 2023

InterSystems publishes developer preview #6 for InterSystems IRIS, IRIS for Health, & HealthShare Health Connect 2022.3

InterSystems announces another developer preview release, as part of the developer preview program for the 2022.3. Many updates and enhancements have been added in 2022.3 and there are also brand new capabilities, such as the new FHIR SQL Builder, improvements for Columnar Storage, and adds support to SUSE 15 SP4 and Oracle Linux 9. Some of these features or improvements may not be available in this current developer preview.

Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can build a better product together.

As usual,  CD releases come with classic installation packages for all supported platforms, as well as container images in Docker container format.  For a complete list, refer to the Supported Platforms document.

Installation packages and preview keys are available from the WRC's preview download site or through the evaluation services website (use the flag "Show Preview Software" to get access to the 2022.3).

Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface.

yesFor additional information about docker commands, please see this post:: Announcing the InterSystems Container Registry web user interface.

The build number for this developer preview release is 2022.3.0.599.0.

For a full list of the available images, please refer to the ICR documentation. Alternatively, tarball versions of all container images are available via the WRC's preview download site.

NOTE: ARM Community containers are not available for this Developer Preview #6.

5 Comments
讨论 (5)1
登录或注册以继续