Hi Dimitris, The way it can be done is to use theVirtuoso sparql_to_sql_text() function (http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html) to determine the SQL query the query including the graph group is translated to ie sparql_to_sql_text ('select * from <group> { ?s ?p ?o }'), then look at the IN condition on 'G' and copy that in the dbpedia/description.vsp in the place of equality of G. Although note there is no guarantee the procedure which returns graph Ids would not be changed in the future as it is an internal call. Another approach is to write the queries using sparql and use 'define output:valmode "LONG" ' in order to get same data types in the result set, see http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsqlfromsparql .
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 11 Dec 2012, at 17:24, Dimitris Kontokostas wrote: > Hi Hugh, > > I hardcoded the gragh with the most triples for now (live.nl.dbpedia.org) to > have something to show, so it is not fixed yet. > > Any suggestions? > > Best, > Dimitris > > > On Tue, Dec 11, 2012 at 7:28 PM, Hugh Williams <hwilli...@openlinksw.com> > wrote: > Hi Dimitris, > > Have your resolved or worked around this issue as I not the link in [2] is > returning a HTML description of the resource and not an empty page as > indicated ? > > 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 6 Dec 2012, at 16:28, Dimitris Kontokostas wrote: > >> Hi, >> >> I am trying to adapt the DBpedia plugin to work with graph groups in >> http://live.nl.dbpedia.org >> Right now I have the "http://nl.dbpedia.org"; as a group graph that contains >> the "http://live.nl.dbpedia.org"; and "http://static.nl.dbpedia.org"; >> >> The problem is that the description page is rendered using SQL from RDF_QUAD >> limiting to specific gragh [1], the "http://nl.dbpedia.org"; which does not >> exists in that table. resulting in empty html pages [2] but not empty data >> pages [3]. >> >> Although I could adapt the queries for this case I would like to use the >> same code for both static & live dbpedia's >> Is it possible to generate a dynamic "IN" clause and depending on the >> settings to fill it with 1 or more graphs? >> >> I am not sure how to do this in VSP but I imagine it something like "... AND >> G IN ( list of graphs)..." instead of G = _G >> >> The second case would be to convert SQL to SPARQL but I am not sure on the >> performance impact it would have >> >> Best, >> Dimitris >> >> >> [1] >> http://dbpedia.hg.sourceforge.net/hgweb/dbpedia/dbpedia_vad/file/e24f14cdfbf5/dbpedia/vsp/description.vsp#l272 >> [2] http://live.nl.dbpedia.org/page/Linux >> [3] >> http://live.nl.dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fnl.dbpedia.org&query=DESCRIBE+%3Chttp://nl.dbpedia.org/resource/Linux%3E&output=text/html >> >> -- >> Dimitris Kontokostas >> Department of Computer Science, University of Leipzig >> Research Group: http://aksw.org >> Homepage:http://aksw.org/DimitrisKontokostas >> ------------------------------------------------------------------------------ >> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial >> Remotely access PCs and mobile devices and provide instant support >> Improve your efficiency, and focus on delivering more value-add services >> Discover what IT Professionals Know. Rescue delivers >> http://p.sf.net/sfu/logmein_12329d2d_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > > -- > Dimitris Kontokostas > Department of Computer Science, University of Leipzig > Research Group: http://aksw.org > Homepage:http://aksw.org/DimitrisKontokostas
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
