One method of event processing

There is one pretty common and widely used approach how to process events in Oracle applications. Publisher INSERTs one row per event into the EVENTS table and Subscriber reads this table, processes the events and DELETEs the corresponding rows. But what if from one hand Publisher inserts events very frequently and you are interested in only last event from another hand. Also there is one additional assumption: the number of different events is relatively small. In this case we can replace INSERT operation to UPDATE with timestamp or event version.
Here I’ll describe this method with examples.

Advertisements
One method of event processing