BSON data types overview in MongoDB - Mini Project: Build & Apply

BSON Data Types Overview

📖 Scenario: You are working with a MongoDB database for a small online bookstore. You want to organize the book information using different BSON data types to store various kinds of data correctly.

🎯 Goal: Build a MongoDB document that uses different BSON data types to represent book details such as title, price, availability, publication date, and tags.

📋 What You'll Learn

Create a document with fields using these BSON data types: String, Double, Boolean, Date, Array, ObjectId

Use exact field names: _id, title, price, inStock, publishedDate, tags

Assign the specified values exactly as described in each step

💡 Why This Matters

🌍 Real World

Using correct BSON data types in MongoDB documents helps store and retrieve data efficiently in real-world applications like online stores, blogs, and social networks.

💼 Career

Understanding BSON types is essential for database developers and administrators working with MongoDB to design schemas and optimize queries.

1

Create the basic book document with _id and title

Create a MongoDB document called book with the field _id set to ObjectId("507f1f77bcf86cd799439011") and the field title set to the string "Learn MongoDB".

MongoDB

# Create the book document with _id and title
# Your code here

Hint

Use ObjectId() to set the _id field and a string for the title.

2

Add price as a Double and inStock as a Boolean

Add the field price with the value 29.99 as a Double and the field inStock with the value true as a Boolean to the book document.

MongoDB

book = {
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "title": "Learn MongoDB"
}
# Add price and inStock fields below
# Your code here

Hint

Use a number with decimals for price and true for inStock.

3

Add publishedDate as a Date

Add the field publishedDate with the value ISODate("2023-01-15T00:00:00Z") to the book document.

MongoDB

book = {
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "title": "Learn MongoDB",
    "price": 29.99,
    "inStock": true
}
# Add publishedDate field below
# Your code here

Hint

Use ISODate() to set the date in ISO format.

4

Add tags as an Array of Strings

Add the field tags with the array value ["database", "mongodb", "nosql"] to the book document.

MongoDB

book = {
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "title": "Learn MongoDB",
    "price": 29.99,
    "inStock": true,
    "publishedDate": ISODate("2023-01-15T00:00:00Z")
}
# Add tags array below
# Your code here

Hint

Use square brackets [] to create an array of strings.

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