Document based stores – Database Management System (DBMS)

A Document Store is a type of NoSQL database that stores data in documents, usually in JSON, BSON, or XML format.

Each document represents a record.
Documents are self-contained, meaning they contain both the data and its structure.
Ideal for applications that deal with semi-structured or hierarchical data.

🧱 Structure Example (JSON Format):

{
  "_id": "user123",
  "name": "Swastika Kumari",
  "age": 21,
  "email": "swastika@example.com",
  "orders": [
    { "id": 101, "item": "Book", "price": 250 },
    { "id": 102, "item": "Bag", "price": 900 }
  ]
}

✅ No need for foreign keys or table joins — all relevant data can be embedded in one document.

📚 Popular Document Databases

Database	Key Features
MongoDB	Most popular, JSON/BSON-based, powerful query language
CouchDB	Uses JSON and HTTP for access; supports revision control
Firestore	Google’s NoSQL document store, great for real-time apps
RavenDB	ACID-compliant document DB with indexing and full-text search
Amazon DocumentDB	Managed MongoDB-compatible service

✅ Key Features

Feature	Description
📄 Schema-less	Each document can have a different structure
🧩 Embedded Data	No need for joins; related data stored together
🔄 Flexible Structure	Easy to change fields and types as app evolves
🧠 Rich Queries	Can query deeply nested fields using expressive syntax
🚀 High Performance	Optimized for reading and writing entire documents

🔍 Use Cases

Scenario	Reason
🛍️ E-commerce platforms	Products with varying attributes
📰 CMS / Blogging platforms	Posts, authors, tags, etc. in nested format
📱 Mobile/web apps	JSON-based APIs fit naturally
🎮 Game development	Player profiles, inventories, achievements
📊 IoT data	Semi-structured sensor data

📊 Advantages

Advantage	Description
📦 Natural data format	JSON aligns well with modern app development
📈 Horizontal scaling	Can shard data across servers
🧱 Denormalized structure	Faster read performance (no joins)
🚀 Rapid development	Easily evolve data without altering schemas
🔄 Nested data support	Allows complex, hierarchical structures

❌ Limitations

Limitation	Description
❌ Data redundancy	Duplicated data if not normalized
❌ Large document size	Can be inefficient if documents grow too big
❌ Limited joins	Some DBs don’t support joins or only allow simple ones
❌ Schema enforcement	Left to the application, not the DB

🆚 Relational vs Document Store (Quick Comparison)

Feature	RDBMS	Document Store
Schema	Fixed	Flexible / schema-less
Relationships	Foreign keys, joins	Embedded or referenced
Read performance	Joins needed	Single document read
Storage unit	Row	Document
Scaling	Vertical	Horizontal (sharding)

💡 Summary

Feature	Document Store
Format	JSON / BSON / XML
Schema	Schema-less or flexible
Ideal For	Nested, semi-structured data
Querying	Rich queries with deep nesting
Popular DBs	MongoDB, CouchDB, Firestore
Best Use Cases	CMS, e-commerce, APIs, IoT

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document Stores — Try It Yourself</title>
<style>
.infographic-docstore {
  --ink:        #1a1a1a;
  --ink-soft:   #5c5c5c;
  --paper:      #ffffff;
  --paper-alt:  #f0ece4;
  --accent:     #2563eb;
  --accent-soft:#e3ebfd;
  --line:       #ddd6c9;
  --good:       #16a34a;
  --good-soft:  #dcfce7;
  --on-accent:  #ffffff;
  --display-font: Georgia, 'Iowan Old Style', serif;
  --body-font: -apple-system, BlinkMacSystemFont, 'Segoe UI', sans-serif;
  --mono-font: 'SF Mono', Consolas, monospace;

  background: var(--paper);
  color: var(--ink);
  font-family: var(--body-font);
  max-width: 960px;
  margin: 0 auto;
  box-sizing: border-box;
  overflow-x: hidden;
}
.infographic-docstore[data-theme="dark"] {
  --ink:        #e8e6e1;
  --ink-soft:   #9a968c;
  --paper:      #121212;
  --paper-alt:  #1e1e26;
  --accent:     #5b8def;
  --accent-soft:#202942;
  --line:       #2c313d;
  --good:       #4ade80;
  --good-soft:  #123420;
  --on-accent:  #101418;
}
.infographic-docstore * { box-sizing: border-box; }

