	{"id":1015858,"date":"2025-10-02T12:28:40","date_gmt":"2025-10-02T11:28:40","guid":{"rendered":"https:\/\/www.artefact.com\/?post_type=blog&#038;p=1015858"},"modified":"2025-10-10T09:35:02","modified_gmt":"2025-10-10T08:35:02","slug":"motherduck-explained-how-it-fits-into-your-data-stack-with-benchmarks","status":"publish","type":"blog","link":"https:\/\/www.artefact.com\/zh\/blog\/motherduck-explained-how-it-fits-into-your-data-stack-with-benchmarks\/","title":{"rendered":"MotherDuck \u89e3\u8bfb\uff1a\u65b0\u4e00\u4ee3 AI \u548c\u5206\u6790\u89e3\u51b3\u65b9\u6848\u5982\u4f55\u878d\u5165\u60a8\u7684 Data \u5806\u6808"},"content":{"rendered":"<h2>\u6267\u884c\u6458\u8981<\/h2>\n<p>MotherDuck \u901a\u8fc7\u534f\u4f5c\u529f\u80fd\u5c06 DuckDB \u7684\u5206\u6790\u6027\u80fd\u6269\u5c55\u5230 cloud\uff0c\u63d0\u4f9b\u6bd4 BigQuery \u5feb 4 \u500d\u7684\u6027\u80fd\uff0c\u5e76\u901a\u8fc7\u65e0\u670d\u52a1\u5668\u3001\u6309\u4f7f\u7528\u4ed8\u8d39\u7684\u5b9a\u4ef7\u65b9\u5f0f\u6bd4\u4f20\u7edf\u7684 data \u4ed3\u5e93\u8282\u7ea6\u6210\u672c\u3002\u5728MotherDuck\u5ba3\u5e03\u65b0\u7684\u6b27\u6d32cloud\u533a\u57df\u540e\uff0c\u5176\u6027\u80fd\u548c\u8bf1\u4eba\u7684\u4ef7\u683c\u7ed9\u6211\u4eec\u7559\u4e0b\u4e86\u6df1\u523b\u5370\u8c61\u3002MotherDuck \u5df2\u7ecf\u53ef\u4ee5\u96c6\u6210\u5230\u60a8\u7684\u9ec4\u91d1\u5c42\u4e2d\uff0c\u4ee5\u52a0\u5feb data \u7528\u4f8b\u7684\u670d\u52a1\u901f\u5ea6\uff0c\u540c\u65f6\u8282\u7ea6\u6210\u672c\u3002\u67e5\u770b\u6027\u80fd\u57fa\u51c6\u3002.<\/p>\n<h2><b>\u5bfc\u8a00<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u5728\u5feb\u901f\u53d1\u5c55\u7684 data \u5206\u6790\u9886\u57df\uff0c\u4e00\u4e2a\u65b0\u7684\u53c2\u4e0e\u8005\u6b63\u5728\u6311\u6218 cloud data \u4ed3\u5e93\u7684\u65e2\u5b9a\u79e9\u5e8f\u3002. <\/span><a href=\"https:\/\/motherduck.com\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">MotherDuck<\/span><\/a><span style=\"font-weight: 400;\">, \u5efa\u7acb\u5728\u4ee5\u4e0b\u57fa\u7840\u4e4b\u4e0a <\/span><a href=\"https:\/\/duckdb.org\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u9e2d\u5b50\u6570\u636e\u5e93<\/span><\/a><span style=\"font-weight: 400;\">\u2018\u5b83\u62e5\u6709\u5feb\u5982\u95ea\u7535\u7684\u5206\u6790\u5f15\u64ce\uff0c\u53ef\u63d0\u4f9b\u4f01\u4e1a\u7ea7\u6027\u80fd\uff0c\u5e76\u5177\u6709\u73b0\u4ee3 data \u56e2\u961f\u6240\u6e34\u671b\u7684\u7b80\u4fbf\u6027\u548c\u6210\u672c\u6548\u76ca\u3002\u4f46\u8fd9\u53ea \"\u9e2d\u5b50 \"\u771f\u7684\u80fd\u4e0e\u8001\u724c\u5de8\u5934\u76f8\u6297\u8861\u5417\uff1f<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u5bf9 MotherDuck \u8fdb\u884c\u4e86\u4e25\u683c\u7684\u6d4b\u8bd5\uff0c\u4ee5\u68c0\u9a8c\u5b83\u662f\u5426\u4e0d\u8d1f\u4f17\u671b\u3002\u6211\u4eec\u7684\u53d1\u73b0\u6311\u6218\u4e86\u5f53\u524d\u5206\u6790\u578b database \u7684\u73b0\u72b6\uff0c\u5e76\u5efa\u8bae\u6211\u4eec\u4ece\u6839\u672c\u4e0a\u6539\u53d8\u57fa\u4e8e cloud \u7684 data \u5904\u7406\u65b9\u6cd5\u3002\u8fd9\u5c31\u662f\u5d4c\u5165\u5f0f database \u5982\u4f55\u5b66\u4f1a\u98de\u884c\u7684\u6545\u4e8b\uff0c\u4ee5\u53ca\u4e3a\u4ec0\u4e48\u5b83\u53ef\u80fd\u4f1a\u5f7b\u5e95\u6539\u53d8\u60a8\u7684 data \u5806\u6808\u3002.<\/span><\/p>\n<p>\u8981\u6293\u4f4f\u8fd9\u79cd\u4e0d\u65ad\u53d8\u5316\u7684\u987e\u5ba2\uff0c\u96f6\u552e\u5546\u5fc5\u987b\u8fc5\u901f\u505a\u51fa\u8c03\u6574\u3002.<\/p>\n<h2><b>\u4e00\u53ea\u6b63\u5728\u5b75\u5316\u7684\u9e2d\u5b50<\/b><\/h2>\n<p><a href=\"https:\/\/motherduck.com\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">MotherDuck<\/span><\/a><span style=\"font-weight: 400;\"> \u5c06\u81ea\u5df1\u63cf\u8ff0\u4e3a \u201cDuckDB cloud data \u4ed3\u5e93\uff0c\u53ef\u6269\u5c55\u81f3 TB \u7ea7\uff0c\u7528\u4e8e\u9762\u5411\u5ba2\u6237\u7684\u5206\u6790\u548c BI\u201d\u3002\u8981\u4e86\u89e3\u8fd9\u4e2a cloud data \u4ed3\u5e93\u7684\u7279\u522b\u4e4b\u5904\uff0c\u6211\u4eec\u9996\u5148\u9700\u8981\u770b\u770b <\/span><a href=\"https:\/\/duckdb.org\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u9e2d\u5b50\u6570\u636e\u5e93<\/span><\/a><span style=\"font-weight: 400;\">, DuckDB \u662f\u4e00\u4e2a\u5f00\u6e90 database \u7cfb\u7edf\uff0c\u5728\u8fc7\u53bb\u51e0\u5e74\u4e2d\u6084\u7136\u6539\u53d8\u4e86 data \u5806\u6808\u3002\u7b80\u5355\u5730\u8bf4\uff0cDuckDB \u662f\u4e00\u4e2a\u5185\u5b58 OLAP SQL database \u7cfb\u7edf\u3002\u5bf9\u4e8e\u90a3\u4e9b\u4e0d\u61c2 database \u672f\u8bed\u7684\u4eba\uff0c\u8ba9\u6211\u4eec\u6765\u89e3\u91ca\u4e00\u4e0b\u5b83\u7684\u5b9e\u9645\u542b\u4e49\uff1a<\/span><\/p>\n<p><span style=\"font-weight: 400;\">OLAP \u662f\u8054\u673a\u5206\u6790\u5904\u7406\u7684\u7f29\u5199\u3002\u53ef\u4ee5\u628a\u5b83\u770b\u4f5c\u662f\u4e00\u4e2a database\uff0c\u7528\u4e8e\u5feb\u901f\u5904\u7406\u6d77\u91cf data \u6570\u636e\u5e76\u56de\u7b54\u590d\u6742\u7684\u4e1a\u52a1\u95ee\u9898\u3002\u4f20\u7edf\u7684 database \u64c5\u957f\u67e5\u627e\u5355\u4e2a\u8bb0\u5f55\uff08\u5982\u67e5\u8be2\u5ba2\u6237\u8ba2\u5355\uff09\uff0c\u800c OLAP database \u5219\u4e0d\u540c\uff0c\u5b83\u53ef\u4ee5\u5728\u6570\u79d2\u5185\u626b\u63cf\u6570\u767e\u4e07\u884c\u5e76\u6267\u884c\u7e41\u91cd\u7684\u8ba1\u7b97\u3002\u5b83\u4eec\u901a\u8fc7\u4ee5\u5217\u800c\u4e0d\u662f\u884c\u4e3a\u5355\u4f4d\u5b58\u50a8 data \u6765\u5b9e\u73b0\u8fd9\u79cd\u901f\u5ea6\uff0c\u4ece\u800c\u53ef\u4ee5\u5feb\u5982\u95ea\u7535\u5730\u5206\u6790\u8d8b\u52bf\u3001\u8ba1\u7b97\u5e73\u5747\u503c\u6216\u6c47\u603b\u6574\u4e2a data \u96c6\u7684\u9500\u552e\u989d\u3002BigQuery \u6216 Snowflake \u7b49\u73b0\u4ee3 data \u4ed3\u5e93\u4e5f\u91c7\u7528\u4e86\u540c\u6837\u7684\u65b9\u6cd5\u3002\u53e6\u4e00\u65b9\u9762\uff0c\u8fd8\u6709 PostgreSQL\u3001SQLite \u6216 MySQL \u7b49 OLTP\uff08\u5728\u7ebf\u4e8b\u52a1\u5904\u7406\uff09data \u5e93\u3002\u8fd9\u4e9b\u6570\u636e\u5e93\u662f\u4e3a\u60a8\u7684\u5e94\u7528\u63d0\u4f9b\u52a8\u529b\u7684\u5de5\u4f5c\u6bcd\u673a\uff0c\u6bcf\u79d2\u53ef\u5904\u7406\u6210\u5343\u4e0a\u4e07\u6b21\u5355\u72ec\u8bfb\u5199\uff0c\u4ee5\u4fdd\u8bc1\u60a8\u7684\u5e94\u7528\u987a\u5229\u8fd0\u884c\u3002.<\/span><a href=\"https:\/\/motherduck.com\/learn-more\/what-is-OLAP\/#olap-vs-oltp\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">\u67e5\u770b\u6709\u5173 OLAP \u4e0e OLTP \u7684\u66f4\u591a\u4fe1\u606f<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u4e3a\u4e86\u4e86\u89e3 DuckDB \u7684\u65b9\u6cd5\u5230\u5e95\u6709\u591a\u5927\u7684\u9769\u547d\u6027\uff0c\u6211\u4eec\u9700\u8981\u56de\u8fc7\u5934\u6765\u770b\u770b\u6211\u4eec\u662f\u5982\u4f55\u8d70\u5230\u8fd9\u4e00\u6b65\u7684\u300220 \u4e16\u7eaa 90 \u5e74\u4ee3\u4e2d\u671f\uff0c\u968f\u7740\u96c5\u864e\u548c\u4e9a\u9a6c\u900a\u7b49\u7f51\u7edc\u5de8\u5934\u7684\u5d1b\u8d77\uff0c\u4ed6\u4eec\u9047\u5230\u4e86\u4e00\u5835\u5c06\u91cd\u5851\u6574\u4e2a data \u683c\u5c40\u7684\u5899\u3002\u8fd9\u4e9b\u516c\u53f8\u88ab data\uff08\u6211\u4eec\u540e\u6765\u79f0\u4e4b\u4e3a \u201c\u5927 data\u201d\uff09\u6df9\u6ca1\uff0c\u800c\u4ed6\u4eec\u73b0\u6709\u7684\u7cfb\u7edf\u6839\u672c\u65e0\u6cd5\u8ddf\u4e0a\u3002\u89e3\u51b3\u65b9\u6848\u662f\u4ec0\u4e48\uff1f\u6602\u8d35\u7684\u5355\u7247\u5f0f\u57fa\u7840\u67b6\u6784\u53ef\u4ee5\u5e94\u5bf9\u8fd9\u79cd\u89c4\u6a21\u3002\u4f46\u968f\u7740 2000 \u5e74\u4ee3\u786c\u4ef6\u6210\u672c\u7684\u6025\u5267\u4e0b\u964d\uff0c\u4e00\u79cd\u65b0\u7684\u7406\u5ff5\u51fa\u73b0\u4e86\uff1a\u4e0e\u5176\u8d2d\u4e70\u66f4\u5927\u7684\u673a\u5668\uff0c\u4e3a\u4ec0\u4e48\u4e0d\u4f7f\u7528\u5927\u91cf\u66f4\u5c0f\u3001\u66f4\u4fbf\u5b9c\u7684\u673a\u5668\u5462\uff1f\u8fd9\u79cd\u601d\u60f3\u50ac\u751f\u4e86 MapReduce \u548c Apache Hadoop \u7b49\u5206\u5e03\u5f0f\u7cfb\u7edf\uff0c\u8fd9\u4e9b\u6280\u672f\u65e8\u5728\u5c06\u5de5\u4f5c\u8d1f\u8f7d\u5206\u6563\u5230\u5546\u54c1\u786c\u4ef6\u96c6\u7fa4\u4e2d\u3002\u4e9a\u9a6c\u900a\u6293\u4f4f\u4e86\u8fd9\u4e00\u8d8b\u52bf\uff0c\u5c06\u8fd9\u4e9b\u5206\u5e03\u5f0f\u6280\u672f\u6253\u5305\u6210\u670d\u52a1\uff0c\u63a8\u51fa\u4e86\u9996\u4e2a\u5927\u578b cloud \u5e73\u53f0--\u4e9a\u9a6c\u900a\u7f51\u7edc\u670d\u52a1\u3002\u591a\u5e74\u6765\uff0c\u8fd9\u6210\u4e86\u9ed8\u8ba4\u7684\u73a9\u6cd5\uff1a\u9047\u5230 data \u95ee\u9898\u65f6\uff0c\u5c31\u5c06\u5176\u5206\u5e03\u5230\u66f4\u591a\u673a\u5668\u4e0a\uff08Fundamentals of Data Engineering, Joe Reis &amp; Matt Housley\uff09\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u4f46\u4ee4\u4eba\u7740\u8ff7\u7684\u662f\uff1a\u5f53\u6240\u6709\u4eba\u90fd\u5fd9\u4e8e\u6784\u5efa\u5206\u5e03\u5f0f\u7cfb\u7edf\u65f6\uff0c\u53e6\u4e00\u4e9b\u4e8b\u60c5\u5374\u5728\u540e\u53f0\u6084\u7136\u53d1\u751f\u3002\u8ba9\u5206\u5e03\u5f0f\u8ba1\u7b97\u53d8\u5f97\u7ecf\u6d4e\u5b9e\u60e0\u7684\u529b\u91cf\uff0c\u4e5f\u8ba9\u5355\u673a\u53d8\u5f97\u65e0\u6bd4\u5f3a\u5927\u3002\u5982\u4eca\uff0c\u4f60\u7684\u7b14\u8bb0\u672c\u7535\u8111\u5df2\u7ecf\u53d8\u5f97\u65e0\u6bd4\u5f3a\u5927\uff0c\u62e5\u6709\u66f4\u591a\u7684\u5185\u5b58\u3001\u66f4\u5feb\u7684\u5904\u7406\u5668\u548c\u66f4\u597d\u7684\u5b58\u50a8\u7a7a\u95f4\u3002DuckDB \u80cc\u540e\u7684\u5f00\u53d1\u4eba\u5458\u610f\u8bc6\u5230\u4e86\u8fd9\u4e2a\u88ab\u5ffd\u89c6\u7684\u673a\u4f1a\uff1a\u5982\u679c\u6211\u4eec\u4e0d\u603b\u662f\u5411\u5916\u6269\u5c55\uff0c\u800c\u662f\u66f4\u667a\u80fd\u5730\u6269\u5c55\u5462\uff1f\u5982\u679c\u6211\u4eec\u53ef\u4ee5\u89e3\u51b3\u8bb8\u591a data \u95ee\u9898\uff0c\u800c\u5b8c\u5168\u4e0d\u9700\u8981\u5206\u5e03\u5f0f\u7cfb\u7edf\u7684\u590d\u6742\u6027\u5462\uff1f<\/span><\/p>\n<p><a href=\"https:\/\/www.sqlite.org\/mostdeployed.html\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u5168\u7403\u90e8\u7f72\u6700\u591a\u7684 database \u53d1\u52a8\u673a\u4e4b\u4e00<\/span><\/a><span style=\"font-weight: 400;\">, SQLite \u91c7\u7528\u4e86\u4e0e\u4f20\u7edf database \u5b8c\u5168\u4e0d\u540c\u7684\u65b9\u6cd5\u3002PostgreSQL \u548c MySQL \u4f5c\u4e3a\u5355\u72ec\u7684\u670d\u52a1\u5668\u8fd0\u884c\uff0c\u5e94\u7528\u7a0b\u5e8f\u901a\u8fc7\u7f51\u7edc\u8fde\u63a5\u5230\u670d\u52a1\u5668\uff0c\u800c SQLite \u5219\u4f5c\u4e3a\u8f7b\u91cf\u7ea7\u5e93\u76f4\u63a5\u5d4c\u5165\u5230\u5e94\u7528\u7a0b\u5e8f\u4e2d\u3002\u6ca1\u6709\u670d\u52a1\u5668\u9700\u8981\u914d\u7f6e\uff0c\u6ca1\u6709\u7f51\u7edc\u5f00\u9500\uff0c\u4e5f\u6ca1\u6709\u590d\u6742\u7684\u8bbe\u7f6e\uff0c\u53ea\u6709\u5728\u5e94\u7528\u7a0b\u5e8f\u8fdb\u7a0b\u4e2d\u8fd0\u884c\u7684\u7eaf\u672c\u5730 database \u529f\u80fd\u3002\u8fd9\u79cd\u7b80\u5355\u6027\u4e0e\u51fa\u8272\u7684\u53ef\u9760\u6027\u548c\u901f\u5ea6\u76f8\u7ed3\u5408\uff0c\u4f7f SQLite \u5728\u4ece\u79fb\u52a8\u5e94\u7528\u7a0b\u5e8f\u5230\u7f51\u7edc\u6d4f\u89c8\u5668\u7684\u6240\u6709\u5e94\u7528\u7a0b\u5e8f\u4e2d\u65e0\u5904\u4e0d\u5728\u3002.<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015859 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck.png\" alt=\"\" width=\"1800\" height=\"698\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271800%27%20height%3D%27698%27%20viewBox%3D%270%200%201800%20698%27%3E%3Crect%20width%3D%271800%27%20height%3D%27698%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-200x78.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-300x116.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-400x155.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-600x233.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-768x298.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-800x310.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-1024x397.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-1200x465.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck-1536x596.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Client-Server-MotherDuck.png 1800w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1800px) 100vw, 1800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">DuckDB \u5c06\u540c\u6837\u7684\u5d4c\u5165\u5f0f\u7406\u5ff5\u5e94\u7528\u4e8e\u5206\u6790\u5de5\u4f5c\u8d1f\u8f7d\uff0c\u8bc1\u660e\u4e86\u60a8\u5e76\u4e0d\u603b\u662f\u9700\u8981\u4e00\u4e2a\u5206\u5e03\u5f0f\u7cfb\u7edf\u6765\u5904\u7406\u5927\u578b data \u6570\u636e\u96c6\u3002\u5c31\u50cf SQLite \u5f7b\u5e95\u6539\u53d8\u4e86\u672c\u5730 data \u5b58\u50a8\u4e00\u6837\uff0cDuckDB \u5229\u7528\u672c\u5730\u8ba1\u7b97\u673a\u7684\u539f\u59cb\u80fd\u529b\uff0c\u8ba9\u5206\u6790\u518d\u6b21\u53d8\u5f97\u7b80\u5355\u3002\u5b89\u88c5\u53ea\u9700\u51e0\u79d2\u949f\uff0c\u6ca1\u6709\u4efb\u4f55\u5916\u90e8\u4f9d\u8d56\u5173\u7cfb\uff0c\u7a81\u7136\u4e4b\u95f4\uff0c\u4f60\u5c31\u53ef\u4ee5\u5728\u6570\u5343\u5146\u5b57\u8282\u7684 data \u4e0a\u8fd0\u884c\u590d\u6742\u7684\u5206\u6790\u67e5\u8be2\uff0c\u800c\u65e0\u9700\u542f\u52a8\u4e00\u4e2a cloud \u5b9e\u4f8b\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">DuckDB \u6700\u5438\u5f15\u4eba\u7684\u5730\u65b9\u5728\u4e8e\u5b83\u80fd\u6ee1\u8db3\u5f00\u53d1\u4eba\u5458\u7684\u9700\u6c42\u3002\u9700\u8981\u5206\u6790 Python DataFrame \u5417\uff1fDuckDB \u53ef\u4ee5\u76f4\u63a5\u67e5\u8be2\u3002\u60f3\u8981\u538b\u7f29 CSV \u6587\u4ef6\uff1f\u6ca1\u95ee\u9898\u3002\u8fd9\u79cd\u65e0\u7f1d\u96c6\u6210\uff0c\u518d\u52a0\u4e0a\u5176\u5feb\u901f\u7684\u5217\u5f0f\u5f15\u64ce\uff0c\u4f7fDuckDB\u6210\u4e3a\u5206\u6790\u9886\u57df\u589e\u957f\u6700\u5feb\u7684database\u7cfb\u7edf\u4e4b\u4e00\u3002\u6027\u80fd\u7684\u5927\u5e45\u63d0\u5347\u5f80\u5f80\u8db3\u4ee5\u8ba9\u4f60\u6000\u7591\u5f53\u521d\u4e3a\u4ec0\u4e48\u8981\u4f7f\u7528\u5206\u5e03\u5f0f\u7cfb\u7edf\u3002\u5982\u679c\u60a8\u60f3\u6df1\u5165\u4e86\u89e3\u8fd9\u79cd\u65b9\u6cd5\u80cc\u540e\u7684\u6280\u672f\u7406\u5ff5\uff0c\u6211\u4eec\u5f3a\u70c8\u63a8\u8350\u60a8\u9605\u8bfb<\/span><a href=\"https:\/\/www.infoq.com\/articles\/analytical-data-management-duckdb\/\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">\u201c\u4f7f\u7528 DuckDB \u8fdb\u884c\u6d41\u7a0b\u5185\u5206\u6790 Data \u7ba1\u7406\u201d<\/span><\/a><span style=\"font-weight: 400;\"> \u7531 DuckDB \u7684\u8054\u5408\u521b\u5efa\u8005 Hannes M\u00fchleisen \u5236\u4f5c\u3002.<\/span><\/p>\n<h3><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015860 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck.png\" alt=\"\" width=\"1838\" height=\"1134\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271838%27%20height%3D%271134%27%20viewBox%3D%270%200%201838%201134%27%3E%3Crect%20width%3D%271838%27%20height%3D%271134%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-200x123.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-300x185.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-400x247.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-600x370.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-768x474.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-800x494.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-1024x632.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-1200x740.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck-1536x948.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Chart-MotherDuck.png 1838w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1838px) 100vw, 1838px\" \/><\/h3>\n<p><span style=\"font-weight: 400;\">\u65e2\u7136\u4f60\u5df2\u7ecf\u4e86\u89e3\u4e86\u4ec0\u4e48\u662f DuckDB\uff0c\u90a3\u6211\u4eec\u5c31\u6765\u8c08\u8c08\u5b83\u7684\u5c40\u9650\u6027\u3002\u6bcf\u79cd\u6280\u672f\u90fd\u6709\u5176\u5c40\u9650\u6027\u3002DuckDB \u53ea\u80fd\u5728\u4e00\u53f0\u673a\u5668\u4e0a\u8fd0\u884c\uff0c\u4e00\u6b21\u53ea\u80fd\u63a5\u53d7\u4e00\u4e2a\u8fde\u63a5\u3002\u5728 data \u56e2\u961f\u6784\u5efa\u670d\u52a1\u4e8e\u6574\u4e2a\u7ec4\u7ec7\u7684 cloud \u539f\u751f\u89e3\u51b3\u65b9\u6848\u7684\u4e16\u754c\u91cc\uff0c\u8fd9\u662f\u4e00\u4e2a\u76f8\u5f53\u5927\u7684\u9650\u5236\u3002\u4f60\u65e0\u6cd5\u8ba9\u591a\u4e2a\u5206\u6790\u5e08\u540c\u65f6\u67e5\u8be2\u540c\u4e00\u4e2a DuckDB \u5b9e\u4f8b\uff0c\u5f53\u7136\u4e5f\u65e0\u6cd5\u50cf\u4f20\u7edf data \u4ed3\u5e93\u90a3\u6837\u8de8\u56e2\u961f\u5171\u4eab data \u96c6\u3002\u867d\u7136 DuckDB \u901f\u5ea6\u5feb\u3001\u64cd\u4f5c\u7b80\u5355\uff0c\u4f46\u5b83\u57fa\u672c\u4e0a\u5c06 data \u9501\u5b9a\u5728\u4e00\u53f0\u673a\u5668\u4e0a\uff0c\u4e00\u6b21\u53ea\u80fd\u7531\u4e00\u4e2a\u4eba\u8bbf\u95ee\u3002\u90a3\u4e48\uff0c\u5982\u4f55\u5c06\u8fd9\u4e2a\u901f\u5ea6\u60ca\u4eba\u4f46\u672c\u8d28\u4e0a\u662f\u5355\u7528\u6237\u7684 database \u53d8\u6210\u4e00\u4e2a\u53ef\u4ee5\u4e3a\u6574\u4e2a\u7ec4\u7ec7\u670d\u52a1\u7684 cloud data \u4ed3\u5e93\u5462\uff1f<\/span><\/p>\n<h2><b>\u5b66\u4f1a\u98de\u7fd4\u7684\u9e2d\u5b50<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u8fd9\u5c31\u662f MotherDuck \u7684\u7528\u6b66\u4e4b\u5730\u3002MotherDuck \u662f\u4e00\u4e2a\u65e0\u670d\u52a1\u5668 data \u4ed3\u5e93\uff0c\u5b83\u5728 DuckDB \u7684\u539f\u59cb\u6027\u80fd\u4e0e\u73b0\u4ee3 data \u56e2\u961f\u7684\u534f\u4f5c\u9700\u6c42\u4e4b\u95f4\u67b6\u8d77\u4e86\u4e00\u5ea7\u6865\u6881\u3002MotherDuck \u521b\u5efa\u4e86\u4ed6\u4eec\u6240\u8c13\u7684 \u201c\u4e2a\u6027\u5316\u5206\u6790 data \u4ed3\u5e93\u201d\uff0c\u4e3a\u6bcf\u4e2a\u7528\u6237\u63d0\u4f9b\u81ea\u5df1\u7684\u9ad8\u6027\u80fd DuckDB \u5b9e\u4f8b\uff0c\u540c\u65f6\u4fdd\u6301\u5728\u6574\u4e2a\u7ec4\u7ec7\u5185\u5171\u4eab data \u7684\u80fd\u529b\u3002\u4ee5\u4e0b\u662f\u8be5\u67b6\u6784\u7684\u5de5\u4f5c\u539f\u7406\uff1a<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015861 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture.png\" alt=\"\" width=\"2346\" height=\"1040\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%272346%27%20height%3D%271040%27%20viewBox%3D%270%200%202346%201040%27%3E%3Crect%20width%3D%272346%27%20height%3D%271040%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-200x89.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-300x133.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-400x177.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-600x266.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-768x340.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-800x355.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-1024x454.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-1200x532.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture-1536x681.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Architecture.png 2346w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 2346px) 100vw, 2346px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u5728\u4f20\u7edf\u7684 cloud data \u4ed3\u5e93\u4e2d\uff0c\u7b14\u8bb0\u672c\u7535\u8111\u53ea\u662f\u4e00\u4e2a\u54d1\u7ec8\u7aef\u3002\u6240\u6709\u7e41\u91cd\u7684\u5de5\u4f5c\u90fd\u5728\u8fdc\u7a0b\u670d\u52a1\u5668\u4e0a\u8fdb\u884c\uff0c\u4f60\u9700\u8981\u6309\u5c0f\u65f6\u4ed8\u8d39\u3002\u4f46\u95ee\u9898\u662f\uff1a\u4f60\u7684 MacBook \u53ef\u80fd\u6bd4\u6bcf\u5c0f\u65f6 $20-60 \u7684 data \u4ed3\u5e93\u5b9e\u4f8b\u8fd8\u8981\u5feb\u3002MotherDuck \u5c1d\u8bd5\u901a\u8fc7\u4e24\u79cd\u521b\u65b0\u65b9\u6cd5\u6765\u5229\u7528\u8fd9\u79cd\u8ba1\u7b97\u80fd\u529b\uff1a\u00a0<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><strong>\u57fa\u4e8e\u6d4f\u89c8\u5668\u7684\u5206\u6790<\/strong> \u5c06\u8ba1\u7b97\u76f4\u63a5\u5e26\u7ed9\u7528\u6237\u3002.<\/li>\n<li aria-level=\"1\"><strong>\u53cc\u91cd\u6267\u884c<\/strong> \u5b83\u80fd\u667a\u80fd\u5730\u5c06\u672c\u5730\u673a\u5668\u7684\u5904\u7406\u80fd\u529b\u4e0e cloud \u8d44\u6e90\u76f8\u7ed3\u5408\uff0c\u4ee5\u6bd4\u4efb\u4f55\u4e00\u79cd\u65b9\u6cd5\u90fd\u66f4\u5feb\u7684\u901f\u5ea6\u63d0\u4f9b\u7ed3\u679c\u3002.<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u5728\u6df1\u5165\u63a2\u8ba8\u8fd9\u4e24\u79cd\u65b9\u6cd5\u4e4b\u524d\uff0c\u6211\u60f3\u8bf4\u7684\u662f\uff0c\u5982\u679c\u5c06 MotherDuck \u7684\u8ba1\u7b97\u80fd\u529b\u5e94\u7528\u4e8e\u4f60\u7684 <\/span><a href=\"https:\/\/www.databricks.com\/glossary\/medallion-architecture\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u91d1\u5c42<\/span><\/a><span style=\"font-weight: 400;\">. .\u5bf9\u4e8e\u4e0d\u719f\u6089\u8fd9\u4e2a\u672f\u8bed\u7684\u4eba\u6765\u8bf4\uff0c\u9ec4\u91d1\u5c42\u662f\u7ecf\u8fc7\u6e05\u7406\u3001\u805a\u5408\u548c\u4e30\u5bcc\u7684\u6700\u7ec8\u4e1a\u52a1\u5c31\u7eea data\u3002\u4ece\u672c\u8d28\u4e0a\u8bb2\uff0c\u7ecf\u8fc7\u6253\u78e8\u7684 data \u96c6\u4e3a\u60a8\u7684\u5206\u6790\u3001\u62a5\u544a\u548c\u673a\u5668\u5b66\u4e60\u63d0\u4f9b\u4e86\u52a8\u529b\u3002\u8fd9\u4e9b data \u9a71\u52a8\u7740\u60a8\u6700\u5173\u952e\u7684\u4e1a\u52a1\u51b3\u7b56\uff0c\u56e0\u6b64\u8fd9\u91cc\u7684\u6027\u80fd\u7edd\u5bf9\u81f3\u5173\u91cd\u8981\u3002\u6bcf\u4e2a\u5229\u76ca\u76f8\u5173\u8005\u90fd\u66fe\u5fcd\u53d7\u8fc7\u4ee4\u4eba\u75db\u82e6\u7684\u7f13\u6162\u4eea\u8868\u76d8\uff0c\u6bcf\u4e2a data \u56e2\u961f\u6210\u5458\u90fd\u66fe\u5728\u7b49\u5f85\u590d\u6742\u67e5\u8be2\u5b8c\u6210\u65f6\u76ef\u7740\u65cb\u8f6c\u7684\u6b7b\u4ea1\u4e4b\u8f6e\u3002MotherDuck \u80fd\u8fce\u5203\u800c\u89e3\u8fd9\u79cd\u56f0\u6270\u3002.<\/span><\/p>\n<h3>\u6d4f\u89c8\u5668\u5185\u5206\u6790<\/h3>\n<p><span style=\"font-weight: 400;\">\u8be5\u89e3\u51b3\u65b9\u6848\u5229\u7528 DuckDB \u7684\u8f7b\u91cf\u7ea7\u548c\u4fbf\u643a\u5f0f\u8bbe\u8ba1\uff0c\u4f7f\u5176\u80fd\u591f\u901a\u8fc7 WebAssembly (Wasm) \u76f4\u63a5\u5728\u6d4f\u89c8\u5668\u4e2d\u8fd0\u884c\u3002\u53ef\u4ee5\u628a Wasm \u770b\u4f5c\u662f\u4e00\u79cd\u8ba9\u590d\u6742\u8f6f\u4ef6\u5728\u6d4f\u89c8\u5668\u4e2d\u672c\u5730\u8fd0\u884c\u7684\u6280\u672f\uff1a\u65e0\u9700\u63d2\u4ef6\uff0c\u65e0\u9700\u4e0b\u8f7d\uff0c\u53ea\u9700\u5728\u6700\u9700\u8981\u7684\u5730\u65b9\u63d0\u4f9b\u8ba1\u7b97\u80fd\u529b\u3002\u6709\u4e86\u8fd0\u884c\u5728\u5ba2\u6237\u7aef\u7684 DuckDB\uff0c\u60a8\u5c31\u53ef\u4ee5\u6267\u884c\u590d\u6742\u7684\u5206\u6790\u67e5\u8be2\uff0c\u800c\u65e0\u9700\u50cf\u5f80\u5e38\u4e00\u6837\u5411\u670d\u52a1\u5668\u53d1\u9001\u8bf7\u6c42\u5e76\u7b49\u5f85\u54cd\u5e94\u3002data \u5904\u7406\u5c31\u5728\u6d4f\u89c8\u5668\u4e2d\u8fdb\u884c\uff0c\u6d88\u9664\u4e86\u7f51\u7edc\u5ef6\u8fdf\uff0c\u5b8c\u5168\u51cf\u5c11\u4e86\u5bf9\u57fa\u7840\u8bbe\u65bd\u7684\u4f9d\u8d56\u3002\u60a8\u53ef\u4ee5\u901a\u8fc7\u5c1d\u8bd5<\/span><a href=\"https:\/\/shell.duckdb.org\/\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">\u6d4f\u89c8\u5668\u4e2d\u7684 DuckDB<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u867d\u7136\u6211\u4eec\u4e0d\u4f1a\u5728\u8fd9\u91cc\u6df1\u5165\u63a2\u8ba8\u6280\u672f\u5b9e\u73b0\uff0c\u4f46\u503c\u5f97\u6ce8\u610f\u7684\u662f\uff0cDuckDB-Wasm \u975e\u5e38\u51fa\u8272\u3002\u7814\u7a76\u8be6\u89c1<\/span><a href=\"https:\/\/www.vldb.org\/pvldb\/vol15\/p3574-kohn.pdf\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">\u672c\u6587<\/span><\/a><span style=\"font-weight: 400;\"> \u5b83\u5927\u5927\u4f18\u4e8e\u73b0\u6709\u7684\u57fa\u4e8e\u6d4f\u89c8\u5668\u7684\u89e3\u51b3\u65b9\u6848\uff0c\u5982 SQLite \u7684 Wasm \u7248\u672c\u6216\u57fa\u4e8e JavaScript \u7684 database Lovefield\u3002\u8fd9\u4e00\u5de7\u5999\u7684\u6280\u672f\u6f14\u793a\u6807\u5fd7\u7740\u6211\u4eec\u5bf9\u5206\u6790\u8ba1\u7b97\u4f4d\u7f6e\u7684\u601d\u8003\u65b9\u5f0f\u53d1\u751f\u4e86\u6839\u672c\u6027\u8f6c\u53d8\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u6b63\u5982 Mehdi Ouazza \u5728\u300aMotherDuck\u300b\u4e00\u4e66\u4e2d\u89e3\u91ca\u7684\u90a3\u6837\uff0cMotherDuck \u63d0\u4f9b\u4e86\u8fd9\u79cd\u7531 Wasm \u9a71\u52a8\u7684\u67b6\u6784\u3002<\/span><a href=\"https:\/\/motherduck.com\/blog\/duckdb-wasm-in-browser\/\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">\u672c\u6761<\/span><\/a><span style=\"font-weight: 400;\">. .\u8fd9\u79cd\u65b9\u6cd5\u5c24\u5176\u9002\u7528\u4e8e\u9ec4\u91d1\u5c42\u5206\u6790\u3002\u60a8\u7684 data \u56e2\u961f\u53ef\u4ee5\u4f7f\u7528\u7b80\u6d01\u3001\u4e1a\u52a1\u5c31\u7eea\u7684 data\uff0c\u800c\u65e0\u9700\u62c5\u5fc3\u540e\u7aef\u57fa\u7840\u67b6\u6784\uff0c\u672c\u5730\u5904\u7406\u53ef\u5b9e\u73b0\u6700\u9ad8\u901f\u5ea6\uff0c\u800c\u4e14\u7531\u4e8e\u5b8c\u5168\u6d88\u9664\u4e86\u7f51\u7edc\u5ef6\u8fdf\uff0c\u60a8\u53ef\u4ee5\u83b7\u5f97\u6700\u5feb\u7684\u54cd\u5e94\u65f6\u95f4\u3002\u6b64\u5916\uff0c\u60a8\u8fd8\u53ef\u4ee5\u907f\u514d\u4f20\u7edf cloud data \u4ed3\u5e93\u5bf9\u6bcf\u6b21\u67e5\u8be2\u6536\u53d6\u7684\u9ad8\u989d\u8ba1\u7b97\u6210\u672c\u3002\u8fd9\u662f\u4e00\u4e2a\u4ee4\u4eba\u4fe1\u670d\u7684\u63d0\u8bae\uff1a\u66f4\u5feb\u7684\u5206\u6790\u901f\u5ea6\u3001\u66f4\u4f4e\u7684\u6210\u672c\u548c\u66f4\u7b80\u5355\u7684\u67b6\u6784\u96c6\u4e8e\u4e00\u8eab\u3002.<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015862 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture.png\" alt=\"\" width=\"2062\" height=\"1078\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%272062%27%20height%3D%271078%27%20viewBox%3D%270%200%202062%201078%27%3E%3Crect%20width%3D%272062%27%20height%3D%271078%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-200x105.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-300x157.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-400x209.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-600x314.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-768x402.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-800x418.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-1024x535.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-1200x627.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture-1536x803.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-WASM-Powered-1.5-tier-architecture.png 2062w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 2062px) 100vw, 2062px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>\u53cc\u91cd\u6267\u884c<\/h3>\n<p><span style=\"font-weight: 400;\">\u5728\u9ec4\u91d1\u5c42\u4e2d\u5229\u7528 MotherDuck \u7684\u53e6\u4e00\u79cd\u65b9\u6cd5\u662f\u901a\u8fc7\u5176\u53cc\u91cd\u6267\u884c\u80fd\u529b\uff0c\u5c06\u672c\u5730\u5904\u7406\u80fd\u529b\u4e0e cloud \u89c4\u6a21\u667a\u80fd\u5730\u7ed3\u5408\u8d77\u6765\u3002MotherDuck \u4e0d\u4f1a\u5f3a\u8feb\u4f60\u7684\u6574\u4e2a data \u56e2\u961f\u5171\u4eab\u76f8\u540c\u7684\u8ba1\u7b97\u8d44\u6e90\uff0c\u800c\u662f\u4e3a\u6bcf\u4e2a\u7528\u6237\u63d0\u4f9b\u81ea\u5df1\u7684 \u201c\u5c0f\u9e2d\u5b50\u201d\uff1a\u4e00\u4e2a\u72ec\u7acb\u7684\u3001\u65e0\u670d\u52a1\u5668\u7684\u8ba1\u7b97\u5b9e\u4f8b\uff0c\u53ef\u6839\u636e\u4ed6\u4eec\u7684\u9700\u6c42\u8fdb\u884c\u6269\u5c55\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u5728\u5904\u7406\u5206\u6563\u5728\u4e0d\u540c\u6570\u636e\u6e90\u4e2d\u7684 data \u65f6\uff0c\u53cc\u6267\u884c\u7684\u771f\u6b63\u5a01\u529b\u5c31\u4f1a\u663e\u73b0\u51fa\u6765\u3002\u60f3\u8c61\u4e00\u4e0b\uff0c\u60a8\u9700\u8981\u67e5\u8be2\u5b58\u50a8\u5728 MotherDuck \u4e2d\u7684 data\uff0c\u5c06\u5176\u4e0e S3 \u4e2d\u7684\u6587\u4ef6\u76f8\u7ed3\u5408\uff0c\u5e76\u4e0e\u672c\u5730\u7b14\u8bb0\u672c\u7535\u8111\u4e0a\u7684 dataset \u76f8\u7ed3\u5408\u3002\u4f20\u7edf\u7684 cloud \u7cfb\u7edf\u4f1a\u8feb\u4f7f\u4f60\u5728\u8fd0\u884c\u8de8\u6e90\u67e5\u8be2\u524d\u5c06\u6240\u6709\u5185\u5bb9\u4e0a\u4f20\u5230\u4e00\u4e2a\u5730\u65b9\u3002MotherDuck \u7684\u6df7\u5408\u6267\u884c\u66f4\u667a\u80fd\u3002\u5b83\u4f1a\u5206\u6790\u4f60\u7684\u67e5\u8be2\uff0c\u53ea\u4fdd\u7559\u6bcf\u4e2a\u6e90\u7684\u5fc5\u8981 data\uff0c\u5e76\u6267\u884c\u8de8\u4f4d\u7f6e\u7684\u667a\u80fd\u8fde\u63a5\uff0c\u4e3a\u4f60\u8282\u7701\u65f6\u95f4\u548c data \u4f20\u8f93\u6210\u672c\u3002.<\/span><\/p>\n<h2><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015863 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution.png\" alt=\"\" width=\"2418\" height=\"1052\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%272418%27%20height%3D%271052%27%20viewBox%3D%270%200%202418%201052%27%3E%3Crect%20width%3D%272418%27%20height%3D%271052%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-200x87.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-300x131.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-400x174.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-600x261.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-768x334.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-800x348.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-1024x446.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-1200x522.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution-1536x668.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Dualhybrid-query-execution.png 2418w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 2418px) 100vw, 2418px\" \/><\/h2>\n<p>\u5728\u5f15\u64ce\u76d6\u4e0b\uff0cMotherDuck \u7684\u4f18\u5316\u5668\u4f1a\u5c06\u4f60\u7684\u67e5\u8be2\u5206\u89e3\u6210\u4e00\u4e2a DAG\uff08\u6709\u5411\u65e0\u73af\u56fe\uff09\u64cd\u4f5c\uff0c\u4f30\u7b97\u672c\u5730\u4e0e\u8fdc\u7a0b\u8fd0\u884c\u6bcf\u4e2a\u8282\u70b9\u7684\u6210\u672c\uff0c\u5e76\u81ea\u52a8\u5904\u7406 data \u79fb\u52a8\u3002\u4f60\u53ea\u9700\u7f16\u5199 SQL\uff0cMotherDuck \u5c31\u80fd\u627e\u51fa\u6700\u4f73\u6267\u884c\u7b56\u7565\u3002\u8fd9\u79cd\u65b9\u6cd5\u4ece\u6839\u672c\u4e0a\u91cd\u65b0\u5b9a\u4e49\u4e86 cloud \u5206\u6790\u3002\u6211\u4eec\u4e0d\u518d\u9700\u8981\u5728\u672c\u5730\u7b80\u6613\u6027\u548c cloud \u53ef\u6269\u5c55\u6027\u4e4b\u95f4\u505a\u51fa\u9009\u62e9\uff0c\u56e0\u4e3a\u4e8c\u8005\u5728 data \u5171\u4eab\u548c\u5de5\u4f5c\u6d41\u534f\u8c03\u65b9\u9762\u90fd\u6709\u5404\u81ea\u7684\u590d\u6742\u6027\u3002\u6709\u4e86 MotherDuck\uff0c\u60a8\u5c31\u80fd\u4e24\u5168\u5176\u7f8e\uff1a\u5f53\u60a8\u7684\u673a\u5668\u80fd\u591f\u5904\u7406\u65f6\u5728\u672c\u5730\u8fd0\u884c\uff0c\u9700\u8981\u65f6\u6269\u5c55\u5230 cloud\uff0c\u5e76\u5728\u6574\u4e2a\u8fc7\u7a0b\u4e2d\u6beb\u4e0d\u8d39\u529b\u5730\u5171\u4eab\u3002\u8fd9\u662f\u4e00\u79cd\u65e0\u670d\u52a1\u5668\u89e3\u51b3\u65b9\u6848\uff0c\u53ef\u964d\u4f4e cloud \u8ba1\u7b97\u6210\u672c\uff0c\u56e0\u4e3a\u60a8\u53ea\u9700\u4e3a\u5b9e\u9645\u8ba1\u7b97\u4ed8\u8d39\u3002.<\/p>\n<p>\u4f46\u6709\u8da3\u7684\u5730\u65b9\u5728\u4e8e\uff1a\u5171\u4eab data \u53d8\u5f97\u6beb\u4e0d\u8d39\u529b\u3002\u8fd8\u8bb0\u5f97 DuckDB \u7684\u5355\u7528\u6237\u7279\u6027\u7ed9\u534f\u4f5c\u5e26\u6765\u7684\u75db\u82e6\u5417\uff1f\u5982\u679c data \u7684\u5206\u6790\u5e08\u521b\u5efa\u4e86\u4e00\u4e2a\u4ee4\u4eba\u60ca\u53f9\u7684\u5206\u6790\uff0c\u4ed6\u4eec\u5fc5\u987b\u5bfc\u51fa\u6240\u6709\u5185\u5bb9\u5e76\u4e0a\u4f20\u5230\u5171\u4eab\u5b58\u50a8\u7cfb\u7edf\uff0c\u624d\u80fd\u8ba9\u961f\u53cb\u8bbf\u95ee\u3002\u6709\u4e86 MotherDuck\uff0c\u5171\u4eab\u53ea\u9700\u70b9\u51fb\u4e00\u4e2a\u6309\u94ae\u6216\u8fd0\u884c\u4e00\u884c\u4ee3\u7801\uff0c\u5c31\u80fd\u521b\u5efa\u4e00\u4e2a\u5177\u6709\u9002\u5f53\u8bbf\u95ee\u63a7\u5236\u7684\u96f6\u62f7\u8d1d\u5feb\u7167\u3002\u65e0\u9700\u79fb\u52a8 data\uff0c\u65e0\u9700\u590d\u5236\u5b58\u50a8\uff0c\u53ea\u9700\u5373\u65f6\u534f\u4f5c\u3002.<\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015864 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud.png\" alt=\"\" width=\"2038\" height=\"1186\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%272038%27%20height%3D%271186%27%20viewBox%3D%270%200%202038%201186%27%3E%3Crect%20width%3D%272038%27%20height%3D%271186%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-200x116.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-300x175.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-400x233.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-600x349.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-768x447.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-800x466.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-1024x596.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-1200x698.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud-1536x894.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Architecture-Managed-DuckDB-in-the-cloud.png 2038w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 2038px) 100vw, 2038px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u4ece MotherDuck \u7684\u8bba\u6587\u4e2d\u4e86\u89e3\u6709\u5173\u53cc\u91cd\/\u6df7\u5408\u67e5\u8be2\u6267\u884c\u7684\u66f4\u591a\u4fe1\u606f\u3002 <\/span><a href=\"https:\/\/www.cidrdb.org\/cidr2024\/papers\/p46-atwal.pdf\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u521b\u65b0 Data \u7cfb\u7edf\u7814\u7a76\u4f1a\u8bae\uff08CIDR\uff09<\/span><\/a><span style=\"font-weight: 400;\">. .\u60a8\u8fd8\u53ef\u4ee5\u89c2\u770b <\/span><a href=\"https:\/\/www.youtube.com\/watch?v=KZi2pDJYgeY\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">dbt \u51dd\u805a\u8c08\u8bdd<\/span><\/a><span style=\"font-weight: 400;\"> \u7531 MotherDuck \u8054\u5408\u521b\u59cb\u4eba\u517c\u9996\u5e2d\u6267\u884c\u5b98 Jordan Tigani \u64b0\u5199\u3002.<\/span><\/p>\n<h2>\u91ce\u5916\u7684\u9e2d\u5b50<\/h2>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u5df2\u7ecf\u770b\u5230 MotherDuck \u5982\u4f55\u4e3a data \u56e2\u961f\u51cf\u5c11\u5927\u91cf\u5f00\u9500\uff0c\u540c\u65f6\u4e3a\u9ec4\u91d1\u5c42\u63d0\u4f9b\u5f3a\u5927\u7684\u5206\u6790\u529f\u80fd\u3002\u4f46\u7406\u8bba\u53ea\u80fd\u5230\u6b64\u4e3a\u6b62\u3002\u6211\u4eec\u60f3\u8ba9 MotherDuck \u4e0e cloud data \u4ed3\u5e93\u9886\u57df\u7684\u8001\u724c\u4f01\u4e1a\u8fdb\u884c\u6d4b\u8bd5\u3002\u770b\u770b<\/span><a href=\"https:\/\/www.metabase.com\/data-stack-report-2025\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">2025 \u5e74 Data \u5806\u6808\u62a5\u544a<\/span><\/a><span style=\"font-weight: 400;\"> \u6211\u4eec\u53d1\u73b0\u4e86\u4e00\u4e9b\u4ee4\u4eba\u60ca\u8bb6\u7684\u73b0\u8c61\uff1a\u5728\u63a5\u53d7\u8c03\u67e5\u7684\u516c\u53f8\u4e2d\uff0cPostgreSQL \u4ecd\u7136\u662f\u6700\u53d7\u6b22\u8fce\u7684 database \u9009\u62e9\uff0c\u5373\u4f7f\u5bf9\u4e8e\u5206\u6790\u5de5\u4f5c\u8d1f\u8f7d\u4e5f\u662f\u5982\u6b64\uff0c\u5176\u6b21\u662f Snowflake \u548c BigQuery\u3002\u8fd9\u4e3a\u6211\u4eec\u63d0\u4f9b\u4e86\u6bd4\u8f83\u76ee\u6807\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u51b3\u5b9a\u5c06 MotherDuck \u4e0e\u6258\u7ba1\u5728 Google Cloud \u4e0a\u7684 PostgreSQL \u548c BigQuery \u8fdb\u884c\u6bd4\u8f83\uff0c\u4f7f\u7528\u4e86 <\/span><a href=\"https:\/\/superset.apache.org\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u963f\u5e15\u5947\u8d85\u7ea7\u96c6<\/span><\/a><span style=\"font-weight: 400;\"> \u4f5c\u4e3a\u6211\u4eec\u9996\u9009\u7684\u5546\u4e1a\u667a\u80fd\u5de5\u5177\u3002Superset\u4e4b\u6240\u4ee5\u6709\u610f\u4e49\u6709\u51e0\u4e2a\u539f\u56e0\uff1a\u5b83\u662f\u5f00\u6e90\u7684\uff0c\u88ab\u5e7f\u6cdb\u91c7\u7528\uff0c\u800c\u4e14\u4e0e\u5927\u591a\u6570\u5176\u4ed6\u4e3b\u8981\u7684 database \u517c\u5bb9\u3002\u6211\u4eec\u7684\u6d4b\u8bd5\u73af\u5883\u5305\u62ec\u90e8\u7f72\u5728\u8c37\u6b4c\u4e91 Kubernetes \u5f15\u64ce\u4e0a\u7684 Apache Superset\uff0c\u5e76\u8fde\u63a5\u5230\u4e09\u4e2a\u4e0d\u540c\u7684\u540e\u7aef\uff1aBigQuery\u3001\u4e91 SQL \u4e0a\u7684 PostgreSQL \u548c MotherDuck\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u7684\u6d4b\u8bd5\u5206\u4e3a\u4e24\u4e2a\u9636\u6bb5\u3002\u9996\u5148\uff0c\u6211\u4eec\u8fd0\u884c\u4e86 TPC-H \u57fa\u51c6\uff1a\u8fd9\u662f\u4e00\u4e2a\u6807\u51c6\u5316\u7684\u51b3\u7b56\u652f\u6301\u57fa\u51c6\uff0c\u53ef\u4ee5\u5411\u6211\u4eec\u5c55\u793a MotherDuck \u5728\u53ef\u63a7\u7684\u7406\u8bba\u73af\u5883\u4e2d\u7684\u8868\u73b0\u3002\u7136\u540e\uff0c\u6211\u4eec\u5411\u73b0\u5b9e\u9760\u62e2\uff0c\u6d4b\u8bd5 Superset \u548c MotherDuck \u4e0e\u4f20\u7edf data \u4ed3\u5e93\u5728\u771f\u5b9e\u4eea\u8868\u76d8\u5e94\u7528\u573a\u666f\u4e2d\u7684\u5173\u7cfb\u3002.<\/span><\/p>\n<h3>TPC-H \u57fa\u51c6\u6d4b\u8bd5<\/h3>\n<p><span style=\"font-weight: 400;\">TPC-H \u662f\u6d4b\u8bd5\u5206\u6790 database \u6027\u80fd\u7684\u6807\u51c6\u3002\u5b83\u662f\u4e00\u79cd\u51b3\u7b56\u652f\u6301\u57fa\u51c6\uff0c\u65e8\u5728\u68c0\u67e5\u5927\u91cf data\u3001\u6267\u884c\u590d\u6742\u67e5\u8be2\u5e76\u4e3a\u4e0d\u540c\u884c\u4e1a\u7684\u5173\u952e\u4e1a\u52a1\u95ee\u9898\u63d0\u4f9b\u7b54\u6848\u3002\u60a8\u53ef\u4ee5\u5728<\/span><a href=\"https:\/\/www.tpc.org\/TPC_Documents_Current_Versions\/pdf\/TPC-H_v3.0.1.pdf\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">\u5b98\u65b9\u6587\u4ef6<\/span><\/a><span style=\"font-weight: 400;\">. .\u8be5\u57fa\u51c6\u7531 22 \u4e2a\u67e5\u8be2\u7ec4\u6210\uff0c\u6a21\u62df\u771f\u5b9e\u4e16\u754c\u7684\u5206\u6790\u5de5\u4f5c\u8d1f\u8f7d\uff0c\u4ece\u7b80\u5355\u7684\u805a\u5408\u5230\u590d\u6742\u7684\u591a\u8868\u8fde\u63a5\u3002.<\/span><\/p>\n<p><b>\u6211\u4eec\u901a\u8fc7 Superset \u7684 SQL Lab \u5bf9\u6240\u6709\u4e09\u4e2a database \u5206\u522b\u8fd0\u884c\u4e86\u6bcf\u4e2a\u67e5\u8be2\uff1aMotherDuck\u3001BigQuery \u548c PostgreSQL<\/b><span style=\"font-weight: 400;\">. .\u6211\u4eec\u8fd8\u76f4\u63a5\u5728 MotherDuck \u7684\u56fe\u5f62\u7528\u6237\u754c\u9762\u4e0a\u6d4b\u8bd5\u4e86\u67e5\u8be2\uff0c\u4ee5\u6d88\u9664\u5ba2\u6237\u7aef\u4e0e\u670d\u52a1\u5668\u4e4b\u95f4\u7684\u5ef6\u8fdf\uff0c\u800c\u4e14\u5766\u7387\u5730\u8bf4\uff0c\u4efb\u4f55\u4f7f\u7528 MotherDuck \u7684\u516c\u53f8\u90fd\u53ef\u80fd\u8ba9\u4ed6\u4eec\u7684 data \u5206\u6790\u5e08\u5728 MotherDuck \u53d7\u7b14\u8bb0\u672c\u542f\u53d1\u800c\u8bbe\u8ba1\u7684\u754c\u9762\u4e0a\u5de5\u4f5c\uff0c\u800c\u4e0d\u662f\u5728 Superset \u7684 SQL Lab \u4e0a\u5de5\u4f5c\u3002\u6b64\u5916\uff0cMotherDuck \u7684\u5e94\u7528\u7a0b\u5e8f\u53ef\u4ee5\u5229\u7528\u6211\u4eec\u4e4b\u524d\u8ba8\u8bba\u8fc7\u7684 WebAssembly \u67b6\u6784\uff0c\u6211\u4eec\u5f88\u60f3\u77e5\u9053\u8fd9\u79cd\u57fa\u4e8e\u6d4f\u89c8\u5668\u7684\u6267\u884c\u65b9\u5f0f\u4e0e\u4f20\u7edf\u7684\u670d\u52a1\u5668-\u5ba2\u6237\u7aef\u6a21\u5f0f\u76f8\u6bd4\u4f1a\u6709\u600e\u6837\u7684\u8868\u73b0\u3002\u4e3a\u4e86\u786e\u4fdd\u6d4b\u8bd5\u7684\u516c\u5e73\u6027\uff0cSuperset \u7684\u7f13\u5b58\u5728\u6240\u6709\u57fa\u51c6\u6d4b\u8bd5\u4e2d\u90fd\u88ab\u7981\u7528\u3002.<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015865 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI.png\" alt=\"\" width=\"2470\" height=\"1268\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%272470%27%20height%3D%271268%27%20viewBox%3D%270%200%202470%201268%27%3E%3Crect%20width%3D%272470%27%20height%3D%271268%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-200x103.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-300x154.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-400x205.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-600x308.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-768x394.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-800x411.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-1024x526.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-1200x616.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI-1536x789.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Web-GUI.png 2470w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 2470px) 100vw, 2470px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u5728\u6b64\u57fa\u51c6\u6d4b\u8bd5\u4e2d\uff0c\u6211\u4eec\u4f7f\u7528\u4e86 TPC-H \u89c4\u6a21\u56e0\u5b50 10 (SF-10)\uff0c\u5b83\u53ef\u751f\u6210 10GB \u7684 dataset\u3002\u6211\u4eec\u4e4b\u6240\u4ee5\u9009\u62e9\u89c4\u6a21\u56e0\u5b50 10\uff0c\u662f\u56e0\u4e3a 10GB \u4ee3\u8868\u4e86\u5927\u591a\u6570\u516c\u53f8\u5206\u6790\u5de5\u4f5c\u8d1f\u8f7d\u7684 dataset \u5b9e\u9645\u5927\u5c0f\uff0c\u8db3\u4ee5\u663e\u793a\u6709\u610f\u4e49\u7684\u6027\u80fd\u5dee\u5f02\uff0c\u800c\u65e0\u9700\u4f01\u4e1a\u7ea7\u57fa\u7840\u8bbe\u65bd\u3002\u4ee5\u4e0b\u662f data \u5728\u5173\u952e\u8868\u4e2d\u7684\u5206\u89e3\u60c5\u51b5\uff1a<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015866 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables.png\" alt=\"\" width=\"1468\" height=\"1106\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271468%27%20height%3D%271106%27%20viewBox%3D%270%200%201468%201106%27%3E%3Crect%20width%3D%271468%27%20height%3D%271106%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-200x151.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-300x226.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-400x301.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-600x452.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-768x579.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-800x603.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-1024x771.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables-1200x904.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/MotherDuck-Tables.png 1468w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1468px) 100vw, 1468px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u4f7f\u7528 DuckDB TPC-H \u6269\u5c55\u5728\u672c\u5730\u751f\u6210 data\uff0c\u7136\u540e\u65e0\u7f1d\u4e0a\u4f20\u5230 MotherDuck\u3002\u5f97\u76ca\u4e8e MotherDuck \u7684 data \u52a0\u8f7d\u529f\u80fd\uff0c\u6574\u4e2a\u8fc7\u7a0b\u53ea\u7528\u4e86\u51e0\u5206\u949f\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u4ee5\u4e0b\u662f\u4ee5\u79d2\u4e3a\u5355\u4f4d\u7684 TPC-H SF-10 \u7ed3\u679c\u3002\u9ec4\u8272\u5217\u663e\u793a\u7684\u662f MotherDuck \u5e94\u7528\u7a0b\u5e8f\u672c\u673a\u7528\u6237\u754c\u9762\u7684\u7ed3\u679c\uff0c\u5176\u4ed6\u5217\u663e\u793a\u7684\u662f\u901a\u8fc7 Superset (SST) SQL \u5b9e\u9a8c\u5ba4\u83b7\u5f97\u7684\u6027\u80fd\uff1a<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015867 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD.png\" alt=\"\" width=\"1446\" height=\"1366\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271446%27%20height%3D%271366%27%20viewBox%3D%270%200%201446%201366%27%3E%3Crect%20width%3D%271446%27%20height%3D%271366%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-200x189.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-300x283.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-400x378.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-600x567.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-768x726.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-800x756.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-1024x967.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD-1200x1134.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Results-for-the-22-queries-in-seconds-MD.png 1446w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1446px) 100vw, 1446px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">MotherDuck \u59cb\u7ec8\u5982\u4e00\u5730\u5168\u9762\u63d0\u4f9b\u4e9a\u79d2\u7ea7\u6027\u80fd\uff1a <\/span><b>\u901a\u8fc7\u8d85\u7ea7\u96c6\u8fdb\u884c\u7684 22 \u6b21\u67e5\u8be2\u4e2d\u6709 21 \u6b21\u5728\u4e00\u79d2\u5185\u5b8c\u6210<\/b><span style=\"font-weight: 400;\">, \u5728\u76f4\u63a5\u901a\u8fc7 MotherDuck \u5e94\u7528\u7a0b\u5e8f\u8fd0\u884c\u65f6\uff0c\u6240\u6709\u67e5\u8be2\u90fd\u80fd\u5728\u4e9a\u79d2\u7ea7\u5b8c\u6210\u3002BigQuery \u663e\u793a\u4e86\u53ef\u89c2\u7684\u6027\u80fd\uff0c\u4f46\u5e73\u5747 <\/span><b>\u5927\u7ea6\u6bd4 MotherDuck \u6162 4 \u500d <\/b><span style=\"font-weight: 400;\">\u5728\u6574\u4e2a\u57fa\u51c6\u6d4b\u8bd5\u5957\u4ef6\u4e2d\u90fd\u662f\u5982\u6b64\u3002PostgreSQL \u7684\u60c5\u51b5\u5219\u5b8c\u5168\u4e0d\u540c\uff0c\u5176\u6027\u80fd\u660e\u663e\u8f83\u6162\uff0c\u5728\u590d\u6742\u7684\u805a\u5408\u548c\u8fde\u63a5\u65b9\u9762\u660e\u663e\u5403\u529b\u3002\u8fd9\u662f\u53ef\u4ee5\u9884\u6599\u5230\u7684\uff0c\u56e0\u4e3a PostgreSQL \u4ece\u6839\u672c\u4e0a\u8bf4\u662f\u4e3a OLTP \u5de5\u4f5c\u8d1f\u8f7d\u800c\u8bbe\u8ba1\u7684\uff0c\u800c\u4e0d\u662f\u4e3a\u5206\u6790\u5904\u7406\u800c\u8bbe\u8ba1\u7684\uff0c\u4f46\u6211\u4eec\u8fd8\u662f\u5c06\u5176\u7eb3\u5165\u4e86\u6bd4\u8f83\u8303\u56f4\uff0c\u56e0\u4e3a\u5b83\u4ecd\u7136\u88ab\u516c\u53f8\u5e7f\u6cdb\u7528\u4e8e\u5206\u6790\u4efb\u52a1\u3002\u503c\u5f97\u6ce8\u610f\u7684\u662f\uff0c\u5982\u679c\u91c7\u7528\u9002\u5f53\u7684\u4f18\u5316\u6280\u672f\uff08\u5982\u7d22\u5f15\u3001\u5206\u533a\u6216\u7269\u5316\u89c6\u56fe\uff09\uff0cPostgreSQL \u53ef\u4ee5\u83b7\u5f97\u66f4\u597d\u7684\u6027\u80fd\uff0c\u4f46\u5373\u4fbf\u5982\u6b64\uff0cPostgreSQL \u4ecd\u7136\u8981\u4e0e\u5b83\u57fa\u4e8e\u884c\u7684\u67b6\u6784\u4f5c\u6597\u4e89\u3002\u6027\u80fd\u4e0a\u7684\u5dee\u8ddd\u6070\u6070\u51f8\u663e\u4e86\u50cf MotherDuck \u8fd9\u6837\u7684\u4e13\u7528 OLAP \u7cfb\u7edf\u5b58\u5728\u7684\u539f\u56e0\uff1a\u5728\u5927\u91cf datasets \u4e0a\u8fd0\u884c\u590d\u6742\u7684\u5206\u6790\u67e5\u8be2\u65f6\uff0c\u67b6\u6784\u975e\u5e38\u91cd\u8981\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u867d\u7136 TPC-H \u663e\u793a\u7684\u662f\u539f\u59cb\u67e5\u8be2\u6027\u80fd\uff0c\u4f46\u771f\u6b63\u7684\u6d4b\u8bd5\u662f\u5982\u4f55\u5c06\u5176\u8f6c\u5316\u4e3a\u5546\u4e1a\u667a\u80fd\u5de5\u5177\u4e2d\u7684\u5b9e\u9645\u7528\u6237\u4f53\u9a8c\u3002.<\/span><\/p>\n<h3>\u4eea\u8868\u677f\u6027\u80fd<\/h3>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u770b\u5230\uff0c\u5728 data \u4ed3\u5e93\u4e2d\u4f7f\u7528 SQL \u7684 data \u5206\u6790\u5e08\u7684\u6027\u80fd\u975e\u5e38\u51fa\u8272\uff0c\u4f46\u6211\u4eec\u60f3\u6d4b\u8bd5\u8fd9\u79cd\u6539\u8fdb\u662f\u5426\u4f1a\u8f6c\u5316\u4e3a\u4eea\u8868\u76d8\uff0c\u56e0\u4e3a\u4e1a\u52a1\u5229\u76ca\u76f8\u5173\u8005\u5b9e\u9645\u4e0a\u662f\u5728\u4e0e data \u8fdb\u884c\u4ea4\u4e92\u3002\u6bd5\u7adf\uff0c\u5982\u679c\u60a8\u7684\u4eea\u8868\u76d8\u4ecd\u7136\u9700\u8981\u5f88\u957f\u65f6\u95f4\u624d\u80fd\u52a0\u8f7d\uff0c\u90a3\u4e48\u901f\u5ea6\u6781\u5feb\u7684 SQL \u67e5\u8be2\u4e5f\u5c31\u6ca1\u6709\u591a\u5927\u610f\u4e49\u4e86\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u4e3a\u4e86\u6d4b\u8bd5\u8fd9\u4e00\u70b9\uff0c\u6211\u4eec\u4f7f\u7528\u4e86\u6765\u81ea\u4e8e<\/span><a href=\"https:\/\/www.kaggle.com\/datasets\/mkechinov\/ecommerce-behavior-data-from-multi-category-store\/data\" target=\"_blank\" rel=\"noopener\"> <span style=\"font-weight: 400;\">Kaggle<\/span><\/a><span style=\"font-weight: 400;\"> \u5728 9GB \u7684 data \u4e2d\u5305\u542b 6,750 \u4e07\u884c\uff0c\u8fd9\u662f\u8bb8\u591a\u516c\u53f8\u6bcf\u6708\u8fdb\u884c\u5ba2\u6237\u5206\u6790\u7684\u89c4\u6a21\u3002\u5229\u7528\u8fd9\u4e2a\u5355\u4e00\u8868\u683c\uff0c\u6211\u4eec\u5efa\u7acb\u4e86\u4e00\u4e2a\u7efc\u5408\u4eea\u8868\u76d8\uff0c\u5bf9\u6bcf\u4e2a\u7cfb\u7edf\u5904\u7406\u5b9e\u9645\u5546\u4e1a\u667a\u80fd\u5de5\u4f5c\u8d1f\u8f7d\u7684\u80fd\u529b\u8fdb\u884c\u538b\u529b\u6d4b\u8bd5\uff1a<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015868 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard.png\" alt=\"\" width=\"2342\" height=\"1128\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%272342%27%20height%3D%271128%27%20viewBox%3D%270%200%202342%201128%27%3E%3Crect%20width%3D%272342%27%20height%3D%271128%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-200x96.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-300x144.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-400x193.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-600x289.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-768x370.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-800x385.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-1024x493.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-1200x578.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard-1536x740.png 1536w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Superset-dashboard.png 2342w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 2342px) 100vw, 2342px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u5728\u591a\u6b21\u8fd0\u884c\u4e2d\u5bf9\u4eea\u8868\u76d8\u8fdb\u884c\u4e86\u5e7f\u6cdb\u6d4b\u8bd5\uff0c\u5e94\u7528\u4e86\u5404\u79cd\u8fc7\u6ee4\u5668\uff0c\u6d4b\u91cf\u4e86\u52a0\u8f7d\u65f6\u95f4\uff0c\u7981\u7528\u4e86\u7f13\u5b58\uff0c\u5e76\u901a\u8fc7\u6d4f\u89c8\u5668\u7684\u5f00\u53d1\u5de5\u5177\u76d1\u63a7\u4e86\u54cd\u5e94\u65f6\u95f4\u3002\u7ecf\u8fc7\u591a\u4e2a\u6d4b\u8bd5\u5468\u671f\u4ee5\u786e\u4fdd\u7ed3\u679c\u4e00\u81f4\u540e\uff0c\u4ee5\u4e0b\u662f\u4ee5\u79d2\u4e3a\u5355\u4f4d\u7684\u4eea\u8868\u76d8\u6027\u80fd\u6307\u6807\uff1a<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1015869 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD.png\" alt=\"\" width=\"1080\" height=\"256\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271080%27%20height%3D%27256%27%20viewBox%3D%270%200%201080%20256%27%3E%3Crect%20width%3D%271080%27%20height%3D%27256%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-200x47.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-300x71.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-400x95.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-600x142.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-768x182.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-800x190.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD-1024x243.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Loading-results-MD.png 1080w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1080px) 100vw, 1080px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u7684\u4eea\u8868\u76d8\u52a0\u8f7d\u6d4b\u8bd5\u63ed\u793a\u4e86 database \u6027\u80fd\u5bf9\u7528\u6237\u4f53\u9a8c\u7684\u5b9e\u9645\u5f71\u54cd\u3002MotherDuck \u63d0\u4f9b\u4e86\u5353\u8d8a\u7684\u4eea\u8868\u76d8\u54cd\u5e94\u80fd\u529b\uff0c\u5e73\u5747\u52a0\u8f7d\u65f6\u95f4\u4ec5\u4e3a 3.35 \u79d2\uff0c\u5b9e\u73b0\u4e86\u771f\u6b63\u7684\u4ea4\u4e92\u5f0f\u5206\u6790\uff0c\u7528\u6237\u53ef\u4ee5\u6d41\u7545\u5730\u63a2\u7d22 data\uff0c\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6469\u64e6\u3002\u76f8\u6bd4\u4e4b\u4e0b\uff0cBigQuery \u52a0\u8f7d\u76f8\u540c\u7684\u4eea\u8868\u76d8\u9700\u8981 8.55 \u79d2\u3002\u5bf9\u4e8e\u8ba1\u5212\u62a5\u544a\u6765\u8bf4\uff0c\u8fd9\u4ecd\u7136\u662f\u53ef\u4ee5\u63a5\u53d7\u7684\uff0c\u4f46\u4f1a\u9020\u6210\u660e\u663e\u7684\u5ef6\u8fdf\uff0c\u4ece\u800c\u963b\u788d\u63a2\u7d22\u6027\u5206\u6790\u3002PostgreSQL \u7684\u52a0\u8f7d\u65f6\u95f4\u4e3a 216 \u79d2\uff08\u8d85\u8fc7 3 \u5206\u949f\uff09\uff0c\u56e0\u6b64\u5b8c\u5168\u4e0d\u9002\u5408\u7528\u4e8e\u4eea\u8868\u76d8\u3002MotherDuck \u7684\u8fd9\u4e00\u6027\u80fd\u4f18\u52bf\u4ece\u6839\u672c\u4e0a\u6539\u53d8\u4e86\u4f01\u4e1a\u7528\u6237\u4e0e data \u7684\u4ea4\u4e92\u65b9\u5f0f\u3002\u5f53\u4eea\u8868\u76d8\u5728\u6570\u79d2\u800c\u4e0d\u662f\u6570\u5206\u949f\u5185\u52a0\u8f7d\u5b8c\u6bd5\u65f6\uff0c\u7528\u6237\u91c7\u7528\u7387\u5c31\u4f1a\u6fc0\u589e\uff0c\u5206\u6790\u5e08\u5c31\u80fd\u5feb\u901f\u8fed\u4ee3\u6d1e\u5bdf\u529b\uff0c\u5206\u6790\u5c31\u4f1a\u6210\u4e3a\u4e00\u79cd\u7ade\u4e89\u4f18\u52bf\u800c\u4e0d\u662f\u74f6\u9888\u3002.<\/span><\/p>\n<h3>\u4ef7\u683c\u6bd4\u8f83<\/h3>\n<p><span style=\"font-weight: 400;\">MotherDuck \u5c06\u5b58\u50a8\u4e0e <\/span><a href=\"https:\/\/motherduck.com\/product\/pricing\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">\u73b0\u6536\u73b0\u4ed8<\/span><\/a><span style=\"font-weight: 400;\"> \u8ba1\u7b97\uff0c\u5e76\u9488\u5bf9\u4ea4\u4e92\u5f0f\u5206\u6790\u8fdb\u884c\u4e86\u4f18\u5316\u3002\u7531\u4e8e\u5b83\u5728\u5355\u53f0\u673a\u5668\u4e0a\u8fdb\u884c\u6269\u5c55\uff0c\u800c\u4e0d\u662f\u5206\u5e03\u5728\u96c6\u7fa4\u4e2d\uff0c\u56e0\u6b64\u907f\u514d\u4e86\u7528\u6237\u6700\u7ec8\u8981\u4ed8\u8d39\u7684\u5f00\u9500\u3002\u4e00\u6b21\u6570\u5341\u6b21\u7684\u67e5\u8be2\u53ef\u80fd\u53ea\u9700\u82b1\u8d39 $0.05-$0.10\uff0c\u800c\u6bcf\u6708\u8fd0\u884c\u6570\u5343\u6b21\u67e5\u8be2\u7684\u56e2\u961f\u53ef\u80fd\u53ea\u9700\u82b1\u8d39 $20-$40\u3002\u76f8\u6bd4\u4e4b\u4e0b\uff0c\u59cb\u7ec8\u5728\u7ebf\u7684 data \u6570\u636e\u5e93\u4ec5\u7ef4\u6301\u6b63\u5e38\u8fd0\u884c\u7684\u8d39\u7528\u5c31\u9ad8\u8fbe $300-$500\/\u6708\uff0c\u800c cloud \u7684\u4ed3\u5e93\u901a\u5e38\u6bcf\u626b\u63cf\u4e00\u4e2a TB \u9700\u8981\u82b1\u8d39 $5-$10\u3002MotherDuck \u91c7\u7528\u6269\u5c55\u8bbe\u8ba1\uff0c\u5b9a\u4ef7\u7b80\u5355\u3001\u53ef\u9884\u6d4b\u3001\u6210\u672c\u6548\u76ca\u9ad8\u3002.<\/span><\/p>\n<p><img decoding=\"async\" class=\"lazyload aligncenter wp-image-1016130 size-full\" src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark.png\" data-orig-src=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark.png\" alt=\"\" width=\"1430\" height=\"484\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271430%27%20height%3D%27484%27%20viewBox%3D%270%200%201430%20484%27%3E%3Crect%20width%3D%271430%27%20height%3D%27484%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-200x68.png 200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-300x102.png 300w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-400x135.png 400w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-600x203.png 600w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-768x260.png 768w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-800x271.png 800w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-1024x347.png 1024w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark-1200x406.png 1200w, https:\/\/www.artefact.com\/\/wp-content\/uploads\/2025\/10\/Pricing-models-of-each-solution-for-the-benchmark.png 1430w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1430px) 100vw, 1430px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u7531\u4e8e\u7ec4\u7ec7\u8d39\u7528\u548c\u4e0d\u540c\u7684\u8ba1\u7b97\u5b9a\u4ef7\u6a21\u5f0f\uff0cMotherDuck \u6700\u521d\u53ef\u80fd\u770b\u8d77\u6765\u66f4\u8d35\u3002\u4f46\u662f\uff0c\u8fd9\u4e24\u4e2a\u7cfb\u7edf\u90fd\u4f7f\u7528\u6709\u5229\u4e8e\u4e0d\u540c\u4f7f\u7528\u6a21\u5f0f\u7684\u5b9a\u4ef7\u6a21\u5f0f\uff1aBigQuery \u64c5\u957f\u5927\u6279\u91cf\u5904\u7406\uff0c\u800c MotherDuck \u5219\u9488\u5bf9\u4ea4\u4e92\u5f0f\u5206\u6790\u8fdb\u884c\u4e86\u4f18\u5316\u3002\u5c31\u6211\u4eec\u7684 TPC-H \u57fa\u51c6\u800c\u8a00\uff0c\u5728 SF-10 \u4e0a\u8fd0\u884c 22 \u6b21\u67e5\u8be2\uff0cMotherDuck \u7684\u6210\u672c\u4e3a $0.03\uff0c\u800c BigQuery \u4e3a $0.60-$1.00\u3002\u8003\u8651\u5230\u57fa\u7840\u8bbe\u65bd\u5f00\u9500\uff08\u6211\u4eec\u7684 PostgreSQL \u8bbe\u7f6e\u4ec5\u4fdd\u6301\u5728\u7ebf\u5c31\u9700\u8981 14 \u6b27\u5143\/\u5929\uff09\uff0cMotherDuck \u7684\u65e0\u670d\u52a1\u5668\u65b9\u6cd5\u901a\u5e38\u80fd\u4e3a\u4ea4\u4e92\u5f0f\u5206\u6790\u5de5\u4f5c\u8d1f\u8f7d\u63d0\u4f9b\u66f4\u4f18\u8d8a\u7684\u603b\u62e5\u6709\u6210\u672c\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u5728\u4f01\u4e1a\u89c4\u6a21\u4e2d\uff0c\u7ecf\u6d4e\u6027\u4f1a\u6839\u636e\u4f7f\u7528\u6a21\u5f0f\u53d1\u751f\u53d8\u5316\u3002BigQuery \u5728\u5927\u6279\u91cf\u6279\u5904\u7406\u65b9\u9762\u66f4\u5177\u6210\u672c\u6548\u76ca\uff0c\u800c MotherDuck \u5728\u4ea4\u4e92\u5f0f\u5206\u6790\u548c\u63a2\u7d22\u6027\u5de5\u4f5c\u6d41\u65b9\u9762\u4fdd\u6301\u4f18\u52bf\u3002\u91cd\u8981\u542f\u793a\uff1a\u6839\u636e\u56e2\u961f\u4f7f\u7528 data \u7684\u5b9e\u9645\u60c5\u51b5\u9009\u62e9\u5b9a\u4ef7\u6a21\u5f0f\uff0c\u800c\u4e0d\u4ec5\u4ec5\u662f\u539f\u59cb\u7684\u5355\u4f4d\u6210\u672c\u3002.<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">\u6ce8\uff1a\u6240\u6709\u5b9a\u4ef7\u793a\u4f8b\u5747\u57fa\u4e8e\u6b27\u6d32-\u897f\u6b274 \u5730\u533a\uff0c\u5e94\u89c6\u4e3a\u793a\u4f8b\u800c\u975e\u7cbe\u786e\u5b9a\u4ef7\uff0c\u56e0\u4e3a\u5b9e\u9645\u6210\u672c\u5728\u5f88\u5927\u7a0b\u5ea6\u4e0a\u53d6\u51b3\u4e8e\u5177\u4f53\u7684\u4f7f\u7528\u6a21\u5f0f\u548c data \u7684\u7279\u6027\u3002.<\/span><\/i><\/p>\n<h2><b>\u7ed3\u8bba<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">MotherDuck \u4ee3\u8868\u7740\u6211\u4eec\u5bf9\u5206\u6790\u578b database \u7684\u770b\u6cd5\u53d1\u751f\u4e86\u6839\u672c\u6027\u7684\u8f6c\u53d8\uff0c\u5b83\u5bf9\u9700\u8981\u590d\u6742\u7684\u5206\u5e03\u5f0f\u7cfb\u7edf\u6765\u5904\u7406\u91cd\u8981\u7684 data \u5de5\u4f5c\u8d1f\u8f7d\u8fd9\u4e00\u5047\u8bbe\u63d0\u51fa\u4e86\u6311\u6218\u3002\u901a\u8fc7\u91c7\u7528 DuckDB \u7684\u5d4c\u5165\u5f0f\u7406\u5ff5\u5e76\u5c06\u5176\u6269\u5c55\u5230 cloud\uff0cMotherDuck \u63d0\u4f9b\u4e86\u73b0\u4ee3 data \u56e2\u961f\u6240\u9700\u7684\u534f\u4f5c\u529f\u80fd\uff0c\u540c\u65f6\u4fdd\u6301\u4e86 DuckDB \u7684\u5353\u8d8a\u539f\u59cb\u6027\u80fd\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u6211\u4eec\u7684\u57fa\u51c6\u6d4b\u8bd5\u7ed3\u679c\u4ee4\u4eba\u4fe1\u670d\uff1aMotherDuck\u7684\u6027\u80fd\u59cb\u7ec8\u5927\u5e45\u9886\u5148\u4e8eBigQuery\u548cPostgreSQL\uff0c\u572810GB datasets\u4e0a\u7684\u67e5\u8be2\u6027\u80fd\u8fbe\u5230\u4e9a\u79d2\u7ea7\uff0c\u4eea\u8868\u76d8\u52a0\u8f7d\u65f6\u95f4\u53ef\u5b9e\u73b0\u771f\u6b63\u7684\u4ea4\u4e92\u5f0f\u5206\u6790\u3002\u4e0e BigQuery \u76f8\u6bd4\u7684\u6027\u80fd\u4f18\u52bf\uff0c\u4ee5\u53ca\u5728\u4eea\u8868\u76d8\u573a\u666f\u4e2d\u4e0e PostgreSQL \u76f8\u6bd4\u7684\u5de8\u5927\u4f18\u52bf\uff0c\u4e0d\u4ec5\u4ec5\u5728\u4e8e\u66f4\u5feb\u7684\u67e5\u8be2\u901f\u5ea6\uff0c\u8fd8\u5728\u4e8e\u5c06\u5206\u6790\u8f6c\u5316\u4e3a\u66f4\u5177\u4e92\u52a8\u6027\u548c\u63a2\u7d22\u6027\u7684\u4f53\u9a8c\uff0c\u4ece\u800c\u4fc3\u8fdb data-driven \u51b3\u7b56\u5236\u5b9a\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u4e5f\u8bb8\u6700\u91cd\u8981\u7684\u662f\uff0cMotherDuck \u5728\u5b9e\u73b0\u8fd9\u4e00\u6027\u80fd\u7684\u540c\u65f6\uff0c\u8fd8\u5927\u5927\u964d\u4f4e\u4e86\u57fa\u7840\u8bbe\u65bd\u7684\u590d\u6742\u6027\u548c\u6210\u672c\u3002\u4f20\u7edf\u7684 cloud \u8bbe\u7f6e\u9700\u8981\u6bcf\u6708\u82b1\u8d39\u6570\u767e\u7f8e\u5143\u7684\u59cb\u7ec8\u5728\u7ebf\u57fa\u7840\u67b6\u6784\uff0c\u800c MotherDuck \u7684\u65e0\u670d\u52a1\u5668\u6a21\u5f0f\u53ea\u6309\u5b9e\u9645\u4f7f\u7528\u91cf\u6536\u8d39\uff0c\u5f80\u5f80\u80fd\u964d\u4f4e\u6210\u672c\u3002\u6309\u8ba1\u7b97\u4ed8\u8d39\u7684\u5b9a\u4ef7\u65b9\u5f0f\u5b8c\u5168\u7b26\u5408\u5206\u6790\u5e08\u7684\u5b9e\u9645\u5de5\u4f5c\u65b9\u5f0f\uff1a\u5728\u63a2\u7d22\u4f1a\u8bdd\u4e2d\u8fd0\u884c\u591a\u4e2a\u67e5\u8be2\uff0c\u800c\u4e0d\u662f\u5b64\u7acb\u3001\u4e0d\u9891\u7e41\u7684\u8bf7\u6c42\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u5176\u5f71\u54cd\u4e0d\u4ec5\u9650\u4e8e\u6027\u80fd\u548c\u6210\u672c\u3002MotherDuck \u7684\u53cc\u91cd\u6267\u884c\u6a21\u5f0f\u548c\u57fa\u4e8e\u6d4f\u89c8\u5668\u7684\u5206\u6790\u529f\u80fd\u8868\u660e\uff0c\u5728\u672a\u6765\uff0c\u672c\u5730\u8ba1\u7b97\u548c cloud \u8ba1\u7b97\u4e4b\u95f4\u7684\u754c\u9650\u5c06\u53d8\u5f97\u8d8a\u6765\u8d8a\u4e0d\u7a33\u5b9a\u3002MotherDuck \u4e0d\u5f3a\u8feb\u56e2\u961f\u5728\u672c\u5730\u7b80\u5355\u6027\u548c cloud \u53ef\u6269\u5c55\u6027\u4e4b\u95f4\u505a\u51fa\u9009\u62e9\uff0c\u800c\u662f\u4e24\u8005\u517c\u987e\uff0c\u667a\u80fd\u5730\u5c06\u8ba1\u7b97\u8def\u7531\u5230\u6700\u5408\u7406\u7684\u5730\u65b9\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u5728\u6d4b\u8bd5\u8fc7\u7a0b\u4e2d\uff0cMotherDuck \u7684\u7b80\u5355\u6613\u7528\u548c\u8bbe\u7f6e\u7ed9\u6211\u7559\u4e0b\u4e86\u6df1\u523b\u5370\u8c61\u3002\u53cc\u6267\u884c\u6a21\u5f0f\u8ba9\u6211\u53ef\u4ee5\u540c\u65f6\u5728\u672c\u5730\u548c cloud \u4e2d\u67e5\u8be2 data\uff0c\u800c Superset \u548c MotherDuck \u4e4b\u95f4\u7684\u8fde\u63a5\u8bbe\u7f6e\u4e5f\u975e\u5e38\u7b80\u5355\u3002.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u5bf9\u4e8e\u5e0c\u671b\u4ece\u9ec4\u91d1\u5c42\u5f00\u59cb\u5b9e\u73b0\u5206\u6790\u80fd\u529b\u73b0\u4ee3\u5316\u7684\u4f01\u4e1a\u6765\u8bf4\uff0cMotherDuck \u63d0\u4f9b\u4e86\u4e00\u4e2a\u6781\u5177\u5438\u5f15\u529b\u7684\u4e3b\u5f20\uff1a\u4f01\u4e1a\u7ea7\u6027\u80fd\u3001\u534f\u540c\u5de5\u4f5c\u6d41\u7a0b\u548c\u6210\u672c\u6548\u7387\uff0c\u800c\u6240\u6709\u8fd9\u4e9b\u90fd\u4e0d\u9700\u8981\u4f20\u7edf data \u4ed3\u5e93\u57fa\u7840\u8bbe\u65bd\u7684\u8fd0\u8425\u5f00\u9500\u3002\u5728 data-driven \u51b3\u7b56\u8d8a\u6765\u8d8a\u591a\u5730\u51b3\u5b9a\u7ade\u4e89\u4f18\u52bf\u7684\u4eca\u5929\uff0c\u4ee5\u4e9a\u79d2\u7ea7\u901f\u5ea6\u4ea4\u4e92\u5f0f\u63a2\u7d22 data \u7684\u80fd\u529b\u5df2\u4e0d\u4ec5\u4ec5\u662f \"\u53ef\u6709\u53ef\u65e0\"\uff0c\u800c\u662f\u53d8\u5f97\u5fc5\u4e0d\u53ef\u5c11\u3002.<\/span><\/p>\n<p><b>\u51c6\u5907\u597d\u4eb2\u81ea\u4f53\u9a8c MotherDuck \u7684\u8868\u6f14\u4e86\u5417\uff1f<\/b><span style=\"font-weight: 400;\"> \u60a8\u53ef\u4ee5\u4ece <\/span><a href=\"https:\/\/motherduck.com\/product\/pricing\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">21 \u5929\u514d\u8d39\u8bd5\u7528\u6216\u4f7f\u7528\u5176\u514d\u8d39 10GB \u8ba1\u5212 <\/span><\/a><span style=\"font-weight: 400;\">\u4f7f\u7528\u81ea\u5df1\u7684 data \u8bbe\u7f6e\u548c\u5de5\u4f5c\u8d1f\u8f7d\u8fdb\u884c\u6d4b\u8bd5\u3002\u5982\u679c\u60a8\u60f3\u4e86\u89e3 MotherDuck \u662f\u5426\u9002\u5408\u60a8\u7684\u7279\u5b9a data \u534f\u8bae\u6808\uff0c\u6216\u5728\u5b9e\u65bd\u8fc7\u7a0b\u4e2d\u9700\u8981\u5e2e\u52a9\uff0c\u8bf7\u901a\u8fc7\u4ee5\u4e0b\u65b9\u5f0f\u8054\u7cfb\u6211\u4eec\u7684\u56e2\u961f <\/span><a href=\"https:\/\/www.artefact.com\/zh\/news\/artefact-partners-with-motherduck\/\"><span style=\"font-weight: 400;\">Artefact<\/span><\/a><span style=\"font-weight: 400;\">, \u5982\u679c\u60a8\u60f3\u4e86\u89e3\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u8054\u7cfb\u6211\u4eec\uff0c\u6211\u4eec\u5f88\u4e50\u610f\u8bc4\u4f30\u60a8\u7684\u5206\u6790\u9700\u6c42\uff0c\u5e76\u5e2e\u52a9\u60a8\u5411\u66f4\u9ad8\u6548\u3001\u66f4\u5177\u6210\u672c\u6548\u76ca\u7684\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u8fc7\u6e21\u3002.<\/span><\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>MotherDuck \u901a\u8fc7\u534f\u4f5c\u529f\u80fd\u5c06 DuckDB \u7684\u5206\u6790\u6027\u80fd\u6269\u5c55\u5230 cloud\uff0c\u63d0\u4f9b\u6bd4 BigQuery \u5feb 4 \u500d\u7684\u6027\u80fd\uff0c\u5e76\u901a\u8fc7\u65e0\u670d\u52a1\u5668\u3001\u6309\u4f7f\u7528\u4ed8\u8d39\u7684\u5b9a\u4ef7\u65b9\u5f0f\u6bd4\u4f20\u7edf\u7684 data \u4ed3\u5e93\u8282\u7ea6\u6210\u672c\u3002\u5728MotherDuck\u5ba3\u5e03\u65b0\u7684\u6b27\u6d32cloud\u533a\u57df\u540e\uff0c\u5176\u6027\u80fd\u548c\u8bf1\u4eba\u7684\u4ef7\u683c\u7ed9\u6211\u4eec\u7559\u4e0b\u4e86\u6df1\u523b\u5370\u8c61\u3002MotherDuck \u5df2\u7ecf\u53ef\u4ee5\u96c6\u6210\u5230\u60a8\u7684\u9ec4\u91d1\u5c42\u4e2d\uff0c\u4ee5\u52a0\u5feb data \u7528\u4f8b\u7684\u670d\u52a1\u901f\u5ea6\uff0c\u540c\u65f6\u8282\u7ea6\u6210\u672c\u3002\u67e5\u770b\u6027\u80fd\u57fa\u51c6\u3002.<\/p>","protected":false},"featured_media":1021833,"parent":0,"template":"","meta":{"_acf_changed":false,"ep_exclude_from_search":false},"blog-category":[2995,21939],"blog-language":[2991],"class_list":["post-1015858","blog","type-blog","status-publish","has-post-thumbnail","hentry","blog-category-ai-technology","blog-category-medium","blog-language-en"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/blog\/1015858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/types\/blog"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/media\/1021833"}],"wp:attachment":[{"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/media?parent=1015858"}],"wp:term":[{"taxonomy":"blog-category","embeddable":true,"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/blog-category?post=1015858"},{"taxonomy":"blog-language","embeddable":true,"href":"https:\/\/www.artefact.com\/zh\/wp-json\/wp\/v2\/blog-language?post=1015858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}