>From a user point of view, separate current and historical properties may be more intuitive if there was only one or two of these properties associated with a topic. Any more and it gets pretty clunky. I am a little concerned about data quality if users are required to re-enter data when it shifts from current to historical. <br>
<br>My preference is for a new MQL function that searches for the most recent date (or most recent of start and end dates for time spans that may contain missing data) along with better documentation for how to enter time series data. Recent discussions have highlighted a need for better handling of dated data across the board. However, I'm not the one doing the programming...<br>
<br>-Ed<br><br><br><br><div class="gmail_quote">On Feb 12, 2008 1:32 AM, Robert Cook <<a href="mailto:robert@metaweb.com">robert@metaweb.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I've been working on loading the current CIA World Factbook, and like<br>you I'm convinced that there will ultimately be a lot of utility for<br>properties containing time series values. The real question is what<br>
to do when an API user who wants to see a single value -- the most<br>recent one -- without a complicated query? These two use cases (time<br>series vs. the canonical up-to-date value) are a little at odds, and<br>it seems like there are at least a couple of possible solutions:<br>
<br>1. Create a second time-series property for population. This would be<br>a denormalization, where the most recent value is also copied into the<br>current population property.<br><br>2. Add functionality to MQL to ask for the "most recent" value in a<br>
time series if it's queried as a single value. Of course, MQL would<br>have to know about dated integers and dated floating point values,<br>along with any other dated CVT. There would have to be some<br>additional indicator on the property at the schema level that<br>
indicated it was a time series so that MQL would know when to affect<br>this behavior.<br><br>#1 could be done right now, whereas something like #2 would probably<br>be non trivial. There may be better ideas.<br><br>Do you see a serious problem adding "historical population" on<br>
Statistical Region to hold your time-series data?<br><font color="#888888"><br>R<br></font><div><div></div><div class="Wj3C7c"><br>On Feb 11, 2008, at 9:47 PM, Jeff Thompson wrote:<br><br>> Bryan Cheung wrote:<br>>> The type company currently has properties which have an expected type<br>
>> of money value. However, these are monetary values associated with a<br>>> given point in time. As such, we have modeled a type dated money<br>>> value<br>>> to represent a money value at a specific date. The expected values of<br>
>> the monetary properties of type company should be updated to use the<br>>> type dated money value.<br>>><br>>> * /business/company/net_income<br>>> * /business/company/operating_income<br>
>> * /business/company/revenue<br>><br>> (This is my cue to beat an old horse.) Will you only allow a single<br>> Dated<br>> Money Value to show the net_income for 2008. That is, when we know<br>> the net_income<br>
> for 2009, will you *add* this information to the data for 2008 to<br>> keep the<br>> running history, or will you delete the information for 2008?<br>><br>> I ask because the population property for San Francisco has a Dated<br>
> Integer for 2006<br>> (the most recent census). I add added the census population for<br>> 2000, but someone<br>> deleted it, probably assuming it was a mistake.<br>><br>> - Jeff<br>><br>><br>> _______________________________________________<br>
> Data-modeling mailing list<br>> <a href="mailto:Data-modeling@freebase.com">Data-modeling@freebase.com</a><br>> <a href="http://lists.freebase.com/mailman/listinfo/data-modeling" target="_blank">http://lists.freebase.com/mailman/listinfo/data-modeling</a><br>
<br>_______________________________________________<br>Data-modeling mailing list<br><a href="mailto:Data-modeling@freebase.com">Data-modeling@freebase.com</a><br><a href="http://lists.freebase.com/mailman/listinfo/data-modeling" target="_blank">http://lists.freebase.com/mailman/listinfo/data-modeling</a><br>
</div></div></blockquote></div><br>