Re: [d2rq-dev] unioning TDB and D2R - success! [SEC=UNCLASSIFIED]

[Richard C. <ri...@cy...>]

Congrats! Glad you got it to work! Hope that performance is acceptable with this setup.

Richard




> On 3 Mar 2015, at 02:18, Paul Murray <pm...@an...> wrote:
> 
> Success!
> 
> As I have been pestering this list about my work, I thought it might be nice to tell you how it has turned out.
> 
> Our SPARQL service lives at http://biodiversity.org.au/sparql
> There is a basic HTML page backed by it at http://biodiversity.org.au/dataexport/html/NSL_SPARQL.html
> 
> I haven't updated this page yet, so it does not have examples relating to the new dataset, but it does have plenty of @prefix declarations whic we will want :) .
> 
> In any case, lets take this query:
> 
> select *
> where { 
>  graph g:all { 
>    <http://biodiversity.org.au/apni.name/2242> ?p ?o
>  }
> }
> ORDER BY ?p
> limit 50
> 
> Now, the URI above is an old-style URI (the weird format is to make it compatible with LSIDs). Most of the triples in the results come from a TDB dataset named JAN2015_APNI . However, there's one triple - http://biodiversity.org.au/voc/boa/BOA#mapsTo - which is pulled from the database. It indicates the new URI for the name, now that we have moved over to the new system.
> 
> Consequently, one can write
> 
> select *
> where { 
>  graph g:all { 
>    <http://biodiversity.org.au/apni.name/2242> <http://biodiversity.org.au/voc/boa/BOA#mapsTo> ?newId .
>    ?newId ?p ?o .
>  }
> }
> ORDER BY ?p
> limit 50
> 
> To get the new content live from the database (well, from our test database, but whatever) using the old id. And we can union the data together:
> 
> select ?p ?o
> where { 
>  graph g:all { 
>    <http://biodiversity.org.au/apni.name/2242> <http://biodiversity.org.au/voc/boa/BOA#mapsTo> ?newId .
>    {
>      {<http://biodiversity.org.au/apni.name/2242> ?p ?o }
>      union
>      { ?newId ?p ?o . }
>    }
>  }
> }
> ORDER BY ?p ?o
> limit 50
> 
> So, it's all pretty good. 
> 
> 
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website, sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the 
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> d2rq-map-devel mailing list
> d2r...@li...
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel