nosql-expert

Topics in the source

• NoSQL Expert Patterns (Cassandra & DynamoDB)
• Overview
• When to Use
• The Mental Shift: SQL vs. Distributed NoSQL
• Core Design Patterns
• 1. Query-First Modeling (Access Patterns)
• 2. The Partition Key is King
• 3. Clustering / Sort Keys

This skill provides professional mental models and design patterns for distributed wide-column and key-value stores (specifically Apache Cassandra and Amazon DynamoDB). Unlike SQL (where you model data entities), or document stores (like MongoDB), these distributed systems require you to model your queries first. Designing for Scale: Moving beyond simple single-node databases to distributed clusters. Technology Selection: Evaluating or using Cassandra, ScyllaDB, or DynamoDB. Performance Tuning: Troubleshooting "hot partitions" or high latency in existing NoSQL systems. Microservices: Implementing "database-per-service" patterns where highly optimized reads are required. | Feature | SQL (Relational) | Distributed NoSQL (Cassandra/DynamoDB) | | :--- | :--- | :--- | | Data modeling | Model Entities + Relationships | Model Queries (Access Patterns) | | Joins | CPU-intensive, at read time | Pre-computed (Denormalized) at write time | | Storage cost | Expensive (minimize duplication) | Cheap (duplicate data for read speed) | | Consistency | ACID (Strong) | BASE (Eventual) / Tunable | | Scalability | Vertical (Bigger machine) | Horizontal (More nodes/shards) | The Golden Rule: In SQL, you

This is an excerpt. Refer to the complete source and its current requirements.