A flexible and recoverable client/server database event notification system

  • Authors:

  • Eric N. Hanson;I.-Cheng Chen;Roxana Dastur;Kurt Engel;Vijay Ramaswamy;Wendy Tan;Chun Xu

  • Affiliations:

  • CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu;CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu;CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu;CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu;CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu;CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu;CISE Department, University of Florida, Gainesville, FL 32611-6120, USA/ e-mail: hanson@cise.ufl.edu

  • Venue:
  • The VLDB Journal — The International Journal on Very Large Data Bases
  • Year:
  • 1998

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.