{"id":771,"date":"2026-02-23T22:09:22","date_gmt":"2026-02-23T14:09:22","guid":{"rendered":"https:\/\/blog.itsmygo.uk\/2026\/02\/23\/%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88-20-%e6%a6%82%e5%bf%b5%e3%80%9104-%e8%b3%87%e6%96%99%e5%ba%ab%e6%a0%b8%e5%bf%83-sql%e3%80%81acid%e3%80%81nosql\/"},"modified":"2026-02-23T22:09:22","modified_gmt":"2026-02-23T14:09:22","slug":"%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88-20-%e6%a6%82%e5%bf%b5%e3%80%9104-%e8%b3%87%e6%96%99%e5%ba%ab%e6%a0%b8%e5%bf%83-sql%e3%80%81acid%e3%80%81nosql","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/02\/23\/%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88-20-%e6%a6%82%e5%bf%b5%e3%80%9104-%e8%b3%87%e6%96%99%e5%ba%ab%e6%a0%b8%e5%bf%83-sql%e3%80%81acid%e3%80%81nosql\/","title":{"rendered":"\u3010\u7cfb\u7d71\u8a2d\u8a08 20 \u6982\u5ff5\u3011#04 \u8cc7\u6599\u5eab\u6838\u5fc3 \u2014 SQL\u3001ACID\u3001NoSQL"},"content":{"rendered":"\n<div id=\"quiz-2642fba1\">\n<style>\n#quiz-2642fba1 .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-2642fba1 .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-2642fba1 .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-2642fba1 .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-2642fba1 .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-2642fba1 .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-2642fba1 .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-2642fba1 .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-2642fba1 .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-2642fba1 .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-2642fba1 .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-2642fba1 .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-2642fba1 .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-2642fba1 .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1a\u8cc7\u6599\u5eab\u6838\u5fc3 \u2014 SQL\u3001ACID\u3001NoSQL<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. SQL \u8cc7\u6599\u5eab\u4e2d\u7684 Schema\uff08\u7d50\u69cb\u63cf\u8ff0\uff09\u6307\u7684\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u8cc7\u6599\u5eab\u88e1\u6bcf\u4e00\u7b46\u8cc7\u6599\u7684\u552f\u4e00\u7de8\u865f<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u5b9a\u7fa9\u6bcf\u500b\u8868\u683c\u6709\u54ea\u4e9b\u6b04\u4f4d\u8207\u8cc7\u6599\u985e\u578b\uff0c\u800c\u4e14\u662f\u56fa\u5b9a\u7684<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u4e00\u7a2e\u7528\u4f86\u52a0\u901f\u67e5\u8a62\u7684\u7d22\u5f15\u6a5f\u5236<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u628a\u591a\u5f35\u8868\u683c\u5408\u5728\u4e00\u8d77\u67e5\u8a62\u7684\u64cd\u4f5c<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. ACID \u4e2d\u7684 Atomicity\uff08\u539f\u5b50\u6027\uff09\u4ee3\u8868\u4ec0\u9ebc\u610f\u601d\uff1f<\/h3>\n      <p>\u60c5\u5883\uff1aAlice \u8981\u8f49 1000 \u5143\u7d66 Bob\uff0c\u9700\u8981\u300cAlice \u5e33\u6236 -1000\u300d\u548c\u300cBob \u5e33\u6236 +1000\u300d\u5169\u6b65\u64cd\u4f5c\u3002<\/p>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u8cc7\u6599\u5eab\u8a2d\u5b9a\u7684\u898f\u5247\u4e0d\u6703\u88ab\u4efb\u4f55\u64cd\u4f5c\u6253\u7834<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u8cc7\u6599\u5beb\u5165\u5f8c\u5373\u4f7f\u65b7\u96fb\u4e5f\u4e0d\u6703\u907a\u5931<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u9019\u5169\u6b65\u64cd\u4f5c\u8981\u561b\u5168\u90e8\u5b8c\u6210\uff0c\u8981\u561b\u5168\u90e8\u4e0d\u7b97\uff0c\u4e0d\u6703\u53ea\u505a\u4e00\u534a<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u540c\u6642\u9032\u884c\u7684\u591a\u7b46\u4ea4\u6613\u4e0d\u6703\u4e92\u76f8\u5e72\u64fe<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u4ee5\u4e0b\u54ea\u500b\u662f NoSQL\u300cKey-Value\u300d\u985e\u578b\u8cc7\u6599\u5eab\u7684\u4ee3\u8868\uff0c\u5e38\u7528\u65bc\u5feb\u53d6\u548c Session \u7ba1\u7406\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'D')\">A. MongoDB<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'D')\">B. Cassandra<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'D')\">C. Neo4j<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'D')\">D. Redis<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u4e0b\u9762\u9019\u6bb5\u4ee3\u78bc\u5229\u7528\u4e86 ACID \u7684\u54ea\u500b\u7279\u6027\uff1f<\/h3>\n      <div class=\"code-block\">with session.begin():\n    alice.balance -= 1000\n    bob.balance += 1000\n# \u96e2\u958b with \u5340\u584a \u2192 \u81ea\u52d5 COMMIT\n# \u5982\u679c\u4e2d\u9593\u51fa\u932f \u2192 \u81ea\u52d5 ROLLBACK<\/div>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'A')\">A. Atomicity\uff08\u539f\u5b50\u6027\uff09\u2014 \u628a\u591a\u500b\u64cd\u4f5c\u5305\u6210\u4e00\u7d44\uff0c\u5168\u505a\u6216\u5168\u4e0d\u505a<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'A')\">B. Consistency\uff08\u4e00\u81f4\u6027\uff09\u2014 \u78ba\u4fdd\u9918\u984d\u4e0d\u70ba\u8ca0\u6578<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'A')\">C. Isolation\uff08\u9694\u96e2\u6027\uff09\u2014 \u78ba\u4fdd\u4ea4\u6613\u4e4b\u9593\u4e92\u4e0d\u5e72\u64fe<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'A')\">D. Durability\uff08\u6301\u4e45\u6027\uff09\u2014 \u78ba\u4fdd\u8cc7\u6599\u5beb\u5165\u5f8c\u4e0d\u6703\u907a\u5931<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5982\u679c\u4f60\u8981\u5efa\u4e00\u500b\u91d1\u878d\u4ea4\u6613\u7cfb\u7d71\uff0c\u9700\u8981\u7cbe\u78ba\u7684\u8cc7\u6599\u4e00\u81f4\u6027\u548c\u8907\u96dc\u7684\u95dc\u806f\u67e5\u8a62\uff0c\u6700\u9069\u5408\u9078\u64c7\u54ea\u7a2e\u8cc7\u6599\u5eab\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'B')\">A. MongoDB \u2014 \u56e0\u70ba Schema \u5f48\u6027\uff0c\u958b\u767c\u5feb\u901f<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'B')\">B. PostgreSQL \u2014 \u56e0\u70ba\u652f\u63f4 ACID \u548c\u5f37\u5927\u7684 JOIN \u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'B')\">C. Redis \u2014 \u56e0\u70ba\u901f\u5ea6\u6975\u5feb\uff0c\u5ef6\u9072\u6700\u4f4e<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'B')\">D. Cassandra \u2014 \u56e0\u70ba\u6c34\u5e73\u64f4\u5c55\u80fd\u529b\u5f37<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"Schema \u662f\u5b9a\u7fa9\u8868\u683c\u6b04\u4f4d\u8207\u8cc7\u6599\u985e\u578b\u7684\u7d50\u69cb\u63cf\u8ff0\uff0c\u5c31\u50cf Excel \u7684\u8868\u982d\uff0c\u800c\u4e14\u662f\u56fa\u5b9a\u7684\u3002\u9078\u9805 A \u63cf\u8ff0\u7684\u662f Primary Key\uff08\u4e3b\u9375\uff09\uff0c\u9078\u9805 C \u63cf\u8ff0\u7684\u662f INDEX\uff0c\u9078\u9805 D \u63cf\u8ff0\u7684\u662f JOIN\u3002\",\n        2: \"\u539f\u5b50\u6027\uff08Atomicity\uff09\u78ba\u4fdd\u4e00\u7d44\u64cd\u4f5c\u300c\u5168\u505a\u6216\u5168\u4e0d\u505a\u300d\u3002\u5982\u679c\u8f49\u5e33\u904e\u7a0b\u4e2d\u65b7\u96fb\uff0c\u5169\u6b65\u64cd\u4f5c\u90fd\u6703\u88ab\u56de\u6efe\uff0c\u4e0d\u6703\u51fa\u73fe Alice \u6263\u4e86\u9322\u4f46 Bob \u6c92\u6536\u5230\u7684\u60c5\u6cc1\u3002\u9078\u9805 A \u662f\u4e00\u81f4\u6027\u3001\u9078\u9805 B \u662f\u6301\u4e45\u6027\u3001\u9078\u9805 D \u662f\u9694\u96e2\u6027\u3002\",\n        3: \"Redis \u662f Key-Value \u985e\u578b NoSQL \u7684\u4ee3\u8868\uff0c\u8cc7\u6599\u5b58\u5728\u8a18\u61b6\u9ad4\u4e2d\u901f\u5ea6\u6975\u5feb\uff0c\u5e38\u7528\u65bc\u5feb\u53d6\u3001Session \u548c\u6392\u884c\u699c\u3002MongoDB \u662f Document \u578b\u3001Cassandra \u662f Column-Family \u578b\u3001Neo4j \u662f Graph \u578b\u3002\",\n        4: \"\u9019\u6bb5\u4ee3\u78bc\u4f7f\u7528 <code>session.begin()<\/code> \u548c <code>with<\/code> \u5340\u584a\u628a\u6263\u6b3e\u8207\u52a0\u6b3e\u5305\u6210\u4e00\u7d44\u4ea4\u6613\uff0c\u9019\u6b63\u662f Atomicity\uff08\u539f\u5b50\u6027\uff09\u7684\u9ad4\u73fe \u2014 \u5168\u90e8\u6210\u529f\u5c31 COMMIT\uff0c\u51fa\u932f\u5c31\u81ea\u52d5 ROLLBACK\u3002\u6587\u7ae0\u660e\u78ba\u6307\u51fa\u9019\u662f\u300c\u628a\u591a\u500b\u64cd\u4f5c\u5305\u6210\u4e00\u7d44\u300d\u7684\u539f\u5b50\u6027\u7528\u6cd5\u3002\",\n        5: \"\u91d1\u878d\u4ea4\u6613\u9700\u8981\u8cc7\u6599\u7d55\u5c0d\u6b63\u78ba\uff08ACID \u4fdd\u8b49\uff09\u4e14\u6709\u8907\u96dc\u7684\u95dc\u806f\u67e5\u8a62\uff08JOIN\uff09\uff0c\u9019\u6b63\u662f SQL \u8cc7\u6599\u5eab\u5982 PostgreSQL \u7684\u5f37\u9805\u3002Redis \u96d6\u5feb\u4f46\u67e5\u8a62\u80fd\u529b\u6709\u9650\u3001MongoDB \u72a7\u7272\u90e8\u5206\u4e00\u81f4\u6027\u3001Cassandra \u64c5\u9577\u5927\u898f\u6a21\u5beb\u5165\u4f46\u4e0d\u64c5\u9577\u8907\u96dc\u67e5\u8a62\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" \ud83c\udf89 \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \ud83d\udc4d \u4e0d\u932f\uff01\"\n                : \" \ud83d\udcda \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u672c\u7bc7\u662f\u300c\u7cfb\u7d71\u8a2d\u8a08 20 \u6982\u5ff5\u300d\u7cfb\u5217\u7b2c 4 \u7bc7\uff0c\u5171 5 \u7bc7\u3002<br>\u524d\u7f6e\u77e5\u8b58\uff1a\u7b2c 3 \u7bc7\u7684\u64f4\u5c55\u6982\u5ff5\uff08\u7406\u89e3\u70ba\u4ec0\u9ebc\u9700\u8981\u4e0d\u540c\u8cc7\u6599\u5eab\uff09<br>\u53c3\u8003\u4f86\u6e90\uff1a20 System Design Concepts Explained in 10 Minutes (NeetCode, YouTube)<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8cc7\u6599\u5eab\u5c31\u662f\u300c\u5b58\u653e\u8cc7\u6599\u7684\u5009\u5eab\u300d\uff0cSQL \u548c NoSQL \u662f\u5169\u7a2e\u4e0d\u540c\u7684\u7ba1\u7406\u98a8\u683c &#8212; \u4e00\u500b\u50cf Excel \u8868\u683c\uff0c\u4e00\u500b\u50cf JSON \u6a94\u6848\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc Vibe Coder \u9700\u8981\u61c2\u8cc7\u6599\u5eab\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f60\u8acb AI \u5e6b\u4f60\u5beb\u5f8c\u7aef\u7a0b\u5f0f\u6642\uff0c\u5b83\u4e00\u5b9a\u6703\u5e6b\u4f60\u6311\u4e00\u500b\u8cc7\u6599\u5eab\u3002\u4f60\u53ef\u80fd\u6703\u770b\u5230\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># AI \u53ef\u80fd\u5beb\u51fa\u9019\u6a23\u7684\u4ee3\u78bc<\/span>\nfrom sqlalchemy import create_engine\nengine = create_engine(<span class=\"hljs-string\">\"postgresql:\/\/localhost\/myapp\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6216\u662f\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u6216\u8005\u9019\u6a23<\/span>\n<span class=\"hljs-keyword\">const<\/span> client = <span class=\"hljs-keyword\">new<\/span> MongoClient(<span class=\"hljs-string\">\"mongodb:\/\/localhost:27017\"<\/span>);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4e00\u500b\u7528 PostgreSQL\uff08SQL \u8cc7\u6599\u5eab\uff09\uff0c\u4e00\u500b\u7528 MongoDB\uff08NoSQL \u8cc7\u6599\u5eab\uff09\u3002\u70ba\u4ec0\u9ebc\u9078\u9019\u500b\u4e0d\u9078\u90a3\u500b\uff1f\u8b80\u5b8c\u672c\u7bc7\u4f60\u5c31\u80fd\u770b\u61c2\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SQL \u8cc7\u6599\u5eab\uff1a\u50cf Excel \u4e00\u6a23\u7684\u8868\u683c<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u6982\u5ff5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\uff08Structured Query Language\uff09\u8cc7\u6599\u5eab\u628a\u8cc7\u6599\u5b58\u5728<strong>\u8868\u683c<\/strong>\u88e1\uff0c\u8ddf Excel \u975e\u5e38\u50cf\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">users \u8868\u683c\uff1a\n+----+--------+-------------------+\n| id | name   | email             |\n+----+--------+-------------------+\n| 1  | Alice  | alice@example.com |\n| 2  | Bob    | bob@example.com   |\n+----+--------+-------------------+\n\norders \u8868\u683c\uff1a\n+----+---------+---------+--------+\n| id | user_id | product | amount |\n+----+---------+---------+--------+\n| 1  | 1       | \u9375\u76e4    | 2500   |\n| 2  | 1       | \u6ed1\u9f20    | 800    |\n| 3  | 2       | \u87a2\u5e55    | 12000  |\n+----+---------+---------+--------+\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u91cd\u9ede\u7ffb\u8b6f<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>Schema\uff08\u7d50\u69cb\u63cf\u8ff0\uff09<\/strong>\uff1a\u5b9a\u7fa9\u6bcf\u500b\u8868\u683c\u6709\u54ea\u4e9b\u6b04\u4f4d\u3001\u4ec0\u9ebc\u985e\u578b\u3002\u50cf Excel \u7684\u8868\u982d\uff0c\u800c\u4e14\u662f\u56fa\u5b9a\u7684 &#8212; \u4f60\u4e0d\u80fd\u7a81\u7136\u5728\u67d0\u4e00\u5217\u591a\u585e\u4e00\u500b\u6b04\u4f4d\u3002<\/li>\n\n\n<li><strong>Row\uff08\u5217\uff09<\/strong>\uff1a\u4e00\u7b46\u8cc7\u6599\u3002<\/li>\n\n\n<li><strong>Column\uff08\u6b04\uff09<\/strong>\uff1a\u4e00\u500b\u6b04\u4f4d\u3002<\/li>\n\n\n<li><strong>Primary Key\uff08\u4e3b\u9375\uff09<\/strong>\uff1a\u6bcf\u7b46\u8cc7\u6599\u7684\u8eab\u5206\u8b49\u865f\u78bc\uff0c\u4e0d\u80fd\u91cd\u8907\u3002\u4e0a\u9762\u7684 <code>id<\/code> \u5c31\u662f\u4e3b\u9375\u3002<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">JOIN\uff1a\u628a\u5169\u5f35\u8868\u683c\u5408\u5728\u4e00\u8d77\u67e5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL \u6700\u5f37\u7684\u80fd\u529b\u5c31\u662f JOIN &#8212; \u628a\u6709\u95dc\u806f\u7684\u8868\u683c\u300c\u63a5\u8d77\u4f86\u300d\u67e5\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u67e5 Alice \u7684\u6240\u6709\u8a02\u55ae\nSELECT users.name, orders.product, orders.amount\nFROM users\nJOIN orders ON users.id = orders.user_id\nWHERE users.name = <span class=\"hljs-string\">'Alice'<\/span>;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\u300c\u5f9e <span class=\"hljs-selector-tag\">users<\/span> \u8868\u683c\u548c <span class=\"hljs-selector-tag\">orders<\/span> \u8868\u683c\u4e2d\uff0c\n \u628a <span class=\"hljs-selector-tag\">users<\/span><span class=\"hljs-selector-class\">.id<\/span> \u548c <span class=\"hljs-selector-tag\">orders<\/span><span class=\"hljs-selector-class\">.user_id<\/span> \u76f8\u540c\u7684\u5217\u5408\u5728\u4e00\u8d77\uff0c\n \u53ea\u62ff <span class=\"hljs-selector-tag\">Alice<\/span> \u7684\u8cc7\u6599\uff0c\n \u986f\u793a\u540d\u5b57\u3001\u5546\u54c1\u3001\u91d1\u984d\u3002\u300d\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u7d50\u679c\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">+-------+---------+--------+\n| name  | product | amount |\n+-------+---------+--------+\n| Alice | \u9375\u76e4    | 2500   |\n| Alice | \u6ed1\u9f20    | 800    |\n+-------+---------+--------+\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u5e38\u898b\u7684 SQL \u8cc7\u6599\u5eab<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u8cc7\u6599\u5eab<\/th>\n<th>\u8ab0\u5728\u7528<\/th>\n<th>\u4e00\u53e5\u8a71\u7279\u8272<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>PostgreSQL<\/strong><\/td>\n<td>Instagram\u3001Supabase<\/td>\n<td>\u529f\u80fd\u6700\u5b8c\u6574\uff0c\u793e\u7fa4\u6d3b\u8e8d<\/td>\n<\/tr>\n<tr>\n<td><strong>MySQL<\/strong><\/td>\n<td>Facebook\u3001Twitter<\/td>\n<td>\u8001\u724c\u7a69\u5b9a\uff0c\u901f\u5ea6\u5feb<\/td>\n<\/tr>\n<tr>\n<td><strong>SQLite<\/strong><\/td>\n<td>\u624b\u6a5f App\u3001\u5c0f\u5c08\u6848<\/td>\n<td>\u4e0d\u9700\u8981\u4f3a\u670d\u5668\uff0c\u4e00\u500b\u6a94\u6848\u641e\u5b9a<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">**Vibe Coder \u63d0\u793a**\uff1a\u5982\u679c\u4f60\u8acb AI \u505a\u4e00\u500b\u300c\u6709\u4f7f\u7528\u8005\u767b\u5165\u3001\u6709\u8a02\u55ae\u3001\u8cc7\u6599\u4e4b\u9593\u6709\u95dc\u806f\u300d\u7684\u61c9\u7528\u7a0b\u5f0f\uff0cAI \u5927\u6982\u7387\u6703\u9078 PostgreSQL \u6216 MySQL\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">ACID\uff1a\u8cc7\u6599\u5eab\u7684\u56db\u5927\u5b89\u5168\u4fdd\u8b49<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">ACID \u662f SQL \u8cc7\u6599\u5eab\u6700\u91cd\u8981\u7684\u7279\u6027\u3002\u6211\u5011\u7528<strong>\u9280\u884c\u8f49\u5e33<\/strong>\u4f86\u7406\u89e3\uff1a<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u60c5\u5883\uff1aAlice \u8981\u8f49 1000 \u5143\u7d66 Bob\u3002<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u500b\u52d5\u4f5c\u9700\u8981\u5169\u6b65\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li>Alice \u5e33\u6236 -1000<\/li>\n\n\n<li>Bob \u5e33\u6236 +1000<\/li>\n\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u505a\u5b8c\u7b2c\u4e00\u6b65\u3001\u9084\u6c92\u505a\u7b2c\u4e8c\u6b65\u5c31\u65b7\u96fb\u4e86\u5462\uff1fAlice \u5c11\u4e86 1000 \u5143\uff0cBob \u537b\u6c92\u6536\u5230\u3002\u9322\u5c31\u9019\u6a23\u6d88\u5931\u4e86\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ACID \u5c31\u662f\u70ba\u4e86\u9632\u6b62\u9019\u7a2e\u4e8b\u60c5\u800c\u5b58\u5728\u7684\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">A &#8211; Atomicity\uff08\u539f\u5b50\u6027\uff09\uff1a\u5168\u505a\u6216\u5168\u4e0d\u505a<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u4ea4\u6613\u958b\u59cb\n  Alice \u5e33\u6236 -1000   \u2190 \u6210\u529f\n  Bob \u5e33\u6236 +1000     \u2190 \u5931\u6557\uff08\u65b7\u96fb\u4e86\uff09\n\u4ea4\u6613\u56de\u6efe \u2192 Alice \u5e33\u6236\u6062\u5fa9\u539f\u72c0\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u9019\u7d44\u64cd\u4f5c\u8981\u561b\u5168\u90e8\u5b8c\u6210\uff0c\u8981\u561b\u5168\u90e8\u4e0d\u7b97\u3002\u4e0d\u6703\u51fa\u73fe\u505a\u4e00\u534a\u7684\u60c5\u6cc1\u3002\u300d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5c31\u50cf\u4f60\u5728\u8d85\u5546\u8cb7\u6771\u897f &#8212; \u4ed8\u9322\u8ddf\u62ff\u5230\u5546\u54c1\u662f\u7d81\u5728\u4e00\u8d77\u7684\uff0c\u4e0d\u6703\u53ea\u4ed8\u4e86\u9322\u537b\u6c92\u62ff\u5230\u6771\u897f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">C &#8211; Consistency\uff08\u4e00\u81f4\u6027\uff09\uff1a\u898f\u5247\u6c38\u9060\u4e0d\u88ab\u6253\u7834<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u898f\u5247\uff1a\u5e33\u6236\u9918\u984d\u4e0d\u80fd\u662f\u8ca0\u6578\n\nAlice \u9918\u984d\uff1a500\nAlice \u8981\u8f49 1000 \u7d66 Bob \u2192 \u62d2\u7d55\uff01\u56e0\u70ba 500 - 1000 = -500\uff0c\u9055\u53cd\u898f\u5247\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u8cc7\u6599\u5eab\u8a2d\u5b9a\u7684\u898f\u5247\uff0c\u4efb\u4f55\u64cd\u4f5c\u90fd\u4e0d\u80fd\u6253\u7834\u3002\u300d<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">I &#8211; Isolation\uff08\u9694\u96e2\u6027\uff09\uff1a\u4ea4\u6613\u4e92\u4e0d\u5e72\u64fe<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u540c\u4e00\u6642\u9593\uff1a\n  \u4ea4\u6613 A\uff1aAlice \u8f49 1000 \u7d66 Bob\n  \u4ea4\u6613 B\uff1aAlice \u8f49 500 \u7d66 Charlie\n\n\u5982\u679c\u6c92\u6709\u9694\u96e2\u6027\uff1a\n  Alice \u9918\u984d 3000\n  \u4ea4\u6613 A \u8b80\u5230 3000\uff0c\u6e1b 1000 = 2000\n  \u4ea4\u6613 B \u4e5f\u8b80\u5230 3000\uff0c\u6e1b 500 = 2500\n  \u6700\u5f8c\u9918\u984d 2500\uff08\u61c9\u8a72\u662f 1500\uff01\u4ea4\u6613 A \u7684\u6263\u6b3e\u88ab\u8986\u84cb\u4e86\uff09\n\n\u6709\u9694\u96e2\u6027\uff1a\n  \u4ea4\u6613\u6392\u968a\u57f7\u884c\uff0c\u7d50\u679c\u4e00\u5b9a\u662f 3000 - 1000 - 500 = 1500 \u2713\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u540c\u6642\u9032\u884c\u7684\u591a\u500b\u64cd\u4f5c\uff0c\u7d50\u679c\u8ddf\u4e00\u500b\u4e00\u500b\u6392\u968a\u505a\u662f\u4e00\u6a23\u7684\u3002\u300d<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">D &#8211; Durability\uff08\u6301\u4e45\u6027\uff09\uff1a\u5beb\u5165\u5c31\u4e0d\u6703\u907a\u5931<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u4ea4\u6613\u5b8c\u6210 \u2192 \u8cc7\u6599\u5df2\u5beb\u5165\u786c\u789f\n\u5373\u4f7f\u4e0b\u4e00\u79d2\u4f3a\u670d\u5668\u7206\u70b8 \u2192 \u8cc7\u6599\u9084\u5728\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u8cc7\u6599\u5eab\u8aaa\u300e\u5b58\u597d\u4e86\u300f\uff0c\u5c31\u662f\u771f\u7684\u5b58\u597d\u4e86\uff0c\u65b7\u96fb\u4e5f\u4e0d\u6703\u4e1f\u3002\u300d<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ACID \u901f\u67e5\u8868<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u7279\u6027<\/th>\n<th>\u4e00\u53e5\u8a71<\/th>\n<th>\u9632\u6b62\u4ec0\u9ebc\u554f\u984c<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>A<\/strong>tomicity<\/td>\n<td>\u5168\u505a\u6216\u5168\u4e0d\u505a<\/td>\n<td>\u64cd\u4f5c\u505a\u4e00\u534a\u5c31\u58de\u6389<\/td>\n<\/tr>\n<tr>\n<td><strong>C<\/strong>onsistency<\/td>\n<td>\u898f\u5247\u4e0d\u88ab\u6253\u7834<\/td>\n<td>\u8cc7\u6599\u51fa\u73fe\u4e0d\u5408\u7406\u7684\u72c0\u614b<\/td>\n<\/tr>\n<tr>\n<td><strong>I<\/strong>solation<\/td>\n<td>\u4ea4\u6613\u4e92\u4e0d\u5e72\u64fe<\/td>\n<td>\u540c\u6642\u64cd\u4f5c\u5c0e\u81f4\u6578\u64da\u932f\u4e82<\/td>\n<\/tr>\n<tr>\n<td><strong>D<\/strong>urability<\/td>\n<td>\u5beb\u5165\u5c31\u4e0d\u4e1f<\/td>\n<td>\u65b7\u96fb\u5f8c\u8cc7\u6599\u6d88\u5931<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">**Vibe Coder \u63d0\u793a**\uff1a\u7576\u4f60\u5728\u4ee3\u78bc\u88e1\u770b\u5230 <code>BEGIN TRANSACTION<\/code> \u548c <code>COMMIT<\/code>\uff08\u6216 ORM \u7684 <code>session.begin()<\/code>\uff09\uff0c\u5c31\u662f\u5728\u7528 ACID \u7684\u539f\u5b50\u6027 &#8212; \u628a\u591a\u500b\u64cd\u4f5c\u5305\u6210\u300c\u4e00\u7d44\u300d\u3002<\/p>\n<\/blockquote>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># AI \u53ef\u80fd\u9019\u6a23\u5beb\uff08SQLAlchemy ORM\uff09<\/span>\nwith session.begin():          <span class=\"hljs-comment\"># \u958b\u59cb\u4ea4\u6613<\/span>\n    alice.balance -= <span class=\"hljs-number\">1000<\/span>      <span class=\"hljs-comment\"># Alice \u6263\u9322<\/span>\n    bob.balance += <span class=\"hljs-number\">1000<\/span>        <span class=\"hljs-comment\"># Bob \u52a0\u9322<\/span>\n<span class=\"hljs-comment\"># \u96e2\u958b with \u5340\u584a \u2192 \u81ea\u52d5 COMMIT\uff08\u5168\u90e8\u5b8c\u6210\uff09<\/span>\n<span class=\"hljs-comment\"># \u5982\u679c\u4e2d\u9593\u51fa\u932f \u2192 \u81ea\u52d5 ROLLBACK\uff08\u5168\u90e8\u9084\u539f\uff09<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">NoSQL \u8cc7\u6599\u5eab\uff1a\u4e0d\u7528\u8868\u683c\u7684\u5f48\u6027\u5009\u5eab<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u9700\u8981 NoSQL\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQL \u8cc7\u6599\u5eab\u5f88\u68d2\uff0c\u4f46\u6709\u4e9b\u60c5\u6cc1\u4e0d\u592a\u9069\u5408\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u60c5\u5883<\/th>\n<th>SQL \u7684\u56f0\u96e3<\/th>\n<th>NoSQL \u7684\u512a\u52e2<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u6bcf\u500b\u4f7f\u7528\u8005\u7684\u8cc7\u6599\u6b04\u4f4d\u4e0d\u540c<\/td>\n<td>Schema \u56fa\u5b9a\uff0c\u6539\u8868\u683c\u5f88\u75db\u82e6<\/td>\n<td>Schema \u5f48\u6027\uff0c\u60f3\u52a0\u4ec0\u9ebc\u52a0\u4ec0\u9ebc<\/td>\n<\/tr>\n<tr>\n<td>\u6bcf\u79d2\u767e\u842c\u7b46\u8b80\u5beb<\/td>\n<td>\u5782\u76f4\u64f4\u5c55\u6709\u4e0a\u9650<\/td>\n<td>\u6c34\u5e73\u64f4\u5c55\u5bb9\u6613\uff08\u591a\u52a0\u6a5f\u5668\u5c31\u597d\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u662f\u5de2\u72c0\u7d50\u69cb\uff08JSON\uff09<\/td>\n<td>\u8981\u62c6\u6210\u5f88\u591a\u8868\u683c\u518d JOIN<\/td>\n<td>\u76f4\u63a5\u5b58\u6574\u500b JSON<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">NoSQL \u7684\u6838\u5fc3\u6982\u5ff5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">NoSQL \u7684\u8cc7\u6599\u9577\u9019\u6a23\uff08\u4ee5 Document \u578b\u70ba\u4f8b\uff09\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"JSON \/ JSON with Comments\" data-shcb-language-slug=\"json\"><span><code class=\"hljs language-json\">{\n  <span class=\"hljs-attr\">\"_id\"<\/span>: <span class=\"hljs-string\">\"user_001\"<\/span>,\n  <span class=\"hljs-attr\">\"name\"<\/span>: <span class=\"hljs-string\">\"Alice\"<\/span>,\n  <span class=\"hljs-attr\">\"email\"<\/span>: <span class=\"hljs-string\">\"alice@example.com\"<\/span>,\n  <span class=\"hljs-attr\">\"orders\"<\/span>: &#91;\n    { <span class=\"hljs-attr\">\"product\"<\/span>: <span class=\"hljs-string\">\"\u9375\u76e4\"<\/span>, <span class=\"hljs-attr\">\"amount\"<\/span>: <span class=\"hljs-number\">2500<\/span> },\n    { <span class=\"hljs-attr\">\"product\"<\/span>: <span class=\"hljs-string\">\"\u6ed1\u9f20\"<\/span>, <span class=\"hljs-attr\">\"amount\"<\/span>: <span class=\"hljs-number\">800<\/span> }\n  ],\n  <span class=\"hljs-attr\">\"preferences\"<\/span>: {\n    <span class=\"hljs-attr\">\"theme\"<\/span>: <span class=\"hljs-string\">\"dark\"<\/span>,\n    <span class=\"hljs-attr\">\"language\"<\/span>: <span class=\"hljs-string\">\"zh-TW\"<\/span>\n  }\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JSON \/ JSON with Comments<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">json<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8ddf SQL \u7684\u95dc\u9375\u5dee\u7570<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u4e0d\u9700\u8981\u4e8b\u5148\u5b9a\u7fa9\u6b04\u4f4d\uff08\u6c92\u6709\u56fa\u5b9a Schema\uff09<\/li>\n\n\n<li>\u8cc7\u6599\u53ef\u4ee5\u662f\u5de2\u72c0\u7684\uff08orders \u76f4\u63a5\u653e\u5728 user \u88e1\u9762\uff09<\/li>\n\n\n<li>\u4e0d\u540c\u7b46\u8cc7\u6599\u53ef\u4ee5\u6709\u4e0d\u540c\u7684\u6b04\u4f4d<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u56db\u7a2e NoSQL \u985e\u578b<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. Key-Value\uff08\u9375\u503c\u5c0d\uff09&#8211; \u6700\u7c21\u55ae<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\"<span class=\"hljs-selector-tag\">session_abc123<\/span>\" \u2192 { <span class=\"hljs-attribute\">user_id<\/span>: <span class=\"hljs-number\">1<\/span>, login_time: <span class=\"hljs-string\">\"...\"<\/span> }\n\"<span class=\"hljs-selector-tag\">cache_homepage<\/span>\" \u2192 \"&lt;<span class=\"hljs-selector-tag\">html<\/span>&gt;...\"\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u5c31\u50cf\u4e00\u500b\u8d85\u5927\u7684\u5b57\u5178\/HashMap\u3002\u7d66\u4e00\u500b key\uff0c\u62ff\u5230\u4e00\u500b value\u3002\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4ee3\u8868<\/th>\n<th>\u5e38\u898b\u7528\u9014<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Redis<\/strong><\/td>\n<td>\u5feb\u53d6\u3001Session\u3001\u6392\u884c\u699c<\/td>\n<\/tr>\n<tr>\n<td><strong>Memcached<\/strong><\/td>\n<td>\u7d14\u5feb\u53d6<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u901f\u5ea6\u6975\u5feb\uff08\u8cc7\u6599\u5b58\u5728\u8a18\u61b6\u9ad4\uff09\uff0c\u4f46\u67e5\u8a62\u80fd\u529b\u6709\u9650 &#8212; \u53ea\u80fd\u7528 key \u53bb\u627e\u3002<\/p>\n<\/blockquote>\n\n\n\n<h4 class=\"wp-block-heading\">2. Document\uff08\u6587\u4ef6\u578b\uff09&#8211; \u6700\u5e38\u898b<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"JSON \/ JSON with Comments\" data-shcb-language-slug=\"json\"><span><code class=\"hljs language-json\"><span class=\"hljs-comment\">\/\/ MongoDB \u88e1\u7684\u4e00\u7b46\u8cc7\u6599<\/span>\n{\n  <span class=\"hljs-attr\">\"_id\"<\/span>: ObjectId(<span class=\"hljs-string\">\"...\"<\/span>),\n  <span class=\"hljs-attr\">\"title\"<\/span>: <span class=\"hljs-string\">\"\u7cfb\u7d71\u8a2d\u8a08\u5165\u9580\"<\/span>,\n  <span class=\"hljs-attr\">\"author\"<\/span>: { <span class=\"hljs-attr\">\"name\"<\/span>: <span class=\"hljs-string\">\"Alice\"<\/span>, <span class=\"hljs-attr\">\"bio\"<\/span>: <span class=\"hljs-string\">\"...\"<\/span> },\n  <span class=\"hljs-attr\">\"tags\"<\/span>: &#91;<span class=\"hljs-string\">\"system-design\"<\/span>, <span class=\"hljs-string\">\"backend\"<\/span>],\n  <span class=\"hljs-attr\">\"comments\"<\/span>: &#91;\n    { <span class=\"hljs-attr\">\"user\"<\/span>: <span class=\"hljs-string\">\"Bob\"<\/span>, <span class=\"hljs-attr\">\"text\"<\/span>: <span class=\"hljs-string\">\"\u597d\u6587\uff01\"<\/span> }\n  ]\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JSON \/ JSON with Comments<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">json<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u6bcf\u7b46\u8cc7\u6599\u5c31\u662f\u4e00\u500b JSON \u6587\u4ef6\u3002\u7d50\u69cb\u53ef\u4ee5\u96a8\u4fbf\u6539\uff0c\u67e5\u8a62\u529f\u80fd\u4e5f\u4e0d\u932f\u3002\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4ee3\u8868<\/th>\n<th>\u8ab0\u5728\u7528<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>MongoDB<\/strong><\/td>\n<td>\u5f88\u591a\u65b0\u5275\u516c\u53f8\u7684\u9810\u8a2d\u9078\u64c7<\/td>\n<\/tr>\n<tr>\n<td><strong>DynamoDB<\/strong><\/td>\n<td>AWS \u4e0a\u6700\u5e38\u7528\u7684 NoSQL<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">3. Column-Family\uff08\u6b04\u65cf\u578b\uff09&#8211; \u5927\u6578\u64da\u5c08\u7528<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">Row<\/span> <span class=\"hljs-selector-tag\">Key<\/span>: \"<span class=\"hljs-selector-tag\">user_001<\/span>\"\n  <span class=\"hljs-selector-tag\">Column<\/span> <span class=\"hljs-selector-tag\">Family<\/span> \"<span class=\"hljs-selector-tag\">profile<\/span>\": { <span class=\"hljs-attribute\">name<\/span>: <span class=\"hljs-string\">\"Alice\"<\/span>, email: <span class=\"hljs-string\">\"...\"<\/span> }\n  <span class=\"hljs-selector-tag\">Column<\/span> <span class=\"hljs-selector-tag\">Family<\/span> \"<span class=\"hljs-selector-tag\">activity<\/span>\": { <span class=\"hljs-attribute\">last_login<\/span>: <span class=\"hljs-string\">\"...\"<\/span>, page_views: <span class=\"hljs-number\">50000<\/span> }\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u628a\u76f8\u95dc\u7684\u6b04\u4f4d\u5206\u7d44\u5b58\u653e\uff0c\u64c5\u9577\u8655\u7406\u6d77\u91cf\u8cc7\u6599\u7684\u8b80\u5beb\u3002\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4ee3\u8868<\/th>\n<th>\u8ab0\u5728\u7528<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Cassandra<\/strong><\/td>\n<td>Netflix\u3001Discord\uff08\u8655\u7406\u6bcf\u5929\u6578\u5341\u5104\u7b46\u4e8b\u4ef6\uff09<\/td>\n<\/tr>\n<tr>\n<td><strong>HBase<\/strong><\/td>\n<td>\u5927\u6578\u64da\u5206\u6790<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">4. Graph\uff08\u5716\u578b\uff09&#8211; \u95dc\u4fc2\u7db2\u7d61\u5c08\u7528<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">(<span class=\"hljs-selector-tag\">Alice<\/span>) <span class=\"hljs-selector-tag\">--<\/span><span class=\"hljs-selector-attr\">&#91;\u8ffd\u8e64]<\/span><span class=\"hljs-selector-tag\">--<\/span>&gt; (<span class=\"hljs-selector-tag\">Bob<\/span>)\n(<span class=\"hljs-selector-tag\">Bob<\/span>)   <span class=\"hljs-selector-tag\">--<\/span><span class=\"hljs-selector-attr\">&#91;\u8ffd\u8e64]<\/span><span class=\"hljs-selector-tag\">--<\/span>&gt; (<span class=\"hljs-selector-tag\">Charlie<\/span>)\n(<span class=\"hljs-selector-tag\">Alice<\/span>) <span class=\"hljs-selector-tag\">--<\/span><span class=\"hljs-selector-attr\">&#91;\u8ffd\u8e64]<\/span><span class=\"hljs-selector-tag\">--<\/span>&gt; (<span class=\"hljs-selector-tag\">Charlie<\/span>)\n\n\u67e5\u8a62\uff1a\u300c<span class=\"hljs-selector-tag\">Alice<\/span> \u7684\u670b\u53cb\u7684\u670b\u53cb\u662f\u8ab0\uff1f\u300d\u2192 \u4e00\u6b65\u641e\u5b9a\n\uff08<span class=\"hljs-selector-tag\">SQL<\/span> \u8981\u5beb\u591a\u5c64 <span class=\"hljs-selector-tag\">JOIN<\/span>\uff0c\u5f88\u6162\uff09\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u300c\u5c08\u9580\u8655\u7406\u300e\u8ab0\u8ddf\u8ab0\u6709\u95dc\u4fc2\u300f\u7684\u8cc7\u6599\u3002\u793e\u7fa4\u7db2\u8def\u3001\u63a8\u85a6\u7cfb\u7d71\u6700\u611b\u7528\u3002\u300d<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4ee3\u8868<\/th>\n<th>\u8ab0\u5728\u7528<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Neo4j<\/strong><\/td>\n<td>\u793e\u7fa4\u7db2\u8def\u3001\u77e5\u8b58\u5716\u8b5c<\/td>\n<\/tr>\n<tr>\n<td><strong>Amazon Neptune<\/strong><\/td>\n<td>AWS \u4e0a\u7684\u5716\u8cc7\u6599\u5eab<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SQL vs NoSQL\uff1a\u5b8c\u6574\u5c0d\u6bd4<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6bd4\u8f03\u9805\u76ee<\/th>\n<th>SQL<\/th>\n<th>NoSQL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>\u8cc7\u6599\u7d50\u69cb<\/strong><\/td>\n<td>\u56fa\u5b9a\u8868\u683c\uff08Schema\uff09<\/td>\n<td>\u5f48\u6027\uff08Schema-less\uff09<\/td>\n<\/tr>\n<tr>\n<td><strong>\u95dc\u806f\u67e5\u8a62<\/strong><\/td>\n<td>JOIN \u5f88\u5f37<\/td>\n<td>\u901a\u5e38\u4e0d\u652f\u63f4 JOIN<\/td>\n<\/tr>\n<tr>\n<td><strong>\u64f4\u5c55\u65b9\u5f0f<\/strong><\/td>\n<td>\u5782\u76f4\u64f4\u5c55\uff08\u5347\u7d1a\u55ae\u53f0\u6a5f\u5668\uff09<\/td>\n<td>\u6c34\u5e73\u64f4\u5c55\uff08\u52a0\u66f4\u591a\u6a5f\u5668\uff09<\/td>\n<\/tr>\n<tr>\n<td><strong>\u4e00\u81f4\u6027<\/strong><\/td>\n<td>\u5f37\u4e00\u81f4\u6027\uff08ACID\uff09<\/td>\n<td>\u6700\u7d42\u4e00\u81f4\u6027\uff08\u53ef\u80fd\u6709\u77ed\u66ab\u5ef6\u9072\uff09<\/td>\n<\/tr>\n<tr>\n<td><strong>\u9069\u5408\u5834\u666f<\/strong><\/td>\n<td>\u91d1\u878d\u3001\u96fb\u5546\u3001\u9700\u8981\u7cbe\u78ba\u6578\u64da<\/td>\n<td>\u793e\u7fa4\u3001IoT\u3001\u5927\u91cf\u8b80\u5beb<\/td>\n<\/tr>\n<tr>\n<td><strong>\u4ee3\u8868\u7522\u54c1<\/strong><\/td>\n<td>PostgreSQL\u3001MySQL<\/td>\n<td>MongoDB\u3001Redis\u3001Cassandra<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u9078 SQL\uff1f<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u8cc7\u6599\u4e4b\u9593\u6709\u660e\u78ba\u7684\u95dc\u806f\uff08\u4f7f\u7528\u8005 &#8211; \u8a02\u55ae &#8211; \u5546\u54c1\uff09<\/li>\n\n\n<li>\u9700\u8981\u8907\u96dc\u7684\u67e5\u8a62\uff08\u591a\u5f35\u8868\u683c JOIN\uff09<\/li>\n\n\n<li>\u8cc7\u6599\u6b63\u78ba\u6027\u975e\u5e38\u91cd\u8981\uff08\u91d1\u878d\u4ea4\u6613\u3001\u5eab\u5b58\u7ba1\u7406\uff09<\/li>\n\n\n<li>\u8cc7\u6599\u7d50\u69cb\u7a69\u5b9a\uff0c\u4e0d\u5e38\u6539\u8b8a<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u9078 NoSQL\uff1f<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u8cc7\u6599\u7d50\u69cb\u7d93\u5e38\u8b8a\u52d5\uff08\u6bcf\u500b\u4f7f\u7528\u8005\u6709\u4e0d\u540c\u6b04\u4f4d\uff09<\/li>\n\n\n<li>\u9700\u8981\u8655\u7406\u5927\u91cf\u8b80\u5beb\uff08\u6bcf\u79d2\u6578\u842c\u5230\u6578\u767e\u842c\u7b46\uff09<\/li>\n\n\n<li>\u8cc7\u6599\u662f\u5de2\u72c0\u7d50\u69cb\uff08JSON\/\u6587\u4ef6\u578b\uff09<\/li>\n\n\n<li>\u53ef\u4ee5\u63a5\u53d7\u77ed\u66ab\u7684\u8cc7\u6599\u4e0d\u4e00\u81f4<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u771f\u5be6\u4e16\u754c\u7684\u9078\u64c7<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u516c\u53f8<\/th>\n<th>\u9078\u64c7<\/th>\n<th>\u539f\u56e0<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Instagram<\/td>\n<td>PostgreSQL<\/td>\n<td>\u4f7f\u7528\u8005\u3001\u8cbc\u6587\u3001\u7559\u8a00\u4e4b\u9593\u6709\u5927\u91cf\u95dc\u806f<\/td>\n<\/tr>\n<tr>\n<td>Netflix<\/td>\n<td>Cassandra<\/td>\n<td>\u5168\u7403\u6578\u5104\u7528\u6236\u7684\u89c0\u770b\u8a18\u9304\uff0c\u9700\u8981\u8d85\u5927\u898f\u6a21\u5beb\u5165<\/td>\n<\/tr>\n<tr>\n<td>Uber<\/td>\n<td>\u6df7\u5408\u4f7f\u7528<\/td>\n<td>PostgreSQL \u5b58\u6838\u5fc3\u4ea4\u6613\uff0cRedis \u505a\u5373\u6642\u5b9a\u4f4d\u5feb\u53d6<\/td>\n<\/tr>\n<tr>\n<td>Discord<\/td>\n<td>Cassandra \u2192 ScyllaDB<\/td>\n<td>\u6bcf\u5929\u6578\u5341\u5104\u7b46\u8a0a\u606f\uff0c\u9700\u8981\u6975\u9ad8\u5beb\u5165\u6548\u80fd<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">**\u91cd\u8981\u89c0\u5ff5**\uff1aSQL vs NoSQL \u4e0d\u662f\u300c\u8ab0\u6bd4\u8f03\u597d\u300d\uff0c\u800c\u662f\u300c\u4ec0\u9ebc\u5834\u666f\u7528\u4ec0\u9ebc\u5de5\u5177\u300d\u3002\u5927\u591a\u6578\u73fe\u4ee3\u7cfb\u7d71\u6703**\u6df7\u5408\u4f7f\u7528** &#8212; \u6838\u5fc3\u8cc7\u6599\u7528 SQL\uff0c\u5feb\u53d6\u548c\u65e5\u8a8c\u7528 NoSQL\u3002<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u8acb AI \u5e6b\u4f60\u5efa\u5c08\u6848\uff0c\u770b\u5230\u8cc7\u6599\u5eab\u76f8\u95dc\u7684\u4ee3\u78bc\u6642\uff0c\u78ba\u8a8d\u4ee5\u4e0b\u5e7e\u9ede\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] <strong>AI \u9078\u4e86\u54ea\u7a2e\u8cc7\u6599\u5eab\uff1f<\/strong> \u770b connection string\uff08<code>postgresql:\/\/<\/code> vs <code>mongodb:\/\/<\/code> vs <code>redis:\/\/<\/code>\uff09<\/li>\n\n\n<li>[ ] <strong>\u6709\u6c92\u6709 Schema\/Model \u5b9a\u7fa9\uff1f<\/strong> SQL \u985e\u4e00\u5b9a\u6709\uff08\u50cf <code>CREATE TABLE<\/code> \u6216 ORM \u7684 class\uff09\uff0cNoSQL \u53ef\u80fd\u6c92\u6709<\/li>\n\n\n<li>[ ] <strong>\u6709\u6c92\u6709\u7528 Transaction\uff1f<\/strong> \u6d89\u53ca\u591a\u6b65\u64cd\u4f5c\uff08\u8f49\u5e33\u3001\u4e0b\u55ae\uff09\u6642\uff0c\u61c9\u8a72\u8981\u770b\u5230 <code>BEGIN<\/code>\/<code>COMMIT<\/code> \u6216 <code>session.begin()<\/code><\/li>\n\n\n<li>[ ] <strong>\u8cc7\u6599\u4e4b\u9593\u7684\u95dc\u806f\u600e\u9ebc\u8655\u7406\uff1f<\/strong> SQL \u7528 JOIN\uff0cNoSQL \u901a\u5e38\u628a\u76f8\u95dc\u8cc7\u6599\u585e\u5728\u540c\u4e00\u500b\u6587\u4ef6\u88e1<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u5fc5\u770b\u61c2 vs \u77e5\u9053\u5c31\u597d<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u5fc5\u770b\u61c2\uff08AI \u751f\u6210\u7684\u4ee3\u78bc\u4e00\u5b9a\u6703\u51fa\u73fe\uff09\uff1a\n  - CREATE TABLE \/ Model \u5b9a\u7fa9\n  - SELECT ... FROM ... WHERE\n  - JOIN\uff08\u628a\u8868\u683c\u5408\u5728\u4e00\u8d77\u67e5\uff09\n  - INSERT \/ UPDATE \/ DELETE\n  - Transaction\uff08BEGIN \/ COMMIT \/ ROLLBACK\uff09\n\n\u77e5\u9053\u5c31\u597d\uff08\u9047\u5230\u518d\u67e5\uff09\uff1a\n  - INDEX\uff08\u52a0\u5feb\u67e5\u8a62\u7684\u7d22\u5f15\uff09\n  - VIEW\uff08\u865b\u64ec\u8868\u683c\uff09\n  - Stored Procedure\uff08\u5b58\u5728\u8cc7\u6599\u5eab\u88e1\u7684\u7a0b\u5f0f\uff09\n  - Sharding\uff08\u628a\u8cc7\u6599\u5206\u6563\u5230\u591a\u53f0\u6a5f\u5668\uff09\n  - Replication\uff08\u8cc7\u6599\u8907\u88fd\u5230\u591a\u53f0\u6a5f\u5668\u505a\u5099\u4efd\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u672c\u7bc7\u91cd\u9ede\u56de\u9867<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li><strong>SQL \u8cc7\u6599\u5eab<\/strong>\uff1a\u8cc7\u6599\u5b58\u5728\u56fa\u5b9a\u7d50\u69cb\u7684\u8868\u683c\u88e1\uff0c\u9760 JOIN \u9023\u63a5\u4e0d\u540c\u8868\u683c\uff0c\u9069\u5408\u6709\u660e\u78ba\u95dc\u806f\u7684\u8cc7\u6599\u3002<\/li>\n\n\n<li><strong>ACID<\/strong>\uff1aSQL \u8cc7\u6599\u5eab\u7684\u56db\u5927\u5b89\u5168\u4fdd\u8b49 &#8212; \u539f\u5b50\u6027\uff08\u5168\u505a\u6216\u5168\u4e0d\u505a\uff09\u3001\u4e00\u81f4\u6027\uff08\u898f\u5247\u4e0d\u88ab\u6253\u7834\uff09\u3001\u9694\u96e2\u6027\uff08\u4ea4\u6613\u4e92\u4e0d\u5e72\u64fe\uff09\u3001\u6301\u4e45\u6027\uff08\u5beb\u5165\u5c31\u4e0d\u4e1f\uff09\u3002<\/li>\n\n\n<li><strong>NoSQL \u8cc7\u6599\u5eab<\/strong>\uff1a\u7d50\u69cb\u5f48\u6027\u3001\u5bb9\u6613\u6c34\u5e73\u64f4\u5c55\uff0c\u4f46\u901a\u5e38\u72a7\u7272\u90e8\u5206\u4e00\u81f4\u6027\u3002\u56db\u7a2e\u985e\u578b\u5404\u6709\u5c08\u9577\uff1aKey-Value\uff08\u5feb\u53d6\uff09\u3001Document\uff08\u901a\u7528\uff09\u3001Column-Family\uff08\u5927\u6578\u64da\uff09\u3001Graph\uff08\u95dc\u4fc2\u7db2\u7d61\uff09\u3002<\/li>\n\n\n<li><strong>\u9078\u64c7\u539f\u5247<\/strong>\uff1a\u4e0d\u662f\u300c\u54ea\u500b\u6bd4\u8f03\u597d\u300d\uff0c\u800c\u662f\u300c\u4ec0\u9ebc\u5834\u666f\u7528\u4ec0\u9ebc\u300d\u3002\u73fe\u4ee3\u7cfb\u7d71\u901a\u5e38\u6df7\u5408\u4f7f\u7528\u3002<\/li>\n\n<\/ol>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u4e0b\u4e00\u7bc7\u6211\u5011\u6703\u9032\u5165 API \u8207\u901a\u8a0a\u6a5f\u5236\uff0c\u770b\u770b\u7cfb\u7d71\u4e4b\u9593\u662f\u600e\u9ebc\u300c\u5c0d\u8a71\u300d\u7684\u3002<\/p>\n<\/blockquote>\n\n\n\n<div id=\"quiz-1bdd964e\">\n<style>\n#quiz-1bdd964e .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-1bdd964e .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-1bdd964e .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-1bdd964e .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-1bdd964e .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-1bdd964e .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-1bdd964e .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-1bdd964e .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-1bdd964e .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-1bdd964e .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-1bdd964e .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-1bdd964e .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-1bdd964e .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-1bdd964e .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-1bdd964e .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-1bdd964e .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-1bdd964e .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1a\u8cc7\u6599\u5eab\u6838\u5fc3 \u2014 SQL\u3001ACID\u3001NoSQL<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u6240\u5b78\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u6b63\u5728\u958b\u767c\u4e00\u500b\u5373\u6642\u804a\u5929\u61c9\u7528\uff0c\u9810\u8a08\u6bcf\u5929\u6703\u7522\u751f\u6578\u5341\u5104\u7b46\u8a0a\u606f\u3002\u8a0a\u606f\u683c\u5f0f\u7c21\u55ae\uff08\u767c\u9001\u8005\u3001\u63a5\u6536\u8005\u3001\u5167\u5bb9\u3001\u6642\u9593\u6233\uff09\uff0c\u4f46\u5beb\u5165\u91cf\u6975\u5927\u3002\u4f60\u61c9\u8a72\u9078\u64c7\u54ea\u7a2e\u8cc7\u6599\u5eab\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'C')\">A. PostgreSQL &#8212; \u56e0\u70ba\u652f\u63f4 ACID\uff0c\u80fd\u78ba\u4fdd\u6bcf\u7b46\u8a0a\u606f\u4e0d\u6703\u907a\u5931<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'C')\">B. MongoDB &#8212; \u56e0\u70ba Schema \u5f48\u6027\uff0c\u53ef\u4ee5\u96a8\u6642\u8abf\u6574\u8a0a\u606f\u683c\u5f0f<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'C')\">C. Cassandra &#8212; \u56e0\u70ba\u64c5\u9577\u8655\u7406\u6d77\u91cf\u5beb\u5165\uff0c\u4e14\u6c34\u5e73\u64f4\u5c55\u5bb9\u6613<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'C')\">D. Redis &#8212; \u56e0\u70ba\u901f\u5ea6\u6975\u5feb\uff0c\u8cc7\u6599\u5b58\u5728\u8a18\u61b6\u9ad4\u4e2d<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u4f60\u7684\u96fb\u5546\u5e73\u53f0\u9700\u8981\u540c\u6642\u8655\u7406\u4ee5\u4e0b\u9700\u6c42\uff1a\u4f7f\u7528\u8005\u4e0b\u55ae\u6642\u8981\u78ba\u4fdd\u5eab\u5b58\u6263\u6e1b\u548c\u91d1\u984d\u6263\u6b3e\u540c\u6642\u6210\u529f\u6216\u540c\u6642\u5931\u6557\uff0c\u540c\u6642\u9996\u9801\u5546\u54c1\u63a8\u85a6\u9700\u8981\u6beb\u79d2\u7d1a\u56de\u61c9\u3002\u6700\u5408\u7406\u7684\u67b6\u69cb\u662f\u4ec0\u9ebc\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'D')\">A. \u5168\u90e8\u4f7f\u7528 PostgreSQL\uff0c\u56e0\u70ba ACID \u4fdd\u8b49\u8cc7\u6599\u6b63\u78ba<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'D')\">B. \u5168\u90e8\u4f7f\u7528 MongoDB\uff0c\u56e0\u70ba\u67e5\u8a62\u901f\u5ea6\u5feb\u53c8\u5f48\u6027<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'D')\">C. \u5168\u90e8\u4f7f\u7528 Redis\uff0c\u56e0\u70ba\u6beb\u79d2\u7d1a\u56de\u61c9\u6700\u91cd\u8981<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'D')\">D. \u6df7\u5408\u4f7f\u7528\uff1aPostgreSQL \u8655\u7406\u8a02\u55ae\u4ea4\u6613\uff08\u9700\u8981 ACID\uff09\uff0cRedis \u505a\u5546\u54c1\u63a8\u85a6\u5feb\u53d6<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 3 -->\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u6b63\u5728\u5efa\u4e00\u500b\u793e\u7fa4\u5e73\u53f0\u7684\u300c\u597d\u53cb\u63a8\u85a6\u300d\u529f\u80fd\uff0c\u9700\u8981\u67e5\u8a62\u300c\u6211\u7684\u670b\u53cb\u7684\u670b\u53cb\u4e2d\uff0c\u54ea\u4e9b\u4eba\u6211\u9084\u6c92\u8ffd\u8e64\u300d\u3002\u54ea\u7a2e NoSQL \u985e\u578b\u6700\u9069\u5408\u9019\u500b\u5834\u666f\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'B')\">A. Document\uff08\u6587\u4ef6\u578b\uff09&#8211; \u628a\u6bcf\u500b\u4f7f\u7528\u8005\u7684\u597d\u53cb\u5217\u8868\u5b58\u6210 JSON \u9663\u5217<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'B')\">B. Graph\uff08\u5716\u578b\uff09&#8211; \u5c08\u9580\u8655\u7406\u300c\u8ab0\u8ddf\u8ab0\u6709\u95dc\u4fc2\u300d\u7684\u591a\u5c64\u67e5\u8a62<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'B')\">C. Key-Value\uff08\u9375\u503c\u5c0d\uff09&#8211; \u7528\u4f7f\u7528\u8005 ID \u7576 key\uff0c\u5feb\u901f\u67e5\u627e<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'B')\">D. Column-Family\uff08\u6b04\u65cf\u578b\uff09&#8211; \u628a\u4f7f\u7528\u8005\u8cc7\u6599\u5206\u7d44\u5b58\u653e<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u5c0f\u660e\u5beb\u4e86\u4ee5\u4e0b\u8f49\u5e33\u4ee3\u78bc\uff0c\u4f46\u6e2c\u8a66\u6642\u767c\u73fe\u6709\u6642\u5019\u9322\u6703\u300c\u6191\u7a7a\u6d88\u5931\u300d\u3002\u554f\u984c\u51fa\u5728\u54ea\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\"># \u5c0f\u660e\u7684\u8f49\u5e33\u4ee3\u78bc\ndef transfer(from_user, to_user, amount):\n    from_user.balance -= amount    # \u7b2c 1 \u6b65\uff1a\u6263\u6b3e\n    db.save(from_user)             # \u5beb\u5165\u8cc7\u6599\u5eab\n\n    to_user.balance += amount      # \u7b2c 2 \u6b65\uff1a\u52a0\u6b3e\n    db.save(to_user)               # \u5beb\u5165\u8cc7\u6599\u5eab<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. \u61c9\u8a72\u5148\u6aa2\u67e5 from_user.balance \u662f\u5426\u8db3\u5920\uff0c\u7f3a\u5c11\u4e00\u81f4\u6027\u6aa2\u67e5<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. \u6c92\u6709\u4f7f\u7528 Transaction\uff0c\u5982\u679c\u7b2c 1 \u6b65\u6210\u529f\u4f46\u7b2c 2 \u6b65\u5931\u6557\uff0c\u6263\u6b3e\u4e0d\u6703\u88ab\u56de\u6efe<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. \u61c9\u8a72\u7528 NoSQL \u8cc7\u6599\u5eab\u53d6\u4ee3 SQL\uff0c\u624d\u80fd\u8655\u7406\u9ad8\u4f75\u767c<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. db.save() \u4e0d\u662f\u6b63\u78ba\u7684\u5beb\u5165\u65b9\u6cd5\uff0c\u61c9\u8a72\u7528 db.commit()<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. AI \u5e6b\u5c0f\u7f8e\u7522\u751f\u4e86\u4ee5\u4e0b\u4ee3\u78bc\u4f86\u5b58\u4f7f\u7528\u8005\u7684\u500b\u4eba\u8a2d\u5b9a\u3002\u6bcf\u500b\u4f7f\u7528\u8005\u7684\u8a2d\u5b9a\u6b04\u4f4d\u90fd\u4e0d\u540c\uff08\u6709\u4eba\u8a2d\u4e86\u4e3b\u984c\u8272\u3001\u6709\u4eba\u8a2d\u4e86\u8a9e\u8a00\u504f\u597d\u3001\u6709\u4eba\u4ec0\u9ebc\u90fd\u6c92\u8a2d\uff09\u3002\u5c0f\u7f8e\u7528\u4e86 SQL \u8cc7\u6599\u5eab\uff0c\u4f46\u9047\u5230\u4e86\u554f\u984c\u3002\u6700\u53ef\u80fd\u7684\u554f\u984c\u662f\u4ec0\u9ebc\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">CREATE TABLE user_preferences (\n    user_id    INT PRIMARY KEY,\n    theme      VARCHAR(50),\n    language   VARCHAR(10),\n    font_size  INT,\n    sidebar    BOOLEAN,\n    &#8212; \u6bcf\u6b21\u6709\u65b0\u8a2d\u5b9a\u9805\u5c31\u8981\u52a0\u4e00\u500b\u6b04\u4f4d&#8230;\n);<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. VARCHAR \u985e\u578b\u4e0d\u9069\u5408\u5b58\u8a2d\u5b9a\u503c\uff0c\u61c9\u8a72\u7528 TEXT \u985e\u578b<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u6c92\u6709\u8a2d\u5b9a INDEX\uff0c\u67e5\u8a62\u901f\u5ea6\u6703\u5f88\u6162<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. SQL \u7684 Schema \u662f\u56fa\u5b9a\u7684\uff0c\u6bcf\u6b21\u65b0\u589e\u8a2d\u5b9a\u9805\u90fd\u9700\u8981\u6539\u8868\u683c\u7d50\u69cb\uff0c\u61c9\u8a72\u8003\u616e\u7528 NoSQL\uff08\u5982 MongoDB\uff09\u76f4\u63a5\u5b58 JSON<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. \u7f3a\u5c11 ACID Transaction\uff0c\u591a\u500b\u8a2d\u5b9a\u540c\u6642\u66f4\u65b0\u6703\u4e92\u76f8\u8986\u84cb<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"\u6587\u7ae0\u63d0\u5230 Discord \u548c Netflix \u90fd\u4f7f\u7528 Cassandra \u4f86\u8655\u7406\u6bcf\u5929\u6578\u5341\u5104\u7b46\u7684\u8cc7\u6599\u5beb\u5165\u3002Cassandra \u662f Column-Family \u578b NoSQL\uff0c\u64c5\u9577\u6d77\u91cf\u5beb\u5165\u4e14\u6c34\u5e73\u64f4\u5c55\u5bb9\u6613\u3002PostgreSQL \u96d6\u6709 ACID \u4f46\u5782\u76f4\u64f4\u5c55\u6709\u4e0a\u9650\uff0c\u96e3\u4ee5\u61c9\u4ed8\u5982\u6b64\u5927\u91cf\u5beb\u5165\uff1bMongoDB \u7684\u512a\u52e2\u662f Schema \u5f48\u6027\u800c\u975e\u8d85\u5927\u898f\u6a21\u5beb\u5165\uff1bRedis \u96d6\u7136\u5feb\u4f46\u8cc7\u6599\u5b58\u5728\u8a18\u61b6\u9ad4\u4e2d\uff0c\u4e0d\u9069\u5408\u4f5c\u70ba\u4e3b\u8981\u5132\u5b58\u3002\",\n        2: \"\u6587\u7ae0\u660e\u78ba\u6307\u51fa\u300c\u5927\u591a\u6578\u73fe\u4ee3\u7cfb\u7d71\u6703\u6df7\u5408\u4f7f\u7528 -- \u6838\u5fc3\u8cc7\u6599\u7528 SQL\uff0c\u5feb\u53d6\u548c\u65e5\u8a8c\u7528 NoSQL\u300d\u3002\u4ee5 Uber \u70ba\u4f8b\uff0c\u4ed6\u5011\u7528 PostgreSQL \u5b58\u6838\u5fc3\u4ea4\u6613\u3001Redis \u505a\u5373\u6642\u5feb\u53d6\u3002\u5168\u7528\u4e00\u7a2e\u8cc7\u6599\u5eab\u7121\u6cd5\u540c\u6642\u6eff\u8db3\u5169\u7a2e\u4e0d\u540c\u9700\u6c42\uff1a\u8a02\u55ae\u4ea4\u6613\u9700\u8981 ACID \u4fdd\u8b49\uff08SQL\uff09\uff0c\u800c\u63a8\u85a6\u7cfb\u7d71\u9700\u8981\u6beb\u79d2\u7d1a\u56de\u61c9\uff08Redis \u5feb\u53d6\uff09\u3002\",\n        3: \"\u6587\u7ae0\u6307\u51fa Graph\uff08\u5716\u578b\uff09\u8cc7\u6599\u5eab\u5c08\u9580\u8655\u7406\u300c\u8ab0\u8ddf\u8ab0\u6709\u95dc\u4fc2\u300d\u7684\u8cc7\u6599\uff0c\u67e5\u8a62\u300c\u670b\u53cb\u7684\u670b\u53cb\u300d\u53ea\u9700\u4e00\u6b65\u641e\u5b9a\uff0c\u800c SQL \u8981\u5beb\u591a\u5c64 JOIN \u4e14\u5f88\u6162\u3002Neo4j \u5c31\u662f\u9019\u985e\u8cc7\u6599\u5eab\u7684\u4ee3\u8868\uff0c\u5e38\u7528\u65bc\u793e\u7fa4\u7db2\u8def\u548c\u63a8\u85a6\u7cfb\u7d71\u3002Document \u578b\u96d6\u7136\u80fd\u5b58\u597d\u53cb\u5217\u8868\uff0c\u4f46\u591a\u5c64\u95dc\u4fc2\u67e5\u8a62\u6548\u7387\u9060\u4e0d\u5982 Graph \u578b\u3002\",\n        4: \"\u9019\u6b63\u662f ACID \u4e2d Atomicity\uff08\u539f\u5b50\u6027\uff09\u8981\u89e3\u6c7a\u7684\u554f\u984c\u3002\u6587\u7ae0\u7528\u9280\u884c\u8f49\u5e33\u8aaa\u660e\uff1a\u5982\u679c\u6263\u6b3e\u6210\u529f\u4f46\u52a0\u6b3e\u5931\u6557\uff0c\u9322\u5c31\u6703\u300c\u6d88\u5931\u300d\u3002\u6b63\u78ba\u505a\u6cd5\u662f\u7528 Transaction \u628a\u5169\u6b65\u64cd\u4f5c\u5305\u6210\u4e00\u7d44\uff08<code>with session.begin()<\/code>\uff09\uff0c\u5168\u505a\u6216\u5168\u4e0d\u505a\u3002\u9078\u9805 A \u96d6\u7136\u4e5f\u662f\u554f\u984c\uff08\u7f3a\u5c11\u4e00\u81f4\u6027\u6aa2\u67e5\uff09\uff0c\u4f46\u300c\u9322\u6d88\u5931\u300d\u7684\u6839\u672c\u539f\u56e0\u662f\u6c92\u6709\u539f\u5b50\u6027\u4fdd\u8b49\u3002\u9078\u9805 C \u548c D \u90fd\u4e0d\u662f\u554f\u984c\u7684\u6839\u6e90\u3002\",\n        5: \"\u6587\u7ae0\u6307\u51fa SQL \u8cc7\u6599\u5eab\u7684 Schema \u662f\u56fa\u5b9a\u7684\uff0c\u300c\u4f60\u4e0d\u80fd\u7a81\u7136\u5728\u67d0\u4e00\u5217\u591a\u585e\u4e00\u500b\u6b04\u4f4d\u300d\u3002\u7576\u6bcf\u500b\u4f7f\u7528\u8005\u7684\u8a2d\u5b9a\u6b04\u4f4d\u90fd\u4e0d\u540c\u3001\u4e14\u8a2d\u5b9a\u9805\u7d93\u5e38\u65b0\u589e\u6642\uff0c\u6bcf\u6b21\u90fd\u8981 ALTER TABLE \u52a0\u6b04\u4f4d\u975e\u5e38\u75db\u82e6\u3002\u9019\u6b63\u662f NoSQL\uff08\u5982 MongoDB\uff09\u7684\u512a\u52e2\u5834\u666f -- Schema \u5f48\u6027\uff0c\u300c\u60f3\u52a0\u4ec0\u9ebc\u52a0\u4ec0\u9ebc\u300d\uff0c\u76f4\u63a5\u628a\u8a2d\u5b9a\u5b58\u6210\u4e00\u500b JSON \u6587\u4ef6\u5373\u53ef\u3002\u9078\u9805 A\u3001B\u3001D \u90fd\u4e0d\u662f\u9019\u500b\u5834\u666f\u4e0b\u7684\u6838\u5fc3\u554f\u984c\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1a\u8cc7\u6599\u5eab\u6838\u5fc3 \u2014 SQL\u3001ACID\u3001NoSQL \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. SQL \u8cc7\u6599\u5eab [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[711],"tags":[746,747,719,718,705,701,708],"class_list":["post-771","post","type-post","status-publish","format-standard","hentry","category-711","tag-acid","tag-database","tag-nosql","tag-sql","tag-system-design","tag-701","tag-708"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=771"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/771\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}