Skip to content

feat: ChatBI 业界主流实现方案深度对比分析报告（阿里/腾讯/字节/帆软） #2

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Draft
XIDIANcoding wants to merge 16 commits into
base: master
Choose a base branch
from
Draft

feat: ChatBI 业界主流实现方案深度对比分析报告（阿里/腾讯/字节/帆软） #2

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
16 commits
Select commit Hold shift + click to select a range
26b63a0
Add OceanBase lakebase AI report
cursoragent Aug 16, 2026
7002bad
Update report with detailed vendor architectures, drawio diagrams, an…
cursoragent Aug 16, 2026
6d7419e
Enhance drawio diagrams with explicit layer-to-layer interactions, da…
cursoragent Aug 16, 2026
5e032f9
Add explicit engineering boundaries, in-kernel modifications, and ext…
cursoragent Aug 16, 2026
922d824
Optimize original vendor diagrams with explicit component placement l…
cursoragent Aug 16, 2026
ad7e500
Ground AI database report in official sources
cursoragent Aug 16, 2026
4b2a6bc
Add editable AI database architecture presentation
cursoragent Aug 16, 2026
3c6125f
Add knowledge graph product roadmap and solutions
cursoragent Aug 16, 2026
3334a2d
Fix architecture connector label overlaps
cursoragent Aug 17, 2026
938cd88
Add AI database common trends HTML report
cursoragent Aug 17, 2026
ff3387c
feat: add comprehensive ChatBI industry architecture analysis report …
cursoragent Aug 18, 2026
40a6aec
Add Tencent ChatBI component interaction & layered deployment archite…
cursoragent Aug 20, 2026
21fb9f7
Fix Tencent ChatBI diagram: isolate Text2SQL/Text2DSL channels, corre…
cursoragent Aug 20, 2026
6900a4c
Add ChatBI capability development checklist for MySQL+in-DB LLM: what…
cursoragent Aug 20, 2026
d12b5c8
Add Alibaba Quick BI (智能小Q) component interaction & layered deploymen…
cursoragent Aug 20, 2026
4742fc0
Add Tencent ChatBI test pack: retail CSV tables, knowledge-base setup…
cursoragent Aug 20, 2026
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
389 changes: 389 additions & 0 deletions ai-database-common-trends-report.html
View file
Open in desktop

Large diffs are not rendered by default.

Binary file added ai-database-lakehouse-report-editable.pptx
View file
Open in desktop
Binary file not shown.
443 changes: 443 additions & 0 deletions alibaba-chatbi-architecture.html
View file
Open in desktop

Large diffs are not rendered by default.

1,453 changes: 1,453 additions & 0 deletions build_chatbi_report.py
View file
Open in desktop

Large diffs are not rendered by default.

1,417 changes: 1,417 additions & 0 deletions chatbi-industry-architecture-report.html
View file
Open in desktop

Large diffs are not rendered by default.

348 changes: 348 additions & 0 deletions chatbi-tencent-testset/README-知识库与测试用例.html
View file
Open in desktop

Large diffs are not rendered by default.

11 changes: 11 additions & 0 deletions chatbi-tencent-testset/dim_customer.csv
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,11 @@
客户ID,客户名称,客户等级,所属行业
C001,华创商贸,A,互联网
C002,星河零售,B,互联网
C003,南粤供应链,C,制造
C004,北辰科技,A,互联网
C005,锦程贸易,A,零售
C006,海纳百川,A,制造
C007,东方明珠商行,B,零售
C008,绿野仙踪生鲜,A,餐饮
C009,云端数码,A,互联网
C010,金鼎家居,B,互联网
18 changes: 18 additions & 0 deletions chatbi-tencent-testset/dim_region.csv
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,18 @@
省份,大区,大区负责人
上海,华东,张伟
江苏,华东,张伟
浙江,华东,张伟
安徽,华东,张伟
北京,华北,李娜
天津,华北,李娜
河北,华北,李娜
山东,华北,李娜
广东,华南,王强
广西,华南,王强
福建,华南,王强
四川,西南,赵敏
重庆,西南,赵敏
云南,西南,赵敏
湖北,华中,陈浩
湖南,华中,陈浩
河南,华中,陈浩
5,849 changes: 5,849 additions & 0 deletions chatbi-tencent-testset/dws_retail_trade_di.csv
View file
Open in desktop

Large diffs are not rendered by default.

