DB-Tools.com - system comparision
5th March 2021, 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