Re: [Virtuoso-users] loaded data doesn't bind to graph specified

2017-01-26 Thread Kingsley Idehen
On 1/26/17 4:32 PM, Roland Cornelissen wrote:
> That works fine, as stated before; when the graph is specified in the
> sparql query the results are as expected.
>
> But take f.i. a resource out of these results and ask a DESCRIBE the
> foaf depiction triple is not presented for the resource:
>
> http://nl.dbpedia.org/sparql?default-graph-uri==describe+%3Chttp%3A%2F%2Fnl.dbpedia.org%2Fresource%2F2_Broke_Girls%3E=text%2Fhtml=3=on

See:

http://nl.dbpedia.org/sparql?default-graph-uri==define+sql%3Adescribe-mode+%22CBD%22%0D%0Adescribe+%3Chttp%3A%2F%2Fnl.dbpedia.org%2Fresource%2F2_Broke_Girls%3E=text%2Fhtml=3=on

DESCRIBE is sparsely specified in the SPARQL specs so you need to use a
pragma. In this case I used:

define sql:describe-moe "CBD"

Where CBD is for Concise Bound Description.

Kingsley
>
>
> On 26-01-17 22:19, Kingsley Idehen wrote:
>> What happens when you try:
>>
>> http://nl.dbpedia.org/sparql?default-graph-uri==select+*+%7Bgraph+%3Fg+%7B%3Fs+foaf%3Adepiction+%3Fpic%7D%7D+limit+100=text%2Fhtml=3=on
>>
>> If that's fine, this its down do you not using: GRAPH ?g in the
>> dataset modifier (body) of your sparql query.
>>
>>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>


-- 
Regards,

Kingsley Idehen   
Founder & CEO 
OpenLink Software   (Home Page: http://www.openlinksw.com)

Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen

Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
: 
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this




smime.p7s
Description: S/MIME Cryptographic Signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] loaded data doesn't bind to graph specified

2017-01-26 Thread Roland Cornelissen
Also, if you open a resource in the classic interface (Pubby the extra
triple is shown, i.e foaf:depiction), but when you open the same
resource in the new interface no extra triples is shown.

f.i. http://nl.dbpedia.org/resource/2-hexenal


On 26-01-17 22:19, Kingsley Idehen wrote:
> On 1/24/17 12:22 PM, Roland Cornelissen wrote:
>>
>> Hi,
>>
>> I have this weird situation where I load a dataset into nl.dbpedia
>> like this:
>>
>> ld_dir ('/opt/static/data/nlwiki/20170120/', '*.nt',
>> 'http://nl.dbpedia.org');
>> rdf_loader_run();
>>
>> Now when I query the data I don't get it any results through the
>> sparql interface when I phrase the query like this
>> 
>>
>> But when the graph is explicitly specified in the query I get results
>> as expected, like this
>> 
>>
>> Results are not showing up in the URI resolving interface.
>>
>> Whats is going on here? How do I get those triples in the right graph?
>>
>> Thanks,
>> Roland
>>
>
> What happens when you try:
>
> http://nl.dbpedia.org/sparql?default-graph-uri==select+*+%7Bgraph+%3Fg+%7B%3Fs+foaf%3Adepiction+%3Fpic%7D%7D+limit+100=text%2Fhtml=3=on
>
> If that's fine, this its down do you not using: GRAPH ?g in the
> dataset modifier (body) of your sparql query.
>
>
> -- 
> Regards,
>
> Kingsley Idehen 
> Founder & CEO 
> OpenLink Software   (Home Page: http://www.openlinksw.com)
>
> Weblogs (Blogs):
> Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
> Blogspot Blog: http://kidehen.blogspot.com
> Medium Blog: https://medium.com/@kidehen
>
> Profile Pages:
> Pinterest: https://www.pinterest.com/kidehen/
> Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
> Twitter: https://twitter.com/kidehen
> Google+: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn: http://www.linkedin.com/in/kidehen
>
> Web Identities (WebID):
> Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
> : 
> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] loaded data doesn't bind to graph specified

2017-01-26 Thread Roland Cornelissen
That works fine, as stated before; when the graph is specified in the
sparql query the results are as expected.

But take f.i. a resource out of these results and ask a DESCRIBE the
foaf depiction triple is not presented for the resource:

http://nl.dbpedia.org/sparql?default-graph-uri==describe+%3Chttp%3A%2F%2Fnl.dbpedia.org%2Fresource%2F2_Broke_Girls%3E=text%2Fhtml=3=on


