DB-Tools.com - system comparision
23rd September 2020, Wednesday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System ClickHouse Apache Cassandra
 Version -- 3
 Drawbacks -- community support only available
 Name -- Apache Cassandra
 Advantages -- Open Source Columnar NoSQL Database with excellent performance
 Languages Supported -- C C# C++ Java Node.js PHP Python Ruby
 Website -- www.datastax.com/products/datastax-enterprise
 XML Support -- no
 JSON Support -- 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.
 Database Model -- Primarily a NoSQL database
 Technical Documentation -- docs.datastax.com
 License -- Commercial
 Cloud-based / SaaS -- Virtual Machine Images available in AWS Azure and Google Cloud Marketplace. https://bitnami.com/stack/cassandra/cloud/aws
 Implementation Language -- C,C++
 Operating System Supported -- Linux OS X Solaris Windows
 Options for Integration / Access API -- CQL (Cassandra Query Language is like SQL) Thrift Protocol
 Consistency -- Highly Consistent
 Foreign Keys -- No
 Streaming Support -- Yes
 Analytics Support -- One of the core features is to build timeseries apps
 Data Storage Schema -- Key Value Column Family NoSQL DB
 Notable Users -- Samsung Smartthings, ING Vysya , Safeway
 Key Differentiator -- Open Source NoSQL DB. The GoTo DB for Columnar NoSQL databases
 Concurrency -- Yes
 Partitioning -- Yes
 Replication -- Yes - Tunable Master-Slave Replication
 Secondary Indexes -- Yes
 SchemaLess -- Yes
 SQL Query -- No, but CQL is similar to SQL