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 = | ||
| − | == | + | == dblp == |
=== sql query === | === sql query === | ||
<source lang='sql'> | <source lang='sql'> | ||
SELECT | SELECT | ||
| − | + | series, | |
min(ordinal) as minOrdinal, | min(ordinal) as minOrdinal, | ||
max(ordinal) as maxOrdinal, | max(ordinal) as maxOrdinal, | ||
| Line 46: | Line 46: | ||
max(Ordinal)-min(Ordinal) as available, | max(Ordinal)-min(Ordinal) as available, | ||
(max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness | (max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness | ||
| − | FROM | + | FROM event_dblp |
Where ordinal is not null | Where ordinal is not null | ||
| − | group by | + | group by series |
order by 6 desc | order by 6 desc | ||
</source> | </source> | ||
=== histogramm === | === histogramm === | ||
| − | [[File: | + | [[File:dblp_series_completeness.png|600px] |
| + | == openresearch == | ||
| + | === sql query === | ||
| + | <source lang='sql'> | ||
| + | SELECT | ||
| + | inEventSeries, | ||
| + | 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_orclone | ||
| + | Where ordinal is not null | ||
| + | group by inEventSeries | ||
| + | order by 6 desc | ||
| + | |||
| + | </source> | ||
| + | === histogramm === | ||
| + | [[File:orclone_series_completeness.png|600px]] | ||
| + | |||
== wikicfp == | == wikicfp == | ||
Revision as of 13:51, 18 May 2022
Ordinal histogramms
ceurws
orbackup
orclonebackup
confref
gnd
wikicfp
or
orclone
tibkat
dblp
crossref
wikidata
Eventseries completeness
dblp
sql query
SELECT
series,
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_dblp
Where ordinal is not null
group by series
order by 6 desc
histogramm
[[File:dblp_series_completeness.png|600px]
openresearch
sql query
SELECT
inEventSeries,
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_orclone
Where ordinal is not null
group by inEventSeries
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
