关键词: 统计报表,多维数据建模,语义分析,计算机辅助软件工程(CASE) 中图法分类号TP391文献标识码A

Abstract: 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 system 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).

Key words: Statistical data sheets,Multiple dimension data modeling,Semantic analysis,Computer aided software engineering(CASE)