Tagged articles
DataWarehouse
10 articles · Page 1 of 1

Yunqi AI+Jul 18, 2026 · Artificial Intelligence
The article analyzes why directly connecting large language models to a data warehouse often fails to deliver reliable analytics, outlines common failure modes, and presents a structured Skill‑based architecture—including intent routing, parameter compilation, metric‑first querying, review, and governance—to ensure trustworthy enterprise data queries.
AIDataWarehouseEnterpriseAnalytics
0 likes · 20 min read

This presentation by iQIYI’s Technical Director Zhang Xiaoming details the evolution of BI systems, introduces the Chat BI framework, explains its three‑step implementation, outlines architectural design, data‑warehouse integration, performance optimizations, and user‑operation strategies, revealing how AI and RAG empower smarter data analytics.
AIBIChatBI
0 likes · 18 min read

This article explains how Douyin rebuilt its interest‑circle platform by replacing MySQL with the columnar OLAP engine ByteHouse, achieving roughly a hundred‑fold improvement in query speed, lower hardware costs, and seamless horizontal scalability for massive daily data volumes.
ByteHouseColumnarStorageDataWarehouse
0 likes · 10 min read

This article details Bilibili's transition from MySQL to ClickHouse for live guild analytics, describing data volume challenges, the design of a Unique Engine to overcome ReplacingMergeTree limitations, and performance results for query and write workloads.
ClickHouseDataWarehouseOLAP
0 likes · 18 min read

This article introduces Alibaba Cloud DataWorks' intelligent data modeling tool, outlines the data demand flow, shares best practices and practical demonstrations of data warehouse modeling, discusses model application and data asset management, and answers common questions while highlighting its commercial availability.
AlibabaCloudDataGovernanceDataWarehouse
0 likes · 12 min read

This comprehensive tutorial walks you through Alibaba DataWorks' data warehouse architecture, covering technical stack selection, three‑layer warehouse design (ODS, CDM, ADS), detailed data modeling with DDL examples, storage strategies, dimension and fact table conventions, and best‑practice hierarchical call standards.
DataModelingDataWarehouseDataWorks
0 likes · 27 min read


政采云技术Jul 12, 2022 · Big Data
This article explains Spark SQL's physical execution plan, detailing each operator, how to interpret the plan, and practical optimization tips for data warehouse developers to improve SQL performance and resource utilization.
DataWarehouseExecutionPlanPerformanceOptimization
0 likes · 10 min read

This article presents an in‑depth overview of ClickHouse's Projection feature, covering its background, definition, storage and query mechanisms, practical use‑case demonstrations, performance comparisons with competing OLAP systems, and real‑world production results that highlight its advantages and limitations.
ClickHouseDataWarehouseMaterializedView
0 likes · 20 min read

This article describes how 58.com introduced ClickHouse to handle massive daily user‑behavior logs, detailing its features, multi‑layer architecture, configuration management, monitoring, performance optimizations, and operational automation to build a high‑availability, low‑cost analytics platform.
ClickHouseDataWarehouseOLAP
0 likes · 20 min read

This article outlines the core concepts of a data middle platform, covering data aggregation, ingestion tools, offline and real‑time development, data governance, service layers, and practical implementation details such as ODS, DWD, and monitoring, illustrating how enterprises build scalable, secure data ecosystems.
DataGovernanceDataMiddlePlatformDataWarehouse
0 likes · 32 min read
