DB-Tools.com - system comparision
26th September 2020, Saturday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Cassandra (Datastax) RiakDB
 Version 2.1 2.2.0 (released Nov 17)
 Drawbacks Paid Version, License Fees, Support Fees 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
 Advantages DB Failover capability, Enterprise support available 1.http calls for crud operations(unlike sql queries) 2.multi-datacenter replication
 Website www.datastax.com www.basho.com
 XML Support Not Available.Generally not available in NOSQL DB. Well known RDBMS have this feature NA
 Name Cassandra (Datastax) Riak
 Languages Supported C C# C++ Java Node.js PHP Python Ruby Ruby, Java, Erlang and Python
 JSON Support yes yes
 Brief description DataStax was built on the open source NoSQL database Apache Cassandra. Cassandra was initially developed internally at Facebook to handle large data sets across multiple servers. It was released as an Apache open source project in 2008 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 and Azure Marketplace. Available as a Hybrid Cloud SaaS Option - NA 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, Linux , OS X, Windows
 Options for Integration / Access API CQL (Cassandra Query Language is like SQL) Gremlin 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 Graph DB built natively on top of the core NoSQL Column Store. Graph and NoSQL component share the same core. Enterprise version of Cassandra supports HighAvailability (HA) Multi DataCenter Replication. This feature is not offered by any other nosql vendor
 Concurrency Yes Yes
 Partitioning Yes Sharding
 Replication Yes Multi Data Center Replication supported
 Secondary Indexes Yes --
 SchemaLess Yes --
 SQL Query No, but CQL is similar to SQL --