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
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
- The Beginner's Guide to Databasestechnically.substack.com
- A More Human Approach To Databasesccorcos.github.io
- Understanding IndexedDB. The complete guide.blog.xnim.me
- What the heck are you actually using NoSQL for? - High Scalability -highscalability.com
- pthorpe92.devpthorpe92.dev
- How Does a Database Work?cstack.github.io
- NoSQL - Database Systemscs186berkeley.net
- Databricks: Leading Data and AI Solutions for Enterprisesmooncake.dev
- An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com