摘要
在传统的应用中,客户端从数据库拉取数据。在实时性较强,数据更新周期较长的应用中,一般采用短时间间隔的轮询方式,增加了数据库端的负担。利用数据库的触发器调用CLR存储过程或者扩展存储过程,配合MSMQ的消息传递能力,可以实现数据库推送数据的服务。
In traditional applications, clients pull data from a database. In a application that need a real-time processing and the database update cycle is a very long time, generally a short interval of polling which increase the burden on the database side is used. Using database triggers, CLR stored procedure or extended stored procedure, with the MSMQ messaging capabilities, a database push data service is implemented.
出处
《电子设计工程》
2011年第21期50-52,共3页
Electronic Design Engineering
