Research And Application Of Parallel Coal Enterprise Reserve Quta Algorithm On Hadoop Platform

The success of a coal group company has introduced the SAP ERP (EnterpriseResource Planning) system, the use of ERP system brings to the Enterprise advancedmanagement concept, construction completed a complete Enterprise informationmanagement system and high efficient and convenient information technologyplatform.However, the above analysis and calculation of the ERP system in the function ofthe spare parts reserve quota focus on machinery manufacturing and other spare partsconsumption regularity strong industry, to spare parts, such as coal mining enterprises ofconsumption demand change, don’t so we developed for its spare parts reserve quotasystem to manage the spare parts information, to assist business personnel spare partsprocurement plan, automatically prompt required order spare parts, etc.But, with the use ofsystem, some problems also followed exposed.If reserve quota system for dailyconsumption of a small amount of spare parts do prediction can be done in a relativelyshort period of time is very good, you need to do for the second half of the years order planor order plan for the coming year, because of the spare parts warehouse huge (nowcommonly used spare parts, there are more than290000history in inventory record datamore), do to spend a long time when forecasting,Other spare parts reserve quota in themodel used to determine the minimum storage of margin coefficient, which is used tomake up for the spare parts according to use historical data to predict the consumptionforecast deviation.Margin coefficient in the original system is not according to the ordercycle of production plan, this time of year spare parts consumption, factors such as thesupply of spare parts, spare parts service life is comprehensive, but independent selectedvalues, subjective factors is very large, so influence the accuracy.So how to effectivelycalculate the forecast order plan, and puts forward a margin coefficient determinationmethod is to solve the problem of this article.As Hadoop cloud computing platform used in the fields of good to its mass datastorage and parallel computing ability, this to solve the problem in this article, a large number of spare parts consumption forecast provides a new solution, in this paper, basedon the Hadoop cloud computing platform of the spare parts consumption forecastsystem.The system is divided into data acquisition module, data storage module, datapreprocessing module and the spare parts consumption forecast module four parts.Amongthem, the data acquisition module using a coal group company ERR system Web Serviceinterface to get the user data;Data storage module, data acquisition module of spare partsaccording to the design of data format into a local Oracle database;Data preprocessingmodule for processing spare parts data in the database, we need the data format ofdata;Spare parts consumption prediction module for consumption forecast of probabilityand statistics analysis method was improved, and graphs are designed and implemented onthe graphs parallel programming model.For margin coefficient is proposed combined withthe fuzzy mathematics theory and fuzzy comprehensive evaluation method, based onmathematical model for the evaluation of capital takes up and key spare parts and get theallowance coefficients.