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

Design and Implementation of Oracle Trigger-based Data Management Method

作　　者：徐漫江[1] 张延盛[1] 陈天皓[1] 

机构地区：[1]国电南瑞科技股份有限公司,南京210061

出　　处：《化工自动化及仪表》2013年第4期512-514,551,共4页Control and Instruments in Chemical Industry

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

关 键 词：综合监控 模型数据管理 ORACLE触发器 数据库同步 

分 类 号：TH865[机械工程—仪器科学与技术]