{"id":21328,"date":"2024-07-22T15:00:07","date_gmt":"2024-07-22T07:00:07","guid":{"rendered":"https:\/\/aif.amtbbs.org\/?p=21328"},"modified":"2024-07-22T15:00:07","modified_gmt":"2024-07-22T07:00:07","slug":"dataops%e5%a4%a7%e6%a8%a1%e5%9e%8b%e4%bf%83%e8%bf%9b%e6%95%b0%e6%8d%ae%e5%b7%a5%e7%a8%8b%e5%88%9b%e6%96%b0","status":"publish","type":"post","link":"https:\/\/aif.amtbbs.org\/index.php\/2024\/07\/22\/21328\/","title":{"rendered":"DataOps+\u5927\u6a21\u578b\u4fc3\u8fdb\u6570\u636e\u5de5\u7a0b\u521b\u65b0"},"content":{"rendered":"<div><img data-dominant-color=\"bac2c9\" data-has-transparency=\"false\" style=\"--dominant-color: #bac2c9;\" loading=\"lazy\" decoding=\"async\" class=\"not-transparent alignnone size-full wp-image-21329\" src=\"https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b-1.jpg\" width=\"474\" height=\"234\" alt=\"Dataops+\u5927\u6a21\u578b\u4fc3\u8fdb\u6570\u636e\u5de5\u7a0b\u521b\u65b0\u56fe\u7247 \u7684\u56fe\u50cf\u7ed3\u679c.\u5927\u5c0f\uff1a176 x 173\u3002 \u8d44\u6599\u6765\u6e90\uff1azhuanlan.zhihu.com\" srcset=\"https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b-1.jpg 474w, https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b-1-300x148.jpg 300w, https:\/\/aiforumimage.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2024\/07\/1fdc0f893412ce55f0d2811821b84d3b-1-150x74.jpg 150w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/div>\n<div class=\"article-desc\">\u4f01\u4e1a\u505a\u6570\u5b57\u5316\u8f6c\u578b\u4f1a\u5236\u5b9a\u81ea\u5df1\u7684\u6570\u5b57\u6218\u7565\uff0c\u5728\u6570\u5b57\u6218\u7565\u4e0e\u4e1a\u52a1\u6218\u7565\u5bf9\u9f50\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4f01\u4e1a\u4e5f\u5b8c\u6210\u4e86\u6570\u636e\u4ece\u6536\u96c6\u3001\u7ba1\u7406\u5230\u5206\u6790\u7684\u6d41\u7a0b\uff0c\u8fd9\u4e2a\u6d41\u7a0b\u5c31\u662f\u4f01\u4e1a\u6570\u5b57\u5316\u8f6c\u578b\u7684\u4f53\u73b0\u3002<\/div>\n<div id=\"postspictures\" class=\"article-content\">\n<div id=\"container\" class=\"container am-engine\" data-v-1d7a5742=\"\" data-element=\"root\">\n<p>ChatGPT4 \u6a2a\u7a7a\u51fa\u4e16\uff0c\u5176\u5f3a\u5927\u7684\u8bed\u4e49\u6cdb\u5316\u80fd\u529b\u4ee5\u53ca\u9488\u5bf9 Zero-Shot\u3001Few-Shot \u7b49\u573a\u666f\u7684\u7279\u6027\u8ba9 AI \u7684\u4f7f\u7528\u95e8\u69db\u8fdb\u4e00\u6b65\u964d\u4f4e\uff0c\u4e5f\u4e3a\u5404\u884c\u5404\u4e1a\u5e26\u6765\u4e86\u66f4\u591a\u60f3\u8c61\u7a7a\u95f4\u3002\u672c\u6587\u5c06\u5206\u4eab\u6d77\u5357\u6570\u9020\u79d1\u6280\u5bf9 DataOps \u52a0\u5927\u6a21\u578b\u9a71\u52a8\u6570\u636e\u521b\u65b0\u7684\u601d\u8003\u4e0e\u5b9e\u8df5\u3002<\/p>\n<h3>\u4e00\u3001\u4f20\u7edf\u6570\u636e\u7ba1\u7406\u9762\u4e34\u7684\u6311\u6218<\/h3>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s2.51cto.com\/oss\/202407\/22\/660a5fc815f79c1a80f453c8421cb00eefc1fb.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4f01\u4e1a\u505a\u6570\u5b57\u5316\u8f6c\u578b\u4f1a\u5236\u5b9a\u81ea\u5df1\u7684\u6570\u5b57\u6218\u7565\uff0c\u5728\u6570\u5b57\u6218\u7565\u4e0e\u4e1a\u52a1\u6218\u7565\u5bf9\u9f50\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4f01\u4e1a\u4e5f\u5b8c\u6210\u4e86\u6570\u636e\u4ece\u6536\u96c6\u3001\u7ba1\u7406\u5230\u5206\u6790\u7684\u6d41\u7a0b\uff0c\u8fd9\u4e2a\u6d41\u7a0b\u5c31\u662f\u4f01\u4e1a\u6570\u5b57\u5316\u8f6c\u578b\u7684\u4f53\u73b0\u3002<\/p>\n<p>\u4f01\u4e1a\u6570\u5b57\u5316\u8f6c\u578b\u5448\u73b0\u51fa\u4e09\u5927\u6218\u7565\u8d8b\u52bf\uff1a<\/p>\n<ul data-id=\"ua73dd4b-iEOlGW5b\">\n<li data-id=\"ld70c578-jLfj4JMP\">\u9996\u5148\u662f\u6570\u636e\u5206\u6790\u6c11\u4e3b\u5316\u3002\u6570\u636e\u5206\u6790\u4e0d\u518d\u53ea\u662f\u5c11\u6570\u4eba\u7684\u5de5\u4f5c\uff0c\u5404\u4e2a\u5c97\u4f4d\u90fd\u4f1a\u53bb\u770b\u62a5\u8868\uff0c\u4e5f\u4f1a\u7528\u4e00\u4e9b\u7edf\u8ba1\u7b97\u6cd5\uff0c\u4ee5\u5b9e\u65f6\u652f\u6491\u4e1a\u52a1\u51b3\u7b56\u3002<\/li>\n<li data-id=\"ld70c578-BnibI4jG\">\u7b2c\u4e8c\u662f\u6570\u636e\u6280\u672f\u591a\u5143\u5316\u3002\u73b0\u5728\u4fe1\u606f\u7cfb\u7edf\u591a\u5143\u5316\uff0c\u6570\u636e\u5f00\u53d1\u540c\u5b66\u9762\u4e34\u7740\u5404\u79cd\u591a\u5143\u5f02\u6784\u7684\u6570\u636e\u3002\u5728\u590d\u6742\u7684\u6570\u636e\u73af\u5883\u4e0b\uff0c\u6211\u4eec\u9700\u8981\u591a\u5143\u5316\u7684\u4e00\u4e9b\u6280\u672f\u7ec4\u4ef6\u6765\u652f\u6491\uff0c\u6bd4\u5982 Flink\u3001Spark \u7b49\u8ba1\u7b97\u7ec4\u4ef6\u548c\u5b58\u50a8\u7ec4\u4ef6\u3002\u53c8\u6bd4\u5982\u5728\u5f88\u591a\u91d1\u878d\u53cd\u6b3a\u8bc8\u573a\u666f\u4e2d\uff0c\u4f1a\u7528\u5230\u77e5\u8bc6\u56fe\u8c31\u5efa\u6a21\u548c\u5206\u6790\u7684\u6570\u636e\u7ec4\u4ef6\u3002\u6574\u4f53\u4e0a\u53d8\u6210\u4e86\u4e00\u4e2a\u5f88\u5e9e\u5927\u7684\u3001\u590d\u6742\u7684\u7cfb\u7edf\u5316\u5de5\u7a0b\u3002<\/li>\n<li data-id=\"ld70c578-Fn7J0B48\">\u7b2c\u4e09\u662f\u4e1a\u52a1\u4ef7\u503c\u7cbe\u76ca\u5316\u3002\u5bf9\u4e8e\u4e1a\u52a1\u90e8\u95e8\u6765\u8bf4\uff0c\u4e5f\u5e0c\u671b\u6570\u636e\u80fd\u5b9e\u73b0\u5feb\u901f\u53d8\u73b0\u3002<\/li>\n<\/ul>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s5.51cto.com\/oss\/202407\/22\/d5d4ab134671c1e593b4359b79466379485c5b.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u5728\u4e0a\u8ff0\u8d8b\u52bf\u4e0b\uff0c\u6211\u4eec\u9762\u4e34\u7740\u4f9b\u9700\u4e0d\u5e73\u8861\u7684\u75db\u70b9\u3002\u73b0\u5728\u5e02\u573a\u53d8\u5316\u5f88\u5feb\uff0c\u4e1a\u52a1\u540c\u5b66\u9700\u8981\u5feb\u901f\u54cd\u5e94\u5e02\u573a\u53d8\u5316\uff0c\u6240\u4ee5\u7ecf\u5e38\u4f1a\u6709\u5927\u91cf\u7684\u3001\u4e34\u65f6\u7684\uff0c\u4e14\u6709\u9ad8\u65f6\u6548\u6027\u8981\u6c42\u7684\u6570\u636e\u9700\u6c42\u3002\u5f00\u53d1\u5728\u65e9\u671f\u4f1a\u9762\u4e34\u5f00\u53d1\u73af\u5883\u4e0e\u6d4b\u8bd5\u73af\u5883\u4e0d\u4e00\u81f4\uff0c\u90e8\u7f72\u548c\u96c6\u6210\u9700\u8981\u5927\u91cf\u4eba\u5de5\u4ecb\u5165\uff0c\u7cfb\u7edf\u4e4b\u95f4\u5b58\u5728\u6570\u636e\u5b64\u5c9b\u95ee\u9898\u3002\u5bfc\u81f4\u8c03\u7814\u6570\u636e\u53e3\u5f84\u8981\u8017\u8d39\u5927\u91cf\u65f6\u95f4\uff0c\u6570\u636e\u5f00\u53d1\u4ece\u4ea4\u4ed8\u5230\u4e0a\u7ebf\u5f80\u5f80\u8d85\u8fc7\u4e00\u5468\uff0c\u751a\u81f3\u66f4\u957f\u65f6\u95f4\u3002\u540c\u65f6\u4e5f\u5b58\u5728\u6570\u636e\u8bed\u4e49\u7f3a\u5931\u3001\u4e1a\u52a1\u7528\u6570\u56f0\u96be\u7b49\u5176\u5b83\u4e00\u4e9b\u95ee\u9898\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u6570\u636e\u5f00\u53d1\u5de5\u4f5c\u4e5f\u50cf\u8f6f\u4ef6\u5de5\u7a0b\u4e00\u6837\uff0c\u4e0d\u5e94\u8be5\u662f\u7011\u5e03\u5f0f\u7684\u6d41\u7a0b\uff0c\u5373\u6240\u6709\u4e8b\u60c5\u90fd\u8981\u5148\u8ba1\u5212\u597d\u3001\u8bbe\u8ba1\u597d\u624d\u53bb\u5f00\u53d1\uff0c\u800c\u662f\u8981\u5b9e\u73b0\u654f\u6377\u4ea4\u4ed8\uff0c\u80fd\u591f\u5b9e\u65f6\u5730\u54cd\u5e94\u9700\u6c42\u3002\u5f53\u524d\u7814\u53d1\u8fdb\u5ea6\u662f\u843d\u540e\u4e8e\u5e02\u573a\u9700\u6c42\u7684\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>\u4e8c\u3001DataOps\u00a0\u4e0e\u5927\u6a21\u578b\u7684\u7ed3\u5408\u9a71\u52a8\u6570\u636e\u5de5\u7a0b\u521b\u65b0<\/h3>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s2.51cto.com\/oss\/202407\/22\/17fc3a125c01c8baf784249f66159017ab2fb8.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u5728\u6570\u5b57\u5316\u8f6c\u578b\u7684\u8d8b\u52bf\u4e0b\uff0c\u4e5f\u662f\u5728\u4e0a\u8ff0\u75db\u70b9\u7684\u9a71\u52a8\u4e0b\uff0c\u4f01\u4e1a\u4e9f\u9700\u65b0\u7684\u6570\u636e\u7814\u53d1\u8303\u5f0f\uff0c\u9700\u8981\u6ee1\u8db3\u4ee5\u4e0b\u8981\u6c42\uff1a<\/p>\n<ul data-id=\"ua73dd4b-Z3SVOaNS\">\n<li data-id=\"ld70c578-UJnl5MPc\">\u5f62\u6210\u654f\u6377\u6570\u636e\u7814\u53d1\u6d41\u6c34\u7ebf\u3002<\/li>\n<li data-id=\"ld70c578-5eegDhcj\">\u6784\u5efa\u9ad8\u6548\u7684\u8de8\u57df\u534f\u540c\u673a\u5236\u3002<\/li>\n<li data-id=\"ld70c578-HR6eCibN\">\u6253\u9020\u81ea\u52a9\u7684\u7528\u6570\u4f53\u9a8c\u3002<\/li>\n<li data-id=\"ld70c578-O4iIlirY\">\u5efa\u7acb\u7cbe\u7ec6\u5316\u7684\u8fd0\u8425\u4f53\u7cfb\u3002<\/li>\n<\/ul>\n<p>\u8fd9\u6837\u624d\u80fd\u5b9e\u73b0\u5feb\u901f\u4ea4\u4ed8\u6570\u636e\u7684\u76ee\u7684\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s4.51cto.com\/oss\/202407\/22\/b33b1209866770a39c80037e9410c308c91a9c.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u5728\u8fd9\u6837\u7684\u80cc\u666f\u4e0b\uff0c\u6211\u4eec\u63d0\u51fa\u4e86 DataOps \u7684\u7406\u5ff5\u3002DataOps \u662f\u5728 DevOps \u7684\u57fa\u7840\u4e0a\u53d1\u5c55\u800c\u6765\u7684\uff0c\u5176\u672c\u8d28\u662f\u6570\u636e\u5de5\u4f5c\u6d41\u7684\u7f16\u6392\u3001\u6570\u636e\u7684\u5f00\u53d1\u3001\u6d4b\u8bd5\u3001\u90e8\u7f72\u4e0a\u7ebf\u3001\u56de\u5f52\u8fd9\u5957\u673a\u5236\u9700\u8981\u8fbe\u5230\u6301\u7eed\u96c6\u6210\u7684\u6548\u679c\uff0c\u6709\u6807\u51c6\u5316\u7684\u4f53\u7cfb\uff0c\u5b9e\u73b0\u81ea\u52a8\u5316\u90e8\u7f72\uff0c\u540c\u65f6\u4f18\u5316\u6574\u4e2a\u6570\u636e\u53d1\u5e03\u7684\u6d41\u7a0b\uff0c\u4f18\u5316\u8d44\u6e90\u8fbe\u5230\u654f\u6377\u5f00\u53d1\u4ea4\u4ed8\u7684\u6548\u679c\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s3.51cto.com\/oss\/202407\/22\/23e057b755006c95942868e317c8d6aac69060.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4ece 2018 \u5e74\u5f00\u59cb\uff0cDataOps \u7684\u7406\u5ff5\u5ea6\u88ab Gartner \u5217\u5165\u4e86\u6280\u672f\u6210\u719f\u5ea6\u66f2\u7ebf\uff0c\u5e76\u6709\u7740\u9010\u5e74\u4e0a\u5347\u7684\u8d8b\u52bf\u3002\u6570\u9020\u79d1\u6280\u5728 2022 \u5e74\u4e0e\u4fe1\u901a\u9662\u8054\u5408\u6210\u7acb\u4e86\u4e00\u4e2a\u4e13\u5bb6\u5de5\u4f5c\u5c0f\u7ec4\uff0c\u5236\u5b9a\u4e86 DataOps \u7684\u80fd\u529b\u6807\u51c6\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s9.51cto.com\/oss\/202407\/22\/22242c7986716d1588d73321458923fff435e5.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4ecb\u7ecd\u4e86 DataOps \u7684\u80cc\u666f\u540e\uff0c\u8ba9\u6211\u4eec\u518d\u56de\u5230 AI\u3002\u4ece AlphaGo \u4e3a\u4ee3\u8868\u7684\u6df1\u5ea6\u5b66\u4e60\u6280\u672f\u7684\u53d1\u5c55\uff0c\u5230\u53bb\u5e74 ChatGPT \u5927\u8bed\u8a00\u6a21\u578b\u6280\u672f\u7684\u51fa\u73b0\uff0cAI \u4f7f\u7528\u95e8\u69db\u8d8a\u6765\u8d8a\u4f4e\uff0c\u6211\u4eec\u7684\u4fe1\u606f\u5316\u7cfb\u7edf\u8d8a\u6765\u8d8a\u667a\u80fd\u5316\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s7.51cto.com\/oss\/202407\/22\/236120a81f7d8d6a5d9320de8c4a0f98615b8f.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4ec5\u4ec5\u4e00\u5e74\u65f6\u95f4\u91cc\uff0c\u51fa\u73b0\u4e86\u5f88\u591a\u57fa\u4e8e\u5927\u8bed\u8a00\u6a21\u578b\u7684 AI \u5de5\u5177\u3002\u6211\u4eec\u56e2\u961f\u4f7f\u7528\u4e86\u4e00\u6b3e\u540d\u4e3a Bito \u7684\u4ee3\u7801\u81ea\u52a8\u751f\u6210\u548c\u68c0\u67e5\u7684\u5f00\u6e90\u63d2\u4ef6\uff0c\u4f7f\u5f97\u5de5\u4f5c\u6548\u7387\u63d0\u5347\u4e86 20% \u4ee5\u4e0a\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s8.51cto.com\/oss\/202407\/22\/f63b51f46b6fffee303973be15af24af85a0ff.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4e0a\u56fe\u5c55\u793a\u4e86\u6211\u4eec DataOps \u7684\u6807\u51c6\u5316\u6d41\u7a0b\uff0c\u5728\u6570\u636e\u7684\u5f00\u53d1\u3001\u53d1\u5e03\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4f7f\u7528\u5927\u6a21\u578b\u652f\u6301\u4ee3\u7801\u751f\u6210\u3001\u4ee3\u7801\u89e3\u91ca\u4ee5\u53ca\u4ee3\u7801\u5ba1\u67e5\u7684\u5de5\u4f5c\uff0c\u8ba9\u6574\u4e2a\u6d41\u7a0b\u66f4\u52a0\u667a\u80fd\u5316\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s2.51cto.com\/oss\/202407\/22\/f2b4a99731e1192521b602685ab64a78542b2f.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4e0a\u56fe\u4e2d\u5bf9\u6bd4\u4e86\u4f20\u7edf\u6570\u636e\u5f00\u53d1\u6a21\u5f0f\u548c\u201cDataOps+\u5927\u6a21\u578b\u201d\u6a21\u5f0f\u3002\u4f20\u7edf\u6570\u636e\u5f00\u53d1\u6a21\u5f0f\uff0c\u4ece\u6570\u636e\u5efa\u6a21\u3001\u6570\u636e\u5f00\u53d1\u5230\u6d4b\u8bd5\u3001\u90e8\u7f72\u3001\u56de\u5f52\uff0c\u6b65\u9aa4\u7e41\u6742\uff0c\u9700\u8981\u5927\u91cf\u7684\u4eba\u529b\u4ecb\u5165\u3002\u5728\u6700\u65e9\u7684\u65f6\u5019\uff0c\u6211\u4eec\u6709\u5f00\u53d1\u73af\u5883\u3001\u6d4b\u8bd5\u73af\u5883\u548c\u51c6\u751f\u4ea7\u73af\u5883\uff0c\u4e0d\u540c\u7684\u73af\u5883\u4e2d\u4f1a\u6709\u4e0d\u540c\u7684\u5f00\u53d1\u4eba\u5458\u7ef4\u7cfb\u5176\u53c2\u6570\u914d\u7f6e\u6587\u4ef6\u3002\u5f53\u90e8\u7f72\u7684\u65f6\u5019\uff0c\u5c31\u8981\u624b\u52a8\u6539\u914d\u7f6e\u6587\u4ef6\uff0c\u5f80\u5f80\u4f1a\u5f15\u5165\u6f5c\u5728\u7684\u98ce\u9669\u3002<\/p>\n<p>\u6709\u4e86 DataOps \u8fd9\u4e00\u5957\u654f\u6377\u6570\u636e\u5f00\u53d1\u53d1\u5e03\u7684\u6807\u51c6\u540e\uff0c\u5c31\u80fd\u8fbe\u5230\u81ea\u52a8\u5316\u7684\u6548\u679c\u3002\u8fd9\u4e9b\u914d\u7f6e\u6587\u4ef6\u4f1a\u88ab\u7edf\u4e00\u3001\u81ea\u52a8\u5316\u5730\u7ba1\u7406\u8d77\u6765\uff0c\u8fbe\u5230\u4e00\u5957\u6570\u636e\u5f00\u53d1\uff0c\u4e00\u5957\u6570\u636e\u5efa\u6a21\u7684\u811a\u672c\uff0c\u80fd\u5728\u591a\u5957\u73af\u5883\u91cc\u9762\u53bb\u4f7f\u7528\uff0c\u914d\u7f6e\u53c2\u6570\u4f1a\u81ea\u52a8\u66ff\u6362\u3002\u540c\u65f6\u8fd8\u5177\u5907\u6570\u636e\u6c99\u7bb1\u7684\u529f\u80fd\uff0c\u6d4b\u8bd5\u6570\u636e\u53ef\u80fd\u65e0\u6cd5\u4f53\u73b0\u751f\u4ea7\u73af\u5883\u7684\u60c5\u51b5\uff0c\u6240\u4ee5\u53ef\u4ee5\u4f7f\u7528\u51c6\u751f\u4ea7\u73af\u5883\u7684\u6570\u636e\u53bb\u9a8c\u8bc1\u811a\u672c\u3002\u5728\u8fd9\u79cd\u81ea\u52a8\u5316\u7684\u4f53\u7cfb\u4e0b\uff0c\u52a0\u5165\u4e86\u4e00\u4e9b\u5927\u6a21\u578b\u7684\u80fd\u529b\uff0c\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u751f\u6210\u4e00\u4e9b\u6570\u636e\u6307\u4ee4\uff0c\u6bd4\u5982\u81ea\u52a8\u751f\u6210 SQL \u6216\u8005\u52a0\u5165\u6ce8\u91ca\uff0c\u4ee5\u53ca\u81ea\u52a8\u5ba1\u67e5\u7b49\u7b49\u3002\u6240\u4ee5\u201cDataOps+\u5927\u6a21\u578b\u201d\u5c31\u662f\u5728 DataOps \u8fd9\u5957\u6807\u51c6\u5316\u6d41\u7a0b\u7684\u4f53\u7cfb\u4e0a\uff0c\u52a0\u5165\u81ea\u52a8\u5316\u548c\u667a\u80fd\u5316\uff0c\u8ba9\u6570\u636e\u7684\u5f00\u53d1\u548c\u4ea4\u4ed8\u66f4\u52a0\u9ad8\u6548\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>\u4e09\u3001DataOps+\u5927\u6a21\u578b\u4ea7\u54c1\u5b9e\u8df5\u63a2\u7d22<\/h3>\n<p>\u5927\u6a21\u578b\u6709\u5f88\u591a\u6709\u8da3\u7684\u5e94\u7528\u573a\u666f\uff0c\u4f8b\u5982\u6587\u6848\u751f\u6210\u3001\u6570\u5b57\u4eba\u3001\u77e5\u8bc6\u68c0\u7d22\u589e\u5f3a\u7b49\u7b49\u3002\u8fd8\u6709\u4e00\u4e2a\u6bd4\u8f83\u70ed\u95e8\u7684\u573a\u666f\u5c31\u662f Text2SQL\uff0c\u8ba9\u5927\u6a21\u578b\u53bb\u751f\u6210\u6307\u4ee4\uff0c\u63a5\u4e0b\u6765\u5c06\u4ecb\u7ecd\u6211\u4eec\u5728\u8fd9\u4e00\u65b9\u5411\u4e0a\u7684\u63a2\u7d22\u4e0e\u5b9e\u8df5\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s9.51cto.com\/oss\/202407\/22\/62a923705c5729043d349020396e3050ce4f69.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>Text2SQL \u5c31\u662f\u57fa\u4e8e\u4ee5\u81ea\u7136\u8bed\u8a00\u63cf\u8ff0\u7684\u95ee\u9898\uff0c\u7ed3\u5408\u8868\u7684\u5143\u6570\u636e\u4fe1\u606f\uff08\u5305\u62ec\u8868\u540d\u3001\u5217\u540d\u4ee5\u53ca\u8868\u4e4b\u95f4\u7684\u5173\u8054\u5173\u7cfb\uff09\uff0c\u751f\u6210\u4e00\u4e2a\u51c6\u786e\u7684 SQL \u8bed\u53e5\u30022022 \u5e74\uff0c\u5728\u5927\u6a21\u578b\u51fa\u73b0\u4e4b\u524d\uff0cText2SQL \u57fa\u4e8e\u9884\u8bad\u7ec3\u6a21\u578b\u7684\u51c6\u786e\u7387\u80fd\u591f\u505a\u5230 75-77% \u5de6\u53f3\u3002\u8fd9\u4e00\u6570\u636e\u6765\u81ea Spider \u7684\u8bc4\u6d4b\u699c\u5355\uff0c\u8fd9\u662f\u4e00\u4e2a\u8de8\u57df\u7684\uff0c\u5728 Text2SQL \u9886\u57df\u6bd4\u8f83\u6743\u5a01\u7684\u699c\u5355\u3002\u5927\u6a21\u578b\u51fa\u73b0\u540e\uff0c\u6bcf\u4e24\u4e2a\u6708\u699c\u5355\u4f1a\u66f4\u65b0\u4e00\u6b21\uff0cGPT4 \u505a\u7684 Text2SQL \u4efb\u52a1\uff0c\u51c6\u786e\u7387\u4e5f\u4ece\u539f\u6765\u7684 78% \u4e00\u8def\u98d9\u5347\u5230 91%\u3002<\/p>\n<p>\u800c Text2SQL \u4efb\u52a1\uff0c\u4ea7\u751f\u6b63\u786e\u7684 SQL \u53ea\u5b9e\u73b0\u4e86\u5176\u4e00\u534a\u7684\u4ef7\u503c\uff0c\u5bf9\u4e8e\u6570\u636e\u5f00\u53d1\u4eba\u5458\u6765\u8bf4\uff0c\u53e6\u4e00\u534a\u7684\u4ef7\u503c\u662f\u5feb\u901f\u627e\u5230\u60f3\u8981\u7684\u6570\u636e\u3002\u73b0\u5b9e\u7684\u751f\u4ea7\u73af\u5883\u4e2d\u6709\u5927\u91cf\u7684\u6570\u636e\u5e93\u3001\u8868\uff0c\u8981\u57fa\u4e8e\u81ea\u7136\u8bed\u8a00\u7684\u63d0\u95ee\uff0c\u627e\u5230\u51c6\u786e\u7684\u8868\u548c\u5217\uff0c\u4e5f\u5c31\u662f\u51c6\u786e\u6570\u636e\u53e3\u5f84\u3002\u6240\u4ee5\u6211\u4eec\u8ba4\u4e3a Text2SQL \u7684\u5b9a\u4e49\u8fd8\u8981\u5305\u62ec\u5728\u4e0d\u540c schema \u4e0b\u9762\u80fd\u4ea7\u751f\u6b63\u786e SQL \u7684\u4efb\u52a1\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u5728\u5927\u6a21\u578b\u51fa\u73b0\u4e4b\u524d\u7684\u505a\u6cd5\uff0c\u662f\u7528 Seq2Seq \u7684\u6a21\u578b\u3002\u5bf9\u4e8e\u63d0\u95ee\uff0c\u8868\u7684\u5143\u6570\u636e\u4fe1\u606f\u505a\u5d4c\u5165\uff0c\u57fa\u4e8e\u5d4c\u5165\u7684\u5411\u91cf\u4fe1\u606f\uff0c\u751f\u6210 SQL \u8bed\u53e5\uff0c\u8fd9\u91cc\u4f1a\u6709 mismatch problem in literature \u7684\u95ee\u9898\u3002\u6211\u4eec\u505a\u6587\u672c\u65f6\uff0c\u4e2d\u6587\u8f6c\u82f1\u6587\u6216\u8005\u4e2d\u6587\u8f6c\u5fb7\u6587\uff0c\u8bcd\u8bed\u8868\u8ff0\u4e0d\u4e00\u6837\uff0c\u8bed\u6cd5\u7ed3\u6784\u4e0d\u4e00\u6837\uff0c\u4f46\u53ef\u80fd\u8bed\u4e49\u662f\u4e00\u6837\u7684\u3002\u800c\u5bf9\u4e8e Text2SQL \u7684\u4efb\u52a1\u6765\u8bf4\uff0c\u8bed\u4e49\u662f\u4e0d\u4e00\u6837\u7684\uff0c\u95ee\u9898\u7528 SQL \u662f\u6ca1\u529e\u6cd5\u51c6\u786e\u8868\u8ff0\u7684\uff0c\u6bd4\u5982 SQL \u4e2d\u7684 group by\u3001intersect\u3001union \u662f\u4e0d\u4f1a\u5728\u81ea\u7136\u8bed\u8a00\u91cc\u9762\u51fa\u73b0\u7684\uff0c\u4f60\u4e0d\u4f1a\u8bf4\uff1a\u201c\u5e2e\u6211\u67e5\u8fd9\u4e2a\u5b63\u5ea6\u7684\u603b\u9500\u552e\u989d\uff0c\u7528 group by \u8fd9\u4e2a\u8bed\u53e5\u201d\uff0c\u6240\u4ee5\u5c31\u4f1a\u5b58\u5728\u8bed\u4e49\u4e0d\u5bf9\u7b49\u7684\u95ee\u9898\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s4.51cto.com\/oss\/202407\/22\/d78012d674630f415bc654463b38a3cf7097ba.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u57fa\u4e8e\u8fd9\u4e2a\u95ee\u9898\uff0c\u5728\u6a21\u578b\u67b6\u6784\u4e0a\uff0c\u6bd4\u5982 Encoder Decoder \u4e0a\u505a\u4e86\u5f88\u591a\u4f18\u5316\u7b56\u7565\u3002\u5728\u5927\u6a21\u578b\u51fa\u6765\u4e4b\u524d\uff0c\u6211\u4eec\u5e38\u7528\u7684\u5c31\u662f\u8c37\u6b4c T5-3B\u3001Electra \u6216\u8005 RoBERTa \u8fd9\u4e9b\u9884\u8bad\u7ec3\u6a21\u578b\u4f5c\u4e3a\u6a21\u578b\u5e95\u5ea7\uff0c\u4e0d\u65ad\u4f18\u5316\u5176 Encoder\uff0c\u4e00\u5f00\u59cb\u53ea\u662f\u7b80\u5355\u7684 input representation\uff0c\u4e00\u4e2a\u7b80\u5355\u7684\u5d4c\u5165\u7684\u4efb\u52a1\uff0c\u4f46\u662f\u4f1a\u53d1\u73b0\u6709 schema-linking \u4e0d\u51c6\u786e\u7684\u95ee\u9898\u3002\u4e3a\u4e86\u66f4\u597d\u5730\u5c06\u95ee\u9898\u4e0e\u9700\u8981\u7528\u5230\u7684\u8868\u6216\u8005\u5217\u5173\u8054\u8d77\u6765\uff0c\u540e\u9762\u6709\u4e86\u66f4\u590d\u6742\u7684 Structure Modeling \u7684\u5efa\u6a21\uff0c\u4f1a\u5bf9\u95ee\u9898\u5efa\u6a21\uff0c\u5bf9\u5143\u6570\u636e\u91c7\u7528\u66f4\u590d\u6742\u5efa\u6a21\u7684\u7b56\u7565\uff0c\u4ee5\u627e\u5230\u95ee\u9898\u76f8\u5173\u7684\u8868\u548c\u5217\u3002<\/p>\n<p>\u8fd1\u51e0\u5e74\u6bd4\u8f83\u6d41\u884c\u7684\u4e00\u79cd\u65b9\u6cd5\u662f\u57fa\u4e8e\u77e5\u8bc6\u56fe\u8c31\u7684\u5efa\u6a21\u65b9\u5f0f\uff0c\u4e00\u5f00\u59cb\u5927\u5bb6\u4f1a\u7528 GNN \u56fe\u795e\u7ecf\u7f51\u7edc\u7684\u65b9\u6cd5\u53bb\u505a\u5efa\u6a21\uff0c\u4f46\u5b58\u5728\u4e00\u4e2a\u95ee\u9898\uff0c\u6a21\u578b\u66f4\u591a\u7684\u662f\u5bf9\u8282\u70b9\u7684\u5efa\u6a21\uff0c\u6ca1\u529e\u6cd5\u6cdb\u5316\u5230\u4e24\u5ea6\u4ee5\u4e0a\u6df1\u5ea6\u7684\u4fe1\u606f\u3002\u6240\u4ee5\u540e\u9762\u53c8\u63d0\u51fa\u4e86 RAT-SQL\u3001RASAT \u6a21\u578b\uff0c\u672c\u8d28\u662f\u5728\u77e5\u8bc6\u56fe\u8c31\u4e0a\u53bb\u5b9a\u4e49 meta-path\uff0c\u628a\u5143\u6570\u636e\u7684\u5173\u8054\u5173\u7cfb\u5b9a\u4e49\u51fa\u6765\uff0c\u5728 Encoder \u4f1a\u53bb\u505a\u591a\u5934\u6ce8\u610f\u529b\uff0c\u628a\u5173\u7cfb\u7684\u5411\u91cf\u4fe1\u606f\u5d4c\u5165\u5230\u91cc\u9762\uff0c\u52a0\u5f3a\u95ee\u9898\u8ddf\u672c\u5730\u5143\u6570\u636e\u7684\u5173\u8054\u6027\u3002<\/p>\n<p>Encoder \u7684\u4f18\u5316\u7b56\u7565\u89e3\u51b3\u5b8c\uff0c\u5c31\u5230 Decoder\uff0c\u600e\u4e48\u628a encoder \u7684\u7f16\u7801\u751f\u6210 SQL \u8bed\u53e5\uff0c\u5f00\u59cb\u5927\u5bb6\u4f1a\u7528 Sketch-based \u7684\u65b9\u6cd5\uff0c\u628a\u751f\u6210 SQL \u8bed\u53e5\u62c6\u89e3\u6210\u4e00\u4e2a\u4e2a\u7684\u5b50\u90e8\u5206\uff0c\u751f\u6210 select\uff0c\u751f\u6210 where\uff0c\u751f\u6210 from\uff0c\u57fa\u4e8e\u5c0f\u7684\u8bed\u53e5\u53bb\u505a\u8bcd\u69fd\uff0c\u628a\u4e4b\u524d encoder \u8bc6\u522b\u5230\u7684\u8868\u540d\u3001\u5217\u540d\u586b\u5230\u8fd9\u4e2a\u8bcd\u69fd\u91cc\uff0c\u4f46\u5b9e\u9645\u4e0a\u6548\u679c\u5e76\u4e0d\u597d\uff0c\u4f1a\u4ea7\u751f\u5f88\u591a\u9519\u8bef\u7684\u3001\u4e0d\u7b26\u5408\u8bed\u6cd5\u7684 SQL \u8bed\u53e5\uff0c\u6240\u4ee5\u6211\u4eec\u7528 Generation-based method \u7684\u65b9\u6cd5\uff0c\u6700\u7ecf\u5178\u7684\u5c31\u662f AST \u8bed\u6cd5\u6811\u7684\u7ed3\u6784\uff0c\u8ba9\u5b83\u9075\u5faa\u4e00\u5b9a\u7684\u8bed\u6cd5\u6811\u6765\u751f\u6210 SQL\uff0c\u8fd8\u6709 PICARD\uff0c\u5728 search \u7684\u65f6\u5019\u4e0d\u65ad\u5730\u53bb\u4e00\u4e2a\u8bb0\u5fc6\u7a7a\u95f4\u68c0\u67e5\u751f\u6210\u7684 SQL \u8ddf\u524d\u9762\u7684 Encoder \u7684 schema-linking \u5185\u5bb9\u662f\u4e0d\u662f\u5bf9\u7b49\u7684\u3001\u662f\u4e0d\u662f\u5408\u8bed\u6cd5\u7684\uff0c\u5305\u62ec RESDSQL\uff0c\u8fd9\u6837\u7684\u4f18\u5316\u7b56\u7565\uff0c\u8ba9\u5b83\u751f\u6210\u66f4\u52a0\u51c6\u786e\u7684 SQL\u3002<\/p>\n<p>\u4f46\u662f\u4ecd\u7136\u4e0d\u591f\u51c6\u786e\uff0c\u7ecf\u8fc7\u5206\u6790\uff0c\u8fd8\u662f\u5b58\u5728\u8bed\u4e49\u4e0d\u5339\u914d\u7684\u95ee\u9898\uff0c\u4e8e\u662f\u6211\u4eec\u53c8\u52a0\u5165\u4e86 Intermediate representation \u7684\u67b6\u6784\uff0c\u53d1\u660e\u4e86\u57fa\u4e8e\u81ea\u7136\u8bed\u8a00\u8ddf SQL \u4e4b\u95f4\u7684\u4e2d\u95f4\u8bed\u8a00\uff0cNatureSQL\u3001SemQL\uff0c\u5148\u751f\u6210\u4e2d\u95f4\u8bed\u8a00\uff0c\u518d\u57fa\u4e8e\u4e2d\u95f4\u8bed\u8a00\u751f\u6210 SQL\uff0c\u51c6\u786e\u7387\u53c8\u8fdb\u4e00\u6b65\u5f97\u5230\u4e86\u63d0\u5347\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s4.51cto.com\/oss\/202407\/22\/92a404d92210620d5f9467c45ef5c53cd02466.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u5927\u6a21\u578b\u51fa\u73b0\u540e\uff0c\u5176\u751f\u6210 SQL \u7684\u51c6\u786e\u5ea6\uff0c\u5c24\u5176\u662f GPT4 \u57fa\u4e8e\u7b56\u7565\u7684\u751f\u6210\uff0c\u51c6\u786e\u5ea6\u8d8a\u6765\u8d8a\u9ad8\u3002\u5927\u6a21\u578b\u76ee\u524d\u4e3b\u8981\u4f7f\u7528\u6709\u4e24\u79cd\u65b9\u6cd5\uff0c\u4e00\u79cd\u662f\u63d0\u793a\u5de5\u7a0b\uff0c\u4e00\u4e2a\u662f\u57fa\u4e8e\u6307\u4ee4\u7684\u76d1\u7763\u5fae\u8c03\uff0c\u8ba9\u5927\u6a21\u578b\u4ea7\u751f\u5bf9\u5e94\u7684 SQL\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s4.51cto.com\/oss\/202407\/22\/e49c59d7438f4745d200860fc29ad8f6eab43d.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4eca\u5e74\u8fd9\u7bc7\u8bba\u6587\u6765\u81ea SQL\uff0c\u4e5f\u662f\u5927\u6a21\u578b\u751f\u6210 SQL \u4efb\u52a1\u7684\u5e38\u7528\u65b9\u6cd5\uff0c\u5373\u57fa\u4e8e\u601d\u7ef4\u94fe\u7684\u65b9\u6cd5\u3002\u5728\u4f20\u7edf Seq2Seq \u7684\u65b9\u6cd5\u4e2d\uff0c\u8f93\u5165\u81ea\u7136\u8bed\u8a00\u548c schema \u4fe1\u606f\uff0c\u8ba9\u5b83\u53bb\u751f\u6210 SQL\uff0c\u7ed3\u679c\u53d1\u73b0\u8fd9\u79cd\u7aef\u5230\u7aef\u7684\u65b9\u6cd5\u6548\u679c\u5f88\u5dee\uff0c\u6240\u4ee5\u624d\u6709\u4e86 Encoder Decoder \u7684\u4f18\u5316\u7b56\u7565\u3002\u5927\u6a21\u578b\u5176\u5b9e\u4e5f\u4e00\u6837\uff0c\u4e00\u5f00\u59cb\u901a\u8fc7 prompt \u628a\u81ea\u7136\u8bed\u8a00\u3001schema \u5582\u7ed9\u5b83\uff0c\u8ba9\u5b83\u751f\u6210 SQL\uff0c\u53d1\u73b0\u51c6\u786e\u7387\u6709\u95ee\u9898\uff0c\u6240\u4ee5\u540e\u9762\u628a\u5927\u6a21\u578b\u7684\u4efb\u52a1\u62c6\u89e3\u6210\u4e00\u4e2a\u4e2a\u5b50\u4efb\u52a1\uff0c\u6bd4\u5982\u5148\u7528\u4e00\u4e2a schema-linking \u7684 prompt \u7684\u6a21\u677f\uff0c\u627e\u5173\u8054\u7684\u8868\u3001\u5217\uff0c\u518d\u57fa\u4e8e\u8868\u3001\u5217\uff0c\u6839\u636e\u95ee\u9898\u7684\u590d\u6742\u6027\u6765\u8fdb\u884c\u5206\u7c7b\uff0c\u662f\u7b80\u5355\u7684\u4e00\u4e2a\u5355\u8868\u67e5\u8be2\u7684 SQL\uff0c\u8fd8\u662f\u6709\u4e00\u4e9b join \u8bed\u53e5\u7684 SQL\uff0c\u8fd8\u662f\u5728 join \u7684\u57fa\u7840\u4e0a\u6709\u4e00\u4e9b\u590d\u6742\u5b50\u67e5\u8be2\u7684 SQL\u3002\u4e3a\u4ec0\u4e48\u8fd9\u6837\u5206\u7c7b\u5462\uff1f\u56e0\u4e3a\u5bf9\u4e8e\u5f88\u7b80\u5355\u7684\u5355\u8868\u67e5\u8be2\u7684 SQL\uff0c\u5982\u679c\u7528\u590d\u6742\u7684 prompt \u6a21\u677f\u53bb\u751f\u6210\uff0c\u6548\u679c\u53cd\u800c\u4f1a\u4e0b\u964d\uff0c\u6240\u4ee5\u52a0\u4e86\u4e00\u4e2a\u5206\u7c7b\u7684 prompt\u3002\u5728\u8fd9\u7bc7\u8bba\u6587\u91cc\uff0c\u8fd8\u52a0\u4e86 self-correction \u7684 prompt \u7684\u6a21\u677f\uff0c\u544a\u8bc9\u5927\u6a21\u578b\u518d\u5e2e\u6211\u4f18\u5316\u4e00\u4e0b SQL\u3002\u57fa\u4e8e\u8fd9\u4e00\u7cfb\u5217\u5b50\u4efb\u52a1\uff0c\u8fd8\u6709\u601d\u7ef4\u94fe\u7684\u5de5\u7a0b\uff0c\u6700\u7ec8\u624d\u80fd\u8ba9 GPT4 \u751f\u6210\u6bd4\u8f83\u51c6\u786e\u7684 SQL \u8bed\u53e5\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s3.51cto.com\/oss\/202407\/22\/c577332079d43a4db37161c747c5703e7145bc.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u5b9e\u8df5\u8fc7\u7a0b\u4e2d\u53d1\u73b0\uff0c\u65e0\u8bba\u662f\u4f20\u7edf\u7684\u9884\u8bad\u7ec3\u6a21\u578b\u8fd8\u662f\u5927\u6a21\u578b\uff0c\u90fd\u9762\u4e34\u7740\u5f88\u591a\u6311\u6218\u3002\u4f20\u7edf\u9884\u8bad\u7ec3\u6a21\u578b\u7684\u8bed\u4e49\u6cdb\u5316\u80fd\u529b\u80af\u5b9a\u6bd4\u5927\u6a21\u578b\u5f31\uff0c\u5b83\u7684\u751f\u6210\u80fd\u529b\u4e5f\u4e0d\u4e00\u5b9a\u6bd4\u5927\u6a21\u578b\u5f3a\uff0c\u5bb9\u6613\u51fa\u73b0 missmatch \u7684\u95ee\u9898\uff0c\u590d\u6742\u67e5\u8be2\u8bed\u53e5\u7684\u751f\u6210\u80fd\u529b\u4e5f\u6bd4\u8f83\u5f31\uff0c\u52a0\u4e0a Encoder\u3001Decoder \u91c7\u7528\u4e86\u5927\u91cf\u590d\u6742\u7684\u4f18\u5316\u7b56\u7565\uff0c\u5c24\u5176\u662f\u57fa\u4e8e graph based \u65b9\u6cd5\uff0c\u8fd8\u8981\u4eba\u5de5\u5148\u751f\u6210 meta-path\uff0c\u7ef4\u62a4\u8fd9\u4e9b meta-path \u4e5f\u9700\u8981\u5927\u91cf\u7684\u5de5\u4f5c\uff0c\u76f8\u6bd4\u4e8e\u5927\u6a21\u578b\u7684 zero-shot\u3001few-shot \u80fd\u529b\uff0c\u8fd8\u8981\u51c6\u5907\u4e00\u4e9b\u6807\u6ce8\u8bed\u6599\uff0c\u5de5\u4f5c\u91cf\u4e5f\u662f\u5f88\u5927\u7684\u3002\u6bd4\u5982 T53B \u6a21\u578b\u7528\u7684\u663e\u5361\u8d44\u6e90\u5e76\u4e0d\u6bd4\u5927\u6a21\u578b\u5c11\u3002<\/p>\n<p>\u5927\u6a21\u578b\u4e5f\u540c\u6837\u9762\u4e34\u4e00\u4e9b\u6311\u6218\uff0c\u6700\u8fd1\u53d1\u8868\u7684\u6240\u6709\u7684 Text2SQL \u8bba\u6587\u5168\u90e8\u96c6\u4e2d\u5728 GPT4 \u7684\u7814\u7a76\uff0c\u5bf9\u4e8e\u672c\u5730\u5316\u3001\u79c1\u6709\u5316\u7684\u5927\u6a21\u578b\u7814\u7a76\u504f\u5c11\u3002Prompt \u7684\u826f\u597d\u5b9e\u8df5\uff0c\u6bd4\u8f83\u4f9d\u8d56\u4e8e\u601d\u7ef4\u94fe\uff0c\u8fd8\u6709 in-context learning\uff0c\u4e5f\u5c31\u662f\u8981\u7ed9\u5927\u6a21\u578b\u4e00\u4e9b\u6837\u4f8b\u6570\u636e\u53bb\u5f15\u5bfc\u5b83\u751f\u6210\u66f4\u52a0\u51c6\u786e\u7684 SQL\uff0c\u4f46\u5bf9\u4e8e\u590d\u6742\u7684 schema\uff0c\u5c31\u4f1a\u8d85\u51fa\u5927\u6a21\u578b\u7684 token\u3002\u6240\u4ee5\u6709\u4e00\u79cd\u505a\u6cd5\u662f\u5148\u628a\u8868\u9884\u5904\u7406\u6210\u5bbd\u8868\uff0c\u751f\u6210\u7684 SQL \u5c31\u6ca1\u90a3\u4e48\u590d\u6742\u4e86\uff0c\u5c31\u53d8\u6210\u4e86\u57fa\u4e8e\u5bbd\u8868\u53bb\u751f\u6210\u67e5\u8be2\u8bed\u53e5\uff0c\u4e0d\u7528\u505a join \u64cd\u4f5c\u3002\u4f46\u751f\u6210\u5bbd\u8868\u7684\u65f6\u5019\uff0c\u9762\u4e34\u7740 schema \u975e\u5e38\u5927\u7684\u95ee\u9898\uff0c\u5f88\u5bb9\u6613\u8d85\u51fa\u5b83\u7684 token\u3002\u57fa\u4e8e\u79c1\u6709\u5316\u5927\u6a21\u578b\u7684\u5fae\u8c03\u4e5f\u662f\u975e\u5e38\u5c11\u7684\u3002<\/p>\n<p>\u6211\u4eec\u8ba4\u4e3a\u4f20\u7edf\u9884\u8bad\u7ec3\u6a21\u578b\u548c\u5927\u6a21\u578b\u90fd\u9762\u4e34\u7740\u4e00\u4e2a\u5171\u540c\u7684\u6311\u6218\uff0c\u7528\u6237\u5728\u5b9e\u9645\u4f7f\u7528\u8fc7\u7a0b\u4e2d\u5176\u5b9e\u4e0d\u77e5\u9053\u6570\u636e\u662f\u5728\u54ea\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\uff0c\u600e\u4e48\u53bb\u4ece\u5927\u91cf\u7684\u5e93\u3001\u8868\u3001\u51e0\u5343\u884c\u7684 schema \u4e2d\u627e\u5230\u95ee\u9898\u5bf9\u5e94\u7684\u5217\u548c\u8868\uff0c\u9ad8\u6548\u7684\u5b8c\u6210 schema-linking \u662f\u975e\u5e38\u56f0\u96be\u7684\u3002\u73b0\u5728\u5f88\u591a Text2SQL \u7684\u8bc4\u6d4b\u4efb\u52a1\u662f\u5df2\u7ecf\u5047\u5b9a\u4e86\u8981\u7528\u54ea\u4e2a\u5e93\uff0c\u8fd9\u4e2a\u5e93\u4e2d\u7684\u8868\u548c\u5217\u5f80\u5f80\u662f\u975e\u5e38\u5c11\u7684\uff0c\u6240\u4ee5\u6ca1\u6709\u9047\u5230\u590d\u6742\u7684 schema \u4e2d\u627e\u6570\u7684\u95ee\u9898\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s2.51cto.com\/oss\/202407\/22\/b287d4c81bb1ed7a789488a86046eba0c1c9f5.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6211\u4eec\u63d0\u51fa\u4e86\u4e00\u4e9b\u5b9e\u8df5\u548c\u65b9\u6cd5\uff0c\u5148\u6784\u5efa\u4e00\u4e2a\u5143\u6570\u636e\u7684\u8bed\u4e49\u56fe\u8c31\uff0c\u8bed\u4e49\u5c31\u662f\u95ee\u9898\u52a0\u4e0a\u8868\u540d\u52a0\u5217\u540d\uff0c\u8fd9\u5c31\u662f\u751f\u6210 SQL \u9700\u8981\u7528\u5230\u7684\u6240\u6709\u8bed\u4e49\u3002\u5f53\u6211\u4eec\u53bb\u751f\u6210\u4e00\u4e2a\u8bed\u4e49\u56fe\u8c31\u7684\u65f6\u5019\uff0c\u6709\u66f4\u591a\u7684 label \u4fe1\u606f\uff0c\u8fd8\u6709\u6307\u6807\u7684\u63cf\u8ff0\uff0c\u80fd\u8865\u5145\u5230\u8fd9\u4e2a\u8bed\u4e49\u91cc\uff0c\u8ba9 prompt \u751f\u6210\u7684\u51c6\u786e\u7387\u66f4\u9ad8\u3002\u751f\u6210\u8bed\u4e49\u56fe\u8c31\uff0c\u9700\u8981\u4e00\u5957\u5b8c\u5907\u7684\u6570\u636e\u6cbb\u7406\u5de5\u5177\u3002\u6211\u4eec\u5728\u6570\u636e\u5efa\u6a21\u7684\u65f6\u5019\uff0c\u6709\u4e00\u5957\u81ea\u52a8\u5316\u7684\u6570\u636e\u6807\u51c6\u5de5\u5177\uff0c\u628a\u8fd9\u5957\u6570\u636e\u6807\u51c6\u843d\u5230\u6570\u636e\u6a21\u578b\u4e2d\uff0c\u79f0\u4e3a\u6a21\u578b\u843d\u6807\u7684\u8fc7\u7a0b\u3002\u57fa\u4e8e\u6570\u636e\u6807\u51c6\u5b8c\u6210\u6570\u636e\u6a21\u578b\u7684\u65f6\u5019\uff0c\u4f1a\u628a\u903b\u8f91\u5c42\u3001\u6982\u5ff5\u5c42\u7684\u5143\u6570\u636e\uff0c\u8fd8\u6709\u7ba1\u7406\u5143\u6570\u636e\u5171\u540c\u843d\u5230\u5143\u6570\u636e\u76ee\u5f55\u4e0a\uff0c\u518d\u57fa\u4e8e\u5143\u6570\u636e\u76ee\u5f55\u6700\u7ec8\u751f\u6210\u8bed\u4e49\u56fe\u8c31\uff0c\u8fd9\u4e2a\u662f\u751f\u6210\u5143\u6570\u636e\u8840\u7f18\u7684\u8fc7\u7a0b\u3002<\/p>\n<p>\u53e6\u5916\u6709\u4e9b\u5ba2\u6237\u5728\u642d\u5efa\u6570\u4ed3\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4f1a\u6284\u4e00\u4e9b\u4e8b\u5b9e\u8868\u3001\u7ef4\u5ea6\u8868\uff0c\u8fd9\u79cd\u6570\u4ed3\u5efa\u6a21\u7684\u5f62\u5f0f\uff0c\u6574\u4e2a\u6570\u4ed3\u5efa\u6a21\u76f4\u63a5\u505a\u6210\u4ece\u903b\u8f91\u5c42\u5f00\u59cb\u5efa\u6a21\uff0c\u4f46\u662f\u5f53\u5efa\u6a21\u5b8c\u6210\u540e\uff0c\u6570\u636e\u5f00\u53d1\u4eba\u5458\u4e0d\u77e5\u9053\u8fd9\u4e2a\u8868\u5bf9\u5e94\u5230\u4ec0\u4e48\u4e1a\u52a1\u53e3\u5f84\uff0c\u800c\u4e1a\u52a1\u53e3\u5f84\u4e5f\u4e0d\u77e5\u9053\u8fd9\u4e2a\u4e1a\u52a1\u6307\u6807\u9700\u8981\u7528\u5230\u54ea\u4e9b\u8868\uff0c\u6709\u54ea\u4e9b\u5de5\u4f5c\u6d41\uff0c\u8fd9\u4e5f\u5bfc\u81f4\u4e86\u8bed\u4e49\u4e0d\u5bf9\u7b49\u7684\u95ee\u9898\u3002\u66f4\u591a\u4e1a\u52a1\u53e3\u5f84\u7684\u8bed\u4e49\u5728\u54ea\u91cc\uff1f\u5176\u5b9e\u662f\u5728\u6982\u5ff5\u5c42\u4e0a\u9762\uff0c\u73b0\u5728\u5927\u5bb6\u505a\u6982\u5ff5\u5c42\u7684\u8bed\u4e49\u5176\u5b9e\u5168\u90e8\u662f\u7528\u77e5\u8bc6\u56fe\u8c31\u53bb\u505a\u7684\uff0c\u6240\u4ee5\u8fd9\u4e2a\u8840\u7f18\u56fe\u8c31\u5728 Text2SQL \u7684\u4efb\u52a1\u4e0a\u662f\u975e\u5e38\u91cd\u8981\u7684\u3002\u5f88\u591a\u8bba\u6587\u4e2d\u7684\u6570\u636e\u9884\u5904\u7406\u7684\u5de5\u4f5c\u662f\u5728\u505a\u8bed\u4e49\u8f6c\u6362\uff0c\u6bd4\u5982\u8868\u540d\u53eb department\uff0c\u5176\u5b9e\u5c31\u7528 DEPT \u7b80\u79f0\u6765\u7f29\u5199\uff0cDEPT \u662f\u4e00\u4e2a\u6ca1\u6709\u4efb\u4f55\u610f\u4e49\u7684\u5217\u540d\uff0cSQL \u6a21\u578b\u600e\u4e48\u80fd\u8bc6\u522b\u5f97\u5230\u5462\uff1f\u6240\u4ee5\u9700\u8981\u4e00\u4e9b\u6570\u636e\u6cbb\u7406\u7684\u524d\u671f\u51c6\u5907\u5de5\u4f5c\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u73b0\u5728\u4e1a\u754c\u90fd\u662f\u57fa\u4e8e GPT4 \u53bb\u505a Text2SQL \u4efb\u52a1\uff0c\u6211\u4eec\u4e0e\u4e00\u4e9b\u56fd\u4ea7\u5927\u6a21\u578b\u5f00\u5c55\u751f\u6001\u5408\u4f5c\uff0c\u63a5\u5165\u4e86\u5b83\u4eec\u7684\u4e00\u4e9b\u63a5\u53e3\u53bb\u505a\u6d4b\u8bd5\u3002\u73b0\u5728\u6240\u6709\u6d4b\u8bd5\u662f\u57fa\u4e8e\u7279\u5b9a\u573a\u666f\u3001\u7279\u5b9a\u6570\u636e\u3001\u7279\u5b9a\u79c1\u6709\u5316\u7684\u5927\u6a21\u578b\u53bb\u505a\u7684\uff0c\u4ec5\u4f9b\u53c2\u8003\uff0c\u4e0d\u4e00\u5b9a\u662f\u5177\u6709\u5f88\u9ad8\u7684\u4ee3\u8868\u6027\u3002\u6211\u4eec\u53d1\u73b0\u79c1\u6709\u5316\u5927\u6a21\u578b\u7684\u6307\u4ee4\u5fae\u8c03\u5728 Text2SQL \u4efb\u52a1\u4e0a\u7684\u6548\u679c\u662f\u6709\u9650\u7684\uff0c\u8fd9\u4e2a\u95ee\u9898\u76f8\u4fe1\u5f88\u5feb\u4f1a\u5f97\u5230\u89e3\u51b3\u3002\u53e6\u5916\u57fa\u4e8e schema-linking \u6240\u9009\u53d6\u51fa\u6765\u7684\u5143\u6570\u636e\u4fe1\u606f\uff0c\u518d\u53bb\u751f\u6210 prompt\uff0c\u5728\u79c1\u6709\u5316\u7684\u5927\u6a21\u578b\u4e0a\uff0cText2SQL \u4efb\u52a1\u6709 5% \u5230 10% \u7684\u63d0\u5347\u3002\u5148\u7528\u4e00\u4e2a schema-linking \u7684\u6a21\u578b\uff0c\u5148\u627e\u51fa\u548c\u95ee\u9898\u76f8\u5173\u7684\u8868\u540d\u3001\u5217\u540d\uff0c\u518d\u57fa\u4e8e\u8868\u540d\u3001\u5217\u540d\u53bb\u505aprompt \u6a21\u677f\uff0c\u6a21\u578b\u7684\u51c6\u786e\u7387\u4f1a\u6709\u63d0\u5347\uff0c\u800c\u4e0d\u662f\u76f4\u63a5\u628a\u6240\u6709\u5143\u6570\u636e\u4fe1\u606f\u5582\u7ed9\u5927\u6a21\u578b\u3002\u57fa\u4e8e\u9884\u8bad\u7ec3\u6a21\u578b schema-linking \u7684\u6548\u679c\u662f\u597d\u4e8e\u5927\u6a21\u578b\u7684\u3002In-context learning \u5bf9\u79c1\u6709\u5316\u5927\u6a21\u578b\u7684\u63d0\u5347\u6548\u679c\u662f\u6700\u660e\u663e\u7684\uff0c\u5927\u6982\u6709 10% \u7684\u63d0\u5347\u3002\u6211\u4eec\u4e4b\u524d Text2SQL \u7ecf\u5e38\u7528\u7684 Intermediate Representation \u7684\u65b9\u6cd5\uff0c\u751f\u6210\u81ea\u7136\u8bed\u8a00\u548c SQL \u8bed\u53e5\u7684\u4e00\u79cd\u4e2d\u95f4\u8bed\u8a00\u7b56\u7565\u5728\u90e8\u5206\u5927\u6a21\u578b\u4e0a\u6ca1\u6709\u5316\u5b66\u53cd\u5e94\uff0c\u751a\u81f3\u6548\u679c\u66f4\u5dee\u3002Self-correction \u5bf9\u79c1\u6709\u5316\u5927\u6a21\u578b\u6709\u5c0f\u5e45\u63d0\u5347\u3002\u76f8\u6bd4\u4e8e\u79c1\u6709\u5316\u5927\u6a21\u578b\uff0c\u76ee\u524d GPT4 \u7684\u6548\u679c\u8fd8\u662f\u9065\u9065\u9886\u5148\u7684\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s3.51cto.com\/oss\/202407\/22\/426118f29ea3a6a06c416932a016a73204c1c3.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u8fd9\u5c31\u662f\u6211\u4eec\u63d0\u51fa\u7684\u65b9\u6cd5\uff0cschema-linking \u662f\u57fa\u4e8e\u9884\u8bad\u7ec3\u6a21\u578b\u53bb\u627e\u5230\u95ee\u9898\u76f8\u5173\u7684\u8868\u548c\u5217\u540d\uff0c\u518d\u57fa\u4e8e prompt \u53bb\u505a\u5927\u6a21\u578b\uff0c\u73b0\u5728\u5f88\u591a\u8bc4\u6d4b\uff0c\u5c24\u5176\u699c\u5355\u7684\u8bc4\u6d4b\u6570\u636e\uff0c\u7528\u5230\u7684\u8868\u540d\u548c\u5217\u540d\u975e\u5e38\u5c11\uff0c\u6240\u4ee5\u5728\u505a schema-linking \u7684\u65f6\u5019\uff0c\u4e5f\u52a0\u5927\u4e86\u96be\u5ea6\uff0c\u7ed9\u5b83\u66f4\u591a\u4e0d\u540c\u7684\u6570\u636e\u5e93\u3001\u4e0d\u540c\u7684\u8868\u3001\u4e0d\u540c\u7684\u5217\u540d\uff0c\u5176 AUC \u5e76\u6ca1\u6709\u660e\u663e\u7684\u4e0b\u964d\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u8fd9\u662f\u6211\u4eec\u57fa\u4e8e\u4eba\u5927\u4eca\u5e74\u53d1\u8868\u7684\u4e00\u7bc7 RESDSQL \u7684\u8bba\u6587\u6240\u505a\u7684 schema-linking\u3002\u5176\u5e95\u5c42\u662f RoBERTa\uff0c\u57fa\u4e8e RoBERTa \u505a Pooling Module\uff0c\u628a\u5207\u7684\u8bcd\u5bf9\u5e94\u5230\u5b8c\u6574\u7684\u8868\u540d\u6216\u8005\u5217\u540d\u4e0a\uff0c\u5728\u505a\u591a\u5934\u6ce8\u610f\u529b\u7684\u65f6\u5019\uff0c\u5bf9\u5217\u540d\u505a\u591a\u5934\u6ce8\u610f\u529b\uff0c\u628a\u4e00\u4e9b\u5217\u7684\u4fe1\u606f\u5d4c\u5165\u5230\u8868\u540d\u4e0a\u6765\u63d0\u5347\u5b83\u5bf9\u95ee\u9898\u76f8\u5173\u7684\u8868\u540d\u3001\u5217\u540d\u505a\u6392\u5e8f\u3002\u6211\u4eec\u662f\u57fa\u4e8e\u8fd9\u4e2a\u6a21\u578b\u505a\u7684 schema-linking\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s8.51cto.com\/oss\/202407\/22\/71adc0d4054954048e6049ed107b27fff4e15b.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6211\u4eec\u4e5f\u53c2\u8003\u4e86\u963f\u91cc\u53d1\u8868\u7684 Dail SQL \u8fd9\u7bc7\u8bba\u6587\uff0c\u5176\u4e2d\u63d0\u51fa\u4e86 prompt \u6a21\u677f\u7684\u4e00\u4e2a\u6807\u51c6\u65b9\u6cd5\uff0c\u57fa\u4e8e prompt \u6a21\u677f\uff0c\u518d\u52a0\u4e0a GPT4\uff0c\u51c6\u786e\u7387\u80fd\u8fbe\u5230 85-86%\u3002\u4e00\u5f00\u59cb\u7528\u4e86 Code Representation \u6765\u8868\u793a schema\uff0c\u7136\u540e\u7528\u4e86 Intermediate Representation\uff0c\u540c\u65f6\u6700\u91cd\u8981\u7684\u662f\u52a0\u5165\u4e86 in-context learning\u3002\u8fd9\u7bc7\u8bba\u6587\u4e2d\uff0c\u540c\u65f6\u4f7f\u7528\u4e86\u76f8\u4f3c\u7684\u95ee\u9898\u548c\u76f8\u4f3c\u7684 SQL \u53bb\u7ec4\u6210 prompt \u6a21\u677f\u4e2d\u7684\u793a\u4f8b\uff0c\u63d0\u793a\u5927\u6a21\u578b\u53bb\u751f\u6210\u6b63\u786e\u7684 SQL\u3002\u5176\u5b9e\u8fd9\u91cc\u7f3a\u5931\u4e86 schema \u7ed3\u6784\u7684\u76f8\u4f3c\u6027\uff0c\u5f88\u591a\u65f6\u5019sql\u8bed\u53e5\u7684\u7ed3\u6784\u4e0d\u5149\u53d6\u51b3\u4e8e\u95ee\u9898\uff0c\u8fd8\u53d6\u51b3\u4e8e\u5bf9\u5e94\u7684\u6570\u636e\u5e93 schema \u7ed3\u6784\uff0c\u5982\u4f55\u5728\u76f8\u4f3c\u95ee\u9898\u548c\u76f8\u4f3c SQL \u7684\u57fa\u7840\u4e0a\u5f15\u5165\u76f8\u4f3c schema \u7684\u5224\u65ad\uff0c\u6211\u4eec\u8ba4\u4e3a\u662f\u5927\u6a21\u578b\u751f\u6210SQL\u4e0b\u4e00\u4e2a\u53ef\u4ee5\u63a2\u7d22\u7684\u65b9\u5411\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s7.51cto.com\/oss\/202407\/22\/b4befdd84fa85953887873ba0a07c922ea7c15.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4e0a\u56fe\u4e2d\u5217\u51fa\u4e86\u4e00\u4e9b Prompt \u7684\u6210\u529f\u5b9e\u8df5\u3002\u6bd4\u5982\u5206\u5272\u7b26\u7684\u5e94\u7528\u548c\u7ed3\u6784\u8bbe\u8ba1\uff0c\u53ef\u4ee5\u8ba9\u5927\u6a21\u578b\u77e5\u9053\u54ea\u4e00\u4e2a\u90e8\u5206\u662f\u5728\u63d0\u95ee\uff0c\u54ea\u4e00\u4e2a\u90e8\u5206\u662f\u5728\u8bb2 schema\uff0c\u54ea\u4e00\u90e8\u5206\u662f\u8bb2 in-context learning\u3002\u53e6\u5916\u6211\u4eec\u4f1a\u52a0\u5165\u4e00\u4e9b\u8f93\u51fa\u524d\u7f00\uff0c\u80fd\u8ba9\u5927\u6a21\u578b\u5728\u751f\u6210\u7b54\u6848\u7684\u65f6\u5019\u66f4\u52a0\u7a33\u5b9a\u3002\u8fd9\u5c31\u6d89\u53ca\u5230\u5927\u6a21\u578b\u7684\u9c81\u68d2\u6027\uff0c\u4ee5\u53ca\u6307\u5b9a\u9075\u4ece\u6027\u7684\u95ee\u9898\uff0c\u56e0\u4e3a\u6d4b\u8bd5\u7684\u8fc7\u7a0b\u4e2d\uff0c\u6211\u4eec\u4f1a\u7528\u5927\u6a21\u578b\u53bb\u5c1d\u8bd5\u505a schema-linking\uff0c\u8ba9\u5b83\u6309 JSON \u683c\u5f0f\u8f93\u51fa\u95ee\u9898\u76f8\u5173\u7684\u5217\u540d\u548c\u8868\u540d\uff0c\u53ef\u80fd 10 \u6b21\u4e2d\u4f1a\u6709 1 \u6b21\u62a5\u9519\uff0c\u6bd4\u5982 JSON \u91cc\u6709\u4e2a\u53cd\u62ec\u53f7\u6f0f\u6389\u4e86\uff0c\u6240\u4ee5\u9c81\u68d2\u6027\u8fd8\u662f\u6709\u4e00\u5b9a\u95ee\u9898\u7684\u3002<\/p>\n<p>\u63a5\u4e0b\u6765\u4ecb\u7ecd\u6570\u9020\u79d1\u6280\u7684\u4ea7\u54c1\u662f\u5982\u4f55\u5b9e\u73b0 DataOps \u4e0e\u5927\u6a21\u578b\u878d\u5408\u7684\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s3.51cto.com\/oss\/202407\/22\/69c85f060a72279fb7e988831a55930497dcb3.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4e0a\u56fe\u662f\u6570\u9020\u79d1\u6280\u7684\u4ea7\u54c1\u4f53\u7cfb\u67b6\u6784\u3002\u5bf9 DataOps \u7684\u6574\u4e2a\u8fc7\u7a0b\uff0c\u5305\u62ec\u6570\u636e\u96c6\u6210\u3001\u5f00\u53d1\uff0c\u63d0\u4f9b\u4e86\u6807\u51c6\u5316\u7684\u6d41\u7a0b\u548c\u65b9\u6cd5\uff0c\u540c\u65f6\u57fa\u4e8e\u6570\u636e\u6e56\u4ed3\u9002\u914d\u4e86\u4e0d\u540c\u7684\u79c1\u6709\u5316\u5927\u6a21\u578b\uff0c\u57fa\u4e8e\u79c1\u6709\u5316\u5927\u6a21\u578b\u53bb\u5b8c\u6210\u4ee3\u7801\u751f\u6210\u3001\u4ee3\u7801\u89e3\u91ca\u7684\u5de5\u4f5c\uff0c\u5e2e\u52a9 DataOps \u63d0\u6548\u3002\u540c\u65f6\u6709\u7edf\u4e00\u5143\u6570\u636e\u7684\u670d\u52a1\uff0c\u5bf9\u4e8e Text2SQL \u4efb\u52a1\u6765\u8bf4\uff0c\u8bed\u4e49\u5c31\u5728\u8868\u540d\u3001\u5217\u540d\u548c\u95ee\u9898\u4e0a\uff0c\u56e0\u6b64\u8981\u63d0\u4f9b\u66f4\u591a\u7684\u8bed\u4e49\u4fe1\u606f\uff0c\u6784\u5efa\u5143\u6570\u636e\u8840\u7f18\u56fe\u8c31\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u5f00\u53d1\u6cbb\u7406\u4e00\u4f53\u5316\u7684\u6570\u636e\u7ba1\u9053\u5305\u62ec\u7ba1\u7406\u57df\u3001\u5f00\u53d1\u57df\u3001\u6cbb\u7406\u57df\u3002\u5176\u4e2d\uff0c\u6cbb\u7406\u57df\u5305\u62ec\u4e00\u5957\u81ea\u52a8\u5316\u7684\u6570\u636e\u6807\u51c6\u548c\u5de5\u5177\uff0c\u5e2e\u52a9\u6211\u4eec\u5728\u6570\u636e\u5efa\u6a21\u7684\u65f6\u5019\u843d\u5730\u6570\u636e\u6807\u51c6\uff0c\u4e0d\u5141\u8bb8\u751f\u6210\u6beb\u65e0\u610f\u4e49\u7684\u8868\u540d\u3001\u5217\u540d\uff0c\u8fd9\u4e9b\u4f1a\u4e25\u91cd\u5f71\u54cd Text2SQL \u4efb\u52a1\u6548\u679c\u3002\u5f00\u53d1\u57df\u4f1a\u57fa\u4e8e\u5927\u6a21\u578b\u505a\u4ee3\u7801\u751f\u6210\u3001\u4ee3\u7801\u89e3\u6790\uff0c\u8fd8\u6709\u6ce8\u91ca\u6807\u6ce8\u7684\u5de5\u4f5c\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s9.51cto.com\/oss\/202407\/22\/c596dcb68974a89750d341e8e366a10bc350e3.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6700\u540e\uff0c\u4ea7\u54c1\u4f1a\u6709\u6301\u7eed\u96c6\u6210\u4e0e\u53d1\u5e03\u7684\u80fd\u529b\uff0c\u5305\u62ec\u4e00\u5957\u4ee3\u7801\u5728\u591a\u5957\u73af\u5883\u8fd0\u884c\u7684\u8fd9\u79cd\u591a\u73af\u5883\u521b\u5efa\u548c\u7ba1\u7406\u7684\u80fd\u529b\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s7.51cto.com\/oss\/202407\/22\/a531cbf66c9aec7e98d723e793c90b477c7b8d.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u4e0a\u56fe\u5c55\u793a\u4e86\u6211\u4eec\u4ea7\u54c1\u7684\u90e8\u5206\u529f\u80fd\u754c\u9762\u3002\u6709\u4e9b\u4f01\u4e1a\u91c7\u7528 Altas \u7b49\u5f00\u6e90\u7684\u56fe\u6570\u636e\u8840\u7f18\u5de5\u5177\uff0c\u5b83\u6709\u4e00\u4e2a\u6700\u5927\u7684\u95ee\u9898\u662f\u4e00\u5f20\u8868\u53ef\u80fd\u6709\u51e0\u5341\u4e2a\u5217\uff0c\u4e00\u5c55\u5f00\u5c31\u662f\u7206\u70b8\u5f0f\u7684\u3001\u5f88\u591a\u7684\u70b9\uff0c\u8bfb\u8d77\u6765\u975e\u5e38\u56f0\u96be\u3002\u6240\u4ee5\u6211\u4eec\u5728\u6570\u636e\u8840\u7f18\u65b9\u9762\u505a\u4e86\u5f88\u591a\u4f18\u5316\u7684\u5de5\u4f5c\uff0c\u4e0d\u5149\u662f\u628a\u5e95\u5c42\u5143\u6570\u636e\u7684\u6570\u636e\u8840\u7f18\u7ba1\u7406\u8d77\u6765\uff0c\u4e5f\u505a\u4e86\u4e00\u4e9b\u53ef\u89c6\u5316\u7684\u4f18\u5316\uff0c\u8ba9\u6570\u636e\u5f00\u53d1\u4eba\u5458\u80fd\u771f\u6b63\u7684\u57fa\u4e8e\u53ef\u89c6\u5316\u7684\u754c\u9762\u53bb\u63a2\u67e5\u6574\u4e2a\u6570\u636e\u8840\u7f18\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u4e0a\u56fe\u5c55\u793a\u7684\u662f\u6570\u636e\u81ea\u52a8\u843d\u6807\u3001\u5de5\u4f5c\u6d41\u7f16\u6392\u7b49\u529f\u80fd\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s3.51cto.com\/oss\/202407\/22\/8115c4b40b5f392a954301f36968428b886e8c.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u8fd9\u662f\u6211\u4eec\u505a\u7684\u521d\u7248 Text2SQL \u7684\u667a\u80fd\u5c0f\u52a9\u624b\uff0c\u57fa\u4e8e\u8f93\u5165\u7684\u95ee\u9898\u53ef\u4ee5\u627e\u51fa\u76f8\u5173\u7684\u5143\u6570\u636e\u4fe1\u606f\uff0c\u5982\u679c\u4e0d\u51c6\uff0c\u8fd8\u80fd\u6839\u636e\u4e4b\u524d\u7684\u6570\u636e\u6cbb\u7406\u6807\u51c6\uff0c\u624b\u52a8\u4fee\u6b63\u76f8\u5173\u7684\u4e3b\u9898\u57df\uff0c\u518d\u53bb\u5582\u7ed9\u5927\u6a21\u578b\u751f\u6210 SQL\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s4.51cto.com\/oss\/202407\/22\/37409be995e1a6962256455a9652e2485722d8.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u751f\u6210\u7684 SQL \u4e0d\u5355\u5355\u53ea\u662f\u770b\uff0c\u6709\u4e00\u4e2a\u6bd4\u8f83\u65b9\u4fbf\u7684\u5bcc\u6587\u672c\u7f16\u8f91\u5668\uff0c\u76f4\u63a5\u5728\u7f16\u8f91\u5668\u4e0a\u9009\u5b9a SQL \u8fd0\u884c\uff0c\u53ef\u4ee5\u67e5\u770b\u62a5\u8868\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s8.51cto.com\/oss\/202407\/22\/f6618012999442c82c0456ffdc1a20c7c139b4.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6700\u540e\u662f\u6301\u7eed\u96c6\u6210\u548c\u6301\u7eed\u53d1\u5e03\u7684\u529f\u80fd\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>\u56db\u3001\u672a\u6765\u5c55\u671b<\/h3>\n<p>\u6700\u540e\u5206\u4eab\u4e00\u4e9b\u5bf9\u672a\u6765\u7684\u5c55\u671b\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s2.51cto.com\/oss\/202407\/22\/160b8d40536ac3801074210127e620be485954.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6211\u4eec\u6784\u5efa\u5143\u6570\u636e\u7684\u8bed\u4e49\u56fe\u8c31\uff0c\u5c24\u5176\u662f\u6307\u6807\u5c42\uff0c\u5305\u542b\u4e86\u66f4\u591a\u7684\u4e1a\u52a1\u8bed\u4e49\u3001\u4e1a\u52a1\u53e3\u5f84\u7b49\u3002\u5982\u4f55\u628a\u6bcf\u4e2a\u6570\u636e\u6807\u51c6\u81ea\u52a8\u5316\u5de5\u5177\u5d4c\u5165\u5230\u6a21\u578b\u4e2d\uff0c\u8fd9\u662f\u6211\u4eec\u672a\u6765\u8981\u505a\u7684\u5de5\u4f5c\uff0c\u57fa\u4e8e\u66f4\u591a\u7684\u8bed\u4e49\uff0c\u770b\u6a21\u578b\u7684\u63d0\u5347\u6548\u679c\u600e\u4e48\u6837\uff0c\u73b0\u5728\u9700\u8981\u4e00\u4e9b\u4eba\u5de5\u53bb\u7ed9 Spider \u6570\u636e\u53bb\u505a\u8bed\u4e49\u7684\u8865\u5145\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s9.51cto.com\/oss\/202407\/22\/92710e7451c7e9dbfcf038f94b09bd16c552cc.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u77e5\u8bc6\u56fe\u8c31\u6709\u5f88\u591a\u5b50\u56fe\u68c0\u7d22\u589e\u5f3a\u95ee\u7b54\u7684\u65b9\u6cd5\uff0c\u6211\u4eec\u4e5f\u5728\u601d\u8003\uff0c\u628a\u8bed\u4e49\u5143\u7d20\u53bb\u56fe\u8c31\u540e\uff0c\u80fd\u4e0d\u80fd\u501f\u9274\u77e5\u8bc6\u56fe\u8c31\u57fa\u4e8e\u5b50\u56fe\u68c0\u7d22\u589e\u5f3a\u7684\u65b9\u6cd5\u53bb\u5d4c\u5165\u5b50\u56fe\u7684\u4fe1\u606f\uff0c\u57fa\u4e8e\u5b50\u56fe\u53bb\u63d0\u5347 schema-linking \u7684\u6548\u679c\uff0c\u8fd9\u4e5f\u662f\u6211\u4eec\u672a\u6765\u60f3\u8981\u63a2\u7d22\u7684\u65b9\u5411\u3002<\/p>\n<p>\u53e6\u5916\u6211\u4eec\u770b\u5230\u5927\u6a21\u578b\uff0c\u628a\u6574\u4e2a SQL \u4efb\u52a1\u62c6\u6210\u4e0d\u540c\u7684\u5b50\u4efb\u52a1\uff0c\u57fa\u4e8e\u8fd9\u4e9b\u5b50\u4efb\u52a1\u7684 Prompt \u6a21\u677f\uff0c\u5f15\u5bfc\u6a21\u578b\u751f\u6210\u6b63\u786e\u7684 SQL\uff0c\u90a3\u4e48\u80fd\u5426\u57fa\u4e8e\u5927\u6a21\u578b\u53bb\u505a\u4e00\u4e2a agent\uff0c\u7528\u4e0d\u540c\u7684\u5b50\u6a21\u578b\u53bb\u5b8c\u6210\u5404\u4e2a\u9636\u6bb5\u7684 SQL \u751f\u6210\u4efb\u52a1\uff0c\u8fd9\u4e5f\u662f\u6211\u4eec\u76ee\u524d\u7684\u4e00\u79cd\u8bbe\u60f3\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s2.51cto.com\/oss\/202407\/22\/888d9bf08429b32f91d58160c0773452d5d609.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u8fd1\u51e0\u4e2a\u6708\u6765\u6211\u4eec\u770b\u5230\u4e86\u5f88\u591a long-context \u5927\u6a21\u578b\u7684\u51fa\u73b0\uff0c\u73b0\u5728\u7684\u5927\u6a21\u578b\u53ef\u80fd\u5c31\u662f 2k\u30014k\uff0c\u6709\u4e00\u4e9b\u957f\u6587\u672c\u7684\u5927\u6a21\u578b\u5df2\u7ecf\u8f93\u5165\u5230\u4e86 200k\u3002\u73b0\u5728 Text2SQL \u6700\u5927\u7684\u95ee\u9898\u5c31\u662f\u600e\u4e48\u628a\u5927\u91cf\u7684\u751f\u4ea7\u73af\u5883\u7684\u5143\u6570\u636e\u5582\u7ed9\u6a21\u578b\uff0c\u6240\u4ee5\u6211\u4eec\u4e5f\u5728\u60f3 long-context \u7684\u5927\u6a21\u578b\u80fd\u4e0d\u80fd\u76f4\u63a5\u628a\u6240\u6709\u7684\u5143\u6570\u636e\u5582\u7ed9\u5b83\uff0c\u4e0d\u9700\u8981\u518d\u505a\u5143\u6570\u636e\u5206\u7247\u7684\u5de5\u4f5c\uff0c\u8ba9\u5b83\u53bb\u751f\u6210 SQL\u3002\u5f53\u7136\uff0c\u5173\u4e8e long-context \u5927\u6a21\u578b\u7684\u6548\u679c\uff0c\u5927\u5bb6\u4e5f\u8fd8\u5728\u89c2\u671b\u4e2d\uff0c\u8fd9\u79cd\u5927\u6a21\u578b\u7684\u6ce8\u610f\u529b\u5728\u4e8e\u5934\u5c3e\uff0c\u4e2d\u95f4\u7684\u4fe1\u606f\u53ef\u80fd\u4f1a\u7f3a\u5931\uff0c\u6240\u4ee5\u8fd9\u4e5f\u662f\u6211\u4eec\u5173\u6ce8\u7684\u4e00\u4e2a\u70b9\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s4.51cto.com\/oss\/202407\/22\/e9b36bc183015999431208754ad9633f5ceea9.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6570\u9020\u79d1\u6280\u4e13\u6ce8\u4e8e\u6570\u636e\u6cbb\u7406\u3001DataOps\u3001\u6570\u636e\u5f00\u53d1\uff0c\u662f\u65b0\u4e00\u4ee3\u654f\u6377\u6570\u636e\u7ba1\u7406\u5e73\u53f0\u7684\u4f9b\u5e94\u5546\uff0c\u5177\u6709\u5927\u6570\u636e\u8d4b\u80fd\u80fd\u529b\u3002<\/p>\n<p><img decoding=\"async\" title=\"\u56fe\u7247\" src=\"https:\/\/s9.51cto.com\/oss\/202407\/22\/03bf9240696e1b0087d5094eb8f01d3638fcca.webp\" alt=\"\u56fe\u7247\" data-type=\"inline\" \/><\/p>\n<p>\u6211\u4eec\u7684\u4ea7\u54c1\u662f\u4e00\u7ad9\u5f0f\u7684\u6570\u636e\u5f00\u53d1\u7ba1\u63a7\u5e73\u53f0\uff0c\u5305\u62ec\u6570\u636e\u6cbb\u7406\u3001\u8840\u7f18\u56fe\u8c31\u7684\u6784\u5efa\uff0c\u8fd8\u6709\u81ea\u52a8\u5316\u6807\u51c6\u6570\u636e\u6cbb\u7406\u7684\u5de5\u5177\uff0c\u4ee5\u53ca\u884c\u4e1a\u5927\u6570\u636e\u89e3\u51b3\u65b9\u6848\u3002<\/p>\n<\/div>\n<\/div>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21328\" class=\"pvc_stats total_only  \" data-element-id=\"21328\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/aif.amtbbs.org\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u4f01\u4e1a\u505a\u6570\u5b57\u5316\u8f6c\u578b\u4f1a\u5236\u5b9a\u81ea\u5df1\u7684\u6570\u5b57\u6218\u7565\uff0c\u5728\u6570\u5b57\u6218\u7565\u4e0e\u4e1a\u52a1\u6218\u7565\u5bf9\u9f50\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4f01\u4e1a\u4e5f\u5b8c\u6210\u4e86\u6570\u636e\u4ece\u6536\u96c6\u3001\u7ba1\u7406\u5230\u5206\u6790\u7684\u6d41 [&hellip;]<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21328\" class=\"pvc_stats total_only  \" data-element-id=\"21328\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.0\" viewBox=\"0 0 502 315\" preserveAspectRatio=\"xMidYMid meet\"><g transform=\"translate(0,332) scale(0.1,-0.1)\" fill=\"\" stroke=\"none\"><path d=\"M2394 3279 l-29 -30 -3 -207 c-2 -182 0 -211 15 -242 39 -76 157 -76 196 0 15 31 17 60 15 243 l-3 209 -33 29 c-26 23 -41 29 -80 29 -41 0 -53 -5 -78 -31z\"\/><path d=\"M3085 3251 c-45 -19 -58 -50 -96 -229 -47 -217 -49 -260 -13 -295 52 -53 146 -42 177 20 16 31 87 366 87 410 0 70 -86 122 -155 94z\"\/><path d=\"M1751 3234 c-13 -9 -29 -31 -37 -50 -12 -29 -10 -49 21 -204 19 -94 39 -189 45 -210 14 -50 54 -80 110 -80 34 0 48 6 76 34 21 21 34 44 34 59 0 14 -18 113 -40 219 -37 178 -43 195 -70 221 -36 32 -101 37 -139 11z\"\/><path d=\"M1163 3073 c-36 -7 -73 -59 -73 -102 0 -56 133 -378 171 -413 34 -32 83 -37 129 -13 70 36 67 87 -16 290 -86 209 -89 214 -129 231 -35 14 -42 15 -82 7z\"\/><path d=\"M3689 3066 c-15 -9 -33 -30 -42 -48 -48 -103 -147 -355 -147 -375 0 -98 131 -148 192 -74 13 15 57 108 97 206 80 196 84 226 37 273 -30 30 -99 39 -137 18z\"\/><path d=\"M583 2784 c-38 -19 -67 -74 -58 -113 9 -42 211 -354 242 -373 16 -10 45 -18 66 -18 51 0 107 52 107 100 0 39 -1 41 -124 234 -80 126 -108 162 -133 173 -41 17 -61 16 -100 -3z\"\/><path d=\"M4250 2784 c-14 -9 -74 -91 -133 -183 -95 -150 -107 -173 -107 -213 0 -55 33 -94 87 -104 67 -13 90 8 211 198 130 202 137 225 78 284 -27 27 -42 34 -72 34 -22 0 -50 -8 -64 -16z\"\/><path d=\"M2275 2693 c-553 -48 -1095 -270 -1585 -649 -135 -104 -459 -423 -483 -476 -23 -49 -22 -139 2 -186 73 -142 361 -457 571 -626 285 -228 642 -407 990 -497 242 -63 336 -73 660 -74 310 0 370 5 595 52 535 111 1045 392 1455 803 122 121 250 273 275 326 19 41 19 137 0 174 -41 79 -309 363 -465 492 -447 370 -946 591 -1479 653 -113 14 -422 18 -536 8z m395 -428 c171 -34 330 -124 456 -258 112 -119 167 -219 211 -378 27 -96 24 -300 -5 -401 -72 -255 -236 -447 -474 -557 -132 -62 -201 -76 -368 -76 -167 0 -236 14 -368 76 -213 98 -373 271 -451 485 -162 444 86 934 547 1084 153 49 292 57 452 25z m909 -232 c222 -123 408 -262 593 -441 76 -74 138 -139 138 -144 0 -16 -233 -242 -330 -319 -155 -123 -309 -223 -461 -299 l-81 -41 32 46 c18 26 49 83 70 128 143 306 141 649 -6 957 -25 52 -61 116 -79 142 l-34 47 45 -20 c26 -10 76 -36 113 -56z m-2057 25 c-40 -58 -105 -190 -130 -263 -110 -324 -59 -707 132 -981 25 -35 42 -64 37 -64 -19 0 -241 119 -326 174 -188 122 -406 314 -532 468 l-58 71 108 103 c185 178 428 349 672 473 66 33 121 60 123 61 2 0 -10 -19 -26 -42z\"\/><path d=\"M2375 1950 c-198 -44 -350 -190 -395 -379 -18 -76 -8 -221 19 -290 114 -284 457 -406 731 -260 98 52 188 154 231 260 27 69 37 214 19 290 -38 163 -166 304 -326 360 -67 23 -215 33 -279 19z\"\/><\/g><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/aif.amtbbs.org\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":56,"featured_media":21329,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,17,80],"tags":[1225],"class_list":["post-21328","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-23","category-17","category-80","tag--chatgpt4-"],"_links":{"self":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21328","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/users\/56"}],"replies":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/comments?post=21328"}],"version-history":[{"count":1,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21328\/revisions"}],"predecessor-version":[{"id":21330,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/posts\/21328\/revisions\/21330"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/media\/21329"}],"wp:attachment":[{"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/media?parent=21328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/categories?post=21328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aif.amtbbs.org\/index.php\/wp-json\/wp\/v2\/tags?post=21328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}