How MongoDB indexes work (B-tree mental model) - Try It Yourself

Understanding MongoDB Indexes with a B-tree Mental Model

📖 Scenario: You are working on a small online bookstore database using MongoDB. You want to speed up searches for books by their title and author. To do this, you will create an index on these fields. This project will help you understand how MongoDB uses B-tree indexes to quickly find data.

🎯 Goal: Build a MongoDB collection with book data, create an index on the title and author fields, and query the collection using the index to find books efficiently.

📋 What You'll Learn

Create a MongoDB collection named books with specific book documents

Create a compound index on the title and author fields

Write a query that uses the index to find books by title and author

Understand the B-tree structure conceptually through the index creation

💡 Why This Matters

🌍 Real World

Indexes in MongoDB help online stores, libraries, and apps quickly find data like books, products, or users without scanning the entire database.

💼 Career

Understanding MongoDB indexes and their B-tree structure is essential for database administrators and developers to optimize query performance and build efficient applications.

1

Create the books collection with sample data

Create a MongoDB collection called books and insert these exact documents: { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 }, { title: "1984", author: "George Orwell", year: 1949 }, and { title: "To Kill a Mockingbird", author: "Harper Lee", year: 1960 }.

MongoDB

// Insert the three book documents into the books collection
// Your code here

Need a hint?

Use db.books.insertMany() with an array of the three book objects.

2

Create a compound index on title and author

Create a compound index on the books collection for the fields title and author in ascending order using db.books.createIndex().

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 },
  { title: "1984", author: "George Orwell", year: 1949 },
  { title: "To Kill a Mockingbird", author: "Harper Lee", year: 1960 }
])
// Create a compound index on title and author
// Your code here

Need a hint?

Use db.books.createIndex({ title: 1, author: 1 }) to create the index.

3

Query the books collection using the index

Write a query to find the book with title "1984" and author "George Orwell" using db.books.find().

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 },
  { title: "1984", author: "George Orwell", year: 1949 },
  { title: "To Kill a Mockingbird", author: "Harper Lee", year: 1960 }
])
db.books.createIndex({ title: 1, author: 1 })
// Query to find the book titled "1984" by "George Orwell"
// Your code here

Need a hint?

Use db.books.find({ title: "1984", author: "George Orwell" }) to query.

4

Explain the B-tree index structure conceptually

Add a comment explaining that MongoDB uses a B-tree structure for the index created on title and author to quickly locate documents by searching through sorted keys.

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", year: 1925 },
  { title: "1984", author: "George Orwell", year: 1949 },
  { title: "To Kill a Mockingbird", author: "Harper Lee", year: 1960 }
])
db.books.createIndex({ title: 1, author: 1 })
db.books.find({ title: "1984", author: "George Orwell" })
// Add a comment explaining the B-tree index concept
// Your code here

Need a hint?

Write a comment starting with // MongoDB uses a B-tree index structure explaining the index helps fast searching.