02. BSON Data Types & Document Schema Design (Embedding vs Referencing) • MongoDB & NoSQL Architecture: CRUD to Sharding & WiredTiger • Rishabh Ki Kaksha

MongoDB & NoSQL Architecture: CRUD to Sharding & WiredTiger › 02. BSON Data Types & Document Schema Design (Embedding vs Referencing)

40 mins

← Prev Next →

Course Syllabus

Module 1: MongoDB Foundations, BSON & CRUD Mechanics

01. NoSQL vs SQL: CAP Theorem & Document-Oriented Architecture 02. BSON Data Types & Document Schema Design (Embedding vs Referencing) 03. High-Performance CRUD Operations, BulkWrite & Write Concerns 04. Schema Validation with JSON Schema ($jsonSchema)

Module 2: Advanced Aggregation Framework & Data Pipelines

05. Aggregation Pipeline Core: $match, $project, $group, $sort & $limit 06. Complex Transformations: $unwind, $lookup (Joins) & $facet (Multi-Facet Analytics) 07. Window Operators ($setWindowFields) & Accumulator Functions

Module 3: Indexing Strategies & Query Optimization

08. B-Tree Indexes in MongoDB: Single Field, Compound & Partial Indexes 09. Special Indexes: TTL (Time-To-Live), Geospatial (2dsphere) & Text Indexes 10. Query Profiling, explain("executionStats") & Index Covering Analysis

Module 4: Storage Engine Internals (WiredTiger) & ACID Transactions

11. WiredTiger Storage Engine Architecture: Cache, Compression & Checkpoints 12. Read Concerns (local, majority, linearizable) & Write Concerns (w:majority, j:true) 13. Multi-Document Distributed ACID Transactions with Sessions

Module 5: High Availability, Replica Sets, Sharding & Backups

14. Replica Sets Architecture: Primary Election, Oplog & Automatic Failover 15. Sharding Architecture: mongos Router, Config Servers & Shard Key Selection 16. Range vs Hash Sharding, Chunk Balancing & Jumbo Chunks Mitigation 17. Change Streams: Building Real-Time Event-Driven Pipelines with MongoDB 18. Production Backup Strategies: mongodump/mongorestore, Point-in-Time & Atlas CLI

Interactive Lesson Studio

# 02. BSON Data Types & Document Schema Design (Embedding vs Referencing)

> MongoDB Notes by Rishabh - Topic 02

---

### 1. JSON vs BSON (Binary JSON 💾)

MongoDB disk par plain text JSON store nahi karta — **BSON (Binary JSON)** store karta hai:
*   **Fast Traversal:** Field length prefix hoti hai jisse parser bina string parse kiye direct jump kar sakta hai.
*   **Rich Types:** `ObjectId`, `Date`, `Binary`, `Int64`, `Decimal128`, `Regex`.

#### Anatomy of an `ObjectId` (12 Bytes / 24 Hex Chars):
```
[ 4-Byte Timestamp ] [ 5-Byte Random Value (Process/Machine) ] [ 3-Byte Incrementing Counter ]
```

---

### 2. Schema Design: Embedding vs Referencing (The #1 Decision 👑)

#### Pattern A: Embedding (1-to-Few / Denormalization)
Data ko parent document ke andar array/object bana kar daalna.
```json
// Order document:
{
  "_id": ObjectId("64f..."),
  "customerName": "Rishabh",
  "shippingAddress": { "city": "Delhi", "zip": "110001" }, // Embedded!
  "items": [ { "sku": "IPHONE-15", "qty": 1, "price": 79999 } ]
}
```
*Pros:* 1 single disk seek me poora order fetch hota hai (Zero Joins!).  
*Cons:* **16MB Document Size Limit** exceed nahi hona chahiye!

#### Pattern B: Referencing (1-to-Many / 1-to-Squillions)
Separate collections me `_id` references store karna:
```json
// Product review:
{ "_id": ObjectId("..."), "productId": ObjectId("P-101"), "reviewText": "Amazing product!" }
```

---

### 3. Master Comparison Matrix

---

### 4. Interview Ke 3 Sawal Is Topic Se

1. **MongoDB document ki maximum hard limit 16MB kyu rakhi gayi hai?** -> Taaki RAM cache allocation optimize rahe aur single massive document poori network bandwidth ya WiredTiger memory ko starve na kare.
2. **`ObjectId` se timestamp bina kisi extra `createdAt` field ke kaise extract karte hain?** -> `objectId.getTimestamp()` method use karke kyunki pehle 4 bytes Unix timestamp hold karte hain.
3. **Outlier Pattern MongoDB me kab use hota hai?** -> Jab 99% users ke paas 50 followers hon (Embedded array) par 1% celebrities ke 10 Million followers hon (Referenced collection).

---
**Next Topic:** 03. High-Performance CRUD Operations, BulkWrite & Write Concerns

Loading lesson content...

Python 3.12

Full IDE

Live Execution Terminal

Click "Execute Live" to run code.
                

Lesson Mastery AI Quiz

AI Doubt Solver

CERTIFICATE OF COMPLETION

Rishabh Gehlot

PHP 8+ & Laravel 11 Master Track