DB-Tools.com - system comparision
22nd September 2020, Tuesday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Aurora Microsoft SQLServer
 Name AWS Aurora Microsoft SQL Server
 Version Version 4.2.8 Sqlserver 2017
 Drawbacks NA high license costs. Applicable for transaction systems in large enterprises
 Advantages Managed RDBMS from AWS ACID compliant. Easy to use User Interface
 Languages Supported Content Management Interoperability Services (CMIS) C# C++ Delphi Go Java JavaScript (Node.js) PHP Python R (Microsoft R) Ruby Visual Basic
 Website aws.amazon.com/rds/aurora/ www.microsoft.com/en-us/sql-server
 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 As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).
 Database Model Relational Database Primarily a relational database
 Technical Documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html docs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentation
 License Commercial Commercial
 Cloud-based / SaaS SaaS Service from AWS Available in AWS, Azure Clouds. Available as a SaaS option in Microsoft 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 OLE DB, Tabular Data Stream (TDS), ADO.NET, JDBC, ODBC
 Consistency NA Highly Consistent
 Foreign Keys Yes Yes
 Streaming Support Yes No
 Analytics Support NA Need to buy SQLServer Analytics Pack (SSAS)
 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