ConferenceCorpus/statistics

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

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

tibkat

sql query

For tibkat a direct SQL query was not possible since the series info is not available. We therefore filtered by series acronym using python code to get an indication. 3136 series where identified this way and then the histogramm was created from the data

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