一种基于双历史站的数据库存储结构的设计与实现  

The design and implementation on the data storage structure based on the double history station

作　　者：荆俊峰 房志奇 刘凯 靳书云 Jing Junfeng;Fang Zhiqi;Liu Kai;Jin Shuyun(The 6th Research institute of China Electronics Corporation,Beijing 100083,China)

机构地区：[1]中国电子信息产业集团有限公司第六研究所,北京100083

出　　处：《电子技术应用》2023年第5期82-87,共6页Application of Electronic Technique

摘　　要：在DCS系统中,历史站承担着历史数据的收集、存储以及查询功能,而实时和历史数据库存储结构的设计则是组态软件的核心技术。设计了一种基于双历史站的实时和历史数据库存储结构的设计和实现方法,分别介绍了系统体系设计、数据采集、实时数据数据库设计、历史数据库设计、数据同步策略、历史数据库对外接口等。该系统实时性高、存储空间节约、查询速度快,已经广泛应用于多个领域的工业控制系统。The history station undertake a task of collecting,storing and querying in the DCS(distributed control system),moreover the real time database and history database are key technology in the configuration software.In this paper,a design way of the real time database and the history database based on the double history station is studied.It introduces the general structure of the distributed control system,the data acquisition,the memory structure design of the real time database,the design of the history database,the synchronization policy,and the extern interface of the database.The database system has been widely applied to the multiple fields of the industrial control,which has the characteristics of high real-time performance,less storage space and fast query.

关 键 词：历史站 DCS系统 Tag点 同步 组态软件 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]