On 26-01-17 22:19, Kingsley Idehen wrote:
>
> What happens when you try:
>
> http://nl.dbpedia.org/sparql?default-graph-uri==select+*+%7Bgraph+%3Fg+%7B%3Fs+foaf%3Adepiction+%3Fpic%7D%7D+limit+100=text%2Fhtml=3=on
>
> If that's fine, this its down do you not using: GRAPH ?g in the
> dataset modifier (body) of your sparql query.
>
>


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] loaded data doesn't bind to graph specified

2017-01-26 Thread Kingsley Idehen
On 1/24/17 12:22 PM, Roland Cornelissen wrote:
>
> Hi,
>
> I have this weird situation where I load a dataset into nl.dbpedia
> like this:
>
> ld_dir ('/opt/static/data/nlwiki/20170120/', '*.nt',
> 'http://nl.dbpedia.org');
> rdf_loader_run();
>
> Now when I query the data I don't get it any results through the
> sparql interface when I phrase the query like this
> 
>
> But when the graph is explicitly specified in the query I get results
> as expected, like this
> 
>
> Results are not showing up in the URI resolving interface.
>
> Whats is going on here? How do I get those triples in the right graph?
>
> Thanks,
> Roland
>

What happens when you try:

http://nl.dbpedia.org/sparql?default-graph-uri==select+*+%7Bgraph+%3Fg+%7B%3Fs+foaf%3Adepiction+%3Fpic%7D%7D+limit+100=text%2Fhtml=3=on

If that's fine, this its down do you not using: GRAPH ?g in the dataset
modifier (body) of your sparql query.


-- 
Regards,

Kingsley Idehen   
Founder & CEO 
OpenLink Software   (Home Page: http://www.openlinksw.com)

Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen

Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
: 
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this



smime.p7s
Description: S/MIME Cryptographic Signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] loaded data doesn't bind to graph specified

2017-01-26 Thread Roland Cornelissen
Hi Hugh,

I think the load method used for nl.dbpedia is TTL_MT() in a script of
Dimitris. I think that is different from ld_dir(), but I tried ttl_mt()
also later with the same results.

I just updated the VOS instance to the latest version from Github and
tried again to load the data. Again the same results...

> What other graphs are in the Quad Store:
>
>   SPARQL SELECT ?g COUNT(*) { GRAPH ?g {?s ?p ?o.} } GROUP BY ?g ORDER BY 
> DESC 2;
SQL> SPARQL SELECT ?g COUNT(*) { GRAPH ?g {?s ?p ?o.} } GROUP BY ?g
ORDER BY DESC 2;
g   
 
callret-1
LONG
VARCHAR 
LONG VARCHAR
___

http://nl.dbpedia.org/data  
 
89058718
http://nl.dbpedia.org   
 
3492372
http://nl.dbpedia.org/resource/classes# 
 
30793
http://live.nl.dbpedia.org:8877/DAV/
 
3504
http://www.openlinksw.com/schemas/virtrdf#  
 
2475
http://www.w3.org/2002/07/owl#  
 
167
http://live.nl.dbpedia.org:8877/sparql  
 
14
http://dbpedia.org/schema/property_rules#   
 
12
dbprdf-label
 
6
http://www.w3.org/ns/ldp#   
 
3

10 Rows. -- 3701 msec.
> and can you query and of the other graphs with the name specified in the 
> “Default Data Set Name” field (from)
yes, nl.dbpedia.org/data (but no foaf:depiction there...)
>
> Also, does the following return results when run from the isql command line 
> tool:
>
>   sparql select * from   { ?s foaf:depiction ?pic 
> } limit 100;
SQL> sparql select * from   { ?s foaf:depiction
?pic } limit 100;
s   
 
pic
LONG
VARCHAR 
LONG VARCHAR
___


0 Rows. -- 3815 msec.


Also, in the old interface (Pubby) the foaf:depictions are visible for
resources, but in the new interface not ...(?)

But, this query _does_ return results:

SQL> SPARQL select * {graph  {?s foaf:depiction
?pic}} limit 10;
s   
 
pic
LONG
VARCHAR 
LONG VARCHAR
___

http://nl.dbpedia.org/resource/$100_Bill_Y'all  
 
http://commons.wikimedia.org/wiki/Special:FilePath/100doll_cube.jpg
http://nl.dbpedia.org/resource/%22This_Is_Our_Punk-Rock%22,_Thee_Rusted_Satellites_Gather_+_Sing
 
http://commons.wikimedia.org/wiki/Special:FilePath/Mtzionthisisour.jpg
http://nl.dbpedia.org/resource/'74-'75  
 
