I'm bringing data from a database every 1 minuite.
Data is three kinds.
Data type is
1. 2013-02-01 13:12:01;i;OS0001; ~~~
2. 2013-02-01 13:12:04;d;OS0001; ~~~
3. 2013-02-01 13:13:06;u;OS0001;~~~
=> "i" is insert, "d" is delete.
, "u" is update, OSC001 is PK.
Can you calculate in case "d" data comes "i" next time?
Streamstats is your friend for comparing events with their predecessor.