Projection for reducing data transfer in MongoDB - Step-by-Step Execution

Concept Flow - Projection for reducing data transfer

Start Query

↓

Specify Collection

↓

Add Filter (Optional)

↓

Add Projection Fields

↓

Execute Query

↓

Return Only Projected Fields

↓

Reduce Data Transfer

The query starts by selecting a collection, optionally filters documents, then specifies which fields to return, executes the query, and returns only those fields to reduce data transfer.

Execution Sample

MongoDB

db.users.find({}, {name: 1, email: 1, _id: 0})

This query fetches all documents from the 'users' collection but returns only the 'name' and 'email' fields, excluding the '_id' field.

Execution Table

Step	Action	Filter Applied	Projection Applied	Documents Returned
1	Start Query	{}	{} (no projection)	N/A
2	Specify Collection	N/A	N/A	N/A
3	Apply Filter	{}	N/A	All documents in users
4	Apply Projection	{}	{name:1, email:1, _id:0}	Only name and email fields
5	Return Result	{}	{name:1, email:1, _id:0}	[{name:'Alice', email:'[e-mail]'}, {name:'Bob', email:'[e-mail]'}, ...]
6	End	N/A	N/A	Data transfer reduced by excluding other fields

💡 Query ends after returning only the specified fields, reducing data transfer.

Variable Tracker

Variable	Start	After Step 3	After Step 4	Final
Filter	{}	{}	{}	{}
Projection	N/A	N/A	{name:1, email:1, _id:0}	{name:1, email:1, _id:0}
Documents Returned	N/A	All documents	Documents with only name and email	Documents with only name and email

Key Moments - 2 Insights

Why do we set _id to 0 in the projection?

By default, MongoDB includes the _id field. Setting _id:0 excludes it, so only the specified fields are returned, reducing data size as shown in execution_table row 4.

What happens if we don't specify any projection?

If no projection is specified, all fields of the documents are returned, which can increase data transfer. This is shown in execution_table row 3 where all documents are returned without field filtering.

Visual Quiz - 3 Questions

Look at the execution_table at step 4, what fields are included in the returned documents?

A All fields including _id

B Only name and email fields

C Only _id field

D No fields are returned

💡 Hint

Check the 'Projection Applied' column at step 4 in the execution_table.

At which step does the query exclude the _id field from the results?

A Step 2

B Step 3

C Step 4

D Step 5

💡 Hint

Look at the 'Projection Applied' column in the execution_table where _id is set to 0.

If we remove the projection from the query, how would the 'Documents Returned' change at step 5?

A All fields including _id would be returned

B Only name and email fields would be returned

C No documents would be returned

D Only _id field would be returned

💡 Hint

Refer to execution_table row 3 where no projection is applied and all fields are returned.

Concept Snapshot

MongoDB Projection:
Use projection to specify which fields to return.
Syntax: find(filter, {field1:1, field2:1, _id:0})
Setting _id:0 excludes the default _id field.
Reduces data transfer by sending only needed fields.

Full Transcript

This visual execution shows how MongoDB projection works to reduce data transfer. The query starts by selecting the collection and optionally filtering documents. Then, it applies a projection to specify which fields to include or exclude. By setting fields to 1, those fields are included; setting _id to 0 excludes the default _id field. The result is that only the specified fields are returned, reducing the amount of data sent over the network. The execution table traces each step, showing how the filter and projection are applied and how the documents returned change accordingly. Key moments clarify why _id is excluded and what happens if no projection is used. The quiz tests understanding of these steps and their effects on the returned data.