Open In App

Difference between MS SQL Server and CouchDB

Improve
Improve
Like Article
Like
Save
Share
Report

1. MS SQL Server :
Microsoft SQL Server is a relational database management system (RDBMS) which is platform dependent and it is both GUI and command based software. It supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It was developed by Microsoft Corporation and initially released on April 24, 1989. It is written in C and C++ languages.

2. CouchDB :
Apache CouchDB is an open-source document-oriented NoSQL database that uses multiple formats and protocols to store, transfer, and process its data, it uses JSON to store data, JavaScript as its query language using MapReduce, and HTTP for an API. It was developed by Apache Software Foundation and initially released in 2005. It is written in Erlang.

Difference between MS SQL Server and CouchDB :


S.NO. MS SQL Server CouchDB
1. Developed by Microsoft Corporation and initially released on April 24, 1989. Developed by Apache Software Foundation and initially released in 2005.
2. MS SQL server is written in C and C++. CouchDB is written in Erlang.
3. The primary database model for MS SQL Server is Relational Database. The primary database model for CouchDB is Document Store.
4. The license for MS SQL Server is Commercial. The license for CouchDB is open source.
5. In MS SQL Server Data Schema is fixed. CouchDB is Data Schema free.
6. MS SQL Server supports XML data format. CouchDB does not supports XML data format.
7. MS SQL Server have predefined datatypes such as float, date, number, etc. In CouchDB there is no predefined datatypes.
8. MS SQL Server supports SQL. CouchDB do not have SQL support.
9. MS SQL Server does not supports Map Reduce method. CouchDB supports Map Reduce method.
10. MS SQL server supports Foreign Keys. CouchDB does not supports Foreign Keys.
11. MS SQL server supports ACID transactions. CouchDB does not supports ACID transactions.
12. MS SQL server provides Immediate Consistency method to ensure consistency in a distributed system. CouchDB provides Eventual Consistency method to ensure consistency in a distributed system.
13. Server operating systems for MS SQL Server are Linux Windows. Server operating systems for CouchDB are Android, BSD, Linux, OS X, Solaris and Windows.
14. Famous companies like Citi, Bank of America, UPS, etc uses MS SQL Server. Famous companies like Akamai Technologies, Hothead Games, Inc., GenCorp Technologies, Vivint Solar, etc uses CouchDB.


Last Updated : 20 Jun, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads