en:site:recherche:logiciels:sparqlwithspark
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| en:site:recherche:logiciels:sparqlwithspark [15/09/2016 16:13] – [Snowflake queries] hubert | en:site:recherche:logiciels:sparqlwithspark [26/04/2017 11:14] (current) – amann | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{indexmenu_n> | {{indexmenu_n> | ||
| - | |||
| ====== SPARQL query processing with Apache Spark ====== | ====== SPARQL query processing with Apache Spark ====== | ||
| - | This wiki is a companion to the //SPARQL query processing with Apache Spark// | + | This wiki is a companion to the following publications: |
| + | * [[https://hal.archives-ouvertes.fr/ | ||
| + | * [[https:// | ||
| + | * [[https://hal.archives-ouvertes.fr/ | ||
| + | * [[https:// | ||
| - | It provides access to some resources related to the evaluation section. | + | It provides access to the resources related to the evaluation section |
| + | |||
| + | See also [[en: | ||
| ===== Data sets ===== | ===== Data sets ===== | ||
| Line 16: | Line 21: | ||
| ===== Query processing ===== | ===== Query processing ===== | ||
| + | |||
| + | ==== WatDiv queries ==== | ||
| + | |||
| + | |||
| + | === Query S1 === | ||
| + | <code sparql> | ||
| + | SELECT ?v0 ?v1 ?v3 ?v4 ?v5 ?v6 ?v7 ?v8 ?v9 WHERE { | ||
| + | ?v0 gr:includes ?v1 . %v2% gr:offers ?v0 . | ||
| + | ?v0 gr:price ?v3 . ?v0 gr: | ||
| + | ?v0 gr: | ||
| + | ?v0 sorg: | ||
| + | ?v0 sorg: | ||
| + | ?v0 sorg: | ||
| + | </ | ||
| + | |||
| + | See [[en: | ||
| + | |||
| + | === Query F5 === | ||
| + | <code sparql> | ||
| + | SELECT ?v0 ?v1 ?v3 ?v4 ?v5 ?v6 WHERE { | ||
| + | ?v0 gr:includes ?v1 . %v2% gr:offers ?v0 . | ||
| + | ?v0 gr:price ?v3 . ?v0 gr: | ||
| + | ?v1 og:title ?v5 . ?v1 rdf:type ?v6 . } | ||
| + | </ | ||
| + | |||
| + | See [[en: | ||
| + | == Execution reports for F5 == | ||
| + | |||
| + | ^Plan ^ Execution report | ||
| + | |SPARQL DF | {{: | ||
| + | |SPARQL Hybrid| | ||
| + | |S2RDF | ||
| + | |S2RDF+Hybrid | ||
| + | |||
| + | |||
| + | === Query C3 === | ||
| + | <code sparql> | ||
| + | SELECT ?v0 WHERE { | ||
| + | ?v0 wsdbm:likes ?v1 . ?v0 wsdbm: | ||
| + | ?v0 dc:Location ?v3 . ?v0 foaf:age ?v4 . | ||
| + | ?v0 wsdbm: | ||
| + | </ | ||
| + | |||
| + | See [[en: | ||
| + | |||
| ==== Star queries ==== | ==== Star queries ==== | ||
| Line 22: | Line 72: | ||
| Star with 3 branches | Star with 3 branches | ||
| - | < | + | < |
| SELECT ?x ?a ?b | SELECT ?x ?a ?b | ||
| WHERE { | WHERE { | ||
| Line 31: | Line 81: | ||
| Star with 5 branches | Star with 5 branches | ||
| - | < | + | < |
| SELECT ?x ?a ?b ?c ?d | SELECT ?x ?a ?b ?c ?d | ||
| WHERE { | WHERE { | ||
| Line 43: | Line 93: | ||
| Star with 10 branches | Star with 10 branches | ||
| - | < | + | < |
| SELECT ?x ?a ?b ?c ?d ?g ?h ?i | SELECT ?x ?a ?b ?c ?d ?g ?h ?i | ||
| WHERE { | WHERE { | ||
| Line 51: | Line 101: | ||
| ?x < | ?x < | ||
| ?x < | ?x < | ||
| - | ?x < | + | ?x < |
| ?x < | ?x < | ||
| ?x < | ?x < | ||
| Line 60: | Line 110: | ||
| Star with 15 branches | Star with 15 branches | ||
| - | < | + | < |
| SELECT ?x ?a ?b ?c ?d ?g ?h ?i ?j ?k ?l | SELECT ?x ?a ?b ?c ?d ?g ?h ?i ?j ?k ?l | ||
| WHERE { | WHERE { | ||
| Line 68: | Line 118: | ||
| ?x < | ?x < | ||
| ?x < | ?x < | ||
| - | ?x < | + | ?x < |
| ?x < | ?x < | ||
| ?x < | ?x < | ||
| Line 87: | Line 137: | ||
| === Chain4 query === | === Chain4 query === | ||
| Chain4 is | Chain4 is | ||
| - | < | + | < |
| SELECT ?x1, ?x2, ?x3, ?x4, ?x5 WHERE { ?x1 P1 ?x2 . ?x2 P2 ?x3 . ?x3 P3 ?x4 . ?x4 P4 ?x5 } | SELECT ?x1, ?x2, ?x3, ?x4, ?x5 WHERE { ?x1 P1 ?x2 . ?x2 P2 ?x3 . ?x3 P3 ?x4 . ?x4 P4 ?x5 } | ||
| </ | </ | ||
| with properties | with properties | ||
| - | < | + | < |
| val P1 = 1389363200 | val P1 = 1389363200 | ||
| val P2 = 52239 | val P2 = 52239 | ||
| Line 100: | Line 150: | ||
| === Chain6 query === | === Chain6 query === | ||
| - | < | + | < |
| SELECT ?x1, ?x2, ?x3, ?x4, ?x5, ?x6, ?x7 WHERE { ?x1 P1 ?x2 . ?x2 P2 ?x3 . ?x3 P3 ?x4 . ?x4 P4 ?x5 . ?x5 P5 ?x6 . ?x6 P6 ?x7 } | SELECT ?x1, ?x2, ?x3, ?x4, ?x5, ?x6, ?x7 WHERE { ?x1 P1 ?x2 . ?x2 P2 ?x3 . ?x3 P3 ?x4 . ?x4 P4 ?x5 . ?x5 P5 ?x6 . ?x6 P6 ?x7 } | ||
| </ | </ | ||
| with properties | with properties | ||
| - | < | + | < |
| val P1 = 18843 | val P1 = 18843 | ||
| val P2 = 5540 | val P2 = 5540 | ||
| Line 117: | Line 167: | ||
| SPARQL for Q8 from LUBM test suite | SPARQL for Q8 from LUBM test suite | ||
| - | < | + | < |
| PREFIX rdf: < | PREFIX rdf: < | ||
| PREFIX ub: < | PREFIX ub: < | ||
| Line 131: | Line 181: | ||
| See [[en: | See [[en: | ||
| - | ==== WatDiv queries ==== | ||
| + | ===== Misc ===== | ||
| + | | ||
| - | === Query S1 === | ||
| - | < | ||
| - | SELECT ?v0 ?v1 ?v3 ?v4 ?v5 ?v6 ?v7 ?v8 ?v9 WHERE { | ||
| - | ?v0 gr:includes ?v1 . %v2% gr:offers ?v0 . | ||
| - | ?v0 gr:price ?v3 . ?v0 gr: | ||
| - | ?v0 gr: | ||
| - | ?v0 sorg: | ||
| - | ?v0 sorg: | ||
| - | ?v0 sorg: | ||
| - | </ | ||
| - | See [[en: | ||
| - | === Query F5 === | ||
| - | < | ||
| - | SELECT ?v0 ?v1 ?v3 ?v4 ?v5 ?v6 WHERE { | ||
| - | ?v0 gr:includes ?v1 . %v2% gr:offers ?v0 . | ||
| - | ?v0 gr:price ?v3 . ?v0 gr: | ||
| - | ?v1 og:title ?v5 . ?v1 rdf:type ?v6 . } | ||
| - | </ | ||
| - | Graphical reports for plan S2RDF+Hybrid{{: | ||
| - | {{: | ||
| - | See [[en: | ||
| - | |||
| - | === Query C3 === | ||
| - | < | ||
| - | SELECT ?v0 WHERE { | ||
| - | ?v0 wsdbm:likes ?v1 . ?v0 wsdbm: | ||
| - | ?v0 dc:Location ?v3 . ?v0 foaf:age ?v4 . | ||
| - | ?v0 wsdbm: | ||
| - | </ | ||
| - | |||
| - | See [[en: | ||
| - | |||
| - | ===== Misc ===== | ||
| - | | ||
en/site/recherche/logiciels/sparqlwithspark.1473948782.txt.gz · Last modified: by hubert