Data Warehouse System Based On Supply Chain Research

Uncertainty of marketing and diversity of products have made supplying chain logistics management more and more difficult, with severe problems about inventory. Supplying chain management emphasizes cooperation between different rings and the best collocation of resources, and data warehouse provide such many functions as data integrity, data share and decision analysis. They have attracted more and more attention at present as the result of their performance on improving the business financial index and high ROI. Based on the all-round research of supplying chain management and data warehouse, this paper has discussed the impossibility of combining them closely, and constructed a scheme that data warehouse system based on the supplying chain management is used to help solve the problems during the material circulation.This paper focused on the collocation of material circulation, particularly discussed test sale of new products under the material initiative supplying model, tracking bills of old products, dealing with peculiar products and client booking tabs, products redeployment (to solve the lopsided sale quantity between different areas), and determining the similar products. By analyzing a lot of data, as well as advantage and disadvantage of them, we emphasized the importance of data warehouse based on the supplying chain management, and got such achievement as follows:1. determining the similarity of different products with the method of intensity judging tree;2. having put forward a flowing sand model for the test sale of new products;3. having constructed a model to control product relief with the supplying day of inventory.What's more, this paper accounted for software design and performance of data warehouse based on the supplying chain management, and some example are followed. In the end, we gave a conclusion and made a prospective.