Hi Community,

Please welcome the new video from Global Summit 2019 on InterSystems Developers YouTube:

⏯ Scaling Up and Out on InterSystems IRIS

I try to compare classic JOIN against implicit JOIN.

It is a simple case. But I am surprised.

The class:
Class Sample.Person1 Extends (%Persistent, %Populate)
{  Property Name As %String;
Property Home As Sample.Address;
Property AR As array Of Sample.Address; }

Query #1 - classic:
select name,home_state,a.* from sample.person1 p
join sample.person1_AR a on p.Id=a.person1
and home_state=AR_state

Query #2 - implicit
select person1->name,person1->home_state,*
from sample.person1_AR where person1->home_state=AR_state

for both I have the same query plan:

It is a simple query on  2 or 1 simple  tables.

Keywords:  IRIS, IntegratedML, Machine Learning, Covid-19, Kaggle 

Continued from the previous Part I ... In part I, we walked through traditional ML approaches on this Covid-19 dataset on Kaggle. 

In this Part II, let's run the same data & task, in its simplest possible form, through IRIS integratedML which  is a nice & sleek SQL interface for backend AutoML options. It uses the same environment. 

IntegratedML Approach?

How to load data into IRIS

integredML-demo-template defined various ways to load data into

Some clients ask me about migrate from Cache to IRIS. Why migrate to IRIS? Cache is excellent, stable, has good performance. These clients are right, but in the last years, the digital transformation imposed more complete solutions for the new requirements and InterSystems was a visionary to perceive it and launch IRIS.
It is a data platform ready to this digital transformation challenge. To show this, I created a Value Canvas.

Value canvas are a perfect tool to show in a few minutes the value of the change.

Hi,

Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work SELECT $$JOB1^KMIGxDESIG() FROM DUAL

Work sELECT $$JOB1^KMIGxDESIG() FROM DUAL

for this I.m using ODBC 64.

Thanks

Dynamic PoolSize (DPS) Experiment

Purpose:

Enhance Ensemble or IRIS production so it can dynamically allocate pool size for adapter-based components based on their utilization.

Sometimes, an unexpected traffic volume occurs, and default pool size allocated to production components may become a bottleneck. To avoid such situations, I created a demonstrator project some 2 years ago to see, whether it would be possible and feasible to modify production, so it allowed for dynamically modifying its components per their load.

Hi,

I have some SQL querys i would like to run using an Outbound SQL Adapter  and save the returned rowsets in excel format (each rowset in a seperate excel file).

What is the best way to do this?

Thanks

Hi,

As part of our continuous efforts to expand and improve the InterSystems IRIS Data Platform, we’ve set up a brief survey around SQL monitoring. Your feedback will help us in designing and developing the right tools for the job and improve the platform’s overall ease-of-use. Please use the link below to access the survey, which should only take around 5 minutes to complete.

Hi Community!

We are pleased to invite you to the upcoming webcast in Portuguese on August 20 at 11:00 BRT:

✅ Digital Government: Architectures and Solutions

On this webcast, InterSystems Solutions Consultant @Yuri Marx will help us understand how the 3 powers at federal, state and municipal levels are seeking the digitalization of public services.

Hello,

I work on deploying IRIS inside Docker container. I really like %Installer class can automate many steps. I want to establish an ECP connection to a mirror database and then define a remote database on the application server. I have already seen we can create local database and namespace in %Installer. What code is needed to establish ECP connection?

Asymmetric cryptography is a cryptographic system that uses pairs of keys: public keys which may be disseminated widely, and private keys which are known only to the owner. The generation of such keys depends on cryptographic algorithms based on mathematical problems to produce one-way functions. Effective security only requires keeping the private key private; the public key can be openly distributed without compromising security.

In such a system, any person can encrypt a message using the receiver's public key, but that encrypted message can only be decrypted with the receiver's private key.

Robust authentication is also possible. A sender can combine a message with a private key to create a short digital signature on the message. Anyone with the sender's corresponding public key can combine the same message and the supposed digital signature associated with it to verify whether the signature was valid, i.e. made by the owner of the corresponding private key. (C) Wikipedia.

ML Toolkit for InterSystems IRIS, besides Python/R/Julia, allows orchestrating cloud-based advanced analytics services, such as Microsoft Azure Data Factory and Machine Learning:

This article, and following two articles of the series, is intended as a user guide for developers or system administrators, who need to work with OAuth 2.0 framework (further referred to as OAUTH for simplicity) in their InterSystems product based applications.

Those of you that worked already with ECP might know that it operates not only across
operating systems, processor technologies (big-little-endian), but also -with limits- across versions in C/E.
This cross-version feature also includes IRIS (verified for 2020.1)  and C/E (2018.3)

