[工程科技]社会保险OLAP系统的设计与实现.doc

摘 要 某市社会保险部门已经拥有成熟的OLTP数据库系统，经过长期的业务处理和常规管理，他们积累了大量的业务数据。要充分利用这些积累起来的海量数据，从中获取可用于决策的有用信息，可行的办法是建立专门用于决策支持的数据仓库系统。本课题的任务就是在建立起来的数据仓库的基础上进行多维（OLAP）分析。 我们在数据仓库中存储海量数据，并面向主题建立数据立方。在建立起来的两个数据立方的基础上，本系统将实现这些功能——展示多维数据，高级查询所需的有用信息，生成用于决策的数据报表，生成用于决策的图形报表。 本论文正文内容包括五大模块：引言，OLAP概述，OLAP开发工具概述，项目系统的设计，项目的技术实现。 引言模块描述了数据仓库的市场现状、技术现状、项目背景、项目任务和论文写作安排。OLAP概述模块阐述了数据仓库的基本理论和多维分析的基本理论。OLAP开发工具概述模块介绍了基于SQL Server 2000的分析服务技术，MDX查询语言，ADO MD对象模型，DSO对象模型，OWC组件技术。项目系统的设计模块描述了本项目数据仓库体系结构，数据仓库模型，数据立方模型。项目的技术实现模块介绍了访问多维数据库的算法和VB代码，客户端应用程序的建立和使用。 【关键词】 社会保险,数据仓库, 多维分析，OLAP Abstract The social insurance department of one city has been equipped a very mature database system of OLTP. After transacting and managing the daily operations by using the OLTP for a long time, they have accumulated a great deal of the transacting data. In order to make good use of the mass data as well as to obtain the useful information which can be used to support decisions, a feasible way is to establish a data warehouse system which can be wholly used to support decisions. The mission of this project is to do the OLAP analysis which base on the established data warehouse. We store the mass data in the data warehouse, and establish the data cubes according to the tops. This system will achieve many functions on the basis of the two data cubes established. It can show the multi-dimension data. Users can query the useful information from it. It can generate the data reports and the charts which will be used to support the decisions. The text content of this dissertation includes 5 modules——the preface, the summary of OLAP, the summary of tools used in developing OLAP, the designing of the system, the technical achieving of the project. The first module describes such content as the status quo of data warehouse in market field, the status quo of data warehouse in Technology field, the background of the project, the mission of the project and the content arrangement of this dissertation. The second module describes