Page MenuHomePhabricator

SWEPUB Sparql Wikidata
Open, Needs TriagePublic

Description

Task: To see if we have any added value by connecting SWEPUB and Wikidata using federation et al
Status: Stalled waiting on SWEPUB to decide license of metadata?!?!?

Background: I was at the SWEPUB userday (link) and thought we could better connect. This task is a first try to find out how. Maybe we can use SPARQL endpoints (looks like SWEPUB wants a username password?!?!)

Information needed to add SWEPUB as an endpoint in Wikidata

Compare T200668: Set up Nobel Data as federated search with Wikidata

From Wikidata:SPARQL_federation_input we need the following info

TODO: Check with SWEPUB

SPARQL Endpointhttp://virhp07.libris.kb.se/sparql/ - query UI select avancerad
Documentation???? http://www.kb.se/libris/SwePub/Format-och-praxis/
Licenseterms-of-use CC-0 ???
BackgroundSWEPUB info is a good match with Scholia as SWEPUB has articles, conference papers, theses etc. published at Swedish higher education institutions and authorities and they also have an SPARQL endpoint

Links

Modell




cc. @Fnielsen any thoughts?!?!?

Event Timeline

Salgo60 created this task.Feb 22 2019, 1:20 PM
Salgo60 updated the task description. (Show Details)Feb 22 2019, 3:02 PM
Salgo60 updated the task description. (Show Details)
Salgo60 added a subscriber: Fnielsen.
Salgo60 updated the task description. (Show Details)Feb 22 2019, 3:07 PM
Salgo60 updated the task description. (Show Details)Feb 22 2019, 3:10 PM
Salgo60 updated the task description. (Show Details)

Test URL with the query below

PREFIX swpa_m: http://swepub.kb.se/SwePubAnalysis/model#
SELECT DISTINCT ?_onetitle as ?title ?_issn as ?printISN ?_eissn as ?electronicISSN xsd:int(?_weight) as ?NorwegianLevel xsd:int(?_weight7) as ?FinnishLevel xsd:int(?_weight8) as ?DanishLevel ?SwedishLevel
WHERE (

?Journal a swpa_m:Journal .
?Journal swpa_m:onetitle ?_onetitle .
OPTIONAL { ?Journal swpa_m:eissn ?_eissn . }
OPTIONAL { ?Journal swpa_m:issn ?_issn . }
FILTER ( bound(?_issn) || bound(?_eissn) )
?Journal swpa_m:hasRank ?SwedishRank .
?SwedishRank a swpa_m:SwedishRank .
?SwedishRank swpa_m:weight ?SwedishLevel . 
OPTIONAL {
?Journal swpa_m:hasRank ?NorwegianRank .
?NorwegianRank a swpa_m:NorwegianRank .
?NorwegianRank swpa_m:weight ?_weight .
}

OPTIONAL {
?Journal swpa_m:hasRank ?FinnishRank .
?FinnishRank a swpa_m:FinnishRank .
?FinnishRank swpa_m:weight ?_weight7 .}

OPTIONAL {

?Journal swpa_m:hasRank ?DanishRank .
?DanishRank a swpa_m:DanishRank .
?DanishRank swpa_m:weight ?_weight8 .}
}
LIMIT 100000&format=text/html&timeout=0&debug=on

Salgo60 updated the task description. (Show Details)Feb 22 2019, 3:28 PM
Salgo60 updated the task description. (Show Details)Feb 22 2019, 3:50 PM
Salgo60 updated the task description. (Show Details)
Salgo60 updated the task description. (Show Details)Feb 22 2019, 4:20 PM
Salgo60 updated the task description. (Show Details)
Salgo60 updated the task description. (Show Details)Feb 22 2019, 6:07 PM
Salgo60 updated the task description. (Show Details)Feb 23 2019, 8:44 AM
Salgo60 updated the task description. (Show Details)Feb 23 2019, 8:52 AM
Salgo60 updated the task description. (Show Details)Feb 23 2019, 8:56 AM
Salgo60 updated the task description. (Show Details)
Abbe98 added a subscriber: Abbe98.Feb 23 2019, 7:11 PM

@Salgo60 what are you trying to do here?

The SWEPUB SPARQL endpoint works great without auth and the data is indeed CC0...

