1. Cassandra :
Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. It was developed by Apache Software foundation and initially released on July 2008. Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.
2. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. PostgreSQL was the first DBMS that implemented multi-version concurrency control (MVCC) feature.
Difference between Cassandra and PostgreSQL :
|1.||Developed by Apache Software foundation and released on July 2008.||Developed By PostgreSQL Global Development Group on 1989.|
|2.||It is wide-column store based on ideas of BigTable and DynamoDB.||It is widely used open source RDBMS.|
|3.||Cassandra is written in Java languages.||PostgreSQL is written in C languages.|
|4.||The primary database model for Cassandra is Wide column store.||The primary database model for PostgreSQL is Relational DBMS.|
|5.||It has no Secondary database models.||It has Document store as Secondary database models.|
|6.||Server operating systems for Cassandra are BSD, Linux, OS X and Windows.||Server operating systems for PostgreSQL are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows.|
|7.||It does not support XML format.||It supports XML format.|
|8.||It supports Secondary indexing but in a restricted way, i.e., only equality queries, not always the best performing solution.||It supports Secondary indexing.|
|9.||It does not supports Server-side scripting.||It has user defined functions for Server-side scripts.|
|10.||It supports selectable replication factor method.||It supports Master-master replication method.|
|11.||In Cassandra, partitioning can be done Sharding.||In PostgreSQL, partitioning can be done by range, list and hash.|
|12.||It offers an API for user-defined Map/Reduce methods.||It does not offers an API for user-defined Map/Reduce method.|
|13.||Cassandra does not provides the concept of Referential Integrity. Hence, no Foreign Keys.||PostgreSQL provides the concept of Referential Integrity and have Foreign keys.|
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.