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.

One method of event processing

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s