触发器技术在古树名木信息动态监管中的应用

摘要

In order to strengthen the monitoring and management for dynamic information of ancient and famous trees, it is necessary to use the database and the current mainstream programming language to develop appropriate management information system. The attribute database of ancient and famous trees is designed, and most importantly, the design process of three main triggers is described. Through the application of the trigger, the historical data record is automatically saved about the growth process and conservation information of ancient and famous trees, and the death information is also automatically updated. The application of the trigger not only ensures the consistency of data, but also reduces the workload of programming applications.%为加强古树名木信息的动态监管,采用数据库及当前主流编程语言开发相应管理信息系统是必须的.设计了金华市古树名木属性数据库,重点叙述了数据库中3个主要的触发器的设计过程.通过触发器的应用实现了古树名木生长情况及养护记录的历史数据的自动保存以及死亡情况的自动更新,保证数据间的一致性,同时还减少应用程序的编程工作量.