#IntegratedML

1 Follower · 88 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.

Question Kurro Lopez · Jul 7, 2024

Hi all,

Some days ago, I've seen a youtuber talking about how to create a neural network (sorry, is in spanish)

In short, it uses the neural network to learn how to convert degrees Celsius to degrees Fahrenheit.
Degrees Fahrenheit = (degrees Celsius × 9/5) +32
In this video, he uses Python to create the neural network, where he creates a table with the values ​​of degrees Celsius and degrees Fahrenheit.

4
0 237
Question Fabio Care · Feb 13, 2024

This may be a very specific problem but might help with some general information that I wasn't able to find anywhere.

I have started to train 2 IntegratedML models using AutoML one month ago.

My first attempt was very optimistic with a class that has  26 Properties and 100.000 datasets. I wasn't expecting good results, just wanted to test it. 
(CREATE MODEL ECLASSPREDICT3 PREDICTING (eClass) FROM CRMSHOPARTIKELML)
My second attempt was more specific using the same class structure but reducing the dataset to 10.000 entries and only using certain properties.

2
0 212
Question Fabio Care · Dec 5, 2023

When trying to create a ML Model I ran into the problem, that AutoML apparantly isn't available on my IRIS instance.

I was able to use the following command successfully: CREATE MODEL ECLASSPREDICT PREDICTING (eClass) FROM SQLUSER.CRMSHOPARTIKEL

Then when trying to use TRAIN MODEL ECLASSPREDICT, I get the error from the image:

 

Roughly translates to : "-186: Modelprovider not available on this instance. #2822 %ML provider 'AutoML' is not available on this instance"

In my ML Configurations there are 3 standard configurations called %AutoML, %H20 and %PMML which I haven't changed.

10
0 456
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.

4
0 485