基于InTouch组态软件的报警存储与事件记录

Based on InTouch Software Record Alarm and Event

完成历史报警数据的记录功能是组态软件非常重要的功能,通常需要软件本身的控件来完成报警数据和事件的存储到外部数据库中的过程。本文分析SQL SERVER、My SQL、Access以及MSDE四种中小型数据库的区别,且以MSDE2000为例,通过InTouch软件中的Alarm DB Logger实用程序,将历史报警和事件数据存储到MSDE2000数据库中,结合Alarm DB Purge-Archive实用程序,完成历史报警与事件记录的手/自动清除与归档操作,归档后的数据可以通过Alarm DB Restore进行恢复。

Logging the historicalalarm database is critical. Normally, need the software component to store the alarm data and events to the extended databases. This paper analyzes the differences of four kinds of small and medium-sized databases： SQL SERVER, Access, My SQL and MSDE.Taking MSDE2000 as an example, recording the alarms and events to MSDE2000 database with the Alarm DB Logger in InTouch,manually/automatically clearing and archiving with Alarm DB Purge-Archive.The archived data can be recovered through the Alarm DB Restore.