This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
en:site:recherche:logiciels:sparqlwithspark:star [13/09/2016 23:29] hubert created |
en:site:recherche:logiciels:sparqlwithspark:star [16/09/2016 23:09] (current) hubert [SPARQL Hybrid DF : plan for Spark v1.5] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | Star shape queries over DrugBank | + | {{indexmenu_n>5}} |
- | SPARQL queries | + | ====== Star shape query plans====== |
- | // Query star 1 (3 branches) | + | |
- | <code> | + | |
- | SELECT ?x ?a ?b | + | |
- | WHERE { | + | |
- | ?x <http://xmlns.com/foaf/0.1/page> <http://dbpedia.org/page/Ibuprofen>. | + | |
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/chebiId> ?a . | + | |
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/casRegistryNumber> ?b.} | + | |
- | </code> | + | |
- | // in SQL | + | === SPARQL SQL for a star with 3 branches === |
- | <code> | + | |
- | SELECT t1.s, t2.o, t3.o FROM triple t1, triple t2, triple t3 WHERE t1.p LIKE '<http://xmlns.com/foaf/0.1/page>' AND t1.o LIKE '<http://dbpedia.org/page/Ibuprofen>' AND t2.p LIKE '<http://xmlns.com/foaf/0.1/page> <http://dbpedia.org/page/Ibuprofen>' AND t3.p LIKE '<http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/casRegistryNumber>' AND t1.s=t2.s AND t1.s=t3.s; | + | |
- | </code> | + | |
- | // Query star 1 (5 branches) | + | <code sql> |
- | <code> | + | SELECT t1.s, t2.o, t3.o |
- | SELECT ?x ?a ?b ?c ?d | + | FROM triple t1, triple t2, triple t3 |
- | WHERE { | + | WHERE t1.p LIKE '<http://xmlns.com/foaf/0.1/page>' |
- | ?x <http://xmlns.com/foaf/0.1/page> <http://dbpedia.org/page/Ibuprofen>. | + | AND t1.o LIKE '<http://dbpedia.org/page/Ibuprofen>' |
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/chebiId> ?a . | + | AND t2.p LIKE '<http://xmlns.com/foaf/0.1/page> <http://dbpedia.org/page/Ibuprofen>' |
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/casRegistryNumber> ?b . | + | AND t3.p LIKE '<http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/casRegistryNumber>' |
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/keggDrugId> ?c . | + | AND t1.s=t2.s AND t1.s=t3.s; |
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/keggCompoundId> ?d . | + | |
- | } | + | |
</code> | </code> | ||
- | // Query star 1 (10 branches) | ||
- | <code> | ||
- | SELECT ?x ?a ?b ?c ?d ?g ?h ?i | ||
- | WHERE { | ||
- | ?x <http://xmlns.com/foaf/0.1/page> <http://dbpedia.org/page/Ibuprofen>. | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/chebiId> ?a . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/casRegistryNumber> ?b . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/keggDrugId> ?c . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/keggCompoundId> ?d . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/pharmacology> "?e. | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/mechanismOfAction> ?f | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/predictedLogs> ?g . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/halfLife> ?h . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/dpdDrugIdNumber> ?i . | ||
- | } | ||
- | </code> | ||
- | // Query star 1 (15 branches) | ||
- | <code> | ||
- | SELECT ?x ?a ?b ?c ?d ?g ?h ?i ?j ?k ?l | ||
- | WHERE { | ||
- | ?x <http://xmlns.com/foaf/0.1/page> <http://dbpedia.org/page/Ibuprofen>. | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/chebiId> ?a . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/casRegistryNumber> ?b . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/keggDrugId> ?c . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/keggCompoundId> ?d . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/pharmacology> "?e. | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/mechanismOfAction> ?f | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/predictedLogs> ?g . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/halfLife> ?h . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/dpdDrugIdNumber> ?i . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/contraindicationInsert> ?j . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/interactionInsert> ?k . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/structure> ?l. | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/state> ?m . | ||
- | ?x <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/rxlistLink> <http://www.rxlist.com/cgi/generic/ibup.htm> .} | ||
- | </code> | ||
- | Scala code: | + | ==== SPARQL Hybrid DF : plan for Spark v1.5==== |
- | <code> | + | <code scala> |
import scala.collection.mutable.ListBuffer | import scala.collection.mutable.ListBuffer | ||
import scala.collection.mutable.ArrayBuffer | import scala.collection.mutable.ArrayBuffer | ||
Line 390: | Line 341: | ||
</code> | </code> | ||
+ | Go to [[en:site:recherche:logiciels:sparqlwithspark]] |