如何在AWS DynamoDB中联接表？ [英] How to join tables in 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： https://aws.amazon.com/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: https://aws.amazon.com/rds/aurora/

需要注意的一件事是，Amazon EMR确实允许连接DynamoDB表，但是我不确定这就是您要查找的内容： http://docs.aws.amazon.com/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: http://docs.aws.amazon.com/ElasticMapReduce/latest/DeveloperGuide/EMRforDynamoDB.html

这篇关于如何在AWS DynamoDB中联接表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！