Some DynamoDB questions

0

Hi @Everyone,

Could someone enlighten me?

  1. How does the concept of Index in DynamoDB from the concept of INdex Relational DBs?
  2. Can I partition tables like in transactional DB in DynamoDB?
  3. Are aggregation operations possible to do using a NoSQL like DynamoDB? Thank you in advance for the answers

Highly appreciate the clarifications.

Amy
demandé il y a un an214 vues
1 réponse
1
Réponse acceptée

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.

profile picture
EXPERT
répondu il y a un an
profile pictureAWS
EXPERT
kentrad
vérifié il y a un an
  • Thank you very much for your answers. Have a great day!

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions