基于MySQL 5的SCADA海量数据的存储方法研究  

A study of the method to store the SCADA's data of great number based on MySQL5

作　　者：文永亮[1] 孟文[1] 王艳秋[1] 王文玺[1] 

机构地区：[1]西南交通大学机械工程学院,四川成都610031

出　　处：《电力系统保护与控制》2009年第12期76-78,105,共4页Power System Protection and Control

摘　　要：根据工程现场实际应用的需求,提出了一种运用MySQL存储SCADA海量数据的方法。简要介绍了MySQL的特点及其在本文设计中的应用。分析了SCADA数据的结构,并据此设计了数据库结构以及存储方法的方案。在VC++6.0编程环境下实现了该存储方法。通过测试证明该方法运行稳定、可靠,即将投入工程现场应用。According to the requirement of practical project＇s application, a method to store the SCADA＇s data of great number by using MySQL is presented in this paper.It briefly introduces the specialty of MySQL and its application in this design. The structure of the SCADA＇s data is analyzed, and the scheme of database＇s structure and the method to store the data are designed. The method is implemented in the VC＋＋ 6.0 programming environment. Practical testing proves the method can run steadily and reliably, and it will be used in the practical project.

关 键 词：MYSQL SCADA 海量数据 

分 类 号：TP333[自动化与计算机技术—计算机系统结构]