Hello Bryan,

I guess you already noticed that unfortunately there is no easy way of
importing DBpedia rdf data
into Virtuoso, at least it needs some care. I didn't try to import the
last version 3.8 yet but there are some things that you can try.

There is a more up to date blog post by the same author with DBpedia 3.7:
http://joernhees.de/blog/2012/05/25/setting-up-a-local-dbpedia-3-7-mirror-with-virtuoso-6-1-5/
To reach your aim you should care for every described step and check if
the problem still exists
with your Virtuoso version / DBpedia version / in your DBpedia language.

Some things to check in your case:
1) It seemed you tried to import file "contents-nq.txt". This file just
contains the urls of the DBpedia data files, that you need to download
first.
If sth. went wrong use
delete from DB.DBA.LOAD_LIST;
to clean the load list again.

2) Are you sure you want to import nq files? They contain the format (s p
o i) with i representing provenance information. Virtuoso creates
different graphs for each i. If you don't need this data, just use nt
files and specify a single graph "http://dbpedia.org"; within the
ld_dir_all command like described in the blog post.

3) The block post states that Virtuoso can only import plain
(uncompressed) or gzipped files. Maybe that's the reason for your
undefined namespace prefix error when trying to import a bzipped file.

Benjamin

(PS: I forgot to cc my mail some hours ago to the virtuoso-list)

Am 06.02.2013, 11:58 Uhr, schrieb bryan rasmussen
<[email protected]>:

> Hi,
>
> I am still struggling with getting dbpedia (the danish version
> downloadable here http://downloads.dbpedia.org/3.8/da) into virtuoso
>
> I followed the tutorial out here
> http://joernhees.de/blog/2010/10/31/setting-up-a-local-dbpedia-mirror-with-virtuoso/
> - although on windows.
>
> After I do the select from my load list to check how it went I get:
>
> 1 Rows. -- 31 msec.
> SQL> SELECT * FROM DB.DBA.LOAD_LIST;
> ll_file
>   ll_graph
>     ll_state    ll_started           ll_done              ll_host      
> ll_work_ti
> me  ll_error
> VARCHAR NOT NULL
>   VARCHAR
>     INTEGER     TIMESTAMP            TIMESTAMP            INTEGER      
> INTEGER
>   VARCHAR
> _______________________________________________________________________________
>
> E:\dbpedia\dk/contents-nq.txt
>   http://da.dbpedia.org
>     2           2013.2.6 11:43.7 0   2013.2.6 11:43.8 0   0            
> NULL
>   37000 SP029: TURTLE RDF loader, line 1: Undefined namespace prefix at  
> http://d
> ownloads.dbpedia.org/3.8/da/article_categories_da.nq.bz2
> E:\dbpedia\dk/global.graph
>   http://da.dbpedia.org
>     2           2013.2.6 11:43.7 0   2013.2.6 11:43.8 0   0            
> NULL
>   37000 SP029: TURTLE RDF loader, line 1: Undefined namespace prefix at  
> http://d
> a.dbpedia.org
>
> 2 Rows. -- 47 msec.
> SQL>
>
>
> Any suggestions, anywhere I can go ask if not here?
>
> Thanks,
> Bryan Rasmussen
>
> On Wed, Feb 6, 2013 at 2:18 AM, bryan rasmussen
> <[email protected]> wrote:
>> Hi,
>> I'm trying to import the danish dbpedia, I do the following in isql:
>>
>> DB.DBA.TTLP_MT(file_to_string_output('E:\\dbpedia\\dk\\category_labels_da.nq\\category_labels_da.nq'),
>> '', 'http://localhost:8890/DAV/dbpedia/dk', 512);
>>
>> The data is of the format:
>>
>> <http://da.dbpedia.org/resource/Kategori:Tal>
>> <http://www.w3.org/2000/01/rdf-schema#label> "Tal"@da
>> <http://da.wikipedia.org/wiki/Kategori:Tal?oldid=6062900> .
>> <http://da.dbpedia.org/resource/Kategori:Tidsperioder>
>> <http://www.w3.org/2000/01/rdf-schema#label> "Tidsperioder"@da
>> <http://da.wikipedia.org/wiki/Kategori:Tidsperioder?oldid=5757820> .
>> <http://da.dbpedia.org/resource/Kategori:Kemi>
>> <http://www.w3.org/2000/01/rdf-schema#label> "Kemi"@da
>> <http://da.wikipedia.org/wiki/Kategori:Kemi?oldid=6045968> .
>>
>> and so on and so forth.
>>
>> sparql select * from <http://da.dbpedia.org/resource/Kategori> where  
>> {?s ?p ?o};
>>
>> and I get
>> The statement execution did not return a result set.
>>
>> I also tried to use the quad store upload and it told me
>>
>> You have attempted to upload invalid data. You can only upload RDF,
>> Turtle, N3 serializations of RDF Data to the RDF Data Store.
>>
>> So -
>>
>> 1. I would like to upload the data - at least in some cases - for
>> example for demo purposes, is there any tool anyone knows of that can
>> change dbpedia extracted data into a format that virtuoso will accept
>>
>> 2. how do I write the query above so that I can get some data out?
>>
>> Thanks,
>> Bryan Rasmussen
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to