Difference between revisions of "Workdocumentation 2022-08-15"

From BITPlan ceur-ws Wiki
Jump to navigation Jump to search
(Created page with "sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki == SubmittedByGt6 == === query === <source lang='sql'> SELECT count(*) as count,submittedBy FROM "volumes"...")
 
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{PageSequence|prev=Workdocumentation 2022-08-13|next=Workdocumentation 2022-08-16|category=Workdocumentation}}
 +
= Participants =
 +
* Tim
 +
* Wolfgang
 +
= Agenda =
 +
* CEUR-WS Volume Browser
 +
* Structure
 +
* Parser
 +
* Queries
 +
 +
= CEUR-WS Volume Browser =
 +
* http://ceur-ws-browser.bitplan.com/
 +
= Structure =
 +
<uml>
 +
hide circle
 +
note top of ceurws
 +
https://github.com/ceurws/ceur-make-ui
 +
https://github.com/ceurws/ceur-make
 +
https://github.com/ceurws/ceur-make/blob/master/workshop.xml
 +
https://github.com/ceurws/ceur-make/blob/master/toc.xml
 +
end note
 +
package ceurws {
 +
  class Paper {
 +
    title
 +
    pdf
 +
    frompage
 +
    topage
 +
   
 +
  }
 +
  class Author {
 +
  name
 +
  }
 +
note top of Series
 +
see also links are generated for Series
 +
end note
 +
  class Series {
 +
    acronym
 +
  }
 +
note top of Volume
 +
Volumes are indexed in dblp and k10plus and partly wikidata
 +
end note
 +
  class Volume {
 +
    number
 +
    homepage
 +
    lang
 +
    location
 +
    country
 +
    city
 +
    ordinal
 +
    date
 +
    pubyear
 +
    publish()
 +
    preView()
 +
    openTicket()
 +
    createIndexHtml()
 +
    importZipFromEasyChair(zipfile)
 +
    createBibTexFile()
 +
  }
 +
note top of Conference
 +
a Conference is a parent Event of a Workshop
 +
end note
 +
  class Conference {
 +
      acronym
 +
      full
 +
      homepage
 +
  }
 +
note top of Event
 +
eventType can be Workshop or Conference
 +
end note
 +
  class Event {
 +
    id
 +
    eventType
 +
    acronym
 +
    volume
 +
    full
 +
  }
 +
note top of Session
 +
sessions are optional
 +
end note
 +
  class Session {
 +
    title
 +
  }
 +
  class Editor {
 +
    name
 +
    affiliation
 +
    country
 +
  }
 +
  Series "1" - "n" Volume
 +
  Volume "1" - "1" Event
 +
  Volume "1" - "0..1" Conference
 +
  Volume "1" - "n" Session
 +
  Volume "1" - "n" Editor
 +
  Session "1" - "n" Paper
 +
  Paper "1" - "n" Author
 +
}
 +
</uml>
 +
 +
= Parser =
 +
* [[Semantic Publishing Challenge -- Assessing the Quality of Scientific Output]]
 +
* {{Link|target=Maxim Kolchin}}
 +
 +
= Queries =
 +
== Colocation ==
 +
<source lang='bash'>
 +
SELECT count(colocated)
 +
FROM "volumes"
 +
where colocated is not null
 +
</source>
 +
1326
 +
 +
== Top Submitters ==
 
sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki
 
sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki
−
== SubmittedByGt6 ==
+
== SubmittedByGt6ForWiki ==
  
 
=== query ===
 
=== query ===
 
<source lang='sql'>
 
<source lang='sql'>
−
SELECT count(*) as count,submittedBy
+
SELECT count(*) as count,"{{Link|target="||submittedBy||"}}"
 
FROM "volumes"
 
FROM "volumes"
 
GROUP BY submittedBY
 
GROUP BY submittedBY
Line 17: Line 128:
 
|+ <!-- caption -->
 
|+ <!-- caption -->
 
|-
 
