Difference between revisions of "ConferenceCorpus/statistics"

From BITPlan Wiki
Jump to navigation Jump to search
Line 5: Line 5:
 
To few available ordinals for analysis.     
 
To few available ordinals for analysis.     
 
              
 
              
−
== Crossref==
+
== CEUR-WS ==
−
[[File:ordinalhistogramm_event_crossref.png|600px]]
+
=== sql query ===
−
[[File:zipf_event_crossref.png|600px]]      
+
<source lang='sql'>
−
           
+
SELECT ordinal
−
== dblp==
+
    FROM event_ceurws
−
[[File:ordinalhistogramm_event_dblp.png|600px]]
+
    where ordinal is not null
−
[[File:zipf_event_dblp.png|600px]]      
+
    and ordinal < 50
−
           
+
   
−
== GND==
+
</source>
−
[[File:ordinalhistogramm_event_gnd.png|600px]]
+
=== ceurws ordinals ===
−
[[File:zipf_event_gnd.png|600px]]      
+
[[File:ordinalhistogramm_event_ceurws.png|600px]][[File:zipf_event_ceurws.png|600px]]
−
           
+
== confref ==
−
== OpenResearch==
+
=== sql query ===
−
[[File:ordinalhistogramm_event_orclone.png|600px]]
+
<source lang='sql'>
−
[[File:zipf_event_orclone.png|600px]]      
+
SELECT ordinal
−
                       
+
    FROM event_confref
−
== TIBKAT==
+
    where ordinal is not null
−
[[File:ordinalhistogramm_event_tibkat.png|600px]]
+
    and ordinal < 50
−
[[File:zipf_event_tibkat.png|600px]]      
+
   
−
           
+
</source>
−
== WikiCFP==
+
=== confref ordinals ===
−
[[File:ordinalhistogramm_event_wikicfp.png|600px]]
+
[[File:ordinalhistogramm_event_confref.png|600px]][[File:zipf_event_confref.png|600px]]
−
[[File:zipf_event_wikicfp.png|600px]]      
+
== Crossref ==
−
           
+
=== sql query ===
−
== Wikidata==
+
<source lang='sql'>
−
[[File:ordinalhistogramm_event_wikidata.png|600px]]
+
SELECT ordinal
−
[[File:zipf_event_wikidata.png|600px]]
+
    FROM event_crossref
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== crossref ordinals ===
 +
[[File:ordinalhistogramm_event_crossref.png|600px]][[File:zipf_event_crossref.png|600px]]
 +
== dblp ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_dblp
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== dblp ordinals ===
 +
[[File:ordinalhistogramm_event_dblp.png|600px]][[File:zipf_event_dblp.png|600px]]
 +
== GND ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_gnd
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== gnd ordinals ===
 +
[[File:ordinalhistogramm_event_gnd.png|600px]][[File:zipf_event_gnd.png|600px]]
 +
== OpenResearch ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_or
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== or ordinals ===
 +
[[File:ordinalhistogramm_event_or.png|600px]][[File:zipf_event_or.png|600px]]
 +
== OpenResearch ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_orbackup
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== orbackup ordinals ===
 +
[[File:ordinalhistogramm_event_orbackup.png|600px]][[File:zipf_event_orbackup.png|600px]]
 +
== OpenResearch ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_orclone
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== orclone ordinals ===
 +
[[File:ordinalhistogramm_event_orclone.png|600px]][[File:zipf_event_orclone.png|600px]]
 +
== OpenResearch ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_orclonebackup
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== orclonebackup ordinals ===
 +
[[File:ordinalhistogramm_event_orclonebackup.png|600px]][[File:zipf_event_orclonebackup.png|600px]]
 +
== TIBKAT ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_tibkat
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== tibkat ordinals ===
 +
[[File:ordinalhistogramm_event_tibkat.png|600px]][[File:zipf_event_tibkat.png|600px]]
 +
== WikiCFP ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_wikicfp
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== wikicfp ordinals ===
 +
[[File:ordinalhistogramm_event_wikicfp.png|600px]][[File:zipf_event_wikicfp.png|600px]]
 +
== Wikidata ==
 +
=== sql query ===
 +
<source lang='sql'>
 +
SELECT ordinal
 +
    FROM event_wikidata
 +
    where ordinal is not null
 +
    and ordinal < 50
 +
   
 +
</source>
 +
=== wikidata ordinals ===
 +
[[File:ordinalhistogramm_event_wikidata.png|600px]][[File:zipf_event_wikidata.png|600px]]
  
 
= Eventseries completeness =
 
= Eventseries completeness =

Revision as of 08:37, 19 May 2022

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

Ordinalhistogramm event ceurws.pngZipf event ceurws.png

confref

sql query

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

confref ordinals

Ordinalhistogramm event confref.pngZipf event confref.png

Crossref

sql query

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

crossref ordinals

Ordinalhistogramm event crossref.pngZipf event crossref.png

dblp

sql query

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

dblp ordinals

Ordinalhistogramm event dblp.pngZipf event dblp.png

GND

sql query

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

gnd ordinals

Ordinalhistogramm event gnd.pngZipf event gnd.png

OpenResearch

sql query

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

or ordinals

Ordinalhistogramm event or.pngZipf event or.png

OpenResearch

sql query

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

orbackup ordinals

Ordinalhistogramm event orbackup.pngZipf event orbackup.png

OpenResearch

sql query

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

orclone ordinals

Ordinalhistogramm event orclone.pngZipf event orclone.png

OpenResearch

sql query

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

orclonebackup ordinals

Ordinalhistogramm event orclonebackup.pngZipf event orclonebackup.png

TIBKAT

sql query

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

tibkat ordinals

Ordinalhistogramm event tibkat.pngZipf event tibkat.png

WikiCFP

sql query

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

wikicfp ordinals

Ordinalhistogramm event wikicfp.pngZipf event wikicfp.png

Wikidata

sql query

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

wikidata ordinals

Ordinalhistogramm event wikidata.pngZipf 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

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

Tibkat 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

Retrieved from "https://wiki.bitplan.com/index.php?title=ConferenceCorpus/statistics&oldid=15531"