基于Oracle数据仓库应用技术的研究与实现-计算机应用技术专业论文.docxVIP

第1I页 第1I页 武汉科技大学硕士学位论文 Abstract The data warehouse techniques is increasingly growing up in the area of information technology,and has been widely researched．Data warehouse is an integrative technology on administration and application．An enterprise，which wants to win the competition and acquires more income，must make use of the data warehouse technology,mine deeply,analyze historical， current and relevant information data,and acquire useful decision making information automatically．So data warehouse call provide fast，exact and convenient decision support to enterprises． nle data warehouse is a subject·ofienWxl,integrated．time-variant and nonvolatile collection of data in support of management’decision making process．Data warehousing is not a new platform，but a new concept．Meanwhile it is not a product，but a solution．It provides decision-maker a single analysis environment,in which information from multiple heterogeneous sources is transformed and integrated in advance and stored in a warehouse． On—Line Analytical Processing(OLAP)is a classical application of data warehousing for the interactive analysis of multidimensional data of varied granularities．Moreover,OLAP supports Some multidimensional analytical operations，such as slice，dice，roll-up，drill—down and rotate，which provide users with the flexibility to view data from different perspectives． This paper does researth on the data warehouse technology oriented decision support． Making use of the kaovAedge of data warehouse and OLAP,designs the data warehouse system framework supported the decision of sell on iron and steel industry independently by the author, and implements a data warehouse system based on the fralne work，then makes the application research on this combination． The paper introduces firstly the concept and characteristic，system frame，data organizing of data warehouse，as well as the major techniques ofbuilding data warehouse system，secondly, explicates the key tools and the way to reslove pr