DB-Tools.com - system comparision
25th September 2020, Friday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Aurora Hive
 Name AWS Aurora --
 Version Version 4.2.8 3.1.2
 Drawbacks NA Can run only on Hadoop with mapreduce
 Advantages Managed RDBMS from AWS A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported Content Management Interoperability Services (CMIS) --
 Website aws.amazon.com/rds/aurora/ https://hive.apache.org
 XML Support no no
 JSON Support yes yes
 Brief description Aurora is available as part of the Amazon Relational Database Service (RDS). Although it is a proprietary technology it offers MySQL compatible service since its release . This was made PostgreSQL compatible since October 2017 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 Relational Database Tabular Data Model
 Technical Documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html --
 License Commercial --
 Cloud-based / SaaS SaaS Service from AWS --
 Implementation Language NA C,C++
 Operating System Supported Not Applicable as its managed by AWS Linux, OS X,
 Options for Integration / Access API Restful HTTP -
 Consistency NA Highly Consistent
 Foreign Keys Yes No
 Streaming Support Yes Yes
 Analytics Support NA --
 Data Storage Schema NA --
 Notable Users NA -
 Key Differentiator Supports MySQL as a SaaS service (Inno Db Engine). Disk Space provisioning done in 10 GB chunks automatically upto 64 TB. Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency Yes Yes
 Partitioning No Yes
 Replication Yes Yes
 Secondary Indexes Yes based on secondary indexes using Solr Yes
 SchemaLess Yes --
 SQL Query No No