Our application uses values and ranges as data. Our records are in the form:
non-uniq-key start finish payload

We are constantly having to do the following operations:

1. new instance comes in.
2. load all non-uniq-key entries from database.
3. add db records to merger class.
4. add new instance (from 1) to merger class.
5. do merge. Some instances will have some of there values changed and some will be deleted if they are aligned or overlapping.
6. delete all instances in db for non-uniq-key.
7. add instances from the merge.
8. commit

As you can see this is a bit of a mouthful. Please can someone give me a couple of pointers and a bit of help on how to set about achieving this. I'm having particular trouble telling hibernate that everything in this list represents all instances of non-uniq-key and anything not in this list should be deleted.

Is this even possible?