2 changes: 2 additions & 0 deletions diagrams/databricks-agent-bricks-architecture.drawio
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,2 @@
<?xml version="1.0" encoding="UTF-8"?>
<mxfile host="drawio" version="26.0.0"><diagram id="databricks-agent-bricks-architecture" name="Databricks：Lakebase LTAP + Lakehouse + Agent Bricks"><mxGraphModel dx="1200" dy="800" grid="1" gridSize="10" guides="1" page="1" pageWidth="1200" pageHeight="900"><root><mxCell id="0" /><mxCell id="1" parent="0" /><mxCell id="2" value="Lakebase Postgres Compute&amp;#xa;无状态标准 Postgres 计算层&amp;#xa;仅持有 shared buffers 与本地缓存&amp;#xa;[D1][D2]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dbeafe;strokeColor=#2563eb;fontSize=11;" vertex="1" parent="1"><mxGeometry x="60" y="45" width="285" height="100" as="geometry" /></mxCell><mxCell id="3" value="Lakebase Durable Storage&amp;#xa;Safekeepers + Pageservers + Cloud Object Storage&amp;#xa;提交持久化，计算与存储分离&amp;#xa;[D1][D2]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#f1f5f9;strokeColor=#64748b;fontSize=11;" vertex="1" parent="1"><mxGeometry x="405" y="45" width="300" height="100" as="geometry" /></mxCell><mxCell id="4" value="LTAP Storage Transcoding&amp;#xa;行式 Postgres 数据落湖时转为 Parquet 列式&amp;#xa;不是外部 CDC/复制管道&amp;#xa;[D3]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#cffafe;strokeColor=#0891b2;fontSize=11;" vertex="1" parent="1"><mxGeometry x="765" y="45" width="295" height="100" as="geometry" /></mxCell><mxCell id="5" value="Lakehouse//RT / OLAP Engine&amp;#xa;直接查询 live Lakebase 当前状态&amp;#xa;与 Postgres 各用专门引擎&amp;#xa;[D3]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dbeafe;strokeColor=#2563eb;fontSize=11;" vertex="1" parent="1"><mxGeometry x="60" y="250" width="285" height="100" as="geometry" /></mxCell><mxCell id="6" value="单一逻辑副本 / 开放格式&amp;#xa;对象存储中的 Parquet，通过 Delta/Iceberg 读取&amp;#xa;OLTP 与 OLAP 共用存储基础&amp;#xa;[D3]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#f1f5f9;strokeColor=#64748b;fontSize=11;" vertex="1" parent="1"><mxGeometry x="405" y="250" width="300" height="100" as="geometry" /></mxCell><mxCell id="7" value="Unity Catalog / Unity AI Gateway&amp;#xa;权限、血缘、审计；模型/Agent/MCP/工具&amp;#xa;统一作为 securable objects 管理&amp;#xa;[D4][D5]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dcfce7;strokeColor=#16a34a;fontSize=11;" vertex="1" parent="1"><mxGeometry x="765" y="250" width="295" height="100" as="geometry" /></mxCell><mxCell id="8" value="Databricks AI Search&amp;#xa;独立托管 Serverless 搜索服务&amp;#xa;Delta Sync index 自动同步源 Delta Table&amp;#xa;[D6]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffedd5;strokeColor=#ea580c;fontSize=11;" vertex="1" parent="1"><mxGeometry x="60" y="455" width="285" height="100" as="geometry" /></mxCell><mxCell id="9" value="Agent Bricks / Supervisor Agent&amp;#xa;托管 Agent 运行时；协调 Genie、AI Search、&amp;#xa;UC Functions、MCP 与自定义 Agent&amp;#xa;[D5][D7]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffedd5;strokeColor=#ea580c;fontSize=11;" vertex="1" parent="1"><mxGeometry x="405" y="455" width="300" height="100" as="geometry" /></mxCell><mxCell id="10" value="Databricks Apps / Model Serving&amp;#xa;应用与 Agent 服务部署入口&amp;#xa;FinThrive 在数小时内上线多 Agent 助手&amp;#xa;[D8]" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffedd5;strokeColor=#ea580c;fontSize=11;" vertex="1" parent="1"><mxGeometry x="765" y="455" width="295" height="100" as="geometry" /></mxCell><mxCell id="100" value="1" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="2" target="3"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="101" value="2" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="3" target="4"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="102" value="3" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="4" target="6"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="103" value="4" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="6" target="5"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="104" value="5" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="7" target="5"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="105" value="6" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="7" target="9"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="106" value="7" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="6" target="8"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="107" value="8" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="8" target="9"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="108" value="9" style="edgeStyle=orthogonalEdgeStyle;rounded=1;orthogonalLoop=1;jettySize=auto;html=1;strokeColor=#334155;fontSize=10;fontStyle=1;labelBackgroundColor=#ffffff;" edge="1" parent="1" source="9" target="10"><mxGeometry relative="1" as="geometry" /></mxCell><mxCell id="109" value="1. WAL/页面持久化" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="60" y="610" width="490" height="28" as="geometry" /></mxCell><mxCell id="110" value="2. 存储物化时转码" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="60" y="644" width="490" height="28" as="geometry" /></mxCell><mxCell id="111" value="3. Parquet + Delta/Iceberg" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="60" y="678" width="490" height="28" as="geometry" /></mxCell><mxCell id="112" value="4. 直接分析单一逻辑副本" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="60" y="712" width="490" height="28" as="geometry" /></mxCell><mxCell id="113" value="5. 治理分析访问" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="60" y="746" width="490" height="28" as="geometry" /></mxCell><mxCell id="114" value="6. 身份/权限/工具治理" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="590" y="610" width="490" height="28" as="geometry" /></mxCell><mxCell id="115" value="7. Delta Sync 派生搜索索引" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="590" y="644" width="490" height="28" as="geometry" /></mxCell><mxCell id="116" value="8. 检索工具" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="590" y="678" width="490" height="28" as="geometry" /></mxCell><mxCell id="117" value="9. 部署与调用" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#cbd5e1;fontSize=10;align=left;spacingLeft=8;" vertex="1" parent="1"><mxGeometry x="590" y="712" width="490" height="28" as="geometry" /></mxCell></root></mxGraphModel></diagram></mxfile>
Loading