Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Historical records and filters

 
Avner Levy
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a database design where each time an object (record) is changed I insert a new record with the new data and the previous one is left as is.
The primary key is a regular 64 bit ID (sequence) and in additional I have an object ID (UUID) which is the same in all the object's versions records.
All relations between objects are defined through the Object ID (UUID), that way if some property of an object is changed all relations are still valid.
I've tried to use filters in order to solve one2one and many2one relations between objects but they work only on many2many.
Does anybody has an idea on how this can be solved?
Thanks in advance,
Avner
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please check your Private Messages for an important JavaRanch message.

Thanks

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic