Subscription and notification with database technology

摘要

The present invention teaches in general how to efficiently exploit active database technology and extensible database technology, i.e. triggers and user-defined functions for processing subscriptions. According to a first aspect of the present invention it is proposed to aggregate all subscriptions on a certain table, or more generally of a plurality of tables, into a single trigger on this table or tables, respectively. This will dramatically improve the trigger-based efficiency. According to a second aspect of the present invention it is proposed to deliver the information a subscriber has registered for directly out of the database systems address space via appropriate user defined functions which is another source of efficiency improvement.