查找

请注意，此帖子已过时。
问题
· 十二月 14, 2022

Does InterSystems has CDS Hook implementations?

#HL7 #InterSystems IRIS for Health

Does InterSystems has CDS Hook implementations?
if yes, where I could get the details.

7 Comments
讨论 (7)3
登录或注册以继续
文章
· 十二月 3, 2022 阅读大约需 2 分钟
Open Exchange

Guide how to run and use IRIS for Health docker image in GCloud

#Docker #InterSystems IRIS for Health

Hi, I would like to tell you how easy it is to spin up IRIS for Health docker container in compute engine(VPS) in google cloud.

I know that to run IRIS for Health in AWS is pretty simple and straightforward, but I wanted to tried if its same easy in GCP environment.

Create vm instance. 2GB RAM is more than enough.

I used Debian 11 as Linux distro.

Standart persistent disk is cheaper.

Don’t forget to allow http, https traffic

 

Last thing for setting up virtual machine is allow external ports in firewall rules.

I allow here only 52773 which is for web user interface.  My Kotlin app will run on same vm and use 1972 internally,  so I didn’t allow it too.

Let’s Install docker-compose then run IRIS:

sudo apt install docker-compose

sudo docker run --name iris -d --publish 1972:1972 --publish 52773:52773 containers.intersystems.com/intersystems/iris-community:2022.1.0.209.0 --check-caps false

I found that command in InterSystems documentation pages here: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=ACLOUD

I only added 2 things:

1.  “-d” after name of container “iris” which means run in detached mode. So container will still run on background after you close SSH shell.

2.  “- -check-caps false” at the end.  I immediately found it in this article which was very helpful. https://community.intersystems.com/post/using-intersystems-iris-containers-docker-201014

sudo docker ps

Container is up and running just with 1 command:

Now check UI in browser:

This link I found at Intersystems documentation pages: https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSA_USING_PORTAL
http://35.222.2.215:52773/csp/sys/UtilHome.csp

35.222.2.215 is external ip of my Virtual machine.

52773 port we exposed with docker run command.

Default Login: SuperUser

Password: SYS

 

Now you have to change default password:

Congratulations, you are logged in:

 

ATTENTION: don't forget to delete VM instance, so you lose money on hosting.

Conclusion:

In this article I only covered how to run IRIS for Health community edition docker container in google cloud linux environment. Other part of my Kotlin/Intersystems journey will be in description of our project Dia Bro App. Please check it up and vote if you like the idea.

讨论 (0)1
登录或注册以继续
文章
· 十一月 28, 2022 阅读大约需 2 分钟

IRIS SQLでは LIMIT/OFFSET句のような機能をサポートしていますか？

#SQL #提示和技巧 #InterSystems IRIS #InterSystems IRIS for Health

Question:

IRISでは、PostgreSQLやMySQLで使うことができる、開始位置や取得件数を指定する LIMIT句やOFFSET句をサポートしているでしょうか？


Answer:

※2025/4/17更新：IRIS2025.1 以降のバージョンでは、LIMIT/OFFSET句をサポートするようになりました。ご参考

残念ながらサポートしていません。
ただ、代わりに使える同様の方法がありますのでご紹介します。

以下のようなSQLクエリをIRIS SQLで行うとします。

SELECT *
  FROM Sample.Person
ORDER BY Name
 LIMIT 3 OFFSET 5


---------------------------------------------------------------------------------
1. サブクエリとビュー ID (%VID)を使用する方法
---------------------------------------------------------------------------------

IRISでは、ビューまたは FROM 節のサブクエリで返される各行に整数のビュー ID (%VID) を割り当てることができます。
%VIDを使用すると、以下のサンプルのようにして同様のことが実現できます。
※%vidについて

SELECT *, %vid FROM (SELECT top all ID, Name
                     FROM Sample.Person
                     ORDER BY Name) v
WHERE %vid BETWEEN 6 AND 8
// 6番目から3つ分 --> 8番目まで


---------------------------------------------------------------------------------
2. OFFSET目までのデータを除いて TOP する方法
---------------------------------------------------------------------------------

SELECT TOP 3 ID, Name FROM Sample.Person WHERE ID NOT IN (SELECT TOP 5 ID
                 FROM Sample.Person
                 ORDER BY Name)
ORDER BY Name

 

---------------------------------------------------------------------------------
3.row_number() 関数を使用する方法
---------------------------------------------------------------------------------

IRIS 2021.1以降でサポートされるようになった ウィンドウ関数の ROW_NUMBER() を使用して実現することも可能です。

SELECT * FROM (
  SELECT row_number() OVER (ORDER BY Name) AS rn, ID, Name
  FROM Sample.Person 
) AS e 
WHERE e.rn BETWEEN 6 AND 8 ORDER BY Name


是非お試しください。

讨论 (0)0
登录或注册以继续
问题
· 十一月 23, 2022

What is the likelihood of encountering "missing messages" in message bank?

#容器化 #企业消息库 #InterSystems IRIS #InterSystems Kubernetes Operator (IKO)

My team works on implementing an Interoperability solution utilizing InterSystems Kubernetes Operator on Red Hat OpenShift container platform. 

We are trying to determine how many messages we can process in any given time. We have a Feeder app running in 10 containers sending 50k messages each to a load balancer all beginning at the same time.

Messages are received via HTTPS protocol by webgateway containers. 

Interoperability production runs in compute pods with persistent data, journals, and WIJ volumes.

We implemented Horizontal Pod Autoscaler to scale compute pods when CPU utilization is high.

We utilize Enterprise Message Bank to have one place to find any message processed by any compute.

We observe the queue for Message Bank operation grows quite large in compute pods.

Sometimes the Autoscaler scales computes down while they are still processing.

How likely is it Messages do not show up in Message Bank if they have been partially or completed processed in compute pods?

Any messages in queues on compute pods which are shutdown will not be processed until the compute pods is started again.

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

Jupyter and IRIS - The Simple Version

#Docker #InterSystems IRIS

There are several great articles in the community showing how to use Jupyter and InterSystems IRIS together, and I encourage you to check them out in the link at the end of this article for more in depth understanding.

This is just another one, the difference is on the simplicity. Do you want to just start a container where Jupyter is already connected to an IRIS instance? Then this is for you!

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