search

dbpedia / databus

A digital factory platform for managing files online with stable IDs, high-quality metadata, powerful API and tools for building on data: find, access, make interoperable, re-use
Apache License 2.0
42 stars 17 forks source link

SPARQL query for core collection issue #70

Closed m1ci closed 1 year ago

m1ci commented 1 year ago

When submitting the SPARQL query associated with the core collection to the databus SPARQL endpoing using the UI at https://databus.dbpedia.org/repo/sparql I get following response:

Request-URI Too Long

The requested URL's length exceeds the capacity limit for this server.

SPARQL query:

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX db: <https://databus.dbpedia.org/>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX dataid: <http://dataid.dbpedia.org/ns/core#>
SELECT DISTINCT ?file WHERE
{ 
    {
        SELECT DISTINCT ?file ?g WHERE {
            GRAPH ?g {
                ?dataset dcat:distribution ?distribution .
                ?distribution dataid:file ?file .
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/dbpedia/generic> .
                    { ?distribution <http://dataid.dbpedia.org/ns/core#compression> 'bzip2'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    { ?distribution <http://dataid.dbpedia.org/ns/core#formatExtension> 'ttl'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/categories> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/commons-sameas-links> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/disambiguations> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/external-links> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/geo-coordinates> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/homepages> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/infobox-properties> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/infobox-property-definitions> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/interlanguage-links> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/labels> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/page> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/persondata> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/redirects> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/revisions> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/wikipedia-links> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/article-templates> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/wikilinks> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/generic/images> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/dbpedia/mappings> .
                    { ?distribution <http://dataid.dbpedia.org/ns/core#compression> 'bzip2'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/mappings/geo-coordinates-mappingbased> .
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/mappings/instance-types> .
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/mappings/mappingbased-literals> .
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/mappings/specific-mappingbased-properties> .
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/dbpedia/transition> .
                    { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/transition/freebase-links> .
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2019.02.10'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/transition/links> .
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2019.02.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/transition/sdtypes> .
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2016.10.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/transition/linked-hypernyms> .
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2019.02.10'^^<http://www.w3.org/2001/XMLSchema#string> . }
                        UNION
                        {
                            ?distribution dct:hasVersion ?version {
                                SELECT (?v as ?version) { 
                                    ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/transition/linked-hypernyms> . 
                                    ?dataset dct:hasVersion ?v . 
                                } ORDER BY DESC (?version) LIMIT 1 
                            }
                        }
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/propan/lhd> .
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/propan/lhd/linked-hypernyms> .
                        {
                            ?distribution <http://dataid.dbpedia.org/ns/cv#type> ?c0 .
                            VALUES ?c0 {
                                'extension'^^<http://www.w3.org/2001/XMLSchema#string>
                                'core'^^<http://www.w3.org/2001/XMLSchema#string>
                            }
                        }
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2016.04.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/ontologies/dbpedia.org> .
                    { ?distribution <http://dataid.dbpedia.org/ns/cv#type> 'parsed'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    { ?distribution <http://dataid.dbpedia.org/ns/core#formatExtension> 'nt'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.09-192002'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/ontologies/dbpedia.org/ontology--DEV> .
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/vehnem/yago> .
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/vehnem/yago/taxonomy> .
                        {
                            ?distribution dct:hasVersion ?version {
                                SELECT (?v as ?version) { 
                                    ?dataset dataid:artifact <https://databus.dbpedia.org/vehnem/yago/taxonomy> . 
                                    ?dataset dct:hasVersion ?v . 
                                } ORDER BY DESC (?version) LIMIT 1 
                            }
                        }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/vehnem/yago/instance-types> .
                        {
                            ?distribution dct:hasVersion ?version {
                                SELECT (?v as ?version) { 
                                    ?dataset dataid:artifact <https://databus.dbpedia.org/vehnem/yago/instance-types> . 
                                    ?dataset dct:hasVersion ?v . 
                                } ORDER BY DESC (?version) LIMIT 1 
                            }
                        }
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/vehnem/replaced-iris> .
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/vehnem/replaced-iris/sameAs> .
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/vehnem/replaced-iris/labels> .
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                }
                UNION
                {
                    ?dataset dataid:group <https://databus.dbpedia.org/dbpedia/text> .
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/text/long-abstracts> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                    UNION
                    {
                        ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/text/short-abstracts> .
                        { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                        { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
                    }
                }
            }
        }

    }
    UNION
    {
        SELECT DISTINCT ?file ?g WHERE {
            GRAPH ?g {
                ?dataset dcat:distribution ?distribution .
                ?distribution dataid:file ?file .
                ?dataset dataid:artifact <https://databus.dbpedia.org/dbpedia/mappings/mappingbased-objects> .
                { ?distribution <http://dataid.dbpedia.org/ns/core#compression> 'bzip2'^^<http://www.w3.org/2001/XMLSchema#string> . }
                { ?distribution <http://dataid.dbpedia.org/ns/cv#lang> 'en'^^<http://www.w3.org/2001/XMLSchema#string> . }
                { ?distribution <http://purl.org/dc/terms/hasVersion> '2022.03.01'^^<http://www.w3.org/2001/XMLSchema#string> . }
            FILTER regex ( str(?file), ".*mappingbased-objects_lang=en.ttl.bz2" )
            }
        }
    }
    UNION
    {
        SELECT ?file {
          VALUES (?lang ?version) { 
        ( "sv"^^xsd:string "2022.03.01"^^xsd:string )
        ( "eo"^^xsd:string "2022.03.01"^^xsd:string )
        ( "de"^^xsd:string "2022.03.01"^^xsd:string )
        ( "id"^^xsd:string "2022.03.01"^^xsd:string )
        ( "eu"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ru"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ca"^^xsd:string "2022.03.01"^^xsd:string )
        ( "el"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ja"^^xsd:string "2022.03.01"^^xsd:string )
        ( "nl"^^xsd:string "2022.03.01"^^xsd:string )
        ( "fr"^^xsd:string "2022.03.01"^^xsd:string )
        ( "es"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ga"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ko"^^xsd:string "2022.03.01"^^xsd:string )
        ( "pt"^^xsd:string "2022.03.01"^^xsd:string )
        ( "cs"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ar"^^xsd:string "2022.03.01"^^xsd:string )
        ( "it"^^xsd:string "2022.03.01"^^xsd:string )
        ( "uk"^^xsd:string "2022.03.01"^^xsd:string )
        ( "zh"^^xsd:string "2022.03.01"^^xsd:string )
        ( "pl"^^xsd:string "2022.03.01"^^xsd:string )

          }
            ?did dataid:artifact <https://databus.dbpedia.org/vehnem/replaced-iris/long-abstracts> .
            ?did dct:hasVersion ?version .
            ?did dcat:distribution ?dis .
            ?dis dataid:contentVariant ?lang .
            ?dis dataid:file ?file .
        }
    }
    UNION
    {
        SELECT ?file {
          VALUES (?lang ?version) { 
        ( "sv"^^xsd:string "2022.03.01"^^xsd:string )
        ( "eo"^^xsd:string "2022.03.01"^^xsd:string )
        ( "de"^^xsd:string "2022.03.01"^^xsd:string )
        ( "id"^^xsd:string "2022.03.01"^^xsd:string )
        ( "eu"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ru"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ca"^^xsd:string "2022.03.01"^^xsd:string )
        ( "el"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ja"^^xsd:string "2022.03.01"^^xsd:string )
        ( "nl"^^xsd:string "2022.03.01"^^xsd:string )
        ( "fr"^^xsd:string "2022.03.01"^^xsd:string )
        ( "es"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ga"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ko"^^xsd:string "2022.03.01"^^xsd:string )
        ( "pt"^^xsd:string "2022.03.01"^^xsd:string )
        ( "cs"^^xsd:string "2022.03.01"^^xsd:string )
        ( "ar"^^xsd:string "2022.03.01"^^xsd:string )
        ( "it"^^xsd:string "2022.03.01"^^xsd:string )
        ( "uk"^^xsd:string "2022.03.01"^^xsd:string )
        ( "zh"^^xsd:string "2022.03.01"^^xsd:string )
        ( "pl"^^xsd:string "2022.03.01"^^xsd:string )

          }
            ?did dataid:artifact <https://databus.dbpedia.org/vehnem/replaced-iris/short-abstracts> .
            ?did dct:hasVersion ?version .
            ?did dcat:distribution ?dis .
            ?dis dataid:contentVariant ?lang .
            ?dis dataid:file ?file .
        }
    } 
 }
kurzum commented 1 year ago

Dude, use POST ;)