Skip to content
Effectuez une recherche pour en savoir plus sur les produits et solutions InterSystems, les offres d'emploi, etc.

ESG Technical Review: InterSystems IRIS

Enterprise Strategy Group

InterSystems IRIS: High Performance Data Management Software for Concurrent Data Ingestion and Real-time Queries

Date: June 2020
Author: Kerry Dolan, Senior IT Validation Analyst

Abstract

This report documents ESG’s validation of concurrent data ingestion and real-time query performance testing of various database management software products that demonstrates the ability of InterSystems IRIS data platform to ingest hundreds of millions of records and simultaneously execute millions of queries with microsecond performance, outperforming other traditional and in-memory products.

The Challenges

For many organizations, the ability to collect data and analyze it in real time is an essential task that drives revenue, improves visibility, informs strategy, and aids decision making. For example, applications focused on financial trading, IoT, fraud detection, and real-time personalization must ingest large amounts of data and analyze it immediately. The challenge is finding a database platform with sufficient horsepower to handle large-scale ingest and querying simultaneously without impeding performance. When ESG asked database and analytics professionals about technologies supporting data analytics, performance was among the topmost important capabilities.1

Enterprise Strategy Group chart showing top 10 most important capabilities for data analytics technologies

In-memory databases offer high performance but are expensive to scale and have hard memory limits that can affect reliability and cause restart delays. Traditional databases offer persistence and reliability but lack the high performance of in-memory databases. InterSystems IRIS can process both ingestion and query workloads simultaneously, with performance equal to or better than in-memory-only databases, without their limitations. InterSystems has published an open-source test to demonstrate this claim, which ESG is validating in this report.

The Solution: InterSystems IRIS

InterSystems IRIS is a data management software platform that was built for high performance, multi-workload processing at scale. As a multi-model DBMS, it provides native support for relational, object-oriented, document, key-value, and hierarchical data objects; in addition, it enables consistent high performance for both transactional and analytic workloads simultaneously. While a complete product description is beyond the scope of this report, some key functionality is described below.

  • An important feature that provides superior ingest performance is the multidimensional data engine in InterSystems IRIS that enables efficient, compact storage with a rich data structure, speeding data ingest, access, and updates while minimizing resource usage and disk consumption.
  • Real-time analytics performance is achieved by using a transactional-bitmap indexing schema that enables InterSystems IRIS to process complex queries quickly, including on real-time data, without searching the entire database.
  • InterSystems IRIS Enterprise Cache Protocol, an intelligent, distributed memory caching mechanism, enables it to execute sophisticated queries on very large data sets with high performance and reliability, including performing joins accessing distributed data, without making multiple data copies.

Other features include:

  • In-memory performance with built-in data persistence in a format optimized for rapid data access.
  • Built-in distributed caching layer with automatic and guaranteed consistency.
  • Full SQL support.
  • Deployment on-premises, in all major public clouds, and in hybrid environments, with a single API.

ESG Tested

ESG validated performance benefits of InterSystems IRIS using the company’s publicly available, customizable, open-source Speed Test benchmark kit.2 The benchmark was designed to measure concurrent real-time ingest and query performance. This is a common use case that financial services, fraud detection, IoT, and other applications face. For example, while financial services firms are executing thousands of trades, thousands of users are querying for order status, risk management, etc. Similarly, IoT sensor data comes in fast from the field and applications must perform immediate anomaly detection and other real-time calculations. When a database is stressed in this way, having to simultaneously ingest data and execute analytic queries can slow performance.

--continues--


1 - Source: ESG Master Survey Results, The State of Data Analytics, August 2019. 2 - https://github.com/intersystems-community/irisdemo-demo-htap.

 

Autres Ressources Que vous Pourriez Apprécier

02 Apr 2025
A Digital Front Door Solution
A Digital Front Door Solution Successful healthcare organizations (HCOs) understand that patient engagement is fundamental. Patients who are well-informed about their conditions and treatment options make better decisions. By empowering patients to take an active role in their healthcare, HCOs can improve patient outcomes, satisfaction, and loyalty.
25 Mar 2025
A cloud-based FHIR to OMOP solution for real-world data
Cloud-Based, On-Demand Access to Secure Patient Data Nationwide
19 Mar 2025
IDC Spotlight
L’évolution des outils de gestion de la supply chain et d’aide à la décision, combinée à des écosystèmes technologiques complexes, souligne l’importance d’intégrer, d’harmoniser et d’exploiter des données disparates. Une meilleure utilisation des données permet d’accélérer les transformations et de générer des bénéfices durables pour l’entreprise.
19 Mar 2025
InterSystems Supply Chain Orchestrator
Dans la chaîne d'approvisionnement, anticiper les perturbations avant qu'elles ne surviennent et les gérer de manière optimisée lorsqu'elles se produisent change radicalement la donne.
14 Mar 2025
InterSystems Data Fabric Studio - Chaîne d'approvisionnement
Data Fabric Studio facilite l'accès à des données précises, cohérentes et fiables plus rapidement, et permet de prendre des décisions mieux informées tout au long de la chaîne d'approvisionnement.
11 Mar 2025
InterSystems Data Fabric Studio - Supply Chain
Data Fabric Studio makes it easy to access accurate, consistent, and reliable data faster, and enables better-informed decision making across your entire supply chain.
07 Mar 2025
Rapport du cabinet d'analyste ARC
Une nouvelle catégorie de tissus de données de la chaîne d'approvisionnement est en train d'émerger pour répondre aux besoins uniques des grandes entreprises ayant des processus de chaîne d'approvisionnement complexes. Ces nouveaux tissus de données doivent aller au-delà des tissus de données d'entreprise traditionnels, qui ne sont pas optimisés pour les environnements de la chaîne d'approvisionnement. Ces nouvelles plateformes doivent être en mesure de prendre en compte les données complexes de la chaîne d'approvisionnement, les alertes en temps réel et les compromis complexes en matière d'aide à la décision. Une telle plateforme est nécessaire pour permettre aux entreprises de soutenir véritablement l'exécution agile des activités.
04 Mar 2025
Next-Generation AI-Powered Electronic Health Record System
InterSystems IntelliCare™ is an advanced, unified electronic health record (EHR) and healthcare information system with integral AI. It enables healthcare delivery organizations of any size to break down interoperability barriers, improve information flows, and boost clinical and business outcomes.
04 Mar 2025
Next-Generation, AI-Powered, Electronic Health Record System
Streamline workflows, transform user experiences, and boost productivity with InterSystems IntelliCare™ - a unified, intelligent healthcare information system connects care teams across the healthcare ecosystem, making it easy to share information across facilities and organisations, improving safety, compliance, and patient satisfaction. Much more than just an Electronic Health Record (EHR) system, the fully integrated, intelligent solution includes a comprehensive set of unified clinical, administrative, revenue cycle management, and departmental products with built-in AI functionality.
04 Mar 2025
Unify Operations, Increase Efficiencies, Improve Patient Experiences
Download the PDF

Passez à l'étape suivante

Nous serions ravis d'échanger avec vous. Remplissez les champs suivants et nous vous recontacterons.
*Champs obligatoires
*Champs obligatoires
*Champs obligatoires
*Champs obligatoires
** En cochant cette case, vous consentez à recevoir des actualités, des mises à jour et toute autre information à objectif marketing liés aux produits et événements actuels et futurs d'InterSystems. En outre, vous consentez à ce que vos coordonnées professionnelles soient saisies dans notre solution CRM hébergée aux États-Unis, mais conservées conformément aux lois applicables en matière de protection des données.