基于数据挖掘和ERP技术的电力工程数据信息库设计  

Design of power engineering data information base based on data mining and ERP technology

作　　者：赵水忠 王一杰 杜亮 吕晓俊 ZHAO Shui-zhong;WANG Yi-jie;DU Liang;LV Xiao-jun(Material Branch,State Grid Zhejiang Electric Power Co.Ltd.,Hangzhou 310000,China)

机构地区：[1]国网浙江省电力有限公司物资分公司,浙江杭州310000

出　　处：《电子设计工程》2020年第5期107-111,共5页Electronic Design Engineering

基　　金：国网浙江省电力有限公司2018年科技项目(B32)。

摘　　要：针对现有数据信息库储存和处理大规模非结构化数据效率低下的问题,结合电力工程信息数据处理的实际需求,文中提出了一种基于数据挖掘和ERP技术的电力工程数据信息库设计方案。方案分别采用3层物理架构以及基于B/S的3层软件架构实现信息库的架构设计,并用Mysql建立了电力工程数据信息库。进一步分析了ERP数据挖掘系统的模块功能,分别设计了ERP技术模块以及数据挖掘模块的架构,并给出了基于灰色关联分析的数据挖掘算法原理。通过对系统响应时间及大规模访问量下的CPU占用率进行的评估结果表明,并发人数急剧增长至500人次,静态页面响应时间小于3 s,可以满足电力工程高峰时段的需求。Aiming at the inefficiency of existing data repository storage and processing large scale unstructured data and the actual requirements of power engineering information data processing,this paper proposes a power engineering data repository design scheme based on data mining and ERP technology.The three layer physical architecture and the three layer software architecture based on B/S technology are used to realize the technical architecture design of the information base,and the power engineering data information base is established based on Mysql.This paper further analyzes the module functions of ERP data mining system,designs the architecture of ERP technology module and data mining module respectively,and gives the principle of data mining algorithm based on grey relational analysis.In addition,this paper evaluates the system response time and the CPU usage under large scale access.The test shows that the number of concurrent users has increased sharply to 500,and the static page response time is less than 3 seconds,meeting the peak demand of power engineering.

关 键 词：非结构化数据 数据挖掘 ERP技术 B/S技术 

分 类 号：TN91[电子电信—通信与信息系统]