The moose likes Object Relational Mapping and the fly likes Historical records and filters Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Java » Object Relational Mapping
Reply Bookmark "Historical records and filters" Watch "Historical records and filters" New topic
Author

Historical records and filters

Avner Levy
Greenhorn

Joined: Feb 28, 2010
Posts: 2
posted private message
Quote
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

Joined: Feb 05, 2001
Posts: 16356

I like...
IntelliJ IDE Mac Spring
posted
Quote
Please check your Private Messages for an important JavaRanch message.

Thanks

Mark

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
 
subject: Historical records and filters
 
developer file tools