.dc-head { text-align: center; margin-bottom: 0.25rem; }
.dc-head h2 {
  font-family: var(--display-font);
  font-size: 1.95rem;
  margin: 0 0 0.5rem;
}
.dc-head p {
  color: var(--ink-soft);
  font-size: 1rem;
  margin: 0 auto;
  max-width: 620px;
  line-height: 1.55;
}

.dc-frame {
  background: var(--paper-alt);
  border: 1px solid var(--line);
  border-radius: 10px;
  padding: 1.25rem;
  margin-top: 1.75rem;
}
.dc-frame-title { font-family: var(--display-font); font-size: 1.02rem; margin: 0 0 0.75rem; }

.dc-query-line {
  font-family: var(--mono-font);
  font-size: 0.9rem;
  text-align: center;
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 8px;
  padding: 0.65rem 1rem;
  margin-bottom: 1.1rem;
}

.dc-race { display: grid; grid-template-columns: 1fr 1fr; gap: 1.25rem; min-width: 0; }
@media (max-width: 680px) { .dc-race { grid-template-columns: 1fr; } }
.dc-race-col { min-width: 0; }
.dc-race-title { font-size: 0.8rem; text-transform: uppercase; letter-spacing: 0.05em; color: var(--ink-soft); margin: 0 0 0.6rem; text-align: center; }

/* RDBMS side */
.dc-table-scroll { overflow-x: auto; -webkit-overflow-scrolling: touch; min-width: 0; margin-bottom: 0.6rem; }
table.dc-table {
  width: 100%;
  min-width: 220px;
  border-collapse: collapse;
  background: var(--paper);
  border-radius: 7px;
  font-size: 0.78rem;
}
table.dc-table th, table.dc-table td {
  border: 1px solid var(--line);
  padding: 0.35rem 0.5rem;
  text-align: left;
  white-space: nowrap;
  transition: background 0.25s;
}
table.dc-table th { background: var(--accent); color: var(--on-accent); font-weight: 700; font-size: 0.68rem; }
table.dc-table tr.is-checking td { background: var(--accent-soft); }
table.dc-table tr.is-match td { background: var(--good-soft); }
table.dc-table tr.is-skip td { opacity: 0.4; }
.dc-table-label { font-size: 0.72rem; color: var(--ink-soft); margin: 0 0 0.3rem; }

/* Document side */
.dc-doc-card {
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 8px;
  padding: 0.85rem 1rem;
  font-family: var(--mono-font);
  font-size: 0.76rem;
  line-height: 1.6;
  transition: background 0.25s, border-color 0.25s;
}
.dc-doc-card.is-active { background: var(--good-soft); border-color: var(--good); }
.dc-doc-card .k { color: var(--accent); }
.dc-doc-card .arr { color: var(--ink-soft); }

.dc-run-btn {
  display: block;
  margin: 1.25rem auto 0;
  font: inherit;
  font-size: 0.88rem;
  background: var(--accent);
  color: var(--on-accent);
  border: none;
  border-radius: 7px;
  padding: 0.6rem 1.3rem;
  cursor: pointer;
}
.dc-run-btn:hover { opacity: 0.9; }
.dc-run-btn:disabled { opacity: 0.4; cursor: not-allowed; }

