Primary Key and Secondary Indexes in DynamoDB | by Mahima Manik | Medium
DynamoDB is a NoSQL database which is fully managed by AWS. DynamoDB can manage structured or semistructured data, including JSON documents. Relational databases are primarily meant for data integrity, not performance. Whereas NoSQL is highly available, scalable and optimized for high performance. DynamoDB uses key-value pairs or document storage for data management. As a managed service, many implementation details i.e., storage and availability complexity are taken care by AWS.Basic components of DynamoDB are: Primary key is the attribute which uniquely identifies each item in the table, so that no two items can have the same key value. Primary key in DynamoDB can be a single attribute or composite attribute: Composite primary key provides more flexibility in the query. Ex: if only partition key is provided in the query, it returns all the items in the table with same partition key value. Subset of items (or single item) can be retrieved by adding sort key value range in the query It
Primary Key and Secondary Indexes in DynamoDB Mahima Manik 7 min read · Oct 4, 2022 -- 1 Listen Share DynamoDB is a NoSQL database which is fully managed by AWS. DynamoDB can manage structured or semistructured data, including JSON documents. Relational databases are primarily meant for data integrity, not performance. Whereas NoSQL is highly available, scalable and optimized for high performance. DynamoDB uses key-value pairs or document storage for data management. As a managed service, many implementation details i.e., storage and availability complexity are taken care by AWS.Basic componen
Explore this link on the map →saved by
related reading
- Things to keep in mind while picking a partition key in DynamoDB | by Ekta Garg | Mediummedium.com
- Build Your Own Databasenan.fyi
- An in-depth look at Database Indexingfreecodecamp.org
- A More Human Approach To Databasesccorcos.github.io
- What the heck are you actually using NoSQL for? - High Scalability -highscalability.com
- pthorpe92.devpthorpe92.dev
- NoSQL - Database Systemscs186berkeley.net
- An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com
- SQL vs NoSQL in 8 Examples | Towards Data Sciencetowardsdatascience.com
- Clustered and non-clustered indexesibm.com
- Sharding with Amazon Relational Database Service | AWS Database Blogaws.amazon.com
- The Problem with Using a UUID Primary Key in MySQL — PlanetScaleplanetscale.com