Tibco Businessworks - In Memory Database

[Russell Bennight]

Hello,

Thank you for reading and for any assistance. I'm new to Tibco BW. In our process, we are pulling messages from a EMS message queue. An example of these messages are below:

EQPID E13ACOX ACTIVITYID EQUIP_START

EQPID D11RCPR1 ACTIVITYID EQUIP_STOP

EQPID E01BFSI ACTIVITYID EQUIP_START

EQPID D10HOTH2 ACTIVITYID FDC_OOC

EQPID B01SSAC2 ACTIVITYID EQUIP_STOP

EQPID E14CAPY ACTIVITYID EQUIP_START

For each EQPID that comes through this queue, I'd like to create a list of with the number of occurrences for each equipment name. I suspect there is a way to do an in memory databases for this I'd like to stay away from a disk database due to the overhead of reading/writing. Any ideas

Thanks in advance!