Exploiting databases in an Event-based infrastructure just got easier…

Reading Time: < 1 minute

… with the announcement that Oracle is now shipping, in Oracle 11g, an enhanced notification mechanism for its continuous query support. This has potential to replace the tedious notions of database triggers and polling mechanisms with a “registered query” that could invoke a Java stored procedure. Through this it can propagate the “data update event” beyond the database and into the event processing world. Thanks to Oracle’s EPTS contributor Dieter Gawlick for this tip at last week’s DEBS09.

Note that Oracle databases are often used as the “backing store” for TIBCO BusinessEvents‘ distributed event store, from which one can run TIBCO Spotfire analytics etc. For some customers (i.e. those without low latency requirements), this backing store can also be used directly as the event store…