On 10/2/15 10:47 AM, Jerven Bolleman wrote: > Hi, > > In Oracle, I think you can create a view on a select on sem_match. e.g. > > CREATE VIEW proteinOrganism AS > SELECT p AS PROTEIN, o AS ORGANISM FROM TABLE(SEM_MATCH( > 'PREFIX c:<http://purl.uniprot.org/core/> SELECT ?p ?o WHERE {?p a > c:Protein . ?p c:organism ?o}', > SEM_MODELS('UNIPROT_2015_08'), null, null, null)); > > Something similar is possible in Virtuoso, and surely DB2 > > In PostgreSQL, you could use > https://github.com/cyga/www_fdw/wiki/Documentation > to map sparql results into views. > > However, all will requires certain maintenance workloads. > > For the experimental stuff you could look at MonetDB/RDF or > Virtuoso-CS (not yet public) > http://homepages.cwi.nl/~duc/papers/emergentschema_www15.pdf > <http://homepages.cwi.nl/%7Educ/papers/emergentschema_www15.pdf> > > Regards, > Jerven >
Virtuoso translates SPARQL to SQL at its core i.e., that's what Virtuoso
is, fundamentally.
Virtuoso also let's you leverage RDF Relations constructed from SPARQL
in the FROM CLAUSE of a SQL Query (we call this SPASQL, and it's existed
since day one).
Here is a simple SPASQL Query where an RDF relation is used in the SQL
FROM CLAUSE:
SELECT "x"."o"
FROM (SPARQL SELECT DISTINCT ?o {?s rdf:type ?o} LIMIT 100) AS "x"
Links:
[1] http://bit.ly/spasql-query-demo-entity-types -- Live instance of SQL
and/or SPARQL Query Tool
--
Regards,
Kingsley Idehen
Founder & CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog 1: http://kidehen.blogspot.com
Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
Twitter Profile: https://twitter.com/kidehen
Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
smime.p7s
Description: S/MIME Cryptographic Signature
