数据仓库技术在商业智能系统中的应用

【作者】 王军；

【导师】 黄国兴；

【作者基本信息】 华东师范大学 ， 软件工程， 2007， 硕士

【摘要】 当今世界已进入全面知识管理时代，信息量的急剧增加使得企业的决策过程日益复杂。新兴的商业智能技术为企业提供了新的选择，越来越多的管理者开始借助商业智能技术为企业寻求解决之道。虽然当前商业智能的研究与应用正处于从起步阶段向发展阶段过渡的转变时期，其理论研究与系统应用已成为目前国内外企业界和软件开发界广泛关注的热点问题。商业智能是对商业信息的搜集、管理和分析过程，目的是使企业各级决策者获得知识或洞察力，促使他们做出对企业更有利的决策。商业智能一般由数据仓库、数据分析、数据挖掘、在线分析、数据备份和恢复等部分组成。目前对于商业智能的开发还没有一套系统的研究，本文从这些出发对该系统作较为全面的研究，并在项目实践过程中对其中的经验进行总结，对其中的重要问题提供相应的对策。本文在第一章主要介绍了商业智能的产生以及体系结构，开发及实施过程以及商业智能的应用。第二章和第三章分别介绍了商业智能系统实现的技术基础：数据仓库和商业智能。在第二章重点对数据仓库产生的背景、数据仓库的体系结构、ETL、OLAP等技术做了深入研究；对数据仓库、数据集市、数据库做了比较分析；对数据仓库的实现策略、开发流程、实施特点进行研究，同时比较分析了常用的数据仓库工具以及数据仓库的新技术。这些为后面的系统实现奠定了基础。第四章和第五章主要介绍了系统的设计、实现。重要的是对系统实现过程中的经验作了总结，为以后系统的开发提供了重要的参考。更多还原

【Abstract】 The world today has entered the era of comprehensive knowledge management, the dramatic increase in the amount of information allows companies increasingly complex decision-making process. Emerging business intelligence (BI) technology provide new options, more and more managers start using business intelligence technology for enterprises seeking a solution road. While the current business intelligence research and application are at the transitional period from the initial stage to the development stage, its theoretical research and application systems have attracted a wide attention of the software development circle at home and abroad.Since there is no systemic research for the development of the business intelligence at present, in this article the author made an all-around study for this system, furthermore, the author summed up the experience of the more important issues and provided the corresponding Countermeasures in the course of the practice.Business intelligence is a process of the collection, management and analysis for the business information, whose purpose is to ensure the corporate decision makers at all levels to acquire knowledge or insight, in order to make them more favorable to business decision-making. Business intelligence is composed of data warehouse, data analysis, data mining, online analysis, data backup and recovery.In this article, the author introduces the birth, intelligent architecture, development and application of the business intelligence in the first chapter. The author introduces the base technology for the implement of the BI system and data warehouse and mining respectively in the second and third chapter. The second chapter focuses not only on the research of the background of data warehouse, data warehouse architecture and the technology of ETL, OLAP; on the comparative analysis of the data warehouse, data market and database; but also the investigation for the implement strategy, developing line and characteristic of the data warehouse; and makes a comparative analysis between the data warehouse tool and new technology. Both these pave the way for the system achievement. The fourth and fifth chapter mostly introduces the designment and implement of the system. The chapter mainly sums up the important experience issue and provides important reference for the developing of the system.更多还原