- Newest
- Most votes
- Most comments
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.
Relevant content
- asked 2 years ago
- asked a year ago
- asked 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago
Thank you very much for your answers. Have a great day!