LOD-Analysis-Clusters

example: film character cluster in LinkedMDB

SPARQL

General remarks

All queries were performed on the SPARQL endpoint at http://wit.istc.cnr.it:8893/sparql

The <dataset> placeholder denotes one of:

• <lmdb_dataset> for LinkedMDB
• <dbtune_peel> for DBTune John Peel Sessions
• <jamendo_dataset> for DBTune Jamendo

All queries share the following prefix mapping:

PREFIX laprop: <http://www.ontologydesignpatterns.org/ont/lod-analysis-properties.owl#>
PREFIX lapath: <http://www.ontologydesignpatterns.org/ont/lod-analysis-path.owl#>
PREFIX ladata: <http://www.ontologydesignpatterns.org/ont/lod-analysis-properties-data.owl#>

Clustering queries

foaf:made cluster paths of length 3, foaf:made in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?pe lapath:hasProperty ?property .
  MINUS {?path a lapath:AlternativePath} .
  FILTER (?property = <http://xmlns.com/foaf/0.1/made>)
}
LIMIT 1000

mo:track cluster of paths of length 3, mo:track in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
  MINUS {?path a lapath:AlternativePath} .
  FILTER (?property = <http://purl.org/ontology/mo/track>)
}
LIMIT 1000 

mo:available_as cluster of paths of length 3, mo:available_as in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
  MINUS {?path a lapath:AlternativePath} .
  FILTER (?property = <http://purl.org/ontology/mo/available_as>)
}
LIMIT 1000

mo:published_as cluster of paths of length 3, mo:published_as in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
  MINUS {?path a lapath:AlternativePath} .
  FILTER (?property = <http://purl.org/ontology/mo/published_as>)
}
LIMIT 1000

event:sub_event cluster of paths of length 3, event:sub_event in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
  MINUS {?path a lapath:AlternativePath} .
  FILTER (?property = <http://purl.org/NET/c4dm/event.owl#sub_event>)
}
LIMIT 1000

mo:produced cluster of paths of length 3, mo:produced in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
MINUS {?path a lapath:AlternativePath} .
FILTER (?property = <http://purl.org/ontology/mo/produced>)
}
LIMIT 1000

mo:producer cluster of paths of length 3, mo:producer in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
  MINUS {?path a lapath:AlternativePath} .
  FILTER (?property = <http://purl.org/ontology/mo/producer>)
}
LIMIT 1000

mo:engineered cluster of paths of length 3, mo:engineered in position 2:

SELECT DISTINCT ?dat ?property ?path  
FROM <lod_stats>
WHERE {
  ?path lapath:hasLength 3 .
  ?path lapath:hasPathElement ?pe .
  ?pe lapath:hasPosition 2 .
  ?poc lapath:hasPath ?path .
  ?poc lapath:inDataset ?dat .
  ?pe lapath:hasProperty ?property .
MINUS {?path a lapath:AlternativePath} .
FILTER (?property = <http://purl.org/ontology/mo/engineered>)
}
LIMIT 1000