DB-Tools.com - system comparision
5th December 2020, Saturday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Aurora Oracle DB
 Version Version 4.2.8 12c
 Drawbacks NA costly. You get comparable performance with open source rdbms databases
 Advantages Managed RDBMS from AWS Robust. Long proven history. Remote connections very stable
 Languages Supported Content Management Interoperability Services (CMIS) C, C++
 Website aws.amazon.com/rds/aurora/ https://www.oracle.com
 Name AWS Aurora Oracle DB
 XML Support no yes
 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 It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads
 Database Model Relational Database Primarily a relational database
 Technical Documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html docs.oracle.com/en/database
 License Commercial Commercial
 Cloud-based / SaaS SaaS Service from AWS Available in AWS, Azure Clouds. Available as a SaaS option in Oracle Cloud
 Implementation Language NA C,C++
 Operating System Supported Not Applicable as its managed by AWS AIX HP-UX Linux OS X Solaris Windows z/OS
 Options for Integration / Access API Restful HTTP Rest API (Oracle Lite), Oracle Call Interface (OCI) JDBC ODBC
 Consistency NA Highly Consistent
 Foreign Keys Yes Yes
 Streaming Support Yes No
 Analytics Support NA Need to buy Exadata (high cost)
 Data Storage Schema NA Relational Database
 Notable Users NA Most of the Fortune 500 Companies
 Key Differentiator Supports MySQL as a SaaS service (Inno Db Engine). Disk Space provisioning done in 10 GB chunks automatically upto 64 TB. Highly reliable as a transactional database
 Concurrency Yes Yes
 Partitioning No No
 Replication Yes Yes
 Secondary Indexes Yes based on secondary indexes using Solr Yes
 SchemaLess Yes No
 SQL Query No Yes