DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > IBM Db2 warehouse vs. Kinetica vs. OmniSci

System Properties Comparison IBM Db2 warehouse vs. Kinetica vs. OmniSci

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonKinetica  Xexclude from comparisonOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018  Xexclude from comparison
DescriptionCloud-based data warehousing serviceGPU-accelerated database for real-time analysis of large and streaming datasetsA high performance, in-memory, column-oriented RDBMS, designed to run on GPUs
Primary database modelRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.61
Rank#119  Overall
#62  Relational DBMS
Score0.58
Rank#192  Overall
#96  Relational DBMS
Score2.55
Rank#92  Overall
#47  Relational DBMS
Websitewww.ibm.com/­products/­db2-warehousewww.kinetica.comwww.omnisci.com
Technical documentationwww.kinetica.com/­docswww.omnisci.com/­docs/­latest
DeveloperIBMKineticaMapD Technologies, Inc.
Initial release201420122016
Current release6.0V4
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache Version 2; enterprise edition available
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC, C++C++ and CUDA
Server operating systemshostedLinuxLinux
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.no infoImport/export of XML data possiblenono
Secondary indexesyesyesno
SQL infoSupport of SQLyesSQL-like DML and DDL statementsyes
APIs and other access methods.NET Client API
JDBC
ODBC
OLE DB
RESTful HTTP API
JDBC
ODBC
Thrift
JDBC
ODBC
Supported programming languagesJava
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
C++
Java
JavaScript (Node.js)
Python
All languages supporting JDBC/ODBC/Thrift
Python
Server-side scripts infoStored proceduresPL/SQL, SQL PLuser defined functionsno
Triggersyesyes infotriggers when inserted values for one or more columns fall within a specified rangeno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoRound robin
Replication methods infoMethods for redundantly storing data on multiple nodesyesMaster-slave replicationMaster-master replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integrityyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnono
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoGPU vRAM or System RAMyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and roles on table levelfine grained access rights according to SQL-standard

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
IBM Db2 warehouse infoformerly named IBM dashDBKineticaOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018
Recent citations in the news

IBM Infuses Db2 with AI to Bring Data Science and Database Management Under One Platform
4 June 2019, Yahoo Finance

IBM POWER9 on IBM Cloud to Help Accelerate Adoption of Hybrid Cloud
17 June 2019, PRNewswire

Holder Gateway Investment Advisers Raised Steel Dynamics (STLD) Position; Augustine Asset Management Has Lowered Its Holding in Intl Business Machines (I (IBM) by $409041
18 June 2019, Stocks Beat

Google looks to poach workloads for its cloud data warehouse
29 March 2019, TechTarget

Amazon Aids Redshift's Performance With Concurrency Scaling
28 March 2019, Nasdaq

provided by Google News

Global GPU Database Market 2019 Top key Players - Kinetica, Omnisci, Sqream, Neo4j, Nvidia, Brytlyt, Jedox, Blazegraph
18 June 2019, World Capital News

GPU Database Market 2019: Global Industry Analysis and Opportunity Assessment, Forecast to 2023
19 June 2019, Amazing Newspaper

Kinetica Appoints Elizabeth McGlauflin as Chief Customer Success Officer
6 June 2019, MarTech Advisor

Kinetica Hires New Chief Customer Success Officer in Response to Triple Digit Growth Across Global Install-Base and Adoption by Major Global 2000 Brands
5 June 2019, businesswire.com

GPU Database Market 2019 | Analysis by Industry Trends, Size, Share, Company Overview, Growth, Development and Forecast by 2025
19 June 2019, Gadget247News

provided by Google News

Global GPU Database Market 2019 Top key Players - Kinetica, Omnisci, Sqream, Neo4j, Nvidia, Brytlyt, Jedox, Blazegraph
18 June 2019, World Capital News

OmniSci enters EMEA market to push high-speed cloud analytics
31 May 2019, Data Economy

2019 Report: Graphics Processing Unit Database Market by Top Players Analysis – Zilliz, Brytlyt, Jedox AG – News Category
19 June 2019, Global Banking And Finance Review

Review: OmniSci GPU database lifts huge data sets
1 April 2019, InfoWorld

GPU Database Market analysis by Service Type, by Vertical
19 June 2019, Market Mirror

provided by Google News

Job opportunities

Data Integration Tester II
Western & Southern Financial Group, Cincinnati, OH

Senior Data Engineer
In-Q-Tel, Arlington, VA

Engineering Manager - Backend Core Team
OmniSci, San Francisco, CA

Support Engineer - (NYC or Washington DC)
OmniSci, Remote

Community Developer Advocate
OmniSci, Remote

Support Engineer - (NYC or Washington DC)
OmniSci, Washington, DC

jobs by Indeed




Share this page

Featured Products

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

AllegroGraph logo

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

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

Present your product here