Hello All,

I have been using IRIS / Ensemble for over a decade and appreciate lot of it's functionalities and features, however besides having a UI of 80's era (which doesn't bother me), what I believe where IRIS is lacking is lack of out of the box connectors (services/operations).
If we look at IRIS's competitors for eg Mulesoft, Talend, Boomi they all have hundreds of pre-built connectors for major applications like Salesforce, SAP etc and cloud services like Azure, AWS etc to store and retrieve information and data.

Just to give an idea here is a link of Dell Boomi connectors

https://help.

Hi Developers,

The new video from Global Summit 2019 is available on InterSystems Developers YouTube:

⏯ REST at Ease

Messages between Business Hosts in Interoperability Production often contain object properties.

Do you define and pass them as object properties or do you define and pass them as Integers with objects conversion where required?

Why?

InterSystems IRIS database supports compression? If yes, wha is possible compress? (logs, temp tables, blob data, backup, etc)

Hi Community!

We are pleased to invite all the developers to the upcoming InterSystems IRIS for Health FHIR Contest Kick-Off Webinar! The topic of this webinar is dedicated to the FHIR Programming Contest.

On this webinar, we will talk and demo how to use the IRIS-FHIR-Template to build FHIR solutions using InterSystems IRIS for Health.

Date & Time: Tuesday, August 11 — 11:00 AM EDT

Speakers:  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager
🗣 @Guillaume Rongier, InterSystems Sales Engineer
🗣 @Patrick Jamieson, InterSystems Product Manager - Health Informatics Platform

What awaits you at this webinar?

Is it possible restrict access in IRIS from label data classification (ultra/top secret, restrict, ostensive, etc.)?

I want to integrate any video call service with IS? Can someone help on this ?

Hi!

As Atelier for Eclipse seems that will be discontinued, I decided to start moving my coding environment to Visual Studio Code. I kind of like it, and I'm getting used to it.

But I can't find the way to have several server connections as I do in Eclipse, and so creating projects based on that servers. Is there any way to do it?

Thanks a lot

The InterSystems IRIS offer many options to deploy digital services running in IRIS. Your option will depends if you use IaC (my preferred option) or no.

If you use IaC, the options are:

1) IKO - InterSystems Kubernetes Operator: this is InterSystems extension to Kubernetes container/docker management and orchestration tool that facilitate create IRIS clusters in the Kubernetes. See more info in: https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=AIKO.

Hey Developers,

Check out the latest video on searching for FHIR resources:

⏯ Searching for FHIR Resources in IRIS for Health

This video covers the most common types of queries used to search for FHIR resources in InterSystems IRIS for Health™, and shows how and when to use each type of query in your application.

⏯ Searching for FHIR Resources in HealthShare Unified Care Record

Did anyone run into this error when stopping a Production from Ens.Director?

Ens.Director::StopProduction => ERROR <Ens>ErrProductionNotQuiescent: IRIS can not become quiescent

It happens sporadically when an automated unit test from a class that extends %UnitTest.TestProduction runs a test on a Business Process. I already increased the parameter MAXWAIT to 30 seconds, but the error still happens.

Hi Community!

We're pleased to invite you to the upcoming "Speed Test: ESG Labs Database Performance Test" webinar on August 5 at 9:30 AM EDT!

Join our live webinar with Mike Leone, senior analyst with Enterprise Strategy Group’s Validation Services, to learn about a speed test that measures and compares the concurrent real-time data ingest and query performance of InterSystems IRIS^® data platform, a leading in-memory database, a cloud relational database, and a traditional relational database. 

Hi

I want to download the iris-facial-recognition application but the download link returns an HTTP 404 error.

Any ideas why?

Nigel

IRIS is an excellent option for machine learning projects with massive data operation scenarios, because the following reasons:

1. Supports the use of shards to scale the data repository, just like MongoDB.
2. Supports the creation of analytical cubes, this in association with sharding allows to have volume with performance.
3. Supports collecting data on a scheduled basis or in real time with a variety of data adapter options.
4. It allows to automate the entire deduplication process using logic in Python or ObjectScript.
5.

Hi Developers,

The new video from Global Summit 2019 is available on InterSystems Developers YouTube:

⏯ Introducing Analytic Workflows

This is the third post of a series explaining how to create an end-to-end Machine Learning system.

Training a Machine Learning Model

When you work with machine learning is common to hear this work: training. Do you what training mean in a ML Pipeline? Training could mean all the development process of a machine learning model OR the specific point in all development process that uses training data and results in a machine learning model.

Source

So Machine Learning Models are not equal Common Applications?

In the very last point it looks like a normal application.