You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Difference between revisions of "User:AKhatun/Wikidata Scholarly Articles Subgraph Analysis"

From Wikitech-static
Jump to navigation Jump to search
imported>AKhatun
(Put in summary of query counts)
imported>AKhatun
(User agent and query time (ongoing))
Line 350: Line 350:
'''A''': Some items occur amost always in relation to scholarly articles. Typical examples include: author property, certain author items, publication date, cites, DOI, and lots of other external IDs. One way to get an approximation of such items is to find out the percentage of use of an item in scholarly article versus in the entire Wikidata. Distribution of this percentage and more analysis given below.
'''A''': Some items occur amost always in relation to scholarly articles. Typical examples include: author property, certain author items, publication date, cites, DOI, and lots of other external IDs. One way to get an approximation of such items is to find out the percentage of use of an item in scholarly article versus in the entire Wikidata. Distribution of this percentage and more analysis given below.


The following analysis uses Wikidata dump of <code>20210816</code> and WDQS public SPARQL queries of <code>07/2021</code> and <code>08/2021</code>. All query related values below are <code>monthly</code> counts.
The following analysis uses Wikidata dump of <code>20210816</code> and WDQS public SPARQL queries of <code>07/2021</code> and <code>08/2021</code>. '''All query related values below are <code>monthly</code> counts'''.


== Summary Counts ==
== Summary Counts ==
Line 377: Line 377:


