Advantages and Disadvantages of DynamoDB

How Does DynamoDB Benefit your DB Management & Performance?

• Scalable- Virtual unlimited storage, users can store infinity amount of data according to their need
• Cost Effective- It seems to be cutting costs, while a big part of data is able to migrate from SQL to NOSQL. Basically it charges for reading, writing, and storing data along with any optional features you choose to enable in DynamoDB
• Data Replication- All data items are stored on SSDs and replication is managed internally across multiple availability zones in a region or can be made available across multiple regions
• Serverless- DynamoDB scales horizontally by expanding a single table over multiple servers
• Easy Administration- Amazon DynamoDB is a fully managed service, you don't need to worry about hardware or software provisioning, setup & configuration, software patching, distributed database cluster or partitioning data over multiple instances as you scale
• Schemaless DB, Ideal for IoT, Mobile, Gaming
• Secure- Customizable traffic filtering, Regulatory Compliance Automation, Comprehensive Database Threat Detection, Advanced System of Notification and Reporting

Why DynamoDB isn’t the Right Choice for you?

• Weak querying model, querying data is extremely limited. DynamoDB is simple to use until it refuses to scale. Throwing data in DynamoDB is the easiest thing you can ever do. It is less complex as you don’t have to be worried about logging in and setting up a cluster. To start operating this service, you just turn a knob, look for an SDK, and sling JSON
• Lack of server-side scripts. The first law of using DynamoDB is to assume that its implementation will be harder compared to employing a relational database you are well-versed with. At a small scale, a relational database will accomplish each of your needs. This is far from the assumption that DynamoDB technology is awful
• Table Joins - Joins are impossible, Triggerless. With DynamoDB, you can only provision its capacity at the entire table level
• Hard to predict cost when that usage might spike, it's not unheard of, to get caught with unexpected costs
• Provisioned throughput and batch jobs don't work well together. DynamoDB can be scaled – until it’s not simple, suitable for small scale
• Available for single-region tables only
• Limited to a maximum of 10 items or 4MB of data. You can’t redesign all the applications
• No client-controlled transactions. Setting it up will initially take a long time compared to DynamoDB. However, the well-established SQL conventions will save you a lot of time in the long run. Business value trumps architectural design each time. Various developers abandoned NoSQL to provide solutions for both small and middle-sized businesses

Workloads Which are Not Suitable for DynamoDb

• When multi-item or cross table transactions are required
• When complex queries and joins are required
• When real-time analytics on historic data is required

If Not DynamoDB then What ??