基于ClickHouse的用户事件分析系统的设计与实现  

Design and Implementation of User Event Analysis System Based on ClickHouse

作　　者：李亚臣 LI Yachen(Shanghai Mint Health Technology Co.,Ltd.,Shanghai 200000,China)

机构地区：[1]上海薄荷健康科技股份有限公司,上海200000

出　　处：《信息与电脑》2021年第9期87-90,共4页Information & Computer

摘　　要：在大数据时代,随着数据越来越多,基于传统数据库的商业智能(Business Intelligence,BI)系统,在查询、分析数据时会存在查询效率慢、查询超时、拖垮数据库等问题,因此有必要引入新型BI系统.笔者首先介绍了传统BI系统的起源和劣势,论述了基于ClickHouse新型BI的优势,并根据企业业务的实际情况,采用ClickHouse作为新型BI的存储引擎,对其进行架构设计、功能设计、程序实现.In the era of big data,with more and more data,business intelligence(BI)systems based on traditional databases will have problems such as slow query efficiency,query timeouts,and database collapse when querying and analyzing data.It is necessary to introduce a new BI system.The author first introduced the origins and disadvantages of the traditional BI system,discussed the advantages of the new type of BI based on ClickHouse,and used ClickHouse as the storage engine of the new type of BI according to the actual business situation of the enterprise,and carried out architecture design,functional design,and program implementation.

关 键 词：React GO ClickHouse BI系统 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]