Hi,
I have objects in my database, and they have an object id generated with
a sequence. Then I have object versions. The ids of object versions need
to be unique only within one object id. But for simplicity they're
generated with a sequence, too.
Now I want to reference an object version. I can use just the object
version id, because it "happens" to be globally unique. Conceptually
though, I should use the object's id and its version's id.
Now redundancy is Not Good™, so I wonder which way is the Right One™.
I understand that both ways work and that the variant with just the
object id is probably both faster and smaller.
I'd be thankful for enlightenment :)
--
Markus Bertheau <twanger(at)bluetwanger(dot)de>