[Developers] Loading Freebase into a Star Schema

[Shawn Simister]

Great work Paul,

This is one of those things that I always figured should be possible but 
I had no idea it would take so much time and effort to load the data. It 
certainly gives me a new appreciation for all the work that the Metaweb 
folks do to return my long, complicated MQL queries at reasonable 
speeds. Thanks for working through the hard parts for us and documenting 
your process so clearly.

Shawn

Paul Houle wrote:
>     I recently,  with some effort,  managed to load the Freebase January 
> 2009 database into a Star Schema.  Loading the 241 M facts took about a 
> week with a seriously untuned system.  Here's an article about the results:
>
> http://gen5.info/q/2009/02/25/putting-freebase-in-a-star-schema/
> _______________________________________________
> Developers mailing list
> Developers at freebase.com
> http://lists.freebase.com/mailman/listinfo/developers
>