[Freebase-discuss] MQL source code (Walker, Travis)

[Walker, Travis]

Hi Roland/All,

I actually did not receive Kurt's reply.  Kindly send my way if it was an intended reply to my email.  I became fond of MQL after only a few hours of using it and I agree that it's valuable for AJAX applications.  I had considered at one point writing my own MQL service on top of the data dumps.  I would be happy to further discuss this with you outside of the mailing list.

To extend my question/request to the list - is there any implementation, quadruple -> sql, or otherwise, that is available to external developers?  How does freebase do it today and can others replicate it easily?

Thanks again,
Travis

-----Original Message-----
From: Roland Bouman [mailto:roland.bouman at gmail.com] 
Sent: Wednesday, March 23, 2011 9:14 PM
To: Freebase.com discussion list
Cc: Walker, Travis
Subject: Re: [Freebase-discuss] MQL source code

Hi Travis, Kurt

I wrote mql-to-sql. The current implementation is very crude, and not much more than a proof of concept.

I should mention that the purpose of mql-to-sql is not to emulate freebase with a RDBMS - it is more a matter of trying to offer MQL instead of SQL on typical traditional OLTP RDBMS schemas.
I just think that MQL - although it was designed for freebase - is a very nice language in its own right, and I think it could serve really nicely as a generic data access layer for typical RDBMS schemas, offering many benefits over SQL, especially for AJAX application developers.

The mql-to-sql project is there to experiment with that thought, and hopefully to attract other developers that would  like to work on this.

I have been experimenting too with importing the entire freebase dataset (or at least, what is in the quadruples dump) into a RDBMS.
I think his may not interest everybody on this list, but if you like discuss this feel free to email me at roland.bouman at gmail.com.
I'm happy to share all that I found out.

Unlike Kurt I'm not sure yet whether a MQL implementation on top of a RDBMS could be successful to query all of the freebase dataset.
I do think there are many queries that perform well on freebase/mql that would pose a serious challenge to a RDBMS-based implementation (that is, FWIW, the implementations that I envision)

I have not (yet) taken the path suggested by Kurt to load it in a tuple store.
I think this approach could work and I'd be interested to hear your experience with this should you try that method.

thanks, and kind regards,

Roland.


On Thu, Mar 24, 2011 at 12:42 AM, Walker, Travis <travis.walker at teamaol.com> wrote:
> Hello,
>
> This is my first post so apologies if this is not the proper venue for 
> my question.
>
> Does anyone know where/if I can get my hands on the actual MQL 
> implementation code (or binary) that is used to power the online 
> freebase MQL API?  The closest thing I could find was mql-to-sql 
> http://code.google.com/p/mql-to-sql/ -  I would use this but it looks 
> like it requires a custom mapping and I'm really interested in the 
> entire freebase corpus from the data dump.
>
> My goals are as follows:
>
> 1) Download the freebase data dump -
> http://download.freebase.com/datadumps/latest/
> 2) Load into mysql
> 3) Install a MQL (mqlread) service locally
> 4) Use it for an internal project ;)
>
> Any suggestions?
>
> Best,
> Travis Walker
>
>
>
>
> _______________________________________________
> You are receiving this message because you are subscribed to the 
> Freebase-discuss mailing list.
> To post a message to the list: Freebase-discuss at freebase.com To 
> unsubscribe, view archives, etc:
> http://lists.freebase.com/mailman/listinfo/freebase-discuss
>



--
Roland Bouman
blog: http://rpbouman.blogspot.com/
twitter: @rolandbouman

Author of "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL",
http://tinyurl.com/lvxa88 (Wiley, ISBN: 978-0-470-48432-6)

Author of "Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration", http://tinyurl.com/33r7a8m (Wiley, ISBN: 978-0-470-63517-9)