#IntegratedML

0 Followers · 84 Posts

InterSystems IntegratedML is an all-SQL machine learning (ML) module for InterSystems IRIS or IRIS for Health that:
- Gives users the ability to create, train and deploy powerful models from simple SQL syntax without requiring data scientists.
- Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot.
- Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications.

Please find more information including videos and infographics at the IntegratedML Resource Guide.

Article Oleh Dontsov · Apr 18, 2023 2m read

The Customer Churn Predictor application is a tool that demonstrates how to use IntegratedML to helps companies identify which customers are likely to leave in the near future and develop customer retention strategies. Benefits of the similar application include:

  • increase the effectiveness of marketing campaigns
  • improve the quality of customer service
  • reduce losses associated with customer churn
  • increase profit
  • improve customer loyalty
0
0 182
Announcement Derek Robinson · Dec 13, 2022

In our latest episode of Data Points, I had a conversation with @Thomas Dyar about AI Link, which helps bridge the gap between data scientists and business analysts. Our conversation talks about how AI Link fits with IntegratedML and Adaptive Analytics, as well, as what new features are on the horizon for IntegratedML. Take a listen!

0
0 183
Article Jimmy Xu · Nov 28, 2022 1m read

Hi Developers,

IntegratedML is a feature helps us and our teams easily implement machine learning (ML) without dedicated ML experts and data scientists. If you do not need particularly complex ML function, integratedML is a good choice and convenient that only requires executing 3 SQL queries to build predictive models directly from InterSystems IRIS to ML engine.

I have recorded a video that walk through the basic of IntegratedML and implement an application from open exchange called diseases predictor by @Yuri Marx 

Check this out: Link to my video

Please feel free to leave any comments

2
1 378
Question Don Martin · Jan 31, 2022

I've been playing with IntegratedML and have created a model and trained the model.  When I try to use PREDICT or PROBABILITY statements in an SQL query, I get the following error:

[SQLCODE: <-400>:<Fatal error occurred>]

  [%msg: <PREDICT execution error: ERROR #5002: ObjectScript error: <OBJECT DISPATCH>%LoadModel+31^%ML.AutoML.TrainedModel.1 *<class 'AttributeError'>: 'str' object has no attribute 'decode' - >]

Here's an example of the sequence of steps I've followed that lead to the error:

CREATE MODEL MyModel PREDICTING (IsError BOOLEAN) FROM Example3.ModelTable

4
0 438
Article Evgeniy Potapov · Jun 3, 2022 3m read

It is very interesting to compare different BI technologies. It is curious to me what the differences are in functionality, development tools, speed and usability.

For this application, I chose a dataset with water conditions in various European countries. This is an open source dataset containing observational data from 1991 to 2017.

The team and I decided to make a model based on this BI dataset using IRIS BI, Tableau, PowerBI and InterSystems Reports (powered by Logi Reports).

For the frontend, we made a web interface in PythonFlask via Embedded Python.

0
0 282
Article Yuri Marx · Jun 1, 2022 6m read

Maternal Risk can be measured from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Yasir Hussein Shakir published a very useful dataset for training ML algorithms in the detection/prediction of Maternal Risk. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/code/yasserhessein/classification-maternal-healt….

About the Dataset

0
1 285
Article Yuri Marx · May 31, 2022 9m read

Kidney Disease can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Akshay Singh published a very useful dataset for training ML algorithms in the detection/prediction of kidney disease. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/akshayksingh/kidney-disease-dataset.

About the Dataset

0
0 397
Article Yuri Marx · May 30, 2022 7m read

Diabetes can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the National Institute of Diabetes and Digestive and Kidney Diseases published a very useful dataset for training ML algorithms in the detection/prediction of diabetes. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/mathchi/diabetes-data-set.

1
1 412
Article Yuri Marx · Dec 19, 2021 5m read

The InterSystems IRIS IntegratedML feature is used to get predictions and probabilities using the AutoML technique. The AutoML is a Machine Learning technology used to select the better Machine Learning algorithm/model to predict status, numbers and general results based in the past data (data used to train the AutoML model). You don't need a Data Scientist, because the AutoML it will test the most common Machine Learning algorithms and select the better algorithm to you, based in the data features analysed. See more here, in this article.

3
1 826
Article Yuri Marx · Jan 13, 2022 2m read

Hi community,

Prediction is a critical to the Maternal healthcare. The Health Dataset Application (https://openexchange.intersystems.com/package/Health-Dataset) has 10 real health datasets to predict the most important diseases and health problems, including Maternal Risk.

This article detail the steps to predict Maternal Risk using the InterSystems IRIS IntegratedML. This is a technology of InterSystems to do predictions using SQL Commnands! Great!

Follow these steps:

  1. Clone/git pull the repo into any local directory
$ git clone https://github.com/yurimarx/predict-maternal-risk.git
0
1 328
Article José Pereira · Dec 21, 2021 8m read

Have you tried the InterSystems learning platform lab for IRIS IntegratedML? In that lab you can train and test a model on a readmission dataset and be able to predict when a patient will be readmitted or not, or calculate its probability of being readmitted.

You can try it without any installation on your system, all you have to do is start a virtual lab environment (Zeppelin) and play it around!

2
2 626
Article Yuri Marx · Jul 18, 2020 1m read

Now Sapphire enable you load CSV to IRIS. See the steps:

1) Create a sample CSV file using Excel (save file as CSV):

2) Follow these instructions to install Sapphire into your enviroment: https://openexchange.intersystems.com/package/SAPPHIRE

3) Access Sapphire web page. Go to top menu Import > Load CSV

4) Configure access to your IRIS target instance, select new table, set your new table name, click Choose button and load your csv file and click upload. Click Get Definitions.

1
2 586
Article Zhong Li · Aug 22, 2020 24m read

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

Purpose

Recently I noticed a Kaggle dataset  for the prediction of whether a Covid-19 patient will be admitted to ICU.  It is a spreadsheet of 1925 encounter records of 231 columns of vital signs and observations, with the last column of "ICU" being 1 for Yes or 0 for No. The task is to predict whether a patient will be admitted to ICU based on known data.

1
1 945
Article Zhong Li · Aug 23, 2020 15m read

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

0
0 588
Announcement Anastasia Dyubaylo · Jul 20, 2020

Hi Community!

We're pleased to invite you to the Online Meetup with the Winners of the InterSystems IRIS AI Programming Contest!

Date & Time: Friday, July 24, 2020 – 11:00 EDT

What awaits you at this virtual Meetup? 

  • Our winners' bios.
  • Short demos on their applications.
  • A short interview with all the winners about the past contest. Plans for the next contests.

 

2
0 467