MongoDB Schema Design and Data Modeling Flashcards

What is the key principle that distinguishes embedding from referencing in MongoDB schema design?

Answer: Embedding stores related data in the same document; referencing stores it in separate documents with links

Embedding stores related data within the same BSON document, enabling single-document reads. Referencing stores related data in separate documents and links them via ObjectId fields, similar to foreign keys, requiring multiple reads or $lookup for joins.

What is the maximum BSON document size in MongoDB?

Answer: 16 MB

MongoDB enforces a maximum BSON document size of 16 megabytes. This limit ensures that individual documents do not use excessive amounts of RAM or bandwidth. For larger data, use GridFS which splits files into chunks.

Which data modeling pattern is best suited when a one-to-many relationship has a bounded, small set of related items that are always read together?

Answer: Embedded document pattern

The embedded document pattern is optimal for one-to-many relationships where the 'many' side is bounded and small. Embedding keeps related data co-located, enabling single-document retrieval and avoiding expensive joins or multiple queries.

What is the Outlier Pattern in MongoDB schema design used for?

Answer: Managing a small number of documents that have many more relationships than typical documents

The Outlier Pattern addresses the situation where a few documents have far more related items than typical, such as a popular author with thousands of books. A flag field identifies outliers, and overflow data is stored in separate documents to avoid document size limits.

In MongoDB, what is the Bucket Pattern primarily used for?

Answer: Aggregating time-series or IoT data into fixed-size groups within a single document

The Bucket Pattern groups a stream of data (e.g., IoT sensor readings or time-series events) into fixed-size or time-window documents. Each bucket document holds many measurements, reducing document count, improving index performance, and enabling efficient range queries.

What is a key advantage of using the Polymorphic Pattern in MongoDB?

Answer: It allows documents with different shapes to be stored in the same collection, simplifying queries across related entities

The Polymorphic Pattern stores documents with different schemas in one collection. A discriminator field (e.g., 'type') identifies each variant. This simplifies queries that span different entity subtypes without requiring joins across multiple collections.