基于SQL的自助数据分析模式设计

Design of Self-service Data Analysis Model Based on SQL

针对集成报表难以满足多样化的数据分析需求,设计并实现一种基于SQL Select的自助数据分析模式.该模式通过在用户层数据别名与物理数据库之间、在分析选项与SQL指令之间建立映射关系,设计相应算法完成数据解释、数据关系解析、查询逻辑判定、语法逻辑判定,并根据解析和判定结果完成Select指令重构和数据查询分析:完整地构建了数据查询分析的自助模式设计,使普通用户能够完成自定义的数据统计分析,有效地增强信息系统数据分析能力与决策支持能力.

In allusion to the deficiency of integrated report in meeting the demand for various data analysis, this work designs a self-service data analysis model based on the SQL Select query. In this model, two mapping relations between the data alias in user-layer and the physical database, between the analysis option in user-layer and the SQL instruction are established, with the algorithm designed for interpreting the data fields, connected relations, query logic and syntax hales. The above efforts help to complete the Select instruction reconstruction and the data analysis during the ensuing steps. The self-service data analysis model is expected not only to enable common users to achieve user-defined statistics analysis but more importantly, to efficiently improve the capacity of information system in data analysis and decision support.