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.

Practice

1. Which BSON data type is used to store a unique identifier for documents in MongoDB?

easy

A. Date

B. String

C. ObjectId

D. Boolean

Solution

1. Step 1: Understand the purpose of ObjectId

   ObjectId is a special BSON type designed to uniquely identify documents in MongoDB collections.

2. Step 2: Compare with other types

   String stores text, Boolean stores true/false, Date stores time values. None of these uniquely identify documents like ObjectId.

3. Final Answer:

   ObjectId -> Option C

4. Quick Check:

   BSON unique ID = ObjectId [OK]

Hint: Unique document IDs in MongoDB are ObjectIds [OK]

Common Mistakes:

• Confusing String with ObjectId for unique IDs
• Thinking Boolean can identify documents
• Assuming Date stores unique identifiers

2. Which of the following is the correct BSON data type to store a true or false value in MongoDB?

easy

A. Integer

B. Boolean

C. String

D. Array

Solution

1. Step 1: Identify the BSON type for true/false

   Boolean is the BSON data type used to store true or false values.

2. Step 2: Eliminate other types

   Integer stores numbers, String stores text, Array stores lists. None represent true/false directly.

3. Final Answer:

   Boolean -> Option B

4. Quick Check:

   True/false = Boolean [OK]

Hint: True or false values use Boolean type [OK]

Common Mistakes:

• Using Integer for true/false
• Confusing String with Boolean
• Choosing Array for single true/false

3. Given the following MongoDB document:
{ "name": "Alice", "age": 30, "member": true }
What BSON data types are used for the fields name, age, and member respectively?

medium

A. String, Boolean, Integer

B. String, String, Boolean

C. ObjectId, Integer, Boolean

D. String, Integer, Boolean

Solution

1. Step 1: Identify each field's value type

   "name" is text, so String; "age" is a number, so Integer; "member" is true/false, so Boolean.

2. Step 2: Match with options

   String, Integer, Boolean matches String, Integer, Boolean in order. Others mismatch types.

3. Final Answer:

   String, Integer, Boolean -> Option D

4. Quick Check:

   Text, number, true/false = String, Integer, Boolean [OK]

Hint: Match field values to String, Integer, Boolean types [OK]

Common Mistakes:

• Confusing Integer with String for numbers
• Mixing Boolean and Integer types
• Assuming ObjectId for name field

4. You try to insert this document into MongoDB:
{ "date": "2023-01-01" }
But you want the date field to be stored as a BSON Date type. What is the issue and how to fix it?

medium

A. The date is a string; convert it to BSON Date using ISODate()

B. The date is missing; add a date field

C. The date format is invalid; use YYYY/DD/MM instead

D. MongoDB does not support Date type; use String instead

Solution

1. Step 1: Identify the current data type of date field

   The date is stored as a string because it is enclosed in quotes.

2. Step 2: Convert string to BSON Date type

   Use MongoDB's ISODate() function to store the date as BSON Date type.

3. Final Answer:

   The date is a string; convert it to BSON Date using ISODate() -> Option A

4. Quick Check:

   Date string needs ISODate() for BSON Date [OK]

Hint: Use ISODate() to store dates, not strings [OK]

Common Mistakes:

• Assuming string is automatically Date
• Changing date format incorrectly
• Believing MongoDB lacks Date type

5. You want to store a list of tags for a blog post in MongoDB. Which BSON data type should you use to store multiple tag strings together?

hard

A. Array

B. ObjectId

C. Boolean

D. Date

Solution

1. Step 1: Understand the need to store multiple values

   A list of tags means multiple values grouped together.

2. Step 2: Identify BSON type for multiple values

   Array is the BSON type used to store lists or collections of values.

3. Final Answer:

   Array -> Option A

4. Quick Check:

   Multiple values = Array type [OK]

Hint: Use Array type for lists of values [OK]

Common Mistakes:

• Using ObjectId for lists
• Choosing Boolean for multiple tags
• Trying to store list as Date