A flexible and recoverable client/server database event notification system

• Published in: The VLDB journal Vol. 7; no. 1; pp. 12 - 24
• Main Authors: HANSON, E. N, CHEN, I.-C, DASTUR, R, ENGEL, K, RAMASWAMY, V, WENDY TAN, CHUN XU
• Format: Journal Article
• Language: English
• Published: Heidelberg Springer 01.02.1998
• Subjects: Applied sciences; Computer science; control theory; systems; Computer systems and distributed systems. User interface; Exact sciences and technology; Information systems. Data bases; Memory organisation. Data processing; Software; Software engineering; Client server application; System architecture; Query language; Database query; Program library; Database; C++ language; Distributed system; Computer server; Database management system; Software engineering
• ISSN: 1066-8888; 0949-877X
• DOI: 10.1007/s007780050051

A software architecture is presented that allows client application programs to interact with a DBMS server in a flexible and powerful way, using either direct, volatile messages, or messages sent via recoverable queues. Normal requests from clients to the server and replies from the server to clients can be transmitted using direct or recoverable messages. In addition, an application event notification mechanism is provided, whereby client applications running anywhere on the network can register for events, and when those events are raised, the clients are notified. A novel parameter passing mechanism allows a set of tuples to be included in an event notification. The event mechanism is particularly useful in an active DBMS, where events can be raised by triggers to signal running application programs.