Why query patterns matter in MongoDB - See It in Action

Why Query Patterns Matter in MongoDB

📖 Scenario: You are managing a small online bookstore database using MongoDB. You want to understand how different query patterns affect the speed and efficiency of finding books.

🎯 Goal: Build a simple MongoDB collection with book data, add an index, and write queries to see how query patterns impact performance.

📋 What You'll Learn

Create a MongoDB collection called books with specific book documents

Add an index on the author field

Write a query to find books by a specific author

Write a query to find books by a specific author and genre

💡 Why This Matters

🌍 Real World

Online bookstores and many apps use databases like MongoDB to store and find data quickly. Understanding query patterns helps keep the app fast.

💼 Career

Database developers and backend engineers must write efficient queries and create indexes to optimize data retrieval in real projects.

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", genre: "Classic" }, { title: "1984", author: "George Orwell", genre: "Dystopian" }, { title: "To Kill a Mockingbird", author: "Harper Lee", genre: "Classic" }

MongoDB

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

Need a hint?

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

2

Add an index on the author field

Create an index on the author field in the books collection using db.books.createIndex.

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", genre: "Classic" },
  { title: "1984", author: "George Orwell", genre: "Dystopian" },
  { title: "To Kill a Mockingbird", author: "Harper Lee", genre: "Classic" }
])
// Create an index on the author field
// Your code here

Need a hint?

Use db.books.createIndex({ author: 1 }) to create an ascending index on the author field.

3

Write a query to find books by author

Write a query using db.books.find to find all books where the author is exactly "George Orwell".

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", genre: "Classic" },
  { title: "1984", author: "George Orwell", genre: "Dystopian" },
  { title: "To Kill a Mockingbird", author: "Harper Lee", genre: "Classic" }
])
db.books.createIndex({ author: 1 })
// Find books by author "George Orwell"
// Your code here

Need a hint?

Use db.books.find({ author: "George Orwell" }) to get books by that author.

4

Write a query to find books by author and genre

Write a query using db.books.find to find all books where the author is "Harper Lee" and the genre is "Classic".

MongoDB

db.books.insertMany([
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald", genre: "Classic" },
  { title: "1984", author: "George Orwell", genre: "Dystopian" },
  { title: "To Kill a Mockingbird", author: "Harper Lee", genre: "Classic" }
])
db.books.createIndex({ author: 1 })
db.books.find({ author: "George Orwell" })
// Find books by author "Harper Lee" and genre "Classic"
// Your code here

Need a hint?

Use db.books.find({ author: "Harper Lee", genre: "Classic" }) to filter by both fields.