DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Atos Standard Common Repository vs. DuckDB vs. IBM Db2 warehouse vs. InterSystems IRIS

System Properties Comparison Atos Standard Common Repository vs. DuckDB vs. IBM Db2 warehouse vs. InterSystems IRIS

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAtos Standard Common Repository  Xexclude from comparisonDuckDB  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonInterSystems IRIS  Xexclude from comparison
This system has been discontinued and will be removed from the DB-Engines ranking.
DescriptionHighly scalable database system, designed for managing session and subscriber data in modern mobile communication networksAn embeddable, in-process, column-oriented SQL OLAP RDBMSCloud-based data warehousing serviceA containerised multi-model DBMS, interoperability and analytics data platform with wide capabilities for vertical and horizontal scalability
Primary database modelDocument store
Key-value store
Relational DBMSRelational DBMSDocument store
Key-value store
Object oriented DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.19
Rank#289  Overall
#134  Relational DBMS
Score1.70
Rank#134  Overall
#67  Relational DBMS
Score1.74
Rank#130  Overall
#21  Document stores
#24  Key-value stores
#2  Object oriented DBMS
#64  Relational DBMS
Websiteatos.net/en/convergence-creators/portfolio/standard-common-repositoryduckdb.orgwww.ibm.com/­products/­db2-warehousewww.intersystems.com/­products/­intersystems-iris
Technical documentationduckdb.org/­docsdocs.intersystems.com/­irislatest/­csp/­docbook/­DocBook.UI.Page.cls
DeveloperAtos Convergence CreatorsIBMInterSystems
Initial release2016201820142018
Current release17030.2, August 20202021.1, June 2021
License infoCommercial or Open SourcecommercialOpen Source infoMIT Licensecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemsLinuxserver-lesshostedAIX
Linux
macOS
Windows
Data schemeSchema and schema-less with LDAP viewsyesyesdepending on used data model
Typing infopredefined data types such as float or dateoptionalyesyesyes
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.yesnono infoImport/export of XML data possibleyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLnoyesyesyes
APIs and other access methodsLDAPCLI Client
JDBC
.NET Client API
JDBC
ODBC
OLE DB
JDBC
ODBC
RESTful HTTP API
Supported programming languagesAll languages with LDAP bindingsC
C++
Go info3rd party driver
Java
Python
R
Ruby info3rd party driver
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
.Net
C++
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresnonoPL/SQL, SQL PLyes
Triggersyesnoyesyes
Partitioning methods infoMethods for storing different data on different nodesSharding infocell divisionnoneShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesnoneyesSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of specific operationsACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes, multi-version concurrency control (MVCC)yesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes
User concepts infoAccess controlLDAP bind authenticationnofine grained access rights according to SQL-standardyes

More information provided by the system vendor

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
Atos Standard Common RepositoryDuckDBIBM Db2 warehouse infoformerly named IBM dashDBInterSystems IRIS
Recent citations in the news

New CWI spin-off company DuckDB Labs: Solutions for fast database analytics
14 July 2021, Centrum Wiskunde & Informatica (CWI)

Apache Arrow 5 Improves Asynchronous Scanner
16 August 2021, iProgrammer

4 predictions for open source in 2021
29 December 2020, IDG Connect

Data management system developed to bridge the gap between databases and data science
9 June 2020, Tech Xplore

provided by Google News

Best Data Warehouse Tools for Managing Your Data | ESF
24 September 2021, Enterprise Storage Forum

Best Data Warehouse Tools & Solutions 2021
23 September 2021, Server Watch

Best cloud databases of 2021
14 September 2021, ITProPortal

The 10 Best Cloud Data Warehouse Solutions to Consider in 2021
3 August 2021, Solutions Review

8 databases supporting in-database machine learning
28 April 2021, InfoWorld

provided by Google News

InterSystems announces IRIS FHIR Accelerator Service
23 September 2021, Healthcare IT News

InterSystems IRIS® FHIR® Accelerator Service Enables Easy Retrieval and Storage of Healthcare Data
20 September 2021, Business Wire

InterSystems IRIS FHIR accelerator service enables easy retrieval and storage of healthcare data
21 September 2021, DOTmed HealthCare Business News

InterSystems and Unqork Partner to Accelerate Innovation and Unlock Business Value for Financial Services Customers
27 August 2021, Business Wire

Latest Release of InterSystems IRIS Data Platform Provides Next Step in Data Fabric Adoption
17 June 2021, Business Wire

provided by Google News

Job opportunities

Junior Python Developer
Gryps, Upper Montclair, NJ

Senior Python Developer
Gryps, Austin, TX

Middleware Administrator
Snap IT Solutions, Houston, TX

Hybrid Data Management (HM) Cloud Program Manager
IBM, Research Triangle Park, NC

Data Science Platform Administrator - Senior Consultant
Guidehouse, Washington, DC

REMOTE Software Developer - InterSystems IRIS
Ellumen, Silver Spring, MD

Solutions Development Program
InterSystems, Cambridge, MA

Senior Server Engineer (AIX)
Sonic Healthcare USA, Inc, Austin, TX

HealthConnect Administrator (Remote Opportunity)
VetsEZ, Houston, TX

Cache Administrator (Remote Opportunity)
VetsEZ, Washington, DC

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database machine learning. Try Vertica for free with no time limit.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

Present your product here