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.

  1. insert object tree temporary in table in database, , run stored procedure historical analysis.

  2. 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

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -