DB-Tools.com - system comparision
25th January 2022, Tuesday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Apache Cassandra Hive
 Version 3 3.1.2
 Drawbacks community support only available Can run only on Hadoop with mapreduce
 Name Apache Cassandra --
 Advantages Open Source Columnar NoSQL Database with excellent performance A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported C C# C++ Java Node.js PHP Python Ruby --
 Website www.datastax.com/products/datastax-enterprise https://hive.apache.org
 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. The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive
 Database Model Primarily a NoSQL database Tabular Data Model
 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++ C,C++
 Operating System Supported Linux OS X Solaris Windows Linux, OS X,
 Options for Integration / Access API CQL (Cassandra Query Language is like SQL) Thrift Protocol -
 Consistency Highly Consistent Highly Consistent
 Foreign Keys No No
 Streaming Support Yes 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 Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency Yes Yes
 Partitioning Yes Yes
 Replication Yes - Tunable Master-Slave Replication Yes
 Secondary Indexes Yes Yes
 SchemaLess Yes --
 SQL Query No, but CQL is similar to SQL No