BSON data types overview in MongoDB - Step-by-Step Execution

Concept Flow - BSON data types overview

Start: Insert Data

↓

Determine Data Type

↓

Map to BSON Type

↓

Store in BSON Format

↓

Retrieve Data

↓

Interpret BSON Type

↓

Return Original Data Type

Data is inserted, MongoDB determines its type, stores it in BSON format, and later retrieves it by interpreting the BSON type back to the original data.

Execution Sample

MongoDB

db.collection.insertOne({name: "Alice", age: 30, active: true, joined: new Date()})

Insert a document with different data types: string, integer, boolean, and date.

Execution Table

Step	Field	Input Value	Detected BSON Type	Stored BSON Representation
1	name	"Alice"	String	UTF-8 String
2	age	30	Int32	32-bit Integer
3	active	true	Boolean	Boolean True
4	joined	new Date()	Date	64-bit UTC datetime
5	End	-	-	All fields stored in BSON document

💡 All fields mapped and stored in BSON format for efficient storage and retrieval.

Variable Tracker

Field	Input Value	BSON Type	BSON Stored Form
name	"Alice"	String	UTF-8 String
age	30	Int32	32-bit Integer
active	true	Boolean	Boolean True
joined	new Date()	Date	64-bit UTC datetime

Key Moments - 2 Insights

Why does MongoDB store dates differently than strings?

MongoDB uses a special BSON Date type (64-bit UTC datetime) to store dates, which allows efficient date queries and sorting, unlike strings which are just text (see execution_table rows 1 and 4).

What happens if you insert a number larger than 32-bit integer?

MongoDB will store it as Int64 or Double depending on the number size, not as Int32. This ensures no data loss (not shown in this example but important to know).

Visual Quiz - 3 Questions

Look at the execution table, what BSON type is assigned to the 'active' field?

A String

B Int32

C Boolean

D Date

💡 Hint

Check the 'Detected BSON Type' column for the 'active' field in the execution_table.

At which step does MongoDB store a 64-bit UTC datetime?

A Step 2

B Step 4

C Step 3

D Step 1

💡 Hint

Look at the 'Stored BSON Representation' column for the 'joined' field.

If the 'age' was 3000000000 (larger than 32-bit int), how would the BSON type change?

A It changes to Int64 or Double

B It becomes String

C It stays Int32

D It becomes Boolean

💡 Hint

Recall key moment about number sizes and BSON types.

Concept Snapshot

BSON data types overview:
- MongoDB stores data in BSON format.
- Common types: String, Int32, Boolean, Date.
- Each field is mapped to a BSON type for efficient storage.
- Dates use 64-bit UTC datetime.
- Large numbers use Int64 or Double to avoid data loss.

Full Transcript

When you insert data into MongoDB, it converts each field's value into a BSON data type. For example, strings become BSON strings, integers become Int32 if small enough, booleans become BSON booleans, and dates become BSON date types stored as 64-bit UTC datetimes. This process ensures data is stored efficiently and can be queried properly. If a number is too large for Int32, MongoDB uses Int64 or Double to store it safely. This overview shows how MongoDB handles different data types internally using BSON.