#InterSystems IRIS

Post a job Follow
19 Followers · 5.5K Posts

InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.

Post a job Follow
Article Robert Cemper · Oct 15, 2017 3m read

@Indirection and eXECUTE - why ?

As I mentioned in an early post the roots of COS were laid in the late 60ies of the 20th century.

Close to that time, BLISS was designed at Carnegie-Mellon University (January 15, 1970)
https://en.wikipedia.org/wiki/BLISS
Similarly in 1972 C language was written at Bell Labs.
https://www.bell-labs.com/usr/dmr/www/chist.html

Both were designed to overcome the portability limits of code written in assembly language.
While BLISS was running on DEC machines and vanished with Digital Equipment Corporation
C language and later C++ expanded on almost any processor technology until today.

#Caché #InterSystems IRIS
2
0 991
Article Kimberly Dunn · Sep 26, 2017 2m read

InterSystems IRIS Data Platform: the Power Behind a Better Online Shopping Experience

This summer the Database Platforms department here at InterSystems tried out a new approach to our internship program.  We hired 10 bright students from some of the top colleges in the US and gave them the autonomy to create their own projects which would show off some of the new features of the InterSystems IRIS Data Platform.  The team consisting of Ruchi Asthana, Nathaniel Brennan, and Zhe “Lily” Wang used this opportunity to develop a smart review analysis engine, which they named Lumière.   As they explain:

#InterSystems IRIS #InterSystems Natural Language Processing (NLP, iKnow) #Cloud
0
0 603
Article Rubens Silva · Aug 9, 2017 9m read

Frontier: An abstraction layer for rapid REST development - Part 1 - Core concepts

Hello.
The idea of this post is to introduce Frontier: An abstraction layer that allows Rapid REST development.

REQUIREMENTS:

Why?

Have you ever found yourself dealing with repetitive tasks like mounting objects, serializing them and eventually handling multiple errors for multiple cases? Frontier can boost your development by making you focus on what really matters: your application.
 

Frontier is made to stop you from WRITE'ing by instead forcing your methods to return values.
It's designed to make you code clean, and you'll see the why pretty soon.

This is the Part 1, where you'll learn he basics about how to work with Frontier. That means at the end of this part you should be capable of 

creating GET requests without difficulties. Since this also serves as a way to introduce the framework, I'll be calling this part: Core concepts.

#Caché #InterSystems IRIS #Object Data Model #REST API #Tutorial
Open Exchange
8
0 1788
Article Robert Cemper · Aug 23, 2017 2m read

Light weight EXCEL download

I worked through the Community for proposals to provide end users
in an easy way with data formatted as EXCEL sheet.

There is a great article Tips & Tricks - SQL to Excel

there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual"

Where's the light weight export to EXCEL ?
Good old CSP is well equipped to produce HTML tables accepted from EXCEL as input.
With modern Browsers you don't even need <head>and  <body> tags.
So the required code around your SQL result set is really slim.
And you are free to add any formatting you need either by HTML or in SQL.

#Caché #InterSystems IRIS #CSP #ObjectScript #SQL
Open Exchange
1
1 1727
Article Murray Oldfield · Apr 8, 2016 17m read

InterSystems Data Platforms and Performance Part 4 - Looking at Memory

This post will guide you through the process of sizing shared memory requirements for database applications running on InterSystems data platforms. It will cover key aspects such as global and routine buffers, gmheap, and locksize, providing you with a comprehensive understanding. Additionally, it will offer performance tips for configuring servers and virtualizing IRIS applications. Please note that when I refer to IRIS, I include all the data platforms (Ensemble, HealthShare, iKnow, Caché, and IRIS).

#Caché #InterSystems IRIS #InterSystems IRIS for Health #Best Practices #InterSystems Business Solutions and Architectures #Performance #System Administration
3
9 11218
Article Murray Oldfield · Nov 25, 2016 23m read

InterSystems Data Platforms and performance – Part 8 Hyper-Converged Infrastructure Capacity and Performance Planning

Hyper-Converged Infrastructure (HCI) solutions have been gaining traction for the last few years with the number of deployments now increasing rapidly. IT decision makers are considering HCI when scoping new deployments or hardware refreshes especially for applications already virtualised on VMware. Reasons for choosing HCI include; dealing with a single vendor, validated interoperability between all hardware and software components, high performance especially IO, simple scalability by addition of hosts, simplified deployment and simplified management.

