Rows vs documents thinking in MongoDB - Quick Revision & Key Differences

Recall & Review

beginner

What is a 'row' in traditional relational databases?

A row is a single record in a table that holds data for each column. Think of it like a single line in a spreadsheet representing one item or person.

beginner

What is a 'document' in MongoDB?

A document is a data record stored in a flexible, JSON-like format. It can hold nested information and different fields, like a detailed profile card with many sections.

intermediate

How does a document differ from a row in terms of structure?

A row has fixed columns with set data types, while a document can have varying fields and nested data, allowing more flexible and rich information in one place.

intermediate

Why might you choose documents over rows for some applications?

Documents let you store related data together, reducing the need to join tables. This is great for complex or changing data, like user profiles with different preferences.

beginner

Can documents in MongoDB have different fields in the same collection?

Yes! Unlike rows in tables, documents in the same collection can have different fields and structures, giving flexibility to store diverse data together.

In a relational database, what does a row represent?

A A flexible JSON-like object

B A nested data structure

C A collection of documents

D A single record with fixed columns

A row is a single record in a table with fixed columns.

Which of the following best describes a MongoDB document?

A A JSON-like object that can have nested fields

B A fixed set of columns

C A row in a table

D A relational table

MongoDB documents are JSON-like and can contain nested fields.

What is a key advantage of documents over rows?

A Documents require strict schema

B Rows are more flexible than documents

C Documents can store related data together without joins

D Rows can store nested data easily

Documents can store related data together, reducing the need for joins.

Can documents in the same MongoDB collection have different fields?

A No, all documents must have the same fields

B Yes, documents can have different fields

C Only if they are in different databases

D Only if they are in different tables

MongoDB allows documents in the same collection to have different fields.

Which data model is more like a spreadsheet row?

A Row

B JSON object

C Document

D Nested array

A row in a relational database is like a spreadsheet row.

Explain the main differences between rows in relational databases and documents in MongoDB.

Think about structure and flexibility.

Why might a developer choose to use documents instead of rows for storing user profile data?

Consider flexibility and data relationships.