Announcement
· Apr 10, 2023
What's Design Thinking All About?

person writing on white paper

Have you ever heard of Design Thinking? Or have you heard of it and thought, “I’m not a designer, when would I use Design Thinking?” While a dedicated designer is responsible for applying Design Thinking practices in an organization, everyone who creates products can benefit from a Design Thinking mindset. According to Forbes, Design thinking practices can “deliver an ROI of 85% or greater”. It can also reduce product development cycles by 33-50%.

4 0
0 236

​Keywords: ChatGPT, COS, Lookup Table, IRIS, AI

Purpose


Here is another quick note before we move on to GPT-4 assisted automation journey. Below are some "little" helps ChatGPT had already been offering, here and there, during daily works.

And what could be the perceived gaps, risks and traps to LLMs assisted automation, if you happen to explore this path too. I'd also love to hear anyone's use cases and experiences on this front too.

5 3
1 494
Article
· May 22, 2022 1m read
Debugging Trick with SQL

I'm sure you have met this situation:

  • There is a bug in a System that you can't reproduce yourself locally
  • You need to run a few lines in the affected instance
  • You get full access to System Management Portal
  • But there is just no terminal, nor console, nor access with Studio, Atelier or VSCode
  • How to run your few lines for testing ???

19 3
5 880
Article
· Mar 2, 2023 5m read
Tutorial - Working with %Query #1

The title of the contest subject is not quite precise but addresses the %Library.classes involved.
What is meant is officially named Class Query and is dating back to the early days of Caché.
CLASS is used because it is embedded in a COS class.
Though there is a precise description in the official documentation it remains rather abstract.
My tutorial should guide you step-by-step through a simple example in COS to make it tangible to you

8 4
1 501

As you know in Caché / IRIS you have the possibility to define a property as Multidimensional as documented here:
https://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_proplit#GOBJ_proplit_multidim
and the explanation of how to use it
https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GOBJ_proplit#GOBJ_proplit_multidim_values

Though the access is quite comfortable (in traditional COS sense) there are 2 main restrictions that hurt:

#1) It is not saved to disk unless your application includes code to save it specifically.
#2) It cannot be stored in or exposed through SQL tables
there are some more
I'll show how to overcome these limits

14 1
2 538
Question
· Mar 17, 2023
A confusing experience

During my last migration to IRIS I met this Compatibility parameter

  • NullSubscripts true
0 - Throw error when referencing a null subscript.
1 - Null subscript references do not throw an error.

The consequences are shocking. This was allowed:

2 5
0 289
Article
· Feb 28, 2023 2m read
Break the limits of your server

Hi developers!

You are experts in IRIS and know all tricks. The functionality of $ZF(-1,-2,-100, ......)
is nothing new to you And you know the limits of this functionality.
Both give you access to your local server command line environment. And that's it.

1 1
0 282
Announcement
· Mar 6, 2023
CCR View Page Opt-In Release

Hello CCR Users,

The new CCR view page is now available to all users via an opt-in toggle a at the top and bottom of the view page.

We hope all users will give the new UI a try and provide us with any feedback that you have through your normal support channels.

Thank you to the beta users who have been using this page for a while, making sure its full release goes smoothly! You can always update your beta user status here.

Thanks!

3 1
0 197
Article
· Mar 2, 2023 4m read
Tutorial - Streams in Pieces

This tutorial is a follow on to Working with %Query
It was displaying the content of the input stream chopped in fixed-size chunks.
But often those streams are structured and have well-defined separators (e.g HL7)
So as a side subject of this tutorial, this chapter shows how to break a stream into PIECES.

It is exactly the same idea as the $PIECE() function for strings with some add-ons.

12 1
1 311
Article
· Mar 2, 2023 5m read
Tutorial - Working with %Query #2

My previous article introduced you to SQL based Basic Class Query
where a clever wizard created all the required code for you and your essential
contribution was an SQL statement.

Now we enter the real Custom Class Query that provides more freedom but
requires a deeper understanding of the mechanic behind the scene.
The full code example is again on GitHub

8 1
0 251
Announcement
· Feb 14, 2023
Community Roundtable: AI / ML

Hi Community,

We are gathering again for the next Community Roundtable. Many of you asked for a roundtable about AL / ML, and we are delighted to bring such a roundtable to you!

Our invited expert from InterSystems: @Thomas Dyar Product Specialist - Machine Learning.

Join our 60-min discussion, prepare your questions, and use cases! There will be a short demo as well.

UPDATE: the recording is available here.

6 5
0 292

Hi Community,

Please read this when you have the time and keep an open mind. Also, you are welcome to tell me it is a terrible idea.

The main reason for this post

If you look at NPM, it has 1.3 million packages. Now ask yourself, is this an achievement or a nightmare?
How many of those packages are no longer supported?
How many of those packages break compatibility on version changes?
How do you know which one to use?

11 13
2 222
Article
· Jan 23, 2023 2m read
Global-Streams-to-SQL

In general Global Streams are data objects embedded in Classes / Tables.
Using and viewing them with SQL is normally a part of the access to the containing tables.

SO WHAT?

During debugging or searching for strange or unexpected behavior there could be the need to
get closer to the stored stream. No big problem with direct access to Globals with SMP or Terminal.
But with SQL you are lost.
So my tool provides dynamic access to Global Streams wherever you may need this
Special thanks to @Oliver Wilms for the inspiration for this tool.

6 1
1 373

Hi ,

I am trying to work out how to install the intersystems-jdbc-3.3.1.jar file onto a windows server to set up a connection between athrid party application and an Iris database.

Is there an installer ? the java -jar etc command does not work "could not load main class " . Added the folder to the system path .

Running Eclipse temurin but I do not work with java at all, other than these very specific points where need to get applications to run .

If someone could point me to a guide or instruction that would be of great assitance

Cheers

0 6
0 513
Article
· Jan 23, 2023 2m read
Global-Streams-to-SQL #2

Some technical background information

There is not just one class in this package: rcc.gstream.cls but also rcc.gstreamT.cls

While rcc.gstream works with direct access to the stream globals, the *T version uses
a Process Private Global (PPG) as Temporary storage.
using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar.

2 0
0 178
Announcement
· Dec 30, 2022
Happy New Year

Dear community!

It was an amazing 2022 with all of you. Great questions and articles around the whole year and this brings us the most valuable gifts -- wisdom and knowledge.
I want to thank you all for a great year full of fun and pleasure.

This community rocks.

7 6
0 182
Question
· May 24, 2022
Questions MSM-Workstation

Hello, my name is Roger, I work in a big hospital in Brazil, I'm new to the MUMPS area, I was given an assignment to try to stabilize our MSM/MUMPS system, we have licenses for 1200 connections, however, the MSM starts having problems when we reach about 990 connections, the terminal has a timeout, it gets stuck. Looking at the MSM settings parameters I noticed the following default settings, could this be related?

0 6
0 467

Overview

Predictable storage IO performance with low latency is vital to provide scalability and reliability for your applications. This set of benchmarks is to inform users of IRIS considering deploying applications in AWS about EBS gp3 volume performance.

Summary

  • An LVM stripe can increase IOPS and throughput beyond single EBS volume performance limits.
  • An LVM stripe lowers read latency.
4 1
0 1.9K