Probably not useful for your problem now, but some databases can do RPR (Row Pattern Recognition) which seems to be able to do such things. (it's in the pipeline for postgres. You use Netcool -> IBM -> DB2? Alas, I don't see it in DB2 either.)