Thursday, February 18, 2021

Difference between Oracle and CouchDB

Oracle and CouchDB, Oracle Database Tutorial and Material, Database Preparation, Database Learning, Database Certification

1. Oracle :

Oracle is a relational database management system (RDBMS). It was developed by Oracle Corporation in 1980. It is the first database designed for grid computing that provides the most flexible and cost-effective way to manage information and application. It runs on major platforms like Windows, Unix, Linux, and macOS. It is a relational database in which data is accessed by the user through the application or query language called SQL.

2. CouchDB :

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 Oracle and CouchDB :

ORACLE COUCHDB 
It was developed by Oracle Corporation in 1980.  It was developed by Apache Software Foundation in 2005.
It is written in C and C++.  It is written in Erlang language. 
It is a commercial software.  It is an open-source software. 
The primary database model for Oracle is Relational DBMS.  The primary database model for CouchDB is Document Store. 
It uses Horizontal partitioning method for storing different data on different nodes.  It uses Sharding partitioning method for storing different data on different nodes. 
The replication methods that Oracle supports are Master-Slave Replication, Master-Master Replication.  The replication methods that CouchDB supports are also Master-Slave Replication, Master-Master Replication. 
Server operating systems for Oracle are Solaris, Linux, OS X, Windows.  Server operating systems for CouchDB are Android, BSD, Linux, OS X, Solaris and Windows. 
ACID properties of transaction are used.  It does not provides ACID transactions. 
Immediate Consistency method ensures consistency.  Eventual Consistency method ensures consistency in a distributed system. 
It provides fine grained access rights according to SQL-standard. It provides access rights for users can be defined per database. 

Related Posts

0 comments:

Post a Comment