=== Queries with scholarly article QID ===
=== Queries with scholarly article QID ===
Although there are other kinds of articles (see [[#Definition of Scholarly Articles|Definition of Scholarly Articles]] for details), since scholarly articles outnumber others significantly, the first step was to find queries that specify the QID of scholarly articles ([[wikidata:Q13442814 | Q13442814]]) directly. This includes queries that may ask for list of scholarly with other condiitons. For instance: List of scholarly articles published in a specific date or by a specific author.
* The number of queries that contained the QID of schoalrly articles cam out to be '''~70K''', which is '''0.04%''' of monthly queries.


=== Queries with scholarly article instance ===
=== Queries with scholarly article instance ===
Another almost direct way to identify queries related to scholarly articles is to get the queries that mentions any scholarly article. For this, the queries are checked for presence of items that are <code>instance of</code> scholarly articles. For example: List the authors for an article.
* The number of such queries was '''~730K''', which is '''0.4%''' of monthly queries.


=== Queries with properties mostly relevant to scholarly articles ===
=== Queries with properties mostly relevant to scholarly articles ===
Some properties are used almost always for scholarly articles, such as author (P50), author name string (P2093), cites work (P2860), IDs like P7710, P5875, P818, etc. If these properties were to be used in a query, we can assume the query has to pass through the scholarly articles subgraph. <br>
There are around 2000 distinct properties used in the scholarly articles subgraph (refer to [[#Predicates of Scholarly Articles|Predicates of Scholarly Articles]] for details on properties). To get a list of properties most concerned with scholarly articles, the following steps wre taken:
# The usage count of these properties was counted in the entirety of Wikidata (<code>total_count</code>)
# The usage count of properties was counted within scholarly articles subgraph (<code>sa_count</code>)
# Then percentage of usage within scholarly article subgraph was calculated (<code>sa_count/total_count</code>)
# All properties with '''>=99%''' usage solely in scholarly articles subgraph were considered properties ''most concerned'' with scholarly articles.
A histogram of the distribution of usage percentage for all predicates used in the scholarly article subgraph is given below. Note that the predicates were grouped with their P values. That is, wd:P50, wdt:P50 would be considered simply P50.
[[File:sa_predicate_dist.png]]
* The number of predicates used '''>=99%''' in scholarly article subgraph is '''40'''. If each predicate was considered separately, i.e wd, wdt, wdtn etc were considered separately, then 128 predicates are counted to be used >=99% in scholarly articles.
* The number of queries that use these 40 predicates is '''2.7M''', which is '''1.4%''' of monthly queries.


=== Queries with sub/obj URIs mostly relevant to scholarly articles ===
=== Queries with sub/obj URIs mostly relevant to scholarly articles ===
Just like properties, some items can occur more in scholarly articles subgraph than other places in wikidata. Following a similar procedure, subject and object URIs usage percentage was calculated and those >=99% were considered more related to scholarly articles. The queries were then searched for presence of these ''more relevant'' items.
A histogram of the distribution of usage percentage for all subjects and object URIs used in the scholarly article subgraph is given below.
[[File:sa_URI_dist.png|1100px]]
* The number of queries that use items more relevant to scholarly articles is '''750K''', which is '''0.4%''' of monthly queries.
* Note that number of queries containing instances of scholarly articles was 730K. Therefore, most of the former number actually includes queries that directly mention the scholarly articles.
* The figure shows that quite a large number of items are used mostly in scholarly articles (>=99% usage), which were then used to sift through queries.


=== Queries with literals mostly relevant to scholarly articles ===
=== Queries with literals mostly relevant to scholarly articles ===
Literals were analyzed separately. They always occur as objects, with or without additinal language or datatype tags ("label"@en, "2021"^^xsd:integer). A user can construct queries containing literals in the following ways:
# match the whole literal string, e.g "labelstring". Addionally use LAND/DTYPE for further filtering. But the literal appears as plain string.
# match literal with language or dtype tags, e.g "labelstring@en"
# match part of the literal, e.g using <code>regex(?g, "matchThisSubstring")</code> or more complex expressions.
For the purposes of analysis, only 1 and 2 were considered for finding the queries since matching substrings is rather complicated and not as much reliable. But we suspect that if a query were to contain literals related to scholarly articles, it should also contain some predicates or other URIs that are mostly related to scholarly articles. Similar to before, literals that were used >=99% of the times in scholarly subgraphs were used to find queries related to scholarly articles.
A histogram of the distribution of usage percentage for all literals used in the scholarly article subgraph is given below.
[[File:sa_literal_dist.png|1100px]]
* The number of such queries was '''~1.5M''', which is '''0.8%''' of monthly queries. Note that this number was obtained from July. In August, it was ~0.9M.
=== Queries with labels and descriptions mostly relevant to scholarly articles ===
While literals already cover labels and descriptions, here a separate analysis is done on them. The process of finding scholarly article related queries remains the same, except this time we only look for labels and descriptions of scholarly articles in the queries.
* The number of such queries was '''M''', which is '''%''' of monthly queries.


== Analysis of queries related to scholarly articles ==
== Analysis of queries related to scholarly articles ==


=== Query Types ===
This section analyses the queries that were extracted following the above methods as being related to scholarly articles. A total of ~4M queries (out of 190M) were identified as such.


=== User agent ===
=== User agent ===
* Number of distinct user agents: 3,946
{| class="wikitable sortable"
|+ Top user agents for count of scholarly article related queries
|-
!User Agent !! Count !! Percentage of scholarly article queries
|-
| wikidataintegrator/0.8.4 || 2254245 || 55
|-
| National library of Israel bot/1.0.0.0 || 245527 || 6
|-
| @wikimedia/kartotherian-geoshapes/1.1.4 || 199195 || 4.9
|-
| UA##1 || 154316 || 3.7
|-
| Scholia || 116985 || 2.9
|-
| Toolforge - mix-n-match || 110254 || 2.7
|-
| Toolforge - legacy code || 109618 || 2.7
|-
| UA##2 || 105040 || 2.5
|-
| UA##3 || 62926 || 1.5
|-
| PyPoli University Matching || 42906 || 1
|-
| UA##4 || 36805 || 0.9
|-
| SearchBot/2.0 || 32454 || 0.8
|-
| Toolforge - wikidata-terminator || 32116 || 0.8
|-
| doubanIMDb/0.01 || 27298 || 0.7
|-
| @wikimedia/kartotherian-geoshapes/1.1.3 || 24827 || 0.6
|-
| Hub || 15626 || 0.4
|-
| Toolforge - orcidator_old || 9198 || 0.2
|-
| NERBot/0.0 || 8076 || 0.2
|-
| efre-lod-enrich-wikidata-bot/0.1 || 7151 || 0.2
|-
| UK gecode/0.1 || 6740 || 0.17
|-
| wikidataintegrator/0.8.1 || 4805 || 0.12
|-
| Recoin/1.0 || 4004 || 0.1
|}
N.B: Some unknown user agents with <1% query were not mentioned in the table as they are not further analyzed due to low count.
=== Query Times ===
{| class="wikitable sortable"
|+ Query execution time for scholarly article queries
|-
!query time class !! count
|-
| less_10ms    || 43,783 
|-
| 10ms_to_100ms || 3,320,388
|-
| 100ms_to_1s  || 645,706
|-
| 1s_to_10s    || 59,501 
|-
| more_10s      || 5,687   
|}
{| class="wikitable sortable"
|+ Query execution time for some top user agents
|-
! User Agent -> !! wikidataintegrator/0.8.4 !! National library of Israel bot/1.0.0.0 !! Scholia
|-
! query time class !! count
|-
| less_10ms    || 2179    || 0 || 15021
|-
| 10ms_to_100ms || 2122492 || 150817 || 96756
|-
| 100ms_to_1s  || 125459  || 93828 || 4641
|-
| 1s_to_10s    || 4043    || 867 || 560
|-
| more_10s      || 72      || 15 || 7
|}
=== Triples Analysis ===

Revision as of 18:38, 8 September 2021

Scholarly articles form a large portion of Wikidata, this has been established for some time. This page highlights the baseline analysis done on Scholarly articles in Wikidata. The aim is to identify not only what portion of Wikidata is scholarly articles, but also how connected is it to other parts of Wikidata, how many users query this subgraph and what percentage of queries they are. The analysis is therefore divided into two parts:

  • Analysis on Wikidata:
    • What are scholarly articles
    • Number and percentage of Wikidata entities that are scholarly articles
    • How many entities connect to scholarly articles
    • How many entities do scholarly articles connect to
    • Rate of growth of scholarly articles
    • Number of authors that would be isolated from Wikidata if scholarly articles were removed (meaning, these author entities were created probably only for the purposes of the articles they wrote.)
  • Analysis of the WDQS SPARQL Queries:
    • What defines a query to be associated with scholarly articles
    • The number and percentage of queries associated with scholarly articles
    • The number and percentage of queries that require entities other than scholarly articles vs those that require only scholarly articles

Ticket: T281854

Scholarly Articles

The Wikidata dump of 20210719 was used for the following analysis.

Definition of Scholarly Articles

Research papers or books can be considered scholarly articles. This includes journals articles, conference papers, books etc. Wikidata has several types of entities to cover these. More technically speaking, the entities involved are:

Most of these have overlaps with scholarly articles, and with themselves. Scholarly articles have the largest count (37M) while everything else combined is in the thousands (~130K, excluding those that are included in scholarly articles), therefore the analysis is more focused on scholarly articles than others. The 130K could be even less if the other article types have overlap among themselves. This is not an exhaustive list, but cover most of what we can call scholarly articles or papers or journal articles. A detailed tree diagram of how these entities are related can be found in Scholarly Articles' Tree in Wikidata.

File:Scholarly articles example.png

Scholarly Article Stats

Number of Scholarly Articles

  • Total entity count: 94M [1]
  • Number of entities that are instance of scholarly article: 37308158 (37.3M). 40% of all Wikidata entities are therefore scholarly articles.

Number of triples related to Scholarly Articles

  • Total triple count: 12819818340 (12.8B)
  • Number of triples included within the scholarly articles: 6399256630 (6.4B). 50% of all triples are directly related to scholarly articles.

Technically, the triple related to scholarly articles come under the 'context' of items that are scholarly articles. Example context of an item is Q39790431 dump. The context count includes:

  • + all triples in which the item is a subject
  • + the statement triples that rise from these triples
  • + triples that define the item itself
  • - the refs and vals, as those are re-usable in other items.

Triples per article

i.e triples related to the articles.

  • Average triple per article: 171
  • Minimum triple per article: 10
  • Maximum triple per article: 41847

See examples of articles with high number of triples in Wikidata_Basic_Analysis#Items

Direct triples per article

i.e triples where scholarly article is the subject.

  • Average direct triple per article: 84
  • Minimum direct triple per article: 7
  • Maximum direct triple per article: 16758

See examples of articles with high number of direct triples in Wikidata_Basic_Analysis#Top_Subjects

This raises the question: Are only a few articles responsible for this huge number of triples, or are the triples distributed evenly among the articles? So we look into the distribution of triples.

Distribution of triples per article

Distribution of the count of triples per article
Number of triples Count of articles
10 to 100 10583118
100 to 1k 26626656
1k to 10k 96563
more than 40k 1821

File:Related triples per scholarly article.png

Number of days to recovery

If 6.4B triples were to be removed from wikidata, given the current rate of growth, how long would it take for wikidata to get back to its original size again?
The growth rate of triples is not constant, but considering the growth an approximate straight line, in grafana dashboard, Wikidata grows at a rate of 4.77M triples per day. This rate was calculated from the number of triples at the start and end of a 90-day interval (11/3/21 to 6/6/21). It could be faster or a bit slower than this.

  • Wikidata will take 1300 days = 44 months = appx. 3.6 years to get back to it's original size. This is a wide approximation, since the growth rate of wikidata is not constant.

Entities connected to scholarly articles

  • Links to scholarly articles: Number of triples that have scholarly articles as object is 529702818 (530M)
  • Outside links to scholarly articles: Number of triples that have scholarly articles as object, but subject is not another scholarly article is 266708031 (266M)

Entities scholarly articles connect to

Queries to directly find what links from scholarly articles to other non-scholarly articles is running into time outs. Another way to estimate this is looking into predicates that tend to point towards other non-scholarly article items in Wikidata.

The predicates considered were:

  • main subject
  • language of work or name
  • stated as
  • on focus list of Wikimedia project
  • describes a project that uses
  • determination method
  • sponsor
  • genre
  • object has role

These together are 85851140 (85M) triples, therefore 85M triples link directly from scholarly articles to things possibly non-scholarly article.
Note that this does not include triples contained in the statements of these triples, if any; but should not add too many triples to it either.

Rate of growth of scholarly articles

The growth of:

  • the number of scholarly articles
  • the number of triples related to scholarly articles

is shown in the figure below. It seems they don't grow too fast, but the data is only over a span of 4 weeks.

File:Scholarly articles growth.png


More trend data can be found in wikicite.org/statistics, but they report for all publications, a much larger category than scholarly articles.

Scholarly Article Counts Summary

File:Scholarly articles count tree.png

Predicates of Scholarly Articles

  • Total distinct predicates: Total distinct predicates of scholarly articles is 2107
  • Non-wikidata predicates: 17 of these predicates are non-wikidata predicates, i.e unlike P31/P279etc, they do not start with the prefix wikidata.org. These predicates form 60% of the scholarly article triples.
  • Non-wiki predicates: 14 of these predicates don't start with wikidata.org or wikiba.se. These are 46% of the scholarly article triples.
  • Descriptions: Descriptions of scholarly articles form 20.5% of the scholarly article triples. This is 10% of all wikidata triples. Recall that all descriptions (of all items) together forms 19.5% of the entire wikidata.
  • External IDs: There are 1000 external IDs associated with scholarly articles, which form ~50% of the distinct predicates of scholarly articles. External IDs form 4% of scholarly article triples, 2% of all triples.

Top Predicates

Top predicates of scholarly articles
Predicate Predicate label # of Triples % of Scholarly Article Triples % of all Triples
http://schema.org/description 1321691671 20.654 10.252
http://wikiba.se/ontology#rank 773820830 12.092 6.002
http://www.w3.org/1999/02/22-rdf-syntax-ns#type 773788620 12.092 6.002
http://www.w3.org/ns/prov#wasDerivedFrom 691773237 10.810 5.366
http://www.wikidata.org/prop/P2860 cites work 263097842 4.111 2.041
http://www.wikidata.org/prop/statement/P2860 cites work 263097837 4.111 2.041
http://www.wikidata.org/prop/direct/P2860 cites work 263004896 4.110 2.040
http://www.wikidata.org/prop/qualifier/P1545 series ordinal 154088914 2.408 1.195
http://www.wikidata.org/prop/P2093 author name string 134315644 2.099 1.042
http://www.wikidata.org/prop/statement/P2093 author name string 134315587 2.099 1.042
http://www.wikidata.org/prop/direct/P2093 author name string 134227496 2.098 1.041
http://www.w3.org/2000/01/rdf-schema#label 74437634 1.163 0.577
http://www.wikidata.org/prop/statement/P31 instance of 40319296 0.630 0.313
http://www.wikidata.org/prop/P31 instance of 40319296 0.630 0.313
http://www.wikidata.org/prop/direct/P31 instance of 40319268 0.630 0.313
http://www.wikidata.org/prop/P1476 title 37524904 0.586 0.291
http://www.wikidata.org/prop/statement/P1476 title 37524903 0.586 0.291
http://www.wikidata.org/prop/direct/P1476 title 37523899 0.586 0.291
http://www.wikidata.org/prop/P577 publication date 37309627 0.583 0.289
http://www.wikidata.org/prop/statement/P577 publication date 37309626 0.583 0.289
http://www.wikidata.org/prop/statement/value/P577 publication date 37309625 0.583 0.289

Top Properties

Considering only wikidata predicates, i.e mainly properties of items, and grouping based on property label of the property, we get the following count of top predicates. Includes p, s, ps, psv, wdt, wdtn, pq, pqv, pqn where applicable. They do not contain triple count of triples that expand from the statements.

Top properties of scholarly articles
Property name # of Triples % of Scholarly Article Triples % of all Triples
cites work 789200575 12.332 6.122
author name string 402859029 6.296 3.125
series ordinal 154089316 2.408 1.195
publication date 149227733 2.332 1.156
DOI 134464365 2.100 1.045
instance of 120957868 1.890 0.939
title 112574265 1.758 0.873
published in 109147370 1.707 0.846
page(s) 104199512 1.629 0.807
volume 103612864 1.620 0.804
PubMed ID 95893499 1.499 0.744
issue 95083032 1.485 0.738
author 59439111 0.929 0.461
main subject 41515900 0.648 0.321
language of work or name 34801291 0.543 0.270
PMCID 19059585 0.297 0.147
ResearchGate publication ID 13734703 0.216 0.108
stated as 8609378 0.135 0.067
exact match 8162235 0.129 0.063
Dimensions Publication ID 4617733 0.072 0.036

Top External IDs

Grouping based on property label of the external IDs, we get the following count of top external IDs. Includes p, s, ps, psv, wdt, wdtn, pq, pqv, pqn where applicable. They do not contain triple count of triples that expand from the statements.

Top external IDs of scholarly articles
External ID # of Triples % of Scholary Article Triples % of all Triples
DOI 134464365 2.100 1.045
PubMed ID 95893499 1.499 0.744
PMCID 19059585 0.297 0.147
ResearchGate publication ID 13734703 0.216 0.108
Dimensions Publication ID 4617733 0.072 0.036
CJFD journal article ID 2915210 0.045 0.024
DBLP publication ID 2080695 0.035 0.015
ADS bibcode 1186590 0.018 0.009
OpenCitations bibliographic resource ID 1161475 0.020 0.010
arXiv ID 1040311 0.015 0.009

Distribution of predicates

The distribution of distinct predicates per article is given below:

  • Average distinct predicate per article: 29
  • Maximum distinct predicate per article: 102
  • Minimum distinct predicate per article: 7
Distribution of distinct predicate per scholarly article
Number of distinct predicate Number of articles
less than 10 277
10 to 20 152995
20 to 30 18146794
30 to 40 18294391
40 to 50 711176
50 to 60 2493
60 to 70 26
70 to 80 4
80 to 90 1
90 to 100 0
more than 100 1

File:Distinct predicates per scholarly article.png

Scholarly Articles' Author

The following analysis is done with the predicate P50, which links to an author item in Wikidata. Other author data include 'author name string', but it is not considered here as these are literals and do not link to other Wikidata items.

  • Total number of distinct authors (through P50) in wikidata: 1.9M
    1. Number of distinct authors who wrote scholarly articles: 1.8M
      • Number of distinct authors who wrote ONLY scholarly articles: 1.44M
    2. Number of distinct authors who wrote other kinds of articles: 0.5M
      • Number of distinct authors who wrote did not write any scholarly article: 0.13M
    3. Number of authors who wrote both scholarly and non-scholarly articles: 0.36

File:SA NonSA authors.png

  • Number of direct links to authors in scholarly articles: 19756767 (19.7M)
  • There are ~28M triples where items (not scholarly articles) link to authors.
  • Average author per article: ~2
  • Maximum author per article: 1070
  • Minimum author per article: 1

File:Auth dist.png

Queries related to scholarly articles

This section aims to find statistics about the queries that touch on the scholarly articles subgraph. Given the inter-connected nature of Wikidata, it is very hard to find queries that somehow relate to scholarly articles, but some approximations are possible. To this end the various types of possble queries possible are:

  1. The query directly mentions some scholarly article(s) (e.g list the authors of an article)
  2. The query asks for scholarly article in results (e.g list articles published in a specific date)
  3. The query asks for information that has to pass through the scholarly articles (e.g list authors of articles published in a specific date)

To approximate the number of queries that relate to scholarly articles certain assumptions were made. These should practically cover all such queries.

  1. Query containing the QID of scholarly article: Q13442814
  2. The query will contain the QID of the articles themselves
  3. The query will contain objects, subjects, or predicates that are used most often in the scholarly article subgraph in Wikidata (e.g author, publication date etc). This set of queries should approximately cover 2nd and 3rd category of queries.
    • Query containing predicates that are used mostly in scholarly articles subgraph
    • Query containing subject/object URIs that are used mostly in scholarly articles subgraph
    • Query containing literals that are used mostly in scholarly articles subgraph

Q: What do you mean by subject/predicate/object mostly in scholarly articles subgraph?
A: Some items occur amost always in relation to scholarly articles. Typical examples include: author property, certain author items, publication date, cites, DOI, and lots of other external IDs. One way to get an approximation of such items is to find out the percentage of use of an item in scholarly article versus in the entire Wikidata. Distribution of this percentage and more analysis given below.

The following analysis uses Wikidata dump of 20210816 and WDQS public SPARQL queries of 07/2021 and 08/2021. All query related values below are monthly counts.

Summary Counts

Count of SPARQL queries related to scholarly articles (monthly)
Category Count % of all queries
Query contains scholarly article QID Q13442814 70K 0.04
Query contains scholarly article instance QID 730K 0.4
Query contains properties mostly relevant to scholarly articles 2.7M 1.4
Query contains subject or object URIs mostly relevant to scholarly articles 750K 0.4
Query contains literals mostly relevant to scholarly articles 1.5M 0.8
Total scholarly article related queries 4M 2
Total queries 190M -

Query Stats

Queries with scholarly article QID

Although there are other kinds of articles (see Definition of Scholarly Articles for details), since scholarly articles outnumber others significantly, the first step was to find queries that specify the QID of scholarly articles ( Q13442814) directly. This includes queries that may ask for list of scholarly with other condiitons. For instance: List of scholarly articles published in a specific date or by a specific author.

  • The number of queries that contained the QID of schoalrly articles cam out to be ~70K, which is 0.04% of monthly queries.

Queries with scholarly article instance

Another almost direct way to identify queries related to scholarly articles is to get the queries that mentions any scholarly article. For this, the queries are checked for presence of items that are instance of scholarly articles. For example: List the authors for an article.

  • The number of such queries was ~730K, which is 0.4% of monthly queries.

Queries with properties mostly relevant to scholarly articles

Some properties are used almost always for scholarly articles, such as author (P50), author name string (P2093), cites work (P2860), IDs like P7710, P5875, P818, etc. If these properties were to be used in a query, we can assume the query has to pass through the scholarly articles subgraph.
There are around 2000 distinct properties used in the scholarly articles subgraph (refer to Predicates of Scholarly Articles for details on properties). To get a list of properties most concerned with scholarly articles, the following steps wre taken:

  1. The usage count of these properties was counted in the entirety of Wikidata (total_count)
  2. The usage count of properties was counted within scholarly articles subgraph (sa_count)
  3. Then percentage of usage within scholarly article subgraph was calculated (sa_count/total_count)
  4. All properties with >=99% usage solely in scholarly articles subgraph were considered properties most concerned with scholarly articles.

A histogram of the distribution of usage percentage for all predicates used in the scholarly article subgraph is given below. Note that the predicates were grouped with their P values. That is, wd:P50, wdt:P50 would be considered simply P50.

File:Sa predicate dist.png

  • The number of predicates used >=99% in scholarly article subgraph is 40. If each predicate was considered separately, i.e wd, wdt, wdtn etc were considered separately, then 128 predicates are counted to be used >=99% in scholarly articles.
  • The number of queries that use these 40 predicates is 2.7M, which is 1.4% of monthly queries.

Queries with sub/obj URIs mostly relevant to scholarly articles

Just like properties, some items can occur more in scholarly articles subgraph than other places in wikidata. Following a similar procedure, subject and object URIs usage percentage was calculated and those >=99% were considered more related to scholarly articles. The queries were then searched for presence of these more relevant items.

A histogram of the distribution of usage percentage for all subjects and object URIs used in the scholarly article subgraph is given below.

File:Sa URI dist.png

  • The number of queries that use items more relevant to scholarly articles is 750K, which is 0.4% of monthly queries.
  • Note that number of queries containing instances of scholarly articles was 730K. Therefore, most of the former number actually includes queries that directly mention the scholarly articles.
  • The figure shows that quite a large number of items are used mostly in scholarly articles (>=99% usage), which were then used to sift through queries.

Queries with literals mostly relevant to scholarly articles

Literals were analyzed separately. They always occur as objects, with or without additinal language or datatype tags ("label"@en, "2021"^^xsd:integer). A user can construct queries containing literals in the following ways:

  1. match the whole literal string, e.g "labelstring". Addionally use LAND/DTYPE for further filtering. But the literal appears as plain string.
  2. match literal with language or dtype tags, e.g "labelstring@en"
  3. match part of the literal, e.g using regex(?g, "matchThisSubstring") or more complex expressions.

For the purposes of analysis, only 1 and 2 were considered for finding the queries since matching substrings is rather complicated and not as much reliable. But we suspect that if a query were to contain literals related to scholarly articles, it should also contain some predicates or other URIs that are mostly related to scholarly articles. Similar to before, literals that were used >=99% of the times in scholarly subgraphs were used to find queries related to scholarly articles.

A histogram of the distribution of usage percentage for all literals used in the scholarly article subgraph is given below.

File:Sa literal dist.png

  • The number of such queries was ~1.5M, which is 0.8% of monthly queries. Note that this number was obtained from July. In August, it was ~0.9M.

Queries with labels and descriptions mostly relevant to scholarly articles

While literals already cover labels and descriptions, here a separate analysis is done on them. The process of finding scholarly article related queries remains the same, except this time we only look for labels and descriptions of scholarly articles in the queries.

  • The number of such queries was M, which is % of monthly queries.

Analysis of queries related to scholarly articles

This section analyses the queries that were extracted following the above methods as being related to scholarly articles. A total of ~4M queries (out of 190M) were identified as such.

User agent

  • Number of distinct user agents: 3,946
Top user agents for count of scholarly article related queries
User Agent Count Percentage of scholarly article queries
wikidataintegrator/0.8.4 2254245 55
National library of Israel bot/1.0.0.0 245527 6
@wikimedia/kartotherian-geoshapes/1.1.4 199195 4.9
UA##1 154316 3.7
Scholia 116985 2.9
Toolforge - mix-n-match 110254 2.7
Toolforge - legacy code 109618 2.7
UA##2 105040 2.5
UA##3 62926 1.5
PyPoli University Matching 42906 1
UA##4 36805 0.9
SearchBot/2.0 32454 0.8
Toolforge - wikidata-terminator 32116 0.8
doubanIMDb/0.01 27298 0.7
@wikimedia/kartotherian-geoshapes/1.1.3 24827 0.6
Hub 15626 0.4
Toolforge - orcidator_old 9198 0.2
NERBot/0.0 8076 0.2
efre-lod-enrich-wikidata-bot/0.1 7151 0.2
UK gecode/0.1 6740 0.17
wikidataintegrator/0.8.1 4805 0.12
Recoin/1.0 4004 0.1

N.B: Some unknown user agents with <1% query were not mentioned in the table as they are not further analyzed due to low count.

Query Times

Query execution time for scholarly article queries
query time class count
less_10ms 43,783
10ms_to_100ms 3,320,388
100ms_to_1s 645,706
1s_to_10s 59,501
more_10s 5,687
Query execution time for some top user agents
User Agent -> wikidataintegrator/0.8.4 National library of Israel bot/1.0.0.0 Scholia
query time class count
less_10ms 2179 0 15021
10ms_to_100ms 2122492 150817 96756
100ms_to_1s 125459 93828 4641
1s_to_10s 4043 867 560
more_10s 72 15 7

Triples Analysis