Latest revision as of 07:11, 12 May 2024

CEUR-WS Example

Relevant Entity Classes and their Relationships

Following strictly the 80% Pareto rule results in the class diagram below with the entity classes being proceedings, event, human_settlement (city), region, and country. The entity classes that are ignored because they are under represented are Scholar, scholarly article, Event Series and also the distinction into Workshops and Conferences. Note: For the classes human_settlement, region and sovereign_state several properties were excluded due to irrelevance for this context.

Edit diagram

Queries for EC Property usage

Proceedings

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?s) as ?count_p)
   WHERE {
     # Entity of Intrest: Q1143604 (proceedings)
     ?s wdt:P31/wdt:P279* wd:Q1143604.
	 # Context 
	 # part of the series CEUR-WS
	 ?s wdt:P179 wd:Q27230297.
     ?s ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent >= 80)
ORDER BY DESC(?count_p)

Try it!

Event

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?s) as ?count_p)
   WHERE {
     # Entity of Intrest: Q1656682 (event)
     ?s wdt:P31/wdt:P279* wd:Q1656682.
	 # Context 
	 { 
	    # is proceedings from → part of the series CEUR-WS
	    ?s ^wdt:P4745/wdt:P179 wd:Q27230297.
     } UNION {
	    # ^presented in → published in → part of the series CEUR-WS
	    ?s ^wdt:P5072/wdt:P1433/wdt:P179 wd:Q27230297.
     }
     ?s ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent >= 80)
ORDER BY DESC(?count_p)

Try it!

Scholar

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?s) as ?count_p)
   WHERE {
     # Entity of Intrest: Q5 (human)
     ?s wdt:P31/wdt:P279* wd:Q5.
	 # Context 
	 { 
	    # author of → published in → part of the series CEUR-WS
	    ?s ^wdt:P50/wdt:P1433/wdt:P179 wd:Q27230297.
     } UNION {
	    # editor of → part of the series CEUR-WS
	    ?s ^wdt:P98/wdt:P179 wd:Q27230297.
     }UNION {
	    # author of → published in → is in proceedings → part of the series CEUR-WS
	    ?s ^wdt:P98/wdt:P5072/^wdt:P4745/wdt:P179 wd:Q27230297.
     }
     ?s ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent > 80)
ORDER BY DESC(?count_p)

Try it!

human settlement

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?s) as ?count_p)
   WHERE {
     # Entity of Intrest: Q486972 (human settlement)
     ?s wdt:P31/wdt:P279* wd:Q486972.
	 # Context 
	 { 
	    # ^location →is proceedings from → part of the series CEUR-WS
	    ?s ^wdt:P276/^wdt:P4745/wdt:P179 wd:Q27230297.
     } UNION {
	    # ^location → ^presented in → published in → part of the series CEUR-WS
	    ?s ^wdt:P276/^wdt:P5072/wdt:P1433/wdt:P179 wd:Q27230297.
     }
     ?s ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent >= 80)
ORDER BY DESC(?count_p)

Try it!

souvereign state

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?s) as ?count_p)
   WHERE {
     # Entity of Intrest: Q3624078 (sovereign state)
     ?s wdt:P31/wdt:P279* wd:Q3624078.
	 # Context 
	 { 
	    # ^location →is proceedings from → part of the series CEUR-WS
	    ?s ^wdt:P17/^wdt:P4745/wdt:P179 wd:Q27230297.
     } UNION {
	    # ^location → ^presented in → published in → part of the series CEUR-WS
	    ?s ^wdt:P17/^wdt:P5072/wdt:P1433/wdt:P179 wd:Q27230297.
     }
     ?s ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent >= 80)
ORDER BY DESC(?count_p)

Try it!

region

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?region) as ?count_p)
   WHERE {
     # Entity of Intrest: Q486972 (human settlement)
     ?s wdt:P31/wdt:P279* wd:Q486972.
	 # Context 
	 { 
	    # ^location →is proceedings from → part of the series CEUR-WS
	    ?s ^wdt:P276/^wdt:P4745/wdt:P179 wd:Q27230297.
     } UNION {
	    # ^location → ^presented in → published in → part of the series CEUR-WS
	    ?s ^wdt:P276/^wdt:P5072/wdt:P1433/wdt:P179 wd:Q27230297.
     }
	 # located in the administrative territorial entity
     ?s wdt:P131+ ?region.
	 ?region ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent >= 80)
ORDER BY DESC(?count_p)

Try it!

Event Series

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
SELECT ?p ?wd_prop ?label ?count_p ((100.0 * ?count_p / ?total) AS ?percent)
WHERE {
  {
   # Entity Selection Query
   SELECT DISTINCT ?p (COUNT(DISTINCT ?s) as ?count_p)
   WHERE {
     # Entity of Intrest: Q15900616 (event sequence )
     ?s wdt:P31/wdt:P279* wd:Q15900616.
	 # Context 
	 { 
	    # ^part of the series →is proceedings from → part of the series CEUR-WS
	    ?s ^wdt:P179/^wdt:P4745/wdt:P179 wd:Q27230297.
     } UNION {
	    # ^part of the series → ^presented in → published in → part of the series CEUR-WS
	    ?s ^wdt:P179/^wdt:P5072/wdt:P1433/wdt:P179 wd:Q27230297.
     }
	 # located in the administrative territorial entity
     ?s ?p ?o.
   }
   GROUP BY ?p
  }
  OPTIONAL{
    ?wd_prop wikibase:directClaim ?p .
    ?wd_prop rdfs:label ?label .
    FILTER (LANG(?label) = "en") .
  } 
  FILTER(?p = rdfs:label || ?wd_prop || ?p = schema:description)
  BIND(MAX(?count_p) as ?total)
}
GROUP BY ?p ?wd_prop ?label ?count_p ?total
HAVING (?percent >= 80)
ORDER BY DESC(?count_p)

Try it!

Count Queries

Number of Workshops: https://qlever.cs.uni-freiburg.de/wikidata/fguMeE
Number of Conferences: 738 https://qlever.cs.uni-freiburg.de/wikidata/3SI8BD
Number of colocated with: 8 https://qlever.cs.uni-freiburg.de/wikidata/4wkIlI
Number of conference series links: https://qlever.cs.uni-freiburg.de/wikidata/cNAQMt
Number of workshop series links: 84
Number of paper linked to proceedings: 485
Number of papers linked directly to event: 19 https://qlever.cs.uni-freiburg.de/wikidata/kbJryF
Number of authors: 317 https://qlever.cs.uni-freiburg.de/wikidata/4TCCli
Number of editors: 41 https://qlever.cs.uni-freiburg.de/wikidata/Z6my6B

Revision as of 06:25, 29 December 2023 (view source) Wf (talk \| contribs) (pushed from rq by wikipush)		Latest revision as of 07:11, 12 May 2024 (view source) Wf (talk \| contribs)
Line 1:		Line 1:
		+	{{WorkSequence\|prev=Workdocumentation_2023-12-22\|next=Workdocumentation 2024-02-02}}
	= CEUR-WS Example =		= CEUR-WS Example =

Difference between revisions of "Workdocumentation 2023-12-23 TH"