【作者】 蒲晓湘；

【导师】 刘文才；

【作者基本信息】 重庆大学 ， 控制理论与控制工程， 2004， 硕士

【摘要】 随着科学技术的发展,人们对信息的获取、加工、处理的要求越来越高,决策支持系统应运而生。数据仓库和联机分析处理(OLAP)技术是两种新型的决策支持技术。数据仓库是一种数据管理技术,侧重于管理面向主题的综合数据,为决策分析提供更有效的数据支持;OLAP技术是一种多维数据分析技术,侧重于数据仓库中的数据分析,为管理者决策提供信息支持。这两种技术相互结合,为决策支持系统开辟了新途径,并受到越来越多的关注。论文首先从基础理论着手,阐述了有关数据仓库技术和OLAP技术的相关知识点,综合分析了两者的性能优化方法,为建立OLAP系统应用作好理论上的充分准备。重庆两百股份有限公司的MIS系统积累了大量数据,有建立OLAP系统的需求和良好基础。论文利用微软的SQL Server 2000及其 Analysis Services工具作后台数据库的开发,用VB6.0开发前端应用程序,为重庆两百开发了一个具体的OLAP应用系统,并研究了具体实施过程中的有关技术,如数据迁移的关键技术、OLAP存储优化技术等等。在具体OLAP应用开发的基础上,论文提出了一种通用的OLAP应用系统框架,希望在已经建立了OLAP立方体的基础上,可以使用该系统完成各种分析任务。该系统的整体框架分为5层:界面层、应用服务器层、OLAP服务器层、数据迁移层、业务数据库层。其中最主要的工作是数据迁移和用户查询分析的实现,论文给出了这两部分的实现框架,最后给出了系统的功能模块构成和项目实施的主要步骤。更多还原

【Abstract】 With the development of science and technology, people’s requirement for the obtainment, processing of information becomes higher and higher, DSS arises at the historic moment. Data warehouse and Online Analytical Processing technology are two new-type decision supported technologies. Data warehouse is a kind of data administrative technology, which emphasizes on the integrated data-facing theme, so it can offer more effective support for making policy and analysis. OLAP is a kind of multidimensional data analysis technology, which emphasizes on the data analysis in data warehouse, and provides aid decision information for managers. These two kinds of technologies are combined mutually, which open up a new way for DSS. They are also received more and more concerns now.This paper begins with the relevant basic technology about data warehouse and OLAP, then sum up and analyses the methods of optimizing the performance of the two technologies. These works are prepared for the following OLAP application.The MIS of Chonqing Liangbai Limited Company has completed for about three years. The company urgently needs a OLAP system to analyses the large amount of data in the database and provide effective information for decisions. In the OLAP system developed for the company, Microsoft SQL Server 2000 and Analysis Services are used for database development, and VB6.0 is used for UI development .In the processing of development, relevant technologies of application of OLAP are summarized.Finally, a General OLAP Data Analysis System is given on condition that the data warehouse and the MD-database are built in advance. The frame of the system is composed of UI layer, application server layer, OLAP server layer, data transformation services layer and operation database layer. The DTS and the achievement of user’s query are the two important parts in the system. Their frames of how to develop are also put forward. The purpose of the research on the General OLAP Data Analysis System is to provide a flat on which companies can easily accomplish all kinds of analyses.更多还原