基于关系数据库的加气站SCADA系统数据存储方案  

Data Storage Schema of Gas Station SCADA System Based on Relational Database

作　　者：钟杰 谢涛 

机构地区：[1]重庆耐德自动化技术有限公司,重庆两江新区401121

出　　处：《自动化与仪器仪表》2017年第11期171-173,共3页Automation & Instrumentation

摘　　要：加气站SCADA系统产生的设备工况数据量非常大,若以常规的关系型数据库单库单表方式直接存储,会对数据库服务器造成非常大的压力,读写数据会导致磁盘I/O响应延迟甚至假死。本文研究并提出了一种基于关系型数据库的分布式存储方法,能够支持大规模的工况数据存储,并能快速响应对数据的查询请求。Because the gas station SCADA system produces a very large amount of equipment production data, so if a relational database used to storing these data, the database server will be very stressed. Reading or writing data will cause the I/O response of the disk delay or even death. In this paper,a distributed storage method based on relational database is studied and proposed. It can support large-scale production data storage, and can quickly respond to query requests.

关 键 词：加气站 SCADA 关系数据库 分布式 

分 类 号：TP311.5[自动化与计算机技术—计算机软件与理论]