【作者】 韩明华；

【导师】 蔡瑞英；

【作者基本信息】 南京工业大学 ， 计算机应用技术， 2005， 硕士

【摘要】 随着市场竞争的不断加剧,如何为企业决策分析人员提供准确、及时的信息,已成为企业当前迫切需要解决的问题。传统的数据库技术是单一的数据库资源,它适合操作型事务处理,但对分析型处理的能力较弱。数据仓库的出现,将操作型环境与分析型环境进行了分离,划清了数据处理的分析型环境与操作型环境之间的界限,从而由原来以单一数据库为中心的数据环境发展为以数据仓库为中心的一种新的体系化环境。 数据仓库中的数据“是面向主题的、集成的、稳定的并随时间不断变化的,建立数据仓库的目的是为了更好地支持决策分析。”通过建立数据仓库系统,借助于联机分析处理(OLAP)和数据挖掘工具(DM)就可以帮助人们以更好的方式来管理、综合和分析海量数据,以支持管理决策。随着世界范围内Internet环境的形成,全球正进入一个以网络为中心的计算时代,进入Internet的用户和地区迅速增加,人们对从Internet上获取信息和服务的需求越来越迫切,因此随着对数据仓库技术的深入研究及Web技术的飞速发展,将Web技术与数据仓库技术进行结合成为可能,即建立基于Web方式的数据仓库系统。基于Web方式的数据仓库系统是一种基于B/S(浏览器/服务器)模式的数据仓库系统,它可以分为客户端浏览器、Web服务器和应用服务器三层构架,用户通过Web浏览器提交分析请求,Web服务器将用户的分析请求提交给应用服务器,应用服务器端的OLAP、DM等工具通过调用数据仓库内的数据完成分析操作并将结果转给Web服务器,而后Web服务器将结果返回给用户端。Web技术和数据仓库的有机结合,扩大了数据仓库的应用范围,增加了数据仓库应用的灵活性,并成为数据仓库的发展的新的方向。 本文对数据仓库的数据组织、结构及Web技术的发展进行了研究,对数据仓库技术及Web技术的结合即基于Web的数据仓库技术进行了讨论,并对数据仓库系统开发的详细过程和技术以及基于数据仓库的数据挖掘和联机分析处理理论进行了深入研究,在此基础上提出了基于Web的数据仓库系统的构架,并以医药企业为例用面向对象的方法建立了医药企业的企业模型,对医药数据仓库主题及边界的划分以及数据模型、数据模式的定义进行了详细介绍,并以此为基础构建了基于Web的医药数据仓库系统的多维模型,最后实现了基于Web的医药数据仓库系统。更多还原

【Abstract】 With the impetuosity of the market competition, how to supply exact and timely information for enterprises’ decision-makers is the problem that the enterprises are facing . The traditional Database is single data resource, it adapts to the operational transaction processing, but its analytical ability is very feebleness. The appearance of DataWarehouse separates the operational circumstance and the analysis circumstance. It makes a clear distinction between the operational circumstance and the analysis circumstance. The data circumstance has developed from single Database to DataWarehouse.The Data in DataWarehouse is Subject Oriented, composite, steady and variation with the time. The intent building DataWarehouse is to support the decision. Through using DataWarehouse, OLAP and DM, users can manage, colligate and analyze a great deal of data with better mode. With the development of Internet, people urgently want to get information and services from Internet. With the development of DataWarehouse and Web, it is possible to integrate DataWarehouse and Web and build the DataWarehouse system based on B/S structure. The DataWarehouse system is a DataWarehouse system based on B/S structure. It has three layers such as browser, Web server and application server. Integrating of Web and DataWarehouse enlarges the applied extension of DataWarehouse and enhances the applied agility of DataWarehouse. It has become the new developmental direction.This article researches the data organization, structure of DataWarehouse and Web. It discusses the integration of Web and DataWarehouse. It not only researches the exploitation process of DataWarehouse but also explores OLAP and DM based on DataWarehouse. The paper gives the structure of DataWarehouse based on B/S. Taking a curative enterprise as an example, this article builds the enterprise model for this curative enterprise using the method of oriented object. It introduces how to compartmentalize the subject and boundary of curative DataWarehouse and how to define the relation model and relation schema. According to these, it builds the dimensional model of the curative DataWarehouse system based on Web. At last, it realizes the system.更多还原