Скачать или смотреть MongoDB| Designing Schema| SNS INSTITUTIONS

MongoDB Designing Schema focuses on optimizing for how data will be accessed and used, leveraging its document-oriented nature. Unlike relational databases with rigid schemas and joins, MongoDB allows for flexible, dynamic schemas and emphasizes embedding related data within a single document to improve performance.
Key Principles of MongoDB Schema Design:
Embedding vs. Referencing:
Embedding: Store related data directly within a parent document, suitable for "one-to-few" relationships where the embedded data is frequently accessed with the parent and doesn't grow excessively large. This reduces the need for joins and improves read performance.
Referencing: Store related data in separate documents and link them using references (similar to foreign keys), suitable for "one-to-many" or "many-to-many" relationships, or when embedded data could become very large or is not always needed with the parent.
Denormalization: MongoDB encourages denormalization, where data might be duplicated across documents to avoid frequent joins and improve query performance for specific access patterns. This contrasts with the normalization principles of relational databases.
Data Access Patterns: Design your schema based on how your application will query and update data. Group data together that is frequently accessed together to minimize the number of queries needed.
Indexes: Create indexes on fields that are frequently queried to improve read performance. Consider compound indexes for queries involving multiple fields.
Cardinality of Relationships:
One-to-few: Embedding is often preferred.
One-to-many (bounded): Embedding or child references can be used depending on the size and access patterns.
One-to-many (unbounded) and Many-to-many: Parent references or a combination of referencing and embedding might be necessary.
Schema Validation: While MongoDB is schemaless by default, you can enforce schema validation rules to ensure data consistency and quality, especially in production environments.
#snsinstitutions #snsdesignthinkers #designthinking