Bases de Données / Databases

Site Web de l'équipe BD du LIP6 / LIP6 DB Web Site

User Tools

Site Tools

Trace: • Stages, thèses, CDD • Stages 2022 • MU4IN803 : SAM - Stockage et Accès aux Mégadonnées (fév 2020) • Recherche • DIU
en:site:recherche:logiciels:sparqlwithspark:star

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:site:recherche:logiciels:sparqlwithspark:star [15/09/2016 10:11] – huberten:site:recherche:logiciels:sparqlwithspark:star [16/09/2016 23:09] (current) – [SPARQL Hybrid DF : plan for Spark v1.5] hubert
Line 1: Line 1:
-{{indexmenu_n>2}}+{{indexmenu_n>5}}
  
-====== Star shape queries over DrugBank ======+====== Star shape query plans======
  
-SPARQL queries+=== SPARQL SQL for a star with 3 branches ===
  
-Star with 3 branches +<code sql>
- +
-<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> +
- +
-SPARQL SQL +
-<code>+
 SELECT t1.s, t2.o, t3.o  SELECT t1.s, t2.o, t3.o 
 FROM triple t1, triple t2, triple t3  FROM triple t1, triple t2, triple t3 
Line 26: Line 15:
 </code> </code>
  
-Star with 5 branches 
-<code> 
-SELECT ?x ?a ?b ?c ?d 
-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 . 
-} 
-</code> 
  
-Star with 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> 
- 
-Star with 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> 
  
 ==== SPARQL Hybrid DF : plan for Spark v1.5==== ==== 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
en/site/recherche/logiciels/sparqlwithspark/star.1473927069.txt.gz · Last modified: by hubert