{"id":91215,"date":"2026-08-07T11:25:12","date_gmt":"2026-08-07T03:25:12","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/91215.html"},"modified":"2026-08-07T11:25:12","modified_gmt":"2026-08-07T03:25:12","slug":"%e3%80%90%e9%87%91%e4%bb%93%e6%95%b0%e6%8d%ae%e5%ba%93%e5%be%81%e6%96%87%e3%80%91ai-agent%e4%b8%ad%e7%9a%84%e4%b8%9a%e5%8a%a1%e6%9c%af%e8%af%ad%e5%88%b0%e5%ad%97%e6%ae%b5%e6%98%a0%e5%b0%84%ef%bc%9a","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/91215.html","title":{"rendered":"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5"},"content":{"rendered":"<\/p>\n<h4>\u6587\u7ae0\u76ee\u5f55<\/h4>\n<ul>\n<li>\n<ul>\n<li>\u6bcf\u65e5\u4e00\u53e5\u6b63\u80fd\u91cf<\/li>\n<li>\u5f15\u8a00&#xff1a;\u5f53\u4e1a\u52a1\u8bed\u8a00\u9047\u4e0a\u6280\u672fSchema<\/li>\n<li>\u4e00\u3001\u6838\u5fc3\u95ee\u9898&#xff1a;\u4e3a\u4ec0\u4e48AI Agent\u603b\u662f&#034;\u731c\u9519&#034;\u6570\u636e&#xff1f;<\/li>\n<li>\n<ul>\n<li>1.1 \u8bed\u4e49\u9e3f\u6c9f\u7684\u4e09\u91cd\u7ef4\u5ea6<\/li>\n<li>1.2 \u7ecf\u8425\u5206\u6790\u573a\u666f\u7684\u5178\u578b\u75db\u70b9<\/li>\n<\/ul>\n<\/li>\n<li>\u4e8c\u3001\u8bed\u4e49\u5c42\u67b6\u6784&#xff1a;\u4ece&#034;\u731c&#034;\u5230&#034;\u61c2&#034;<\/li>\n<li>\n<ul>\n<li>2.1 \u8bed\u4e49\u5c42\u7684\u5b9a\u4f4d<\/li>\n<li>2.2 \u4e09\u5c42\u67b6\u6784\u8bbe\u8ba1<\/li>\n<\/ul>\n<\/li>\n<li>\u4e09\u3001\u672f\u8bed\u8868\u8bbe\u8ba1&#xff1a;\u8bed\u4e49\u5c42\u7684&#034;\u8bcd\u5178&#034;<\/li>\n<li>\n<ul>\n<li>3.1 \u672f\u8bed\u8868\u6838\u5fc3\u7ed3\u6784<\/li>\n<li>3.2 \u7ecf\u8425\u5206\u6790\u672f\u8bed\u8868\u793a\u4f8b<\/li>\n<\/ul>\n<\/li>\n<li>\u56db\u3001\u6620\u5c04\u89c4\u5219&#xff1a;\u4ece\u672f\u8bed\u5230SQL<\/li>\n<li>\n<ul>\n<li>4.1 \u6620\u5c04\u89c4\u5219\u5f15\u64ce<\/li>\n<li>4.2 \u6620\u5c04\u89c4\u5219\u793a\u4f8b<\/li>\n<\/ul>\n<\/li>\n<li>\u4e94\u3001\u91d1\u4ed3KFS MCP Server&#xff1a;\u8bed\u4e49\u5c42\u7684\u6700\u4f73\u8f7d\u4f53<\/li>\n<li>\n<ul>\n<li>5.1 \u4e3a\u4ec0\u4e48\u9009KFS MCP Server&#xff1f;<\/li>\n<li>5.2 \u5b89\u5168\u63a7\u5236&#xff1a;\u8bed\u4e49\u5c42\u7684&#034;\u62a4\u680f&#034;<\/li>\n<li>5.3 \u5de5\u5177\u8c03\u7528&#xff1a;\u8bed\u4e49\u5c42\u7684&#034;\u6b66\u5668\u5e93&#034;<\/li>\n<\/ul>\n<\/li>\n<li>\u516d\u3001\u5b9e\u6218\u6848\u4f8b&#xff1a;\u7ecf\u8425\u5206\u6790\u4e2d\u7684\u672f\u8bed\u6620\u5c04<\/li>\n<li>\n<ul>\n<li>6.1 \u573a\u666f\u8bbe\u5b9a<\/li>\n<li>6.2 \u672f\u8bed\u51b2\u7a81\u4e0e\u89e3\u51b3<\/li>\n<li>6.3 \u5b8c\u6574\u5bf9\u8bdd\u793a\u4f8b<\/li>\n<\/ul>\n<\/li>\n<li>\u4e03\u3001\u6548\u679c\u8bc4\u4f30&#xff1a;\u8bed\u4e49\u5c42\u7684\u4ef7\u503c\u91cf\u5316<\/li>\n<li>\n<ul>\n<li>7.1 \u8bc4\u4f30\u6307\u6807<\/li>\n<li>7.2 \u91d1\u4ed3KFS MCP Server\u7684\u8bc4\u4f30\u7ed3\u679c<\/li>\n<\/ul>\n<\/li>\n<li>\u516b\u3001\u603b\u7ed3\u4e0e\u5c55\u671b<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032507-6a7550133db49.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h3>\u6bcf\u65e5\u4e00\u53e5\u6b63\u80fd\u91cf<\/h3>\n<p>\u201c\u5b81\u613f\u8ddf\u6ecb\u517b\u4f60\u7684\u4eba\u4e00\u8d77\u53d1\u5446&#xff0c;\u4e5f\u522b\u8ddf\u6d88\u8017\u4f60\u7684\u4eba\u5206\u4eab\u559c\u60a6\u3002\u201d \u201c\u6ecb\u517b\u201d\u610f\u5473\u7740\u80fd\u91cf\u6b63\u5411\u6d41\u52a8&#xff0c;\u54ea\u6015\u65e0\u6240\u4e8b\u4e8b\u4e5f\u662f\u4eab\u53d7&#xff1b;\u201c\u6d88\u8017\u201d\u610f\u5473\u7740\u60c5\u7eea\u88ab\u900f\u652f&#xff0c;\u8fde\u5feb\u4e50\u90fd\u53ef\u80fd\u88ab\u8d2c\u4f4e\u6216\u5229\u7528\u3002\u9009\u62e9\u4e0e\u8c01\u5171\u5ea6&#xff0c;\u6bd4\u9009\u62e9\u505a\u4ec0\u4e48\u66f4\u91cd\u8981\u3002<\/p>\n<h3>\u5f15\u8a00&#xff1a;\u5f53\u4e1a\u52a1\u8bed\u8a00\u9047\u4e0a\u6280\u672fSchema<\/h3>\n<p>\u201c\u5e2e\u6211\u67e5\u4e00\u4e0b\u4e0a\u4e2a\u6708\u7684GMV\u3002\u201d<\/p>\n<p>\u9762\u5bf9\u8fd9\u4e2a\u7b80\u5355\u7684\u9700\u6c42&#xff0c;AI Agent\u9700\u8981\u5b8c\u6210\u4e00\u7cfb\u5217\u590d\u6742\u7684&#034;\u7ffb\u8bd1&#034;\u5de5\u4f5c&#xff1a;GMV\u662f\u4ec0\u4e48&#xff1f;\u5bf9\u5e94\u6570\u636e\u5e93\u91cc\u54ea\u4e2a\u5b57\u6bb5&#xff1f;\u5982\u679c\u7528\u6237\u8bf4&#034; gross merchandise value&#034;\u5462&#xff1f;\u5982\u679c\u4ed6\u8bf4&#034;\u603b\u4ea4\u6613\u989d&#034;\u5462&#xff1f;\u5982\u679c\u4e0d\u540c\u90e8\u95e8\u5bf9&#034;GMV&#034;\u7684\u5b9a\u4e49\u8fd8\u4e0d\u4e00\u6837&#xff08;\u6709\u7684\u542b\u9000\u6b3e&#xff0c;\u6709\u7684\u4e0d\u542b&#xff09;&#xff1f;<\/p>\n<p>\u8fd9\u5c31\u662f\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04&#xff08;Business Term to Field Mapping&#xff09;\u95ee\u9898\u2014\u2014AI Agent\u5728\u6570\u636e\u5206\u6790\u573a\u666f\u4e2d\u6700\u57fa\u7840\u3001\u4e5f\u6700\u81f4\u547d\u7684\u74f6\u9888\u3002\u672c\u6587\u5c06\u6df1\u5165\u5256\u6790\u8bed\u4e49\u5c42\u7684\u6784\u5efa\u65b9\u6cd5&#xff0c;\u5e76\u4ee5\u91d1\u4ed3KFS MCP Server\u4e3a\u5e95\u5ea7&#xff0c;\u5c55\u793a\u4e00\u5957\u53ef\u843d\u5730\u7684\u5de5\u7a0b\u65b9\u6848\u3002<\/p>\n<hr \/>\n<h3>\u4e00\u3001\u6838\u5fc3\u95ee\u9898&#xff1a;\u4e3a\u4ec0\u4e48AI Agent\u603b\u662f&#034;\u731c\u9519&#034;\u6570\u636e&#xff1f;<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032507-6a755013698fe.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>1.1 \u8bed\u4e49\u9e3f\u6c9f\u7684\u4e09\u91cd\u7ef4\u5ea6<\/h4>\n<p>\u5728\u4f01\u4e1a\u7ecf\u8425\u5206\u6790\u573a\u666f\u4e2d&#xff0c;\u4e1a\u52a1\u8bed\u8a00\u4e0e\u6280\u672fSchema\u4e4b\u95f4\u5b58\u5728\u5929\u7136\u7684\u8bed\u4e49\u9e3f\u6c9f&#xff1a;<\/p>\n<table>\n<tr>\u7ef4\u5ea6\u4e1a\u52a1\u8bed\u8a00\u6280\u672fSchema\u9e3f\u6c9f\u8868\u73b0<\/tr>\n<tbody>\n<tr>\n<td>\u547d\u540d\u5dee\u5f02<\/td>\n<td>\u201c\u5ba2\u6237\u6570\u201d<\/td>\n<td>cust_cnt\u3001user_total\u3001customer_count<\/td>\n<td>\u540c\u4e00\u6982\u5ff5&#xff0c;\u591a\u79cd\u547d\u540d<\/td>\n<\/tr>\n<tr>\n<td>\u7c92\u5ea6\u5dee\u5f02<\/td>\n<td>\u201c\u9500\u552e\u989d\u201d<\/td>\n<td>order_amount\u3001payment_amount\u3001settle_amount<\/td>\n<td>\u53e3\u5f84\u4e0d\u540c&#xff0c;\u7ed3\u679c\u8fe5\u5f02<\/td>\n<\/tr>\n<tr>\n<td>\u9690\u542b\u903b\u8f91<\/td>\n<td>\u201c\u6d3b\u8dc3\u7528\u6237\u201d<\/td>\n<td>\u9700\u7ec4\u5408last_login_date\u3001status\u3001vip_level<\/td>\n<td>\u4e1a\u52a1\u89c4\u5219\u672a\u663e\u5f0f\u5b9a\u4e49<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>1.2 \u7ecf\u8425\u5206\u6790\u573a\u666f\u7684\u5178\u578b\u75db\u70b9<\/h4>\n<p>\u4ee5\u4e00\u4e2a\u771f\u5b9e\u7684\u96f6\u552e\u4f01\u4e1a\u4e3a\u4f8b&#xff0c;\u5176\u6570\u636e\u4ed3\u5e93\u5305\u542b200&#043;\u5f20\u8868\u30015000&#043;\u4e2a\u5b57\u6bb5\u3002\u5f53\u4e1a\u52a1\u4eba\u5458\u95ee&#034;\u4e0a\u4e2a\u6708\u534e\u4e1c\u533a\u7684GMV&#034;\u65f6&#xff0c;AI Agent\u9762\u4e34\u4ee5\u4e0b\u6311\u6218&#xff1a;<\/p>\n<li>\u672f\u8bed\u6b67\u4e49&#xff1a;\u201cGMV&#034;\u5728\u8d22\u52a1\u90e8\u95e8\u6307&#034;\u8ba2\u5355\u91d1\u989d\u201d&#xff0c;\u5728\u8fd0\u8425\u90e8\u95e8\u6307&#034;\u652f\u4ed8\u91d1\u989d&#034;&#xff0c;\u5728\u7ba1\u7406\u5c42\u6307&#034;\u6210\u4ea4\u91d1\u989d&#xff08;\u53bb\u91cd&#xff09;&#034;<\/li>\n<li>\u7ef4\u5ea6\u7f3a\u5931&#xff1a;&#034;\u534e\u4e1c\u533a&#034;\u9700\u8981\u6620\u5c04\u5230region_code IN (&#039;310000&#039;, &#039;320000&#039;, &#039;330000&#039;, &#039;340000&#039;)<\/li>\n<li>\u65f6\u95f4\u53e3\u5f84&#xff1a;&#034;\u4e0a\u4e2a\u6708&#034;\u662f\u81ea\u7136\u6708\u8fd8\u662f\u8d22\u52a1\u6708&#xff1f;\u662f\u5426\u5305\u542b\u9000\u6b3e&#xff1f;<\/li>\n<li>\u8ba1\u7b97\u903b\u8f91&#xff1a;GMV &#061; SUM(order_amount) \u8fd8\u662f SUM(payment_amount) &#8211; SUM(refund_amount)&#xff1f;<\/li>\n<p>\u5982\u679c\u6ca1\u6709\u7ed3\u6784\u5316\u7684\u8bed\u4e49\u5c42&#xff0c;AI Agent\u53ea\u80fd\u57fa\u4e8e\u5b57\u6bb5\u540d\u505a\u6a21\u7cca\u5339\u914d&#xff0c;\u5176\u51c6\u786e\u7387\u53ef\u60f3\u800c\u77e5\u3002<\/p>\n<hr \/>\n<h3>\u4e8c\u3001\u8bed\u4e49\u5c42\u67b6\u6784&#xff1a;\u4ece&#034;\u731c&#034;\u5230&#034;\u61c2&#034;<\/h3>\n<h4>2.1 \u8bed\u4e49\u5c42\u7684\u5b9a\u4f4d<\/h4>\n<p>\u8bed\u4e49\u5c42&#xff08;Semantic Layer&#xff09;\u662fAI Agent\u4e0e\u6570\u636e\u5e93\u4e4b\u95f4\u7684&#034;\u7ffb\u8bd1\u5b98&#034;&#xff0c;\u5176\u6838\u5fc3\u804c\u8d23\u5305\u62ec&#xff1a;<\/p>\n<ul>\n<li>\u672f\u8bed\u6807\u51c6\u5316&#xff1a;\u7edf\u4e00\u4e1a\u52a1\u672f\u8bed\u7684\u5b9a\u4e49\u3001\u522b\u540d\u548c\u8ba1\u7b97\u903b\u8f91<\/li>\n<li>\u5b57\u6bb5\u6620\u5c04&#xff1a;\u5c06\u4e1a\u52a1\u672f\u8bed\u6620\u5c04\u5230\u5177\u4f53\u7684\u8868\u3001\u5b57\u6bb5\u548c\u8fc7\u6ee4\u6761\u4ef6<\/li>\n<li>\u53e3\u5f84\u6cbb\u7406&#xff1a;\u7ba1\u7406\u4e0d\u540c\u90e8\u95e8\u3001\u4e0d\u540c\u573a\u666f\u4e0b\u7684\u6307\u6807\u5b9a\u4e49<\/li>\n<li>\u6743\u9650\u9694\u79bb&#xff1a;\u6839\u636e\u7528\u6237\u89d2\u8272\u8fd4\u56de\u4e0d\u540c\u7684\u8bed\u4e49\u89e3\u91ca<\/li>\n<\/ul>\n<h4>2.2 \u4e09\u5c42\u67b6\u6784\u8bbe\u8ba1<\/h4>\n<p>\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502           \u4e1a\u52a1\u8bed\u8a00\u5c42 (Business Layer)    \u2502<br \/>\n\u2502    &#034;\u4e0a\u4e2a\u6708\u534e\u4e1c\u533a\u7684GMV&#034;                   \u2502<br \/>\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524<br \/>\n\u2502           \u8bed\u4e49\u89e3\u6790\u5c42 (Semantic Layer)    \u2502<br \/>\n\u2502    \u672f\u8bed\u8bc6\u522b \u2192 \u610f\u56fe\u5206\u7c7b \u2192 \u5b9e\u4f53\u63d0\u53d6        \u2502<br \/>\n\u2502    \u53e3\u5f84\u5339\u914d \u2192 \u6743\u9650\u6821\u9a8c \u2192 SQL\u751f\u6210          \u2502<br \/>\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524<br \/>\n\u2502           \u6570\u636e\u7269\u7406\u5c42 (Physical Layer)    \u2502<br \/>\n\u2502    SELECT SUM(payment_amount)            \u2502<br \/>\n\u2502    FROM fact_orders                      \u2502<br \/>\n\u2502    WHERE region_code IN (&#8230;)            \u2502<br \/>\n\u2502      AND order_date BETWEEN &#8230;          \u2502<br \/>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/p>\n<hr \/>\n<h3>\u4e09\u3001\u672f\u8bed\u8868\u8bbe\u8ba1&#xff1a;\u8bed\u4e49\u5c42\u7684&#034;\u8bcd\u5178&#034;<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032508-6a755014c8601.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>3.1 \u672f\u8bed\u8868\u6838\u5fc3\u7ed3\u6784<\/h4>\n<p><span class=\"token decorator annotation punctuation\">&#064;dataclass<\/span><br \/>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name\">BusinessTerm<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u4e1a\u52a1\u672f\u8bed\u5b9a\u4e49&#034;&#034;&#034;<\/span><br \/>\n    term_id<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                        <span class=\"token comment\"># \u672f\u8bed\u552f\u4e00\u6807\u8bc6<\/span><br \/>\n    canonical_name<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                 <span class=\"token comment\"># \u6807\u51c6\u540d\u79f0<\/span><br \/>\n    aliases<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">]<\/span>                  <span class=\"token comment\"># \u522b\u540d\u5217\u8868<\/span><br \/>\n    category<span class=\"token punctuation\">:<\/span> TermCategory              <span class=\"token comment\"># \u672f\u8bed\u5206\u7c7b<\/span><\/p>\n<p>    <span class=\"token comment\"># \u6280\u672f\u6620\u5c04<\/span><br \/>\n    primary_mapping<span class=\"token punctuation\">:<\/span> FieldMapping       <span class=\"token comment\"># \u4e3b\u6620\u5c04<\/span><br \/>\n    alternative_mappings<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span>FieldMapping<span class=\"token punctuation\">]<\/span>  <span class=\"token comment\"># \u5907\u9009\u6620\u5c04<\/span><\/p>\n<p>    <span class=\"token comment\"># \u4e1a\u52a1\u5b9a\u4e49<\/span><br \/>\n    definition<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                     <span class=\"token comment\"># \u4e1a\u52a1\u5b9a\u4e49<\/span><br \/>\n    calculation_logic<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>               <span class=\"token comment\"># \u8ba1\u7b97\u903b\u8f91<\/span><br \/>\n    business_owner<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                <span class=\"token comment\"># \u4e1a\u52a1\u8d1f\u8d23\u4eba<\/span><\/p>\n<p>    <span class=\"token comment\"># \u7248\u672c\u4e0e\u6743\u9650<\/span><br \/>\n    version<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">int<\/span>                        <span class=\"token comment\"># \u7248\u672c\u53f7<\/span><br \/>\n    effective_date<span class=\"token punctuation\">:<\/span> datetime           <span class=\"token comment\"># \u751f\u6548\u65e5\u671f<\/span><br \/>\n    departments<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span><span class=\"token builtin\">str<\/span><span class=\"token punctuation\">]<\/span>            <span class=\"token comment\"># \u9002\u7528\u90e8\u95e8<\/span><\/p>\n<p>    <span class=\"token comment\"># \u5ba1\u8ba1<\/span><br \/>\n    created_by<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><br \/>\n    created_at<span class=\"token punctuation\">:<\/span> datetime<br \/>\n    updated_at<span class=\"token punctuation\">:<\/span> datetime<\/p>\n<p><span class=\"token decorator annotation punctuation\">&#064;dataclass<\/span><br \/>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name\">FieldMapping<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u5b57\u6bb5\u6620\u5c04\u5b9a\u4e49&#034;&#034;&#034;<\/span><br \/>\n    mapping_id<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><br \/>\n    table_name<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><br \/>\n    field_name<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><br \/>\n    aggregation<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                    <span class=\"token comment\"># SUM\/AVG\/COUNT\u7b49<\/span><br \/>\n    filter_conditions<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span>Filter<span class=\"token punctuation\">]<\/span>    <span class=\"token comment\"># \u8fc7\u6ee4\u6761\u4ef6<\/span><\/p>\n<p>    <span class=\"token comment\"># \u7ef4\u5ea6\u5173\u8054<\/span><br \/>\n    dimension_joins<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span>DimensionJoin<span class=\"token punctuation\">]<\/span><\/p>\n<p>    <span class=\"token comment\"># \u6570\u636e\u8d28\u91cf<\/span><br \/>\n    data_quality_rules<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span>QualityRule<span class=\"token punctuation\">]<\/span><\/p>\n<p><span class=\"token decorator annotation punctuation\">&#064;dataclass<\/span><br \/>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name\">Filter<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u8fc7\u6ee4\u6761\u4ef6&#034;&#034;&#034;<\/span><br \/>\n    field<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><br \/>\n    operator<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                       <span class=\"token comment\"># &#061;, IN, BETWEEN\u7b49<\/span><br \/>\n    value<span class=\"token punctuation\">:<\/span> Any<br \/>\n    value_type<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span>                     <span class=\"token comment\"># literal\/parameter\/subquery<\/span><\/p>\n<h4>3.2 \u7ecf\u8425\u5206\u6790\u672f\u8bed\u8868\u793a\u4f8b<\/h4>\n<table>\n<tr>\u672f\u8bedID\u6807\u51c6\u540d\u79f0\u522b\u540d\u4e3b\u6620\u5c04\u8868\u4e3b\u6620\u5c04\u5b57\u6bb5\u805a\u5408\u65b9\u5f0f\u9002\u7528\u90e8\u95e8<\/tr>\n<tbody>\n<tr>\n<td>T_001<\/td>\n<td>GMV<\/td>\n<td>\u603b\u4ea4\u6613\u989d, Gross Merchandise Value<\/td>\n<td>fact_orders<\/td>\n<td>order_amount<\/td>\n<td>SUM<\/td>\n<td>\u5168\u516c\u53f8<\/td>\n<\/tr>\n<tr>\n<td>T_002<\/td>\n<td>\u652f\u4ed8GMV<\/td>\n<td>\u6210\u4ea4\u91d1\u989d, \u5b9e\u6536\u91d1\u989d<\/td>\n<td>fact_orders<\/td>\n<td>payment_amount<\/td>\n<td>SUM<\/td>\n<td>\u8d22\u52a1<\/td>\n<\/tr>\n<tr>\n<td>T_003<\/td>\n<td>\u51c0GMV<\/td>\n<td>\u53bb\u9000\u6b3eGMV<\/td>\n<td>fact_orders<\/td>\n<td>net_amount<\/td>\n<td>SUM<\/td>\n<td>\u8fd0\u8425<\/td>\n<\/tr>\n<tr>\n<td>T_004<\/td>\n<td>\u6d3b\u8dc3\u7528\u6237\u6570<\/td>\n<td>DAU, \u65e5\u6d3b<\/td>\n<td>dim_users<\/td>\n<td>user_id<\/td>\n<td>COUNT DISTINCT<\/td>\n<td>\u8fd0\u8425<\/td>\n<\/tr>\n<tr>\n<td>T_005<\/td>\n<td>\u5ba2\u5355\u4ef7<\/td>\n<td>ATV, \u4eba\u5747\u6d88\u8d39<\/td>\n<td>fact_orders<\/td>\n<td>order_amount<\/td>\n<td>AVG<\/td>\n<td>\u8fd0\u8425<\/td>\n<\/tr>\n<tr>\n<td>T_006<\/td>\n<td>\u534e\u4e1c\u533a<\/td>\n<td>\u534e\u4e1c\u5730\u533a, \u534e\u4e1c\u5927\u533a<\/td>\n<td>dim_regions<\/td>\n<td>region_code<\/td>\n<td>IN (\u2018310000\u2019, \u2018320000\u2019, \u2018330000\u2019, \u2018340000\u2019)<\/td>\n<td>\u5168\u516c\u53f8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h3>\u56db\u3001\u6620\u5c04\u89c4\u5219&#xff1a;\u4ece\u672f\u8bed\u5230SQL<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032509-6a755015e97d8.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>4.1 \u6620\u5c04\u89c4\u5219\u5f15\u64ce<\/h4>\n<p><span class=\"token keyword\">class<\/span> <span class=\"token class-name\">SemanticMappingEngine<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u8bed\u4e49\u6620\u5c04\u5f15\u64ce&#034;&#034;&#034;<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> term_repository<span class=\"token punctuation\">:<\/span> TermRepository<span class=\"token punctuation\">,<\/span><br \/>\n                 user_context<span class=\"token punctuation\">:<\/span> UserContext<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>term_repo <span class=\"token operator\">&#061;<\/span> term_repository<br \/>\n        self<span class=\"token punctuation\">.<\/span>user_ctx <span class=\"token operator\">&#061;<\/span> user_context<\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">parse_query<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> natural_language<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> ParsedQuery<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n        \u89e3\u6790\u81ea\u7136\u8bed\u8a00\u67e5\u8be2<br \/>\n        \u8f93\u5165: &#034;\u4e0a\u4e2a\u6708\u534e\u4e1c\u533a\u7684GMV&#034;<br \/>\n        \u8f93\u51fa: \u7ed3\u6784\u5316\u67e5\u8be2\u5bf9\u8c61<br \/>\n        &#034;&#034;&#034;<\/span><br \/>\n        <span class=\"token comment\"># 1. \u5206\u8bcd\u4e0e\u672f\u8bed\u8bc6\u522b<\/span><br \/>\n        tokens <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_tokenize<span class=\"token punctuation\">(<\/span>natural_language<span class=\"token punctuation\">)<\/span><br \/>\n        terms <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_identify_terms<span class=\"token punctuation\">(<\/span>tokens<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># 2. \u610f\u56fe\u5206\u7c7b<\/span><br \/>\n        intent <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_classify_intent<span class=\"token punctuation\">(<\/span>tokens<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># 3. \u5b9e\u4f53\u63d0\u53d6<\/span><br \/>\n        entities <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_extract_entities<span class=\"token punctuation\">(<\/span>tokens<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># 4. \u8bed\u4e49\u6d88\u6b67<\/span><br \/>\n        resolved_terms <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_resolve_ambiguity<span class=\"token punctuation\">(<\/span>terms<span class=\"token punctuation\">,<\/span> self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">return<\/span> ParsedQuery<span class=\"token punctuation\">(<\/span>intent<span class=\"token operator\">&#061;<\/span>intent<span class=\"token punctuation\">,<\/span> entities<span class=\"token operator\">&#061;<\/span>entities<span class=\"token punctuation\">,<\/span><br \/>\n                          terms<span class=\"token operator\">&#061;<\/span>resolved_terms<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">generate_sql<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> parsed_query<span class=\"token punctuation\">:<\/span> ParsedQuery<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> GeneratedSQL<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n        \u751f\u6210SQL\u67e5\u8be2<br \/>\n        &#034;&#034;&#034;<\/span><br \/>\n        <span class=\"token comment\"># 1. \u83b7\u53d6\u672f\u8bed\u6620\u5c04<\/span><br \/>\n        mappings <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> term <span class=\"token keyword\">in<\/span> parsed_query<span class=\"token punctuation\">.<\/span>terms<span class=\"token punctuation\">:<\/span><br \/>\n            mapping <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>term_repo<span class=\"token punctuation\">.<\/span>get_mapping<span class=\"token punctuation\">(<\/span><br \/>\n                term<span class=\"token punctuation\">,<\/span><br \/>\n                department<span class=\"token operator\">&#061;<\/span>self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>department<span class=\"token punctuation\">,<\/span><br \/>\n                scenario<span class=\"token operator\">&#061;<\/span>self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>scenario<br \/>\n            <span class=\"token punctuation\">)<\/span><br \/>\n            mappings<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span>mapping<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># 2. \u6784\u5efa\u67e5\u8be2<\/span><br \/>\n        sql_builder <span class=\"token operator\">&#061;<\/span> SQLBuilder<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">for<\/span> mapping <span class=\"token keyword\">in<\/span> mappings<span class=\"token punctuation\">:<\/span><br \/>\n            sql_builder<span class=\"token punctuation\">.<\/span>add_field<span class=\"token punctuation\">(<\/span>mapping<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># 3. \u5e94\u7528\u6743\u9650\u8fc7\u6ee4<\/span><br \/>\n        sql_builder<span class=\"token punctuation\">.<\/span>apply_row_level_security<span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># 4. \u751f\u6210\u6700\u7ec8SQL<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> sql_builder<span class=\"token punctuation\">.<\/span>build<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h4>4.2 \u6620\u5c04\u89c4\u5219\u793a\u4f8b<\/h4>\n<p><span class=\"token comment\"># \u89c4\u52191: GMV\u8ba1\u7b97\u89c4\u5219<\/span><br \/>\nGMV_RULE <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n    <span class=\"token string\">&#034;term&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;GMV&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;mappings&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token string\">&#034;default&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n            <span class=\"token string\">&#034;table&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;fact_orders&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;order_amount&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;aggregation&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;SUM&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;filters&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n                <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;order_status&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;operator&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;!&#061;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;value&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;cancelled&#034;<\/span><span class=\"token punctuation\">}<\/span><br \/>\n            <span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;finance&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n            <span class=\"token string\">&#034;table&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;fact_orders&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;payment_amount&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;aggregation&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;SUM&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;filters&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n                <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;payment_status&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;operator&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;&#061;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;value&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;paid&#034;<\/span><span class=\"token punctuation\">}<\/span><br \/>\n            <span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;operation&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n            <span class=\"token string\">&#034;table&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;fact_orders&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;net_amount&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;aggregation&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;SUM&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;filters&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><br \/>\n                <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;order_status&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;operator&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;in&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                 <span class=\"token string\">&#034;value&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;completed&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;shipped&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;delivered&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><br \/>\n            <span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token punctuation\">}<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<p><span class=\"token comment\"># \u89c4\u52192: \u533a\u57df\u6620\u5c04\u89c4\u5219<\/span><br \/>\nREGION_RULE <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n    <span class=\"token string\">&#034;term&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;\u534e\u4e1c\u533a&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;mappings&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token string\">&#034;default&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n            <span class=\"token string\">&#034;dimension_table&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;dim_regions&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;filter&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n                <span class=\"token string\">&#034;field&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;region_code&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;operator&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;IN&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;values&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;310000&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;320000&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;330000&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;340000&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            <span class=\"token punctuation\">}<\/span><br \/>\n        <span class=\"token punctuation\">}<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<p><span class=\"token comment\"># \u89c4\u52193: \u65f6\u95f4\u6620\u5c04\u89c4\u5219<\/span><br \/>\nTIME_RULE <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n    <span class=\"token string\">&#034;term&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;\u4e0a\u4e2a\u6708&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;mappings&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token string\">&#034;default&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n            <span class=\"token string\">&#034;function&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;DATE_TRUNC(&#039;month&#039;, CURRENT_DATE &#8211; INTERVAL &#039;1 month&#039;)&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token string\">&#034;range&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n                <span class=\"token string\">&#034;start&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;DATE_TRUNC(&#039;month&#039;, CURRENT_DATE &#8211; INTERVAL &#039;1 month&#039;)&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;end&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;DATE_TRUNC(&#039;month&#039;, CURRENT_DATE) &#8211; INTERVAL &#039;1 day&#039;&#034;<\/span><br \/>\n            <span class=\"token punctuation\">}<\/span><br \/>\n        <span class=\"token punctuation\">}<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<hr \/>\n<h3>\u4e94\u3001\u91d1\u4ed3KFS MCP Server&#xff1a;\u8bed\u4e49\u5c42\u7684\u6700\u4f73\u8f7d\u4f53<\/h3>\n<h4>5.1 \u4e3a\u4ec0\u4e48\u9009KFS MCP Server&#xff1f;<\/h4>\n<p>\u91d1\u4ed3KFS MCP Server\u4e0d\u4ec5\u662f\u6570\u636e\u5e93\u8fde\u63a5\u5668&#xff0c;\u66f4\u662f\u8bed\u4e49\u5c42\u7684\u7406\u60f3\u8f7d\u4f53\u3002\u5176\u67b6\u6784\u5929\u7136\u652f\u6301\u8bed\u4e49\u5c42\u7684\u5206\u5c42\u8bbe\u8ba1&#xff1a;<\/p>\n<p>\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502         AI \u5ba2\u6237\u7aef (Cursor\/Trae)        \u2502<br \/>\n\u2502         &#034;\u4e0a\u4e2a\u6708\u534e\u4e1c\u533a\u7684GMV&#034;              \u2502<br \/>\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524<br \/>\n\u2502      \u8bed\u4e49\u89e3\u6790\u5c42 (Semantic Parser)        \u2502<br \/>\n\u2502    \u672f\u8bed\u8bc6\u522b \u2502 \u610f\u56fe\u5206\u7c7b \u2502 \u5b9e\u4f53\u63d0\u53d6         \u2502<br \/>\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524<br \/>\n\u2502      KFS MCP Server                     \u2502<br \/>\n\u2502    \u251c\u2500 \u672f\u8bed\u8868\u67e5\u8be2 (list_terms)            \u2502<br \/>\n\u2502    \u251c\u2500 \u6620\u5c04\u89c4\u5219\u6267\u884c (get_mapping)         \u2502<br \/>\n\u2502    \u251c\u2500 SQL\u751f\u6210 (generate_sql)            \u2502<br \/>\n\u2502    \u2514\u2500 \u5b89\u5168\u6821\u9a8c (validate_sql)           \u2502<br \/>\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524<br \/>\n\u2502      KingbaseES \u6570\u636e\u5e93                    \u2502<br \/>\n\u2502    \u251c\u2500 \u672f\u8bed\u5b57\u5178\u8868 (sys_semantic_terms)    \u2502<br \/>\n\u2502    \u251c\u2500 \u6620\u5c04\u89c4\u5219\u8868 (sys_field_mappings)   \u2502<br \/>\n\u2502    \u2514\u2500 \u4e1a\u52a1\u6570\u636e\u8868                         \u2502<br \/>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/p>\n<h4>5.2 \u5b89\u5168\u63a7\u5236&#xff1a;\u8bed\u4e49\u5c42\u7684&#034;\u62a4\u680f&#034;<\/h4>\n<p>\u5728\u591a\u7528\u6237\u3001\u591a\u90e8\u95e8\u7684\u7ecf\u8425\u5206\u6790\u573a\u666f\u4e2d&#xff0c;\u5b89\u5168\u63a7\u5236\u81f3\u5173\u91cd\u8981\u3002\u91d1\u4ed3KFS MCP Server\u63d0\u4f9b\u53cc\u91cd\u5b89\u5168\u4fdd\u969c&#xff1a;<\/p>\n<p>Restricted\u6a21\u5f0f\u4e0b\u7684\u8bed\u4e49\u5b89\u5168<\/p>\n<p><span class=\"token keyword\">class<\/span> <span class=\"token class-name\">SemanticSecurityPolicy<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u8bed\u4e49\u5c42\u5b89\u5168\u7b56\u7565&#034;&#034;&#034;<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> user_context<span class=\"token punctuation\">:<\/span> UserContext<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>user_ctx <span class=\"token operator\">&#061;<\/span> user_context<\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">validate_term_access<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> term<span class=\"token punctuation\">:<\/span> BusinessTerm<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token builtin\">bool<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n        \u9a8c\u8bc1\u7528\u6237\u5bf9\u672f\u8bed\u7684\u8bbf\u95ee\u6743\u9650<br \/>\n        &#034;&#034;&#034;<\/span><br \/>\n        <span class=\"token comment\"># 1. \u90e8\u95e8\u6743\u9650\u6821\u9a8c<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> self<span class=\"token punctuation\">.<\/span>_check_department_access<span class=\"token punctuation\">(<\/span>term<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span><\/p>\n<p>        <span class=\"token comment\"># 2. \u89d2\u8272\u6743\u9650\u6821\u9a8c<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> self<span class=\"token punctuation\">.<\/span>_check_role_access<span class=\"token punctuation\">(<\/span>term<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span><\/p>\n<p>        <span class=\"token comment\"># 3. \u6570\u636e\u8303\u56f4\u6821\u9a8c<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token keyword\">not<\/span> self<span class=\"token punctuation\">.<\/span>_check_data_scope<span class=\"token punctuation\">(<\/span>term<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span><\/p>\n<p>        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">True<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">filter_sensitive_terms<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> terms<span class=\"token punctuation\">:<\/span> List<span class=\"token punctuation\">[<\/span>BusinessTerm<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> List<span class=\"token punctuation\">[<\/span>BusinessTerm<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n        \u8fc7\u6ee4\u654f\u611f\u672f\u8bed<br \/>\n        &#034;&#034;&#034;<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token punctuation\">[<\/span>t <span class=\"token keyword\">for<\/span> t <span class=\"token keyword\">in<\/span> terms <span class=\"token keyword\">if<\/span> self<span class=\"token punctuation\">.<\/span>validate_term_access<span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">_check_department_access<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> term<span class=\"token punctuation\">:<\/span> BusinessTerm<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token builtin\">bool<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u68c0\u67e5\u90e8\u95e8\u6743\u9650&#034;&#034;&#034;<\/span><br \/>\n        user_dept <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>department<br \/>\n        <span class=\"token keyword\">return<\/span> user_dept <span class=\"token keyword\">in<\/span> term<span class=\"token punctuation\">.<\/span>departments <span class=\"token keyword\">or<\/span> <span class=\"token string\">&#039;all&#039;<\/span> <span class=\"token keyword\">in<\/span> term<span class=\"token punctuation\">.<\/span>departments<\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">_check_role_access<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> term<span class=\"token punctuation\">:<\/span> BusinessTerm<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token builtin\">bool<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u68c0\u67e5\u89d2\u8272\u6743\u9650&#034;&#034;&#034;<\/span><br \/>\n        user_role <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>role<br \/>\n        <span class=\"token comment\"># \u654f\u611f\u672f\u8bed\u4ec5\u5bf9\u9ad8\u7ba1\u5f00\u653e<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> term<span class=\"token punctuation\">.<\/span>sensitivity <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#039;high&#039;<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> user_role <span class=\"token keyword\">in<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;executive&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;senior_manager&#039;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">True<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">_check_data_scope<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> term<span class=\"token punctuation\">:<\/span> BusinessTerm<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token builtin\">bool<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u68c0\u67e5\u6570\u636e\u8303\u56f4&#034;&#034;&#034;<\/span><br \/>\n        <span class=\"token comment\"># \u533a\u57df\u7ecf\u7406\u53ea\u80fd\u67e5\u770b\u81ea\u5df1\u533a\u57df\u7684\u6570\u636e<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>role <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#039;regional_manager&#039;<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> term<span class=\"token punctuation\">.<\/span>region <span class=\"token operator\">&#061;&#061;<\/span> self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>region<br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">True<\/span><\/p>\n<h4>5.3 \u5de5\u5177\u8c03\u7528&#xff1a;\u8bed\u4e49\u5c42\u7684&#034;\u6b66\u5668\u5e93&#034;<\/h4>\n<p>\u91d1\u4ed3KFS MCP Server\u5c06\u8bed\u4e49\u5c42\u64cd\u4f5c\u5c01\u88c5\u4e3a\u6807\u51c6\u5316\u5de5\u5177&#xff0c;\u4f9bAI Agent\u8c03\u7528&#xff1a;<\/p>\n<table>\n<tr>\u5de5\u5177\u540d\u79f0\u529f\u80fd\u63cf\u8ff0\u7ecf\u8425\u5206\u6790\u573a\u666f<\/tr>\n<tbody>\n<tr>\n<td>list_terms<\/td>\n<td>\u5217\u51fa\u6240\u6709\u4e1a\u52a1\u672f\u8bed<\/td>\n<td>\u201c\u6709\u54ea\u4e9b\u9500\u552e\u6307\u6807&#xff1f;\u201d<\/td>\n<\/tr>\n<tr>\n<td>get_term_details<\/td>\n<td>\u83b7\u53d6\u672f\u8bed\u8be6\u60c5<\/td>\n<td>\u201cGMV\u7684\u5b9a\u4e49\u662f\u4ec0\u4e48&#xff1f;\u201d<\/td>\n<\/tr>\n<tr>\n<td>search_terms<\/td>\n<td>\u6a21\u7cca\u641c\u7d22\u672f\u8bed<\/td>\n<td>\u201c\u8ddf\u2019\u9000\u6b3e\u2019\u76f8\u5173\u7684\u6307\u6807\u201d<\/td>\n<\/tr>\n<tr>\n<td>get_mapping<\/td>\n<td>\u83b7\u53d6\u5b57\u6bb5\u6620\u5c04<\/td>\n<td>\u201cGMV\u5bf9\u5e94\u54ea\u4e2a\u5b57\u6bb5&#xff1f;\u201d<\/td>\n<\/tr>\n<tr>\n<td>validate_mapping<\/td>\n<td>\u9a8c\u8bc1\u6620\u5c04\u6b63\u786e\u6027<\/td>\n<td>\u201c\u8fd9\u4e2a\u53e3\u5f84\u5bf9\u5417&#xff1f;\u201d<\/td>\n<\/tr>\n<tr>\n<td>generate_sql<\/td>\n<td>\u751f\u6210SQL\u67e5\u8be2<\/td>\n<td>\u201c\u751f\u6210\u67e5\u8be2SQL\u201d<\/td>\n<\/tr>\n<tr>\n<td>explain_semantics<\/td>\n<td>\u89e3\u91ca\u8bed\u4e49\u903b\u8f91<\/td>\n<td>\u201c\u4e3a\u4ec0\u4e48\u7528\u8fd9\u4e2a\u5b57\u6bb5&#xff1f;\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u5de5\u5177\u8c03\u7528\u94fe\u793a\u4f8b<\/p>\n<p>\u7528\u6237: &#034;\u4e0a\u4e2a\u6708\u534e\u4e1c\u533a\u7684GMV&#034;<br \/>\n  \u2193<br \/>\n[\u8c03\u7528 list_terms] \u2192 \u8bc6\u522b&#034;GMV&#034;\u3001&#034;\u534e\u4e1c\u533a&#034;\u3001&#034;\u4e0a\u4e2a\u6708&#034;<br \/>\n  \u2193<br \/>\n[\u8c03\u7528 get_mapping] \u2192 \u83b7\u53d6GMV\u7684\u5b57\u6bb5\u6620\u5c04<br \/>\n  \u2193<br \/>\n[\u8c03\u7528 generate_sql] \u2192 \u751f\u6210\u5b8c\u6574SQL<br \/>\n  \u2193<br \/>\n[\u8c03\u7528 validate_mapping] \u2192 \u9a8c\u8bc1SQL\u6b63\u786e\u6027<br \/>\n  \u2193<br \/>\n[\u6267\u884cSQL] \u2192 \u8fd4\u56de\u7ed3\u679c<\/p>\n<hr \/>\n<h3>\u516d\u3001\u5b9e\u6218\u6848\u4f8b&#xff1a;\u7ecf\u8425\u5206\u6790\u4e2d\u7684\u672f\u8bed\u6620\u5c04<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032510-6a755016e54e2.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>6.1 \u573a\u666f\u8bbe\u5b9a<\/h4>\n<p>\u67d0\u96f6\u552e\u4f01\u4e1a\u6709\u4ee5\u4e0b\u51e0\u4e2a\u90e8\u95e8&#xff1a;<\/p>\n<ul>\n<li>\u8d22\u52a1\u90e8&#xff1a;\u5173\u6ce8&#034;\u652f\u4ed8GMV&#034;\u3001\u201c\u9000\u6b3e\u7387\u201d\u3001\u201c\u6bdb\u5229\u201d<\/li>\n<li>\u8fd0\u8425\u90e8&#xff1a;\u5173\u6ce8&#034;\u6d3b\u8dc3\u7528\u6237\u6570&#034;\u3001\u201c\u5ba2\u5355\u4ef7\u201d\u3001\u201c\u590d\u8d2d\u7387\u201d<\/li>\n<li>\u7ba1\u7406\u5c42&#xff1a;\u5173\u6ce8&#034;\u603bGMV&#034;\u3001\u201c\u540c\u6bd4\u589e\u957f\u7387\u201d\u3001\u201c\u533a\u57df\u6392\u540d\u201d<\/li>\n<\/ul>\n<h4>6.2 \u672f\u8bed\u51b2\u7a81\u4e0e\u89e3\u51b3<\/h4>\n<p>\u51b2\u7a81\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u8d22\u52a1\u90e8\u7684&#034;GMV&#034; &#061; SUM(payment_amount) WHERE payment_status &#061; \u2018paid\u2019<\/li>\n<li>\u8fd0\u8425\u90e8\u7684&#034;GMV&#034; &#061; SUM(net_amount) WHERE order_status IN (\u2018completed\u2019, \u2018shipped\u2019)<\/li>\n<li>\u7ba1\u7406\u5c42\u7684&#034;GMV&#034; &#061; SUM(order_amount) WHERE order_status !&#061; \u2018cancelled\u2019<\/li>\n<\/ul>\n<p>\u89e3\u51b3\u65b9\u6848&#xff1a;<\/p>\n<p><span class=\"token comment\"># \u57fa\u4e8e\u7528\u6237\u89d2\u8272\u7684\u672f\u8bed\u6620\u5c04<\/span><br \/>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name\">RoleBasedMapping<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u57fa\u4e8e\u89d2\u8272\u7684\u672f\u8bed\u6620\u5c04&#034;&#034;&#034;<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> user_context<span class=\"token punctuation\">:<\/span> UserContext<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>user_ctx <span class=\"token operator\">&#061;<\/span> user_context<\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">get_gmv_mapping<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> FieldMapping<span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token triple-quoted-string string\">&#034;&#034;&#034;\u6839\u636e\u7528\u6237\u89d2\u8272\u8fd4\u56deGMV\u6620\u5c04&#034;&#034;&#034;<\/span><br \/>\n        role <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>user_ctx<span class=\"token punctuation\">.<\/span>role<\/p>\n<p>        <span class=\"token keyword\">if<\/span> role <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#039;finance&#039;<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> FieldMapping<span class=\"token punctuation\">(<\/span><br \/>\n                table<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;fact_orders&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;payment_amount&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                aggregation<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;SUM&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                filters<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>Filter<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;payment_status&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;&#061;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;paid&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">elif<\/span> role <span class=\"token operator\">&#061;&#061;<\/span> <span class=\"token string\">&#039;operation&#039;<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> FieldMapping<span class=\"token punctuation\">(<\/span><br \/>\n                table<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;fact_orders&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;net_amount&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                aggregation<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;SUM&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                filters<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>Filter<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;order_status&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;IN&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                              <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;completed&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;shipped&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;delivered&#034;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span>  <span class=\"token comment\"># management<\/span><br \/>\n            <span class=\"token keyword\">return<\/span> FieldMapping<span class=\"token punctuation\">(<\/span><br \/>\n                table<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;fact_orders&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;order_amount&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                aggregation<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;SUM&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                filters<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>Filter<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;order_status&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;!&#061;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;cancelled&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">]<\/span><br \/>\n            <span class=\"token punctuation\">)<\/span><\/p>\n<h4>6.3 \u5b8c\u6574\u5bf9\u8bdd\u793a\u4f8b<\/h4>\n<p>\u7528\u6237&#xff08;\u8fd0\u8425\u90e8&#xff09;: &#034;\u67e5\u4e00\u4e0b\u4e0a\u4e2a\u6708\u7684\u5ba2\u5355\u4ef7&#034;<\/p>\n<p>AI Agent:<br \/>\n[\u672f\u8bed\u8bc6\u522b] &#034;\u5ba2\u5355\u4ef7&#034; \u2192 ATV (Average Transaction Value)<br \/>\n[\u89d2\u8272\u8bc6\u522b] \u7528\u6237\u5c5e\u4e8e\u8fd0\u8425\u90e8<br \/>\n[\u6620\u5c04\u89c4\u5219] ATV &#061; AVG(order_amount) WHERE order_status IN (&#039;completed&#039;, &#039;shipped&#039;)<br \/>\n[\u65f6\u95f4\u6620\u5c04] &#034;\u4e0a\u4e2a\u6708&#034; \u2192 2024-07-01 \u81f3 2024-07-31<br \/>\n[\u751f\u6210SQL]<br \/>\n  SELECT AVG(order_amount) as atv<br \/>\n  FROM fact_orders<br \/>\n  WHERE order_status IN (&#039;completed&#039;, &#039;shipped&#039;)<br \/>\n    AND order_date BETWEEN &#039;2024-07-01&#039; AND &#039;2024-07-31&#039;<br \/>\n[\u6267\u884c\u7ed3\u679c] \u00a5385.6<\/p>\n<p>\u7528\u6237: &#034;\u90a3\u534e\u4e1c\u533a\u5462&#xff1f;&#034;<\/p>\n<p>AI Agent:<br \/>\n[\u4e0a\u4e0b\u6587\u7ee7\u627f] \u4fdd\u6301&#034;\u5ba2\u5355\u4ef7&#034;\u548c&#034;\u4e0a\u4e2a\u6708&#034;<br \/>\n[\u65b0\u589e\u7ef4\u5ea6] &#034;\u534e\u4e1c\u533a&#034; \u2192 region_code IN (&#039;310000&#039;, &#039;320000&#039;, &#039;330000&#039;, &#039;340000&#039;)<br \/>\n[\u751f\u6210SQL]<br \/>\n  SELECT AVG(order_amount) as atv<br \/>\n  FROM fact_orders o<br \/>\n  JOIN dim_regions r ON o.region_id &#061; r.region_id<br \/>\n  WHERE o.order_status IN (&#039;completed&#039;, &#039;shipped&#039;)<br \/>\n    AND o.order_date BETWEEN &#039;2024-07-01&#039; AND &#039;2024-07-31&#039;<br \/>\n    AND r.region_code IN (&#039;310000&#039;, &#039;320000&#039;, &#039;330000&#039;, &#039;340000&#039;)<br \/>\n[\u6267\u884c\u7ed3\u679c] \u00a5412.3<\/p>\n<hr \/>\n<h3>\u4e03\u3001\u6548\u679c\u8bc4\u4f30&#xff1a;\u8bed\u4e49\u5c42\u7684\u4ef7\u503c\u91cf\u5316<\/h3>\n<h4>7.1 \u8bc4\u4f30\u6307\u6807<\/h4>\n<table>\n<tr>\u6307\u6807\u5b9a\u4e49\u76ee\u6807\u503c<\/tr>\n<tbody>\n<tr>\n<td>\u672f\u8bed\u8bc6\u522b\u51c6\u786e\u7387<\/td>\n<td>\u6b63\u786e\u8bc6\u522b\u4e1a\u52a1\u672f\u8bed\u7684\u6bd4\u4f8b<\/td>\n<td>&gt;95%<\/td>\n<\/tr>\n<tr>\n<td>\u6620\u5c04\u6b63\u786e\u7387<\/td>\n<td>\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\u6b63\u786e\u7684\u6bd4\u4f8b<\/td>\n<td>&gt;98%<\/td>\n<\/tr>\n<tr>\n<td>\u53e3\u5f84\u4e00\u81f4\u6027<\/td>\n<td>\u540c\u4e00\u672f\u8bed\u5728\u4e0d\u540c\u573a\u666f\u4e0b\u7ed3\u679c\u4e00\u81f4\u7684\u6bd4\u4f8b<\/td>\n<td>100%<\/td>\n<\/tr>\n<tr>\n<td>\u67e5\u8be2\u6210\u529f\u7387<\/td>\n<td>\u81ea\u7136\u8bed\u8a00\u67e5\u8be2\u6210\u529f\u8f6c\u5316\u4e3aSQL\u7684\u6bd4\u4f8b<\/td>\n<td>&gt;90%<\/td>\n<\/tr>\n<tr>\n<td>\u7528\u6237\u6ee1\u610f\u5ea6<\/td>\n<td>\u4e1a\u52a1\u4eba\u5458\u5bf9\u67e5\u8be2\u7ed3\u679c\u7684\u6ee1\u610f\u7a0b\u5ea6<\/td>\n<td>&gt;4.5\/5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>7.2 \u91d1\u4ed3KFS MCP Server\u7684\u8bc4\u4f30\u7ed3\u679c<\/h4>\n<p>\u5728\u5b9e\u9645\u9879\u76ee\u4e2d&#xff0c;\u57fa\u4e8e\u91d1\u4ed3KFS MCP Server\u6784\u5efa\u7684\u8bed\u4e49\u5c42\u53d6\u5f97\u4e86\u4ee5\u4e0b\u6548\u679c&#xff1a;<\/p>\n<ul>\n<li>\u672f\u8bed\u8bc6\u522b\u51c6\u786e\u7387&#xff1a;97.3%&#xff08;\u57fa\u4e8e200&#043;\u672f\u8bed\u30015000&#043;\u6b21\u67e5\u8be2&#xff09;<\/li>\n<li>\u6620\u5c04\u6b63\u786e\u7387&#xff1a;99.1%&#xff08;\u4eba\u5de5\u6821\u9a8c1000\u6b21\u67e5\u8be2&#xff09;<\/li>\n<li>\u67e5\u8be2\u54cd\u5e94\u65f6\u95f4&#xff1a;\u5e73\u5747&lt;2\u79d2&#xff08;\u542b\u8bed\u4e49\u89e3\u6790&#043;SQL\u751f\u6210&#043;\u6267\u884c&#xff09;<\/li>\n<li>\u4e1a\u52a1\u4eba\u5458\u6ee1\u610f\u5ea6&#xff1a;4.7\/5&#xff08;\u57fa\u4e8e50\u540d\u4e1a\u52a1\u4eba\u5458\u8c03\u7814&#xff09;<\/li>\n<\/ul>\n<hr \/>\n<h3>\u516b\u3001\u603b\u7ed3\u4e0e\u5c55\u671b<\/h3>\n<p>\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\u662fAI Agent\u5728\u6570\u636e\u5206\u6790\u573a\u666f\u4e2d\u7684\u6838\u5fc3\u80fd\u529b\u3002\u901a\u8fc7\u6784\u5efa\u7ed3\u6784\u5316\u7684\u8bed\u4e49\u5c42&#xff0c;\u6211\u4eec\u53ef\u4ee5&#xff1a;<\/p>\n<li>\u6d88\u9664\u8bed\u4e49\u9e3f\u6c9f&#xff1a;\u8ba9AI Agent\u771f\u6b63&#034;\u542c\u61c2&#034;\u4e1a\u52a1\u8bed\u8a00<\/li>\n<li>\u4fdd\u969c\u53e3\u5f84\u4e00\u81f4&#xff1a;\u907f\u514d\u4e0d\u540c\u90e8\u95e8\u3001\u4e0d\u540c\u573a\u666f\u4e0b\u7684\u6570\u636e\u6b67\u4e49<\/li>\n<li>\u63d0\u5347\u67e5\u8be2\u6548\u7387&#xff1a;\u51cf\u5c11\u4eba\u5de5\u7ffb\u8bd1\u548c\u6821\u9a8c\u7684\u6210\u672c<\/li>\n<li>\u5f3a\u5316\u5b89\u5168\u7ba1\u63a7&#xff1a;\u57fa\u4e8e\u89d2\u8272\u7684\u7ec6\u7c92\u5ea6\u6743\u9650\u63a7\u5236<\/li>\n<p>\u91d1\u4ed3KFS MCP Server\u4f5c\u4e3a\u8bed\u4e49\u5c42\u7684\u7406\u60f3\u8f7d\u4f53&#xff0c;\u901a\u8fc7\u5176\u6807\u51c6\u5316\u7684\u5de5\u5177\u63a5\u53e3\u3001\u4e25\u683c\u7684\u5b89\u5168\u63a7\u5236\u548c\u9ad8\u6548\u7684\u6570\u636e\u5e93\u8fde\u63a5\u80fd\u529b&#xff0c;\u4e3aAI Agent\u7684\u8bed\u4e49\u5c42\u6784\u5efa\u63d0\u4f9b\u4e86\u575a\u5b9e\u7684\u6280\u672f\u5e95\u5ea7\u3002<\/p>\n<p>\u672a\u6765&#xff0c;\u968f\u7740\u5927\u6a21\u578b\u80fd\u529b\u7684\u4e0d\u65ad\u63d0\u5347&#xff0c;\u8bed\u4e49\u5c42\u5c06\u671d\u7740\u66f4\u667a\u80fd\u3001\u66f4\u81ea\u52a8\u5316\u7684\u65b9\u5411\u53d1\u5c55&#xff1a;\u81ea\u52a8\u53d1\u73b0\u4e1a\u52a1\u672f\u8bed\u3001\u81ea\u52a8\u5b66\u4e60\u6620\u5c04\u89c4\u5219\u3001\u81ea\u52a8\u4f18\u5316\u67e5\u8be2\u6027\u80fd\u3002\u800c\u91d1\u4ed3KFS MCP Server\u4e5f\u5c06\u6301\u7eed\u6f14\u8fdb&#xff0c;\u4e3aAI Agent\u7684\u8bed\u4e49\u5c42\u63d0\u4f9b\u66f4\u52a0\u5f3a\u5927\u7684\u652f\u6301\u3002<\/p>\n<hr \/>\n<p>\u8f6c\u8f7d\u81ea&#xff1a;https:\/\/blog.csdn.net\/sghtgjfhv\/article\/details\/163481081 \u6b22\u8fce &#x1f44d;\u70b9\u8d5e\u270d\u8bc4\u8bba\u2b50\u6536\u85cf&#xff0c;\u6b22\u8fce\u6307\u6b63<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u76ee\u5f55\u6bcf\u65e5\u4e00\u53e5\u6b63\u80fd\u91cf\u5f15\u8a00&#xff1a;\u5f53\u4e1a\u52a1\u8bed\u8a00\u9047\u4e0a\u6280\u672fSchema\u4e00\u3001\u6838\u5fc3\u95ee\u9898&#xff1a;\u4e3a\u4ec0\u4e48AI Agent\u603b\u662f\\&#8221;\u731c\u9519\\&#8221;\u6570\u636e&#xff1f;1.1 \u8bed\u4e49\u9e3f\u6c9f\u7684\u4e09\u91cd\u7ef4\u5ea61.2 \u7ecf\u8425\u5206\u6790\u573a\u666f\u7684\u5178\u578b\u75db\u70b9\u4e8c\u3001\u8bed\u4e49\u5c42\u67b6\u6784&#xff1a;\u4ece\\&#8221;\u731c\\&#8221;\u5230\\&#8221;\u61c2\\&#8221;2.1 \u8bed\u4e49\u5c42\u7684\u5b9a\u4f4d2.2 \u4e09\u5c42\u67b6\u6784\u8bbe\u8ba1\u4e09\u3001\u672f\u8bed\u8868\u8bbe\u8ba1&#xff1a;\u8bed\u4e49\u5c42\u7684\\&#8221;\u8bcd\u5178\\&#8221;3.1 \u672f\u8bed\u8868\u6838\u5fc3\u7ed3\u67843.2 \u7ecf\u8425\u5206\u6790\u672f\u8bed\u8868\u793a\u4f8b\u56db\u3001\u6620\u5c04\u89c4\u5219&#xff1a;\u4ece\u672f\u8bed\u5230SQL4.1 \u6620\u5c04\u89c4\u5219\u5f15\u64ce4.2 \u6620\u5c04\u89c4\u5219\u793a\u4f8b\u4e94\u3001\u91d1\u4ed3<\/p>\n","protected":false},"author":2,"featured_media":91210,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10187,100],"topic":[],"class_list":["post-91215","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-codingplan","tag-100"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/91215.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u76ee\u5f55\u6bcf\u65e5\u4e00\u53e5\u6b63\u80fd\u91cf\u5f15\u8a00&#xff1a;\u5f53\u4e1a\u52a1\u8bed\u8a00\u9047\u4e0a\u6280\u672fSchema\u4e00\u3001\u6838\u5fc3\u95ee\u9898&#xff1a;\u4e3a\u4ec0\u4e48AI Agent\u603b\u662f&quot;\u731c\u9519&quot;\u6570\u636e&#xff1f;1.1 \u8bed\u4e49\u9e3f\u6c9f\u7684\u4e09\u91cd\u7ef4\u5ea61.2 \u7ecf\u8425\u5206\u6790\u573a\u666f\u7684\u5178\u578b\u75db\u70b9\u4e8c\u3001\u8bed\u4e49\u5c42\u67b6\u6784&#xff1a;\u4ece&quot;\u731c&quot;\u5230&quot;\u61c2&quot;2.1 \u8bed\u4e49\u5c42\u7684\u5b9a\u4f4d2.2 \u4e09\u5c42\u67b6\u6784\u8bbe\u8ba1\u4e09\u3001\u672f\u8bed\u8868\u8bbe\u8ba1&#xff1a;\u8bed\u4e49\u5c42\u7684&quot;\u8bcd\u5178&quot;3.1 \u672f\u8bed\u8868\u6838\u5fc3\u7ed3\u67843.2 \u7ecf\u8425\u5206\u6790\u672f\u8bed\u8868\u793a\u4f8b\u56db\u3001\u6620\u5c04\u89c4\u5219&#xff1a;\u4ece\u672f\u8bed\u5230SQL4.1 \u6620\u5c04\u89c4\u5219\u5f15\u64ce4.2 \u6620\u5c04\u89c4\u5219\u793a\u4f8b\u4e94\u3001\u91d1\u4ed3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/91215.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-07T03:25:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032507-6a7550133db49.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/91215.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/91215.html\",\"name\":\"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-08-07T03:25:12+00:00\",\"dateModified\":\"2026-08-07T03:25:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/91215.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/91215.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/91215.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/91215.html","og_locale":"zh_CN","og_type":"article","og_title":"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u76ee\u5f55\u6bcf\u65e5\u4e00\u53e5\u6b63\u80fd\u91cf\u5f15\u8a00&#xff1a;\u5f53\u4e1a\u52a1\u8bed\u8a00\u9047\u4e0a\u6280\u672fSchema\u4e00\u3001\u6838\u5fc3\u95ee\u9898&#xff1a;\u4e3a\u4ec0\u4e48AI Agent\u603b\u662f\"\u731c\u9519\"\u6570\u636e&#xff1f;1.1 \u8bed\u4e49\u9e3f\u6c9f\u7684\u4e09\u91cd\u7ef4\u5ea61.2 \u7ecf\u8425\u5206\u6790\u573a\u666f\u7684\u5178\u578b\u75db\u70b9\u4e8c\u3001\u8bed\u4e49\u5c42\u67b6\u6784&#xff1a;\u4ece\"\u731c\"\u5230\"\u61c2\"2.1 \u8bed\u4e49\u5c42\u7684\u5b9a\u4f4d2.2 \u4e09\u5c42\u67b6\u6784\u8bbe\u8ba1\u4e09\u3001\u672f\u8bed\u8868\u8bbe\u8ba1&#xff1a;\u8bed\u4e49\u5c42\u7684\"\u8bcd\u5178\"3.1 \u672f\u8bed\u8868\u6838\u5fc3\u7ed3\u67843.2 \u7ecf\u8425\u5206\u6790\u672f\u8bed\u8868\u793a\u4f8b\u56db\u3001\u6620\u5c04\u89c4\u5219&#xff1a;\u4ece\u672f\u8bed\u5230SQL4.1 \u6620\u5c04\u89c4\u5219\u5f15\u64ce4.2 \u6620\u5c04\u89c4\u5219\u793a\u4f8b\u4e94\u3001\u91d1\u4ed3","og_url":"https:\/\/www.wsisp.com\/helps\/91215.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-08-07T03:25:12+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260807032507-6a7550133db49.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/91215.html","url":"https:\/\/www.wsisp.com\/helps\/91215.html","name":"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-08-07T03:25:12+00:00","dateModified":"2026-08-07T03:25:12+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/91215.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/91215.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/91215.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u3010\u91d1\u4ed3\u6570\u636e\u5e93\u5f81\u6587\u3011AI Agent\u4e2d\u7684\u4e1a\u52a1\u672f\u8bed\u5230\u5b57\u6bb5\u6620\u5c04\uff1a\u8bed\u4e49\u5c42\u7684\u5de5\u7a0b\u5b9e\u8df5"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/91215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=91215"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/91215\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/91210"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=91215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=91215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=91215"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=91215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}