ConferenceCorpus/statistics

Introduction

SQL Query for Event Series completion

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

Event Signature Availability

see also http://conferencecorpus.bitplan.com/query/SignatureAvailability

signature completeness combined

signature completeness of acronym

signature completeness of startDate

signature completeness of ordinal

signature completeness of year

signature completeness of title

signature completeness of city

signature completeness of country

[[File:completeSignature_country.png|600px]

Ordinal histogramms

The Zipf digramms show the log frequency (leaving out the first event, since typically the decline begins from the second event)

confref

To few available ordinals for analysis.

CEUR-WS

sql query

SELECT ordinal
    FROM event_ceurws
    where ordinal is not null
    and ordinal < 50

ceurws ordinals

confref

not enough data

Crossref

sql query

SELECT ordinal
    FROM event_crossref
    where ordinal is not null
    and ordinal < 50

crossref ordinals

dblp

sql query

SELECT ordinal
    FROM event_dblp
    where ordinal is not null
    and ordinal < 50

dblp ordinals

GND

sql query

SELECT ordinal
    FROM event_gnd
    where ordinal is not null
    and ordinal < 50

gnd ordinals

OpenResearch

sql query

SELECT ordinal
    FROM event_or
    where ordinal is not null
    and ordinal < 50

or ordinals

OpenResearch

sql query

SELECT ordinal
    FROM event_orbackup
    where ordinal is not null
    and ordinal < 50

orbackup ordinals

OpenResearch

sql query

SELECT ordinal
    FROM event_orclone
    where ordinal is not null
    and ordinal < 50

orclone ordinals

OpenResearch

sql query

SELECT ordinal
    FROM event_orclonebackup
    where ordinal is not null
    and ordinal < 50

orclonebackup ordinals

TIBKAT

sql query

SELECT ordinal
    FROM event_tibkat
    where ordinal is not null
    and ordinal < 50

tibkat ordinals

WikiCFP

sql query

SELECT ordinal
    FROM event_wikicfp
    where ordinal is not null
    and ordinal < 50

wikicfp ordinals

Wikidata

sql query

SELECT ordinal
    FROM event_wikidata
    where ordinal is not null
    and ordinal < 50

wikidata ordinals

Eventseries completeness

The queries here only give a rough estimate for an upper bound since the assumption here is that all events between max(ordinal) and min(ordinal) are available which is often not the case.

dblp

sql query

SELECT 
       series,
       min(ordinal) as minOrdinal, 
       max(ordinal) as maxOrdinal,
       avg(ordinal) as avgOrdinal,
       max(Ordinal)-min(Ordinal) as ordinalRange,
       (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

event series completeness of dblp

OpenResearch

sql query

SELECT 
       inEventSeries,
       min(ordinal) as minOrdinal, 
       max(ordinal) as maxOrdinal,
       avg(ordinal) as avgOrdinal,
       max(Ordinal)-min(Ordinal) as ordinalRange,
       (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

event series completeness of orclone

WikiCFP

sql query

SELECT 
       seriesId,
       min(ordinal) as minOrdinal, 
       max(ordinal) as maxOrdinal,
       avg(ordinal) as avgOrdinal,
       max(Ordinal)-min(Ordinal) as ordinalRange,
       (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

event series completeness of wikicfp

Wikidata

sql query

SELECT 
       eventInSeriesId,
       min(ordinal) as minOrdinal, 
       max(ordinal) as maxOrdinal,
       avg(ordinal) as avgOrdinal,
       max(Ordinal)-min(Ordinal) as ordinalRange,
       (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

event series completeness of wikidata

Eventseries completeness by acronym

Not all data sources have an eventseries reference per event. As as alternative approach we analyzed the acronyms to group event series. The results will in some cases mix data from event series with ambiguous acronyms.

CEUR-WS

event series completeness of ceurws

Crossref

event series completeness of crossref

dblp

event series completeness of dblp

GND

event series completeness of gnd

OpenResearch

event series completeness of or

OpenResearch

event series completeness of orbackup

OpenResearch

event series completeness of orclone

OpenResearch

event series completeness of orclonebackup

TIBKAT

event series completeness of tibkat

WikiCFP

event series completeness of wikicfp

Wikidata

event series completeness of wikidata