[Data-modeling] Intervals as a primitive data type
John Giannandrea
jg at metaweb.com
Sat Feb 21 23:32:18 UTC 2009
Tom Morris wrote:
> There are a bunch of types with intervals specified using individual
> properties like start_date/end_date, birth_date/death_date, etc. If
> these were encoded using a single property with an datetime_interval
> as the type, they could be manipulated and compared much more
> directly.
There is a type, /measurement_unit/time_interval which can be used for
this.
For example http://www.freebase.com/type/schema/spaceflight/rocket_engine
uses it.
The tradeoff seems to be whether it makes a type more or less
accessible to have specific properties (like date_of_death) or a
standard encoding which is one ply further out (a CVT).
In the case of date_of_death, that property is actually on a different
type than the birth which complicates things further.
I agree with you that if there was a standard way to encode a range
then the query language (and filter UI) could do smarter things with
ranges.
Perhaps what we really need is a way of having the 'friendly'
properties 'reach into' a more normative form which standardizes on
time_interval.
-jg
More information about the Data-modeling
mailing list