Difference between revisions of "ConferenceCorpus/statistics"
Jump to navigation
Jump to search
| Line 36: | Line 36: | ||
[[File:ordinalhistogramm_event_wikidata.png|600px]] | [[File:ordinalhistogramm_event_wikidata.png|600px]] | ||
= Eventseries completeness = | = Eventseries completeness = | ||
| + | == confref == | ||
| + | === sql query === | ||
| + | <source lang='sql'> | ||
| + | SELECT | ||
| + | seriesId, | ||
| + | min(ordinal) as minOrdinal, | ||
| + | max(ordinal) as maxOrdinal, | ||
| + | avg(ordinal) as avgOrdinal, | ||
| + | max(Ordinal)-min(Ordinal) as available, | ||
| + | (max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness | ||
| + | FROM event_confref | ||
| + | Where ordinal is not null | ||
| + | group by seriesId | ||
| + | order by 6 desc | ||
| + | |||
| + | </source> | ||
| + | === histogramm === | ||
| + | [[File:confref_series_completeness.png|600px]] | ||
| + | |||
| + | == wikicfp == | ||
| + | === sql query === | ||
| + | <source lang='sql'> | ||
| + | SELECT | ||
| + | seriesId, | ||
| + | min(ordinal) as minOrdinal, | ||
| + | max(ordinal) as maxOrdinal, | ||
| + | avg(ordinal) as avgOrdinal, | ||
| + | max(Ordinal)-min(Ordinal) as available, | ||
| + | (max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness | ||
| + | FROM event_wikicfp | ||
| + | Where ordinal is not null | ||
| + | group by seriesId | ||
| + | order by 6 desc | ||
| + | |||
| + | </source> | ||
| + | === histogramm === | ||
| + | [[File:wikicfp_series_completeness.png|600px]] | ||
== wikidata == | == wikidata == | ||
=== sql query === | === sql query === | ||
<source lang='sql'> | <source lang='sql'> | ||
SELECT | SELECT | ||
| − | + | eventInSeriesId, | |
| − | + | min(ordinal) as minOrdinal, | |
| − | + | max(ordinal) as maxOrdinal, | |
| − | + | avg(ordinal) as avgOrdinal, | |
| − | + | max(Ordinal)-min(Ordinal) as available, | |
| − | + | (max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness | |
| − | + | FROM event_wikidata | |
| − | + | Where ordinal is not null | |
| − | + | group by eventInSeriesId | |
| − | + | order by 6 desc | |
</source> | </source> | ||
=== histogramm === | === histogramm === | ||
| − | + | [[File:wikidata_series_completeness.png|600px]] | |
Revision as of 12:49, 18 May 2022
Ordinal histogramms
ceurws
orbackup
orclonebackup
confref
gnd
wikicfp
or
orclone
tibkat
dblp
crossref
wikidata
Eventseries completeness
confref
sql query
SELECT
seriesId,
min(ordinal) as minOrdinal,
max(ordinal) as maxOrdinal,
avg(ordinal) as avgOrdinal,
max(Ordinal)-min(Ordinal) as available,
(max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness
FROM event_confref
Where ordinal is not null
group by seriesId
order by 6 desc
histogramm
wikicfp
sql query
SELECT
seriesId,
min(ordinal) as minOrdinal,
max(ordinal) as maxOrdinal,
avg(ordinal) as avgOrdinal,
max(Ordinal)-min(Ordinal) as available,
(max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness
FROM event_wikicfp
Where ordinal is not null
group by seriesId
order by 6 desc
histogramm
wikidata
sql query
SELECT
eventInSeriesId,
min(ordinal) as minOrdinal,
max(ordinal) as maxOrdinal,
avg(ordinal) as avgOrdinal,
max(Ordinal)-min(Ordinal) as available,
(max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness
FROM event_wikidata
Where ordinal is not null
group by eventInSeriesId
order by 6 desc
histogramm
