在传统企业应用中,开发人员要根据不同的业务需求开发对应的数据统计模块,这样的“预定义”数据统计方法很难满足不同用户对统计数据的个性化需求.为了简化数据统计模块的开发流程,同时满足不同用户的数据需求,提出了面向最终用户的可定制数据统计服务解决方案.本文着重介绍了面向用户的元数据模型和统计模型的表示方法,以及基于动态构建SQL的即席查询方法,并设计和实现了一套支持企业应用的数据统计服务.
In traditional enterprise application, developers should develop different statistics modules according to corresponding business requirements. It is difficult to meet the individual needs of business users by using such "predefined" statistics methods. In order to simplify the development process of statistics modules and meet the individual data needs of users, this paper presents an end-user customizable statistics service solution. This paper focuses on the representation of user-oriented metadata model and statistical model, ad hoc query method based on dynamically constructed SQL, then presents the design and implement of a statistics service system supporting enterorise at3Dlication.