Difference between revisions of "Semantic Publishing Challenge Queries"

From BITPlan cr Wiki
Jump to navigation Jump to search
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
=Queries against wikidata =
 
  
−
== Q1.1 ==
 
−
List the full names of all editors of the proceedings of workshop W
 
  
−
Input for this query is the volume number.
+
= CEUR-WS Semantification Queries =
−
<source lang="sparql">
 
−
SELECT ?proceedings ?editor ?editorLabel ?affiliation ?affiliationLabel
 
−
WHERE{
 
−
  VALUES ?volume_number {"3262"}
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number;
 
−
              p:P98 [
 
−
                ps:P98 ?editor;
 
−
                pq:P1416 ?affiliation
 
−
              ].
 
−
 
 
−
  ?editor rdfs:label ?editorLabel. FILTER(lang(?editorLabel)="en")
 
−
  ?affiliation rdfs:label ?affiliationLabel. FILTER(lang(?affiliationLabel)="en")         
 
−
}
 
−
</source>
 
  
−
== Q1.2 ==
 
−
Count the number of papers in workshop W .
 
−
<source lang="sparql">
 
−
SELECT ?proceedings (COUNT(DISTINCT ?paper) as ?number_of_papers)
 
−
WHERE{
 
−
  VALUES ?volume_number {"3262"}
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number.
 
−
 
 
−
  ?paper wdt:P31 wd:Q13442814;
 
−
        wdt:P1433 ?proceedings.
 
−
}
 
−
GROUP BY ?proceedings
 
−
</source>
 
  
−
== Q1.3 ==
+
= Queries =
−
List the full names of all authors who have (co-)authored a paper in workshop W .
+
== Queries by Task ==
−
<source lang="sparql">
+
{{#ask: [[Concept:Query]]
−
SELECT DISTINCT ?proceedings ?author ?authorLabel
+
|mainlabel=Query
−
WHERE{
+
|?Query id = id
−
  VALUES ?volume_number {"3262"}
+
|?Query title = title
−
  ?proceedings wdt:P31 wd:Q1143604;
+
|?Query tryiturl = tryiturl
−
              wdt:P179 wd:Q27230297;
+
|?Query wdqsurl = wdqsurl
−
              p:P179/pq:P478 ?volume_number.
+
|?Query relevance = relevance
−
 
+
|?Query task = task
−
  ?paper wdt:P31 wd:Q13442814;
+
|limit=200
−
        wdt:P1433 ?proceedings;
+
|sort=Query task,Query id
−
        wdt:P50|wdt:P2093 ?author.
+
}}
−
  ?author rdfs:label ?authorLabel. FILTER(lang(?authorLabel)="en")
 
−
}
 
−
</source>
 
  
 +
= Queries by subjective Relevance =
 +
{{#ask: [[Concept:Query]]
 +
|mainlabel=Query
 +
|?Query id = id
 +
|?Query title = title
 +
|?Query tryiturl = tryiturl
 +
|?Query wdqsurl = wdqsurl
 +
|?Query relevance = relevance
 +
|?Query task = task
 +
|limit=200
 +
|sort=Query relevance,Query task, Query id
 +
}}
  
−
== Q1.4 ==
 
−
Compute the average length of a paper (in pages) in workshop W
 
−
<source lang="sparql">
 
−
SELECT DISTINCT ?proceedings (AVG(?number_of_pages) as ?avg_number_of_pages)
 
−
WHERE{
 
−
  VALUES ?volume_number {"3262"}
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number.
 
−
 
 
−
  ?paper wdt:P31 wd:Q13442814;
 
−
        wdt:P1433 ?proceedings;
 
−
        wdt:P1104 ?number_of_pages.
 
−
}
 
−
GROUP BY ?proceedings
 
−
</source>
 
  
−
== Q1.5 ==
+
== Q0 (Additional Queries) ==
−
(publication turnaround) Find out whether the proceedings of work-
+
{| class="wikitable"
−
shop W were published on CEUR-WS.org before the workshop took place.
+
! Query !! Definition
 +
|-
 +
| Q0.8 || List the full names of all authors with their affiliation who have (co-)authored a paper
 +
in workshop W (combines Q1.3 and Q2.1)
 +
|}
  
