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.
