Modelize StarWars Ontology into DB

README.md

Star Wars Ontology

This gist is part of the tutorial about modelizing a Star Wars Ontolofy into SurrealDB

star-wars-planet-query.sparql

SELECT 
    ?property 
    (COUNT(DISTINCT ?planet) as ?planetCount)
    (MAX(?valueCountPerPlanet) as ?maxValuesPerPlanet)
    (COUNT(DISTINCT ?planetWithMultiple) as ?planetsWithMultipleValues)
    (GROUP_CONCAT(DISTINCT ?datatype; separator=", ") as ?datatypes)
    (GROUP_CONCAT(DISTINCT ?objectType; separator=", ") as ?objectTypes)
    (SAMPLE(GROUP_CONCAT(DISTINCT ?value; separator=", ")) as ?exampleValues)
WHERE {
    ?planet a voc:Planet ;
            ?property ?value .
    
    # Count values per planet
    {
        SELECT ?planet ?property (COUNT(?value) as ?valueCountPerPlanet)
        WHERE {
            ?planet a voc:Planet ;
                    ?property ?value .
        }
        GROUP BY ?planet ?property
    }
    
    # Identify planets with multiple values
    OPTIONAL {
        SELECT ?planet ?property
        WHERE {
            ?planet a voc:Planet ;
                    ?property ?value .
        }
        GROUP BY ?planet ?property
        HAVING (COUNT(?value) > 1)
    } BIND(?planet as ?planetWithMultiple)
    
    OPTIONAL {
        ?value a ?objectType .
    }
    BIND(datatype(?value) as ?datatype)
}
GROUP BY ?property
ORDER BY DESC(?planetCount)