−
This query lists all proceedings that were published before the event took place.
+
= Stakeholder Query Relevance =
−
<source lang="sparql">
+
{| class="wikitable" style="margin:auto"
−
SELECT DISTINCT ?proceedings ?pub_date ?event ?start_date
+
|-
−
WHERE{
+
! Stakeholder !! Interests !! Queries
−
  ?proceedings wdt:P31 wd:Q1143604;
+
|-
−
              wdt:P179 wd:Q27230297;
+
| Researcher / Author
−
              p:P179/pq:P478 ?volume_number;
+
|
−
              wdt:P577 ?pub_date;
+
* finding conferences/workshops
−
              wdt:P4745 ?event.
+
* finding papers
−
  ?event wdt:P580 ?start_date.
+
* finding authors
−
  FILTER(?pub_date < ?start_date)
+
|
−
}
+
* Q1.3 & Q4.1
−
</source>
+
* Q1.6
 +
* Q1.8
 +
* Q3.3
 +
* Q3.7
 +
* Q3.4
 +
* Q3.1 (show all works of an author)
  
−
== Q1.6 ==
+
|-
−
(previous editions of a workshop) Identify all editions that the work-
+
| Editors
−
shop series titled T has published with CEUR-WS.org.
+
| 
−
<source lang="sparql">
+
* finding authors
−
SELECT DISTINCT ?event ?ordinal ?proceedings ?volume_number
+
* finding previous events/proceedings of the series
−
WHERE{
+
|
−
  VALUES ?series_title {"Wikidata Workshop"@en}
+
* Q1.3
−
  VALUES ?series_type{ wd:Q47459256 wd:Q47258130 }
+
* Q1.6
−
  ?series wdt:P31 ?series_type;
 
−
          wdt:P1476|rdfs:label ?series_title.
 
−
  ?event p:P179 [
 
−
            ps:P179 ?series;
 
−
            pq:P1545 ?ordinal
 
−
          ].
 
  
−
  ?proceedings wdt:P31 wd:Q1143604;
+
|-
−
              wdt:P179 wd:Q27230297;
+
| Organizer
−
              p:P179/pq:P478 ?volume_number;
+
|
−
              wdt:P4745 ?event.
+
* information about the series
−
}
+
* quality of submitted papers
−
</source>
+
** 
 +
|
 +
* Q1.20
  
 +
|-
 +
| Publisher
 +
|
 +
* information about the editors
 +
* quality of proceedings/event
 +
** increasing/decreasing → reject/accept proceeding
 +
* provide access to proceedings/papers
 +
** increase visibility (SEO, linking to other sources)
 +
|
 +
* Q1.1
 +
* Q1.8 (colocated with)
 +
* Q1.9
 +
* Q3.1
 +
* Q3.2
 +
* Q4.1
  
 +
|-
 +
| Indexer
 +
|
 +
* metadata about
 +
** proceedings
 +
** conference(workshop
 +
** papers
 +
** editors
 +
**authors
 +
|
 +
* Q1.1
 +
* Q1.3
 +
* Q1.14
 +
* Q4.1
 +
* Q4.2
  
−
== Q1.7 ==
+
|-
−
Identify the full names of those chairs of the workshop series titled T that have so far been a chair in every edition of the workshop published with CEUR-WS.org.
+
| Platforms (Search & Recommendation)
−
<source lang="sparql">
+
|
−
SELECT DISTINCT ?programm_commitee ?programm_commiteeLabel
+
* quality of papers
−
WHERE{
+
** citation counts → impact of the paper
−
  VALUES ?series_title {"Wikidata Workshop"@en}
+
* quality of conference/workshop
−
  VALUES ?series_type{ wd:Q47459256 wd:Q47258130 }
+
** consistency of the event
−
  ?series wdt:P31 ?series_type;
+
** quality of papers
−
          wdt:P1476|rdfs:label ?series_title.
+
* subjects of paper/event
−
  ?event p:P179 [
+
|
−
            ps:P179 ?series;
+
* recomendation
−
            pq:P1545 ?ordinal
+
** Q1.13
−
          ];
+
** Q3.3 (CfP)
−
        wdt:P5804 ?programm_commitee;
+
* trend detection
−
        ^wdt:P4745/wdt:P179 wd:Q27230297.
+
** Q1.2
−
  {
+
** Q1.16
−
    SELECT (COUNT(DISTINCT ?event) as ?number_of_events)
+
* information retrival
−
    WHERE{
+
** Q1.6
−
      VALUES ?series_title {"Wikidata Workshop"@en}
+
** Q1.8 (colocated with)
−
      VALUES ?series_type{ wd:Q47459256 wd:Q47258130 }
+
** Q2.3
−
      ?series wdt:P31 ?series_type;
+
** Q2.4
−
          wdt:P1476|rdfs:label ?series_title.
+
** Q2.5
−
      ?event p:P179 [
 
−
            ps:P179 ?series;
 
−
            pq:P1545 ?ordinal
 
−
          ];
 
−
          wdt:P5804 ?programm_commitee;
 
−
          ^wdt:P4745/wdt:P179 wd:Q27230297.
 
−
      }
 
−
    }
 
  
−
  ?programm_commitee rdfs:label ?programm_commiteeLabel. FILTER(lang(?programm_commiteeLabel)="en")
+
|-
−
}GROUP BY ?programm_commitee ?number_of_events ?programm_commiteeLabel
+
|}
−
HAVING (?number_of_events = COUNT(?programm_commitee))
 
−
</source>
 
−
 
 
−
== Q1.8 ==
 
−
Identify all CEUR-WS.org proceedings volumes in which workshops of conference C in year Y were published.
 
−
 
 
−
<source lang="sparql">
 
−
SELECT DISTINCT *
 
−
WHERE{
 
−
  VALUES ?conference_title {"ESWC 2022"@en}
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number;
 
−
              wdt:P577 ?pub_date;
 
−
              wdt:P4745 ?workshop.
 
−
  ?workshop wdt:P11633 ?conference.  # colocated with
 
−
  ?conference wdt:P1476|rdfs:label ?conference_title.
 
−
 
 
−
FILTER(YEAR(?pub_date)= "2022"^^xsd:integer)
 
−
}
 
−
</source>
 
−
 
 
−
== Q1.9 ==
 
−
Identify those papers of workshop W that were (co-)authored by at least one chair of the workshop.
 
−
 
 
−
<source lang="sparql">
 
−
SELECT DISTINCT ?proceedings ?paper ?paperLabel ?event ?eventLabel ?author ?authorLabel
 
−
WHERE{
 
−
  #VALUES ?volume_number {"3262"}
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number;
 
−
              wdt:P4745 ?event.
 
−
 
 
−
  ?paper wdt:P31 wd:Q13442814;
 
−
        wdt:P1433 ?proceedings;
 
−
        wdt:P50|wdt:P2093 ?author.
 
−
  ?event wdt:P5804 ?author.
 
−
 
 
−
 
 
−
  ?author rdfs:label ?authorLabel. FILTER(lang(?authorLabel)="en")
 
−
  ?paper rdfs:label ?paperLabel. FILTER(lang(?paperLabel)="en")
 
−
  ?event rdfs:label ?eventLabel. FILTER(lang(?eventLabel)="en")
 
−
}
 
−
</source>
 
−
 
 
−
== Q1.10 ==
 
−
List the full names of all authors of invited papers in workshop W
 
−
 
 
−
 
 
−
invited papers are currently not covered by wikidata
 
−
<source lang="sparql">
 
−
 
 
−
</source>
 
−
 
 
−
== Q1.11 ==
 
−
Determine the number of editions that the workshop series titled T
 
−
has had, regardless of whether published with CEUR-WS.org.
 
−
 
 
−
<source lang="sparql">
 
−
SELECT DISTINCT ?series ?seriesLabel (Count(DISTINCT ?event2)as ?number_of_events)
 
−
WHERE{
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number;
 
−
              wdt:P4745 ?event.
 
−
  ?event wdt:P179 ?series.
 
−
  ?event2 wdt:P179 ?series.
 
−
  ?series rdfs:label ?seriesLabel. FILTER(lang(?seriesLabel)="en")
 
−
}
 
−
GROUP BY ?series ?seriesLabel
 
−
</source>
 
−
 
 
−
 
 
−
== Q1.12 ==
 
−
(change of workshop title) Determine the title (without year) that workshop W had in its first edition.
 
−
 
 
−
 
 
−
<source lang="sparql">
 
−
SELECT DISTINCT ?event ?eventLabel
 
−
WHERE{
 
−
  VALUES ?event_title {"The Third Wikidata Workshop"@en}
 
−
  ?proceedings wdt:P31 wd:Q1143604;
 
−
              wdt:P179 wd:Q27230297;
 
−
              p:P179/pq:P478 ?volume_number;
 
−
              wdt:P4745 ?e.
 
−
  ?e wdt:P179 ?series;
 
−
        wdt:P1476|rdfs:label ?event_title.
 
−
  ?event p:P179 [
 
−
                  ps:P179 ?series;
 
−
                  pq:P1545 ?ordinal
 
−
  ].
 
−
  ?event rdfs:label ?eventLabel. FILTER(lang(?eventLabel)="en")
 
−
}
 
−
ORDER BY ?ordinal
 
−
LIMIT 1
 
−
 
 
−
</source>
 
  
 +
== Queries for specific quality aspects ==
 +
* [[Q1.4]]
 +
* [[Q1.5]]
 +
* [[Q1.7]]
 +
* [[Q1.9]]
 +
* [[Q1.12]]
 +
* [[Q1.13]]
 +
* [[Q1.16]]
 +
* [[Q1.17]]
 +
* [[Q1.18]]
 +
* [[Q1.19]]
 +
* [[Q1.20]]
  
 
[[Category:Text2KG]]
 
[[Category:Text2KG]]

Latest revision as of 11:01, 22 March 2023


CEUR-WS Semantification Queries

Queries

Queries by Task

Queryidtitletryiturlwdqsurlrelevancetask
Q0.11All proceedingskfm8ib6UCU1Task0
Q0.22All papersK452U46UJb1Task0
Q0.33All eventsBww8ip6UKq1Task0
Q0.44All event seriesJqXf3G6UE41Task0
Q0.55All scholars3mUK8B6UT61Task0
Q0.66All institutionsz7hnKG6UKK1Task0
Q0.77authors of papers of proceedingsP7jZJm6UTH1Task0
Q0.88Duplicate and Empty URNs of proceedingsOLyKEm8eaz1Task0
Q0.99Duplicate CEUR-WS Volume numbers of proceedingshJlygL8ea41Task0
Q0.1010Locations of all CEUR-WS proceedings proceedings events8gRw1Task0
Q0.1111Events events and proceedings proceedings grouped by Event Series1Task0
Q1.11All Editors of Workshop(Volume W)JGBD4b6UAa3Task1
Q1.22Number of Papers in Workshop(Volume W)9e3zUz6UAd3Task1
Q1.33All Authors of Workshop6JIyAd6UAf2Task1
Q1.44Average #of pages in workshopNGlB2l6UAX3Task1
Q1.55Publication turnaroundPAvC7D6UAk3Task1
Q1.66previous editions of a workshopkUPI5O6UAo1Task1
Q1.77chairs over the history of a workshopngbkiD6UAu4Task1
Q1.88Workshops of Conference in Yearj57HVl6UAw2Task1
Q1.99Chair of Workshop as CoauthorqKaWxd6UA$3Task1
Q1.1010Authors of invited papers4Task1
Q1.1111Number of Editions of workshop seriesuVEk8R6UB42Task1
Q1.1212Change of Workshop titlea1sm2q6UB53Task1
Q1.1313workshops that have died3Task1
Q1.1414Jointly published papersvgcLz46UBA2Task1
Q1.1515Editors of jointly published papersTBhxb56UBB3Task1
Q1.1616Workshop with biggest percent of growth of number of papers5Task1
Q1.1717change of conference affiliation(Event,Year)3Task1
Q1.1818change of workshop date3Task1
Q1.1919institutional diversity and internationality of chairs3Task1
Q1.2020continuity of authors4Task1
Q2.11Affiliations of Authors (Paper X)3Task2
Q2.22Papers from country at Workshop3Task2
Q2.33Works cited by paperG7PGHO6UBC2Task2
Q2.44Works cited by paper after yearQ32kCB6UBF3Task2
Q2.55Journal papers cited by a paper4Task2
Q2.66grants for research in paper5Task2
Q2.77Funding agency for research of paper5Task2
Q2.88EU projects supporting research in paper5Task2
Q2.99Ontologies mentioned in abstract of paper5Task2
Q2.1010Ontologies introduced in paper abstract5Task2
Q3.11Same entities within the CEUR-WS.org dataset2Task3
Q3.22Same entities across different datasets1Task3
Q3.33Workshop call for papersn57R4b6UKs2Task3
Q3.44Workshop website98pi386ULB2Task3
Q3.55Overall contribution to the conference4Task3
Q3.66Overall activity in a year6UTP3Task3
Q3.77Full series of workshops1Task3
Q3.88Coauthorship(Scholar A, Paper P, Year Y)->Scholar5Task3

Queries by subjective Relevance

Queryidtitletryiturlwdqsurlrelevancetask
Q0.11All proceedingskfm8ib6UCU1Task0
Q0.22All papersK452U46UJb1Task0
Q0.33All eventsBww8ip6UKq1Task0
Q0.44All event seriesJqXf3G6UE41Task0
Q0.55All scholars3mUK8B6UT61Task0
Q0.66All institutionsz7hnKG6UKK1Task0
Q0.77authors of papers of proceedingsP7jZJm6UTH1Task0
Q0.88Duplicate and Empty URNs of proceedingsOLyKEm8eaz1Task0
Q0.99Duplicate CEUR-WS Volume numbers of proceedingshJlygL8ea41Task0
Q0.1010Locations of all CEUR-WS proceedings proceedings events8gRw1Task0
Q0.1111Events events and proceedings proceedings grouped by Event Series1Task0
Q1.66previous editions of a workshopkUPI5O6UAo1Task1
Q3.22Same entities across different datasets1Task3
Q3.77Full series of workshops1Task3
Q1.33All Authors of Workshop6JIyAd6UAf2Task1
Q1.88Workshops of Conference in Yearj57HVl6UAw2Task1
Q1.1111Number of Editions of workshop seriesuVEk8R6UB42Task1
Q1.1414Jointly published papersvgcLz46UBA2Task1
Q2.33Works cited by paperG7PGHO6UBC2Task2
Q3.11Same entities within the CEUR-WS.org dataset2Task3
Q3.33Workshop call for papersn57R4b6UKs2Task3
Q3.44Workshop website98pi386ULB2Task3
Q1.11All Editors of Workshop(Volume W)JGBD4b6UAa3Task1
Q1.22Number of Papers in Workshop(Volume W)9e3zUz6UAd3Task1
Q1.44Average #of pages in workshopNGlB2l6UAX3Task1
Q1.55Publication turnaroundPAvC7D6UAk3Task1
Q1.99Chair of Workshop as CoauthorqKaWxd6UA$3Task1
Q1.1212Change of Workshop titlea1sm2q6UB53Task1
Q1.1313workshops that have died3Task1
Q1.1515Editors of jointly published papersTBhxb56UBB3Task1
Q1.1717change of conference affiliation(Event,Year)3Task1
Q1.1818change of workshop date3Task1
Q1.1919institutional diversity and internationality of chairs3Task1
Q2.11Affiliations of Authors (Paper X)3Task2
Q2.22Papers from country at Workshop3Task2
Q2.44Works cited by paper after yearQ32kCB6UBF3Task2
Q3.66Overall activity in a year6UTP3Task3
Q1.77chairs over the history of a workshopngbkiD6UAu4Task1
Q1.1010Authors of invited papers4Task1
Q1.2020continuity of authors4Task1
Q2.55Journal papers cited by a paper4Task2
Q3.55Overall contribution to the conference4Task3
Q1.1616Workshop with biggest percent of growth of number of papers5Task1
Q2.66grants for research in paper5Task2
Q2.77Funding agency for research of paper5Task2
Q2.88EU projects supporting research in paper5Task2
Q2.99Ontologies mentioned in abstract of paper5Task2
Q2.1010Ontologies introduced in paper abstract5Task2
Q3.88Coauthorship(Scholar A, Paper P, Year Y)->Scholar5Task3


Q0 (Additional Queries)

Query Definition
Q0.8 List the full names of all authors with their affiliation who have (co-)authored a paper

in workshop W (combines Q1.3 and Q2.1)

Stakeholder Query Relevance

Stakeholder Interests Queries
Researcher / Author
  • finding conferences/workshops
  • finding papers
  • finding authors
  • Q1.3 & Q4.1
  • Q1.6
  • Q1.8
  • Q3.3
  • Q3.7
  • Q3.4
  • Q3.1 (show all works of an author)
Editors
  • finding authors
  • finding previous events/proceedings of the series
  • Q1.3
  • Q1.6
Organizer
  • information about the series
  • quality of submitted papers
  • Q1.20
Publisher
  • information about the editors
  • quality of proceedings/event
    • increasing/decreasing → reject/accept proceeding
  • provide access to proceedings/papers
    • increase visibility (SEO, linking to other sources)
  • Q1.1
  • Q1.8 (colocated with)
  • Q1.9
  • Q3.1
  • Q3.2
  • Q4.1
Indexer
  • metadata about
    • proceedings
    • conference(workshop
    • papers
    • editors
    • authors
  • Q1.1
  • Q1.3
  • Q1.14
  • Q4.1
  • Q4.2
Platforms (Search & Recommendation)
  • quality of papers
    • citation counts → impact of the paper
  • quality of conference/workshop
    • consistency of the event
    • quality of papers
  • subjects of paper/event
  • recomendation
    • Q1.13
    • Q3.3 (CfP)
  • trend detection
    • Q1.2
    • Q1.16
  • information retrival
    • Q1.6
    • Q1.8 (colocated with)
    • Q2.3
    • Q2.4
    • Q2.5

Queries for specific quality aspects

Retrieved from "https://cr.bitplan.com/index.php?title=Semantic_Publishing_Challenge_Queries&oldid=1960"