DB-Tools.com - system comparision
19th September 2020, Saturday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Aurora IBM DB2
 Name AWS Aurora IBM DB2
 Version Version 4.2.8 Last Stable Release 11.1 , released in april 2016
 Drawbacks NA high license costs. Applicable for transaction systems in large enterprises
 Advantages Managed RDBMS from AWS ACID compliant.
 Languages Supported Content Management Interoperability Services (CMIS) C C# C++ Cobol Delphi Fortran Java JCL Perl PHP Python Ruby Visual Basic
 Website aws.amazon.com/rds/aurora/ www.ibm.com/­analytics/­us/­en/­db2
 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 IBM Db2 was the name introduced by IBM in 1983. The names DB2(tm) and Db2(tm) refer to database-server products developed by IBM. IBM Researchers invented Relational model and SQL Format.
 Database Model Relational Database Primarily a relational database
 Technical Documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html www.ibm.com/­support/­knowledgecenter/­SSEPGG
 License Commercial Commercial
 Cloud-based / SaaS SaaS Service from AWS Available in AWS, Azure Clouds. Available as a SaaS option in IBM Cloud
 Implementation Language NA C,C++
 Operating System Supported Not Applicable as its managed by AWS Linux Windows
 Options for Integration / Access API Restful HTTP JSON Query, Xquery, JDBC, ODBC
 Consistency NA Highly Consistent
 Foreign Keys Yes Yes
 Streaming Support Yes No
 Analytics Support NA Need to buy Netezza
 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. Go To Database for IBM Mainframe Systems
 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