Things to keep in mind while picking a partition key in DynamoDB | by Ekta Garg | Medium
In a DynamoDB table, we will always have a primary key. The primary can consist of just a partition key (Simple Primary Key) or the combination of a partition key and a sort key (Composite Primary Key). Partition and Partition key: Partition is simply a logical separation or group of machines that are hosting your data for instance if you have hundreds of GB of data in your table, DynamoDB may create multiple partitions based on a key to separate out the data across these partitions. When a query comes in for a particular key, dynamo uses a particular key’s value which is called the partition key as the input to a hashing function and spits out the location of the record. Using this technique, dynamo can quickly go to the location and fetch the records with very very high performance. This diagram shows the organization of cart records placed by a user in a Cart table. Each order is uniquely identified by a combination of userID and cartID. Why choosing the right partition key is impor
Things to keep in mind while picking a partition key in DynamoDB Ekta Garg 3 min read · Mar 20, 2023 -- Listen Share Press enter or click to view image in full size architectural glass partitions Primary Key: In a DynamoDB table, we will always have a primary key. The primary can consist of just a partition key (Simple Primary Key) or the combination of a partition key and a sort key (Composite Primary Key). Partition and Partition key: Partition is simply a logical separation or group of machines that are hosting your data for instance if you have hundreds of GB of data in your table, DynamoD
Explore this link on the map →saved by
related reading
- Primary Key and Secondary Indexes in DynamoDB | by Mahima Manik | Mediummedium.com
- Introduction to partitioned tables | BigQuery | Google Cloud Documentationcloud.google.com
- Build Your Own Databasenan.fyi
- Hash-Range Partitioning | ben.kirw.inben.kirw.in
- Scaling PostgreSQL to power 800 million ChatGPT users | OpenAIopenai.com
- An in-depth look at Database Indexingfreecodecamp.org
- An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com
- Core Concepts for System Design Interviews | Hello Interview System Design in a Hurryhellointerview.com
- On Idempotency Keys - Gunnar Morlingmorling.dev
- Herding elephants: Lessons learned from sharding Postgres at Notionnotion.so
- Sharding with Amazon Relational Database Service | AWS Database Blogaws.amazon.com
- Parallel Query Processing - Database Systemscs186berkeley.net