|-
−
! align="right"|  count !! submittedBy
+
! align="right"|  count !! Link
 
|-
 
|-
−
| align="right"|      26 || Nicola Ferro
+
| align="right"|      26 || {{Link|target=Nicola Ferro}}
 
|-
 
|-
−
| align="right"|      18 || Pavel Shvaiko
+
| align="right"|      18 || {{Link|target=Pavel Shvaiko}}
 
|-
 
|-
−
| align="right"|      15 || Philipp Mayr
+
| align="right"|      15 || {{Link|target=Philipp Mayr}}
 
|-
 
|-
−
| align="right"|      13 || Denis Kudryashov
+
| align="right"|      13 || {{Link|target=Denis Kudryashov}}
 
|-
 
|-
−
| align="right"|      13 || Christoph Lange
+
| align="right"|      13 || {{Link|target=Christoph Lange}}
 
|-
 
|-
−
| align="right"|      10 || Sarven Capadisli
+
| align="right"|      10 || {{Link|target=Sarven Capadisli}}
 
|-
 
|-
−
| align="right"|      10 || Pasquale Lops
+
| align="right"|      10 || {{Link|target=Pasquale Lops}}
 
|-
 
|-
−
| align="right"|      9 || Ruben Verborgh
+
| align="right"|      9 || {{Link|target=Ruben Verborgh}}
 
|-
 
|-
−
| align="right"|      9 || Grzegorz J. Nalepa
+
| align="right"|      9 || {{Link|target=Grzegorz J. Nalepa}}
 
|-
 
|-
−
| align="right"|      9 || Christian Napoli
+
| align="right"|      9 || {{Link|target=Christian Napoli}}
 
|-
 
|-
−
| align="right"|      8 || Xavier Franch
+
| align="right"|      8 || {{Link|target=Xavier Franch}}
 
|-
 
|-
−
| align="right"|      8 || Serhiy O. Semerikov
+
| align="right"|      8 || {{Link|target=Serhiy O. Semerikov}}
 
|-
 
|-
−
| align="right"|      8 || Ralf Klamma
+
| align="right"|      8 || {{Link|target=Ralf Klamma}}
 
|-
 
|-
−
| align="right"|      8 || Oliver Kutz
+
| align="right"|      8 || {{Link|target=Oliver Kutz}}
 
|-
 
|-
−
| align="right"|      8 || Horst Lichter
+
| align="right"|      8 || {{Link|target=Horst Lichter}}
 
|-
 
|-
−
| align="right"|      8 || Frans Van Assche
+
| align="right"|      8 || {{Link|target=Frans Van Assche}}
 
|-
 
|-
−
| align="right"|      8 || Dmitry Ustalov
+
| align="right"|      8 || {{Link|target=Dmitry Ustalov}}
 
|-
 
|-
−
| align="right"|      8 || Dmitry Ignatov
+
| align="right"|      8 || {{Link|target=Dmitry Ignatov}}
 
|-
 
|-
−
| align="right"|      8 || Birgit Penzenstadler
+
| align="right"|      8 || {{Link|target=Birgit Penzenstadler}}
 
|-
 
|-
−
| align="right"|      8 || Antonio Lieto
+
| align="right"|      8 || {{Link|target=Antonio Lieto}}
 
|-
 
|-
−
| align="right"|      8 || Adrian Giurca
+
| align="right"|      8 || {{Link|target=Adrian Giurca}}
 
|-
 
|-
−
| align="right"|      7 || Zoran Budimac
+
| align="right"|      7 || {{Link|target=Zoran Budimac}}
 
|-
 
|-
−
| align="right"|      7 || Vitaliy Yakovyna
+
| align="right"|      7 || {{Link|target=Vitaliy Yakovyna}}
 
|-
 
|-
−
| align="right"|      7 || Thomas Daniel Ullmann
+
| align="right"|      7 || {{Link|target=Thomas Daniel Ullmann}}
 
|-
 
