{"id":775,"date":"2026-02-23T22:29:07","date_gmt":"2026-02-23T14:29:07","guid":{"rendered":"https:\/\/blog.itsmygo.uk\/2026\/02\/23\/%e3%80%90%e5%b7%a5%e7%a8%8b%e5%b8%ab%e7%9a%84%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e3%80%9103-%e8%b3%87%e6%96%99%e5%b1%a4%e8%a8%ad%e8%a8%88%ef%bc%9a%e8%b3%87%e6%96%99%e5%ba%ab%e9%81%b8%e5%9e%8b\/"},"modified":"2026-02-23T22:29:07","modified_gmt":"2026-02-23T14:29:07","slug":"%e3%80%90%e5%b7%a5%e7%a8%8b%e5%b8%ab%e7%9a%84%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e3%80%9103-%e8%b3%87%e6%96%99%e5%b1%a4%e8%a8%ad%e8%a8%88%ef%bc%9a%e8%b3%87%e6%96%99%e5%ba%ab%e9%81%b8%e5%9e%8b","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/02\/23\/%e3%80%90%e5%b7%a5%e7%a8%8b%e5%b8%ab%e7%9a%84%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e3%80%9103-%e8%b3%87%e6%96%99%e5%b1%a4%e8%a8%ad%e8%a8%88%ef%bc%9a%e8%b3%87%e6%96%99%e5%ba%ab%e9%81%b8%e5%9e%8b\/","title":{"rendered":"\u3010\u5de5\u7a0b\u5e2b\u7684\u7cfb\u7d71\u8a2d\u8a08\u3011#03 \u8cc7\u6599\u5c64\u8a2d\u8a08\uff1a\u8cc7\u6599\u5eab\u9078\u578b\u3001Schema \u8207\u5feb\u53d6\u7b56\u7565"},"content":{"rendered":"\n<div id=\"quiz-14707803\">\n<style>\n#quiz-14707803 .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-14707803 .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-14707803 .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-14707803 .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-14707803 .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-14707803 .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-14707803 .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-14707803 .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-14707803 .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-14707803 .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-14707803 .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-14707803 .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-14707803 .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-14707803 .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\u5c64\u8a2d\u8a08 &#8211; \u8cc7\u6599\u5eab\u9078\u578b\u3001Schema \u8207\u5feb\u53d6\u7b56\u7565<\/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. \u5728\u7cfb\u7d71\u67b6\u69cb\u4e2d\uff0c\u70ba\u4ec0\u9ebc\u8cc7\u6599\u5eab\u901a\u5e38\u662f\u7cfb\u7d71\u74f6\u9838\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u8cc7\u6599\u5eab\u7684\u7a0b\u5f0f\u8a9e\u8a00\u6bd4\u8f03\u6162<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u8cc7\u6599\u5eab\u8981\u8b80\u5beb\u78c1\u789f\u3001\u8655\u7406\u9396\u5b9a\u3001\u7dad\u8b77\u7d22\u5f15\uff0c\u901f\u5ea6\u9060\u4f4e\u65bc\u8a18\u61b6\u9ad4\u904b\u7b97<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u8cc7\u6599\u5eab\u53ea\u80fd\u55ae\u57f7\u884c\u7dd2\u904b\u4f5c\uff0c\u7121\u6cd5\u5e73\u884c\u8655\u7406<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u8cc7\u6599\u5eab\u9700\u8981\u9023\u7db2\u624d\u80fd\u4f7f\u7528\uff0c\u7db2\u8def\u5ef6\u9072\u662f\u4e3b\u56e0<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u5982\u679c\u4f60\u8981\u5efa\u4e00\u500b\u6d89\u53ca\u91d1\u9322\u4ea4\u6613\u7684\u96fb\u5546\u7cfb\u7d71\uff08\u8a02\u55ae\u3001\u652f\u4ed8\uff09\uff0c\u6700\u9069\u5408\u9078\u64c7\u54ea\u7a2e\u8cc7\u6599\u5eab\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'A')\">A. PostgreSQL\uff0c\u56e0\u70ba\u652f\u63f4 ACID \u78ba\u4fdd\u4ea4\u6613\u5b89\u5168<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'A')\">B. MongoDB\uff0c\u56e0\u70ba\u6587\u4ef6\u578b\u7d50\u69cb\u66f4\u9069\u5408\u5b58\u8a02\u55ae\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'A')\">C. Redis\uff0c\u56e0\u70ba\u901f\u5ea6\u6700\u5feb\uff0c\u4ea4\u6613\u8b1b\u7a76\u6548\u7387<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'A')\">D. \u4e09\u7a2e\u90fd\u53ef\u4ee5\uff0c\u770b\u5718\u968a\u719f\u6089\u54ea\u500b\u5c31\u7528\u54ea\u500b<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u770b\u5230\u4ee5\u4e0b SQLAlchemy \u7a0b\u5f0f\u78bc\uff0c<code>ForeignKey(\"users.id\")<\/code> \u4ee3\u8868\u4ec0\u9ebc\u610f\u601d\uff1f<\/h3>\n      <div class=\"code-block\">class Order(Base):\n    __tablename__ = &#8220;orders&#8221;\n    id = Column(Integer, primary_key=True)\n    user_id = Column(Integer, ForeignKey(&#8220;users.id&#8221;))<\/div>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'C')\">A. \u5efa\u7acb\u4e00\u500b\u540d\u70ba users.id \u7684\u65b0\u6b04\u4f4d<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'C')\">B. \u628a user_id \u8a2d\u70ba\u81ea\u52d5\u905e\u589e\u7684\u4e3b\u9375<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'C')\">C. user_id \u7684\u503c\u5fc5\u9808\u662f users \u8868\u88e1\u67d0\u500b\u5df2\u5b58\u5728\u7684 id<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'C')\">D. \u5c07 orders \u8868\u5408\u4f75\u5230 users \u8868\u4e2d<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u95dc\u65bc\u300c\u6b63\u898f\u5316\u300d\u548c\u300c\u53cd\u6b63\u898f\u5316\u300d\uff0c\u4ee5\u4e0b\u6558\u8ff0\u4f55\u8005\u6b63\u78ba\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'D')\">A. \u6b63\u898f\u5316\u5c31\u662f\u628a\u6240\u6709\u8cc7\u6599\u653e\u5728\u540c\u4e00\u5f35\u8868\uff0c\u67e5\u8a62\u6bd4\u8f03\u65b9\u4fbf<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'D')\">B. \u53cd\u6b63\u898f\u5316\u9069\u5408\u300c\u5beb\u591a\u8b80\u5c11\u300d\u7684\u5834\u666f\uff0c\u56e0\u70ba\u53ea\u9700\u8981\u6539\u4e00\u500b\u5730\u65b9<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'D')\">C. \u5be6\u52d9\u4e0a\u61c9\u8a72\u4e00\u958b\u59cb\u5c31\u5927\u91cf\u53cd\u6b63\u898f\u5316\uff0c\u6548\u80fd\u512a\u5148<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'D')\">D. \u5148\u6b63\u898f\u5316\u8a2d\u8a08\uff0c\u9047\u5230\u6548\u80fd\u554f\u984c\u518d\u5c40\u90e8\u53cd\u6b63\u898f\u5316<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5728 Cache-Aside Pattern \u4e2d\uff0c\u5982\u679c\u5927\u91cf\u5feb\u53d6\u540c\u6642\u904e\u671f\u5c0e\u81f4\u6240\u6709\u8acb\u6c42\u77ac\u9593\u6253\u5230\u8cc7\u6599\u5eab\uff0c\u9019\u500b\u554f\u984c\u53eb\u4ec0\u9ebc\uff1f\u5e38\u898b\u7684\u89e3\u6cd5\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'C')\">A. \u5feb\u53d6\u7a7f\u900f\uff1b\u89e3\u6cd5\u662f\u5c0d\u4e0d\u5b58\u5728\u7684\u8cc7\u6599\u4e5f\u5b58\u4e00\u500b\u7a7a\u503c<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'C')\">B. \u5feb\u53d6\u64ca\u7a7f\uff1b\u89e3\u6cd5\u662f\u7528\u5206\u6563\u5f0f\u9396\u8b93\u53ea\u6709\u4e00\u500b\u8acb\u6c42\u67e5 DB<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'C')\">C. \u5feb\u53d6\u96ea\u5d29\uff1b\u89e3\u6cd5\u662f\u904e\u671f\u6642\u9593\u52a0\u4e0a\u96a8\u6a5f\u503c\uff0c\u907f\u514d\u540c\u6642\u5931\u6548<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'C')\">D. \u5feb\u53d6\u6ea2\u4f4d\uff1b\u89e3\u6cd5\u662f\u589e\u52a0 Redis \u7684\u8a18\u61b6\u9ad4\u4e0a\u9650<\/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: \"API \u4f3a\u670d\u5668\u7684\u904b\u7b97\u5728\u8a18\u61b6\u9ad4\u88e1\u5b8c\u6210\uff08\u5948\u79d2\u7b49\u7d1a\uff09\uff0c\u800c\u8cc7\u6599\u5eab\u8981\u8b80\u5beb\u78c1\u789f\u3001\u8655\u7406\u9396\u5b9a\u3001\u7dad\u8b77\u7d22\u5f15\uff08\u6beb\u79d2\u7b49\u7d1a\uff09\uff0c\u5169\u8005\u901f\u5ea6\u5dee\u8ddd\u7d04\u4e00\u767e\u842c\u500d\uff0c\u9019\u662f\u8cc7\u6599\u5c64\u6210\u70ba\u74f6\u9838\u7684\u6839\u672c\u539f\u56e0\u3002\",\n        2: \"\u6d89\u53ca\u91d1\u9322\u7684\u7cfb\u7d71\u9700\u8981 ACID \u4fdd\u969c\uff08\u539f\u5b50\u6027\u3001\u4e00\u81f4\u6027\u3001\u9694\u96e2\u6027\u3001\u6301\u4e45\u6027\uff09\uff0c\u78ba\u4fdd\u4ea4\u6613\u8981\u561b\u5168\u6210\u529f\u8981\u561b\u5168\u5931\u6557\u3002PostgreSQL \u5929\u751f\u652f\u63f4 ACID\uff0c\u800c MongoDB \u548c Redis \u5728\u9019\u65b9\u9762\u6bd4\u8f03\u5f31\u3002\",\n        3: \"ForeignKey\uff08\u5916\u9375\uff09\u662f\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7684\u6838\u5fc3\u6982\u5ff5\u3002<code>ForeignKey(\\\"users.id\\\")<\/code> \u8868\u793a user_id \u6b04\u4f4d\u7684\u503c\u5fc5\u9808\u5c0d\u61c9\u5230 users \u8868\u4e2d\u67d0\u500b\u5df2\u5b58\u5728\u7684 id\uff0c\u9019\u5c31\u662f\u8868\u8207\u8868\u4e4b\u9593\u7684\u95dc\u806f\u3002\",\n        4: \"\u6587\u7ae0\u660e\u78ba\u5efa\u8b70\uff1a\u5148\u6b63\u898f\u5316\u8a2d\u8a08\uff0c\u9047\u5230\u67e5\u8a62\u6548\u80fd\u554f\u984c\u518d\u5c40\u90e8\u53cd\u6b63\u898f\u5316\u3002\u4e0d\u8981\u4e00\u958b\u59cb\u5c31\u70ba\u4e86\u6548\u80fd\u72a7\u7272\u8cc7\u6599\u4e00\u81f4\u6027\u3002\u6b63\u898f\u5316\u662f\u62c6\u8868\u6d88\u9664\u91cd\u8907\uff08\u9069\u5408\u5beb\u591a\u8b80\u5c11\uff09\uff0c\u53cd\u6b63\u898f\u5316\u662f\u5408\u8868\u5197\u9918\u5132\u5b58\uff08\u9069\u5408\u8b80\u591a\u5beb\u5c11\uff09\u3002\",\n        5: \"\u5feb\u53d6\u96ea\u5d29\uff08Cache Avalanche\uff09\u662f\u6307\u5927\u91cf\u5feb\u53d6\u540c\u6642\u904e\u671f\uff0c\u5c0e\u81f4\u77ac\u9593\u6240\u6709\u8acb\u6c42\u90fd\u6253\u5230\u8cc7\u6599\u5eab\u3002\u89e3\u6cd5\u662f\u8b93\u904e\u671f\u6642\u9593\u52a0\u4e0a\u96a8\u6a5f\u503c\uff08\u4f8b\u5982 300 + random(0,60) \u79d2\uff09\uff0c\u4f7f\u4e0d\u540c\u5feb\u53d6\u4e0d\u6703\u540c\u6642\u5931\u6548\u3002\u5feb\u53d6\u7a7f\u900f\u662f\u67e5\u4e0d\u5b58\u5728\u7684\u8cc7\u6599\uff0c\u5feb\u53d6\u64ca\u7a7f\u662f\u55ae\u4e00\u71b1\u9580\u5feb\u53d6\u904e\u671f\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 = \"&#10003; \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"&#10007; \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              ? \" \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \u4e0d\u932f\uff01\"\n                : \" \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\">**\u7cfb\u5217**\uff1a\u5de5\u7a0b\u5e2b\u7684\u7cfb\u7d71\u8a2d\u8a08\uff08\u7b2c 3 \u7bc7\uff0c\u5171 4 \u7bc7\uff09<br>**\u96e3\u5ea6**\uff1aL2-\u9032\u968e<br>**\u524d\u7f6e\u77e5\u8b58**\uff1a\u7b2c 1 \u7bc7\u7cfb\u7d71\u8a2d\u8a08\u601d\u7dad\u5165\u9580\u3001\u7b2c 2 \u7bc7 API \u8a2d\u8a08\u3001\u57fa\u672c SQL \u8a9e\u6cd5\uff08SELECT, INSERT, JOIN\uff09<\/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\u5c64\u662f\u7cfb\u7d71\u7684\u300c\u8a18\u61b6\u300d\uff0c\u9078\u5c0d\u8cc7\u6599\u5eab\u3001\u8a2d\u8a08\u597d\u7d50\u69cb\u3001\u642d\u914d\u5feb\u53d6\uff0c\u7cfb\u7d71\u624d\u4e0d\u6703\u6162\u5230\u5d29\u6f70\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4f60\u5c07\u5b78\u6703\u770b\u61c2\u7684\u4e8b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b80\u5b8c\u9019\u7bc7\uff0c\u4f60\u80fd\u5920\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u770b\u5230\u5c08\u6848\u7528 PostgreSQL\u3001MongoDB \u6216 Redis \u6642\uff0c\u7406\u89e3\u70ba\u4ec0\u9ebc\u9078\u5b83<\/li>\n\n\n<li>\u770b\u5230 Schema \u5b9a\u7fa9\u6642\uff0c\u7406\u89e3\u8868\u8ddf\u8868\u4e4b\u9593\u7684\u95dc\u806f<\/li>\n\n\n<li>\u770b\u5230\u7d22\u5f15\u8a2d\u5b9a\u6642\uff0c\u77e5\u9053\u5b83\u5728\u52a0\u901f\u4ec0\u9ebc<\/li>\n\n\n<li>\u770b\u5230\u5feb\u53d6\u908f\u8f2f\u6642\uff0c\u7406\u89e3 Cache-Aside \u7b49\u5e38\u898b\u6a21\u5f0f\u5728\u5e79\u561b<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. \u70ba\u4ec0\u9ebc\u8cc7\u6599\u5c64\u901a\u5e38\u662f\u7cfb\u7d71\u74f6\u9838<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f60\u7684\u7cfb\u7d71\u67b6\u69cb\u9577\u9019\u6a23\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\">\u4f7f\u7528\u8005 \u2192 API \u4f3a\u670d\u5668 \u2192 \u8cc7\u6599\u5eab\n         \uff08\u5f88\u5feb\uff09      \uff08\u5f88\u6162\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">API \u4f3a\u670d\u5668\u7684\u904b\u7b97\u5728\u8a18\u61b6\u9ad4\u88e1\u5b8c\u6210\uff0c\u901f\u5ea6\u662f\u5948\u79d2\u7b49\u7d1a\u3002\u4f46\u8cc7\u6599\u5eab\u8981\u8b80\u5beb\u78c1\u789f\u3001\u8655\u7406\u9396\u5b9a\u3001\u7dad\u8b77\u7d22\u5f15\uff0c\u901f\u5ea6\u662f\u6beb\u79d2\u7b49\u7d1a\u3002\u5dee\u4e86 <strong>\u4e00\u767e\u842c\u500d<\/strong>\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6240\u4ee5\u7cfb\u7d71\u8a2d\u8a08\u7684\u6838\u5fc3\u554f\u984c\u4e4b\u4e00\u5c31\u662f\uff1a<strong>\u600e\u9ebc\u8b93\u8cc7\u6599\u5c64\u4e0d\u62d6\u57ae\u6574\u500b\u7cfb\u7d71<\/strong>\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7b54\u6848\u6709\u4e09\u500b\u65b9\u5411\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li><strong>\u9078\u5c0d\u8cc7\u6599\u5eab<\/strong> &#8212; \u4e0d\u540c\u5834\u666f\u7528\u4e0d\u540c\u5de5\u5177<\/li>\n\n\n<li><strong>\u8a2d\u8a08\u597d Schema<\/strong> &#8212; \u8b93\u67e5\u8a62\u76e1\u91cf\u7c21\u55ae<\/li>\n\n\n<li><strong>\u52a0\u4e0a\u5feb\u53d6<\/strong> &#8212; \u6e1b\u5c11\u76f4\u63a5\u6253\u8cc7\u6599\u5eab\u7684\u6b21\u6578<\/li>\n\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u63a5\u4e0b\u4f86\u6211\u5011\u9010\u4e00\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\">2. SQL vs NoSQL \u9078\u578b\u6307\u5357<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u5340\u5206<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u985e\u578b<\/th>\n<th>\u4ee3\u8868<\/th>\n<th>\u4e00\u53e5\u8a71<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u95dc\u806f\u5f0f\uff08SQL\uff09<\/td>\n<td>PostgreSQL, MySQL<\/td>\n<td>\u8cc7\u6599\u6709\u56b4\u683c\u7d50\u69cb\uff0c\u8868\u8ddf\u8868\u4e4b\u9593\u6709\u95dc\u806f<\/td>\n<\/tr>\n<tr>\n<td>\u6587\u4ef6\u578b\uff08NoSQL\uff09<\/td>\n<td>MongoDB<\/td>\n<td>\u8cc7\u6599\u50cf JSON\uff0c\u7d50\u69cb\u5f48\u6027\u5927<\/td>\n<\/tr>\n<tr>\n<td>\u9375\u503c\u578b\uff08NoSQL\uff09<\/td>\n<td>Redis<\/td>\n<td>\u8d85\u5feb\u7684\u300ckey-value\u300d\u5b58\u53d6\uff0c\u5e38\u7576\u5feb\u53d6\u7528<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u9078\u54ea\u500b<\/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\">\u4f60\u7684\u8cc7\u6599\u6709\u660e\u78ba\u7684\u95dc\u806f\u55ce\uff1f\uff08\u7528\u6236 \u2192 \u8a02\u55ae \u2192 \u5546\u54c1\uff09\n  \u2192 \u662f\uff1aPostgreSQL\uff08\u95dc\u806f\u5f0f\uff09\n\n\u4f60\u7684\u8cc7\u6599\u7d50\u69cb\u7d93\u5e38\u8b8a\u52d5\u55ce\uff1f\uff08\u6bcf\u7bc7\u6587\u7ae0\u6b04\u4f4d\u90fd\u4e0d\u540c\uff09\n  \u2192 \u662f\uff1aMongoDB\uff08\u6587\u4ef6\u578b\uff09\n\n\u4f60\u9700\u8981\u8d85\u9ad8\u901f\u8b80\u53d6\u55ce\uff1f\uff08\u5feb\u53d6\u3001\u6392\u884c\u699c\u3001Session\uff09\n  \u2192 \u662f\uff1aRedis\uff08\u9375\u503c\u578b\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b\uff1a\u4e09\u7a2e\u8cc7\u6599\u5eab\u5b58\u540c\u4e00\u7b46\u300c\u7528\u6236\u300d\u8cc7\u6599<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PostgreSQL<\/strong> &#8212; \u7d50\u69cb\u56b4\u683c\uff0c\u5148\u5b9a\u7fa9\u6b04\u4f4d\u624d\u80fd\u5b58<\/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\">CREATE TABLE users (\n    id SERIAL PRIMARY KEY,       -- \u81ea\u52d5\u905e\u589e\u7684 ID\n    name VARCHAR(<span class=\"hljs-number\">100<\/span>) NOT <span class=\"hljs-keyword\">NULL<\/span>,  -- \u540d\u5b57\uff0c\u4e0d\u80fd\u7a7a\n    email VARCHAR(<span class=\"hljs-number\">255<\/span>) UNIQUE    -- \u4fe1\u7bb1\uff0c\u4e0d\u80fd\u91cd\u8907\n);\n\nINSERT INTO users (name, email) VALUES (<span class=\"hljs-string\">'Alice'<\/span>, <span class=\"hljs-string\">'alice@example.com'<\/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\"><strong>MongoDB<\/strong> &#8212; \u76f4\u63a5\u4e1f JSON \u9032\u53bb<\/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=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">db<\/span><span class=\"hljs-selector-class\">.users<\/span><span class=\"hljs-selector-class\">.insertOne<\/span>({\n    <span class=\"hljs-attribute\">name<\/span>: <span class=\"hljs-string\">\"Alice\"<\/span>,\n    email: <span class=\"hljs-string\">\"alice@example.com\"<\/span>,\n    hobbies: &#91;<span class=\"hljs-string\">\"reading\"<\/span>, <span class=\"hljs-string\">\"coding\"<\/span>]   \/\/ \u60f3\u591a\u52a0\u6b04\u4f4d\uff1f\u76f4\u63a5\u52a0\n})\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><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>Redis<\/strong> &#8212; \u7528 key \u5c0d\u61c9 value\uff0c\u50cf\u5b57\u5178\u4e00\u6a23<\/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=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">SET<\/span> <span class=\"hljs-selector-tag\">user<\/span><span class=\"hljs-selector-pseudo\">:1<\/span><span class=\"hljs-selector-pseudo\">:name<\/span> \"<span class=\"hljs-selector-tag\">Alice<\/span>\"\n<span class=\"hljs-selector-tag\">SET<\/span> <span class=\"hljs-selector-tag\">user<\/span><span class=\"hljs-selector-pseudo\">:1<\/span><span class=\"hljs-selector-pseudo\">:email<\/span> \"<span class=\"hljs-selector-tag\">alice<\/span><span class=\"hljs-keyword\">@example<\/span>.com\"\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><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<h3 class=\"wp-block-heading\">\u7ffb\u8b6f\u5c0d\u7167<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u4f60\u6703\u770b\u5230<\/th>\n<th>\u610f\u601d<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>SERIAL PRIMARY KEY<\/code><\/td>\n<td>\u81ea\u52d5\u7522\u751f\u7684\u552f\u4e00\u7de8\u865f<\/td>\n<\/tr>\n<tr>\n<td><code>NOT NULL<\/code><\/td>\n<td>\u9019\u500b\u6b04\u4f4d\u5fc5\u586b<\/td>\n<\/tr>\n<tr>\n<td><code>UNIQUE<\/code><\/td>\n<td>\u9019\u500b\u6b04\u4f4d\u7684\u503c\u4e0d\u80fd\u91cd\u8907<\/td>\n<\/tr>\n<tr>\n<td><code>VARCHAR(100)<\/code><\/td>\n<td>\u6700\u591a 100 \u5b57\u7684\u6587\u5b57<\/td>\n<\/tr>\n<tr>\n<td><code>insertOne({...})<\/code><\/td>\n<td>\u585e\u4e00\u7b46\u6587\u4ef6\uff08JSON\uff09\u9032 MongoDB<\/td>\n<\/tr>\n<tr>\n<td><code>SET key value<\/code><\/td>\n<td>\u5728 Redis \u5b58\u4e00\u500b\u9375\u503c\u5c0d<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">ACID \u662f\u4ec0\u9ebc\uff08\u77e5\u9053\u5c31\u597d\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f60\u6703\u5728\u8cc7\u6599\u5eab\u6587\u4ef6\u88e1\u5e38\u770b\u5230 ACID\uff0c\u7ffb\u8b6f\u4e00\u4e0b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>A<\/strong>tomicity\uff08\u539f\u5b50\u6027\uff09\uff1a\u4e00\u7d44\u64cd\u4f5c\u8981\u561b\u5168\u6210\u529f\uff0c\u8981\u561b\u5168\u5931\u6557<\/li>\n\n\n<li><strong>C<\/strong>onsistency\uff08\u4e00\u81f4\u6027\uff09\uff1a\u8cc7\u6599\u6c38\u9060\u4fdd\u6301\u5408\u7406\u72c0\u614b<\/li>\n\n\n<li><strong>I<\/strong>solation\uff08\u9694\u96e2\u6027\uff09\uff1a\u591a\u4eba\u540c\u6642\u64cd\u4f5c\u4e0d\u6703\u4e92\u76f8\u5e72\u64fe<\/li>\n\n\n<li><strong>D<\/strong>urability\uff08\u6301\u4e45\u6027\uff09\uff1a\u5b58\u9032\u53bb\u5c31\u4e0d\u6703\u4e1f<\/li>\n\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL \u5929\u751f\u652f\u63f4 ACID\uff0cMongoDB \u548c Redis \u5728\u9019\u65b9\u9762\u6bd4\u8f03\u5f31\u3002\u6240\u4ee5<strong>\u6d89\u53ca\u91d1\u9322\u7684\u7cfb\u7d71<\/strong>\uff08\u96fb\u5546\u3001\u652f\u4ed8\uff09\u5e7e\u4e4e\u90fd\u9078\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. Schema \u8a2d\u8a08\u5be6\u6230\uff1a\u96fb\u5546\u7cfb\u7d71<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b\uff1a\u7528 Python + SQLAlchemy \u5b9a\u7fa9 Schema<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">SQLAlchemy \u662f Python \u6700\u5e38\u7528\u7684\u8cc7\u6599\u5eab\u5de5\u5177\uff0c\u8b93\u4f60\u7528 Python \u985e\u5225\u5b9a\u7fa9\u8cc7\u6599\u8868\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\">from sqlalchemy import Column, Integer, String, Float, ForeignKey, DateTime\nfrom sqlalchemy.orm import declarative_base, relationship\nfrom datetime import datetime\n\nBase = declarative_base()  # \u6240\u6709 Model \u7684\u57fa\u5e95\u985e\u5225\n\nclass User(Base):\n    __tablename__ = \"users\"           # \u5c0d\u61c9\u8cc7\u6599\u5eab\u88e1\u7684 users \u8868\n\n    id = Column(Integer, primary_key=True)   # \u4e3b\u9375\n    name = Column(String(100), nullable=False)  # \u5fc5\u586b\n    email = Column(String(255), unique=True)    # \u4e0d\u80fd\u91cd\u8907\n\n    orders = relationship(\"Order\", back_populates=\"user\")\n    # \u2191 \u9019\u884c\u7684\u610f\u601d\uff1a\u4e00\u500b User \u53ef\u4ee5\u6709\u591a\u7b46 Order\uff08\u4e00\u5c0d\u591a\uff09\n\nclass Product(Base):\n    __tablename__ = \"products\"\n\n    id = Column(Integer, primary_key=True)\n    name = Column(String(200), nullable=False)\n    price = Column(Float, nullable=False)\n\nclass Order(Base):\n    __tablename__ = \"orders\"\n\n    id = Column(Integer, primary_key=True)\n    user_id = Column(Integer, ForeignKey(\"users.id\"))   # \u5916\u9375\uff1a\u6307\u5411 users \u8868\n    product_id = Column(Integer, ForeignKey(\"products.id\"))\n    quantity = Column(Integer, default=1)\n    created_at = Column(DateTime, default=datetime.utcnow)\n\n    user = relationship(\"User\", back_populates=\"orders\")\n    # \u2191 \u53cd\u5411\u95dc\u806f\uff1a\u5f9e Order \u53ef\u4ee5\u627e\u5230\u5c0d\u61c9\u7684 User\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u9010\u884c\u7ffb\u8b6f\u91cd\u9ede<\/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\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">Base = declarative_base()\n<span class=\"hljs-comment\"># \u2191 \u5efa\u7acb\u4e00\u500b\u300c\u57fa\u5e95\u300d\uff0c\u4e4b\u5f8c\u6240\u6709 Model \u90fd\u7e7c\u627f\u5b83<\/span>\n\n__tablename__ = <span class=\"hljs-string\">\"users\"<\/span>\n<span class=\"hljs-comment\"># \u2191 \u9019\u500b Python \u985e\u5225\u5c0d\u61c9\u8cc7\u6599\u5eab\u88e1\u53eb \"users\" \u7684\u8868<\/span>\n\nColumn(Integer, primary_key=<span class=\"hljs-keyword\">True<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u6574\u6578\u6b04\u4f4d\uff0c\u662f\u9019\u5f35\u8868\u7684\u4e3b\u9375\uff08\u552f\u4e00\u8b58\u5225\u78bc\uff09<\/span>\n\nColumn(String(<span class=\"hljs-number\">255<\/span>), unique=<span class=\"hljs-keyword\">True<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u6700\u591a 255 \u5b57\u7684\u6587\u5b57\uff0c\u503c\u4e0d\u80fd\u91cd\u8907<\/span>\n\nForeignKey(<span class=\"hljs-string\">\"users.id\"<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u5916\u9375\uff1a\u9019\u500b\u6b04\u4f4d\u7684\u503c\u5fc5\u9808\u662f users \u8868\u88e1\u67d0\u500b id<\/span>\n\nrelationship(<span class=\"hljs-string\">\"Order\"<\/span>, back_populates=<span class=\"hljs-string\">\"user\"<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u5b9a\u7fa9\u95dc\u806f\uff1a\u8b93\u4f60\u53ef\u4ee5\u7528 user.orders \u53d6\u5f97\u8a72\u7528\u6236\u7684\u6240\u6709\u8a02\u55ae<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><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<h3 class=\"wp-block-heading\">\u95dc\u806f\u5716\uff1a\u770b\u61c2\u8868\u8ddf\u8868\u7684\u95dc\u4fc2<\/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\">users          orders              products\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 id (PK) \u2502\u25c4\u2500\u2500\u2500\u2502 user_id (FK) \u2502    \u2502 id (PK)  \u2502\n\u2502 name    \u2502    \u2502 product_id(FK)\u2502\u2500\u2500\u2500\u25ba\u2502 name     \u2502\n\u2502 email   \u2502    \u2502 quantity     \u2502    \u2502 price    \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518    \u2502 created_at   \u2502    \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n               \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\nPK = Primary Key\uff08\u4e3b\u9375\uff0c\u552f\u4e00\u8b58\u5225\uff09\nFK = Foreign Key\uff08\u5916\u9375\uff0c\u6307\u5411\u53e6\u4e00\u5f35\u8868\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4e00\u500b User \u53ef\u4ee5\u6709\u5f88\u591a Order\uff08\u4e00\u5c0d\u591a\uff09\uff0c\u4e00\u500b Order \u5c0d\u61c9\u4e00\u500b Product\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. \u6b63\u898f\u5316 vs \u53cd\u6b63\u898f\u5316<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u5340\u5206<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>\u6b63\u898f\u5316<\/strong>\uff1a\u62c6\u8868\uff0c\u6d88\u9664\u91cd\u8907\u8cc7\u6599\uff08\u9069\u5408\u300c\u5beb\u591a\u8b80\u5c11\u300d\uff09<\/li>\n\n\n<li><strong>\u53cd\u6b63\u898f\u5316<\/strong>\uff1a\u5408\u8868\uff0c\u5197\u9918\u5132\u5b58\u52a0\u5feb\u67e5\u8a62\uff08\u9069\u5408\u300c\u8b80\u591a\u5beb\u5c11\u300d\uff09<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b\uff1a\u8a02\u55ae\u8981\u986f\u793a\u5546\u54c1\u540d\u7a31<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6b63\u898f\u5316\u505a\u6cd5<\/strong>\uff08\u62c6\u8868\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\"><span><code class=\"hljs\">-- \u67e5\u8a02\u55ae\u6642\u8981 JOIN \u624d\u80fd\u62ff\u5230\u5546\u54c1\u540d\u7a31\nSELECT orders.id, products.name, products.price\nFROM orders\nJOIN products ON orders.product_id = products.id\nWHERE orders.user_id = 1;\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u7ffb\u8b6f\uff1a\u300c\u5f9e orders \u8868\u548c products \u8868\u88e1\uff0c\u7528 product_id \u628a\u5b83\u5011\u95dc\u806f\u8d77\u4f86\uff0c\u627e\u51fa\u7528\u6236 1 \u7684\u6240\u6709\u8a02\u55ae\u3002\u300d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u53cd\u6b63\u898f\u5316\u505a\u6cd5<\/strong>\uff08\u5408\u8868\uff0c\u5197\u9918\u5132\u5b58\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\"><span><code class=\"hljs\">-- \u8a02\u55ae\u8868\u76f4\u63a5\u5b58\u5546\u54c1\u540d\u7a31\u548c\u50f9\u683c\uff08\u4e0d\u7528 JOIN\uff09\nSELECT id, product_name, product_price\nFROM orders\nWHERE user_id = 1;\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u7ffb\u8b6f\uff1a\u300c\u76f4\u63a5\u5f9e orders \u8868\u62ff\uff0c\u56e0\u70ba\u5546\u54c1\u540d\u7a31\u548c\u50f9\u683c\u5df2\u7d93\u8907\u88fd\u4e00\u4efd\u5b58\u5728\u88e1\u9762\u4e86\u3002\u300d<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u600e\u9ebc\u9078<\/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\">\u4f60\u7684\u5834\u666f\u662f\u300c\u8b80\u591a\u5beb\u5c11\u300d\u55ce\uff1f\uff08\u5546\u54c1\u9801\u9762\u3001\u6587\u7ae0\u5217\u8868\uff09\n  \u2192 \u50be\u5411\u53cd\u6b63\u898f\u5316\uff1a\u67e5\u8a62\u5feb\uff0c\u5c11\u505a JOIN\n\n\u4f60\u7684\u5834\u666f\u662f\u300c\u5beb\u591a\u8b80\u5c11\u300d\u55ce\uff1f\uff08\u5f8c\u53f0\u7ba1\u7406\u3001\u8cc7\u6599\u532f\u5165\uff09\n  \u2192 \u50be\u5411\u6b63\u898f\u5316\uff1a\u4fee\u6539\u4e00\u8655\u5c31\u751f\u6548\uff0c\u4e0d\u7528\u5230\u8655\u540c\u6b65\n\n\u4f60\u7684\u5834\u666f\u6d89\u53ca\u91d1\u9322\u6216\u5eab\u5b58\u55ce\uff1f\n  \u2192 \u6b63\u898f\u5316\uff1a\u907f\u514d\u8cc7\u6599\u4e0d\u4e00\u81f4\uff08\u5546\u54c1\u6539\u50f9\u683c\u5f8c\u8a02\u55ae\u9084\u986f\u793a\u820a\u50f9\u683c\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5be6\u52d9\u4e0a\u7684\u505a\u6cd5<\/strong>\uff1a\u5148\u6b63\u898f\u5316\u8a2d\u8a08\uff0c\u9047\u5230\u67e5\u8a62\u6548\u80fd\u554f\u984c\u518d\u5c40\u90e8\u53cd\u6b63\u898f\u5316\u3002\u4e0d\u8981\u4e00\u958b\u59cb\u5c31\u70ba\u4e86\u6548\u80fd\u72a7\u7272\u8cc7\u6599\u4e00\u81f4\u6027\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">5. \u7d22\u5f15\u7b56\u7565\uff1a\u8b93\u67e5\u8a62\u5feb\u4e00\u767e\u500d<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d22\u5f15\u50cf\u66f8\u7684\u300c\u76ee\u9304\u300d\uff0c\u8b93\u8cc7\u6599\u5eab\u4e0d\u7528\u7ffb\u904d\u6574\u672c\u66f8\u5c31\u80fd\u627e\u5230\u4f60\u8981\u7684\u9801\u9762\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6c92\u6709\u7d22\u5f15 vs \u6709\u7d22\u5f15<\/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\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">\u6c92\u6709\u7d22\u5f15\uff08\u5168\u8868\u6383\u63cf\uff09\uff1a\n  \u5f9e\u7b2c <span class=\"hljs-number\">1<\/span> \u7b46\u6383\u5230\u7b2c <span class=\"hljs-number\">100<\/span> \u842c\u7b46\uff0c\u627e email = <span class=\"hljs-string\">'alice@example.com'<\/span>\n  \u2192 \u5f88\u6162\n\n\u6709\u7d22\u5f15\uff1a\n  \u76f4\u63a5\u8df3\u5230 <span class=\"hljs-string\">'alice@example.com'<\/span> \u6240\u5728\u7684\u4f4d\u7f6e\n  \u2192 \u5f88\u5feb\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><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<h3 class=\"wp-block-heading\">B-Tree \u7d22\u5f15\u539f\u7406\uff08\u6982\u5ff5\u5c64\u9762\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f60\u4e0d\u9700\u8981\u7406\u89e3\u6f14\u7b97\u6cd5\u7d30\u7bc0\uff0c\u53ea\u9700\u8981\u77e5\u9053\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=\"HTML, XML\" data-shcb-language-slug=\"xml\"><span><code class=\"hljs language-xml\">B-Tree \u7d22\u5f15\u50cf\u4e00\u68f5\u5012\u904e\u4f86\u7684\u6a39\uff1a\n\n         &#91;M]\n        \/   \\\n    &#91;D,H]   &#91;Q,T]\n    \/ | \\    \/ | \\\n  \u8cc7\u6599 \u8cc7\u6599 \u8cc7\u6599 \u8cc7\u6599\n\n\u8981\u627e \"H\"\uff1a\n  1. \u770b\u6839\u7bc0\u9ede \u2192 H <span class=\"hljs-tag\">&lt; <span class=\"hljs-attr\">M<\/span> \u2192 \u8d70\u5de6\u908a\n  <span class=\"hljs-attr\">2.<\/span> \u770b\u5de6\u7bc0\u9ede \u2192 <span class=\"hljs-attr\">H<\/span> = <span class=\"hljs-string\">H<\/span> \u2192 \u627e\u5230\u4e86\uff01\n\n<span class=\"hljs-attr\">100<\/span> \u842c\u7b46\u8cc7\u6599\u53ea\u8981\u6bd4\u5c0d\u7d04 <span class=\"hljs-attr\">20<\/span> \u6b21\u5c31\u80fd\u627e\u5230\uff08\u4e0d\u662f <span class=\"hljs-attr\">100<\/span> \u842c\u6b21\uff09\n<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">HTML, XML<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">xml<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u7528 SQLAlchemy \u5efa\u7acb\u7d22\u5f15<\/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\">from sqlalchemy import Column, Integer, String, Index\n\nclass User(Base):\n    __tablename__ = \"users\"\n\n    id = Column(Integer, primary_key=True)\n    name = Column(String(100))\n    email = Column(String(255), unique=True, index=True)\n    #                                       \u2191 \u52a0\u4e0a index=True \u5c31\u5efa\u4e86\u7d22\u5f15\n    city = Column(String(100))\n    age = Column(Integer)\n\n# \u8907\u5408\u7d22\u5f15\uff1a\u540c\u6642\u7528\u5169\u500b\u6b04\u4f4d\u67e5\u8a62\u6642\u5f88\u6709\u7528\nIndex(\"idx_city_age\", User.city, User.age)\n# \u2191 \u7576\u67e5\u8a62\u662f WHERE city = 'Taipei' AND age &gt; 20 \u6642\uff0c\u9019\u500b\u7d22\u5f15\u6703\u52a0\u901f\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u9010\u884c\u7ffb\u8b6f<\/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\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">index=<span class=\"hljs-keyword\">True<\/span>\n<span class=\"hljs-comment\"># \u2191 \u66ff\u9019\u500b\u6b04\u4f4d\u5efa\u7acb\u7d22\u5f15\uff0c\u7528\u9019\u500b\u6b04\u4f4d\u67e5\u8a62\u6642\u6703\u8b8a\u5feb<\/span>\n\nIndex(<span class=\"hljs-string\">\"idx_city_age\"<\/span>, User.city, User.age)\n<span class=\"hljs-comment\"># \u2191 \u5efa\u7acb\u300c\u8907\u5408\u7d22\u5f15\u300d\uff0c\u540d\u5b57\u53eb idx_city_age<\/span>\n<span class=\"hljs-comment\">#   \u7576\u4f60\u540c\u6642\u7528 city \u548c age \u67e5\u8a62\u6642\u6703\u52a0\u901f<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><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<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u8a72\u52a0\u7d22\u5f15\u3001\u4ec0\u9ebc\u6642\u5019\u4e0d\u8a72<\/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\">\u8a72\u52a0\u7d22\u5f15\u7684\u60c5\u6cc1\uff1a\n  - WHERE \u689d\u4ef6\u5e38\u7528\u7684\u6b04\u4f4d\uff08\u5982 email, user_id\uff09\n  - JOIN \u7684\u5916\u9375\u6b04\u4f4d\n  - ORDER BY \u6392\u5e8f\u7684\u6b04\u4f4d\n\n\u4e0d\u8a72\u52a0\u7d22\u5f15\u7684\u60c5\u6cc1\uff1a\n  - \u8868\u5f88\u5c0f\uff08\u5e7e\u767e\u7b46\uff09\uff0c\u5168\u8868\u6383\u63cf\u53cd\u800c\u66f4\u5feb\n  - \u5f88\u5c11\u7528\u4f86\u67e5\u8a62\u7684\u6b04\u4f4d\n  - \u7d93\u5e38\u5927\u91cf\u5beb\u5165\u7684\u8868\uff08\u7d22\u5f15\u6703\u62d6\u6162\u5beb\u5165\u901f\u5ea6\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u8986\u84cb\u7d22\u5f15\uff08\u77e5\u9053\u5c31\u597d\uff09<\/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\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u5047\u8a2d\u6709\u7d22\u5f15 (city, age, name)\nSELECT name FROM users WHERE city = <span class=\"hljs-string\">'Taipei'<\/span> AND age &gt; <span class=\"hljs-number\">20<\/span>;\n-- \u2191 \u6240\u6709\u9700\u8981\u7684\u6b04\u4f4d\u90fd\u5728\u7d22\u5f15\u88e1\uff0c\u8cc7\u6599\u5eab\u9023\u8868\u90fd\u4e0d\u7528\u67e5\n--   \u9019\u53eb\u300c\u8986\u84cb\u7d22\u5f15\u300d\uff0c\u662f\u6700\u5feb\u7684\u67e5\u8a62\u65b9\u5f0f\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><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<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">6. \u5feb\u53d6\u5c64\u8a2d\u8a08<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u9700\u8981\u5feb\u53d6<\/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\">\u6c92\u6709\u5feb\u53d6\uff1a\n  \u6bcf\u6b21\u8acb\u6c42 \u2192 \u67e5\u8cc7\u6599\u5eab \u2192 \u56de\u61c9\n  100 \u500b\u4eba\u540c\u6642\u770b\u540c\u4e00\u500b\u5546\u54c1 \u2192 \u8cc7\u6599\u5eab\u88ab\u67e5 100 \u6b21\n\n\u6709\u5feb\u53d6\uff1a\n  \u7b2c 1 \u6b21\u8acb\u6c42 \u2192 \u67e5\u8cc7\u6599\u5eab \u2192 \u5b58\u5230\u5feb\u53d6 \u2192 \u56de\u61c9\n  \u5f8c\u7e8c 99 \u6b21 \u2192 \u76f4\u63a5\u5f9e\u5feb\u53d6\u62ff \u2192 \u56de\u61c9\n  \u8cc7\u6599\u5eab\u53ea\u88ab\u67e5 1 \u6b21\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Redis \u662f\u6700\u5e38\u898b\u7684\u5feb\u53d6\u5de5\u5177\uff0c\u8b80\u53d6\u901f\u5ea6\u5728\u5fae\u79d2\u7b49\u7d1a\uff08\u6bd4\u8cc7\u6599\u5eab\u5feb 100 \u500d\u4ee5\u4e0a\uff09\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Cache-Aside Pattern\uff08\u6700\u5e38\u898b\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u662f\u4f60\u5728\u7a0b\u5f0f\u78bc\u88e1\u6700\u5e38\u770b\u5230\u7684\u5feb\u53d6\u6a21\u5f0f\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-9\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import redis\nimport json\n\nr = redis.Redis(host=<span class=\"hljs-string\">\"localhost\"<\/span>, port=<span class=\"hljs-number\">6379<\/span>, db=<span class=\"hljs-number\">0<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u9023\u63a5\u672c\u6a5f\u7684 Redis<\/span>\n\ndef get_product(product_id: int) -&gt; dict:\n    cache_key = f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>\n    <span class=\"hljs-comment\"># \u2191 \u5feb\u53d6\u7684 key\uff0c\u4f8b\u5982 \"product:42\"<\/span>\n\n    <span class=\"hljs-comment\"># 1. \u5148\u67e5\u5feb\u53d6<\/span>\n    cached = r.get(cache_key)\n    <span class=\"hljs-keyword\">if<\/span> cached:\n        <span class=\"hljs-keyword\">return<\/span> json.loads(cached)\n        <span class=\"hljs-comment\"># \u2191 \u5feb\u53d6\u547d\u4e2d\uff01\u76f4\u63a5\u56de\u50b3\uff08\u4e0d\u67e5\u8cc7\u6599\u5eab\uff09<\/span>\n\n    <span class=\"hljs-comment\"># 2. \u5feb\u53d6\u6c92\u6709\uff0c\u67e5\u8cc7\u6599\u5eab<\/span>\n    product = db.query(Product).filter(Product.id == product_id).first()\n\n    <span class=\"hljs-comment\"># 3. \u5beb\u5165\u5feb\u53d6\uff0c\u8a2d\u5b9a 300 \u79d2\u904e\u671f<\/span>\n    r.setex(cache_key, <span class=\"hljs-number\">300<\/span>, json.dumps(product.to_dict()))\n    <span class=\"hljs-comment\"># \u2191 setex = SET + EXpire\uff0c\u5b58\u503c\u4e26\u8a2d\u5b9a\u904e\u671f\u6642\u9593<\/span>\n\n    <span class=\"hljs-keyword\">return<\/span> product.to_dict()\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><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<h3 class=\"wp-block-heading\">\u9010\u884c\u7ffb\u8b6f<\/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\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">r = redis.Redis(host=<span class=\"hljs-string\">\"localhost\"<\/span>, port=<span class=\"hljs-number\">6379<\/span>, db=<span class=\"hljs-number\">0<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u9023\u5230 Redis \u4f3a\u670d\u5668\uff08\u9810\u8a2d port 6379\uff0c\u7528\u7b2c 0 \u865f\u8cc7\u6599\u5eab\uff09<\/span>\n\nr.get(cache_key)\n<span class=\"hljs-comment\"># \u2191 \u5f9e Redis \u62ff\u8cc7\u6599\uff0c\u6c92\u6709\u7684\u8a71\u56de\u50b3 None<\/span>\n\nr.setex(cache_key, <span class=\"hljs-number\">300<\/span>, json.dumps(data))\n<span class=\"hljs-comment\"># \u2191 \u5b58\u8cc7\u6599\u5230 Redis\uff0c300 \u79d2\u5f8c\u81ea\u52d5\u904e\u671f\u522a\u9664<\/span>\n<span class=\"hljs-comment\">#   json.dumps \u662f\u628a Python \u5b57\u5178\u8f49\u6210 JSON \u5b57\u4e32<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><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<h3 class=\"wp-block-heading\">\u4e09\u7a2e\u5feb\u53d6\u7b56\u7565\u6bd4\u8f03<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u7b56\u7565<\/th>\n<th>\u904b\u4f5c\u65b9\u5f0f<\/th>\n<th>\u9069\u7528\u5834\u666f<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Cache-Aside<\/strong><\/td>\n<td>\u8b80\uff1a\u5148\u67e5\u5feb\u53d6\uff0c\u6c92\u6709\u624d\u67e5 DB \u518d\u5beb\u5165\u5feb\u53d6<\/td>\n<td>\u6700\u5e38\u7528\uff0c\u9069\u5408\u5927\u90e8\u5206\u8b80\u591a\u5834\u666f<\/td>\n<\/tr>\n<tr>\n<td><strong>Write-Through<\/strong><\/td>\n<td>\u5beb\uff1a\u540c\u6642\u5beb DB \u548c\u5feb\u53d6<\/td>\n<td>\u9700\u8981\u5feb\u53d6\u6c38\u9060\u6700\u65b0\u7684\u5834\u666f<\/td>\n<\/tr>\n<tr>\n<td><strong>Write-Behind<\/strong><\/td>\n<td>\u5beb\uff1a\u5148\u5beb\u5feb\u53d6\uff0c\u4e4b\u5f8c\u518d\u6279\u6b21\u5beb DB<\/td>\n<td>\u5beb\u5165\u91cf\u6975\u5927\u7684\u5834\u666f\uff08\u5982\u8a08\u6578\u5668\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b\uff1a\u4e09\u7a2e\u7b56\u7565\u7684 Python \u5beb\u6cd5<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cache-Aside<\/strong>\uff08\u4e0a\u9762\u5df2\u7d93\u5c55\u793a\u904e\uff0c\u9019\u662f\u6700\u5e38\u898b\u7684\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Write-Through<\/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-11\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">def update_product(product_id: int, data: dict):\n    <span class=\"hljs-comment\"># \u540c\u6642\u66f4\u65b0\u8cc7\u6599\u5eab\u548c\u5feb\u53d6<\/span>\n    db.query(Product).filter(Product.id == product_id).update(data)\n    db.commit()\n    <span class=\"hljs-comment\"># \u2191 \u5148\u5beb\u8cc7\u6599\u5eab<\/span>\n\n    r.setex(f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>, <span class=\"hljs-number\">300<\/span>, json.dumps(data))\n    <span class=\"hljs-comment\"># \u2191 \u518d\u5beb\u5feb\u53d6\uff08\u4fdd\u6301\u5feb\u53d6\u6700\u65b0\uff09<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><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\"><strong>Write-Behind<\/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-12\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">def increment_view_count(product_id: int):\n    r.incr(f<span class=\"hljs-string\">\"product:{product_id}:views\"<\/span>)\n    <span class=\"hljs-comment\"># \u2191 \u5148\u53ea\u5beb Redis\uff08\u8d85\u5feb\uff09<\/span>\n    <span class=\"hljs-comment\"># \u8cc7\u6599\u5eab\u7531\u80cc\u666f\u6392\u7a0b\u5b9a\u671f\u540c\u6b65\uff08\u4f8b\u5982\u6bcf 5 \u5206\u9418\uff09<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><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<h3 class=\"wp-block-heading\">\u5feb\u53d6\u5e38\u898b\u554f\u984c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f60\u5728\u770b\u7cfb\u7d71\u8a2d\u8a08\u6587\u4ef6\u6642\u6703\u9047\u5230\u9019\u4e09\u500b\u8853\u8a9e\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u5feb\u53d6\u7a7f\u900f<\/strong>\uff08Cache Penetration\uff09<\/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\">\u554f\u984c\uff1a\u67e5\u8a62\u4e0d\u5b58\u5728\u7684\u8cc7\u6599\uff0c\u5feb\u53d6\u6c38\u9060\u6c92\u6709\uff0c\u6bcf\u6b21\u90fd\u6253 DB\n\u4f8b\u5982\uff1a\u60e1\u610f\u8acb\u6c42 product_id = -1\uff08\u6839\u672c\u4e0d\u5b58\u5728\uff09\n\n\u89e3\u6cd5\uff1a\u67e5\u4e0d\u5230\u4e5f\u5b58\u4e00\u500b\u7a7a\u503c\u5230\u5feb\u53d6\n<\/code><\/span><\/pre><\/div>\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-13\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">def get_product_safe(product_id: int):\n    cached = r.get(f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>)\n    <span class=\"hljs-keyword\">if<\/span> cached == <span class=\"hljs-string\">b\"NULL\"<\/span>:\n        <span class=\"hljs-keyword\">return<\/span> None          <span class=\"hljs-comment\"># \u5df2\u77e5\u4e0d\u5b58\u5728\uff0c\u4e0d\u67e5 DB<\/span>\n    <span class=\"hljs-keyword\">if<\/span> cached:\n        <span class=\"hljs-keyword\">return<\/span> json.loads(cached)\n\n    product = db.query(Product).filter(Product.id == product_id).first()\n    <span class=\"hljs-keyword\">if<\/span> product is None:\n        r.setex(f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>, <span class=\"hljs-number\">60<\/span>, <span class=\"hljs-string\">\"NULL\"<\/span>)\n        <span class=\"hljs-comment\"># \u2191 \u4e0d\u5b58\u5728\u4e5f\u5b58\u8d77\u4f86\uff0c60 \u79d2\u904e\u671f<\/span>\n        <span class=\"hljs-keyword\">return<\/span> None\n\n    r.setex(f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>, <span class=\"hljs-number\">300<\/span>, json.dumps(product.to_dict()))\n    <span class=\"hljs-keyword\">return<\/span> product.to_dict()\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><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\"><strong>\u5feb\u53d6\u96ea\u5d29<\/strong>\uff08Cache Avalanche\uff09<\/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\">\u554f\u984c\uff1a\u5927\u91cf\u5feb\u53d6\u540c\u6642\u904e\u671f\uff0c\u77ac\u9593\u6240\u6709\u8acb\u6c42\u90fd\u6253 DB\n\u4f8b\u5982\uff1a\u6240\u6709\u5546\u54c1\u5feb\u53d6\u90fd\u8a2d 300 \u79d2\uff0c300 \u79d2\u5f8c\u5168\u90e8\u540c\u6642\u5931\u6548\n\n\u89e3\u6cd5\uff1a\u904e\u671f\u6642\u9593\u52a0\u4e0a\u96a8\u6a5f\u503c\n<\/code><\/span><\/pre><\/div>\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-14\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import random\n\nttl = <span class=\"hljs-number\">300<\/span> + random.randint(<span class=\"hljs-number\">0<\/span>, <span class=\"hljs-number\">60<\/span>)\n<span class=\"hljs-comment\"># \u2191 \u904e\u671f\u6642\u9593\u5728 300~360 \u79d2\u4e4b\u9593\u96a8\u6a5f<\/span>\n<span class=\"hljs-comment\">#   \u9019\u6a23\u4e0d\u540c\u5546\u54c1\u7684\u5feb\u53d6\u4e0d\u6703\u540c\u6642\u5931\u6548<\/span>\nr.setex(cache_key, ttl, data)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><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\"><strong>\u5feb\u53d6\u64ca\u7a7f<\/strong>\uff08Cache Breakdown\uff09<\/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\">\u554f\u984c\uff1a\u67d0\u500b\u8d85\u71b1\u9580\u7684\u5feb\u53d6\u904e\u671f\uff0c\u77ac\u9593\u5927\u91cf\u8acb\u6c42\u540c\u6642\u67e5 DB\n\u4f8b\u5982\uff1a\u9996\u9801\u63a8\u85a6\u5546\u54c1\u7684\u5feb\u53d6\u525b\u597d\u904e\u671f\n\n\u89e3\u6cd5\uff1a\u7528\u9396\u8b93\u53ea\u6709\u4e00\u500b\u8acb\u6c42\u53bb\u67e5 DB\uff0c\u5176\u4ed6\u8acb\u6c42\u7b49\u5f85\n<\/code><\/span><\/pre><\/div>\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-15\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">def get_hot_product(product_id: int):\n    cached = r.get(f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>)\n    <span class=\"hljs-keyword\">if<\/span> cached:\n        <span class=\"hljs-keyword\">return<\/span> json.loads(cached)\n\n    lock_key = f<span class=\"hljs-string\">\"lock:product:{product_id}\"<\/span>\n    <span class=\"hljs-keyword\">if<\/span> r.set(lock_key, <span class=\"hljs-string\">\"1\"<\/span>, nx=<span class=\"hljs-keyword\">True<\/span>, ex=<span class=\"hljs-number\">5<\/span>):\n        <span class=\"hljs-comment\"># \u2191 nx=True \u8868\u793a\u300c\u53ea\u6709\u7576 key \u4e0d\u5b58\u5728\u6642\u624d\u8a2d\u5b9a\u300d<\/span>\n        <span class=\"hljs-comment\">#   ex=5 \u8868\u793a\u9396\u6700\u591a\u5b58\u5728 5 \u79d2\uff08\u9632\u6b62\u6b7b\u9396\uff09<\/span>\n        <span class=\"hljs-comment\">#   \u53ea\u6709\u4e00\u500b\u8acb\u6c42\u80fd\u62ff\u5230\u9019\u628a\u9396<\/span>\n        product = db.query(Product).filter(Product.id == product_id).first()\n        r.setex(f<span class=\"hljs-string\">\"product:{product_id}\"<\/span>, <span class=\"hljs-number\">300<\/span>, json.dumps(product.to_dict()))\n        r.delete(lock_key)\n        <span class=\"hljs-keyword\">return<\/span> product.to_dict()\n    <span class=\"hljs-keyword\">else<\/span>:\n        import time\n        time.sleep(<span class=\"hljs-number\">0.1<\/span>)\n        <span class=\"hljs-keyword\">return<\/span> get_hot_product(product_id)\n        <span class=\"hljs-comment\"># \u2191 \u6c92\u62ff\u5230\u9396\u7684\u8acb\u6c42\uff0c\u7b49\u4e00\u4e0b\u518d\u8a66<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><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\">7. \u8cc7\u6599\u4e00\u81f4\u6027\u8207 CAP \u5b9a\u7406<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">CAP \u5b9a\u7406\u7684\u76f4\u89c0\u7406\u89e3<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5206\u6563\u5f0f\u7cfb\u7d71\uff08\u591a\u53f0\u6a5f\u5668\uff09\u53ea\u80fd\u4e09\u9078\u4e8c\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\">C - Consistency\uff08\u4e00\u81f4\u6027\uff09\uff1a\u6bcf\u53f0\u6a5f\u5668\u770b\u5230\u7684\u8cc7\u6599\u90fd\u4e00\u6a23\nA - Availability\uff08\u53ef\u7528\u6027\uff09\uff1a\u6bcf\u6b21\u8acb\u6c42\u90fd\u80fd\u5f97\u5230\u56de\u61c9\nP - Partition Tolerance\uff08\u5206\u5340\u5bb9\u5fcd\uff09\uff1a\u7db2\u8def\u65b7\u7dda\u6642\u7cfb\u7d71\u9084\u80fd\u904b\u4f5c\n\n        C\n       \/ \\\n      \/   \\\n     A --- P\n\n\u73fe\u5be6\u4e2d P \u662f\u5fc5\u9078\u7684\uff08\u7db2\u8def\u4e00\u5b9a\u6703\u51fa\u554f\u984c\uff09\uff0c\n\u6240\u4ee5\u5be6\u969b\u4e0a\u662f\u5728 C \u548c A \u4e4b\u9593\u53d6\u6368\u3002\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u7ffb\u8b6f\u5c0d\u7167<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u9078\u64c7<\/th>\n<th>\u767d\u8a71<\/th>\n<th>\u4ee3\u8868<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>CP\uff08\u9078\u4e00\u81f4\u6027\uff09<\/td>\n<td>\u5be7\u53ef\u56de\u61c9\u6162\uff0c\u4e5f\u4e0d\u80fd\u7d66\u932f\u8aa4\u8cc7\u6599<\/td>\n<td>\u9280\u884c\u8f49\u5e33\u3001\u5eab\u5b58\u6263\u6e1b<\/td>\n<\/tr>\n<tr>\n<td>AP\uff08\u9078\u53ef\u7528\u6027\uff09<\/td>\n<td>\u5be7\u53ef\u8cc7\u6599\u7a0d\u5fae\u904e\u671f\uff0c\u4e5f\u8981\u5feb\u901f\u56de\u61c9<\/td>\n<td>\u793e\u7fa4\u5a92\u9ad4\u52d5\u614b\u3001\u5546\u54c1\u700f\u89bd\u6578<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u7d42\u4e00\u81f4\u6027 vs \u5f37\u4e00\u81f4\u6027<\/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\">\u5f37\u4e00\u81f4\u6027\uff1a\n  \u5beb\u5165\u5f8c\uff0c\u6240\u6709\u4eba\u7acb\u523b\u770b\u5230\u65b0\u8cc7\u6599\n  \u4f8b\uff1a\u9280\u884c\u8f49\u5e33\uff0c\u8f49\u5b8c\u9322\u9918\u984d\u7acb\u523b\u66f4\u65b0\n\n\u6700\u7d42\u4e00\u81f4\u6027\uff1a\n  \u5beb\u5165\u5f8c\uff0c\u53ef\u80fd\u6709\u5e7e\u79d2\u5ef6\u9072\u624d\u540c\u6b65\u5230\u6240\u6709\u7bc0\u9ede\n  \u4f8b\uff1a\u793e\u7fa4\u8cbc\u6587\u7684\u6309\u8b9a\u6578\uff0c\u4e0d\u540c\u4eba\u53ef\u80fd\u77ed\u66ab\u770b\u5230\u4e0d\u540c\u6578\u5b57\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u7a0b\u5f0f\u78bc\u88e1\u6709\u300ceventual consistency\u300d\u7684\u8a3b\u89e3\uff0c\u5c31\u662f\u5728\u8aaa\u300c\u9019\u908a\u5141\u8a31\u77ed\u66ab\u7684\u8cc7\u6599\u4e0d\u4e00\u81f4\u300d\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">8. \u5b8c\u6574\u5be6\u6230\uff1a\u96fb\u5546\u5546\u54c1\u67e5\u8a62\u7cfb\u7d71<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u628a\u4ee5\u4e0a\u6240\u6709\u6982\u5ff5\u6574\u5408\u6210\u4e00\u500b\u5b8c\u6574\u7bc4\u4f8b\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\u96fb\u5546\u5546\u54c1\u67e5\u8a62\u7cfb\u7d71\n\u7528\u5230\uff1aSQLAlchemy\uff08\u8cc7\u6599\u5eab\uff09+ Redis\uff08\u5feb\u53d6\uff09+ Cache-Aside Pattern\n\"\"\"\nfrom sqlalchemy import create_engine, Column, Integer, String, Float, Index\nfrom sqlalchemy.orm import declarative_base, Session\nimport redis\nimport json\nimport random\n\n# --- \u8cc7\u6599\u5eab\u8a2d\u5b9a ---\nengine = create_engine(\"postgresql:\/\/user:pass@localhost\/shop\")\n# \u2191 \u9023\u63a5 PostgreSQL \u8cc7\u6599\u5eab\uff0c\u8cc7\u6599\u5eab\u540d\u7a31\u53eb shop\nBase = declarative_base()\n\n# --- Redis \u8a2d\u5b9a ---\ncache = redis.Redis(host=\"localhost\", port=6379, db=0)\n# \u2191 \u9023\u63a5 Redis\uff0c\u7528\u4f86\u505a\u5feb\u53d6\n\n# --- Schema \u5b9a\u7fa9 ---\nclass Product(Base):\n    __tablename__ = \"products\"\n\n    id = Column(Integer, primary_key=True)\n    name = Column(String(200), nullable=False)\n    price = Column(Float, nullable=False)\n    category = Column(String(100), index=True)\n    # \u2191 category \u52a0\u4e86\u7d22\u5f15\uff0c\u7528\u5206\u985e\u67e5\u8a62\u6642\u6703\u5feb\u5f88\u591a\n\n# \u8907\u5408\u7d22\u5f15\uff1a\u5e38\u4e00\u8d77\u67e5\u7684\u6b04\u4f4d\u653e\u5728\u540c\u4e00\u500b\u7d22\u5f15\nIndex(\"idx_category_price\", Product.category, Product.price)\n# \u2191 \u52a0\u901f WHERE category = 'electronics' ORDER BY price \u9019\u985e\u67e5\u8a62\n\n# --- \u5546\u54c1\u67e5\u8a62\uff08\u542b\u5feb\u53d6\uff09 ---\ndef get_product_by_id(product_id: int) -&gt; dict | None:\n    \"\"\"\n    Cache-Aside Pattern\uff1a\n    1. \u5148\u67e5 Redis \u5feb\u53d6\n    2. \u6c92\u6709\u5c31\u67e5 PostgreSQL\n    3. \u67e5\u5230\u5f8c\u5beb\u56de\u5feb\u53d6\n    \"\"\"\n    cache_key = f\"product:{product_id}\"\n\n    # \u6b65\u9a5f 1\uff1a\u67e5\u5feb\u53d6\n    cached = cache.get(cache_key)\n    if cached:\n        if cached == b\"NULL\":\n            return None  # \u5df2\u77e5\u4e0d\u5b58\u5728\u7684\u5546\u54c1\uff08\u9632\u5feb\u53d6\u7a7f\u900f\uff09\n        return json.loads(cached)\n\n    # \u6b65\u9a5f 2\uff1a\u67e5\u8cc7\u6599\u5eab\n    with Session(engine) as session:\n        product = session.query(Product).filter(\n            Product.id == product_id\n        ).first()\n\n    # \u6b65\u9a5f 3\uff1a\u5beb\u5165\u5feb\u53d6\n    if product is None:\n        cache.setex(cache_key, 60, \"NULL\")\n        # \u2191 \u5546\u54c1\u4e0d\u5b58\u5728\u4e5f\u5feb\u53d6 60 \u79d2\uff08\u9632\u7a7f\u900f\uff09\n        return None\n\n    result = {\n        \"id\": product.id,\n        \"name\": product.name,\n        \"price\": product.price,\n        \"category\": product.category,\n    }\n\n    ttl = 300 + random.randint(0, 60)\n    # \u2191 \u96a8\u6a5f\u904e\u671f\u6642\u9593 300~360 \u79d2\uff08\u9632\u96ea\u5d29\uff09\n    cache.setex(cache_key, ttl, json.dumps(result))\n\n    return result\n\n# --- \u4f9d\u5206\u985e\u67e5\u8a62\u5546\u54c1\u5217\u8868 ---\ndef get_products_by_category(category: str) -&gt; list&#91;dict]:\n    \"\"\"\n    \u5217\u8868\u67e5\u8a62\u901a\u5e38\u4e0d\u5feb\u53d6\u6bcf\u4e00\u7b46\uff0c\u800c\u662f\u5feb\u53d6\u6574\u500b\u67e5\u8a62\u7d50\u679c\n    \"\"\"\n    cache_key = f\"products:category:{category}\"\n\n    cached = cache.get(cache_key)\n    if cached:\n        return json.loads(cached)\n\n    with Session(engine) as session:\n        products = session.query(Product).filter(\n            Product.category == category\n        ).order_by(Product.price).all()\n        # \u2191 \u9019\u500b\u67e5\u8a62\u6703\u7528\u5230 idx_category_price \u8907\u5408\u7d22\u5f15\n\n    result = &#91;\n        {\"id\": p.id, \"name\": p.name, \"price\": p.price}\n        for p in products\n    ]\n\n    ttl = 120 + random.randint(0, 30)\n    cache.setex(cache_key, ttl, json.dumps(result))\n\n    return result\n\n# --- \u66f4\u65b0\u5546\u54c1\uff08Write-Through\uff09 ---\ndef update_product(product_id: int, name: str, price: float):\n    \"\"\"\n    Write-Through\uff1a\u540c\u6642\u66f4\u65b0\u8cc7\u6599\u5eab\u548c\u5feb\u53d6\n    \"\"\"\n    with Session(engine) as session:\n        product = session.query(Product).filter(\n            Product.id == product_id\n        ).first()\n\n        if product:\n            product.name = name\n            product.price = price\n            session.commit()\n            # \u2191 \u5148\u66f4\u65b0\u8cc7\u6599\u5eab\n\n            result = {\n                \"id\": product.id,\n                \"name\": product.name,\n                \"price\": product.price,\n                \"category\": product.category,\n            }\n            cache.setex(\n                f\"product:{product_id}\",\n                300,\n                json.dumps(result)\n            )\n            # \u2191 \u518d\u66f4\u65b0\u5feb\u53d6\uff08\u78ba\u4fdd\u5feb\u53d6\u8ddf DB \u4e00\u81f4\uff09\n\n            # \u6e05\u9664\u5206\u985e\u5217\u8868\u5feb\u53d6\uff08\u56e0\u70ba\u5546\u54c1\u8cc7\u6599\u8b8a\u4e86\uff09\n            cache.delete(f\"products:category:{product.category}\")\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u9019\u6bb5\u7a0b\u5f0f\u78bc\u505a\u4e86\u4ec0\u9ebc<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li>\u7528 SQLAlchemy \u5b9a\u7fa9\u4e86 <code>Product<\/code> \u8868\u7684 Schema\uff0c\u5305\u542b\u7d22\u5f15\u8a2d\u5b9a<\/li>\n\n\n<li><code>get_product_by_id<\/code> \u5be6\u4f5c\u4e86 Cache-Aside Pattern\uff0c\u4e26\u9632\u7bc4\u5feb\u53d6\u7a7f\u900f\u548c\u96ea\u5d29<\/li>\n\n\n<li><code>get_products_by_category<\/code> \u5c55\u793a\u4e86\u5217\u8868\u67e5\u8a62\u7684\u5feb\u53d6\u7b56\u7565<\/li>\n\n\n<li><code>update_product<\/code> \u5be6\u4f5c\u4e86 Write-Through\uff0c\u66f4\u65b0\u6642\u540c\u6b65 DB \u548c\u5feb\u53d6<\/li>\n\n<\/ol>\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\">\u770b\u5230\u8cc7\u6599\u5c64\u76f8\u95dc\u7684\u7a0b\u5f0f\u78bc\u6642\uff0c\u78ba\u8a8d\u9019\u4e9b\u91cd\u9ede\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u8cc7\u6599\u5eab\u9078\u578b<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u6709\u9322\u76f8\u95dc\u7684\u908f\u8f2f\u55ce\uff1f\u61c9\u8a72\u7528\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\uff08PostgreSQL\/MySQL\uff09<\/li>\n\n\n<li>[ ] Schema \u6703\u7d93\u5e38\u8b8a\u52d5\u55ce\uff1f\u53ef\u4ee5\u8003\u616e MongoDB<\/li>\n\n\n<li>[ ] \u9700\u8981\u8d85\u5feb\u8b80\u53d6\u55ce\uff1fRedis \u9069\u5408\u505a\u5feb\u53d6\u6216\u6392\u884c\u699c<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Schema \u8a2d\u8a08<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u8868\u4e4b\u9593\u7684\u95dc\u806f\uff08ForeignKey\uff09\u5408\u7406\u55ce\uff1f<\/li>\n\n\n<li>[ ] \u6709\u6c92\u6709\u5fc5\u8981\u7684 NOT NULL \u548c UNIQUE \u7d04\u675f\uff1f<\/li>\n\n\n<li>[ ] \u662f\u6b63\u898f\u5316\u9084\u662f\u53cd\u6b63\u898f\u5316\uff1f\u8ddf\u4f7f\u7528\u5834\u666f\u5339\u914d\u55ce\uff1f<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u7d22\u5f15<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] WHERE \u5e38\u7528\u7684\u6b04\u4f4d\u6709\u52a0\u7d22\u5f15\u55ce\uff1f<\/li>\n\n\n<li>[ ] \u662f\u4e0d\u662f\u52a0\u592a\u591a\u7d22\u5f15\u4e86\uff1f\uff08\u6703\u62d6\u6162\u5beb\u5165\uff09<\/li>\n\n\n<li>[ ] \u8907\u5408\u7d22\u5f15\u7684\u6b04\u4f4d\u9806\u5e8f\u5c0d\u55ce\uff1f\uff08\u6700\u5e38\u904e\u6ffe\u7684\u653e\u524d\u9762\uff09<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u5feb\u53d6<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u7528\u4e86\u4ec0\u9ebc\u5feb\u53d6\u7b56\u7565\uff1f\uff08Cache-Aside \/ Write-Through \/ Write-Behind\uff09<\/li>\n\n\n<li>[ ] \u6709\u8a2d\u904e\u671f\u6642\u9593\u55ce\uff1f\uff08\u6c92\u8a2d\u7684\u8a71\u5feb\u53d6\u6703\u6c38\u9060\u4e0d\u66f4\u65b0\uff09<\/li>\n\n\n<li>[ ] \u6709\u8655\u7406\u5feb\u53d6\u7a7f\u900f\u55ce\uff1f\uff08\u4e0d\u5b58\u5728\u7684\u8cc7\u6599\u4e5f\u8981\u5feb\u53d6\uff09<\/li>\n\n\n<li>[ ] \u904e\u671f\u6642\u9593\u6709\u52a0\u96a8\u6a5f\u503c\u55ce\uff1f\uff08\u9632\u96ea\u5d29\uff09<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u5fc5\u770b\u61c2 vs \u77e5\u9053\u5c31\u597d<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5fc5\u770b\u61c2\uff08\u7cfb\u7d71\u8a2d\u8a08\u6838\u5fc3\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>SQL vs NoSQL \u7684\u9078\u578b\u908f\u8f2f<\/li>\n\n\n<li>Schema \u7684 ForeignKey \u548c relationship<\/li>\n\n\n<li>Cache-Aside Pattern\uff08\u6700\u5e38\u898b\u7684\u5feb\u53d6\u6a21\u5f0f\uff09<\/li>\n\n\n<li>\u7d22\u5f15\u7684\u57fa\u672c\u6982\u5ff5\uff08\u70ba\u4ec0\u9ebc\u80fd\u52a0\u901f\u67e5\u8a62\uff09<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u77e5\u9053\u5c31\u597d\uff08\u9047\u5230\u518d\u67e5\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>B-Tree \u7684\u5177\u9ad4\u5be6\u4f5c\u7d30\u7bc0<\/li>\n\n\n<li>\u8986\u84cb\u7d22\u5f15\u7684\u6700\u4f73\u5316\u6280\u5de7<\/li>\n\n\n<li>Write-Behind \u7684\u6279\u6b21\u540c\u6b65\u5be6\u4f5c<\/li>\n\n\n<li>CAP \u5b9a\u7406\u7684\u6578\u5b78\u8b49\u660e<\/li>\n\n\n<li>\u5206\u6563\u5f0f\u9396\u7684\u5404\u7a2e\u5be6\u4f5c\u65b9\u5f0f\uff08Redlock \u7b49\uff09<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7e3d\u7d50<\/h2>\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\">\u8cc7\u6599\u5c64\u8a2d\u8a08\u4e09\u4ef6\u4e8b\uff1a\n\n1. \u9078\u5c0d\u8cc7\u6599\u5eab\n   \u2514 \u6709\u95dc\u806f \u2192 SQL\u3001\u7d50\u69cb\u5f48\u6027 \u2192 NoSQL\u3001\u8981\u5feb \u2192 Redis\n\n2. \u8a2d\u8a08\u597d Schema\n   \u2514 \u5148\u6b63\u898f\u5316 \u2192 \u9047\u5230\u6548\u80fd\u554f\u984c\u518d\u5c40\u90e8\u53cd\u6b63\u898f\u5316\n   \u2514 \u5e38\u67e5\u7684\u6b04\u4f4d\u52a0\u7d22\u5f15\n\n3. \u642d\u914d\u5feb\u53d6\n   \u2514 Cache-Aside \u662f\u6700\u5e38\u898b\u7684\u6a21\u5f0f\n   \u2514 \u6ce8\u610f\u7a7f\u900f\u3001\u96ea\u5d29\u3001\u64ca\u7a7f\u4e09\u500b\u554f\u984c\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4e0b\u4e00\u7bc7\u6211\u5011\u5c07\u9032\u5165\u7cfb\u7d71\u8a2d\u8a08\u7684\u6700\u5f8c\u4e00\u584a\u62fc\u5716\uff1a<strong>\u53ef\u64f4\u5c55\u6027\u8207\u90e8\u7f72\u67b6\u69cb<\/strong>\uff0c\u5b78\u6703\u5982\u4f55\u8b93\u7cfb\u7d71\u5f9e\u55ae\u6a5f\u64f4\u5c55\u5230\u5206\u6563\u5f0f\u3002<\/p>\n\n\n\n<div id=\"quiz-fb4075d6\">\n<style>\n#quiz-fb4075d6 .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-fb4075d6 .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-fb4075d6 .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-fb4075d6 .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-fb4075d6 .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-fb4075d6 .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-fb4075d6 .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-fb4075d6 .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-fb4075d6 .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-fb4075d6 .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-fb4075d6 .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-fb4075d6 .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-fb4075d6 .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-fb4075d6 .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-fb4075d6 .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-fb4075d6 .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-fb4075d6 .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\u5c64\u8a2d\u8a08 &#8211; \u8cc7\u6599\u5eab\u9078\u578b\u3001Schema \u8207\u5feb\u53d6\u7b56\u7565<\/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\u8a2d\u8a08\u4e00\u500b\u90e8\u843d\u683c\u5e73\u53f0\uff0c\u6bcf\u7bc7\u6587\u7ae0\u7684\u6b04\u4f4d\u53ef\u80fd\u4e0d\u540c\uff08\u6709\u4e9b\u6709\u5f71\u7247\u3001\u6709\u4e9b\u6709\u7a0b\u5f0f\u78bc\u5340\u584a\u3001\u6709\u4e9b\u6709\u6295\u7968\uff09\u3002\u6587\u7ae0\u5beb\u5165\u5f8c\u5e7e\u4e4e\u4e0d\u4fee\u6539\uff0c\u4f46\u6bcf\u5929\u6709\u6578\u842c\u6b21\u95b1\u8b80\u3002\u4f60\u6703\u600e\u9ebc\u9078\u64c7\u8cc7\u6599\u5eab\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. PostgreSQL\uff0c\u56e0\u70ba\u6587\u7ae0\u4e4b\u9593\u6709\u5206\u985e\u548c\u6a19\u7c64\u7684\u95dc\u806f<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. MongoDB\uff0c\u56e0\u70ba\u6587\u7ae0\u7d50\u69cb\u7d93\u5e38\u8b8a\u52d5\u4e14\u5f48\u6027 Schema \u9069\u5408\u6b64\u5834\u666f<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. Redis\uff0c\u56e0\u70ba\u8b80\u53d6\u91cf\u5f88\u5927\u9700\u8981\u6700\u5feb\u7684\u901f\u5ea6<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u7528 PostgreSQL \u5132\u5b58\u6587\u7ae0\uff0c\u6bcf\u6b21\u65b0\u589e\u6b04\u4f4d\u6642\u4fee\u6539\u8868\u7d50\u69cb<\/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\u7cfb\u7d71\u9996\u9801\u6709\u4e00\u500b\u300c\u4eca\u65e5\u63a8\u85a6\u300d\u5546\u54c1\u5340\u584a\uff0c\u6bcf\u79d2\u6709\u4e0a\u5343\u6b21\u8acb\u6c42\u3002\u67d0\u5929\u65e9\u4e0a\u7a81\u7136\u8cc7\u6599\u5eab CPU \u98c6\u5230 100%\uff0c\u6392\u67e5\u5f8c\u767c\u73fe\u8a72\u5546\u54c1\u7684\u5feb\u53d6\u525b\u597d\u904e\u671f\u3002\u9019\u662f\u4ec0\u9ebc\u554f\u984c\uff1f\u4f60\u61c9\u8a72\u600e\u9ebc\u4fee\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u5feb\u53d6\u7a7f\u900f\uff1b\u5728\u67e5\u4e0d\u5230\u6642\u5b58\u4e00\u500b NULL \u503c\u5230\u5feb\u53d6<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. \u5feb\u53d6\u96ea\u5d29\uff1b\u628a\u6240\u6709\u5feb\u53d6\u7684\u904e\u671f\u6642\u9593\u52a0\u4e0a\u96a8\u6a5f\u503c<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u5feb\u53d6\u64ca\u7a7f\uff1b\u7528\u5206\u6563\u5f0f\u9396\u8b93\u53ea\u6709\u4e00\u500b\u8acb\u6c42\u67e5 DB\uff0c\u5176\u4ed6\u8acb\u6c42\u7b49\u5f85<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. \u5feb\u53d6\u96ea\u5d29\uff1b\u589e\u52a0 Redis \u7684\u8a18\u61b6\u9ad4\u4e0a\u9650<\/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\u8ca0\u8cac\u7684\u5546\u54c1\u9801\u9762\u67e5\u8a62\u5f88\u6162\u3002\u8cc7\u6599\u5eab\u6709 500 \u842c\u7b46\u5546\u54c1\uff0c\u4f7f\u7528\u8005\u5e38\u7528\u300c\u57ce\u5e02 + \u50f9\u683c\u7bc4\u570d\u300d\u641c\u5c0b\u3002\u76ee\u524d\u53ea\u6709 <code>city<\/code> \u6b04\u4f4d\u6709\u55ae\u4e00\u7d22\u5f15\u3002\u4f60\u61c9\u8a72\u600e\u9ebc\u512a\u5316\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">&#8212; \u76ee\u524d\u7684\u6162\u67e5\u8a62\nSELECT name, price FROM products\nWHERE city = &#8216;Taipei&#8217; AND price BETWEEN 100 AND 500\nORDER BY price;<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'B')\">A. \u518d\u55ae\u7368\u70ba <code>price<\/code> \u6b04\u4f4d\u52a0\u4e00\u500b\u7d22\u5f15<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'B')\">B. \u5efa\u7acb <code>(city, price)<\/code> \u7684\u8907\u5408\u7d22\u5f15\uff0c\u540c\u6642\u52a0\u901f WHERE \u548c ORDER BY<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'B')\">C. \u628a\u6240\u6709\u5546\u54c1\u8f09\u5165 Redis \u5feb\u53d6\uff0c\u5b8c\u5168\u7e5e\u904e\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'B')\">D. \u628a products \u8868\u53cd\u6b63\u898f\u5316\uff0c\u628a\u57ce\u5e02\u540d\u7a31\u76f4\u63a5\u5b58\u5728\u5546\u54c1\u540d\u4e2d<\/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. \u540c\u4e8b\u5beb\u4e86\u4ee5\u4e0b\u5feb\u53d6\u908f\u8f2f\uff0c\u4f46\u4e0a\u7dda\u5f8c\u767c\u73fe\uff1a\u60e1\u610f\u4f7f\u7528\u8005\u6301\u7e8c\u8acb\u6c42\u4e0d\u5b58\u5728\u7684\u5546\u54c1 ID\uff08\u5982 -999\uff09\uff0c\u6bcf\u6b21\u90fd\u76f4\u63a5\u67e5\u8cc7\u6599\u5eab\uff0c\u5c0e\u81f4 DB \u8ca0\u8f09\u904e\u9ad8\u3002\u9019\u6bb5\u7a0b\u5f0f\u78bc\u7684\u554f\u984c\u5728\u54ea\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">def get_product(product_id: int) -> dict:\n    cache_key = f&#8221;product:{product_id}&#8221;\n\n    cached = r.get(cache_key)\n    if cached:\n        return json.loads(cached)\n\n    product = db.query(Product).filter(\n        Product.id == product_id\n    ).first()\n\n    if product:\n        r.setex(cache_key, 300, json.dumps(product.to_dict()))\n        return product.to_dict()\n\n    return None<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. <code>r.setex<\/code> \u7684\u904e\u671f\u6642\u9593 300 \u79d2\u592a\u77ed\uff0c\u61c9\u6539\u70ba\u6c38\u4e45\u5feb\u53d6<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. \u7576\u5546\u54c1\u4e0d\u5b58\u5728\u6642\u6c92\u6709\u5feb\u53d6 NULL \u503c\uff0c\u5c0e\u81f4\u6bcf\u6b21\u90fd\u7a7f\u900f\u5230\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. \u61c9\u8a72\u7528 Write-Through \u6a21\u5f0f\u53d6\u4ee3 Cache-Aside<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. <code>json.loads<\/code> \u7121\u6cd5\u8655\u7406 Redis \u56de\u50b3\u7684\u4e8c\u9032\u4f4d\u8cc7\u6599<\/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. \u7cfb\u7d71\u4e0a\u7dda\u4e00\u6bb5\u6642\u9593\u5f8c\uff0c\u6bcf\u5929\u51cc\u6668 3:00 \u90fd\u6703\u51fa\u73fe\u8cc7\u6599\u5eab\u77ac\u9593\u9ad8\u5cf0\u3002\u6392\u67e5\u5f8c\u767c\u73fe\u6240\u6709\u5546\u54c1\u7684\u5feb\u53d6\u90fd\u662f\u5728\u6bcf\u5929\u51cc\u6668 2:55 \u5de6\u53f3\u88ab\u5beb\u5165\u7684\uff0c\u904e\u671f\u6642\u9593\u7d71\u4e00\u8a2d\u70ba 300 \u79d2\u3002\u4ee5\u4e0b\u54ea\u6bb5\u4fee\u6b63\u7a0b\u5f0f\u78bc\u80fd\u89e3\u6c7a\u9019\u500b\u554f\u984c\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\"># \u539f\u672c\u7684\u7a0b\u5f0f\u78bc\uff08\u6709\u554f\u984c\uff09\nr.setex(cache_key, 300, json.dumps(data))<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. \u628a\u904e\u671f\u6642\u9593\u5f9e 300 \u6539\u70ba 3600\uff0c\u5ef6\u9577\u5feb\u53d6\u5b58\u6d3b\u6642\u9593<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u6539\u7528 <code>r.set(cache_key, data)<\/code> \u4e0d\u8a2d\u904e\u671f\u6642\u9593\uff0c\u8b93\u5feb\u53d6\u6c38\u9060\u5b58\u5728<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u6539\u70ba <code>ttl = 300 + random.randint(0, 60)<\/code>\uff0c\u52a0\u96a8\u6a5f\u503c\u932f\u958b\u904e\u671f\u6642\u9593<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. \u5728\u51cc\u6668 2:55 \u57f7\u884c\u6392\u7a0b\u9810\u5148\u5237\u65b0\u6240\u6709\u5feb\u53d6<\/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: \"\u9019\u500b\u5834\u666f\u7684\u95dc\u9375\u662f\u300c\u6b04\u4f4d\u7d50\u69cb\u7d93\u5e38\u8b8a\u52d5\u300d\u3002MongoDB \u7684\u6587\u4ef6\u578b\u7d50\u69cb\u8b93\u6bcf\u7bc7\u6587\u7ae0\u53ef\u4ee5\u6709\u4e0d\u540c\u7684\u6b04\u4f4d\uff08\u5f71\u7247\u3001\u7a0b\u5f0f\u78bc\u5340\u584a\u3001\u6295\u7968\uff09\uff0c\u4e0d\u9700\u8981\u9810\u5148\u5b9a\u7fa9 Schema\u3002PostgreSQL \u96d6\u7136\u4e5f\u80fd\u7528 JSONB \u6b04\u4f4d\uff0c\u4f46 MongoDB \u539f\u751f\u5c31\u70ba\u5f48\u6027\u7d50\u69cb\u800c\u8a2d\u8a08\u3002Redis \u4e3b\u8981\u662f\u5feb\u53d6\u7528\u9014\uff0c\u4e0d\u9069\u5408\u7576\u4e3b\u8981\u8cc7\u6599\u5eab\u5132\u5b58\u5b8c\u6574\u6587\u7ae0\u5167\u5bb9\u3002\",\n        2: \"\u9019\u662f\u5178\u578b\u7684\u300c\u5feb\u53d6\u64ca\u7a7f\u300d\uff08Cache Breakdown\uff09\u554f\u984c\uff1a\u67d0\u500b\u8d85\u71b1\u9580\u7684\u5feb\u53d6\u904e\u671f\uff0c\u77ac\u9593\u5927\u91cf\u8acb\u6c42\u540c\u6642\u67e5 DB\u3002\u89e3\u6cd5\u662f\u7528\u5206\u6563\u5f0f\u9396\uff08<code>r.set(lock_key, \\\"1\\\", nx=True, ex=5)<\/code>\uff09\uff0c\u8b93\u53ea\u6709\u4e00\u500b\u8acb\u6c42\u53bb\u67e5 DB\uff0c\u5176\u4ed6\u8acb\u6c42\u7b49\u5f85\u3002\u5feb\u53d6\u7a7f\u900f\u662f\u67e5\u300c\u4e0d\u5b58\u5728\u300d\u7684\u8cc7\u6599\uff0c\u5feb\u53d6\u96ea\u5d29\u662f\u300c\u5927\u91cf\u300d\u5feb\u53d6\u540c\u6642\u904e\u671f\uff0c\u8ddf\u6b64\u60c5\u5883\u4e0d\u7b26\u3002\",\n        3: \"\u6839\u64da\u6587\u7ae0\u5167\u5bb9\uff0c<code>(city, price)<\/code> \u7684\u8907\u5408\u7d22\u5f15\u80fd\u540c\u6642\u52a0\u901f WHERE \u689d\u4ef6\u904e\u6ffe\u548c ORDER BY \u6392\u5e8f\u3002\u55ae\u7368\u70ba price \u52a0\u7d22\u5f15\u6548\u679c\u4e0d\u5982\u8907\u5408\u7d22\u5f15\uff0c\u56e0\u70ba\u8cc7\u6599\u5eab\u53ef\u80fd\u7121\u6cd5\u540c\u6642\u4f7f\u7528\u5169\u500b\u7368\u7acb\u7d22\u5f15\u3002\u628a 500 \u842c\u7b46\u5168\u90e8\u8f09\u5165 Redis \u4e0d\u5207\u5be6\u969b\u4e14\u6d6a\u8cbb\u8a18\u61b6\u9ad4\u3002\u53cd\u6b63\u898f\u5316\u5728\u9019\u88e1\u5b8c\u5168\u6c92\u6709\u610f\u7fa9\u3002\",\n        4: \"\u9019\u662f\u300c\u5feb\u53d6\u7a7f\u900f\u300d\uff08Cache Penetration\uff09\u554f\u984c\u3002\u7576 <code>product<\/code> \u70ba None \u6642\uff0c\u7a0b\u5f0f\u78bc\u76f4\u63a5 return None \u800c\u6c92\u6709\u5c07\u7d50\u679c\u5feb\u53d6\u3002\u9019\u610f\u5473\u8457\u6bcf\u6b21\u67e5\u8a62\u4e0d\u5b58\u5728\u7684\u5546\u54c1\u90fd\u6703\u76f4\u63a5\u6253\u5230\u8cc7\u6599\u5eab\u3002\u4fee\u6b63\u65b9\u5f0f\u662f\u5728\u5546\u54c1\u4e0d\u5b58\u5728\u6642\u4e5f\u5b58\u4e00\u500b\u77ed\u671f\u7684\u7a7a\u503c\uff1a<code>r.setex(cache_key, 60, \\\"NULL\\\")<\/code>\uff0c\u4e26\u5728\u8b80\u53d6\u6642\u5224\u65b7 <code>cached == b\\\"NULL\\\"<\/code> \u76f4\u63a5\u56de\u50b3 None\u3002\",\n        5: \"\u9019\u662f\u300c\u5feb\u53d6\u96ea\u5d29\u300d\uff08Cache Avalanche\uff09\u554f\u984c\u3002\u6240\u6709\u5feb\u53d6\u5728 2:55 \u5beb\u5165\u3001\u7d71\u4e00 300 \u79d2\u904e\u671f\uff0c\u6240\u4ee5 3:00 \u5de6\u53f3\u5168\u90e8\u540c\u6642\u5931\u6548\uff0c\u5c0e\u81f4\u77ac\u9593\u5927\u91cf\u8acb\u6c42\u6253\u5230\u8cc7\u6599\u5eab\u3002\u6b63\u78ba\u7684\u4fee\u6b63\u662f\u52a0\u4e0a\u96a8\u6a5f\u503c\uff1a<code>ttl = 300 + random.randint(0, 60)<\/code>\uff0c\u8b93\u4e0d\u540c\u5feb\u53d6\u5728 300 \u5230 360 \u79d2\u4e4b\u9593\u96a8\u6a5f\u904e\u671f\uff0c\u907f\u514d\u540c\u6642\u5931\u6548\u3002\u55ae\u7d14\u5ef6\u9577\u904e\u671f\u6642\u9593\u53ea\u662f\u5ef6\u5f8c\u554f\u984c\uff0c\u4e0d\u8a2d\u904e\u671f\u6642\u9593\u6703\u5c0e\u81f4\u5feb\u53d6\u6c38\u9060\u4e0d\u66f4\u65b0\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 = \"&#10003; \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"&#10007; \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 = \"\u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\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\u5c64\u8a2d\u8a08 &#8211; \u8cc7\u6599\u5eab\u9078\u578b\u3001Schema \u8207\u5feb\u53d6\u7b56\u7565 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c  [&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":[757],"tags":[729,240,761,759,762,760,758],"class_list":["post-775","post","type-post","status-publish","format-standard","hentry","category-757","tag-cap","tag-python","tag-redis","tag-schema","tag-sqlalchemy","tag-760","tag-758"],"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\/775","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=775"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/775\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}