Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why well-designed DynamoDB application require only one table?

On Amazon DynamoDB help center I've read that

You should maintain as few tables as possible in a DynamoDB application. Most well designed applications require only one table.

Sorry guys, but what does it mean? Whether should I design a database with just ONE table, or should I work with just one table in my (let it be php) application (but a database may contain several tables)?

Thank you!

like image 351
Volodymyr Nabok Avatar asked Apr 24 '18 20:04

Volodymyr Nabok


1 Answers

I think this One Table concept means if you draw a relational database diagram of your models and associations, then all associated tables that connected should be able to be merged, or designed into one single NoSQL table. If you got two sets of tables in the same relational database that have no association between them, then you can group them into two separate NoSQL tables.

like image 162
G. Dulin Avatar answered Nov 14 '22 10:11

G. Dulin