基于语义分析的统计报表多维数据建模方法  

Multiple Dimension Data Modeling Method for Statistical Data Sheets Based on Semantic Analysis

作　　者：沈晖[1] 陆育锋[1] 郭以东[1] 杨勇[1] 

机构地区：[1]中国石油勘探开发研究院西北分院计算机技术研究所,兰州730020

出　　处：《计算机科学》2013年第9期243-246,共4页Computer Science

基　　金：中国石油天然气集团公司"十二五"信息化重点项目(E7)资助

摘　　要：在统计类应用系统实施过程中,依据前台报表的样式和填报要求设计后台数据库表结构是一项重要的基础性工作,但往往凭借的是系统设计人员的经验,被看作是一项艺术而不是有章可循的技术,直接导致的结果是:针对同一套业务统计报表,不同的系统设计人员可能设计出千差万别的后台数据库表,带来系统运行性能与日后运维升级等方面的问题。为了改变这种状况,对现实中基于业务统计报表设计后台数据模型的过程进行了深入研究,总结提出一种基于语义分析的从统计报表集合抽取统一多维数据模型的规范化、程序化方法,并在某大型国企信息系统项目中进行了应用验证。For implementing statistical analysis applications, it is the most fundamental task to design back-end database to support front-end data sheets processing, including data capturing, calculation and presentation. It always depends on technical designer＇s personal experiences instead of rule-based step-by-step procedure and has been regarded as ＂art＂ instead of ＂scientific technology＂. A risky result is that different technical designers might create different data models for one same set of statistical data sheets pre-defined by business end-users, which can cause big troubles both for sys-tem performance and on-going application maintenance. Through in-depth study on real case to summarize business rules,a formal method based on semantic analysis was proposed to support creating unified multiple dimension data model from pre-defined statistical data sheets and applied in a large SOE information system project as PoC（Proof-of-Concept）.

关 键 词：统计报表 多维数据建模 语义分析 计算机辅助软件工程(CASE) 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]