Columnar storage is one of the newer offers provided by InterSystems IRIS. Unlike traditional row-based storage, it optimizes query processing by storing data in columns rather than rows, enabling faster access and retrieval of relevant information.

A couple of articles have been written on when it should be used to give a system the biggest boost, how to create tables like that using SQL

CREATE TABLE table (column1 type1, column2 type2, column3 type3) WITH STORAGETYPE = COLUMNAR  -- ex 1
CREATE TABLE table (column1 type1, column2 type2, column3 type3 WITH STORAGETYPE = COLUMNAR)  -- ex 2

and even the performance tests.

As we all know, InterSystems IRIS is a multi-model DBMS and it gives seamless access to the same data using relational and object access. So the former is covered in other articles, but what about the latter?

Hi all!

Hi Community,

Watch this video to see how HL7® FHIR® Implementation Guides allow you to restrict or extend APIs, resources, and terminologies:

⏯ What are HL7 FHIR Implementation Guides

https://www.youtube.com/embed/E9oRde9fHGE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi. I am struggling to understand the meaning of different elements of an order in my hospital's EHR.

Page: EPR > All Orders

Question: What is the difference between Start Date and Date Executed and Order End Date? If an order was started on Monday and executeed on Tuesday.. does this mean the patient received the order on Monday or Tuesday? and what is End date?

Also, how do I interpret order status? What is the difference between discontinued, verified, and executed?

Hi there,

I am interested to execute ObjectScript commands from external language. I saw that IRIS provides the irisnative library for this.

I am using Windows and 8-bit IRIS server (due to compatibility with old software I need to use 8-bit instead of Unicode).

It's the QUIZ time today!
Here you can test your knowledge and try to solve the quiz.

Choose the right answer below.
Author: @Robert Barbiaux

The poll is active for one week, after which we reveal the correct answer along with a link to the documentation.

Beginning with the release of InterSystems IRIS® data platform 2022.3, InterSystems corrected the license enforcement mechanism to include REST and SOAP requests. Due to this change, environments with non-core-based licenses that use REST or SOAP may experience greater license utilization after upgrading.

In the summer of 1993 for the first time was held InterSystems Global Summit. Many warm memories are associated with this event!

We hope you had the opportunity to visit one or more of Global Summits!

Let's share photos of the best moments you had at any InterSystems Global Summit in the comments below.

It's Friday and a long weekend is upon us, so let's have a round of code golf!

Nowadays, it's rare to find a text message without at least one emoji. 😃😄😎🙂😊😀😁😆😂
But back in the day, people had to be creative to express their emotions in text. They would use emoticons, which are symbols made up of keyboard characters :^) =] ) B).
Our challenge for today is to create a function that receives a string as argument and returns the total number of smiling faces or happy faces.
Each smiley face must have one smiling mouth, which should be marked with ), ], }, D or >.
A smiley face can have a pair of eyes but it does not have to. Valid characters for eyes are :, ;, 8, B or =.
A nose is optional, and can be represented these characters: -, ^, c, o and ~.

Valid smiley face examples:

    :) :D ;-D :~) :‑) :-] =)    
    :] :-> :> 8-) :D 8‑D )
    8) :-} :} :o) :c) :^) =]
    :‑D 8D =D B^D

Input

"count how many smiley faces are here :)"

​

Output

1

Hi,

In my Iris Installation I cannot use python. When I try to install external libraries I get no OPENSSL_Applink:

$ pwd
/cygdrive/c/InterSystems/IRIS2/bin
$ ./irispip install --target ../Mgr/python/ pandas
OPENSSL_Uplink(00007FFBEC2F7068,08): no OPENSSL_Applink

I get the same error when I try to install a wheel file:

George James Software is excited to announce that a new version of Deltanji source control is now available.

Hey Community,

Play the new video on InterSystems Developers YouTube:

⏯ Building a FHIR Facade @ Global Summit 2023

https://www.youtube.com/embed/RWyfFWRThxU
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hi everybody,

I need to connect a Caché database to Metabase, but Metabase does not support this database.
Metabase only supports these databases:

- Amazon Athena
- BigQuery (Google Cloud Platform)
- Druid
- MongoDB (recommend version 4.2 or higher)
- MySQL (recommend version 8.0.33 or higher, as well as MariaDB version 10.4 or higher)
- Oracle
- PostgreSQL
- Presto
- Redshift (Amazon Web Services)
- Snowflake
- SparkSQL
- SQL Server
- SQLite
- Vertica

Hi folks,

I am working on a customer project which uses some slightly altered FHIR resources in comparison to default R4 patient resource. I am able to import the structuedefinition as a custom FHIR package and assign it to the ISC FHIR server and the endpoint the IRIS instance provides.