[Developers] Steps Toward a Complete History Export in Freebase

[Tyler Pirtle]

Kurt Bollacker wrote:
> That won't show deleted or updated links.  In fact I think it's
> impossible to get the history without significant post processing of
> MQL results.  I believe there are outstanding bugs related to this.
>
> 								Kurt :-)
>

My dear scientist (and friends)

What we have is this:
>>
>> Here's some MQL that will help:
>>
>> [{
>>    "type":         "/type/link",
>>    "source": {
>>      "*": null
>>    },
>>    "target": {
>>      "*": null
>>    },
>>    "b:timestamp>": "2009-05-29",
>>    "timestamp":    null,
>>    "sort":         "-timestamp"
>> }]
>>
>> K.
>>


This query verges on going all the way. It lacks the magic sauce 
required in the original message to refute the following claims:

> No indication is given of which user made an assertion in that log.   
> Imagine if a bad piece of data is noticed: Freebase holds a unique  
> position to investigate the other changes made by that account.  Thus  
> their ability to reconcile and analyze the corpus is privileged.

As do you my friend!

MQL shares it's secrets with you:

	http://mql.freebaseapps.com/

specifically,

	http://mql.freebaseapps.com/ch03.html#links


It needs to be a little augmented like this:


[{
   "type":         "/type/link",
   "creator": "/user/<username to inspect>",
   "source": {
     "*": null
   },
   "target": {
     "*": null
   },
   "timestamp>=": "2009-05-29T00:00:00Z",
   "timestamp<=": "2000-06-00T00:00:00Z",
   "timestamp": null,
   "operation": null,
   "valid": null,
   "sort":         "-timestamp"
}]

et voila.

Updates, inserts, and deletes, all in a row.

See it happen here:

    http://www.freebase.com/history/view/user/<username>


(The query that this produces is a little more complicated, but this 
will give you the idea).


Kurt, if I missed something, let me know.



T

>>
>> -- 
>> Kirrily Robert
>> Freebase Community Director
>> kirrily at metaweb.com
>> http://freebase.com/
>>
>>
>>
>>
>> _______________________________________________
>> Developers mailing list
>> Developers at freebase.com
>> http://lists.freebase.com/mailman/listinfo/developers
> _______________________________________________
> Developers mailing list
> Developers at freebase.com
> http://lists.freebase.com/mailman/listinfo/developers