一种基于触发器的数据管理方法的设计与实现

为了方便、高效地管理RT21-ISCS综合监控系统的各项数据,保证数据的一致性和完整性,针对轨道交通综合监控系统的特点,通过对oracle触发器的合理设计,实现了一种基于模型的数据管理方式.触发器不但处理了各等级模型数据间的复杂逻辑,同时通过定义同步机制,实现了系统内实时数据库与历史数据库的同步,使客户端可以直接访问实时数据库,以提高系统的响应速度和处理能力.

Design and Implementation of Oracle Trigger-based Data Management Method

For conveniently and efficiently managing the dada of RT21-ISCS＇ s monitoring system and ensuring their consistency and integrity,and considering the characteristics of this monitoring system,a model-based data management method was proposed through rational design of the trigger.The oracle trigger can process the complex logic among different model data and meanwhile,it can synchronize the real-time database and historical database in the system with the help of synchronization mechanism so that the clients can access real-time database and the response speed and processing capacity of the system can be improved.