Commodity Purchase Decision Support System Research And Application

Using the material purchasing decision support system's researching and applying, we can inquest stock in storage and status of the financing occupation quickly .We can also inquest the material purchasing, selling, stocking in a certain period .Stating the material's serving, costing and consuming with accuracy .Processing the material's cost calculation, reflecting the material's dynamic state .Affording scientific gist for the material's economy analysis. We can share the information from the internet technology, reduce the reduplicate stockpile , decrease the storage , expedite the financing's turnover , finally , improve the whole bureau economic effect .We can use this system to analyze the status of different material surplus and deficiency , control the dynamic material reserve in reason , avoid the material's overstock or the material's scarcity . Predominating the purchasing progress, supervising procurement contract execute. Providing materials supply balance plan and contract resources statistical data. So this can replace fussy manual query and reckoning.In addition, we can use this system to share the information of the material purchasing in security range. Take advantage of the modern control theory, we can control the purveying chain in science, circulate it in effect. We can use the data warehouse technique to accomplish the historical data analysis. We can use the data digging technique to analyze the rule of different material using by different users. So we can depress the purchasing cost in whole hog, enhance quality of service, make the maximal economic effect.Now in the oil field, the data warehouse technique and the OLAP technique is very important to us. We can use these techniques to analyze the output of the oil and gas. We also can use these techniques to analyze the different factor of influencing the output of oil and gas. We use the OLAP technique to analyze the certain matter in oil exploiting, Access the data in manifold form. The administrative supervisor can profoundly survey the data. So this item has a very profitable signification to study the Relational Data Base Management System in many domain of the oil field. This item has a very extensive foreground in application.