What users are saying about

Amazon DynamoDB

Top Rated
52 Ratings

Amazon DynamoDB

Top Rated
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

Azure SQL Database

98 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Add comparison

Likelihood to Recommend

Amazon DynamoDB

It is best for high demand over short periods of time and then being scaled down to save costs. This is kind of a pay for what you need model. This falls short though because while you can scale up unlimited you can only scale down 4 times a day which can be a limitation for some.
Adam Lauer profile photo

Azure SQL Database

If you have any apps in the cloud, this is the way to go. The interface and management is much better than AWS, and no one else is getting closer. If you are running just BI, you could go with a Snowflake or Cloudera approach, but Cloudera is complex and Snowflake simply sits on top of Azure Data Storage anyway, and I hear will soon be an offering by Microsoft as well.
No photo available

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
7.9
Azure SQL Database
Performance
Amazon DynamoDB
8.0
Azure SQL Database
Availability
Amazon DynamoDB
8.4
Azure SQL Database
Concurrency
Amazon DynamoDB
9.0
Azure SQL Database
Security
Amazon DynamoDB
8.7
Azure SQL Database
Scalability
Amazon DynamoDB
9.7
Azure SQL Database
Data model flexibility
Amazon DynamoDB
4.0
Azure SQL Database
Deployment model flexibility
Amazon DynamoDB
7.3
Azure SQL Database

Database-as-a-Service

Amazon DynamoDB
Azure SQL Database
9.2
Automatic software patching
Amazon DynamoDB
Azure SQL Database
9.5
Database scalability
Amazon DynamoDB
Azure SQL Database
9.5
Automated backups
Amazon DynamoDB
Azure SQL Database
9.0
Database security provisions
Amazon DynamoDB
Azure SQL Database
9.4
Monitoring and metrics
Amazon DynamoDB
Azure SQL Database
8.6
Automatic host deployment
Amazon DynamoDB
Azure SQL Database
9.0

Pros

  • Amazon DynamoDB excels at quite, intuitive object retrievals. The usage of hash and range keys to retrieve flat objects means it's easy to understand what you are going to get and how to map out objects into entities in your data access layer.
  • Amazon DynamoDB is great at adding new indexes to a table, making it fast and intuitive for prototyping.
  • The ability to use Amazon CloudWatch monitoring on Amazon DynamoDB is very helpful for managing data analysis and discovering issues without a large investment.
Jordan Bayles profile photo
  • It optimizes cost - pay per usage. It can scale up and down as needed.
  • It can be migrated to from Oracle, MySQL and other on premises databases.
  • It is always updated with management and administrative functionalities being added weekly.
No photo available

Cons

  • Query "language" leaves much to be desired. If you're coming from a database like MongoDB or SQL you'll find it extremely difficult to get data back out of the system without breaking the bank.
  • Because querying is poor, often the only way to get data out of arbitrary fields is by scanning the records – but the pricing model for this is cost prohibitive. This means you frequently need additional architecture to keep track of where data is stored in the hash table. While this is an issue for lots of NoSQL database, DynamoDB is probably the worst offender I've used to date because of the pricing model.
  • Amazon does offer a local version of DynamoDB you can run in development, but its an extremely clunky and very hard to integrate into any kind of continuous integration.
Justin Schroeder profile photo
  • Intelligent recommendations are not a silver bullet, since they often fail to detect opportunities that are obvious to a human database admin with any experience.
  • Certain advanced database features - most recently I found: column store indices - are locked behind pricing tiers that one would naively assume are just about performance.
Erik Ralston profile photo

Likelihood to Renew

Amazon DynamoDB6.9
Based on 13 answers
I wouldn't stay with the product, but may simply because I have no other choice. The reason for keeping it will depend on if we are given time by management to go to another solution (back to an SQL database) or the purchase of an ETL tool.
No photo available
Azure SQL Database8.0
Based on 1 answer
This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.
Zimran Azim profile photo

Support

No score
No answers yet
No answers on this topic
Azure SQL Database9.0
Based on 1 answer
It has been a drastic change but the shift was so smooth.
Zimran Azim profile photo

Alternatives Considered

We ended up selecting DynamoDB compared to similar products simply because we host on AWS. To use any other NoSQL solution would require more work in the long run due to having to maintain the EC2 instance, manage updates to the operating system and whatever NoSQL system that was chosen.
No photo available
Amazon Relational Database Service is the other obvious competitor. We were already in Azure, so it's not a serious contender for our business due to that bias already, but I do personally find the marketing and documentation of RDS more intimidating to sort through.
Erik Ralston profile photo

Return on Investment

  • The system is free to use (to a point).
  • The system was relatively easy to get setup to add data.
  • The system is difficult to access data without the use of scripts to handle return of data (unless you utilize an ETL tool).
No photo available
  • Overall it increased the business profits as customers trust the system.
  • Storage capacity is very large so we do not need to worry about this.
  • It saves business old transactions to monitor business growth and help in making plans for the future.
Simranjeet Singh profile photo

Pricing Details

Amazon DynamoDB

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Azure SQL Database

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details