sql - Historical Data and modified objects -
my application receives object trees jms topic, , must persist objects have changed historical purposes.
if, example, receives object tree objects a, b, c (which exist in database according ids) in hierarchical order (a contains b contains c), object c has changed, object stored in database, creating new entry historical purposes.
what solution best approach? technologies (hibernate, jpa) can me achieving this?
here 2 fundamentally different approaches started.
insert object tree temporary in table in database, , run stored procedure historical analysis.
pull out matching object tree database , determine in code.
the typical depth of tree, whether jms objects result in change, rate @ receive objects, difficulty of how detect change, whether same objects sent repeated or not, things affect best design choice.
after that, should worry technology go with.
Comments
Post a Comment