如何在AWS DynamoDB中联接表？

本文介绍了如何在AWS DynamoDB中联接表？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我知道整个设计应该基于自然的汇总（文档），但是我正在考虑为本地化实现一个单独的表（语言，键，文本），然后在其他表中使用键。但是，我找不到执行此操作的任何示例。

I know the whole design should be based on natural aggregates (documents), however I'm thinking to implement a separate table for localisations (lang, key, text) and then use keys in other tables. However, I was unable to find any example on doing this.

任何指针都可能有用！

推荐答案

您是正确的， DynamoDB并非设计为关系数据库，并且不支持联接操作。您可以将DynamoDB看作是一组键值对。

You are correct, DynamoDB is not designed as a relational database and does not support join operations. You can think about DynamoDB as just being a set of key-value pairs.

您可以在多个表中使用相同的键（例如document_ID），但是DynamoDB却没有自动同步它们或具有任何外键功能。一个表中的document_ID，尽管名称相同，但从技术上讲是与另一个表中的document_ID不同的集合。

You can have the same keys across multiple tables (e.g. document_IDs), but DynamoDB doesn't automatically sync them or have any foreign-key features. The document_IDs in one table, while named the same, are technically a different set than the ones in a different table. It's up to your application software to make sure that those keys are synced.

DynamoDB是考虑数据库的另一种方式，您可能需要考虑使用托管关系数据库，这取决于您的应用程序软件。例如Amazon Aurora： aws.amazon/rds/aurora/

DynamoDB is a different way of thinking about databases and you might want to consider using a managed relational database such as Amazon Aurora: aws.amazon/rds/aurora/

需要注意的一件事是，Amazon EMR确实允许连接DynamoDB表，但是我不确定这就是您要查找的内容： docs.aws.amazon/ElasticMapReduce/latest/DeveloperGuide/EMRforDynamoDB.html

One thing to note, Amazon EMR does allow DynamoDB tables to be joined, but I'm not sure that's what you're looking for: docs.aws.amazon/ElasticMapReduce/latest/DeveloperGuide/EMRforDynamoDB.html