DB-Tools.com - system comparision
2nd December 2020, Wednesday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Apache Cassandra RiakDB
 Version 3 2.2.0 (released Nov 17)
 Drawbacks community support only available basho.com had funding problems and the company was sold to bet365.com in aug 2017. There is little clarity on product vision after the sale
 Name Apache Cassandra Riak
 Advantages Open Source Columnar NoSQL Database with excellent performance 1.http calls for crud operations(unlike sql queries) 2.multi-datacenter replication
 Languages Supported C C# C++ Java Node.js PHP Python Ruby Ruby, Java, Erlang and Python
 Website www.datastax.com/products/datastax-enterprise www.basho.com
 XML Support no NA
 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. Distributed NoSQL key-value data store that offers high availability, fault tolerance, operational simplicity, and scalability. There are three variants riakkv (keyvalue), riakts(time series) and riakcs (distributed storage)
 Database Model Primarily a NoSQL database Key Value Store
 Technical Documentation docs.datastax.com https://docs.basho.com/
 License Commercial Open Source. Multi Data Centre Replication needs an enterprise license
 Cloud-based / SaaS Virtual Machine Images available in AWS Azure and Google Cloud Marketplace. https://bitnami.com/stack/cassandra/cloud/aws SaaS options AWS-https://aws.amazon.com/marketplace/pp/B00AMRXCQA/ref=mkt_m3_riak, On-Prem available as well
 Implementation Language C,C++ Erlang
 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, ProtocolBuffers, Native Erlang Interface
 Consistency Highly Consistent Eventual consistency
 Foreign Keys No No
 Streaming Support Yes No
 Analytics Support One of the core features is to build timeseries apps No
 Data Storage Schema Key Value Column Family NoSQL DB Key Value Store with separate instances for timeseries,key-value and storage
 Notable Users Samsung Smartthings, ING Vysya , Safeway weather.com,bestbuy.com,nhs.co.uk,github.com
 Key Differentiator Open Source NoSQL DB. The GoTo DB for Columnar NoSQL databases Multi DataCenter Replication. This feature is not offered by any other nosql vendor
 Concurrency Yes Yes
 Partitioning Yes Sharding
 Replication Yes - Tunable Master-Slave Replication Multi Data Center Replication supported
 Secondary Indexes Yes --
 SchemaLess Yes --
 SQL Query No, but CQL is similar to SQL --