Cassandra
Introduction Cassandra was built at Facebook then released as
open source in 2008. It’s now being managed by The
Apache Software Foundation.
Primary database Wide column store
model
Supported operating BSD, Linux, OS X, Windows
systems
Support of SQL SQL-like SELECT, DML and DDL statements (CQL)
Stored Procedure No
support
Triggers support Yes
Replication methods Selectable replication factor
In-memory capabilities No
Written language Java
Protocol CQL3
Advantages Free of cost
Peer to peer structural design
Elasticity
Fault tolerance
Great Performer
Column based
Adjustable steadiness
Disadvantages No support to Data Integration
No streaming of globule values.
No cursor support,
Large outputs must be physically paged
When to use Cassandra is the best choice for use cases:
SQL-style data types.
Very fast write speeds.
Steep learning curve when switching from SQL.
Conclusion In short, if you want a database that’s similar to RDBMS but offers more flexibility at the same time, ch
Cassandra. If you need a higher degree of flexibility and are willing to learn something new, pick Mon
(Source- https://tableplus.io/blog/2018/10/cassandra-vs-mongodb-nosql-db-comparison.html)
MongoDB
MongoDB was built in 2007 by 10gen, which later
renamed to MongoDB, Inc. MongoDB, Inc. provides
development of the software and sells their
enterprise solution.
Document store
Linux, OS X, Solaris, Windows
Read-only SQL queries via the MongoDB Connector
for BI
Javascript
No
Master-slave replication
Yes
C++
Custom binary (BSON)
Scalability
Flexibility
User-friendly
No concept of rows and columns
No re-establishment of indexing
Memory is not expandable
Joins can be done only through multiple queries
No transactions can be done
MongoDB is best for workloads with:
Lots of highly unstructured data.
Evolving data requirements.
Loosely coupled objectives — the design may change
by over time
ilar to RDBMS but offers more flexibility at the same time, choose
flexibility and are willing to learn something new, pick MongoDB.
018/10/cassandra-vs-mongodb-nosql-db-comparison.html)
Additional info
They are both NoSQL database.
No ACID compliance.
Both keep recent data in memory to improve performance.
Both data stores discourage joins and prefer denormalization.
Name Cassandra
Description Wide-column store based on ideas of BigTable
and DynamoDB Optimized for write access
Primary database model Wide column store
Secondary database models
DB-Engines Ranking
Score 123.37
Rank #11 Overall
#1 Wide column stores
Website cassandra.apache.org
Technical documentation cassandra.apache.org/doc/latest
Developer Apache Software Foundation
Initial release 2008
Current release 3.11.4, February 2019
License Open Source
Cloud-based only no
Implementation language Java
Server operating systems BSD
Linux
OS X
Windows
Data scheme schema-free
Typing yes
XML support no
Secondary indexes restricted
SQL SQL-like SELECT, DML and DDL statements
(CQL)
APIs and other access methods Proprietary protocol
Thrift
Supported programming languages C#
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript
Perl
PHP
Python
Ruby
Scala
Server-side scripts no
Triggers yes
Partitioning methods Sharding
Replication methods selectable replication factor
MapReduce yes
Consistency concepts Eventual Consistency
Immediate Consistency
Foreign keys no
Transaction concepts no
Concurrency yes
Durability yes
In-memory capabilities no
User concepts Access rights for users can be defined per
object
MongoDB Oracle NoSQL
One of the most popular document stores Key-value store based on Berkeley DB
Java Edition
Document store Key-value store
Relational DBMS
Score 395.09 Score 3.05
Rank #5 Overall Rank #80 Overall
#1 Document stores #13 Key-value stores
www.mongodb.com www.oracle.com/database/nosql/index.html
docs.mongodb.com/manual docs.oracle.com/cd/NOSQL/index.html
MongoDB, Inc Oracle
2009 2011
4.0.6, February 2019 18.3, November 2018
Open Source Open Source
no no
C++ Java
Linux Linux
OS X Solaris SPARC/x86
Solaris
Windows
schema-free optional, scheme definition possible with
AVRO or in 'table-style'
yes optional
no
yes yes
Read-only SQL queries via the MongoDB SQL-like DML and DDL statements
Connector for BI
proprietary protocol using JSON RESTful HTTP API
Actionscript C
C C#
C# Java
C++ JavaScript (Node.js)
Clojure Python
ColdFusion
D
Dart
Delphi
Erlang
Go
Groovy
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Perl
PHP
PowerShell
Prolog
Python
R
Ruby
Scala
Smalltalk
JavaScript no
no no
Sharding Sharding
Master-slave replication Electable Master-Slave per shard
yes with Hadoop integration
Eventual Consistency Eventual Consistency
Immediate Consistency Immediate Consistency
no no
Multi-document ACID Transactions with configurable
snapshot isolation
yes yes
yes yes
yes yes
Access rights for users and roles Access rights for users and roles
