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

[Jeff Prucher]

> -----Original Message-----
> From: developers-bounces at freebase.com 
> [mailto:developers-bounces at freebase.com] On Behalf Of Daniel E. Renfer
> Sent: Tuesday, December 18, 2007 7:13 PM
> To: For discussions about MQL,Freebase API and apps built on Freebase
> Subject: Re: [Developers] [Data-modeling] is everyone married 
> to themselves?
> 
> 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
> 

Actually, this is possible using the current schemas. The to and from dates
(plus some other information) are stored in a CVT, but one that connects to
the type "politician" rather than "US president).  All US presidents should
also be typed as politicians, although most aren't currently (this is a
migration task we're working on, though).  Visit the page for Grover
Cleveland again, to see how it works.

Jeff