DB-Tools.com - system comparision
26th January 2021, Tuesday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System CouchDB Hive
 Name CouchDB --
 Version 3.3.5 3.1.2
 Drawbacks 1 Does not have capabilities present in an RDF data store e.g does not support SparQL Can run only on Hadoop with mapreduce
 Advantages NA A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported .net, C#, Javascript --
 Website apache.couchdb.org https://hive.apache.org
 XML Support NA no
 JSON Support yes yes
 Brief description Open Source Transactional database with native graph storage and processing 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 Property Graph Tabular Data Model
 Technical Documentation docs.microsoft.com/­en-us/­azure/­cosmos-db --
 License Community license can be run on 1 node.Enterprise License supports multi-node cluster deployment --
 Cloud-based / SaaS Amazon AMI available, On Prem can be installed --
 Implementation Language Java API C,C++
 Operating System Supported Linux , OS X, Windows Linux, OS X,
 Options for Integration / Access API Rest API -
 Consistency NA Highly Consistent
 Foreign Keys No No
 Streaming Support No Yes
 Analytics Support No --
 Data Storage Schema Key Value Store presented as Document DB --
 Notable Users -- -
 Key Differentiator -- Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency -- Yes
 Partitioning -- Yes
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- --
 SQL Query -- No