DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Cachelot.io vs. HEAVY.AI vs. Informix vs. Ingres vs. InterSystems IRIS

System Properties Comparison Cachelot.io vs. HEAVY.AI vs. Informix vs. Ingres vs. InterSystems IRIS

Editorial information provided by DB-Engines
NameCachelot.io  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonInformix  Xexclude from comparisonIngres  Xexclude from comparisonInterSystems IRIS  Xexclude from comparison
DescriptionIn-memory caching systemA high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareA secure embeddable database from IBM, positioned besides IBM Db2 as a relatively low-cost product optimized for OLTP and Internet of Things dataWell established RDBMSA containerised multi-model DBMS, interoperability and analytics data platform with wide capabilities for vertical and horizontal scalability
Primary database modelKey-value storeRelational DBMSRelational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMSDocument store
Key-value store
Object oriented DBMS
Relational DBMS
Secondary database modelsSpatial DBMSDocument store
Spatial DBMS
Time Series DBMS infowith Informix TimeSeries Extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.00
Rank#357  Overall
#56  Key-value stores
Score1.48
Rank#146  Overall
#70  Relational DBMS
Score24.16
Rank#34  Overall
#20  Relational DBMS
Score6.19
Rank#70  Overall
#38  Relational DBMS
Score2.45
Rank#118  Overall
#23  Document stores
#22  Key-value stores
#2  Object oriented DBMS
#59  Relational DBMS
Websitecachelot.iogithub.com/­heavyai/­heavydb
www.heavy.ai
www.ibm.com/­products/­informixwww.actian.com/­data-management/­ingres-sql-rdbmswww.intersystems.com/­products/­intersystems-iris
Technical documentationdocs.heavy.aiinformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
docs.actian.com/­ingresdocs.intersystems.com/­irislatest/­csp/­docbook/­DocBook.UI.Page.cls
DeveloperHEAVY.AI, Inc.IBM, HCL Technologies infoEffective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.Actian CorporationInterSystems
Initial release2015201619841974 infooriginally developed at University Berkely in early 1970s2018
Current release5.10, January 202214.10.FC5, November 202011.0, April 20172021.1, June 2021
License infoCommercial or Open SourceOpen Source infoSimplified BSD LicenseOpen Source infoApache Version 2; enterprise edition availablecommercial infofree developer edition availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++ and CUDAC, C++ and JavaC
Server operating systemsFreeBSD
Linux
OS X
LinuxAIX
HP-UX
Linux
macOS
Solaris
Windows
AIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
AIX
Linux
macOS
Windows
Data schemeschema-freeyesyesyesdepending on used data model
Typing infopredefined data types such as float or datenoyesyes infoSince Version 12.10 support for JSON/BSON datatypesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono infobut tools for importing/exporting data from/to XML-files availableyes
Secondary indexesnonoyesyesyes
SQL infoSupport of SQLnoyesyesyesyes
APIs and other access methodsMemcached protocolJDBC
ODBC
Thrift
Vega
JDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
JDBC
ODBC
RESTful HTTP API
Supported programming languages.Net
C
C++
ColdFusion
Erlang
Java
Lisp
Lua
OCaml
OCaml
Perl
PHP
Python
Ruby
All languages supporting JDBC/ODBC/Thrift
Python
.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net
C++
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresnonoyesyesyes
Triggersnonoyesyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infoRound robinShardinghorizontal partitioning infoIngres Star to access multiple databases simultaneouslySharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replicationMulti-source replication
Source-replica replication
Ingres ReplicatorSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infoMVCCyes
Durability infoSupport for making data persistentnoyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyesnoyes
User concepts infoAccess controlnofine grained access rights according to SQL-standardUsers with fine-grained authentication, authorization, and auditing controlsfine grained access rights according to SQL-standardyes
More information provided by the system vendor
Cachelot.ioHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022InformixIngresInterSystems IRIS
Specific characteristicsOptimizes memory and compute layers to deliver unprecedented performance. Natively...
» more
Competitive advantagesOnly HEAVY.AI allows users to visually and interactively discover high-value patterns,...
» more
Typical application scenariosAdvanced analytics, geospatial and time-series analytics, accelerated data science,...
» more
Licensing and pricing modelsHEAVY.AI Free (Free Forever), Foundations ($2k/month), and Enterprise Licensure (Inquire...
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Cachelot.ioHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022InformixIngresInterSystems IRIS
Recent citations in the news

OmniSci Gets HEAVY New Name and New CEO
1 March 2022, Datanami

HEAVY.AI Introduces New Capabilities that Enable Organizations to Gain Faster Access to Rapidly Growing Data Sets and Deliver Decision-Quality Information
23 March 2022, insideBIGDATA

The insideBIGDATA IMPACT 50 List for Q2 2022
27 April 2022, insideBIGDATA

The insideBIGDATA IMPACT 50 List for Q3 2022
19 July 2022, insideBIGDATA

Heard on the Street – 6/1/2022
1 June 2022, insideBIGDATA

provided by Google News

Jonathan Rende Articles and Insights
12 August 2022, DevOps.com

Software Engineer (Snr) at Parvana Recruitment
19 August 2022, IT-Online

The women writing checks: A list of female venture capitalists in the Pacific Northwest
10 August 2022, GeekWire

The Data Replication Market in 2022
24 February 2022, Datamation

Best Data Migration Tools and Software 2022 | ENP
29 December 2021, EnterpriseNetworkingPlanet

provided by Google News

Neon nabs $30M to build a scalable cloud service for Postgres databases
26 July 2022, TechCrunch

Actian’s plan for the AI era
27 May 2022, Protocol

Two Sizes Fit Most: PostgreSQL and ClickHouse – The New Stack
13 April 2022, thenewstack.io

AEC plots next stage of mammoth election systems rebuild
5 August 2022, iTnews

DataStax Astra DB gets Change Data Capture
25 April 2022, iProgrammer

provided by Google News

InterSystems releases updates to its IRIS data platform
19 August 2022, DataCenterNews Asia

The Solutions to Today's Supply Chain Disruptions: Intelligent Management
25 July 2022, Business Wire

InterSystems Takes Data Fabrics to the Next Level with Ever-Increasing Embedded Analytics Capabilities
16 August 2022, ACROFAN USA

InterSystems opens first Kiwi office as 'Hira' health spend ramps up
28 July 2022, Reseller News

InterSystems IRIS Data Platform reduces complexity for Epic customers
13 November 2020, TechTarget

provided by Google News

Job opportunities

Data Analyst
Cambridge Technology Enterprises (CTE), Atlanta, GA

Warehouse Shipping and Receiving Clerk
Inmar, Remote

Informix DBA
Ignite IT, Remote

Technical Services Support Specialist
Tyler Technologies, Tempe, AZ

SQL Developer
Providge Consulting, White Plains, NY

Manager of Court Information Technology
City of Aurora, CO, Aurora, CO

Database Administrator III
Fred Hutchinson Cancer Research Center, Seattle, WA

Systems Engineer (Junior)
Cognosante, LLC, Virginia

Systems Analyst
Teradyne Infotech, Farmington Hills, MI

Intelligence Analyst
CACI, Dahlgren, VA

System Administrator - Master
M & M Technical Services, Andrews, TX

System Administrator
Persistent Technology, Remote

Software Engineer
TriCore Reference Laboratories, Remote

Interface Engineer
Netsmart Technologies, Remote

Full Stack Developer
InterSystems, Cambridge, MA

Hospital HIE Interface Engineer
Cognosante, LLC, Alabama

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here