Wednesday, August 5, 2020

Difference between CouchDB and Relational Database

Database CouchDB, Relational Database, Oracle Database Tutorial and Material, Database Guides, Database Exam Prep

1. 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.

2. Relational Database:


RDBMS stands for Relational Database Management Systems. It is most popular database. In it, data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily accessed because data is store in the table. This Model was proposed by E.F. Codd.

Difference between CouchDB and Relational Database:


COUCHDB RELATIONAL DATABASE 
It is developed by Apache Software Foundation and initially released in 2005. It is developed by Oracle on May 1995.
It is written in Erlang language.   It is developed in C and C++ languages. 
The primary database model for CouchDB is the Document Store.  The primary database model for a relational database is client/server model. 
It can handle only one connection at a time.  It can handle multiple connections simultaneously. 
It does support XML data format.  It does not support XML data format. 
In CouchDB, there is no predefined datatypes.  It supports predefined data types such as float, date, number, etc. 
It does not support Secondary indexes.  It supports secondary indexes. 
It does not support ACID transactions.  It provides ACID transactions. 
It supports Map Reduce method.  It does not support Map-Reduce method. 
It has no Data Schema.  It has Data Schema. 

Related Posts

0 comments:

Post a Comment