#Caché #InterSystems IRIS #Best Practices #InterSystems Business Solutions and Architectures #InterSystems Data Platform Blog #Performance #System Administration
7
1 3818
Article Sergey Kamenev · May 30, 2017 6m read

Globals Are Magic Swords For Managing Data. Part 1

Globals, these magic swords for storing data, have been around for a while, but not many people can use them efficiently or know about this super-weapon altogether.

If you use globals for tasks where they truly shine, the results may be amazing, either in terms of increased performance or dramatic simplification of the overall solution (1, 2).

Globals offer a special way of storing and processing data, which is completely different from SQL tables. They were first introduced in 1966 in the M(UMPS) programming language, which was initially used in medical databases. It is still used in the same way, but has also been adopted by some other industries where reliability and high performance are top priorities: finance, trading, etc.

Later M(UMPS) evolved into Caché ObjectScript (COS). COS was developed by InterSystems as a superset of M. The original language is still accepted by developers' community and alive in a few implementations. There are several signs of activity around the web: MUMPS Google group, Mumps User's group), effective ISO Standard, etc.

Modern global based DBMS supports transactions, journaling, replication, partitioning. It means that they can be used for building modern, reliable and fast distributed systems.

Globals do not restrict you to the boundaries of the relational model. They give you the freedom of creating data structures optimized for particular tasks. For many applications reasonable use of globals can be a real silver bullet offering speeds that developers of conventional relational applications can only dream of.

Globals as a method of storing data can be used in many modern programming languages, both high- and low-level. Therefore, this article will focus specifically on globals and not the language they once came from.

#Caché #InterSystems IRIS #Beginner #Globals #Node.js #Performance #Relational Tables
10
0 2641
Article Daniel Kutac · May 3, 2017 18m read

InterSystems IRIS Open Authorization Framework (OAuth 2.0) implementation - part 3

Created by Daniel Kutac, Sales Engineer, InterSystems

Part 3. Appendix

InterSystems IRIS OAUTH classes explained

In the previous part of our series we have learned about configuring InterSystems IRIS to act as an OAUTH client as well as authorization and authentication server (by means of OpenID Connect). In this final part of our series we are going to describe classes implementing InterSystems IRIS OAuth 2.0 framework. We will also discuss use cases for selected methods of API classes.

The API classes implementing OAuth 2.0 can be separated into three different groups according to their purpose. All classes are implemented in %SYS namespace. Some of them are public (via % package), some not and should not be called by developers directly.

#Caché #Ensemble #InterSystems IRIS #Authentication #Access control #OAuth2 #Security
0
3 3594
Article Murray Oldfield · Oct 1, 2016 10m read

Data Platforms and Performance - Part 7 ECP for performance, scalability and availability

One of the great availability and scaling features of Caché is Enterprise Cache Protocol (ECP). With consideration during application development distributed processing using ECP allows a scale out architecture for Caché applications. Application processing can scale to very high rates from a single application server to the processing power of up to 255 application servers with no application changes.

#Caché #InterSystems IRIS #InterSystems IRIS for Health #Best Practices #ECP #InterSystems Business Solutions and Architectures #Performance #System Administration
6
2 3572
Article Murray Oldfield · Nov 12, 2016 6m read

InterSystems Data Platforms Capacity Planning and Performance Series Index

Index

This is a list of all the posts in the Data Platforms’ capacity planning and performance series in order. Also a general list of my other posts. I will update as new posts in the series are added.

You will notice that I wrote some posts before IRIS was released and refer to Caché. I will revisit the posts over time, but in the meantime, Generally, the advice for configuration is the same for Caché and IRIS. Some command names may have changed; the most obvious example is that anywhere you see the ^pButtons command, you can replace it with ^SystemPerformance.

While some posts are updated to preserve links, others will be marked as strikethrough to indicate that the post is legacy. Generally, I will say, "See: some other post" if it is appropriate.

Capacity Planning and Performance Series

Generally, posts build on previous ones, but you can also just dive into subjects that look interesting.

#Caché #InterSystems IRIS #InterSystems IRIS for Health #Best Practices #InterSystems Business Solutions and Architectures #Performance #System Administration #Tips & Tricks
0
7 6596
Article Cindy Olsen · Nov 8, 2016 7m read

