ConferenceCorpus: Difference between revisions

From BITPlan Wiki
Jump to navigation Jump to search
No edit summary
 
(6 intermediate revisions by the same user not shown)
Line 7: Line 7:
|title=Scientific Event Corpus
|title=Scientific Event Corpus
|url=https://github.com/WolfgangFahl/ConferenceCorpus
|url=https://github.com/WolfgangFahl/ConferenceCorpus
|version=0.0.10
|version=0.1.0
|date=2021-08-03
|date=2022-11-20
|since=2021-07-26
|since=2021-07-26
|storemode=property
|storemode=property
|name=ConferenceCorpus
|name=ConferenceCorpus
}}
}}
=Freitext=
= What Links Here =
{{WhatLinksHere}}
= Installation =
= Installation =
== via pip ==
== via pip ==
Line 34: Line 35:
* https://conferencecorpus.bitplan.com/eventseries/ISWC?format=json
* https://conferencecorpus.bitplan.com/eventseries/ISWC?format=json
* https://conferencecorpus.bitplan.com/eventseries/ISWC?format=html
* https://conferencecorpus.bitplan.com/eventseries/ISWC?format=html
== Database View with Sqlite ==
The EventCorpus.db is in Sqlite format.
=== using sqlite-web ===
<source lang='bash'>
pip install sqlite-web
sqlite_web $HOME/.conferencecorpus/EventCorpus.db
</source>
There is convenience script [https://github.com/WolfgangFahl/ConferenceCorpus/tree/main/scripts/ccsqliteweb ccsqliteweb] available in the [https://github.com/WolfgangFahl/ConferenceCorpus/tree/main/scripts scripts] directory which will also kill an existing sqlite_web EventCorpus.db process and run the server in background using nohup.


== Command Line ==
== Command Line ==
Line 73: Line 82:
title
title
ConfIDent  Event
ConfIDent  Event
2021-08-21
2022-05-11
[[https://projects.tib.eu/en/confident/ © 2019-2021 ConfIDent project]]
[[https://projects.tib.eu/en/confident/ © 2019-2022 ConfIDent project and Wolfgang Fahl]]
see also [[http://ptp.bitplan.com/settings Proceedings Title Parser]]
see also [[http://cc.bitplan.com Conference Corpus]]


end title
end title
Line 84: Line 93:
   country : TEXT  
   country : TEXT  
   eventId : TEXT  
   eventId : TEXT  
  lookupAcronym : TEXT
  ordinal : INTEGER
  region : TEXT
   source : TEXT  
   source : TEXT  
   title : TEXT  
   title : TEXT  
  url : TEXT
   year : INTEGER  
   year : INTEGER  
   }
   }
Note top of event_orclone
[[https://confident.dbis.rwth-aachen.de/or OPENRESEARCH (orclone-api)]]
9470 instances
End note
  class event_orclone << Entity >> {
  acceptedPapers : INTEGER
  creationDate : TIMESTAMP
  endDate : TIMESTAMP
  eventType : TEXT
  homepage : TEXT
  inEventSeries : TEXT
  lastEditor : TEXT
  modificationDate : TIMESTAMP
  ordinal : INTEGER
  pageTitle : TEXT <<PK>>
  region : TEXT
  startDate : TIMESTAMP
  submittedPapers : INTEGER
  yearStr : TEXT
  }
Note top of event_orclonebackup
[[https://confident.dbis.rwth-aachen.de/or OPENRESEARCH (orclone-backup)]]
9325 instances
End note
  class event_orclonebackup << Entity >> {
  acceptedPapers : TEXT
  endDate : TEXT
  eventType : TEXT
  homepage : TEXT
  inEventSeries : TEXT
  ordinal : TEXT
  pageTitle : TEXT <<PK>>
  presence : TEXT
  region : TEXT
  startDate : TEXT
  submittedPapers : TEXT
  yearStr : TEXT
  }
Note top of event_confref
[[http://portal.confref.org ConfRef]]
37945 instances
End note
   class event_confref << Entity >> {
   class event_confref << Entity >> {
   area : TEXT  
   area : TEXT  
  cityWikidataid : TEXT
  countryIso : TEXT
  countryWikidataid : TEXT
   dblpSeriesId : TEXT  
   dblpSeriesId : TEXT  
   endDate : TEXT  
   endDate : TEXT  
   keywords : TEXT  
   keywords : TEXT  
  location : TEXT
   ranks : TEXT  
   ranks : TEXT  
  regionIso : TEXT
  regionWikidataid : TEXT
   seriesId : TEXT  
   seriesId : TEXT  
   seriesTitle : TEXT  
   seriesTitle : TEXT  
   startDate : TEXT  
   startDate : TEXT  
   submissionExtended : BOOLEAN
   submissionExtended : INTEGER
  url : TEXT
   }
   }
Note top of event_crossref
   class event_gnd << Entity >> {
[[https://www.crossref.org/ CrossRef]]
  acronymCount : INTEGER
49280 instances
  acronyms : TEXT
End note
   class event_crossref << Entity >> {
   cityWikidataid : TEXT  
   cityWikidataid : TEXT  
  countryIso : TEXT
   countryWikidataid : TEXT  
   countryWikidataid : TEXT  
   doi : TEXT  
   date : TEXT  
  dateCount : INTEGER
   endDate : DATE  
   endDate : DATE  
  event : TEXT
  fulltitle : TEXT
  homepage : TEXT
   location : TEXT  
   location : TEXT  
   month : INTEGER
   organization : TEXT
   name : TEXT  
   place : TEXT  
   number : TEXT  
   placeCount : INTEGER
   region : TEXT  
  places : TEXT  
   regionIso : TEXT  
   regionWikidataid : TEXT  
   regionWikidataid : TEXT  
  sponsor : TEXT
   startDate : DATE  
   startDate : DATE  
   theme : TEXT
   variant : TEXT  
  }
   variantCount : INTEGER
Note top of event_wikidata
   variants : TEXT  
[[https://www.wikidata.org/wiki/Wikidata:Main_Page Wikidata]]
7508 instances
End note
  class event_wikidata << Entity >> {
  cityId : TEXT
  countryId : TEXT
  dblpConferenceId : TEXT
  endDate : TIMESTAMP
  eventInSeries : TEXT
  eventInSeriesId : TEXT
  gndId : TEXT
  homepage : TEXT
  language : TEXT
  location : TEXT
  locationId : TEXT
  mainSubject : TEXT
  ordinal : TEXT  
   startDate : TIMESTAMP
   wikiCfpId : TEXT  
   }
   }
Note top of event_wikicfp
[[http://www.wikicfp.com WikiCFP]]
87987 instances
End note
   class event_wikicfp << Entity >> {
   class event_wikicfp << Entity >> {
   Final_Version_Due : TEXT  
   Final_Version_Due : TEXT  
Line 191: Line 147:
   Submission_Deadline : TIMESTAMP  
   Submission_Deadline : TIMESTAMP  
   cityWikidataid : TEXT  
   cityWikidataid : TEXT  
  countryIso : TEXT
   countryWikidataid : TEXT  
   countryWikidataid : TEXT  
   deleted : INTEGER  
   deleted : INTEGER  
Line 196: Line 153:
   eventType : TEXT  
   eventType : TEXT  
   locality : TEXT  
   locality : TEXT  
   region : TEXT  
   regionIso : TEXT  
   regionWikidataid : TEXT  
   regionWikidataid : TEXT  
   series : TEXT  
   series : TEXT  
   seriesId : TEXT  
   seriesId : TEXT  
   startDate : TIMESTAMP  
   startDate : TIMESTAMP  
  url : TEXT
   wikiCfpId : INTEGER  
   wikiCfpId : INTEGER  
   }
   }
Note top of event_dblp
  class event_orclone << Entity >> {
[[https://dblp.org/ dblp computer science bibliography]]
  DblpConferenceId : TEXT
47891 instances
  ISBN : TEXT
End note
  TibKatId : TEXT
  acceptedPapers : INTEGER
  creationDate : TIMESTAMP
  endDate : TIMESTAMP
  eventType : TEXT
  homepage : TEXT
  inEventSeries : TEXT
  lastEditor : TEXT
  modificationDate : TIMESTAMP
  pageTitle : TEXT <<PK>>
  startDate : TIMESTAMP
  submittedPapers : INTEGER
  url : TEXT
  wikidataId : TEXT
  yearStr : TEXT
  }
  class event_tibkat << Entity >> {
  alternativeTitles : TEXT
  authorGndId : TEXT
  bk : TEXT
  changeDate : TEXT
  cityWikidataid : TEXT
  corporateCreatorNames : TEXT
  corporateCreatorTypes : TEXT
  countryIso : TEXT
  countryWikidataid : TEXT
  databaseDate : TEXT
  dates : TEXT
  ddc : TEXT
  description : TEXT
  documentGenreCode : TEXT
  documentId : TEXT
  documentTypeCode : TEXT
  doi : TEXT
  ean : TEXT
  endDate : DATE
  event : TEXT
  firstid : TEXT
  ftxCreationDate : TEXT
  gndIds : TEXT
  isbn : TEXT
  isbn13 : TEXT
  journalTitle : TEXT
  journalVolumeNumber : TEXT
  location : TEXT
  ppn : TEXT
  publisher : TEXT
  pubplace : TEXT
  pubyear : TEXT
  regionIso : TEXT
  regionWikidataid : TEXT
  sponsorGndId : TEXT
  startDate : DATE
  }
   class event_dblp << Entity >> {
   class event_dblp << Entity >> {
   booktitle : TEXT  
   booktitle : TEXT  
   cityWikidataid : TEXT  
   cityWikidataid : TEXT  
  countryIso : TEXT
   countryWikidataid : TEXT  
   countryWikidataid : TEXT  
   doi : TEXT  
   doi : TEXT  
   ee : TEXT  
   ee : TEXT  
  endDate : TIMESTAMP
   isbn : TEXT  
   isbn : TEXT  
   location : TEXT  
   location : TEXT  
   mdate : TEXT  
   mdate : TEXT  
   publicationSeries : TEXT  
   publicationSeries : TEXT  
   region : TEXT  
   regionIso : TEXT  
   regionWikidataid : TEXT  
   regionWikidataid : TEXT  
   series : TEXT  
   series : TEXT  
  startDate : TIMESTAMP
  url : TEXT
   }
   }
Note top of event_or
  class event_crossref << Entity >> {
[[https://www.openresearch.org/mediawiki/ OPENRESEARCH (or-api)]]
  cityWikidataid : TEXT
9471 instances
  countryIso : TEXT
End note
  countryWikidataid : TEXT
   class event_or << Entity >> {
  doi : TEXT
   acceptedPapers : INTEGER
  endDate : DATE
   creationDate : TIMESTAMP
  location : TEXT
  month : INTEGER
  name : TEXT
  number : TEXT
  regionIso : TEXT
  regionWikidataid : TEXT
  sponsor : TEXT
  startDate : DATE
  theme : TEXT
  url : TEXT
  }
   class event_wikidata << Entity >> {
   cityWikidataid : TEXT
  countryId : TEXT
  countryIso : TEXT
  countryWikidataid : TEXT
  dblpId : TEXT
  describedAtUrl : TEXT
   doi : TEXT
   endDate : TIMESTAMP  
   endDate : TIMESTAMP  
   eventType : TEXT  
   eventInSeries : TEXT
  eventInSeriesId : TEXT
  eventTitle : TEXT
  followedById : TEXT
  gndId : TEXT  
   homepage : TEXT  
   homepage : TEXT  
   inEventSeries : TEXT  
   language : TEXT  
   lastEditor : TEXT  
   location : TEXT  
   modificationDate : TIMESTAMP
   locationId : TEXT
   ordinal : INTEGER
  mainSubject : TEXT
   pageTitle : TEXT <<PK>>
  ppn : TEXT
   region : TEXT  
   proceedings : TEXT
  proceedingsLabel : TEXT
   regionIso : TEXT  
   regionWikidataid : TEXT  
   startDate : TIMESTAMP  
   startDate : TIMESTAMP  
   submittedPapers : INTEGER
   url : TEXT  
  yearStr : TEXT
   wikiCfpId : TEXT  
  }
Note top of event_orbackup
[[https://www.openresearch.org/mediawiki/ OPENRESEARCH (or-backup)]]
9231 instances
End note
  class event_orbackup << Entity >> {
  acceptedPapers : TEXT
  endDate : TEXT
  eventType : TEXT
  homepage : TEXT
  inEventSeries : TEXT
  ordinal : TEXT
  pageTitle : TEXT <<PK>>
  region : TEXT
  startDate : TEXT
  submittedPapers : TEXT  
   yearStr : TEXT  
   }
   }
  Event <|-- event_confref
  Event <|-- event_gnd
  Event <|-- event_wikicfp
   Event <|-- event_orclone
   Event <|-- event_orclone
   Event <|-- event_orclonebackup
   Event <|-- event_tibkat
   Event <|-- event_confref
   Event <|-- event_dblp
   Event <|-- event_crossref
   Event <|-- event_crossref
   Event <|-- event_wikidata
   Event <|-- event_wikidata
  Event <|-- event_wikicfp
  Event <|-- event_dblp
  Event <|-- event_or
  Event <|-- event_orbackup
}
}
' BITPlan Corporate identity skin params
' BITPlan Corporate identity skin params
' Copyright (c) 2015-2020 BITPlan GmbH
' Copyright (c) 2015-2020 BITPlan GmbH
Line 581: Line 602:
' end of skinparams '
' end of skinparams '
</uml>
</uml>
= Updating the database =
== Openresearch ==
<source lang='bash'>
scripts/getbackup
</source>
gets a copy of the nightly OpenResearch backups
= Issues =
= Issues =
# {{Ticket
# {{Ticket

Latest revision as of 07:17, 18 November 2023

OsProject

OsProject
edit
id  ConferenceCorpus
state  active
owner  WolfgangFahl
title  Scientific Event Corpus
url  https://github.com/WolfgangFahl/ConferenceCorpus
version  0.1.0
description  
date  2022-11-20
since  2021-07-26
until  

What Links Here

Installation

via pip

pip install ConferenceCorpus
# alternatively if your pip is not a python3 pip
pip3 install ConferenceCorpus

upgrade

pip install ConferenceCorpus -U
# alternatively if your pip is not a python3 pip
pip3 install ConferenceCorpus -U

Usage

RESTFul API

Examples

Database View with Sqlite

The EventCorpus.db is in Sqlite format.

using sqlite-web

pip install sqlite-web
sqlite_web $HOME/.conferencecorpus/EventCorpus.db

There is convenience script ccsqliteweb available in the scripts directory which will also kill an existing sqlite_web EventCorpus.db process and run the server in background using nohup.

Command Line

aelookup -h
usage: aelookup [-h] [-d] [-e ENDPOINT] [-v] [-u] [-f]
                [--datasources DATASOURCES]

Scientific Event Corpus and Lookup

  Created by Wolfgang Fahl on 2020-06-22.
  Copyright 2020-2021 Wolfgang Fahl. All rights reserved.

  Licensed under the Apache License 2.0
  http://www.apache.org/licenses/LICENSE-2.0

  Distributed on an "AS IS" basis without warranties
  or conditions of any kind, either express or implied.

USAGE

optional arguments:
  -h, --help            show this help message and exit
  -d, --debug           show debug info
  -e ENDPOINT, --endpoint ENDPOINT
                        SPARQL endpoint to use for wikidata queries
  -v, --version         show program's version number and exit
  -u, --uml             output plantuml diagram markup
  -f, --force           force Update - may take quite a time
  --datasources DATASOURCES
                        , delimited list of datasource lookup ids

Overview

Datasources

You might want to open the diagrams in a new tab to be able to click the links depicted.

Event

EventSeries

Updating the database

Openresearch

scripts/getbackup

gets a copy of the nightly OpenResearch backups

Issues

  1. Issue 33 - Event series completion
  2. Issue 32 - regression TemplateNotFound: fb4common/base.html
  3. Issue 31 - Provide RDF export of the data
  4. Issue 30 - add ordinal distribution query✓
  5. Issue 29 - add scholar RESTFul API
  6. Issue 28 - add generic search for scholarly items
  7. Issue 27 - openresearch results missing in multiquery
  8. Issue 26 - add bib file import
  9. Issue 25 - make multiquery result available via webapi with content negotiation✓
  10. Issue 24 - allow updating the database via webserver
  11. Issue 23 - dictOfLod Lookup result via commandline
  12. Issue 22 - add multi query option✓
  13. Issue 21 - add Webserver✓
  14. Issue 20 - Work around upstream Nominatim OSM Pythontools issue✓
  15. Issue 19 - Update Openresearch Samples✓
  16. Issue 18 - Update requirements.txt✓
  17. Issue 17 - include ACM digital library as a source
  18. Issue 16 - Steps towards csv upload✓
  19. Issue 15 - Filter obviously invalid Series and Event entries✓
  20. Issue 14 - wikiCFP 500 Internal Server and TimeOut Error Handling✓
  21. Issue 12 - Relevant FTX fields
  22. Issue 11 - Locality fixes
  23. Issue 10 - OpenResearch export option
  24. Issue 9 - offline access to EventCorpus.db
  25. Issue 8 - migrate confref data from Proceedings Title Parser here✓
  26. Issue 7 - migrate crossref data from proceedings title parser here✓
  27. Issue 6 - migrate dblp data source here from ptp and dblpconf✓
  28. Issue 5 - dblp xml parser skips some proceedings titles
  29. Issue 4 - add commandline interface to CorpusLookup✓
  30. Issue 3 - add python api doc✓
  31. Issue 2 - Cache all SQL tables in the same SQLite database in a ".conferencecorpus" directory✓
  32. Issue 1 - There should be a common set of attributes for Event and EventSeries from different datasources
Retrieved from "https://wiki.bitplan.com/index.php?title=ConferenceCorpus&oldid=18087"