Salgo60 added a comment.EditedFeb 24 2019, 10:10 AM

@Abbe98 ok do you have a link stating CC-0 of the meta data? I guess that is what we need... to start the process of setting up a SPARQL federation in WIkidata

Todo list as I see it

  • wait until this is approved and set up in WIkidata --> it will appear on page SPARQL_Federation_endpoints
  • understand how we write query between Wikidata and Swepub I guess we can use DOI and ORCID

What are the benefits of Wikidata <-> SWEPUB

I guess both will benefit. I was at SWEPUB userday 2019 and missed a holistic vision compare the Bologna workshop on Open Citations (hashtag #WOOC2018) and the presentation by Diego Chialva ERCEA (European Research Council Executive Agency) link presentation and link video on slide 18 is Wikibase(i.e. Wikidata) mentioned as the tool they speak about using,

At SWEPUB my feeling is that they are struggling with basic things like getting Swedish research organizations getting money to report back adding categories to classify the research so some evaluation can be done in Sweden.... no speaking about linked data or no more advanced concepts did I hear.... I feels I see the same problems/patterns with SILOS we see with cultural databases and museums.... maybe European Research Council could be the driver..... maybe I am wrong as I have no skills/experience in this area

Task {T216409: Nobelprize as part of evaluating research in different countries} is also a spin off from that Bologna workshop on Open Citations ....

Added value for SWEPUB is I guess that Wikidata/Wikipedia

  1. Has articles about a lot of researchers in + 300 languages
  2. Wikidata has a rich property model -->
    1. you have +100 Authority property information
    2. you have just for Academics/researchers +17 properties e.g. ORCID, ACM Digital Library author ID, Academic Tree ID (P2381) , CONICET person ID, DBLP ID (P2456), Dialnet author ID (P1607), Dictionary Grierson ID (P3946), Google Scholar författar ID (P1960), IPNI author ID (P586), MTMT author ID (P2492), Persons ID på ResearchGate (P2038), ResearcherID (P1053).....
  3. lesson learned from T200668: Set up Nobel Data as federated search with Wikidata is that Wikidata is fast updating (not always correct but...) and also supports having sources/references for statements

Today project Scholia using Wikidata for creating Open citation Graphs is more than interesting. See tweet were we find Swedish female researches with most quoted science articles BUT no sv:WIkipedia article --> could be an indication that an sv:Wikipedia article should be written. I guess with Wikidata <-> Swepub Wikidata will get better quality of this data ...

result from a search in tweet

DOI/ORCID

My understanding is that Wikidata has +460 000 researchers with ORCID P496 and if we check Scholia we have 16527450 objects with DOI P356

As Swepub also have DOI and ORCID I guess they are a good candidates for "same as" and doing SPARQL federated queries

The future will tell ;-)

Salgo60 added a comment.EditedFeb 25 2019, 10:51 AM

@Abbe98 how do you understand this answer

Is it a go no go for Wikidata <-> Swepub? My understanding is that they have a SPARQL db but has no experience in federation.... or share data....

FYI: I started to look how we could better populate Wikidata information from other sources like Karolinska Institutet tweet

Interesting to read page Altmetrics – support for science communication

and the WIkipedia section....

I started to connect researchers youtube video at Karolinska with the youtube presentation Karolinska has

report

I do still not see the problem you can do Federated SPARQL without the endpoint being CC0.

@Abbe98 yes but inside Wikidata they say on Wikidata:SPARQL_federation_input

so I guess best is like with LIBRIS XL a CC0 statement see T200191: Document what license Libris XL data is available under . But we need a license statement from the SWEPUB people.... the latest bid is they redesign the SWEPUB solution ?!?!?!.... ==> I moved this task to Blocked ( best would be if they start using Wikibase... ;-) )

As a person just trying to touch CC0 things I can see other requests denied like "Persée ... a digital library of open access, mostly French-language scholarly journals" with the motivation

the license seems to say "strictly for non-commercial purposes", and since we can not ensure that WDQS queries would not be used for commercial purposes, this may create a licensing problem.

my understanding is as long as the SWEPUB cant point on a license statement for the SWEPUB data they have then Wikidata is not interested in setting up SPARQL federation with them ==> so this task is stalled...

Salgo60 updated the task description. (Show Details)Feb 26 2019, 4:58 AM