SYSLOG - what it really is and what it means

In this post I would like to talk about the syslog table.  I will cover what it is, how you look at it, what the entries really are, and why it may be important to you.  The syslog table can contain important diagnostic information.  If your system is having any problems, it is important to understand how to look at this table and what information is contained there.

#InterSystems Data Platform Blog #Best Practices #Caché #Terminal #InterSystems IRIS #Monitoring #Tips & Tricks #InterSystems Data Platform Blog
1
2 2905
Article Peter Steiwer · Nov 7, 2016 2m read

Accessing a new DeepSee Namespace for the first time

Whether you are accessing DeepSee for the first time ever or you are configuring DeepSee on a new instance, there are two common issues that are encountered after clicking on the “DeepSee” option in the System Management Portal.

Issue #1: Architect/Analyzer is grayed out!

Issue #2: DeepSee must be enabled before use.

Issue #1: Architect/Analyzer is grayed out!

There are two common causes for this problem.

Cause 1 - License

Cause 2 - Security

#Caché #InterSystems IRIS #InterSystems IRIS BI (DeepSee) #Analytics
1
0 1659
Article Murray Oldfield · Apr 1, 2016 3m read

Extracting pButtons data to a csv file for easy charting

A short post for now to answer a question that came up. In post two of this series I included graphs of performance data extracted from pButtons. I was asked off-line if there is a quicker way than cut/paste to extract metrics for mgstat etc from a pButtons .html file for easy charting in Excel.

See: - Part 2 - Looking at the metrics we collected

#InterSystems IRIS #Best Practices #CSV #InterSystems Data Platform Blog #Performance #System Administration
2
0 1620
Article Murray Oldfield · Sep 30, 2016 1m read

ECP Magic

I saw someone recently refer to ECP as magic. It certainly seems so, and there is a lot of very clever engineering to make it work. But the following sequence of diagrams is a simple view of how data is retrieved and used across a distributed architecture.

For more more on ECP including capacity planning follow this link: Data Platforms and Performance - Part 7 ECP for performance, scalability and availability

To start

#InterSystems IRIS #Best Practices #ECP #InterSystems Business Solutions and Architectures #Performance
0
0 1337
Article Mark Bolinsky · Jul 1, 2016 17m read

InterSystems Example Reference Architecture for Microsoft Azure Resource Manager (ARM)

++Update: August 2, 2018

This article provides a reference architecture as a sample for providing robust performing and highly available applications based on InterSystems Technologies that are applicable to Caché, Ensemble, HealthShare, TrakCare, and associated embedded technologies such as DeepSee, iKnow, Zen and Zen Mojo.

Azure has two different deployment models for creating and working with resources: Azure Classic and Azure Resource Manager. The information detailed in this article is based on the Azure Resource Manager model (ARM).

#Caché #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #Azure #Best Practices #Cloud #High Availability #InterSystems Business Solutions and Architectures #InterSystems Data Platform Blog #Mirroring
4
0 12622
Article Murray Oldfield · May 26, 2016 1m read

Caché and virus scanners

Post updated in August 2025 to include links to IRIS.

I have seen customer problems where the use of a virus scanner running over Caché or IRIS databases was causing intermittent application slowdowns and bad user response times.

This is a surprisingly common problem, so this short post is just a reminder to exclude key Caché and IRIS components from your virus scanning.

#Caché #InterSystems IRIS #System Administration
2
1 1888
Article Evgeny Shvarov · Apr 16, 2016 1m read

Try catch block I usually use in InterSystems ObjectScript

Hi!

Want to share with you code snippet of try catch block I usually use in methods which should return %Status. 


{ 
 try {
  	$$$TOE(sc,StatusMethod())
 }
 catch e {
 	set sc=e.AsStatus()
 	do e.Log()
 }

Quit sc 
}

Here $$$TOE is a short form of $$$TROWONERROR macro.

Inside macro StatusMethod is any method you call which will return %Status value. This value will be placed into sc variable.

In case of sc contains error execution will be routed to try catch block. You can wrap any Status methods calls in your code if you need to catch the errors coming from them.

#Caché #InterSystems IRIS #Code Snippet #ObjectScript
21
2 3565