.dc-log-scroll { overflow-x: auto; margin-top: 1.1rem; }
.dc-log {
  background: var(--ink);
  color: #d4e2ff;
  border-radius: 8px;
  padding: 0.75rem 0.9rem;
  font-family: var(--mono-font);
  font-size: 0.78rem;
  line-height: 1.65;
  min-height: 2rem;
}
.infographic-docstore[data-theme="dark"] .dc-log { background: #05070a; }
.dc-log-line { opacity: 0; animation: dc-line-in 0.25s ease forwards; }
@keyframes dc-line-in { to { opacity: 1; } }
.dc-log-placeholder { color: #7c8aa8; font-style: italic; }

.dc-scoreboard { display: flex; gap: 1rem; justify-content: center; margin-top: 1.25rem; flex-wrap: wrap; }
.dc-score { background: var(--paper); border: 1px solid var(--line); border-radius: 8px; padding: 0.6rem 1.1rem; text-align: center; min-width: 170px; }
.dc-score.is-winner { border-color: var(--good); }
.dc-score-label { font-size: 0.72rem; color: var(--ink-soft); text-transform: uppercase; letter-spacing: 0.04em; }
.dc-score-value { font-family: var(--mono-font); font-size: 1.05rem; margin-top: 0.15rem; color: var(--accent); }
.dc-score.is-winner .dc-score-value { color: var(--good); }

.dc-reset-btn {
  display: block;
  margin: 1rem auto 0;
  font: inherit;
  font-size: 0.8rem;
  background: var(--paper);
  border: 1px solid var(--line);
  border-radius: 7px;
  padding: 0.4rem 0.9rem;
  cursor: pointer;
  color: var(--ink);
}
.dc-reset-btn:hover { border-color: var(--accent); }

@media (prefers-reduced-motion: reduce) {
  .infographic-docstore *, .infographic-docstore *::before, .infographic-docstore *::after {
    transition-duration: 0.001ms !important;
    animation-duration: 0.001ms !important;
  }
}
</style>
</head>
<body>

<div class="infographic-docstore" id="docstore">

  <div class="dc-head">
    <h2>Document Stores — Try It Yourself</h2>
    <p>Same request — get a user with their orders — run against a normalized RDBMS layout and a single embedded document.</p>
  </div>

  <div class="dc-frame">
    <p class="dc-query-line" id="dcQuery">Get user123 with their orders</p>

    <div class="dc-race">
      <div class="dc-race-col">
        <p class="dc-race-title">RDBMS (normalized)</p>
        <p class="dc-table-label">Users</p>
        <div class="dc-table-scroll">
          <table class="dc-table" id="dcUsersTable">
            <thead><tr><th>UserID</th><th>Name</th></tr></thead>
            <tbody>
              <tr data-user="user123"><td>user123</td><td>Swastika Kumari</td></tr>
              <tr data-user="user124"><td>user124</td><td>Rahul Verma</td></tr>
            </tbody>
          </table>
        </div>
        <p class="dc-table-label">Orders</p>
        <div class="dc-table-scroll">
          <table class="dc-table" id="dcOrdersTable">
            <thead><tr><th>OrderID</th><th>UserID (FK)</th><th>Item</th><th>Price</th></tr></thead>
            <tbody>
              <tr data-order="101" data-user="user123"><td>101</td><td>user123</td><td>Book</td><td>250</td></tr>
              <tr data-order="102" data-user="user123"><td>102</td><td>user123</td><td>Bag</td><td>900</td></tr>
              <tr data-order="103" data-user="user124"><td>103</td><td>user124</td><td>Pen</td><td>50</td></tr>
            </tbody>
          </table>
        </div>
      </div>

      <div class="dc-race-col">
        <p class="dc-race-title">Document Store</p>
        <div class="dc-doc-card" id="dcDocCard">{<br>
&nbsp;&nbsp;<span class="k">"_id"</span>: "user123",<br>
&nbsp;&nbsp;<span class="k">"name"</span>: "Swastika Kumari",<br>
&nbsp;&nbsp;<span class="k">"age"</span>: 21,<br>
&nbsp;&nbsp;<span class="k">"email"</span>: "swastika@example.com",<br>
&nbsp;&nbsp;<span class="k">"orders"</span>: [<br>
&nbsp;&nbsp;&nbsp;&nbsp;{ "id": 101, "item": "Book", "price": 250 },<br>
&nbsp;&nbsp;&nbsp;&nbsp;{ "id": 102, "item": "Bag", "price": 900 }<br>
&nbsp;&nbsp;]<br>
}</div>
      </div>
    </div>

    <button class="dc-run-btn" id="dcRunBtn" type="button">▶ Run the query</button>

    <div class="dc-log-scroll">
      <div class="dc-log" id="dcLog"><span class="dc-log-placeholder">Click "Run the query" to see both approaches in action...</span></div>
    </div>

    <div class="dc-scoreboard">
      <div class="dc-score" id="dcScoreRdbms"><div class="dc-score-label">RDBMS</div><div class="dc-score-value">–</div></div>
      <div class="dc-score" id="dcScoreDoc"><div class="dc-score-label">Document Store</div><div class="dc-score-value">–</div></div>
    </div>

    <button class="dc-reset-btn" id="dcReset" type="button">Reset</button>
  </div>

</div>

<script>
(function () {
  const wrapper = document.getElementById('docstore');
  const bodyAttr = document.body.getAttribute('data-darkmode');
  let dark;
  if (bodyAttr === 'true') {
    dark = true;
  } else if (bodyAttr === 'false') {
    dark = false;
  } else {
    const match = document.cookie.match(/(?:^|;\s*)darkMode=([^;]+)/);
    dark = match ? match[1] === 'true' : false;
  }
  if (dark) wrapper.setAttribute('data-theme', 'dark');
})();

(function () {
  const usersTable = document.getElementById('dcUsersTable');
  const ordersTable = document.getElementById('dcOrdersTable');
  const docCard = document.getElementById('dcDocCard');
  const log = document.getElementById('dcLog');
  const runBtn = document.getElementById('dcRunBtn');
  const scoreRdbms = document.querySelector('#dcScoreRdbms .dc-score-value');
  const scoreDoc = document.querySelector('#dcScoreDoc .dc-score-value');
  const scoreRdbmsCard = document.getElementById('dcScoreRdbms');
  const scoreDocCard = document.getElementById('dcScoreDoc');

  function clearLog() { log.innerHTML = ''; }
  function appendLog(text) {
    if (log.querySelector('.dc-log-placeholder')) log.innerHTML = '';
    const line = document.createElement('div');
    line.className = 'dc-log-line';
    line.textContent = text;
    log.appendChild(line);
  }

  function clearHighlights() {
    usersTable.querySelectorAll('tr').forEach(tr => tr.classList.remove('is-checking', 'is-match', 'is-skip'));
    ordersTable.querySelectorAll('tr').forEach(tr => tr.classList.remove('is-checking', 'is-match', 'is-skip'));
    docCard.classList.remove('is-active');
  }

  runBtn.addEventListener('click', () => {
    clearHighlights();
    clearLog();
    runBtn.disabled = true;

    appendLog('— RDBMS —');
    const userRow = usersTable.querySelector('tr[data-user="user123"]');
    userRow.classList.add('is-checking');
    appendLog('1. Look up Users row: user123 (Swastika Kumari)');

    setTimeout(() => {
      userRow.classList.remove('is-checking');
      userRow.classList.add('is-match');
      const orderRows = Array.from(ordersTable.querySelectorAll('tbody tr'));
      let i = 0;
      let matched = 0;

      function scanOrders() {
        if (i >= orderRows.length) {
          appendLog('3. JOIN Users + matched Orders rows → combine into one result.');
          scoreRdbms.textContent = '1 row + ' + orderRows.length + ' rows scanned + JOIN';
          appendLog('— Document Store —');
          docCard.classList.add('is-active');
          appendLog('1. Look up document _id: "user123" — orders already embedded inside it.');
          scoreDoc.textContent = '1 document read';
          scoreDocCard.classList.add('is-winner');
          scoreRdbmsCard.classList.remove('is-winner');
          runBtn.disabled = false;
          return;
        }
        const row = orderRows[i];
        row.classList.add('is-checking');
        const isMatch = row.dataset.user === 'user123';
        appendLog('2. Scan Orders row ' + row.dataset.order + ': UserID = ' + row.dataset.user + (isMatch ? '  ✓ matches' : '  ✕ skip'));
        setTimeout(() => {
          row.classList.remove('is-checking');
          row.classList.add(isMatch ? 'is-match' : 'is-skip');
          if (isMatch) matched++;
          i++;
          scanOrders();
        }, 380);
      }
      scanOrders();
    }, 400);
  });

  document.getElementById('dcReset').addEventListener('click', () => {
    clearHighlights();
    clearLog();
    log.innerHTML = '<span class="dc-log-placeholder">Click "Run the query" to see both approaches in action...</span>';
    scoreRdbms.textContent = '–';
    scoreDoc.textContent = '–';
    scoreRdbmsCard.classList.remove('is-winner');
    scoreDocCard.classList.remove('is-winner');
    runBtn.disabled = false;
  });
})();
</script>

</body>
</html>

.demo {
  font-family: system-ui, sans-serif;
  padding: 16px;
}

.demo h1 {
  color: #2563eb;
  margin: 0 0 8px;
}

.demo p {
  color: #4b5563;
  margin: 0;
}

document.querySelector('.demo h1')?.addEventListener('click', () => {
  alert('Hello from live preview!');
});