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 AWS DynamoDB Hive
 Name Amazon DynamoDB --
 Version released Jan 2012 3.1.2
 Drawbacks Very few features when compared to other key-value stores Can run only on Hadoop with mapreduce
 Advantages Managed Database Service provided by a leading cloud provider A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported Java, Node.js, Go, C# .NET, Perl, PHP, Python, Ruby, Haskell and Erlang. --
 Website aws.amazon.com/­dynamodb https://hive.apache.org
 XML Support no no
 JSON Support yes yes
 Brief description Amazon DynamoDB is a fully managed proprietary NoSQL database service that supports key-value and document data structures[2] and is offered by Amazon.com as part of the Amazon Web Services portfolio 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 Key Value Model Tabular Data Model
 Technical Documentation aws.amazon.com/­documentation/­dynamodb --
 License commercial on aws cloud. --
 Cloud-based / SaaS Yes but you can download dynamod db locally as well. Local installation does not have vendor support --
 Implementation Language C++ C,C++
 Operating System Supported Linux , OS X, Windows Linux, OS X,
 Options for Integration / Access API Rest API -
 Consistency Immediate consistency Highly Consistent
 Foreign Keys No No
 Streaming Support No Yes
 Analytics Support NA --
 Data Storage Schema Key Value Model --
 Notable Users As per Amazon the solution has been deployed by around 100,000 customers -
 Key Differentiator Amazon allows developers to purchase a service based on throughput, rather than storage. Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency Yes Yes
 Partitioning Sharding Yes
 Replication Multi Data Center Replication supported Yes
 Secondary Indexes Yes Yes
 SchemaLess Yes --
 SQL Query No No