Oracle数据表更新即时通告的实现方法

摘要

The database table update notification is a universal application, but it is difficulty to ensure the timely notification, stable, reliable, and the relation technology is also more extensive. Through the comparative analysis of several feasible schemes, adopts technology of named pipes and real-time signal mechanism to design and realize this system. In the software architecture, fully considers the possibilities of the large amount of data update and data for the different processing, so software logic uses three layer design, to ensure the scalability of the application system, but also brings convenience for flexible excellent physical deployment software.%数据库表更新通告是一个很普遍的应用，但要保证通知的及时、稳定、可靠，开发还是有一定的困难，涉及技术也比较广。通过分析对比多个可行方案，采用命名管道和实时信号机制技术来设计实现这一系统。在软件架构方面充分考虑到大量数据更新和数据需不同处理的可能性，软件逻辑上采用三层设计，保证系统应用的可扩充性，同时也为软件的物理部署带来极好的灵活方便性。