论文部分内容阅读
WDS9002水调自动化系统大量使用于全国各大电网公司和水电厂。该系统在测点实时数据表(RT)上采用ORACLE的插入和修改触发器,将测点的最新一条实时数据插入和修改到断面数据表(REAL),保证REAL中存放的是各测点的最新数据。当某测点的某条实时数据记录在RT中被删除时,自动判断该条数据是否存在于REAL中,如果存在则应该用该测点次新记录更新REAL。如何在删除RT时同步REAL成为一个技术难点。本文针对该问题对解决方案作了详细描述,希望对有类似应用需求(即在ORACLE触发器内需要保留基表操作数据,提供给后续应用使用)的用户提供一个解决问题的思路。
WDS9002 water conditioning automation system used extensively in the country’s major power grid companies and hydropower plants. The system uses the insertion and modification trigger of ORACLE on the real-time data table (RT) of the measuring point to insert and modify the latest real-time data of the measuring point into the data table (REAL) of the section to ensure that REAL stores the data of each measuring point The latest data. When a measuring point of a real-time data record is deleted in the RT, automatically determine the data is present in the REAL, if there should be updated with the test point record REAL. How to synchronize REAL when RT is deleted becomes a technical challenge. In this paper, a detailed description of the solution to the problem, hoping to have similar application requirements (that is, in the ORACLE trigger need to retain the base operating data provided for subsequent use) to provide users with a solution to the problem.