Project

General

Profile

DOIBoost » History » Version 33

Alessia Bardi, 12/11/2021 12:05 PM
Use field names of the public json schema

1 1 Alessia Bardi
h1. DOIBoost
2
3 31 Claudio Atzori
{{>toc}}
4
5 4 Alessia Bardi
h2. DOIBoost: Crossref, Unpaywall, Microsoft Academic Graph, ORCID
6 1 Alessia Bardi
7
The idea behind DOIBoost and its origin can be found in the paper (and related resources) at: 
8
9
* La Bruzzo S., Manghi P., Mannocci A. (2019) OpenAIRE's DOIBoost - Boosting CrossRef for Research. In: Manghi P., Candela L., Silvello G. (eds) Digital Libraries: Supporting Open Science. IRCDL 2019. Communications in Computer and Information Science, vol 988. Springer, doi:10.1007/978-3-030-11226-4_11 . Open Access version available at: https://doi.org/10.5281/zenodo.1441071
10
11
In short, the goal is to enrich the records available on Crossref with what's available on Unpaywall, Microsoft Academic Graph, ORCID intersecting all those datasets by DOI.
12 5 Alessia Bardi
13
h3. Inputs
14
15 6 Alessia Bardi
* *Crossref*: dump available to Crossref subscribers via MetadataPlus service, updated once a month.
16 27 Claudio Atzori
* *Microsoft Academic Graph*: downloaded version on 2021-02-15. We plan to take the latest version in Dec 2021 before MAG will be retired.
17 18 Alessia Bardi
* *ORCID*: baseline dump obtained in 2020-10-13, regularly updated every week from the "ORCID public API":https://info.orcid.org/documentation/features/public-api/
18 7 Alessia Bardi
* *Unpaywall*: public database snapshot downloaded in March 2021. Unpaywall updates it twice a year (https://unpaywall.org/products/snapshot) 
19 5 Alessia Bardi
20 27 Claudio Atzori
The construction of the DOIBoost dataset consists of the following phases:
21 1 Alessia Bardi
22 26 Claudio Atzori
h3. 1 Filtering
23 1 Alessia Bardi
24 26 Claudio Atzori
Records in Crossref are ruled out according to the following criteria
25
26 1 Alessia Bardi
* have blank title
27 26 Claudio Atzori
* have one of the following publishers: @"Test accounts"@, @"CrossRef Test Account"@
28 1 Alessia Bardi
* have no authors with valid names, where valid means: not blank and different from all strings in this list: @List(",", "none none", "none, none", "none &na;", "(:null)", "test test test", "test test", "test", "&na; &na;")@
29 26 Claudio Atzori
* have @"Addie Jackson"@ as author and @"Elsevier BV"@ as publisher (empirically we say they are test records)
30 15 Alessia Bardi
* have not one of the following values in the field @type@:
31 26 Claudio Atzori
**   @"book-section"@
32
**   @"book"@
33
**   @"book-chapter"@
34
**   @"book-part"@
35
**   @"book-series"@
36
**   @"book-set"@
37
**   @"book-track"@
38
**   @"edited-book"@
39
**   @"reference-book"@
40
**   @"monograph"@
41
**   @"journal-article"@
42
**   @"dissertation"@
43
**   @"other"@
44
**   @"peer-review"@
45
**   @"proceedings"@
46
**   @"proceedings-article"@
47
**   @"reference-entry"@
48
**   @"report"@
49
**   @"report-series"@
50
**   @"standard"@
51
**   @"standard-series"@
52
**   @"posted-content"@
53
**   @"dataset"@
54 15 Alessia Bardi
55 1 Alessia Bardi
Records with @type=dataset@ are mapped into OpenAIRE results of type dataset. All others are mapped as OpenAIRE results of type publication.
56 19 Alessia Bardi
57 30 Claudio Atzori
h3. 2 Mapping Crossref properties into the OpenAIRE Research Graph
58 16 Alessia Bardi
59 27 Claudio Atzori
Properties in OpenAIRE results are set based on the logic described in the following table:
60 16 Alessia Bardi
61 1 Alessia Bardi
|_.OpenAIRE Result field path|_.Crossref path(s)|_.Notes|
62 33 Alessia Bardi
| id | doi | id in the form @doi_________::md5(doi) |
63
| type | type | @dataset@ if the Crossref type is dataset, @publication@ otherwise (based on the logics [[DOIBoost#1-Filtering|described above]]) |
64
| originalId | | TODO |
65
| maintitle | title |  |
66
| subtitle | subtitle |  |
67 1 Alessia Bardi
| author | author | if available the sequence is mapped to rank and the ORCID is also mapped (as 'orcid_pending') |
68 33 Alessia Bardi
| bestaccessright | | TODO |
69
| contributor | | TODO |
70
| country | | TODO |
71
| coverage | | TODO |
72
| dateofcollection | | TODO |
73
| description | abstract |  |
74
| embargoenddate | | TODO |
75 1 Alessia Bardi
| instance | | TODO One instance is created . . .  |
76 33 Alessia Bardi
| instance.accessright |  | Values in @instance.accessright.code@ and @instance.accessright.label@ are set based on license and dateofacceptance: 
77 1 Alessia Bardi
- UNKNOWN: if the license is blank
78
- OPEN ACCESS: if the license is a CC license or an ACS license or an APA license (considered OPEN also by Unpaywall, see "Unpaywall FAQ":https://support.unpaywall.org/support/solutions/articles/44002063718-what-is-an-oa-license- for details) or if OUP license, but only after 12 months from the publication date
79
- EMBARGO: OUP license, before 12 months from the publication date
80
- CLOSED: if there is a license not covered by the previous cases |
81 33 Alessia Bardi
| instance.accessright.code |  | Code from the "COAR vocabulary for access right":http://vocabularies.coar-repositories.org/documentation/access_rights/|
82
| instance.accessright.label |  | One of: OPEN, RESTRICTED, CLOSED, EMBARGO |
83
| instance.accessright.scheme |  | Scheme that defines the code and label, i.e. the URL to the "COAR vocabulary for access right":http://vocabularies.coar-repositories.org/documentation/access_rights/|
84
| instance.accessright.openAccessRoute |  | only if instance.accessright.value = 'OPEN ACCESS'. Default is 'hybrid'. The route is fixed in subsequent phases of DOIBoost, namely when intersecting with Unpaywall and patching the hostedby via DOAJ and the Gold-ISSN list.|
85
| instance.alternateIdentifier | | TODO|
86
| instance.alternateIdentifier.scheme | | DOUBLE CHECK |
87
| instance.alternateIdentifier.value | doi | DOUBLE CHECK |
88
| instance.license | license.URL| If there is a @license.content-version='vor'@, then this is used. Otherwise the first license entry is used. |
89
| instance.pid | doi | DOUBLE CHECK |
90
| instance.pid.scheme | | DOUBLE CHECK |
91
| instance.pid.value | doi | DOUBLE CHECK |
92
| instance.publicationDate | issued.datetime or, if not available, created.datetime|  |
93
| instance.refereed |  | set to 'peerReviewed' only if @relation.has-review.id@ is not empty. TODO: we probably need to change this|
94
| instance.type | subtype | mapped using the "OpenAIRE vocabulary for result typologies":https://api.openaire.eu/vocabularies/dnet:result_typologies |
95
| instance.url | URL, link.URL| there may be different URLs in the same instance | 
96
| instance.collectedfrom | | as in result.collectedfrom above 
97
TODO: double check if this field is in the dump. It seems it is not and we can remove it from here |
98
| language | | TODO |
99
| language.code | | TODO |
100
| language.label | | TODO |
101
| lastupdatetimestamp | | TODO |
102
| pid |  | The scheme tells the type of PID, the value contains the actual value |
103
| pid.scheme | One of: doi, clinical-trial-number, alternative-id | TODO DOUBLE CHECK |
104
| pid.value | doi, clinical-trial-number, alternative-id | TODO DOUBLE CHECK. the doi is normalised and lowered case. TODO: Is it correct to map alternate-id(s) as PIDs?  |
105
| publicationdate | issued.datetime or, if not available, created.datetime | TODO CHECK: in the instance we have publicationDate, here all lowercase.  |
106
| publisher | publisher |  |
107
| source | source |  only if the record is not of type @book@ |
108
| source | concatenation of @container-title.head@ "ISBN: " @ISBN.head@ | only if the record is of type @book@ |
109
| subject | subject | with classid='keywords', i.e. no controlled vocabularies for Crossref subjects |
110
| container |  | It is set only for publications with information about the journal it was published in. TODO: do we have also conference dates and places to map? |
111
| container.name | container-title.head| |
112
| container.issnOnline | issn-type.value| if issn-type.type='electronic'|
113
| container.issnPrinted | issn-type.value| if issn-type.type='print'|
114
| container.issnLinking | | Not mapped TODO: I think we should if Crossref has it|
115
| container.vol | volume| |
116
| container.sp | page | before '-'| 
117
| container.ep | page | after '-'| 
118
| container.iss | | Not mapped TODO: I think we should if Crossref has it|
119
| container.edition | | Not mapped TODO: I think we should if Crossref has it|
120
| container.conferencedate | | Not mapped| 
121
| container.conferencedate | | Not mapped| 
122
| dateofcollection|  indexed.datetime|  |
123
124
All other fields of the [[Json_schema]] not mentioned in the table contain empty values.
125
126
All the records from Crossref are related to the datasource with @name=Crossref@ and @id=openaire____::081b82f96300b6a6e3d282bad31cb6e2@
127
128
129
130
131
132
133
134
135 4 Alessia Bardi
136 2 Alessia Bardi
h3. 2 Map Crossref links to projects/funders
137 4 Alessia Bardi
138
Links to funding available in Crossref are mapped as funding relationships (@result@ -- @isProducedBy@ --> @project@) applying the following mapping:
139 3 Alessia Bardi
140
| *funder* | *grant code* | *Link to* |
141
| DOI: {10.13039/100010663, 10.13039/100010661, 10.13039/501100007601, 10.13039/501100000780, 10.13039/100010665}
142
or name: 'European Union’s Horizon 2020 research and innovation program' | series of 4-9 digits in @award@ | Link to H2020 project |
143
| DOI: {10.13039/100011199, 10.13039/100004431, 10.13039/501100004963, 10.13039/501100000780} | series of 4-9 digits in @award@  | Link to FP7 project |
144
| DOI: 10.13039/501100000781 OR name: 'European Union's'| series of 4-9 digits in @award@ | Link to FP7 or H2020 project |
145
| DOI: 10.13039/100000001 | @award@ | Link to NSF project |
146
| DOI: 10.13039/501100001665 OR name: {'The French National Research Agency (ANR)', 'The French National Research Agency'} | @award@ | Link to ANR project |
147
| DOI: 10.13039/501100002341 | @award@ | Link to Academy of Finland project |
148
| DOI: 10.13039/501100001602 | @award@, removing the initial 'SFI' if present | Link to SFI project |
149
| DOI: 10.13039/501100000923 | @award@ | Link to ARC project |
150
| DOI: 10.13039/501100000038 | @award@ ignore: we cannot map the project codes in Crossref to project codes in OpenAIRE | Link to NSERC (@unidentified@ project) |
151
| DOI: 10.13039/501100000155 | @award@ ignore: we cannot map the project codes in Crossref to project codes in OpenAIRE | Link to SSHRC (@unidentified@ project) |
152
| DOI: 10.13039/501100000024 | @award@ ignore: we cannot map the project codes in Crossref to project codes in OpenAIRE | Link to CIHR (@unidentified@ project) |
153
| DOI: 10.13039/501100002848 OR name :'CONICYT, Programa de Formación de Capital Humano Avanzado' | @award@ | Link to CONICYT project |
154
| DOI: 10.13039/501100003448 | series of 4-9 digits in @award@ | Link to GSRT project |
155
| DOI: 10.13039/501100010198 | @award@ | Link to SGOV project |
156
| DOI: 10.13039/501100004564 | series of 4-9 digits in @award@ | Link to MESTD project |
157
| DOI: 10.13039/501100003407 | @award@ | Link to MIUR project. Since OpenAIRE has a small subset of MIUR projects, a link to the MIUR funder (@unidentified@ project) is also generated |
158
| DOI: {10.13039/501100006588, 10.13039/501100004488} | @award@, removing 'Project No' and 'HRZZ' prefix, if present | Link to HRZZ or MZOS project |
159
| DOI: 10.13039/501100006769 | @award@ | Link to Russian Science Foundation project |
160
| DOI: 10.13039/501100001711 | @award@ after '_' and before '/' | Link to SNSF project |
161 1 Alessia Bardi
| DOI: 10.13039/501100004410 | @award@ | Link to TUBITAK project |
162
| DOI: 10.10.13039/100004440  or name: 'Wellcome Trust Masters Fellowship'| @award@ | Link to Wellcome Trust specific project and to the @unidentified@ project.|
163 4 Alessia Bardi
164 1 Alessia Bardi
h3. 3 Intersect Crossref with Unpaywall by DOI (DOIBoost1)
165 10 Alessia Bardi
166
The fields we consider from Unpaywall are:
167
* @is_oa@
168
* @best_oa_location@
169
* @oa_status@
170
171
The results of Crossref that intersect by DOI with Unpaywall records are enriched with:
172 11 Alessia Bardi
173
TODO: ensure we refer to json fields of the public dump 
174 10 Alessia Bardi
175 12 Alessia Bardi
|_.OpenAIRE Result field path |_.Unpaywall field path |_.Notes |
176 1 Alessia Bardi
| result.instance | | created only if @is_oa@ and a @best_oa_location@ is available |
177 11 Alessia Bardi
| result.instance.collectedfrom.name | | default value "Unpaywall" |
178 12 Alessia Bardi
| result.instance.collectedfrom.id | | default value TODO |
179
| result.instance.url | @best_oa_location@ | |
180
| result.instance.license | @best_oa_location.license@ | |
181 10 Alessia Bardi
| result.instance.pid | @doi@ | |
182 12 Alessia Bardi
| result.instance.accessright | | default value  Open Access: we do not add instances if Unpaywall says there is no open version|
183 10 Alessia Bardi
| result.instance.accessright.route | @oa_status@ | |
184 11 Alessia Bardi
185 9 Alessia Bardi
For the definition of Unpaywall's @oa_status@ refer to the "Unpaywall FAQ":https://support.unpaywall.org/support/solutions/articles/44001777288-what-do-the-types-of-oa-status-green-gold-hybrid-and-bronze-mean-
186
187
h3. 4 Intersect DOIBoost1 with ORCID (DOIBoost2)
188 21 Alessia Bardi
189
The fields we consider from ORCID are:
190 23 Alessia Bardi
* @doi@
191 21 Alessia Bardi
* @authors@, a list of authors, each with optional @name@, @surname@, @creditName@, @oid@
192
193
|_.OpenAIRE field path|_.ORCID path|_.Notes|
194
| pid | doi  |  |
195
| author.name | capitalize(name) |  only mapped if not blank|
196
| author.surname | capitalize(surname) | only mapped if not blank |
197
| author.fullname |  | if name and surname are not blank, they are concatenated (capitalize(name) capitalize(surname)), otherwise we use the creditName  |
198
| author.pid | oid | as confirmed ORCID identifier (in contrast to the 'orcid_pending' set from Crossref and Unpaywall |
199
200 4 Alessia Bardi
201
The records are enriched with the ORCID identifiers of their authors.
202
* if the number of authors from Crossref equals the size of authors from ORCID, then we pick the list of authors with more PIDs and try to enrich it with the PIDs from the other list, based on JaroWrinkler distance on on authors' names, surnames, or fullnames, depending on which properties are available;
203 21 Alessia Bardi
* if the number of authors are different, then we take the longest and try to enrich it with the PIDs from the other author list, based on JaroWrinkler distance on on authors' names, surnames, or fullnames, depending on which properties are available
204
205 4 Alessia Bardi
TODO: How do we ensure that if an author comes with an orcid_pending from Crossref and one orcid from ORCID, the last wins?
206 1 Alessia Bardi
207
h3. 5 Intersect DOIBoost2 with Microsoft Academic Graph (DOIBoost3)
208 24 Alessia Bardi
209
*Important Notes*
210
* Only papers with DOI are considered
211
* Since for the same DOI we have multiple version of item with different MAG PaperId, we only take one per DOI (the last one we process). We call this dataset @Papers_distinct@
212
213
When mapping MAG records to the OpenAIRE Research Graph, we consider the the following MAG tables:
214
* @PaperAbstractsInvertedIndex@: for the paper abstracts
215
* @Authors@: for the authors. The MAG data is pre-processed by grouping authors by PaperId 
216
* @Affiliations@ and @PaperAuthorAffiliations@: to generate links between publications and organisations
217
* @Journals@ and @ConferenceInstances@: joined with @Papers_distinct@ to have the information about the venues where the paper was published
218
* TO BE REMOVED @PaperUrls@: to create one instance for the OpenAIRE publication
219
* @FieldsOfStudy@: to add subjects
220 1 Alessia Bardi
221
The records are enriched with:
222
* abstracts
223
* MAG identifiers of authors
224
* affiliation relationships
225 4 Alessia Bardi
* subjects (MAG FieldsOfStudy)
226
* conference or journal information (in the @journal@ field) TODO: or @container@, in case of the dump?
227 24 Alessia Bardi
* [TO BE REMOVED] instances with URL from MAG
228
229
230
TODO: ensure we use the field names of the public dump
231
232
|_.OpenAIRE path| ._MAG table |_.MAG path(s)|_.Notes|
233
| pid | Papers_distinct | Doi | |
234
| originalId | Papers_distinct | PaperId | |
235
| title | Papers_distinct | PaperTitle | as main title |
236
| title | Papers_distinct | OriginalTitle | as alternative title |
237
| source | Papers_distinct | BookTitle |  |
238
| dateofacceptance | Papers_distinct  | Date |  first 10 chars, if not blank |
239
| publisher | Papers_distinct, Journal  | Publisher |   |
240
| description | PaperAbstractsInvertedIndex | IndexedAbstract | |
241
| journal | ConferenceInstances, Journals |  ||
242
| journal.name | | DisplayName ||
243
| journal.conferencePlace | | Location ||
244
| journal.conferenceDate | | StartDate and EndDate | Values created as concatanation of the first 10 chars of each (separated by '-'), if both are not blank|
245
| journal.sp | | FirstPage ||
246
| journal.ep | | EndPage ||
247
| journal.issnPrinted | | Issn ||
248
| journal.vol | Papers_distinct | Volume ||
249
| journal.iss | Papers_distinct | Issue ||
250
| subject |FieldsOfStudy  | subjects | All subjects from MAG are set with a dedicated marker in the classname/classid 'Microsoft Academic Graph Classification'/MAG. 
251
We create one subject per DisplayName, per MainType and, if the MainType is in the format @x.y@, one subject also for the first token (i.e. @x@) |
252
| subject.value | | subjects.DisplayName, subjects.MainType, split(subjects.MainType, '.'0.head | All subject from MAG are set with a dedicated marker in the classname/classid 'Microsoft Academic Graph Classification'/MAG|
253
| author | Authors, PaperAuthorAffiliations | |  |
254
| author.rank |  | sequenceNumber |  |
255
| author.fullName |  | DisplayName | if not blank |
256
| author.affiliation |  | affiliation | if not null |
257
| author.pid |  | AuthorId |  MAG id of the author as URL. TO BE REMOVED? |
258
| instance | PaperUrls | | TO BE REMOVED. Currently maps to the MAG URl and to any URLs in SourceUrl |
259
260 4 Alessia Bardi
h3. 6 Enrich DOIBoost3 with hosting data sources (@hostedby@) and access right information
261
262 27 Claudio Atzori
In this phase, we intersect DOIBoost3 with a dataset composed of journals from OpenAIRE, Crossref, and the ISSN gold list. Each journal comes with its International Standard Serial Numbers (issn, eissn, lissn) and, when available, a flag that tells if the journal is open access. The intersection is done on the basis of the International Standard Serial Numbers. The records with a @journal.[l|e]issn@ that match are enriched as follows:
263 25 Alessia Bardi
* Each instance gain the @hostedby@ information corresponding to the journal
264 1 Alessia Bardi
* If the journal is open access, the access rights of the instances are also set to "Open Access" with "gold" route (because by construction, the journals we know are open are from DOAJ or Gold ISSN list)
265
266
The hostedby of records that do not match are set to the "Unknown Repository".