DB-Tools.com - system comparision
21st September 2020, Monday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Apache Cassandra AWS DynamoDB
 Version 3 released Jan 2012
 Drawbacks community support only available Very few features when compared to other key-value stores
 Name Apache Cassandra Amazon DynamoDB
 Advantages Open Source Columnar NoSQL Database with excellent performance Managed Database Service provided by a leading cloud provider
 Languages Supported C C# C++ Java Node.js PHP Python Ruby Java, Node.js, Go, C# .NET, Perl, PHP, Python, Ruby, Haskell and Erlang.
 Website www.datastax.com/products/datastax-enterprise aws.amazon.com/­dynamodb
 XML Support no no
 JSON Support yes yes
 Brief description MongoDB is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemata. MongoDB is developed by MongoDB Inc. Amazon DynamoDB is a fully managed proprietary NoSQL database service that supports key-value and document data structures[2] and is offered by Amazon.com as part of the Amazon Web Services portfolio
 Database Model Primarily a NoSQL database Key Value Model
 Technical Documentation docs.datastax.com aws.amazon.com/­documentation/­dynamodb
 License Commercial commercial on aws cloud.
 Cloud-based / SaaS Virtual Machine Images available in AWS Azure and Google Cloud Marketplace. https://bitnami.com/stack/cassandra/cloud/aws Yes but you can download dynamod db locally as well. Local installation does not have vendor support
 Implementation Language C,C++ C++
 Operating System Supported Linux OS X Solaris Windows Linux , OS X, Windows
 Options for Integration / Access API CQL (Cassandra Query Language is like SQL) Thrift Protocol Rest API
 Consistency Highly Consistent Immediate consistency
 Foreign Keys No No
 Streaming Support Yes No
 Analytics Support One of the core features is to build timeseries apps NA
 Data Storage Schema Key Value Column Family NoSQL DB Key Value Model
 Notable Users Samsung Smartthings, ING Vysya , Safeway As per Amazon the solution has been deployed by around 100,000 customers
 Key Differentiator Open Source NoSQL DB. The GoTo DB for Columnar NoSQL databases Amazon allows developers to purchase a service based on throughput, rather than storage.
 Concurrency Yes Yes
 Partitioning Yes Sharding
 Replication Yes - Tunable Master-Slave Replication Multi Data Center Replication supported
 Secondary Indexes Yes Yes
 SchemaLess Yes Yes
 SQL Query No, but CQL is similar to SQL No