Tables or Documents

Tables or Documents: Tables and Documents: Two Ways to Store a Recipe, The NoSQL Families in Plain Words, Where Documents Fit, and Where They Don't.

Updated

  1. Tables and Documents: Two Ways to Store a Recipe (Novice): A recipe card with lists of ingredients and steps breaks a single spreadsheet table; a relational database splits it into tables joined back together, and a document database keeps the whole card in one document.
  2. The NoSQL Families in Plain Words (Novice): NoSQL means "not only SQL", the databases that don't keep their data in relational tables; its four families store key-value pairs, documents, wide rows of columns or a graph of connections, and MongoDB is a document database.
  3. Where Documents Fit, and Where They Don't (Apprentice): Documents fit data that is read together, holds lists and changes shape over time; a relational database is often the better choice when many records must change together, when the same data is combined in many ways, or when a strict shape is the point.