Member-only story

Modelling Many to Many Relationships in Amazon DynamoDB

By utilising Amazon DynamoDB to model many to many relational data we can utilise a service that has single digit millisecond performance as well as high availability and durability

Marco Susilo
6 min readJul 14, 2023

--

Photo by Dom Fou on Unsplash

Why Use Amazon DynamoDB?

Amazon DynamoDB is a managed and highly scalable NoSQL database service in AWS. It is very effective when working with a online transaction processing (OLTP) application.

Relational Database Management Systems (RDBMS) already exists and can also be used for such applications, however, this technology was created at a time where data storage costs was relatively high when compared to data processing costs. As a result RDBMS aim to reduce data stored by normalisation and reducing any data duplication. Furthermore, these systems can be quite costly (server costs and licenses) and is only vertically scalable.

With the utilisation of cloud, data storage costs has become very inexpensive relative to data processing costs and that is where Amazon DynamoDB can be a solution for an application that provides single digit millisecond performance as well as high availability and durability.

--

--

Marco Susilo
Marco Susilo

Written by Marco Susilo

A Kaggle expert, certified Machine Learning Specialist AWS, passionate about cloud, analytics and technology. Founder of PassionIT (https://www.passionit.tech)

No responses yet