|-
−
| align="right"|      7 || Tarek R. Besold
+
| align="right"|      7 || {{Link|target=Tarek R. Besold}}
 
|-
 
|-
−
| align="right"|      7 || Solomiia Fedushko
+
| align="right"|      7 || {{Link|target=Solomiia Fedushko}}
 
|-
 
|-
−
| align="right"|      7 || S&ouml;ren Auer
+
| align="right"|      7 || {{Link|target=S&ouml;ren Auer}}
 
|-
 
|-
−
| align="right"|      7 || Paul Johannesson
+
| align="right"|      7 || {{Link|target=Paul Johannesson}}
 
|-
 
|-
−
| align="right"|      7 || Parth Mehta
+
| align="right"|      7 || {{Link|target=Parth Mehta}}
 
|-
 
|-
−
| align="right"|      7 || Max L. Wilson
+
| align="right"|      7 || {{Link|target=Max L. Wilson}}
 
|-
 
|-
−
| align="right"|      7 || Manuel Wimmer
+
| align="right"|      7 || {{Link|target=Manuel Wimmer}}
 
|-
 
|-
−
| align="right"|      7 || Kostas Stefanidis
+
| align="right"|      7 || {{Link|target=Kostas Stefanidis}}
 
|-
 
|-
−
| align="right"|      7 || Kathryn Blackmond Laskey
+
| align="right"|      7 || {{Link|target=Kathryn Blackmond Laskey}}
 
|-
 
|-
−
| align="right"|      7 || Giuseppe Vizzari
+
| align="right"|      7 || {{Link|target=Giuseppe Vizzari}}
 
|-
 
|-
−
| align="right"|      7 || Filippo Palumbo
+
| align="right"|      7 || {{Link|target=Filippo Palumbo}}
 
|-
 
|-
−
| align="right"|      7 || Dmitry S. Kulyabov
+
| align="right"|      7 || {{Link|target=Dmitry S. Kulyabov}}
 
|-
 
|-
−
| align="right"|      7 || Dietmar Jannach
+
| align="right"|      7 || {{Link|target=Dietmar Jannach}}
 
|}
 
|}

Latest revision as of 11:02, 16 August 2022

Participants

  • Tim
  • Wolfgang

Agenda

  • CEUR-WS Volume Browser
  • Structure
  • Parser
  • Queries

CEUR-WS Volume Browser

Structure

Parser

Queries

Colocation

SELECT count(colocated)
FROM "volumes"
where colocated is not null

1326

Top Submitters

sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki

SubmittedByGt6ForWiki

query

SELECT count(*) as count,"{{Link|target="||submittedBy||"}}"
FROM "volumes"
GROUP BY submittedBY
HAVING COUNT(*) > 6
ORDER BY 1 DESC


result

count Link
26 Nicola Ferro
18 Pavel Shvaiko
15 Philipp Mayr
13 Denis Kudryashov
13 Christoph Lange
10 Sarven Capadisli
10 Pasquale Lops
9 Ruben Verborgh
9 Grzegorz J. Nalepa
9 Christian Napoli
8 Xavier Franch
8 Serhiy O. Semerikov
8 Ralf Klamma
8 Oliver Kutz
8 Horst Lichter
8 Frans Van Assche
8 Dmitry Ustalov
8 Dmitry Ignatov
8 Birgit Penzenstadler
8 Antonio Lieto
8 Adrian Giurca
7 Zoran Budimac
7 Vitaliy Yakovyna
7 Thomas Daniel Ullmann
7 Tarek R. Besold
7 Solomiia Fedushko
7 Sören Auer
7 Paul Johannesson
7 Parth Mehta
7 Max L. Wilson
7 Manuel Wimmer
7 Kostas Stefanidis
7 Kathryn Blackmond Laskey
7 Giuseppe Vizzari
7 Filippo Palumbo
7 Dmitry S. Kulyabov
7 Dietmar Jannach
Retrieved from "http://ceur-ws.bitplan.com/index.php?title=Workdocumentation_2022-08-15&oldid=670"