Some DynamoDB questions

Hi,

I hope below helps you.

How does the concept of Index in DynamoDB from the concept of INdex Relational DBs?

The concept of index between the two is roughly the same, though their implementations and types are fundamentally different. Both allow you to access data faster. In dynamo thought, there are some indexes that allow you to view data in different forms, based on your access patterns. The beginning of this article explains really well how: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.Indexes.Creating.html

Can I partition tables like in transactional DB in DynamoDB?

In dynamo partitions is done automatically. The way you influence it though, is via picking the right partition keys that match best the access pattern you need. A bit on partitions here: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.Partitions.html

Are aggregation operations possible to do using a NoSQL like DynamoDB?

No. It doesn’t support aggregations out of the box as dynamo is meant for low-key fast data access. To do that, you ll need to handle in your application code or move the data out of dynamo to components that support aggregation such as Redshift.