Cementing Materials Sales Based On Data Warehouse Decision Support System

In the intense market competition, the information has very important function for living and development of company. The data of expression information increases unceasingly along with the time and the service's development Therefore the company more and more needed to establish a function formidable auxiliary decision support system to summarize and analyze past information data. Now the assistance decision support system mainly established with the data warehouse technology.The company very early started to apply the system of sale management. With the fast development of the company, The information data is massively accumulated. The high leaders of the company draw a conclusion to establish the decision support system on the original systematic foundation, increasing the competition ability of the business enterprise with more science more completely of decision support.The paper from the concept, the logic, the physical level has carried on the model design of the data model and the granularity model, basically has completed the data warehouse design. The first stage of this article points out the problems of Data Warehouse. 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. 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 the papers, points out the shortage and mistake in the design and development.