The Design And Realization Of Sales Decisions Based On Data Warehouse System

Business trading company must deal with a great deal of data in every day. Adapting to the increasingly vigorous market competition, we need establish the management system and decision support system with a strong function. Therefore it is very significant for Business trading company how to establish decision support system, which is base on a purchase, sales and inventory system. The nativity of the data warehouse brings about the structural revolution in information system; also establishes the modern ear with business enterprise management intelligent decision. The first stage of this article points out the problems of a purchase, sales and inventory system, further uses the manners and methods of data warehouse to solute the problem. And then the second stage of this article introduce the conception , principle, technology of data warehouse. In order to there is clearer cognition to the data warehouse, provide the theories technique support for the design and development.Because the vigorous market competes and data warehouse give the business enterprise the high the bigness value, the high leaders of the material limited company of the two bureau of china's train draw a conclusion to establish the decision support system, increasing the competition ability of the business enterprise with more science more completely of decision support.We have investigate and understand the need of the leader, the Manager of Sale department and employee. According to the general principles that data warehouse design, we select the sale topic to establish Prototype design. The third stage of this article introduces the design and development of sale warehouse. We Discuss gradually the analysis of need, the Construction of the system hardware and software design Concept model design, the model of data. The data collects, the design of multilateral dimension analysis service, the design and development of custom tool.Article finally analysis the complete work in this papers, points out the shortage and mistake in the design and development, points out the work of the next activity.