[Developers] [Data-modeling] is everyone married to themselves?

Daniel E. Renfer duck at kronkltd.net
Wed Dec 19 03:12:30 UTC 2007


David Huynh wrote:
> Alexios Zavras wrote:
>   
>> As someone who has once delved into the intricacies
>> of time-ranges in databases, I must warn that this is
>> a slippery path.
>>
>> I don't know about American constitution rules,
>> but can a person be President for two non-consecutive terms ?
>> In that case, there is no single "start-of" and "end-of".
>>
>> I know it can happen with marriages:
>> As the most famous example I can think of,
>> asnwer "Did Liz Taylor receive an award while being married
>> to Richard Burton ?"
>> >From wikipedia, they were married in the intervals
>> (March 15, 1964 - June 26, 1974) *and*
>> (October 10, 1975 - July 29, 1976).
>>
>> How do you model that ?
>>
>>   
>>     
> You could model the marriages and the job positions as independent 
> objects (reification in RDF).
>
> David
Marriages are already done like that. (/people/marriage)

It seems like the presidential schema is a little lacking. The US
President type should hold references to a CVT that contains the
presidential number, the from and to dates, and the vice president(s).

If you model it like that, then it would be easy to fully model Grover
Cleveland's[1] presidencies.

[1]: http://www.freebase.com/view/grover_cleveland

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebase.com/pipermail/developers/attachments/20071218/1fdd9935/attachment-0001.pgp 


More information about the Developers mailing list