1. Oracle :
Oracle is a relational management system. It is 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 a major platform like WINDOWS, UNIX, LINUX and MACOS. It will relational database in which data accessed by the user through the application or query language called SQL.
2. PouchDB :
Difference between Oracle and PouchDB :
|1.||It is developed by Oracle Corporation in 1980.||It is developed by Apache Software Foundation in 2012.|
|3.||It is a commercial software.||It is an open-source software.|
|4.||The Primary database model for Oracle is Relational DBMS.||The primary database model for PouchDB is Document Store.|
|6.||It uses Horizontal partitioning method for storing different data on different nodes.||It uses Sharding partitioning method for storing different data on different nodes.|
|7.||Immediate Consistency method ensures consistency.||Eventual Consistency method ensures consistency in a distributed system.|
|8.||ACID properties of transaction are used.||It does not provides ACID transactions.|
|9.||The replication method that Oracle supports is Master Slave Replication, Master-master replication.||The replication method that PouchDB supports is Master Slave Replication, Master-master replication.|
|10.||It provides fine grained access rights according to SQL-standard.||It provides access rights for users can be defined per database.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.