http://commons.wikimedia.org/wiki/Special:FilePath/The_Connells_-_'74_-_'75_album_cover.jpg
http://nl.dbpedia.org/resource/'88_Remix
 
http://commons.wikimedia.org/wiki/Special:FilePath/Giantpanda-88remix.jpg
http://nl.dbpedia.org/resource/'N'_Dey_Say  
 
http://commons.wikimedia.org/wiki/Special:FilePath/Nelly_-_N_Dey_Say_CD_cover.jpg
http://nl.dbpedia.org/resource/'Till_I_Get_My_Way/Girl_Is_On_My_Mind
 
http://commons.wikimedia.org/wiki/Special:FilePath/'Till_I_Get_My_Way_-_Girl_Is_On_My_Mind.jpg
http://nl.dbpedia.org/resource/'Tis_So_Sweet_to_Trust_in_Jesus  
 
http://commons.wikimedia.org/wiki/Special:FilePath/Amy_Grant_Tis_So_Sweet_To_Trust_In_Jesus_single.jpg
http://nl.dbpedia.org/resource/'n_Toeback   
 
http://commons.wikimedia.org/wiki/Special:FilePath/N_Toeback_(bier).JPG
http://nl.dbpedia.org/resource/'s-Gravenpolder_(Groede) 
 
http://commons.wikimedia.org/wiki/Special:FilePath/Kuypers_-_'s-Gravenpolder_(Groede).PNG
http://nl.dbpedia.org/resource/'t_Aepjen
 
http://commons.wikimedia.org/wiki/Special:FilePath/Zeed1.jpg

10 Rows. -- 8 msec.


What could be the problem here?

Thanks,
Roland



>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc.  //  http://www.openlinksw.com/
> Weblog   -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter  -- http://twitter.com/OpenLink
> Google+  -- 

Re: [Virtuoso-users] Running to VOS with one virtuoso.db

2017-01-26 Thread Hugh Williams
Hi Pasquale,

What is the purpose of running two Virtuoso instances, is this for setup access 
for SPARQL or SQL storage ?

The easiest way to start multiple Virtuoso database instances on the same 
machine is to create two separate databases with a “virtuoso.ini” file on each 
set to use unique SQL & HTTP ports and then start each in the separate 
directories with a lock file for each …

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  //  http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 26 Jan 2017, at 14:28, Pasquale Di Donato  
> wrote:
> 
> Hi all
> 
> I wanted to run 2 Virtuoso Open Source instances on one virtuoso.db, but it 
> seems not possible since when the first instances is run then a lock file is 
> created for the DB.
> 
> Any hint here or is this not possible with the Open Source Edition?
> 
> Pasquale
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! 
> http://sdm.link/slashdot___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users



smime.p7s
Description: S/MIME cryptographic signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] loaded data doesn't bind to graph specified

2017-01-26 Thread Hugh Williams
Hi Roland,

Is this not the same method you have loaded DBpedia NL datasets in the past ? 
In which case what is different with this new dataset load ?

What other graphs are in the Quad Store:

SPARQL SELECT ?g COUNT(*) { GRAPH ?g {?s ?p ?o.} } GROUP BY ?g ORDER BY 
DESC 2;

and can you query and of the other graphs with the name specified in the 
“Default Data Set Name” field (from)

Also, does the following return results when run from the isql command line 
tool:

sparql select * from   { ?s foaf:depiction ?pic 
} limit 100;

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  //  http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 24 Jan 2017, at 17:22, Roland Cornelissen  wrote:
> 
> Hi,
> 
> I have this weird situation where I load a dataset into nl.dbpedia like this:
> 
> ld_dir ('/opt/static/data/nlwiki/20170120/', '*.nt', 'http://nl.dbpedia.org');
> rdf_loader_run();
> 
> Now when I query the data I don't get it any results through the sparql 
> interface when I phrase the query like this
> 
> But when the graph is explicitly specified in the query I get results as 
> expected, like this
> 
> Results are not showing up in the URI resolving interface.
> 
> Whats is going on here? How do I get those triples in the right graph?
> 
> Thanks,
> Roland
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! 
> http://sdm.link/slashdot___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users



smime.p7s
Description: S/MIME cryptographic signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


[Virtuoso-users] Running to VOS with one virtuoso.db

2017-01-26 Thread Pasquale Di Donato
Hi all

I wanted to run 2 Virtuoso Open Source instances on one virtuoso.db, but it
seems not possible since when the first instances is run then a lock file
is created for the DB.

Any hint here or is this not possible with the Open Source Edition?

Pasquale
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users