| With the depth application of information technology in the power industry, theinformation construction of the power grid company also achieved fruitful results, unifiedplanning and deployment of the National Grid headquarters under construction ERP(Enterprise Resource Planning), planning scheme information management, infrastructuremanagement information systems, production management systems, power transmissionequipment condition monitoring system, scheduling platform and a number of applications,the basic realization of the core business automation and enterprise upstream, midstreamand downstream management process management. Based on the accumulation of theseperfect trading system and trading data, the construction of a decision support system tohelp enterprises to achieve strategic decisions, tactical formulation and battle plans,implementation, monitoring, analysis, adjusted scientific on the growing demand forcorporate profitability and risk prevention urgent, so the company started the constructionproject operator monitoring platform, to make up for the current lack of the company’soperational management system to provide data to support decision-making for thedevelopment of the company.The electric power industry is the industry’s first national economic development.With the rapid development of China’s economy, the huge demand for energy to promotethe rapid development of the power industry, the power system to the development of largecapacity, ultra-high pressure and cross-regional direction. However, with the increase of the system capacity and the expansion of the power grid, power equipment failure to thepeople’s production and modern life brought about by the increasing influence of big.Whom are closely related to the normal supply of electricity, as large as the country’smacroeconomic development, small to the daily life of residents. The usual powerequipment failure process, replacement of spare parts is the most rapid and most effectivesolution. So, for the supply of spare parts management is particularly important in a limitedamount of funds used case, the biggest meet maintenance demand for maintenance spares isan urgent problem.Therefore, based on the above-mentioned problems, the study of the history ofmaintenance spares consumption, use appropriate algorithms to make more accuratepredictions of future demand, thereby increasing the rate of timely supply of spare parts,reduce the number of inadequate maintenance spares, is to reduce the power failuretheimpact of the development of the national economy and people’s daily lives, and will havegreat practical significance.This thesis is the design and construction of the national power grid operator of aprovincial network company monitoring center, based on the theory of data warehousing,data mining, ERP systems, production management systems, power transmissionequipment condition monitoring systems, asset life cycle assessment decisions system andsystem historical data is analyzed, focusing on research and forecast grid maintenance spareparts demand, and thus a rational allocation of resources, improve service quality.System acquisition and maintenance-related data in the existing business systems, datawarehousing, data analysis and the establishment of a data model, data mining. Datawarehouse for the source data is dispersed, heterogeneous mass characteristics, in-depthanalysis of the use of self-built data warehouse model, established analysis topics, the datawarehouse has a comprehensive data base, not only to meet the needs of the statisticalreporting system, and prepare for future deeper application development. Metadatamanagement and ETL rules Informatica manage, collate and analyze practical solutions,has some versatility and can promote the formation of technical documents in the system.In content presentation, the overall design is based on a clear reporting requirements,statistical reports data marts, PC client, large-screen display, and other forms of statementanalysis system.The practice shows that the system is able to predict the demand formaintenance spares, can effectively reduce maintenance spare parts Queliao times in thecase of funds for spare parts occupy the same. Finally a summary of the full text, and data mining research and application in thepower industry direction prospected. |