Skip to content
Telusuri untuk mempelajari tentang produk dan solusi InterSystems, peluang karier, dan banyak lagi.

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.

 

RELATED TOPICS

Sumber Daya Terkait

21 November, 2024
Make Your HIE Vision a Reality
Specifying Requirements, Evaluating Technologies, and Selecting Partners Download the Planning Guide
09 November, 2024
Forrester Research
InterSystems Positioned as a Leader in The Forrester Wave™: Translytical Data Platforms, Q4 2024, recognizing and evaluating comprehensive real-time transactional-analytical (“translytical”) capabilities
02 February, 2024
True Interoperability with the 3Cs
InterSystems supports child welfare agencies in their modernization efforts with true interoperability with the 3Cs – Connectivity, Compatibility, and Context.
06 October, 2023
Analytics
InterSystems proven technology is used today to replicate data from an operational production system to a “reporting node,” where it can be queried and analyzed without impacting the operational system.
05 June, 2023
Improved Citizen Support with Supply Chain Visibility and AI/ML-Driven Augmented Decision Support
Government agencies are engaged with supply chains from multiple perspectives, including:
26 March, 2021
An enterprise data fabric is a new architectural approach that speeds and simplifies access to data assets across the entire business. It accesses, transforms, and harmonizes data from multiple sources, on demand, to make it usable and actionable for a wide variety of business applications.
11 February, 2021
API Platform
State and local governments today strive to transform their operations to break down silos, improve interagency collaboration and communication, and delight their citizens with access to streamlined and automated services. Unfortunately, transforming government operations can be like trying to turn an aircraft carrier— a slow, laborious process. When it comes to technology, public agencies and institutions are often committed to information systems that have been running for decades. Such legacy systems present daunting challenges to the goals of automation and digital transformation.
17 September, 2020
Public Safety
Data Management Challenges in Public Safety Today more than ever before, public safety organizations worldwide are challenged to deliver top levels of service with shrinking resources. The effective use of information technology can help law enforcement, criminal justice, emergency response, and other public safety organizations meet their goals efficiently. Yet many organizations still struggle to reach their most mission-critical technology goals, including:
31 August, 2020
e-Government Digital Transformation
Today’s state and local governments are striving to digitally transform their processes and systems to break down silos, improve interagency collaboration and communication, and delight their citizens with access to streamlined and automated services. But public agencies and institutions have been running their own siloed legacy information systems for decades, making it difficult to automate and streamline processes. Citizens often need to visit multiple systems or government agencies to get all the required documentation for an application or fulfill a request.
10 April, 2020
IntegratedML
Win the Artificial Intelligence Talent War With an Easy-to-Develop, Easy-to-Deploy Machine Learning Solution

Ambil Langkah Selanjutnya

Kami ingin sekali berbicara. Isi beberapa detail dan kami akan menghubungi Anda.
*Bidang yang dibutuhkan
Highlighted fields are required
*Bidang yang dibutuhkan
Highlighted fields are required

Dengan mengirimkan informasi kontak bisnis Anda kepada InterSystems melalui formulir ini, Anda mengakui dan menyetujui bahwa InterSystems dapat memproses informasi ini, untuk tujuan memenuhi pengajuan Anda, melalui sistem yang dihosting di Amerika Serikat, tetapi tetap konsisten dengan undang-undang perlindungan data yang berlaku.



** Dengan memilih ya, Anda memberikan persetujuan untuk dihubungi untuk mendapatkan berita, pembaruan, dan tujuan pemasaran lainnya yang berkaitan dengan produk dan acara InterSystems yang sudah ada dan yang akan datang. Selain itu, Anda menyetujui informasi kontak bisnis Anda dimasukkan ke dalam solusi CRM kami yang dikelola di Amerika Serikat, tetapi tetap konsisten dengan undang-undang perlindungan data yang berlaku.