Easy data storage but at what cost?
September 14, 2017
Easy data storage but at what cost?
Score 3 out of 10
Vetted Review
Verified User
Overall Satisfaction with Amazon DynamoDB
My company utilizes DynamoDb for storage of site traffic data for sites hosted on our product. We felt that a NoSQL solution from Amazon would be a great fit to store a massive amount of data because our already tightly integrated AWS hosted solution. This would solve the large problem of this data living in a standard SQL database which were increasingly becoming less performance.
- Speed of data inserts.
- Quick setup of tables and integration into code.
- Automated system management
- Ease of use, I had to search several non-Amazon tutorials to figure out setup.
- Integration into RDBMS would be a great improvement. Currently to move data around you have to export it and reimport into your destination. You could use Amazon Data Migration services - but not very straight forward.
- You only have once instance. If you want to group tables into a "database", you cannot do that.
- 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).
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.