DB-EngineseXtremeDB reduces memory consumptionEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > IBM Db2 vs. RocksDB vs. XAP

System Properties Comparison IBM Db2 vs. RocksDB vs. XAP

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonRocksDB  Xexclude from comparisonXAP  Xexclude from comparison
DescriptionCommon in IBM host environments, 2 different versions for host and Windows/LinuxEmbeddable persistent key-value store optimized for fast storage (flash and RAM)High performant in-memory data grid for mission critical applications. Insight Edge from the same company extends XAP for AI/ML support, BI and other interfaces
Primary database modelRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBKey-value storeDocument store
Key-value store infoValues are user defined objects
Secondary database modelsDocument store
RDF store infoin DB2 LUW (Linux, Unix, Windows)
Object oriented DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score161.90
Rank#6  Overall
#5  Relational DBMS
Score3.84
Rank#88  Overall
#15  Key-value stores
Score1.01
Rank#170  Overall
#27  Document stores
#31  Key-value stores
Websitewww.ibm.com/­analytics/­db2rocksdb.orgwww.gigaspaces.com/­products/­xap
Technical documentationwww.ibm.com/­support/­knowledgecenter/­SSEPGGgithub.com/­facebook/­rocksdb/­wikidocs.gigaspaces.com/­latest/­landing.html
DeveloperIBMFacebook, Inc.Gigaspaces Technologies
Initial release1983 infohost version20132000
Current release12.1, October 20166.13.3, October 202014.5.0, June 2019
License infoCommercial or Open Sourcecommercial infofree version is availableOpen Source infoBSDOpen Source infoApache Version 2; Commercial licenses available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++C++Java, C++, .Net
Server operating systemsAIX
HP-UX
Linux
Solaris
Windows
z/OS
Linux
macOS
Solaris
Windows
Data schemeyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesnoyes
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.nono infoXML can be used for describing objects metadata
Secondary indexesyesnoyes
SQL infoSupport of SQLyesnoSQL-like query language and DML statements
APIs and other access methodsADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
C++ API
Java API
GigaSpaces LRMI
Hibernate
JCache
JDBC
JPA
ODBC
RESTful HTTP API
Spring Data
Supported programming languagesC
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
C++
Java
.Net
C++
Java
Server-side scripts infoStored proceduresyesnoyes
Triggersyesnoyes infoEvent Listeners
Partitioning methods infoMethods for storing different data on different nodesSharding infoonly with Windows/Unix/Linux VersionnoneSharding infoHash based
Replication methods infoMethods for redundantly storing data on multiple nodesyes infowith separate tools (MQ, InfoSphere)noneMulti-source replication infosynchronous or asynchronous
Source-replica replication infosynchronous or asynchronous
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infoMap-Reduce pattern can be built with XAP task executors
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency infoConsistency level configurable: ALL, QUORUM, ANY
Foreign keys infoReferential integrityyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyesACID
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
User concepts infoAccess controlfine grained access rights according to SQL-standardnoRole-based access control

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
3rd partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
IBM Db2 infoformerly named DB2 or IBM Database 2RocksDBXAP
Recent citations in the news

Db2 And SQL Services Get Upgrades With TRs
12 October 2020, IT Jungle

How The Latest TRs Bolster The Core IBM i OS
7 October 2020, IT Jungle

BMC Enhances Mainframe Resiliency and Advances Enterprise DevOps
1 October 2020, AiThority

Forty8Fifty Labs to Hold DevOps Tech Summit On-Demand, October 26-29
20 October 2020, PRNewswire

Face Forensics announces tattoo recognition upgrade to biometric algorithm
8 October 2020, Biometric Update

provided by Google News

AMD EPYC vs. Intel Xeon Cascadelake With Facebook's RocksDB Database
17 October 2019, Phoronix

Toshiba Memory America Optimizes RocksDB for SSDs
1 August 2019, Business Wire

Micron Announces An Open-Source Storage Engine Designed For SSDs, Persistent Memory
27 April 2020, Phoronix

Toshiba Memory America Highlights TRocksDB at SNIA's 2019 Storage Developer Conference
23 September 2019, Business Wire

Facebook Open Sources MyRocks DB Engine And ZStandard Compression Algorithm
3 September 2016, Fossbytes

provided by Google News

Top 3 In-memory Computing Platforms
6 November 2019, Customer Think

GigaSpaces opens up its in-memory data grid
9 August 2016, SiliconANGLE

Space-based Architecture and Microservices in XAP
29 December 2015, DZone News

GigaSpaces Empowers Developers with Open Source In-Memory Computing Platform
11 August 2016, insideBIGDATA

GigaSpaces raises $12 million to accelerate AI workloads with in-memory computing
5 May 2020, VentureBeat

provided by Google News

Job opportunities

Jr. SQL Database Administrator
GOLDEN WOLF LLC, Remote

Sr Database Administrator
Fast Dolphin, Remote

JDA Developer
Relevance Lab, Remote

100 - Mainframe Production Support
L&T Infotech, Hartford, CT

Database Administrator (DBA)_L3
Internet of Things LLC, Omaha, NE

Digital - MarketData APIs
FactSet Research Systems, York, NY

Software Engineer
DataDog, Denver, CO

Senior Software Engineer - Ads Attribution
Twitter, New York, NY

Sr. Cloud Engineer (Remote)
CrowdStrike, United States

Remote MySQL Support Engineer South America Hours
Percona, Raleigh, NC

jobs by Indeed




Share this page

Featured Products

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

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

Neo4j logo

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

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here