The Analysis System of Purchasing Management (ASPM) is an important implement in Purchasing Management. According to the requirement and development of Business Intelligence, the process of purchasingăthe purchasing mode of manufacturing specialist and the indicators of analysis, the database of ASPM and its architecture is designed.The main content in this dissertation is below:Analyzed the present situationăstructure and purchasing module of the ERP system, discussed the questions and status about purcharsing management at home and abroad.(2) Designed the new data structure of ASPM and completed as the role of date mode designed, so that the structure is took care of in dependable, which promoted the efficiency of analyzed, and then much routine time has been saved. So the Enterprises Purchasing Management is normalized, systematized and being scientific.(3) Analyzed the mode of purchasing analysis at home and abroad, pointed out it is necessary to building the analysed indicators. Proposed the source of data and data conversion role, studied the data model of purchasing logical and the policy of data update etc, bring out the indicators of analysis detail designe, and an indicators has been designed which work as being calculative.(4) The Analysis System of Purchasing Management is designed by the thinking of modular design and prototyping, coded by Oracel datebase,PL/SQL, and tested. |