Hello,
so i'm creating a french version of dbpedia using the
extraction-framework from dbpedia, and I have a problem with inserted
datas which are saved in graph "http://fr.dbpedia.org"; but with sparql
request i can't get the datas:
I created new virtuoso (Version 7.1.0.3207-pthreads as of Apr 4 2014)
database with the following virtuoso.ini
<https://gist.github.com/descl/98bfa481bd3a9d068f1d>.
I installed new version of DBpedia vad for this test.
My extraction files are in /home/extraction-framework/datas/frwiki/20140521
root@ns384501:/home/extraction-framework/datas/frwiki/20140521# ls
frwiki-20140521-article-categories.nt.gz
frwiki-20140521-infobox-properties.nt.gz
frwiki-20140521-redirects.nt.gz
frwiki-20140521-article-templates.nt.gz
frwiki-20140521-infobox-property-definitions.nt.gz
frwiki-20140521-revision-ids.nt.gz
frwiki-20140521-category-labels.nt.gz frwiki-20140521-infobox-test.nt.gz
frwiki-20140521-revision-uris.nt.gz
frwiki-20140521-disambiguations.nt.gz frwiki-20140521-instance-types.nt.gz
frwiki-20140521-skos-categories.nt.gz
frwiki-20140521-download-complete
frwiki-20140521-interlanguage-links.nt.gz
frwiki-20140521-specific-mappingbased-properties.nt.gz
frwiki-20140521-external-links.nt.gz frwiki-20140521-labels.nt.gz
frwiki-20140521-template-redirects.obj
frwiki-20140521-extraction-complete
frwiki-20140521-mappingbased-properties.nt.gz
frwiki-20140521-topical-concepts.nt.gz
frwiki-20140521-french-population.nt.gz frwiki-20140521-page-ids.nt.gz
frwiki-20140521-wikipedia-links.nt.gz
frwiki-20140521-geo-coordinates.nt.gz frwiki-20140521-page-links.nt.gz
global.graph
frwiki-20140521-homepages.nt.gz frwiki-20140521-pages-articles.xml
index.html
frwiki-20140521-images.nt.gz frwiki-20140521-pnd.nt.gz
There is the global.graph file with "http://fr.dbpedia.org"; inside.
In order to have datas inserted in the triplestore i used the following
commands:
|set password dba *****||;|
|DB.DBA.RDF_GRAPH_GROUP_CREATE ('http://fr.dbpedia.org',1);| |
DB.DBA.RDF_GRAPH_GROUP_INS
('http://||fr||.dbpedia.org','http://||fr||.dbpedia.org/||live||');|
|DB.DBA.RDF_GRAPH_GROUP_INS
('http://||fr||.dbpedia.org','http://static.||fr||.dbpedia.org');|
|DB.DBA.RDF_GRAPH_GROUP_INS
('http://||fr||.dbpedia.org','http://||fr||.dbpedia.org/resource/classes#');|
log_enable(3,1);
registry_set ('dbp_decode_iri', 'on');
registry_set ('dbp_domain', 'http://fr.dbpedia.org');
registry_set ('dbp_graph', 'http://fr.dbpedia.org');
registry_set ('dbp_lang', 'fr');
registry_set ('dbp_DynamicLocal', 'off');
registry_set ('dbp_category', 'Catégorie');
registry_set ('dbp_imprint', 'http://dbpedia.fr/doc/Imprint');
registry_set ('dbp_website', 'http://wimmics.inria.fr/projects/dbpedia/');
registry_set ('dbp_lhost', ':80');
registry_set ('dbp_vhost', 'dbpedia.org');
vad_install('/usr/local/share/virtuoso/vad/dbpedia_dav.vad', 0);
vad_install('/usr/local/share/virtuoso/vad/rdf_mappers_dav.vad', 0);
ld_dir('/home/extraction-framework/datas/frwiki/20140521/','*.nt.gz',
'http:// <http://fr.dbpedia.org/>static.
<http://fr.dbpedia.org/>fr.dbpedia.org <http://fr.dbpedia.org/>');
rdf_loader_run();
Now my datas are on http://live.fr.dbpedia.org/sparql
If i make the following request (thanks Julien Plu for help)
select * from <http://fr.dbpedia.org> where
{<http://fr.dbpedia.org/resource/France> ?a ?b} LIMIT 100
=> no results
But with:
select * where {graph <http://fr.dbpedia.org>
{<http://fr.dbpedia.org/resource/France> ?a ?b}} LIMIT 100
=> I have the triples ! :'(
IfI can't put my datas in the well graph i can't have results in
http://live.fr.dbpedia.org/data/France.ntriples
Julien Cojan helped gave me a isql request in order to know graph for
triples:
select top 5 id_to_iri(G) as G_iri, id_to_iri(S) as S_iri, id_to_iri(P)
as P_iri, id_to_iri(O) as O_iri from DB.DBA.RDF_QUAD where
S=iri_to_id('http://fr.dbpedia.org/resource/Paris') and
P=iri_to_id('http://www.w3.org/1999/02/22-rdf-syntax-ns#type'
<http://www.w3.org/1999/02/22-rdf-syntax-ns#type%27>);
G_iri S_iri P_iri O_iri
LONG VARCHAR LONG VARCHAR LONG VARCHAR LONG VARCHAR
_______________________________________________________________________________
*http://fr.dbpedia.org * http://fr.dbpedia.org/resource/Paris
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/2002/07/owl#Thing
*http://fr.dbpedia.org* http://fr.dbpedia.org/resource/Paris
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/2004/02/skos/core#Concept
*http://fr.dbpedia.org* http://fr.dbpedia.org/resource/Paris
http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://schema.org/Place
*http://fr.dbpedia.org* http://fr.dbpedia.org/resource/Paris
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://dbpedia.org/ontology/Place
*http://fr.dbpedia.org* http://fr.dbpedia.org/resource/Paris
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://dbpedia.org/ontology/PopulatedPlace
5 Rows. -- 1 msec.
It's saying that my datas are in the good graph...
I have no solution yet for solving the problem. To you have ideas of
solutions?
Here is the virtuoso log:
root@ns384501:/home/virtuoso/db# virtuoso-t +foreground
Thu May 22 2014
17:24:37 OpenLink Virtuoso Universal Server
17:24:37 Version 07.10.3207-pthreads for Linux as of Apr 4 2014
17:24:37 uses parts of OpenSSL, PCRE, Html Tidy
17:24:40 Database version 3126
17:24:40 SQL Optimizer enabled (max 1000 layouts)
17:24:41 Compiler unit is timed at 0.000148 msec
17:24:42 built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST" overruled
by the RDBMS
17:24:42 built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH" overruled by the
RDBMS
17:24:42 built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI" overruled by
the RDBMS
17:24:42 built-in procedure "repl_undot_name" overruled by the RDBMS
17:24:43 Roll forward started
17:24:43 Roll forward complete
17:24:43 Checkpoint started
17:24:43 Checkpoint finished, log reused
17:24:43 HTTP/WebDAV server online at 80
17:24:43 Server online at 1111 (pid 4647)
Thanks! Chris
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
