基于存储过程和HTTP协议的消息主动推送系统实现  

Implementation of Message Push System Based on the Stored Procedure and HTTP Protocol

作　　者：夏凌云[1] 龚文涛[1] 

机构地区：[1]中国石油大学(华东),网络及教育技术中心,青岛266580

出　　处：《微型电脑应用》2016年第11期66-68,共3页Microcomputer Applications

摘　　要：数据库中的存储过程和触发器多用于数据完整性检测和复杂规则约束,其提供了一个当数据表数据发生变更后的主动操作机制,Oracle数据库还提供了UTL_HTTP包来实现数据库对外部WEB服务器的主动访问。利用这两个特性,可以在数据发生变化的时候主动地将变化内容及时传输给外部业务服务器,再通过业务服务器发送给相应的业务人员,以此避免外部业务系统主动和频繁读取数据库服务器,提高系统消息发送效率,降低系统查询负担。Stored procedures and triggers in database are formerly used for data integrity checking and complex rule restriction, they also provide an actively operating mechanism when the data change in the database table. Oracle Database also provides UTL_HTTP package to achieve the access from database to external WEB server. Using these two characteristics, it can send the changing data to an external service server initiatively and promptly, and then sends the message to the appropriate user through the service server. Thereby avoiding external service systems avoid frequent reading the database server initiatively, it improves messaging system efficiency and reduces the burden on system queries.

关 键 词：存储过程 触发器 消息推送 ORACLE UTL_HTTP 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]