{"id":10007007,"date":"2022-12-24T02:39:46","date_gmt":"2022-12-23T18:39:46","guid":{"rendered":"https:\/\/ityet.com\/?p=10007007"},"modified":"2022-12-24T02:39:46","modified_gmt":"2022-12-23T18:39:46","slug":"%e7%b4%a2%e5%bc%95%e9%80%89%e6%8b%a9%e5%ba%a6%e9%97%ae%e9%a2%98%e4%bc%98%e5%8c%96%e6%95%b4%e7%90%86","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10007007","title":{"rendered":"\u7d22\u5f15\u9009\u62e9\u5ea6\u95ee\u9898\u4f18\u5316\u6574\u7406"},"content":{"rendered":"

\u4e4b\u524d\u5728\u641e\u5b9c\u642d\u5143\u6570\u636e\u5e95\u5c42\u7d22\u5f15\u4f18\u5316\u7684\u65f6\u5019\uff0c\u9488\u5bf9\u4e00\u4e9b\u67e5\u8be2\u65f6\u5feb\u65f6\u6162\uff0c\u4ee5\u53ca\u4e00\u4e9b\u7d22\u5f15\u9009\u62e9\u7684\u95ee\u9898\uff0c\u7814\u7a76\u8fc7\uff0c\u4e5f\u57fa\u4e8e\u770b\u8fc7\u7684\u4e00\u4e9b\u6848\u4f8b\u4ee5\u53ca\u81ea\u8eab\u5f52\u7eb3\u601d\u8003\uff0c\u4e0b\u9762\u6574\u7406\u5206\u4eab\u4e0b\uff1b<\/p><\/blockquote>\n

\u4e00\u822c\u6211\u4eec\u4e3a\u4e86\u52a0\u5feb\u67e5\u8be2\u901f\u5ea6\uff0c\u4f1a\u8bbe\u8ba1\u7d22\u5f15\uff0c\u5f53\u7136\u6709\u7d22\u5f15\u60c5\u51b5\u4e0b\uff0c\u5927\u591a\u662f\u4f1a\u547d\u4e2d\u53bb\u8d70\u7d22\u5f15\u67e5\u8be2\uff1b\u4f46\u662f\u5462:<\/p>\n

    \n
  1. \u5b58\u50a8\u4f18\u5316\u5668\u53bb\u6267\u884c\uff0c\u5c31\u7b97\u52a0\u4e86\u7d22\u5f15\uff0c\u5728\u4e00\u5b9a\u65f6\u5019\u6709\u53ef\u80fd\u6ca1\u7528\u5230\u7d22\u5f15\uff0c\u901f\u5ea6\u4f1a\u66f4\u6162\u70b9\uff0c\u8fd9\u662f\u4e3a\u4ec0\u4e48\u4e0d\u7528\uff1f<\/li>\n
  2. \u6709\u4e9b\u65f6\u5019\u540c\u4e00\u4e2a\u7528\u6237\u4e0d\u540c\u65f6\u95f4\u53bb\u8bf7\u6c42\uff0c\u4ea7\u751f\u76f8\u540cSQL\u8bed\u53e5\u53bb\u67e5\u8be2\u4e5f\u53ef\u80fd\u51fa\u73b0\u4e0d\u540c\u7684\u5feb\u6162\u6027\u80fd\uff0c\u8fd9\u53c8\u662f\u4e3a\u4ec0\u4e48\uff1f<\/li>\n
  3. \u5c31\u7b97\u547d\u4e2d\u4e86\u7d22\u5f15\uff0c\u901f\u5ea6\u53ef\u80fd\u66f4\u6162\uff0c\u8fd9\u6700\u540e\u53c8\u662f\u4e3a\u4ec0\u4e48\uff1f<\/li>\n<\/ol>\n

    \u5148\u4e3e\u51e0\u4e2a\u4e4b\u524d\u77e5\u9053\u7684\u4f8b\u5b50\u52a0\u4ee5\u5206\u6790\uff1b
    <\/a><\/p>\n

    \u6848\u4f8b\u4e00<\/h2>\n
    -- \u521b\u5efa\u6d4b\u8bd5\u8868\nCREATE TABLE `t` (\n  `id` int primary key auto_increment,\n  `a` int default null,\n  `b` int default null,\n  KEY `a` (`a`),\n  KEY `b` (`b`)\n) ENGINE=InnoDB;\n\n-- \u63d2\u516510w\u884c\u6d4b\u8bd5\u6570\u636e\ndelimiter ;;\ncreate procedure idata()\nbegin\n  declare i int;\n  set i=1;\n  while(i<=100000)do\n    insert into t values(i, i, i);\n    set i=i+1;\n  end while;\nend;;\ndelimiter ;\ncall idata();<\/code><\/pre>\n
    mysql\u5168\u8868\u626b\u63cf<\/strong>
    explain select  from t where a between 10000 and 20000; 
    \"\"
    \u901a\u8fc7explain\u7684\u6267\u884c\u7ed3\u679c\u6211\u4eec\u53ef\u4ee5\u770b\u51fa\uff0c\u4e0a\u9762\u7684SQL\u8bed\u53e5\u5e76\u6ca1\u6709\u8d70\u6211\u4eec\u7684\u7d22\u5f15a\uff0c\u800c\u662f\u76f4\u63a5\u4f7f\u7528\u4e86\u5168\u8868\u626b\u63cf\u3002
    — \u5f3a\u5236\u8d70\u7d22\u5f15a explain select <\/em> from t force index(a) where a between 10000 and 20000; 
    \"\"
    \u901a\u8fc7explain\u7684\u6267\u884c\u7ed3\u679c\u6211\u4eec\u53ef\u4ee5\u770b\u51fa\uff0c\u4e0a\u9762\u7684SQL\u8bed\u53e5\u6211\u4eec\u901a\u8fc7force index(a)\u4ee5\u540e\uff0c\u786e\u5b9e\u4f7f\u7528\u4e86\u7d22\u5f15\u3002
    — \u5f00\u542f\u6162\u65e5\u5fd7 set global slow_query_log  = true; set long_query_time = 0; — \u5206\u522b\u6267\u884c\u4e0d\u8d70\u7d22\u5f15\u548c\u8d70\u7d22\u5f15\u7684SQL select  from t where a between 10000 and 20000; select <\/em> from t force index(a) where a between 10000 and 20000; 
    \"image.png\"<\/p>\n
    \"image.png\"
    \u53ef\u4ee5\u770b\u51fa\u8d70\u7d22\u5f15\u7684\u67e5\u8be2\u6bd4\u4e0d\u8d70\u7d22\u5f15\u7684\u67e5\u8be2\u5feb\u4e86\u5c06\u8fd110ms\u3002
    \u4f46\u662f\u5b58\u50a8\u4f18\u5316\u5668\u9ed8\u8ba4\u6ca1\u8d70\u7d22\u5f15\u7684\u67e5\u8be2\uff0c\u867d\u7136\u52a0\u4e86\u7d22\u5f15
    <\/a><\/p>\n
    \u6848\u4f8b\u4e8c<\/h2>\n
    \u9488\u5bf9\u67d0\u4e2a\u5e73\u53f0\u6709\u5f20\u6d88\u606f\u53d1\u9001\u4ea4\u6d41\u7684\u8868\uff0c\u89c4\u6a21\u8fbe\u5230\u6570\u5343\u4e07\u884c\u7ea7\uff0cPG\u5b58\u50a8\uff1b\u6d88\u606f\u8868\u4e0a\u7684\u4e3b\u67e5\u8be2\u901a\u5e38\u6781\u5feb\uff0c\u4f46\u662f\u4e5f\u9047\u5230\u4e86\u4e00\u4e9b\u95f4\u6b47\u7684\u6162\u67e5\u8be2\u8d85\u65f6\u3002\u6162\u67e5\u8be2\u4e0d\u4f46\u5f71\u54cd\u4e86\u6d88\u606f\u529f\u80fd\u7684\u7528\u6237\u4f53\u9a8c\uff0c\u800c\u4e14\u52a0\u5927\u4e86\u6574\u4e2a\u7cfb\u7edf\u7684\u8d1f\u8377\uff0c\u62d6\u6162\u4e86\u5176\u4ed6\u529f\u80fd\u7684\u7528\u6237\u4f53\u9a8c\u3002
    \u8fd9\u4e2a\u67e5\u8be2\u957f\u8fd9\u6837\uff1a<\/p>\n
    SELECT messages.* FROM messages  WHERE messages.deleted_at IS NULL AND messages.namespace = ?  AND (        jsonb_extract_path_text(context, 'topic') IN (?, ?)        OR jsonb_extract_path_text(context, 'topic') LIKE ?      )  AND ( context @> '{"involved_parties":[{"id":1,"type":1}]}'::jsonb ) ORDER BY messages.created_at ASC<\/code><\/pre>\n
    \u5728context\u4e0a\u6709\u4e24\u4e2a\u7d22\u5f15<\/p>\n
      \n
    1. context\u5217\u4e0a\u7684GIN\u7d22\u5f15<\/li>\n
    2. jsonb_extract_path_text(context, \u2018topic\u2019)\u8868\u8fbe\u5f0f\u4e0a\u7684BTREE\u8868\u8fbe\u5f0f\u7d22\u5f15<\/li>\n<\/ol>\n
      \u770b\u4e0b\u4e0a\u9762\u8bed\u53e5\u5076\u5c14\u6162\u7684\u65f6\u5019QUERY PLAN\uff1a<\/p>\n
      UERY PLAN\n------------------------------------------------------------------------------\n Sort  (cost=540.08..540.09 rows=3 width=915)\n   Sort Key: created_at\n   ->  Bitmap Heap Scan on messages  (cost=536.03..540.06 rows=3 width=915)\n         Recheck Cond: (((jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) = ANY ('{?,?}'::text[])) OR (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~~ '?%'::text)) AND (context @> '{"involved_parties": [{"id": 1, "type": 1}]}'::jsonb))\n         Filter: ((deleted_at IS NULL) AND ((namespace)::text = '?'::text) AND ((jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) = ANY ('{?,?}'::text[])) OR (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~~ '?%'::text)))\n         ->  BitmapAnd  (cost=536.03..536.03 rows=1 width=0)\n               ->  BitmapOr  (cost=20.13..20.13 rows=249 width=0)\n                     ->  Bitmap Index Scan on index_messages_on_topic_key_string  (cost=0.00..15.55 rows=249 width=0)\n                           Index Cond: (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) = ANY ('{?,?}'::text[]))\n                     ->  Bitmap Index Scan on index_messages_on_topic_key_string  (cost=0.00..4.57 rows=1 width=0)\n                           Index Cond: ((jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~>=~ '?'::text) AND (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~<~ '?'::text))\n               ->  Bitmap Index Scan on index_messages_on_context  (cost=0.00..515.65 rows=29820 width=0)\n                     Index Cond: (context @> '{"involved_parties": [{"id": 1, "type": 1}]}'::jsonb)\n(\u8fd9\u4e2a\u67e5\u8be2\u8ba1\u5212\u6765\u81eaEXPLAIN\uff0c\u7531\u4e8eEXPLAIN ANALYZE\u8d85\u65f6)<\/code><\/pre>\n
      \u770b\u4e0b\u4e0a\u9762\u8bed\u53e5\u5feb\u7684\u65f6\u5019QUERY PLAN\uff1a<\/p>\n
      QUERY PLAN\n------------------------------------------------------------------------------\n Sort  (cost=667.75..667.76 rows=3 width=911) (actual time=0.093..0.094 rows=7 loops=1)\n   Sort Key: created_at\n   Sort Method: quicksort  Memory: 35kB\n   ->  Bitmap Heap Scan on messages  (cost=14.93..667.73 rows=3 width=911) (actual time=0.054..0.077 rows=7 loops=1)\n         Recheck Cond: ((jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) = ANY ('{?,?}'::text[])) OR (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~~ '?%'::text))\n         Filter: ((deleted_at IS NULL) AND (context @> '{"involved_parties": [{"id": 1, "type": 1}]}'::jsonb) AND ((namespace)::text = '?'::text) AND ((jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) = ANY ('{?,?}'::text[])) OR (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~~ '?%'::text)))\n         Heap Blocks: exact=7\n         ->  BitmapOr  (cost=14.93..14.93 rows=163 width=0) (actual time=0.037..0.037 rows=0 loops=1)\n               ->  Bitmap Index Scan on index_messages_on_topic_key_string  (cost=0.00..10.36 rows=163 width=0) (actual time=0.029..0.029 rows=4 loops=1)\n                     Index Cond: (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) = ANY ('{?,?}'::text[]))\n               ->  Bitmap Index Scan on index_messages_on_topic_key_string  (cost=0.00..4.57 rows=1 width=0) (actual time=0.007..0.007 rows=7 loops=1)\n                     Index Cond: ((jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~>=~ '?'::text) AND (jsonb_extract_path_text(context, VARIADIC '{topic}'::text[]) ~<~ '?'::text))\n Planning time: 0.313 ms\n Execution time: 0.138 ms<\/code><\/pre>\n
      \u56fe\u4e2d\u6267\u884c\u8ba1\u5212\u53ef\u4ee5\u770b\u51fa\uff0c(context @> ‘{“involved_parties”: [{“id”: 1, “type”: 1}]}’::jsonb) \u6ca1\u8d70\u7d22\u5f15\u66f4\u5feb\uff0c\u8d70\u4e86\u7d22\u5f15\u8fd8\u66f4\u6162\uff1b \u800c\u4e14\u540c\u4e00\u4e2aSQL\u67e5\u8be2\uff0c\u6709\u4e9b\u65f6\u5019\u8d70\u7d22\u5f15\uff0c\u6709\u4e9b\u65f6\u5019\u53c8\u4e0d\u8d70\uff1b
      <\/a><\/p>\n
      \u6848\u4f8b\u5206\u6790<\/h2>\n
      \u8fd9\u91cc\u9488\u5bf9\u6848\u4f8b\u4e8c\u8fdb\u884c\u5206\u6790: 
      \u4e86\u89e3\u4e0b\u7d22\u5f15\u533a\u522b<\/strong><\/p>\n
      GIN\u662fPostgreSQL\u63d0\u4f9b\u7684\u4e00\u6b3e\u7528\u4e8e\u590d\u6742\u503c\u7684\u7d22\u5f15\u5f15\u64ce\uff0c\u4e00\u822c\u7528\u4e8e\u6570\u7ec4\u3001JSON\u6216\u6587\u672c\u7b49\u7684\u6570\u636e\u7ed3\u6784\u3002GIN\u7684\u8bbe\u8ba1\u7528\u9014\u662f\u7d22\u5f15\u90a3\u4e9b\u53ef\u5bf9\u5185\u90e8\u7ed3\u6784\u505a\u7ec6\u5206\u7684\u6570\u636e\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u67e5\u627e\u6570\u636e\u5185\u90e8\u7684\u5b50\u6570\u636e\u4e86\u3002BTREE\u662fPostgreSQL\u7684\u9ed8\u8ba4\u7d22\u5f15\u5f15\u64ce\uff0c\u80fd\u5bf9\u7b80\u5355\u503c\u505a\u76f8\u7b49\u6027\u6bd4\u8f83\u6216\u8303\u56f4\u67e5\u8be2\u3002\u8868\u8fbe\u5f0f\u7d22\u5f15\u662fPostgreSQL\u63d0\u4f9b\u7684\u4e00\u79cd\u5f3a\u529b\u7684\u7d22\u5f15\u7c7b\u578b\uff0c\u80fd\u5bf9\u4e00\u4e2a\u8868\u8fbe\u5f0f\uff08\u800c\u4e0d\u662f\u4e00\u4e2a\u5217\uff09\u505a\u7d22\u5f15\u3002JSONB\u7c7b\u578b\u4e00\u822c\u53ea\u80fd\u7528GIN\u8fd9\u6837\u7684\u7d22\u5f15\u5f15\u64ce\uff0c\u56e0\u4e3aBTREE\u53ea\u652f\u6301\u6807\u91cf\u7c7b\u578b\uff08\u53ef\u4ee5\u7406\u89e3\u4e3a\u201c\u6ca1\u6709\u5185\u90e8\u7ed3\u6784\u7684\u7b80\u5355\u503c\u7c7b\u578b\u201d\uff09\u3002\u56e0\u6b64\uff0ccontext\u5217\u4e0a\u7684jsonb_extract_path_text(context, \u2018topic\u2019)\u8868\u8fbe\u5f0f\u53ef\u4ee5\u7528BTREE\u7d22\u5f15\uff0c\u56e0\u4e3a\u5b83\u8fd4\u56de\u5b57\u7b26\u4e32\u7c7b\u578b\u3002\u4e0d\u540c\u4e8eBTREE\u7d22\u5f15\u7edf\u4e00\u800c\u4e00\u81f4\u7684\u8868\u793a\u683c\u5f0f\uff0cGIN\u7d22\u5f15\u7684\u5185\u5bb9\u53ef\u4ee5\u56e0\u6240\u7528\u6570\u636e\u7c7b\u578b\u548c\u64cd\u4f5c\u7b26\u7c7b\u578b\u7684\u4e0d\u540c\u800c\u6781\u4e3a\u4e0d\u540c\u3002\u800c\u4e14\u8003\u8651\u5230\u67e5\u8be2\u53c2\u6570\u7684\u9009\u62e9\u5ea6\u6709\u8f83\u9ad8\u7684\u591a\u6837\u6027\uff0cGIN\u7d22\u5f15\u66f4\u9002\u7528\u4e8e\u4e00\u4e9b\u7279\u5b9a\u7684\u67e5\u8be2\uff0c\u4e0d\u50cfBTREE\u7d22\u5f15\u5e7f\u6cdb\u9002\u7528\u4e8e\u76f8\u7b49\u6027\u6bd4\u8f83\u548c\u8303\u56f4\u67e5\u8be2\u3002<\/p><\/blockquote>\n
      \u9884\u5206\u6790<\/strong>
      \u4e00\u4e2a\u67e5\u8be2\u901a\u5e38\u4f1a\u5148\u505a\u7d22\u5f15\u626b\u63cf\u4ee5\u521d\u7b5b\uff0c\u518d\u5bf9\u7b5b\u9009\u540e\u7684\u8303\u56f4\u505a\u8868\u626b\u63cf\uff08\u4e00\u4e2a\u7279\u4f8b\u662f\uff0c\u5f53\u7d22\u5f15\u626b\u63cf\u8db3\u4ee5\u8986\u76d6\u6240\u9700\u7684\u6240\u6709\u6570\u636e\u5217\u65f6\uff0c\u5219\u65e0\u9700\u8868\u626b\u63cf\uff09\u3002\u4e3a\u4e86\u6700\u5927\u5316\u6027\u80fd\uff0c\u7d22\u5f15\u8981\u6709\u8f83\u597d\u7684\u9009\u62e9\u5ea6\u6765\u7f29\u5c0f\u8303\u56f4\uff0c\u4ee5\u51cf\u5c11\u751a\u81f3\u907f\u514d\u4e4b\u540e\u7684\u8868\u626b\u63cf\u3002\u6761\u4ef6context @> \u2018{\u201cinvolved_parties\u201d:[{\u201cid\u201d:1,\u201dtype\u201d:1}]}\u2019::jsonb\u80fd\u4f7f\u7528context\u5217\u4e0a\u7684GIN\u7d22\u5f15\uff0c\u4f46\u662f\u8fd9\u5e76\u4e0d\u662f\u4e00\u4e2a\u597d\u9009\u62e9\uff0c\u56e0\u4e3a{\u201cid\u201d:1,\u201dtype\u201d:1}\u8fd9\u4e2a\u503c\u662f\u5b58\u5728\u4e8e\u5927\u591a\u6570\u884c\u4e2d\u7684\u4e00\u4e2a\u7279\u6b8a\u503c\uff08\u8fd9\u6570\u5b57\u5c31\u5f88\u7279\u6b8a\uff0c\u50cf\u7ba1\u7406\u5458\u7684\u53f7\u7801\uff09\u3002\u56e0\u6b64\uff0cGIN\u7d22\u5f15\u5bf9\u4e8e\u8fd9\u4e2a\u6761\u4ef6\u7684\u9009\u62e9\u5ea6\u5f88\u5dee\u3002\u5b9e\u9645\u4e0a\uff0c\u8fd9\u4e2a\u67e5\u8be2\u4e2d\u7684\u5176\u4ed6\u6761\u4ef6\u5df2\u80fd\u63d0\u4f9b\u5f88\u597d\u7684\u9009\u62e9\u5ea6\uff0c\u6240\u4ee5\u6c38\u8fdc\u4e0d\u9700\u8981\u4e3a\u8fd9\u4e2a\u6761\u4ef6\u4f7f\u7528\u7d22\u5f15\u3002
      \u9488\u5bf9\u5feb\u6162\u67e5\u8be2\u5206\u6790<\/strong>
                                   \u6162\u67e5\u8be2\u8def\u5f84                               \u5feb\u67e5\u8be2\u8def\u5f84
      \"image.png\"\"image.png\"<\/p>\n
      \u5982\u56fe\u53ef\u89c1\uff0c\u8fd9\u4e2a\u6162\u67e5\u8be2\u8ba1\u5212\u6bd4\u5feb\u67e5\u8be2\u8ba1\u5212\u66f4\u590d\u6742\u3002\u5b83\u591a\u4e86\u4e00\u4e2a\u201dBitmapAnd\u201d\u548c\u4e00\u4e2a\u626b\u63cfindex 3\u7684\u201dBitmap Index Scan\u201d\u8282\u70b9\uff08index 3\u662fcontext\u5217\u4e0a\u7684GIN\u7d22\u5f15\uff09\u3002\u82e5index 3\u4f4e\u6548\u7387\uff0c\u603b\u4f53\u6027\u80fd\u5c31\u4f1a\u964d\u4f4e\u3002
      \u5f53\u6210\u672c\u4f30\u8ba1\u51c6\u786e\u65f6\uff0c\u67e5\u8be2\u8ba1\u5212\u5668\u5de5\u4f5c\u5f97\u5f88\u597d\u3002\u4f46\u662fJSONB\u4e0a\u7684GIN\u7d22\u5f15\u7684\u6210\u672c\u4f30\u8ba1\u4e0d\u662f\u5f88\u51c6\u786e\u7684\u3002\u7531\u89c2\u6d4b\u53ef\u89c1\uff0c\u5b83\u8ba4\u4e3a\u8fd9\u4e2a\u7d22\u5f15\u7684\u9009\u62e9\u5ea6\u4e3a0.001\uff08\u8fd9\u662f\u4e00\u4e2a\u786c\u7f16\u7801\u7684\u56fa\u5b9a\u503c\uff09\uff0c\u4e5f\u5c31\u662f\u8bf4\u5b83\u5047\u8bbe\u4efb\u4f55\u76f8\u5173\u7684\u67e5\u8be2\u90fd\u4f1a\u9009\u62e9\u8868\u4e2d\u6240\u6709\u884c\u76840.1%\uff0c\u4f46\u5728\u6211\u4eec\u8fd9\u4e2a\u573a\u666f\u5b83\u5b9e\u9645\u4f1a\u9009\u62e990%\u7684\u884c\uff0c\u6240\u4ee5\u8fd9\u4e2a\u5047\u8bbe\u4e0d\u6210\u7acb\u3002\u9519\u8bef\u7684\u5047\u8bbe\u4f7f\u67e5\u8be2\u8ba1\u5212\u5668\u4f4e\u4f30\u4e86\u6162\u67e5\u8be2\u8ba1\u5212\u7684\u6210\u672c\u3002\u867d\u7136JSONB\u7c7b\u578b\u7684\u5217\u4e5f\u6709\u4e00\u4e9b\u7edf\u8ba1\u4fe1\u606f\uff0c\u4f46\u597d\u50cf\u6ca1\u6709\u8d77\u5230\u4f5c\u7528\u3002
      <\/a><\/p>\n
      \u7ed3\u8bba<\/h2>\n
      \u6240\u4ee5\u8bf4\u6709\u4e9b\u65f6\u547d\u4e2d\u7d22\u5f15\u4e0d\u4e00\u5b9a\u5c31\u5feb\uff0c\u800c\u4e14\u7d22\u5f15\u4f18\u5316\u5668\u4e5f\u4e0d\u4e00\u5b9a\u662f\u51c6\u786e\u7684\uff0c\u53ef\u80fd\u4f1a\u6267\u884c\u66f4\u6162\uff1b
      <\/a><\/p>\n
      \u4e00\u4e9b\u6709\u7528\u7684\u539f\u5219<\/h2>\n
      <\/a><\/p>\n
      \u539f\u52191: \u5c11\u5373\u662f\u591a<\/h3>\n
      \u7ba1\u7406\u597d\u7d22\u5f15<\/strong>
      \u66f4\u591a\u7684\u7d22\u5f15\u5e76\u4e0d\u610f\u5473\u7740\u66f4\u597d\u7684\u6027\u80fd\u3002\u4e8b\u5b9e\u4e0a\uff0c\u6bcf\u589e\u52a0\u4e00\u4e2a\u7d22\u5f15\u90fd\u4f1a\u964d\u4f4e\u5199\u64cd\u4f5c\u7684\u6027\u80fd\u3002\u5982\u679c\u67e5\u8be2\u8ba1\u5212\u5668\u9009\u62e9\u4e86\u4e0d\u9ad8\u6548\u7684\u7d22\u5f15\uff0c\u90a3\u4e48\u67e5\u8be2\u4ecd\u7136\u4f1a\u5f88\u6162\u3002
      \u4e0d\u8981\u5806\u79ef\u7d22\u5f15\uff08\u4f8b\u5982\u6bcf\u4e00\u5217\u90fd\u5efa\u7d22\u5f15\u5c31\u662f\u4e0d\u53ef\u53d6\u7684\uff09\u3002\u8bd5\u7740\u5c3d\u53ef\u80fd\u5220\u9664\u4e00\u4e9b\u7d22\u5f15\u5427\u3002\u800c\u4e14\u6bcf\u6539\u52a8\u4e00\u4e2a\u7d22\u5f15\u90fd\u8981\u76d1\u63a7\u5176\u5bf9\u6027\u80fd\u7684\u5f71\u54cd\u3002
      \u4f18\u9009\u7b80\u5355\u7684\u6570\u636e\u5e93\u8bbe\u8ba1<\/strong>
      RDBMS\uff08\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7cfb\u7edf\uff09\u4e2d\u7684\u6570\u636e\u4e00\u822c\u90fd\u5b9c\u7528\u8303\u5f0f\u5316\u8bbe\u8ba1\u3002JSON\u6216JSONB\u5219\u662fNoSQL\u98ce\u683c\u7684\u53cd\u8303\u5f0f\u5316\u8bbe\u8ba1\u3002
      \u8303\u5f0f\u5316\u548c\u53cd\u8303\u5f0f\u5316\u54ea\u4e2a\u66f4\u597d\u5462\uff1f\u4ece\u4e1a\u52a1\u7684\u89d2\u5ea6\uff0c\u8981\u5177\u4f53\u60c5\u51b5\u5177\u4f53\u5206\u6790\u3002\u4eceRDBMS\u7684\u89d2\u5ea6\uff0c\u8303\u5f0f\u5316\u603b\u662f\u66f4\u7b80\u5355\u66f4\u597d\uff0c\u800c\u53cd\u8303\u5f0f\u5316\u5219\u53ef\u4ee5\u5728\u67d0\u4e9b\u60c5\u51b5\u4f5c\u4e3a\u8865\u5145\u3002
      \u5efa\u8bae1\uff1a\u8003\u8651\u4eceDDD\uff08\u9886\u57df\u9a71\u52a8\u8bbe\u8ba1\uff09\u7684\u89d2\u5ea6\u6765\u8bbe\u8ba1\u6570\u636e\u6a21\u578b\u3002<\/p>\n