More free Course Material on this YouTube channel
SQL or NOSQL service, that´s the question. As you can see in the following NoSQL example, you can get any unstructured data in a data string or its JSON document with a single key-value. Like this, you can change for prices on ecommerce websites in real-time. Not as fast are SQL queries in strictly structure excel like table cells, identified by column and row addresses.
But which of the four main AWS services should you choose? For SQL, the answer is simple with RDS or Aurora relational Databases and the Redshift Data Warehouse. These services can even handle a bit of JSON documents. RDS is a standardized service on its instance with seven optional SQL database engines and Aurora provides two of them. That’s just the thing for read-intensive enterprise apps. Aurora instances are organized in clusters and connected with an additional distributed storage cluster and a serverless option. All of this gives you higher global SQL performance and scalability also for modern global apps. Similar, Redshift data warehouse instances are also organized in clusters for very large data analytics such as Business Intelligence at moderate costs.
In contrast, DynamoDB is a highly flexible and scalable serverless NoSQL database for modern serverless apps with multi-media. It provides the smallest storages size, but compensates this not only with the highest availability, but also with extreme scalability like Redshift.
What makes the difference? Whereas Redshift offers you the largest tables and clusters, DynamoDB table and items are limited and smallest in size. Small and hefty comes to mind with DynamoDB’s highest availability and extreme scalability like Redshift. For such a case, you don´t select RDS. And when it comes to throughput and latency, remember to consider Aurora and the fast processing of DynamoDB. This isn’t really a domain of Redshift, as it covers really large data solutions in many variants with multiple performance options. Altogether, if costs but not size is your preference, architect with DynamoDB instead of the costly Aurora. With the understanding of the these relevant database services, you are ready for more details.
With this short reading, we compared most relevant AWS Cloud Database characteristics. We wish you further insights!
If you do not have any abbreviations to hand, you can find further information under this link:
