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

DBMS > IBM Db2 vs. Percona Server for MongoDB vs. SQLite

System Properties Comparison IBM Db2 vs. Percona Server for MongoDB vs. SQLite

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 comparisonPercona Server for MongoDB  Xexclude from comparisonSQLite  Xexclude from comparison
DescriptionCommon in IBM host environments, 2 different versions for host and Windows/LinuxA drop-in replacement for MongoDB Community Edition with enterprise-grade features.Widely used in-process RDBMS
Primary database modelRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBDocument storeRelational DBMS
Secondary database modelsDocument store
RDF store infoin DB2 LUW (Linux, Unix, Windows)
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score171.35
Rank#6  Overall
#5  Relational DBMS
Score0.52
Rank#205  Overall
#30  Document stores
Score120.36
Rank#11  Overall
#7  Relational DBMS
Websitewww.ibm.com/­analytics/­db2www.percona.com/­software/­mongo-database/­percona-server-for-mongodbwww.sqlite.org
Technical documentationwww.ibm.com/­support/­knowledgecenter/­SSEPGGwww.percona.com/­doc/­percona-server-for-mongodb/­LATEST/­index.htmlwww.sqlite.org/­docs.html
DeveloperIBMPerconaDwayne Richard Hipp
Initial release1983 infohost version20152000
Current release12.1, October 20163.4.10-2.10, November 20173.30.1, October 2019
License infoCommercial or Open Sourcecommercial infofree version is availableOpen Source infoGPL Version 2Open Source infoPublic Domain
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++C
Server operating systemsAIX
HP-UX
Linux
Solaris
Windows
z/OS
Linuxserver-less
Data schemeyesschema-freeyes infodynamic column types
Typing infopredefined data types such as float or dateyesyesyes infonot rigid because of 'dynamic typing' concept.
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
Secondary indexesyesyesyes
SQL infoSupport of SQLyesnoyes infoSQL-92 is not fully supported
APIs and other access methodsADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
proprietary protocol using JSONADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
Supported programming languagesC
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Actionscript
C
C#
C++
Clojure
ColdFusion
D
Dart
Delphi
Erlang
Go
Groovy
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Perl
PHP
PowerShell
Prolog
Python
R
Ruby
Scala
Smalltalk
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
Server-side scripts infoStored proceduresyesJavaScriptno
Triggersyesnoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoonly with Windows/Unix/Linux VersionShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes infowith separate tools (MQ, InfoSphere)Master-slave replicationnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Foreign keys infoReferential integrityyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infovia file-system locks
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.yes infovia In-Memory Engineyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and rolesno

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
Navicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
» 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 2Percona Server for MongoDBSQLite
DB-Engines blog posts

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Recent citations in the news

Db2 For IBM i 7.3 Hits A Bad Patch
2 December 2019, IT Jungle

Latest TRs For IBM i Now Available
20 November 2019, IT Jungle

Syniti Releases Data Replication Solution, Offers Free Trial
4 December 2019, Database Trends and Applications

Delivering Delphix to a Database Near You
26 November 2019, Security Boulevard

IBM Injects 'Data Science' AI Into Its Db2 Database
4 June 2019, Forbes

provided by Google News

Percona XtraDB and MongoDB Operators for Kubernetes
7 June 2019, InfoQ.com

Percona Server for MongoDB 4.0 an Ideal Solution for Even More Use Cases
31 October 2018, GlobeNewswire

After Red Hat, Homebrew removes MongoDB from core formulas due to its Server Side Public License adoption
3 September 2019, Packt Hub

Percona Expands Support for Cloud Native Applications and Hybrid Multi-Cloud Environments with the Percona Cloud Native Autonomous Database Initiative
29 May 2019, GlobeNewswire

Percona packages PostgreSQL alongside existing MySQL and MongoDB products
1 October 2019, The Register

provided by Google News

It's Hipp to be square: What happened when SQLite creator met GitHub
3 December 2019, The Register

Transform Data Into Game-Changing Insights with This SQL Training
7 December 2019, Entrepreneur

Learn how to use SQL database management systems with this $21 bundle
13 December 2019, iMore

RDBMS Software Market Size, Trends, Growth and Forecast Analysis Report from 2019-2025 : PostgreSQL Global Development Group, SQLite
10 December 2019, The Connect Report

Clever attack uses SQLite databases to hack other apps, malware servers
10 August 2019, ZDNet

provided by Google News

Job opportunities

Database Administrator_Remote
Sawdey Solution Services, Inc., Remote

Sr. DB2 Database Developer
Bank of America, Pennington, NJ

DATABASE ADMINISTRATOR
New York City FINANCIAL INFO SVCS AGENCY, Manhattan, NY

Senior Mainframe Database Administrator
Liberty Mutual Insurance, Portsmouth, NH

Data Modeler / Database Developer
Defined Clarity, Washington, DC

MySQL DBA - remote
Percona, Remote

Database Administrator
The Rector & Visitors of the University of Virginia, Charlottesville, VA

Lead DBA
ADP, Alpharetta, GA

Senior Database Administrator
O'Reilly Auto Parts, Springfield, MO

Database Administrator
VS Media, Westlake Village, CA

IT Application Developer - Journey *12206-19
State of Washington Dept. of Fish and Wildlife, Olympia, WA

Android Developer (Marvel)
Marvel Entertainment, New York, NY

Entry Level Developer
Best Value Technology Inc., Virginia

Software Engineer - Java
Piper Companies, Chapel Hill, NC

Newsperson, Data Journalist, State Politics and Policy
Associated Press, United States

jobs by Indeed




Share this page

Featured Products

Couchbase logo

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


Datastax logo

Build data-driven applications that set the standard for performance, availability,
& scale with DataStax.
Learn more.

Redis logo

Hosted, serverless DBaaS
in 3 steps.

30MB Free!
Start now.

AllegroGraph logo

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

Neo4j logo

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

Present your product here