'DynamoDB queries on Hierachical structures

On this lecture, the speaker gives two examples of Hierarchical Structures:

  1. as item collections enter image description here

  2. as Documents (JSON) enter image description here

Suppose it is needed to query for movies in which a particular actor appeared or the length of tracks, how would one proceed to achieve this?

I have a feeling that creating GSIs would work for the first case, but have no clue if it would be possible in the second case.

nosql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Configure DynamoDB stream trigger with insert only

Configure DynamoDB stream trigger with insert only

Elastic Cache vs DynamoDb DAX

Exporting DynamoDB to JSON

How to update multiple items in a DynamoDB table at once

Is there a less verbose way to write DynamoDB update params?

DynamoDB FilterExpression with multiple condition javascript

Formatting DynamoDB data to normal JSON in AWS Lambda

Maximum Partition key length of my data in Dynamo DB

How do I append a list to my DynamoDB table using Python?

How to model a relationship in Dynamoose/DynamoDB?

Dynamodb attribute converter provider for enhanced type extending Hashmap

dynamodb PartiQL SELECT query returns ValidationException: Unexpected from source

Dynamodb will consider the secondary index also a primary key, before put item into table.?

restoring DynamoDB table from AWS Backup