Editorial information provided by DB-Tools |
System |
Name |
Azure Cosmos DB |
IBM DB2 |
Version |
NA |
Last Stable Release 11.1 , released in april 2016 |
Drawbacks |
1.Most often compared with MongoDB. Unlike Mongo DB does not support joins
2.Managed Database which can be used only within Azure/Microsoft framework |
high license costs. Applicable for transaction systems in large enterprises |
Advantages |
NA |
ACID compliant. |
Languages Supported |
.net, C#, Javascript |
C
C#
C++
Cobol
Delphi
Fortran
Java
JCL
Perl
PHP
Python
Ruby
Visual Basic |
Website |
www.azure.microsoft.com/services/cosmos-db |
www.ibm.com/analytics/us/en/db2 |
XML Support |
no |
yes |
JSON Support |
yes |
yes |
Brief description |
1.Globally distributed, horizontally scalable, multi-model database service
2.Earlier called Azure Document DB. Skype, Xbox uses this DB, Office, Active Directory and MSC (all Microsoft products) |
IBM Db2 was the name introduced by IBM in 1983. The names DB2(tm) and Db2(tm) refer to database-server products developed by IBM.
IBM Researchers invented Relational model and SQL Format. |
Database Model |
Key Value DB |
Primarily a relational database |
Technical Documentation |
docs.microsoft.com/en-us/azure/cosmos-db |
www.ibm.com/support/knowledgecenter/SSEPGG |
License |
commercial on azure cloud. |
Commercial |
Cloud-based / SaaS |
Azure Cloud based |
Available in AWS, Azure Clouds. Available as a SaaS option in IBM Cloud |
Implementation Language |
NA |
C,C++ |
Operating System Supported |
Linux , OS X, Windows |
Linux
Windows
|
Options for Integration / Access API |
Rest API , MongoDB drivers |
JSON Query,
Xquery,
JDBC,
ODBC |
Consistency |
Eventual consistency |
Highly Consistent |
Foreign Keys |
No |
Yes |
Streaming Support |
No |
No |
Analytics Support |
NA |
Need to buy Netezza |
Data Storage Schema |
Multi Model Database |
Relational Database |
Notable Users |
-- |
Most of the Fortune 500 Companies |
Key Differentiator |
-- |
Go To Database for IBM Mainframe Systems |
Concurrency |
-- |
Yes |
Partitioning |
-- |
No |
Replication |
-- |
Yes |
Secondary Indexes |
-- |
Yes |
SchemaLess |
-- |
No |
SQL Query |
-- |
Yes |