The Research And Application Of DataWarehouse System Based On Web

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.