Real-Time Aggregation of Streaming Data

[frankienle at juno.com]

This may be pushing it but I think Revolution should be able to handle this!?

I have a cmd line application (old) that outputs to stdout on Unix system. 

It produces 10 comma delimited variables at approximately 80 lines per minute.

I can already redirect it into a scrollable field in revolution.

What I want to do is to able to aggregate that stream in as near real time as possible based on two of the fields the user has preselected. I then want to sort the list based off the aggregated fields from the largest to smallest.


Input Example (4 variables) - First line always has the field titles
Make,Color,MPG,Miles
volvo,red,30,200
ford,blue,25,125
ford,green,40,145
volvo,red,20,78
GM,blue,120,500
volvo,red,24,134
volvo,yellow,45,120

Output Example One
Aggregated (user selected Make - aggregation is MPG )
GM,blue,120,500     #GM is number 1 since it has the current highest MPG value
volvo,yellow,119,532    #the last color of the make is reflected and both numeric fields are aggregated
ford,green,65,270

If by Make and Color then volvo and ford  would have two lines.

Given the data amount and its speed which it arrives what is the best way for  Revolution to handle it? In an array, in a list with screen refresh selection, a temp file?

thank you in advance for any insight and wisdom

Fran


________________________________________________________________
The best thing to hit the internet in years - Juno SpeedBand!
Surf the web up to FIVE TIMES FASTER!
Only $14.95/ month - visit www.juno.com to sign up today!