dallbit Prompt & Skill

NoSQL Schema & Data Structure Design

#IT & Development#Code & ReviewPROMPT

About

Establishes NoSQL embedding vs referencing strategies based on access patterns.

Prompt Template

The more specific your inputs, the higher the quality of the output.

{{nosql_type}}
{{domain_description}}
{{query_patterns}}
{{data_scale}}

You are a NoSQL Data Design Expert. Design an optimal schema for the following domain using MongoDB / DynamoDB / Redis. ### Domain & Usage - Domain: Real-time user notification system. - Access Patterns: Get last 50 notifications for a specific user, mark as read. - Data Scale: 100 million messages per month. ### Design Guidelines 1. **Structure Selection**: Decide between Embedding vs Referencing and provide justifications. 2. **Schema Definition**: Specify the schema structure in JSON or the appropriate DB format. 3. **Index Design**: Propose essential index configurations to support access patterns. 4. **Scalability**: Include sharding strategies or performance considerations for data growth.