{"id":78763,"date":"2026-02-28T07:51:38","date_gmt":"2026-02-27T23:51:38","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/78763.html"},"modified":"2026-02-28T07:51:38","modified_gmt":"2026-02-27T23:51:38","slug":"rag%e5%ba%94%e7%94%a8%e6%95%b0%e6%8d%ae%e5%ba%93%e9%80%89%e5%9e%8b%ef%bc%9aduckdb%e3%80%81milvus%e4%b8%8esurrealdb%e6%b7%b1%e5%ba%a6%e5%af%b9%e6%af%94%e5%88%86%e6%9e%90","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/78763.html","title":{"rendered":"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790"},"content":{"rendered":"<h3>\u6458\u8981<\/h3>\n<p>\u68c0\u7d22\u589e\u5f3a\u751f\u6210&#xff08;Retrieval-Augmented Generation&#xff0c;RAG&#xff09;\u6280\u672f\u5df2\u6210\u4e3a\u5927\u8bed\u8a00\u6a21\u578b\u5e94\u7528\u843d\u5730\u7684\u6838\u5fc3\u67b6\u6784\u6a21\u5f0f\u3002\u5728RAG\u7cfb\u7edf\u4e2d&#xff0c;\u5411\u91cf\u6570\u636e\u5e93\u627f\u62c5\u7740\u8bed\u4e49\u68c0\u7d22\u7684\u5173\u952e\u804c\u8d23&#xff0c;\u5176\u9009\u578b\u76f4\u63a5\u5f71\u54cd\u7cfb\u7edf\u7684\u68c0\u7d22\u7cbe\u5ea6\u3001\u54cd\u5e94\u5ef6\u8fdf\u548c\u6269\u5c55\u80fd\u529b\u3002\u672c\u6587\u5c06\u4ece\u6280\u672f\u67b6\u6784\u3001\u6027\u80fd\u7279\u5f81\u3001\u9002\u7528\u573a\u666f\u7b49\u7ef4\u5ea6&#xff0c;\u5bf9DuckDB\u3001Milvus\u548cSurrealDB\u4e09\u6b3e\u6570\u636e\u5e93\u5728RAG\u5e94\u7528\u4e2d\u7684\u8868\u73b0\u8fdb\u884c\u7cfb\u7edf\u6027\u5bf9\u6bd4\u5206\u6790&#xff0c;\u4e3a\u6280\u672f\u9009\u578b\u63d0\u4f9b\u53c2\u8003\u4f9d\u636e\u3002<\/p>\n<h3>1. RAG\u6280\u672f\u67b6\u6784\u4e0e\u6570\u636e\u5e93\u9700\u6c42<\/h3>\n<h4>1.1 RAG\u5de5\u4f5c\u6d41\u7a0b<\/h4>\n<p>RAG\u7cfb\u7edf\u7684\u5178\u578b\u5de5\u4f5c\u6d41\u7a0b\u5305\u542b\u4ee5\u4e0b\u73af\u8282&#xff1a;<\/p>\n<li>\u6587\u6863\u5904\u7406&#xff1a;\u5bf9\u539f\u59cb\u6587\u6863\u8fdb\u884c\u5206\u5757\u3001\u6e05\u6d17\u548c\u9884\u5904\u7406<\/li>\n<li>\u5411\u91cf\u5316&#xff1a;\u901a\u8fc7Embedding\u6a21\u578b\u5c06\u6587\u672c\u8f6c\u6362\u4e3a\u9ad8\u7ef4\u5411\u91cf<\/li>\n<li>\u5411\u91cf\u5b58\u50a8&#xff1a;\u5c06\u5411\u91cf\u53ca\u5143\u6570\u636e\u6301\u4e45\u5316\u5b58\u50a8<\/li>\n<li>\u8bed\u4e49\u68c0\u7d22&#xff1a;\u6839\u636e\u67e5\u8be2\u5411\u91cf\u68c0\u7d22\u76f8\u4f3c\u6587\u6863<\/li>\n<li>\u4e0a\u4e0b\u6587\u589e\u5f3a&#xff1a;\u5c06\u68c0\u7d22\u7ed3\u679c\u4f5c\u4e3a\u4e0a\u4e0b\u6587\u8f93\u5165LLM\u751f\u6210\u56de\u7b54<\/li>\n<h4>1.2 \u6570\u636e\u5e93\u6838\u5fc3\u9700\u6c42<\/h4>\n<p>RAG\u5e94\u7528\u5bf9\u6570\u636e\u5e93\u63d0\u51fa\u4e86\u591a\u7ef4\u5ea6\u7684\u6280\u672f\u8981\u6c42&#xff1a;<\/p>\n<table>\n<tr>\u9700\u6c42\u7ef4\u5ea6\u5177\u4f53\u8981\u6c42<\/tr>\n<tbody>\n<tr>\n<td>\u5411\u91cf\u68c0\u7d22<\/td>\n<td>\u652f\u6301\u9ad8\u7ef4\u5411\u91cf\u7684\u76f8\u4f3c\u5ea6\u8ba1\u7b97&#xff08;\u4f59\u5f26\u3001\u6b27\u6c0f\u8ddd\u79bb\u7b49&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>\u68c0\u7d22\u6027\u80fd<\/td>\n<td>\u5927\u89c4\u6a21\u5411\u91cf\u96c6\u5408\u4e0b\u7684\u4f4e\u5ef6\u8fdf\u67e5\u8be2<\/td>\n<\/tr>\n<tr>\n<td>\u6df7\u5408\u67e5\u8be2<\/td>\n<td>\u5411\u91cf\u68c0\u7d22\u4e0e\u6807\u91cf\u8fc7\u6ee4\u7684\u7ec4\u5408\u80fd\u529b<\/td>\n<\/tr>\n<tr>\n<td>\u6269\u5c55\u6027<\/td>\n<td>\u6570\u636e\u91cf\u589e\u957f\u65f6\u7684\u6c34\u5e73\u6269\u5c55\u80fd\u529b<\/td>\n<\/tr>\n<tr>\n<td>\u5143\u6570\u636e\u7ba1\u7406<\/td>\n<td>\u6587\u6863\u5c5e\u6027\u3001\u6743\u9650\u7b49\u7ed3\u6784\u5316\u6570\u636e\u7684\u5b58\u50a8\u4e0e\u67e5\u8be2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>2. \u6570\u636e\u5e93\u6280\u672f\u5b9a\u4f4d\u5bf9\u6bd4<\/h3>\n<h4>2.1 \u6838\u5fc3\u5b9a\u4f4d\u5dee\u5f02<\/h4>\n<p>\u4e09\u6b3e\u6570\u636e\u5e93\u5728\u8bbe\u8ba1\u7406\u5ff5\u548c\u6280\u672f\u5b9a\u4f4d\u4e0a\u5b58\u5728\u672c\u8d28\u5dee\u5f02&#xff1a;<\/p>\n<table>\n<tr>\u6570\u636e\u5e93\u7c7b\u578b\u5b9a\u4f4d\u8bbe\u8ba1\u76ee\u6807\u5f00\u6e90\u534f\u8bae<\/tr>\n<tbody>\n<tr>\n<td>DuckDB<\/td>\n<td>\u5d4c\u5165\u5f0fOLAP\u6570\u636e\u5e93<\/td>\n<td>\u9ad8\u6027\u80fd\u5206\u6790\u67e5\u8be2<\/td>\n<td>MIT<\/td>\n<\/tr>\n<tr>\n<td>Milvus<\/td>\n<td>\u4e13\u7528\u5411\u91cf\u6570\u636e\u5e93<\/td>\n<td>\u5927\u89c4\u6a21\u5411\u91cf\u76f8\u4f3c\u5ea6\u68c0\u7d22<\/td>\n<td>Apache 2.0<\/td>\n<\/tr>\n<tr>\n<td>SurrealDB<\/td>\n<td>\u591a\u6a21\u578b\u6570\u636e\u5e93<\/td>\n<td>\u6587\u6863\u3001\u56fe\u3001\u5411\u91cf\u4e00\u4f53\u5316<\/td>\n<td>BSL 1.1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>2.2 \u67b6\u6784\u7279\u5f81\u5bf9\u6bd4<\/h4>\n<h5>DuckDB\u67b6\u6784\u7279\u5f81<\/h5>\n<p>DuckDB\u91c7\u7528\u8fdb\u7a0b\u5185\u5d4c\u5165\u5f0f\u67b6\u6784&#xff0c;\u5176\u6838\u5fc3\u7279\u5f81\u5305\u62ec&#xff1a;<\/p>\n<ul>\n<li>\u5217\u5f0f\u5b58\u50a8\u5f15\u64ce&#xff1a;\u9488\u5bf9\u5206\u6790\u578b\u67e5\u8be2\u4f18\u5316\u7684\u5b58\u50a8\u683c\u5f0f<\/li>\n<li>\u5411\u91cf\u5316\u6267\u884c&#xff1a;\u6279\u91cf\u6570\u636e\u5904\u7406&#xff0c;\u5145\u5206\u5229\u7528CPU\u7f13\u5b58\u548cSIMD\u6307\u4ee4<\/li>\n<li>\u96f6\u5916\u90e8\u4f9d\u8d56&#xff1a;\u5355\u4e00\u5e93\u6587\u4ef6&#xff0c;\u65e0\u9700\u72ec\u7acb\u670d\u52a1\u8fdb\u7a0b<\/li>\n<li>SQL\u6807\u51c6\u517c\u5bb9&#xff1a;\u63d0\u4f9b\u4e30\u5bcc\u7684SQL\u65b9\u8a00\u652f\u6301<\/li>\n<\/ul>\n<h5>Milvus\u67b6\u6784\u7279\u5f81<\/h5>\n<p>Milvus\u91c7\u7528\u5206\u5e03\u5f0f\u4e91\u539f\u751f\u67b6\u6784&#xff0c;\u6838\u5fc3\u7ec4\u4ef6\u5305\u62ec&#xff1a;<\/p>\n<ul>\n<li>\u5b58\u7b97\u5206\u79bb&#xff1a;\u8ba1\u7b97\u8282\u70b9\u4e0e\u5b58\u50a8\u8282\u70b9\u72ec\u7acb\u6269\u5c55<\/li>\n<li>\u591a\u7ea7\u7d22\u5f15&#xff1a;\u652f\u6301HNSW\u3001IVF_FLAT\u3001IVF_PQ\u3001ANNOY\u7b49\u591a\u79cdANN\u7d22\u5f15<\/li>\n<li>\u5206\u7247\u673a\u5236&#xff1a;\u6570\u636e\u81ea\u52a8\u5206\u7247&#xff0c;\u652f\u6301\u6c34\u5e73\u6269\u5c55<\/li>\n<li>\u4f9d\u8d56\u7ec4\u4ef6&#xff1a;etcd&#xff08;\u5143\u6570\u636e&#xff09;\u3001MinIO\/S3&#xff08;\u5bf9\u8c61\u5b58\u50a8&#xff09;\u3001Pulsar\/Kafka&#xff08;\u6d88\u606f\u961f\u5217&#xff09;<\/li>\n<\/ul>\n<h5>SurrealDB\u67b6\u6784\u7279\u5f81<\/h5>\n<p>SurrealDB\u91c7\u7528\u591a\u6a21\u578b\u7edf\u4e00\u67b6\u6784&#xff1a;<\/p>\n<ul>\n<li>\u591a\u6a21\u578b\u652f\u6301&#xff1a;\u6587\u6863\u5b58\u50a8\u3001\u56fe\u6570\u636e\u5e93\u3001\u5411\u91cf\u68c0\u7d22\u4e09\u4f4d\u4e00\u4f53<\/li>\n<li>\u5b9e\u65f6\u80fd\u529b&#xff1a;\u5185\u7f6eWebSocket\u652f\u6301&#xff0c;\u6570\u636e\u53d8\u66f4\u5b9e\u65f6\u63a8\u9001<\/li>\n<li>\u5355\u4f53\u90e8\u7f72&#xff1a;\u5355\u4e00\u4e8c\u8fdb\u5236\u6587\u4ef6&#xff0c;\u652f\u6301\u5d4c\u5165\u5f0f\u548c\u670d\u52a1\u5668\u6a21\u5f0f<\/li>\n<li>SurrealQL&#xff1a;\u81ea\u7814\u67e5\u8be2\u8bed\u8a00&#xff0c;\u878d\u5408SQL\u4e0e\u56fe\u67e5\u8be2\u8bed\u6cd5<\/li>\n<\/ul>\n<h3>3. RAG\u573a\u666f\u80fd\u529b\u8be6\u7ec6\u5bf9\u6bd4<\/h3>\n<h4>3.1 \u5411\u91cf\u68c0\u7d22\u80fd\u529b<\/h4>\n<h5>DuckDB\u5411\u91cf\u68c0\u7d22<\/h5>\n<p>DuckDB\u901a\u8fc7\u5185\u7f6e\u6570\u7ec4\u51fd\u6570\u63d0\u4f9b\u57fa\u7840\u5411\u91cf\u68c0\u7d22\u80fd\u529b&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; DuckDB\u5411\u91cf\u76f8\u4f3c\u5ea6\u67e5\u8be2<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    doc_id<span class=\"token punctuation\">,<\/span><br \/>\n    content<span class=\"token punctuation\">,<\/span><br \/>\n    list_cosine_similarity<span class=\"token punctuation\">(<\/span>embedding<span class=\"token punctuation\">,<\/span> $query_embedding<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> similarity_score<br \/>\n<span class=\"token keyword\">FROM<\/span> documents<br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> similarity_score <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6280\u672f\u7279\u70b9\u5206\u6790&#xff1a;<\/p>\n<ul>\n<li>\u91c7\u7528\u66b4\u529b\u641c\u7d22&#xff08;Brute-Force&#xff09;\u65b9\u5f0f&#xff0c;\u7cbe\u786e\u5ea6\u9ad8<\/li>\n<li>\u7f3a\u4e4f\u4e13\u4e1aANN\u7d22\u5f15\u652f\u6301&#xff0c;\u5927\u89c4\u6a21\u6570\u636e\u6027\u80fd\u53d7\u9650<\/li>\n<li>\u5411\u91cf\u7ef4\u5ea6\u548c\u6570\u636e\u89c4\u6a21\u53d7\u5185\u5b58\u9650\u5236<\/li>\n<\/ul>\n<h5>Milvus\u5411\u91cf\u68c0\u7d22<\/h5>\n<p>Milvus\u63d0\u4f9b\u4e13\u4e1a\u7ea7\u5411\u91cf\u68c0\u7d22\u80fd\u529b&#xff1a;<\/p>\n<p><span class=\"token keyword\">from<\/span> pymilvus <span class=\"token keyword\">import<\/span> Collection<span class=\"token punctuation\">,<\/span> connections<\/p>\n<p>connections<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span>host<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;localhost&#034;<\/span><span class=\"token punctuation\">,<\/span> port<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;19530&#034;<\/span><span class=\"token punctuation\">)<\/span><br \/>\ncollection <span class=\"token operator\">&#061;<\/span> Collection<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;rag_documents&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>search_params <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n    <span class=\"token string\">&#034;metric_type&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;COSINE&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token string\">&#034;params&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;nprobe&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">16<\/span><span class=\"token punctuation\">}<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<p>results <span class=\"token operator\">&#061;<\/span> collection<span class=\"token punctuation\">.<\/span>search<span class=\"token punctuation\">(<\/span><br \/>\n    data<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>query_embedding<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    anns_field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;embedding&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    param<span class=\"token operator\">&#061;<\/span>search_params<span class=\"token punctuation\">,<\/span><br \/>\n    limit<span class=\"token operator\">&#061;<\/span><span class=\"token number\">10<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    expr<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;category &#061;&#061; &#039;technical&#039; AND publish_date &gt; &#039;2024-01-01&#039;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    output_fields<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;doc_id&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;content&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;metadata&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><\/p>\n<p>\u6280\u672f\u7279\u70b9\u5206\u6790&#xff1a;<\/p>\n<ul>\n<li>\u652f\u6301\u591a\u79cdANN\u7d22\u5f15\u7b97\u6cd5&#xff0c;\u53ef\u6839\u636e\u573a\u666f\u9009\u62e9\u7cbe\u5ea6\u4e0e\u6027\u80fd\u7684\u5e73\u8861\u70b9<\/li>\n<li>\u539f\u751f\u652f\u6301\u5411\u91cf\u68c0\u7d22\u4e0e\u6807\u91cf\u8fc7\u6ee4\u7684\u6df7\u5408\u67e5\u8be2<\/li>\n<li>\u4ebf\u7ea7\u5411\u91cf\u89c4\u6a21\u4e0b\u4ecd\u53ef\u4fdd\u6301\u6beb\u79d2\u7ea7\u54cd\u5e94<\/li>\n<\/ul>\n<h5>SurrealDB\u5411\u91cf\u68c0\u7d22<\/h5>\n<p>SurrealDB\u901a\u8fc7\u5185\u7f6e\u5411\u91cf\u51fd\u6570\u63d0\u4f9b\u68c0\u7d22\u80fd\u529b&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; SurrealDB\u5411\u91cf\u68c0\u7d22<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    id<span class=\"token punctuation\">,<\/span><br \/>\n    content<span class=\"token punctuation\">,<\/span><br \/>\n    vector::similarity::cosine<span class=\"token punctuation\">(<\/span>embedding<span class=\"token punctuation\">,<\/span> $query_vec<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> score<br \/>\n<span class=\"token keyword\">FROM<\/span> document<br \/>\n<span class=\"token keyword\">WHERE<\/span> score <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0.7<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> score <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6280\u672f\u7279\u70b9\u5206\u6790&#xff1a;<\/p>\n<ul>\n<li>\u5411\u91cf\u68c0\u7d22\u4e0e\u6587\u6863\u3001\u56fe\u67e5\u8be2\u7edf\u4e00\u5728\u540c\u4e00\u67e5\u8be2\u8bed\u8a00\u4e2d<\/li>\n<li>\u652f\u6301\u57fa\u7840\u7684\u5411\u91cf\u76f8\u4f3c\u5ea6\u8ba1\u7b97<\/li>\n<li>\u7d22\u5f15\u80fd\u529b\u76f8\u5bf9\u6709\u9650&#xff0c;\u5927\u89c4\u6a21\u573a\u666f\u6027\u80fd\u5f85\u9a8c\u8bc1<\/li>\n<\/ul>\n<h4>3.2 \u6df7\u5408\u67e5\u8be2\u80fd\u529b<\/h4>\n<p>RAG\u5e94\u7528\u901a\u5e38\u9700\u8981\u7ed3\u5408\u8bed\u4e49\u68c0\u7d22\u4e0e\u7ed3\u6784\u5316\u8fc7\u6ee4&#xff0c;\u4e09\u6b3e\u6570\u636e\u5e93\u7684\u6df7\u5408\u67e5\u8be2\u80fd\u529b\u5b58\u5728\u663e\u8457\u5dee\u5f02\u3002<\/p>\n<h5>DuckDB\u6df7\u5408\u67e5\u8be2<\/h5>\n<p><span class=\"token comment\">&#8212; DuckDB\u6df7\u5408\u67e5\u8be2&#xff1a;\u5411\u91cf\u68c0\u7d22 &#043; \u5173\u7cfb\u578b\u8fc7\u6ee4 &#043; \u805a\u5408\u5206\u6790<\/span><br \/>\n<span class=\"token keyword\">WITH<\/span> semantic_matches <span class=\"token keyword\">AS<\/span> <span class=\"token punctuation\">(<\/span><br \/>\n    <span class=\"token keyword\">SELECT<\/span><br \/>\n        doc_id<span class=\"token punctuation\">,<\/span><br \/>\n        content<span class=\"token punctuation\">,<\/span><br \/>\n        category<span class=\"token punctuation\">,<\/span><br \/>\n        list_cosine_similarity<span class=\"token punctuation\">(<\/span>embedding<span class=\"token punctuation\">,<\/span> $query_vec<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> score<br \/>\n    <span class=\"token keyword\">FROM<\/span> documents<br \/>\n    <span class=\"token keyword\">WHERE<\/span> publish_date <span class=\"token operator\">&gt;&#061;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span><br \/>\n      <span class=\"token operator\">AND<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;published&#039;<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    category<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> match_count<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token function\">AVG<\/span><span class=\"token punctuation\">(<\/span>score<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> avg_relevance<span class=\"token punctuation\">,<\/span><br \/>\n    ARRAY_AGG<span class=\"token punctuation\">(<\/span>content <span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> score <span class=\"token keyword\">DESC<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">1<\/span>:<span class=\"token number\">3<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">AS<\/span> top_contents<br \/>\n<span class=\"token keyword\">FROM<\/span> semantic_matches<br \/>\n<span class=\"token keyword\">WHERE<\/span> score <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0.6<\/span><br \/>\n<span class=\"token keyword\">GROUP<\/span> <span class=\"token keyword\">BY<\/span> category<br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> avg_relevance <span class=\"token keyword\">DESC<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>DuckDB\u5728\u590d\u6742SQL\u67e5\u8be2\u65b9\u9762\u5177\u6709\u663e\u8457\u4f18\u52bf&#xff0c;\u652f\u6301\u7a97\u53e3\u51fd\u6570\u3001CTE\u3001\u5b50\u67e5\u8be2\u7b49\u9ad8\u7ea7\u7279\u6027\u3002<\/p>\n<h5>Milvus\u6df7\u5408\u67e5\u8be2<\/h5>\n<p><span class=\"token comment\"># Milvus\u6df7\u5408\u67e5\u8be2&#xff1a;\u5411\u91cf\u68c0\u7d22 &#043; \u6807\u91cf\u8fc7\u6ee4<\/span><br \/>\nresults <span class=\"token operator\">&#061;<\/span> collection<span class=\"token punctuation\">.<\/span>search<span class=\"token punctuation\">(<\/span><br \/>\n    data<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>query_embedding<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    anns_field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;embedding&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    param<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;metric_type&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;COSINE&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;params&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;nprobe&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    limit<span class=\"token operator\">&#061;<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    expr<span class=\"token operator\">&#061;<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n        category in [&#039;tech&#039;, &#039;science&#039;]<br \/>\n        AND word_count &gt; 500<br \/>\n        AND publish_date &gt; &#039;2024-01-01&#039;<br \/>\n    &#034;&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    output_fields<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;doc_id&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;content&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;category&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;publish_date&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><\/p>\n<p>Milvus\u7684\u6807\u91cf\u8fc7\u6ee4\u80fd\u529b\u76f8\u5bf9\u57fa\u7840&#xff0c;\u4e0d\u652f\u6301\u590d\u6742\u7684JOIN\u548c\u805a\u5408\u64cd\u4f5c\u3002<\/p>\n<h5>SurrealDB\u6df7\u5408\u67e5\u8be2<\/h5>\n<p><span class=\"token comment\">&#8212; SurrealDB\u6df7\u5408\u67e5\u8be2&#xff1a;\u5411\u91cf &#043; \u56fe\u904d\u5386<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    id<span class=\"token punctuation\">,<\/span><br \/>\n    content<span class=\"token punctuation\">,<\/span><br \/>\n    vector::similarity::cosine<span class=\"token punctuation\">(<\/span>embedding<span class=\"token punctuation\">,<\/span> $query_vec<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> score<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>cites<span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>document<span class=\"token punctuation\">.<\/span>title <span class=\"token keyword\">AS<\/span> cited_documents<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token operator\">&lt;<\/span><span class=\"token operator\">&#8211;<\/span>written_by<span class=\"token operator\">&lt;<\/span><span class=\"token operator\">&#8211;<\/span>author<span class=\"token punctuation\">.<\/span>name <span class=\"token keyword\">AS<\/span> authors<br \/>\n<span class=\"token keyword\">FROM<\/span> document<br \/>\n<span class=\"token keyword\">WHERE<\/span> score <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0.7<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>belongs_to<span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>category<span class=\"token punctuation\">.<\/span>name <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;Machine Learning&#039;<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> score <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>SurrealDB\u7684\u72ec\u7279\u4f18\u52bf\u5728\u4e8e\u5c06\u5411\u91cf\u68c0\u7d22\u4e0e\u56fe\u904d\u5386\u67e5\u8be2\u65e0\u7f1d\u7ed3\u5408\u3002<\/p>\n<h4>3.3 \u6269\u5c55\u6027\u4e0e\u90e8\u7f72\u6a21\u5f0f<\/h4>\n<table>\n<tr>\u7279\u6027DuckDBMilvusSurrealDB<\/tr>\n<tbody>\n<tr>\n<td>\u90e8\u7f72\u6a21\u5f0f<\/td>\n<td>\u5d4c\u5165\u5f0f\/\u5355\u673a<\/td>\n<td>\u5206\u5e03\u5f0f\u96c6\u7fa4<\/td>\n<td>\u5355\u673a\/\u96c6\u7fa4<\/td>\n<\/tr>\n<tr>\n<td>\u6c34\u5e73\u6269\u5c55<\/td>\n<td>\u4e0d\u652f\u6301<\/td>\n<td>\u539f\u751f\u652f\u6301<\/td>\n<td>\u6709\u9650\u652f\u6301<\/td>\n<\/tr>\n<tr>\n<td>\u9ad8\u53ef\u7528<\/td>\n<td>\u4e0d\u652f\u6301<\/td>\n<td>\u652f\u6301&#xff08;\u591a\u526f\u672c&#xff09;<\/td>\n<td>\u652f\u6301&#xff08;TiKV\u540e\u7aef&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>\u90e8\u7f72\u590d\u6742\u5ea6<\/td>\n<td>\u6781\u4f4e<\/td>\n<td>\u8f83\u9ad8<\/td>\n<td>\u4e2d\u7b49<\/td>\n<\/tr>\n<tr>\n<td>\u8d44\u6e90\u5360\u7528<\/td>\n<td>\u6781\u4f4e<\/td>\n<td>\u8f83\u9ad8<\/td>\n<td>\u4e2d\u7b49<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>3.4 \u751f\u6001\u96c6\u6210\u80fd\u529b<\/h4>\n<h5>DuckDB\u751f\u6001\u96c6\u6210<\/h5>\n<p><span class=\"token keyword\">import<\/span> duckdb<br \/>\n<span class=\"token keyword\">import<\/span> pandas <span class=\"token keyword\">as<\/span> pd<br \/>\n<span class=\"token keyword\">from<\/span> sentence_transformers <span class=\"token keyword\">import<\/span> SentenceTransformer<\/p>\n<p><span class=\"token comment\"># \u4e0ePython\u6570\u636e\u79d1\u5b66\u751f\u6001\u65e0\u7f1d\u96c6\u6210<\/span><br \/>\nmodel <span class=\"token operator\">&#061;<\/span> SentenceTransformer<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;all-MiniLM-L6-v2&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\ndf <span class=\"token operator\">&#061;<\/span> pd<span class=\"token punctuation\">.<\/span>read_parquet<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;documents.parquet&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\ndf<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;embedding&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&#061;<\/span> df<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;content&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span><span class=\"token builtin\">apply<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">lambda<\/span> x<span class=\"token punctuation\">:<\/span> model<span class=\"token punctuation\">.<\/span>encode<span class=\"token punctuation\">(<\/span>x<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>tolist<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># \u76f4\u63a5\u67e5\u8be2DataFrame<\/span><br \/>\nconn <span class=\"token operator\">&#061;<\/span> duckdb<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><br \/>\nresults <span class=\"token operator\">&#061;<\/span> conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n    SELECT content, list_cosine_similarity(embedding, ?) AS score<br \/>\n    FROM df<br \/>\n    ORDER BY score DESC LIMIT 10<br \/>\n&#034;&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span>query_embedding<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>fetchdf<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h5>Milvus\u751f\u6001\u96c6\u6210<\/h5>\n<p><span class=\"token keyword\">from<\/span> langchain<span class=\"token punctuation\">.<\/span>vectorstores <span class=\"token keyword\">import<\/span> Milvus<br \/>\n<span class=\"token keyword\">from<\/span> langchain<span class=\"token punctuation\">.<\/span>embeddings <span class=\"token keyword\">import<\/span> OpenAIEmbeddings<\/p>\n<p><span class=\"token comment\"># LangChain\u539f\u751f\u96c6\u6210<\/span><br \/>\nvectorstore <span class=\"token operator\">&#061;<\/span> Milvus<span class=\"token punctuation\">.<\/span>from_documents<span class=\"token punctuation\">(<\/span><br \/>\n    documents<span class=\"token punctuation\">,<\/span><br \/>\n    OpenAIEmbeddings<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    connection_args<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;host&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;localhost&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;port&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;19530&#034;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    collection_name<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;langchain_docs&#034;<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># \u68c0\u7d22\u5668\u63a5\u53e3<\/span><br \/>\nretriever <span class=\"token operator\">&#061;<\/span> vectorstore<span class=\"token punctuation\">.<\/span>as_retriever<span class=\"token punctuation\">(<\/span>search_kwargs<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;k&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">5<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h5>SurrealDB\u751f\u6001\u96c6\u6210<\/h5>\n<p><span class=\"token keyword\">from<\/span> surrealdb <span class=\"token keyword\">import<\/span> Surreal<\/p>\n<p><span class=\"token keyword\">async<\/span> <span class=\"token keyword\">with<\/span> Surreal<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;ws:\/\/localhost:8000\/rpc&#034;<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> db<span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">await<\/span> db<span class=\"token punctuation\">.<\/span>signin<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;user&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;root&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;pass&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;root&#034;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">await<\/span> db<span class=\"token punctuation\">.<\/span>use<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;namespace&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;database&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token comment\"># \u63d2\u5165\u5e26\u5411\u91cf\u7684\u6587\u6863<\/span><br \/>\n    <span class=\"token keyword\">await<\/span> db<span class=\"token punctuation\">.<\/span>create<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;document&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token string\">&#034;content&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;RAG\u6280\u672f\u6587\u6863&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;embedding&#034;<\/span><span class=\"token punctuation\">:<\/span> embedding_vector<span class=\"token punctuation\">,<\/span><br \/>\n        <span class=\"token string\">&#034;metadata&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;category&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;tech&#034;<\/span><span class=\"token punctuation\">}<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h3>4. \u5178\u578b\u5e94\u7528\u573a\u666f\u63a8\u8350<\/h3>\n<h4>4.1 DuckDB\u9002\u7528\u573a\u666f<\/h4>\n<p>\u63a8\u8350\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u539f\u578b\u5f00\u53d1\u4e0e\u6982\u5ff5\u9a8c\u8bc1&#xff08;POC&#xff09;\u9636\u6bb5<\/li>\n<li>\u6587\u6863\u89c4\u6a21\u572810\u4e07\u6761\u4ee5\u5185\u7684\u5c0f\u578bRAG\u5e94\u7528<\/li>\n<li>\u9700\u8981\u590d\u6742SQL\u5206\u6790\u7684\u6df7\u5408\u67e5\u8be2\u573a\u666f<\/li>\n<li>\u8fb9\u7f18\u8bbe\u5907\u6216\u79bb\u7ebf\u73af\u5883\u90e8\u7f72<\/li>\n<li>\u6570\u636e\u79d1\u5b66\u5de5\u4f5c\u6d41\u4e2d\u7684\u4e34\u65f6\u5411\u91cf\u68c0\u7d22\u9700\u6c42<\/li>\n<\/ul>\n<p>\u5178\u578b\u7528\u4f8b&#xff1a;<\/p>\n<p><span class=\"token comment\"># \u672c\u5730\u77e5\u8bc6\u5e93\u95ee\u7b54\u539f\u578b<\/span><br \/>\n<span class=\"token keyword\">import<\/span> duckdb<\/p>\n<p><span class=\"token keyword\">def<\/span> <span class=\"token function\">simple_rag_query<\/span><span class=\"token punctuation\">(<\/span>question<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">,<\/span> conn<span class=\"token punctuation\">:<\/span> duckdb<span class=\"token punctuation\">.<\/span>DuckDBPyConnection<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    query_embedding <span class=\"token operator\">&#061;<\/span> embed_model<span class=\"token punctuation\">.<\/span>encode<span class=\"token punctuation\">(<\/span>question<span class=\"token punctuation\">)<\/span><\/p>\n<p>    results <span class=\"token operator\">&#061;<\/span> conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n        SELECT content, metadata<br \/>\n        FROM knowledge_base<br \/>\n        WHERE list_cosine_similarity(embedding, ?) &gt; 0.7<br \/>\n        ORDER BY list_cosine_similarity(embedding, ?) DESC<br \/>\n        LIMIT 5<br \/>\n    &#034;&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span>query_embedding<span class=\"token punctuation\">,<\/span> query_embedding<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>fetchall<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    context <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#034;\\\\n&#034;<\/span><span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span>r<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> r <span class=\"token keyword\">in<\/span> results<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token keyword\">return<\/span> llm<span class=\"token punctuation\">.<\/span>generate<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;\u57fa\u4e8e\u4ee5\u4e0b\u5185\u5bb9\u56de\u7b54\u95ee\u9898&#xff1a;\\\\n<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>context<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\\\\n\\\\n\u95ee\u9898&#xff1a;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>question<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><\/p>\n<h4>4.2 Milvus\u9002\u7528\u573a\u666f<\/h4>\n<p>\u63a8\u8350\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u751f\u4ea7\u7ea7\u5927\u89c4\u6a21RAG\u7cfb\u7edf&#xff08;\u767e\u4e07\u81f3\u4ebf\u7ea7\u6587\u6863&#xff09;<\/li>\n<li>\u5bf9\u68c0\u7d22\u5ef6\u8fdf\u6709\u4e25\u683c\u8981\u6c42\u7684\u5b9e\u65f6\u5e94\u7528<\/li>\n<li>\u9700\u8981\u6c34\u5e73\u6269\u5c55\u80fd\u529b\u7684\u4f01\u4e1a\u7ea7\u90e8\u7f72<\/li>\n<li>\u591a\u79df\u6237SaaS\u5e73\u53f0\u7684\u5411\u91cf\u68c0\u7d22\u670d\u52a1<\/li>\n<li>\u4e0eLangChain\u3001LlamaIndex\u7b49\u6846\u67b6\u6df1\u5ea6\u96c6\u6210\u7684\u9879\u76ee<\/li>\n<\/ul>\n<p>\u5178\u578b\u7528\u4f8b&#xff1a;<\/p>\n<p><span class=\"token comment\"># \u4f01\u4e1a\u7ea7RAG\u68c0\u7d22\u670d\u52a1<\/span><br \/>\n<span class=\"token keyword\">from<\/span> pymilvus <span class=\"token keyword\">import<\/span> Collection<span class=\"token punctuation\">,<\/span> utility<\/p>\n<p><span class=\"token keyword\">class<\/span> <span class=\"token class-name\">ProductionRAGRetriever<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> collection_name<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>collection <span class=\"token operator\">&#061;<\/span> Collection<span class=\"token punctuation\">(<\/span>collection_name<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>collection<span class=\"token punctuation\">.<\/span>load<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">retrieve<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> query_embedding<span class=\"token punctuation\">,<\/span> filters<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">,<\/span> top_k<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">int<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        expr <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_build_filter_expr<span class=\"token punctuation\">(<\/span>filters<span class=\"token punctuation\">)<\/span><\/p>\n<p>        results <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>collection<span class=\"token punctuation\">.<\/span>search<span class=\"token punctuation\">(<\/span><br \/>\n            data<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>query_embedding<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            anns_field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;embedding&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            param<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">{<\/span><br \/>\n                <span class=\"token string\">&#034;metric_type&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;COSINE&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n                <span class=\"token string\">&#034;params&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;nprobe&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">16<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;ef&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">64<\/span><span class=\"token punctuation\">}<\/span><br \/>\n            <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            limit<span class=\"token operator\">&#061;<\/span>top_k<span class=\"token punctuation\">,<\/span><br \/>\n            expr<span class=\"token operator\">&#061;<\/span>expr<span class=\"token punctuation\">,<\/span><br \/>\n            output_fields<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;doc_id&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;content&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;metadata&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">return<\/span> self<span class=\"token punctuation\">.<\/span>_format_results<span class=\"token punctuation\">(<\/span>results<span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">_build_filter_expr<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> filters<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        conditions <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token string\">&#034;tenant_id&#034;<\/span> <span class=\"token keyword\">in<\/span> filters<span class=\"token punctuation\">:<\/span><br \/>\n            conditions<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;tenant_id &#061;&#061; &#039;<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>filters<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;tenant_id&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#039;&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">if<\/span> <span class=\"token string\">&#034;category&#034;<\/span> <span class=\"token keyword\">in<\/span> filters<span class=\"token punctuation\">:<\/span><br \/>\n            conditions<span class=\"token punctuation\">.<\/span>append<span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f&#034;category in <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>filters<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;category&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><span class=\"token punctuation\">)<\/span><br \/>\n        <span class=\"token keyword\">return<\/span> <span class=\"token string\">&#034; AND &#034;<\/span><span class=\"token punctuation\">.<\/span>join<span class=\"token punctuation\">(<\/span>conditions<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">if<\/span> conditions <span class=\"token keyword\">else<\/span> <span class=\"token string\">&#034;&#034;<\/span><\/p>\n<h4>4.3 SurrealDB\u9002\u7528\u573a\u666f<\/h4>\n<p>\u63a8\u8350\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u77e5\u8bc6\u56fe\u8c31\u589e\u5f3a\u7684RAG\u5e94\u7528<\/li>\n<li>\u9700\u8981\u56fe\u5173\u7cfb\u63a8\u7406\u7684\u590d\u6742\u68c0\u7d22\u573a\u666f<\/li>\n<li>\u5168\u6808\u5e94\u7528&#xff0c;\u5e0c\u671b\u7b80\u5316\u6280\u672f\u6808<\/li>\n<li>\u5b9e\u65f6\u534f\u4f5c\u5e94\u7528&#xff0c;\u9700\u8981\u6570\u636e\u53d8\u66f4\u8ba2\u9605<\/li>\n<li>\u4e2d\u5c0f\u89c4\u6a21\u5e94\u7528&#xff0c;\u8ffd\u6c42\u5f00\u53d1\u6548\u7387<\/li>\n<\/ul>\n<p>\u5178\u578b\u7528\u4f8b&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; \u77e5\u8bc6\u56fe\u8c31\u589e\u5f3aRAG\u67e5\u8be2<\/span><br \/>\n<span class=\"token comment\">&#8212; \u68c0\u7d22\u76f8\u5173\u6587\u6863\u5e76\u83b7\u53d6\u5173\u8054\u5b9e\u4f53\u4fe1\u606f<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    doc<span class=\"token punctuation\">.<\/span>id<span class=\"token punctuation\">,<\/span><br \/>\n    doc<span class=\"token punctuation\">.<\/span>content<span class=\"token punctuation\">,<\/span><br \/>\n    vector::similarity::cosine<span class=\"token punctuation\">(<\/span>doc<span class=\"token punctuation\">.<\/span>embedding<span class=\"token punctuation\">,<\/span> $query_vec<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> relevance<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token keyword\">SELECT<\/span> <span class=\"token keyword\">VALUE<\/span> entity<span class=\"token punctuation\">.<\/span>name<br \/>\n        <span class=\"token keyword\">FROM<\/span> doc<span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>mentions<span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>entity<br \/>\n        <span class=\"token keyword\">WHERE<\/span> entity<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">type<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;Concept&#039;<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> related_concepts<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token punctuation\">(<\/span><br \/>\n        <span class=\"token keyword\">SELECT<\/span> <span class=\"token keyword\">VALUE<\/span> ref<span class=\"token punctuation\">.<\/span>title<br \/>\n        <span class=\"token keyword\">FROM<\/span> doc<span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span><span class=\"token keyword\">references<\/span><span class=\"token operator\">&#8211;<\/span><span class=\"token operator\">&gt;<\/span>ref<br \/>\n    <span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> <span class=\"token keyword\">references<\/span><br \/>\n<span class=\"token keyword\">FROM<\/span> document <span class=\"token keyword\">AS<\/span> doc<br \/>\n<span class=\"token keyword\">WHERE<\/span> relevance <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0.6<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> relevance <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h3>5. \u6df7\u5408\u67b6\u6784\u65b9\u6848<\/h3>\n<p>\u5728\u5b9e\u9645\u751f\u4ea7\u73af\u5883\u4e2d&#xff0c;\u5355\u4e00\u6570\u636e\u5e93\u5f80\u5f80\u96be\u4ee5\u6ee1\u8db3RAG\u7cfb\u7edf\u7684\u5168\u90e8\u9700\u6c42\u3002\u6df7\u5408\u67b6\u6784\u65b9\u6848\u53ef\u5145\u5206\u53d1\u6325\u5404\u6570\u636e\u5e93\u7684\u4f18\u52bf\u3002<\/p>\n<h4>5.1 DuckDB &#043; Milvus\u6df7\u5408\u67b6\u6784<\/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\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502                      RAG Application                         \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\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524<br \/>\n\u2502                                                              \u2502<br \/>\n\u2502  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510  \u2502<br \/>\n\u2502  \u2502   DuckDB     \u2502    \u2502    Milvus    \u2502    \u2502     LLM      \u2502  \u2502<br \/>\n\u2502  \u2502              \u2502    \u2502              \u2502    \u2502              \u2502  \u2502<br \/>\n\u2502  \u2502 \u2022 \u6570\u636e\u9884\u5904\u7406  \u2502\u2500\u2500\u2500\u25b6\u2502 \u2022 \u5411\u91cf\u5b58\u50a8   \u2502\u2500\u2500\u2500\u25b6\u2502 \u2022 \u751f\u6210\u56de\u7b54   \u2502  \u2502<br \/>\n\u2502  \u2502 \u2022 \u5143\u6570\u636e\u7ba1\u7406  \u2502    \u2502 \u2022 \u8bed\u4e49\u68c0\u7d22   \u2502    \u2502              \u2502  \u2502<br \/>\n\u2502  \u2502 \u2022 \u5206\u6790\u62a5\u8868   \u2502\u25c0\u2500\u2500\u2500\u2502 \u2022 ANN\u7d22\u5f15    \u2502    \u2502              \u2502  \u2502<br \/>\n\u2502  \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518    \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518    \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518  \u2502<br \/>\n\u2502                                                              \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\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/p>\n<p>\u804c\u8d23\u5206\u5de5&#xff1a;<\/p>\n<ul>\n<li>DuckDB&#xff1a;\u6587\u6863\u9884\u5904\u7406\u3001\u7279\u5f81\u5de5\u7a0b\u3001\u5143\u6570\u636e\u7ba1\u7406\u3001\u5206\u6790\u62a5\u8868<\/li>\n<li>Milvus&#xff1a;\u5411\u91cf\u5b58\u50a8\u3001\u8bed\u4e49\u68c0\u7d22\u3001\u76f8\u4f3c\u5ea6\u8ba1\u7b97<\/li>\n<\/ul>\n<h4>5.2 \u5b9e\u73b0\u793a\u4f8b<\/h4>\n<p><span class=\"token keyword\">import<\/span> duckdb<br \/>\n<span class=\"token keyword\">from<\/span> pymilvus <span class=\"token keyword\">import<\/span> Collection<\/p>\n<p><span class=\"token keyword\">class<\/span> <span class=\"token class-name\">HybridRAGSystem<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>duckdb_conn <span class=\"token operator\">&#061;<\/span> duckdb<span class=\"token punctuation\">.<\/span>connect<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;metadata.duckdb&#039;<\/span><span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>milvus_collection <span class=\"token operator\">&#061;<\/span> Collection<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;documents&#034;<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">ingest_documents<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> documents<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">list<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token comment\"># DuckDB\u5904\u7406\u5143\u6570\u636e<\/span><br \/>\n        metadata_df <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_extract_metadata<span class=\"token punctuation\">(<\/span>documents<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>duckdb_conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><br \/>\n            <span class=\"token string\">&#034;INSERT INTO document_metadata SELECT * FROM metadata_df&#034;<\/span><br \/>\n        <span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># Milvus\u5b58\u50a8\u5411\u91cf<\/span><br \/>\n        vectors <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_generate_embeddings<span class=\"token punctuation\">(<\/span>documents<span class=\"token punctuation\">)<\/span><br \/>\n        self<span class=\"token punctuation\">.<\/span>milvus_collection<span class=\"token punctuation\">.<\/span>insert<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><br \/>\n            <span class=\"token punctuation\">[<\/span>doc<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;id&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> doc <span class=\"token keyword\">in<\/span> documents<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            vectors<span class=\"token punctuation\">,<\/span><br \/>\n            <span class=\"token punctuation\">[<\/span>doc<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;content&#039;<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> doc <span class=\"token keyword\">in<\/span> documents<span class=\"token punctuation\">]<\/span><br \/>\n        <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>    <span class=\"token keyword\">def<\/span> <span class=\"token function\">hybrid_search<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> query<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">str<\/span><span class=\"token punctuation\">,<\/span> filters<span class=\"token punctuation\">:<\/span> <span class=\"token builtin\">dict<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token comment\"># Step 1: DuckDB\u9884\u8fc7\u6ee4\u83b7\u53d6\u5019\u9009\u6587\u6863ID<\/span><br \/>\n        candidate_ids <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>duckdb_conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n            SELECT doc_id FROM document_metadata<br \/>\n            WHERE category &#061; ? AND publish_date &gt; ?<br \/>\n        &#034;&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span>filters<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;category&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> filters<span class=\"token punctuation\">[<\/span><span class=\"token string\">&#039;date&#039;<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>fetchall<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># Step 2: Milvus\u5728\u5019\u9009\u96c6\u4e2d\u8fdb\u884c\u5411\u91cf\u68c0\u7d22<\/span><br \/>\n        query_embedding <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>_embed<span class=\"token punctuation\">(<\/span>query<span class=\"token punctuation\">)<\/span><br \/>\n        id_filter <span class=\"token operator\">&#061;<\/span> <span class=\"token string-interpolation\"><span class=\"token string\">f&#034;doc_id in <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token punctuation\">[<\/span><span class=\"token builtin\">id<\/span><span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token keyword\">for<\/span> <span class=\"token builtin\">id<\/span> <span class=\"token keyword\">in<\/span> candidate_ids<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">&#034;<\/span><\/span><\/p>\n<p>        results <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>milvus_collection<span class=\"token punctuation\">.<\/span>search<span class=\"token punctuation\">(<\/span><br \/>\n            data<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">[<\/span>query_embedding<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            anns_field<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#034;embedding&#034;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            param<span class=\"token operator\">&#061;<\/span><span class=\"token punctuation\">{<\/span><span class=\"token string\">&#034;metric_type&#034;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;COSINE&#034;<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            limit<span class=\"token operator\">&#061;<\/span><span class=\"token number\">10<\/span><span class=\"token punctuation\">,<\/span><br \/>\n            expr<span class=\"token operator\">&#061;<\/span>id_filter<br \/>\n        <span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token comment\"># Step 3: DuckDB\u8865\u5145\u5b8c\u6574\u5143\u6570\u636e<\/span><br \/>\n        doc_ids <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">[<\/span>hit<span class=\"token punctuation\">.<\/span><span class=\"token builtin\">id<\/span> <span class=\"token keyword\">for<\/span> hit <span class=\"token keyword\">in<\/span> results<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">]<\/span><br \/>\n        full_results <span class=\"token operator\">&#061;<\/span> self<span class=\"token punctuation\">.<\/span>duckdb_conn<span class=\"token punctuation\">.<\/span>execute<span class=\"token punctuation\">(<\/span><span class=\"token triple-quoted-string string\">&#034;&#034;&#034;<br \/>\n            SELECT * FROM document_metadata<br \/>\n            WHERE doc_id IN (SELECT UNNEST(?))<br \/>\n        &#034;&#034;&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span>doc_ids<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>fetchdf<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><\/p>\n<p>        <span class=\"token keyword\">return<\/span> full_results<\/p>\n<h3>6. \u9009\u578b\u51b3\u7b56\u6846\u67b6<\/h3>\n<h4>6.1 \u6838\u5fc3\u80fd\u529b\u5bf9\u6bd4<\/h4>\n<table>\n<tr>\u80fd\u529b\u7ef4\u5ea6DuckDBMilvusSurrealDB<\/tr>\n<tbody>\n<tr>\n<td>\u5411\u91cf\u68c0\u7d22<\/td>\n<td>\u66b4\u529b\u641c\u7d22&#xff0c;\u65e0ANN\u7d22\u5f15<\/td>\n<td>\u591a\u79cdANN\u7d22\u5f15&#xff0c;\u4ebf\u7ea7\u652f\u6301<\/td>\n<td>\u57fa\u7840\u652f\u6301<\/td>\n<\/tr>\n<tr>\n<td>\u90e8\u7f72\u590d\u6742\u5ea6<\/td>\n<td>\u96f6\u4f9d\u8d56&#xff0c;\u5d4c\u5165\u5f0f<\/td>\n<td>\u9700etcd\/MinIO\u7b49\u7ec4\u4ef6<\/td>\n<td>\u5355\u4e8c\u8fdb\u5236&#xff0c;\u8f83\u7b80\u5355<\/td>\n<\/tr>\n<tr>\n<td>\u6c34\u5e73\u6269\u5c55<\/td>\n<td>\u4e0d\u652f\u6301<\/td>\n<td>\u539f\u751f\u5206\u5e03\u5f0f<\/td>\n<td>\u6709\u9650\u652f\u6301<\/td>\n<\/tr>\n<tr>\n<td>SQL\u80fd\u529b<\/td>\n<td>\u5b8c\u6574SQL\u652f\u6301<\/td>\n<td>\u4ec5\u6807\u91cf\u8fc7\u6ee4<\/td>\n<td>SurrealQL&#xff0c;\u8f83\u5b8c\u6574<\/td>\n<\/tr>\n<tr>\n<td>\u56fe\u67e5\u8be2<\/td>\n<td>\u4e0d\u652f\u6301<\/td>\n<td>\u4e0d\u652f\u6301<\/td>\n<td>\u539f\u751f\u652f\u6301<\/td>\n<\/tr>\n<tr>\n<td>\u751f\u6001\u6210\u719f\u5ea6<\/td>\n<td>\u6210\u719f&#xff0c;\u793e\u533a\u6d3b\u8dc3<\/td>\n<td>\u6210\u719f&#xff0c;LangChain\u7b49\u6df1\u5ea6\u96c6\u6210<\/td>\n<td>\u8f83\u65b0&#xff0c;\u751f\u6001\u5efa\u8bbe\u4e2d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>6.2 \u5feb\u901f\u51b3\u7b56\u6307\u5357<\/h4>\n<p>\u5f00\u59cb<br \/>\n  \u2502<br \/>\n  \u25bc<br \/>\n\u6587\u6863\u89c4\u6a21\u662f\u5426\u8d85\u8fc7100\u4e07&#xff1f;<br \/>\n  \u2502<br \/>\n  \u251c\u2500 \u662f \u2500\u2500\u25b6 \u9009\u62e9 Milvus<br \/>\n  \u2502<br \/>\n  \u25bc \u5426<br \/>\n\u662f\u5426\u9700\u8981\u56fe\u5173\u7cfb\u67e5\u8be2&#xff1f;<br \/>\n  \u2502<br \/>\n  \u251c\u2500 \u662f \u2500\u2500\u25b6 \u9009\u62e9 SurrealDB<br \/>\n  \u2502<br \/>\n  \u25bc \u5426<br \/>\n\u662f\u5426\u4e3a\u539f\u578b\/POC\u9636\u6bb5&#xff1f;<br \/>\n  \u2502<br \/>\n  \u251c\u2500 \u662f \u2500\u2500\u25b6 \u9009\u62e9 DuckDB<br \/>\n  \u2502<br \/>\n  \u25bc \u5426<br \/>\n\u662f\u5426\u9700\u8981\u590d\u6742SQL\u5206\u6790&#xff1f;<br \/>\n  \u2502<br \/>\n  \u251c\u2500 \u662f \u2500\u2500\u25b6 \u9009\u62e9 DuckDB &#043; Milvus\u6df7\u5408\u67b6\u6784<br \/>\n  \u2502<br \/>\n  \u25bc \u5426<br \/>\n\u9009\u62e9 Milvus&#xff08;\u751f\u4ea7\u73af\u5883\u9996\u9009&#xff09;<\/p>\n<h3>7. \u603b\u7ed3\u4e0e\u5efa\u8bae<\/h3>\n<h4>7.1 \u6838\u5fc3\u7ed3\u8bba<\/h4>\n<p>\u4e09\u6b3e\u6570\u636e\u5e93\u5728RAG\u5e94\u7528\u573a\u666f\u4e2d\u5404\u5177\u7279\u8272&#xff1a;<\/p>\n<ul>\n<li>DuckDB&#xff1a;\u4ee5\u6781\u4f4e\u7684\u90e8\u7f72\u6210\u672c\u548c\u5f3a\u5927\u7684SQL\u80fd\u529b\u89c1\u957f&#xff0c;\u9002\u5408\u539f\u578b\u5f00\u53d1\u548c\u5c0f\u89c4\u6a21\u5e94\u7528&#xff0c;\u4f46\u5411\u91cf\u68c0\u7d22\u80fd\u529b\u6709\u9650<\/li>\n<li>Milvus&#xff1a;\u4e13\u4e1a\u5411\u91cf\u6570\u636e\u5e93\u7684\u4ee3\u8868&#xff0c;\u5728\u5927\u89c4\u6a21\u5411\u91cf\u68c0\u7d22\u573a\u666f\u4e0b\u6027\u80fd\u5353\u8d8a&#xff0c;\u662f\u751f\u4ea7\u7ea7RAG\u7cfb\u7edf\u7684\u9996\u9009<\/li>\n<li>SurrealDB&#xff1a;\u591a\u6a21\u578b\u7edf\u4e00\u7684\u521b\u65b0\u8bbe\u8ba1&#xff0c;\u5728\u77e5\u8bc6\u56fe\u8c31\u589e\u5f3aRAG\u573a\u666f\u4e2d\u5177\u6709\u72ec\u7279\u4f18\u52bf<\/li>\n<\/ul>\n<h4>7.2 \u5b9e\u8df5\u5efa\u8bae<\/h4>\n<li>\u539f\u578b\u9636\u6bb5&#xff1a;\u4f18\u5148\u9009\u62e9DuckDB&#xff0c;\u5feb\u901f\u9a8c\u8bc1\u4e1a\u52a1\u903b\u8f91<\/li>\n<li>\u751f\u4ea7\u90e8\u7f72&#xff1a;\u6839\u636e\u89c4\u6a21\u9009\u62e9Milvus\u6216\u6df7\u5408\u67b6\u6784<\/li>\n<li>\u77e5\u8bc6\u56fe\u8c31\u573a\u666f&#xff1a;\u8003\u8651SurrealDB\u6216Neo4j &#043; \u5411\u91cf\u63d2\u4ef6\u65b9\u6848<\/li>\n<li>\u6301\u7eed\u6f14\u8fdb&#xff1a;\u5efa\u7acb\u62bd\u8c61\u5c42&#xff0c;\u4fdd\u6301\u6570\u636e\u5e93\u5207\u6362\u7684\u7075\u6d3b\u6027<\/li>\n<h4>7.3 \u672a\u6765\u5c55\u671b<\/h4>\n<p>\u968f\u7740RAG\u6280\u672f\u7684\u6301\u7eed\u6f14\u8fdb&#xff0c;\u6570\u636e\u5e93\u9886\u57df\u4e5f\u5728\u5feb\u901f\u53d1\u5c55&#xff1a;<\/p>\n<ul>\n<li>DuckDB\u6b63\u5728\u589e\u5f3a\u5411\u91cf\u68c0\u7d22\u80fd\u529b&#xff0c;\u672a\u6765\u7248\u672c\u53ef\u80fd\u5f15\u5165ANN\u7d22\u5f15\u652f\u6301<\/li>\n<li>Milvus\u6301\u7eed\u4f18\u5316\u6df7\u5408\u67e5\u8be2\u80fd\u529b&#xff0c;\u5411\u5168\u529f\u80fd\u6570\u636e\u5e93\u65b9\u5411\u6f14\u8fdb<\/li>\n<li>SurrealDB\u4f5c\u4e3a\u65b0\u5174\u9879\u76ee&#xff0c;\u591a\u6a21\u578b\u7edf\u4e00\u7684\u7406\u5ff5\u5177\u6709\u957f\u671f\u4ef7\u503c<\/li>\n<\/ul>\n<p>\u6280\u672f\u9009\u578b\u5e94\u7ed3\u5408\u56e2\u961f\u80fd\u529b\u3001\u4e1a\u52a1\u9700\u6c42\u548c\u957f\u671f\u89c4\u5212\u7efc\u5408\u8003\u91cf&#xff0c;\u907f\u514d\u8fc7\u5ea6\u8bbe\u8ba1&#xff0c;\u4e5f\u8981\u4e3a\u672a\u6765\u6269\u5c55\u9884\u7559\u7a7a\u95f4\u3002<\/p>\n<hr \/>\n<p>\u53c2\u8003\u8d44\u6e90&#xff1a;<\/p>\n<ul>\n<li>DuckDB\u5b98\u65b9\u6587\u6863&#xff1a;https:\/\/duckdb.org\/docs\/<\/li>\n<li>Milvus\u5b98\u65b9\u6587\u6863&#xff1a;https:\/\/milvus.io\/docs\/<\/li>\n<li>SurrealDB\u5b98\u65b9\u6587\u6863&#xff1a;https:\/\/surrealdb.com\/docs\/<\/li>\n<li>LangChain\u5411\u91cf\u5b58\u50a8\u96c6\u6210&#xff1a;https:\/\/python.langchain.com\/docs\/integrations\/vectorstores\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u6458\u8981<br \/>\n\u68c0\u7d22\u589e\u5f3a\u751f\u6210&#xff08;Retrieval-Augmented Generation&#xff0c;RAG&#xff09;\u6280\u672f\u5df2\u6210\u4e3a\u5927\u8bed\u8a00\u6a21\u578b\u5e94\u7528\u843d\u5730\u7684\u6838\u5fc3\u67b6\u6784\u6a21\u5f0f\u3002\u5728RAG\u7cfb\u7edf\u4e2d&#xff0c;\u5411\u91cf\u6570\u636e\u5e93\u627f\u62c5\u7740\u8bed\u4e49\u68c0\u7d22\u7684\u5173\u952e\u804c\u8d23&#xff0c;\u5176\u9009\u578b\u76f4\u63a5\u5f71\u54cd\u7cfb\u7edf\u7684\u68c0\u7d22\u7cbe\u5ea6\u3001\u54cd\u5e94\u5ef6\u8fdf\u548c\u6269\u5c55\u80fd\u529b\u3002\u672c\u6587\u5c06\u4ece\u6280\u672f\u67b6\u6784\u3001\u6027\u80fd\u7279\u5f81\u3001\u9002\u7528\u573a\u666f\u7b49\u7ef4\u5ea6&#xff0c;\u5bf9DuckDB\u3001Milvus\u548cSurrealDB\u4e09\u6b3e\u6570\u636e\u5e93\u5728RAG\u5e94\u7528\u4e2d\u7684\u8868\u73b0\u8fdb\u884c\u7cfb\u7edf\u6027\u5bf9\u6bd4\u5206\u6790&#xff0c;\u4e3a\u6280<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4119,50,100],"topic":[],"class_list":["post-78763","post","type-post","status-publish","format-standard","hentry","category-server","tag-rag","tag-50","tag-100"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790 - \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\/78763.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6458\u8981 \u68c0\u7d22\u589e\u5f3a\u751f\u6210&#xff08;Retrieval-Augmented Generation&#xff0c;RAG&#xff09;\u6280\u672f\u5df2\u6210\u4e3a\u5927\u8bed\u8a00\u6a21\u578b\u5e94\u7528\u843d\u5730\u7684\u6838\u5fc3\u67b6\u6784\u6a21\u5f0f\u3002\u5728RAG\u7cfb\u7edf\u4e2d&#xff0c;\u5411\u91cf\u6570\u636e\u5e93\u627f\u62c5\u7740\u8bed\u4e49\u68c0\u7d22\u7684\u5173\u952e\u804c\u8d23&#xff0c;\u5176\u9009\u578b\u76f4\u63a5\u5f71\u54cd\u7cfb\u7edf\u7684\u68c0\u7d22\u7cbe\u5ea6\u3001\u54cd\u5e94\u5ef6\u8fdf\u548c\u6269\u5c55\u80fd\u529b\u3002\u672c\u6587\u5c06\u4ece\u6280\u672f\u67b6\u6784\u3001\u6027\u80fd\u7279\u5f81\u3001\u9002\u7528\u573a\u666f\u7b49\u7ef4\u5ea6&#xff0c;\u5bf9DuckDB\u3001Milvus\u548cSurrealDB\u4e09\u6b3e\u6570\u636e\u5e93\u5728RAG\u5e94\u7528\u4e2d\u7684\u8868\u73b0\u8fdb\u884c\u7cfb\u7edf\u6027\u5bf9\u6bd4\u5206\u6790&#xff0c;\u4e3a\u6280\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/78763.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-27T23:51:38+00:00\" \/>\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\/78763.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/78763.html\",\"name\":\"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-02-27T23:51:38+00:00\",\"dateModified\":\"2026-02-27T23:51:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/78763.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/78763.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/78763.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790\"}]},{\"@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":"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790 - \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\/78763.html","og_locale":"zh_CN","og_type":"article","og_title":"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6458\u8981 \u68c0\u7d22\u589e\u5f3a\u751f\u6210&#xff08;Retrieval-Augmented Generation&#xff0c;RAG&#xff09;\u6280\u672f\u5df2\u6210\u4e3a\u5927\u8bed\u8a00\u6a21\u578b\u5e94\u7528\u843d\u5730\u7684\u6838\u5fc3\u67b6\u6784\u6a21\u5f0f\u3002\u5728RAG\u7cfb\u7edf\u4e2d&#xff0c;\u5411\u91cf\u6570\u636e\u5e93\u627f\u62c5\u7740\u8bed\u4e49\u68c0\u7d22\u7684\u5173\u952e\u804c\u8d23&#xff0c;\u5176\u9009\u578b\u76f4\u63a5\u5f71\u54cd\u7cfb\u7edf\u7684\u68c0\u7d22\u7cbe\u5ea6\u3001\u54cd\u5e94\u5ef6\u8fdf\u548c\u6269\u5c55\u80fd\u529b\u3002\u672c\u6587\u5c06\u4ece\u6280\u672f\u67b6\u6784\u3001\u6027\u80fd\u7279\u5f81\u3001\u9002\u7528\u573a\u666f\u7b49\u7ef4\u5ea6&#xff0c;\u5bf9DuckDB\u3001Milvus\u548cSurrealDB\u4e09\u6b3e\u6570\u636e\u5e93\u5728RAG\u5e94\u7528\u4e2d\u7684\u8868\u73b0\u8fdb\u884c\u7cfb\u7edf\u6027\u5bf9\u6bd4\u5206\u6790&#xff0c;\u4e3a\u6280","og_url":"https:\/\/www.wsisp.com\/helps\/78763.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-02-27T23:51:38+00:00","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\/78763.html","url":"https:\/\/www.wsisp.com\/helps\/78763.html","name":"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-02-27T23:51:38+00:00","dateModified":"2026-02-27T23:51:38+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/78763.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/78763.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/78763.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"RAG\u5e94\u7528\u6570\u636e\u5e93\u9009\u578b\uff1aDuckDB\u3001Milvus\u4e0eSurrealDB\u6df1\u5ea6\u5bf9\u6bd4\u5206\u6790"}]},{"@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\/78763","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=78763"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/78763\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=78763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=78763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=78763"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=78763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}