免疫疾病预防数据库中保存了大量的统计数据,这些数据来自于各个疾病预防控制单位的免疫防病信息系统。传统的OLTP分析系统无法对这些数据进行有效的决策分析。为了能够根据这些信息迅速生成综合分析数据,以辅助卫生防疫部门和相关政府部门进行决策,急需一个基于统一数据仓库的数据分析系统。本文介绍了基于OLAP的免疫疾病预防数据分析系统的设计方案以及关键的实现技术。系统具有良好的可扩展性和可移植性,也为利用ASP.NET、OWC和SQL Server 2000 Analysis Services等构建基于W eb的深层数据分析提供了一个通用的解决方案。
The immunity database stores substantive statistic data from all kinds of prophylactic units. The traditional OLTP analysis system can' t do effective decision-making and analysis from these data. In order to quickly generate integrated analysis data for epidemic prevention units and relative governmeutal sectors, it urgently needs an OLAP-based decision-making and analysis system. This paper introduces the design of the OLAP-based immunity data analysis system and the relative important realization technique. The system has favorable expandability and transportability. It provides a general solution for the construction of Webbased deep level data analysis by using ASP. NET, OWC, and SQL Server 2000 Analysis Services.