Amazon DynamoDB has been one of the most popular NoSQL databases in the cloud since its introduction in 2012. It is central to many modern applications in ad tech, gaming, IoT, and financial services. As opposed to a traditional RDBMS , like PostgreSQL, DynamoDB scales horizontally, obviating the need for careful capacity planning, resharding, and database maintenance.
Companies turn to DynamoDB for building event-driven architectures and user-friendly, performant applications at scale. As an operational database, DynamoDB is optimized for real-time transactions even when deployed across multiple geographic locations. However, it does not provide strong performance for analytics workloads. In this ebook, we discuss the analytical query performance of DynamoDB and compare different options for ETL and analytics tools including Athena, Hive/Spark, Elasticsearch, ElasticCache for Redis, Redshift and Rockset.