一种通用聚合算法在统计工作中的应用研究-《计算机技术与发展》

文章信息/Info

Title:: Research and Application of a Generic Aggregation Algorithm to Government Statistics

Author(s):: LU Pan; YU Fang; [1]Shanghai Normal University[2]Management Institute, Xinxiang Medical College

Keywords:: statistic database; statistical grouping; OLAP; generic aggregation algorithm

摘要:: 目前政府统计部门正在积极建设统计数据库，统计数据库具有典型的多维特征。同时，统计业务人员经常要对各种级别的统计数据尤其是汇总级的数据进行所谓的即席查询（Ad—hoc query）。为了实现这一点，大多数统计查询和分析系统依赖于关系数据库平台本身提供的OLAP功能和接口，造成应用系统与数据库系统紧耦合反而降低了应用系统的可移植性。文中根据统计数据库多维特征和OLAP聚合操作的原理提出一种跨数据库系统平台的通用聚合算法，并成功应用于统计工作中，有效地解决了上述问题

Abstract:: Nowadays, governmental statistical departments are building statistical databases actively. Statistical database has typically mul- tidimensional character. On the other hand, statisticians often implement ad - hoc queries to all kinds of criteria for statistical data, especially to aggregation. To achieve this, the majority of statistical information and analysis systems rely on the OLAP functions and interfaces provided by relational database platform itself, resulting in applications and database systems tight coupling, which reduces the portability of applications. So design and implement a generic aggregation algorithm in the thesis that doesn＇ t depend on a specific RDBMS according to multidimensional character of statistical database and principle of aggregation. The algorithm has been applied to statistics successfully, and provides a solution of the problem