[redland-dev] dbpedia + redland basics

[Andrew (Chuan) Khoo]

Thanks for the fast reply Gregory,

rdfproc works, and is now busy parsing articles_label_en.nt. it's  
taking quite some time though, and i'm not looking forward to when i  
parse one of the larger datasets, but I definitely see the tables  
slowly populating in mysql administrator.

once i get everything i want parsed i'll give your second part of the  
rdfproc instructions a whirl and see how it works.


a question for those who are using the redland php api: how do i apply  
the php binding so that my php code can call the rdflib functions? do  
i add something in php.ini? the redland-1.0.7-bindings created a  
'redland.bundle' file in my /usr/lib/php/extensions folder.


Cheers,
Andrew

On Mar 2, 2008, at 11:25 AM, Gregory Williams wrote:

> On Mar 2, 2008, at 9:36 AM, Andrew (Chuan) Khoo wrote:
>
>> So, to list down my questions:
>> 1) How do I import .nt data into mySQL?
>> 2) If there is code provided to parse the data into the mysql  
>> store, how do I compile and run it?
>
> rdfproc should be able to do this for you. For example, using the  
> geo coordinates data:
>
> rdfproc -n -s mysql -t  
> "host='localhost',database='test',user='test',password='test'"  
> dbpedia parse geo_en.nt ntriples
>
> This will create a model named "dbpedia" in the "test" database. For  
> future data loading, you'll want to drop the "-n" argument so that  
> you're not creating a new store (and deleting what you've already  
> loaded) on each command.
>
>> 2) How do I call SPARQL queries (using rasqal?) from php?
>
> On the command line, you can again use rdfproc:
>
> rdfproc -s mysql -t  
> "host='localhost',database='test',user='test',password='test'"  
> dbpedia query sparql - "SELECT * WHERE { ?thing a <http://dbpedia.org/class/yago/landmark 
> > }"
>
> This is also possible through the PHP bindings, but someone else  
> will have to comment on the exact APIs to use.
>
> hope that helps,
> .greg
>
> -- 
> "Turns out the Z-machine (yes, the engine that does Zork) has
> continuations. Who'd've thunk it? Not only are we 30 years behind  
> Lisp,
> we're 25 years behind text adventure engines..."    - Dan Sugalski
>