Difference between revisions of "ConferenceCorpus/statistics"

From BITPlan Wiki
Jump to navigation Jump to search
Line 53: Line 53:
 
</source>
 
</source>
 
=== histogramm ===
 
=== histogramm ===
[[File:dblp_series_completeness.png|600px]
+
[[File:dblp_series_completeness.png|600px]]
 +
 
 
== openresearch ==
 
== openresearch ==
 
=== sql query ===
 
=== sql query ===

Revision as of 12:52, 18 May 2022

Ordinal histogramms

ceurws

Ordinalhistogramm event ceurws.png

orbackup

Ordinalhistogramm event orbackup.png

orclonebackup

Ordinalhistogramm event orclonebackup.png

confref

Ordinalhistogramm event confref.png

gnd

Ordinalhistogramm event gnd.png

wikicfp

Ordinalhistogramm event wikicfp.png

or

Ordinalhistogramm event or.png

orclone

Ordinalhistogramm event orclone.png

tibkat

Ordinalhistogramm event tibkat.png

dblp

Ordinalhistogramm event dblp.png

crossref

Ordinalhistogramm event crossref.png

wikidata

Ordinalhistogramm event wikidata.png

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

Dblp series completeness.png

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

Orclone series completeness.png


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

Wikicfp series completeness.png

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

Wikidata series completeness.png