Is Oracle AQ/Streams of any use in my situation?

Posted by RenderIn on Stack Overflow See other posts from Stack Overflow or by RenderIn
Published on 2010-03-15T21:16:46Z Indexed on 2010/03/15 21:19 UTC
Read the original article Hit count: 377

I'm writing a workflow system that is driven entirely at each step by explicit human interaction. That is, a task is assigned to a person, that person selects from a few limited options {approve, reject, forward}, and then it is either sent along to the next person or terminated.

Just curious of Oracle Streams/AQ has anything to offer over flat tables managed by regular web application code. The amount of processing after each action is fairly limited and the volume is not terribly high, so there's not really a need to throttle things by throwing them into a queue. What are some of the benefits of introducing a queue structure, or is it overkill for my situation?

© Stack Overflow or respective owner

Related posts about oracle-streams

Related posts about oracle-aq