Difference between revisions of "ConferenceCorpus"

From BITPlan Wiki
Jump to navigation Jump to search
(12 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
{{OsProject
 
{{OsProject
 
|id=ConferenceCorpus
 
|id=ConferenceCorpus
 +
|state=active
 
|owner=WolfgangFahl
 
|owner=WolfgangFahl
 
|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
 
|storemode=property
 
|storemode=property
 
|name=ConferenceCorpus
 
|name=ConferenceCorpus
 
}}
 
}}
−
 
+
=Freitext=
 
= Installation =
 
= Installation =
 
== via pip ==
 
== via pip ==
Line 26: Line 28:
 
</source>
 
</source>
 
= Usage =
 
= Usage =
 +
== RESTFul API ==
 +
=== Examples ===
 +
* https://conferencecorpus.bitplan.com/eventseries/WEBIST?format=json
 +
* https://conferencecorpus.bitplan.com/eventseries/WEBIST?format=html
 +
* https://conferencecorpus.bitplan.com/eventseries/ISWC?format=json
 +
* 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 ==
 
<source lang='bash'>
 
<source lang='bash'>
Line 64: Line 81:
 
title
 
title
 
ConfIDent  Event
 
ConfIDent  Event
−
2021-08-10
+
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 72: Line 89:
 
   class Event << Entity >> {
 
   class Event << Entity >> {
 
   acronym : TEXT  
 
   acronym : TEXT  
 +
  city : 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_crossref
+
   class event_confref << Entity >> {
−
[[https://www.crossref.org/ CrossRef]]
+
   area : TEXT
−
49280 instances
+
  cityWikidataid : TEXT
−
End note
+
  countryIso : TEXT
−
   class event_crossref << Entity >> {
+
  countryWikidataid : TEXT
−
   doi : TEXT  
+
  dblpSeriesId : TEXT  
−
   endDate : DATE
+
   endDate : TEXT
 +
  keywords : TEXT
 
   location : TEXT  
 
   location : TEXT  
−
   month : INTEGER
+
   ranks : TEXT  
−
  name : TEXT
+
   regionIso : TEXT  
−
  number : TEXT
+
   regionWikidataid : TEXT  
−
  sponsor : TEXT
+
   seriesId : TEXT  
−
  startDate : DATE
+
   seriesTitle : TEXT  
−
  theme : TEXT
 
−
  }
 
−
Note top of event_orbackup
 
−
[[https://www.openresearch.org/mediawiki/ OPENRESEARCH (or-backup)]]
 
−
9231 instances
 
−
End note
 
−
  class event_orbackup << Entity >> {
 
−
  acceptedPapers : TEXT
 
−
  city : TEXT
 
−
  country : TEXT
 
−
  endDate : TEXT
 
−
  eventType : TEXT
 
−
  homepage : TEXT  
 
−
   inEventSeries : TEXT  
 
−
   ordinal : TEXT  
 
−
   pageTitle : TEXT <<PK>>
 
−
   region : TEXT  
 
 
   startDate : TEXT  
 
   startDate : TEXT  
−
   submittedPapers : TEXT
+
   submissionExtended : INTEGER
−
   yearStr : TEXT  
+
   url : TEXT  
 
   }
 
   }
−
Note top of event_wikidata
+
   class event_gnd << Entity >> {
−
[[https://www.wikidata.org/wiki/Wikidata:Main_Page Wikidata]]
+
   acronymCount : INTEGER
−
7444 instances
+
  acronyms : TEXT  
−
End note
+
   cityWikidataid : TEXT  
−
   class event_wikidata << Entity >> {
+
   countryIso : TEXT  
−
   country : TEXT  
+
   countryWikidataid : TEXT
−
   countryId : TEXT  
+
   date : TEXT  
−
   dblpConferenceId : TEXT  
+
   dateCount : INTEGER
−
   endDate : TIMESTAMP
+
  endDate : DATE
−
   eventInSeries : TEXT  
+
  event : TEXT  
−
   eventInSeriesId : TEXT  
+
   fulltitle : TEXT  
−
   gndId : TEXT  
 
 
   homepage : TEXT  
 
   homepage : TEXT  
−
   language : TEXT  
+
   location : TEXT  
−
   mainSubject : TEXT  
+
   organization : TEXT  
−
   ordinal : TEXT  
+
   place : TEXT
−
   startDate : TIMESTAMP
+
  placeCount : INTEGER
−
   wikiCfpId : TEXT  
+
  places : TEXT
 +
  regionIso : TEXT
 +
  regionWikidataid : TEXT  
 +
   startDate : DATE
 +
  variant : TEXT
 +
  variantCount : INTEGER
 +
   variants : TEXT  
 
   }
 
   }
−
Note top of event_or
+
   class event_wikicfp << Entity >> {
−
[[https://www.openresearch.org/mediawiki/ OPENRESEARCH (or-api)]]
+
   Final_Version_Due : TEXT
−
9455 instances
+
  Notification_Due : TIMESTAMP
−
End note
+
  Submission_Deadline : TIMESTAMP
−
   class event_or << Entity >> {
+
  cityWikidataid : TEXT
−
   acceptedPapers : INTEGER
+
   countryIso : TEXT  
−
   city : TEXT  
+
   countryWikidataid : TEXT  
−
   country : TEXT  
+
   deleted : INTEGER
−
   creationDate : TIMESTAMP
 
 
   endDate : TIMESTAMP  
 
   endDate : TIMESTAMP  
 
   eventType : TEXT  
 
   eventType : TEXT  
−
   homepage : TEXT  
+
   locality : TEXT  
−
   inEventSeries : TEXT  
+
   regionIso : TEXT  
−
   lastEditor : TEXT  
+
   regionWikidataid : TEXT  
−
   modificationDate : TIMESTAMP
+
   series : TEXT  
−
  ordinal : INTEGER
+
   seriesId : TEXT  
−
  pageTitle : TEXT <<PK>>
 
−
   region : TEXT  
 
 
   startDate : TIMESTAMP  
 
   startDate : TIMESTAMP  
−
   submittedPapers : INTEGER
+
   url : TEXT  
−
  yearStr : TEXT  
+
   wikiCfpId : INTEGER
−
  }
 
−
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
 
−
  city : TEXT
 
−
  country : 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_orclone
 
−
[[https://confident.dbis.rwth-aachen.de/or OPENRESEARCH (orclone-api)]]
 
−
9455 instances
 
−
End note
 
 
   class event_orclone << Entity >> {
 
   class event_orclone << Entity >> {
 +
  DblpConferenceId : TEXT
 +
  ISBN : TEXT
 +
  TibKatId : TEXT
 
   acceptedPapers : INTEGER  
 
   acceptedPapers : INTEGER  
−
  city : TEXT
 
−
  country : TEXT
 
 
   creationDate : TIMESTAMP  
 
   creationDate : TIMESTAMP  
 
   endDate : TIMESTAMP  
 
   endDate : TIMESTAMP  
Line 188: Line 172:
 
   lastEditor : TEXT  
 
   lastEditor : TEXT  
 
   modificationDate : TIMESTAMP  
 
   modificationDate : TIMESTAMP  
−
  ordinal : INTEGER
 
 
   pageTitle : TEXT <<PK>>
 
   pageTitle : TEXT <<PK>>
−
  region : TEXT
 
 
   startDate : TIMESTAMP  
 
   startDate : TIMESTAMP  
 
   submittedPapers : INTEGER  
 
   submittedPapers : INTEGER  
 +
  url : TEXT
 +
  wikidataId : TEXT
 
   yearStr : TEXT  
 
   yearStr : TEXT  
 
   }
 
   }
−
Note top of event_wikicfp
+
   class event_tibkat << Entity >> {
−
[[http://www.wikicfp.com WikiCFP]]
+
   alternativeTitles : TEXT
−
88236 instances
+
  authorGndId : TEXT
−
End note
+
  bk : TEXT
−
   class event_wikicfp << Entity >> {
+
  changeDate : TEXT
−
   Final_Version_Due : TEXT  
+
  cityWikidataid : TEXT
−
   Notification_Due : TIMESTAMP
+
  corporateCreatorNames : TEXT
−
   Submission_Deadline : TIMESTAMP
+
  corporateCreatorTypes : TEXT
−
   deleted : BOOLEAN
+
  countryIso : TEXT
−
   endDate : TIMESTAMP
+
  countryWikidataid : TEXT
−
   eventType : TEXT  
+
  databaseDate : TEXT
−
   locality : TEXT  
+
  dates : TEXT
−
   series : TEXT  
+
  ddc : TEXT  
−
   seriesId : TEXT  
+
   description : TEXT
−
   startDate : TIMESTAMP
+
   documentGenreCode : TEXT
−
   wikiCfpId : INTEGER
+
   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
 
   }
 
   }
−
Note top of event_dblp
 
−
[[https://dblp.org/ dblp computer science bibliography]]
 
−
47891 instances
 
−
End note
 
 
   class event_dblp << Entity >> {
 
   class event_dblp << Entity >> {
 
   booktitle : TEXT  
 
   booktitle : TEXT  
 +
  cityWikidataid : TEXT
 +
  countryIso : TEXT
 +
  countryWikidataid : TEXT
 
   doi : TEXT  
 
   doi : TEXT  
 
   ee : TEXT  
 
   ee : TEXT  
 +
  endDate : TIMESTAMP
 
   isbn : TEXT  
 
   isbn : TEXT  
 +
  location : TEXT
 
   mdate : TEXT  
 
   mdate : TEXT  
 
   publicationSeries : TEXT  
 
   publicationSeries : TEXT  
 +
  regionIso : TEXT
 +
  regionWikidataid : TEXT
 
   series : TEXT  
 
   series : TEXT  
 +
  startDate : TIMESTAMP
 +
  url : TEXT
 
   }
 
   }
−
Note top of event_confref
+
  class event_crossref << Entity >> {
−
[[http://portal.confref.org ConfRef]]
+
  cityWikidataid : TEXT
−
37945 instances
+
  countryIso : TEXT
−
End note
+
  countryWikidataid : TEXT
−
   class event_confref << Entity >> {
+
  doi : TEXT
−
   area : TEXT  
+
  endDate : DATE
−
   city : TEXT  
+
  location : TEXT
−
   country : TEXT  
+
  month : INTEGER
−
   dblpSeriesId : TEXT  
+
  name : TEXT
−
   endDate : TEXT  
+
  number : TEXT
−
   keywords : TEXT  
+
  regionIso : TEXT
−
   ranks : TEXT  
+
  regionWikidataid : TEXT
−
   seriesId : TEXT  
+
  sponsor : TEXT
−
   seriesTitle : TEXT  
+
  startDate : DATE
−
   startDate : TEXT  
+
  theme : TEXT
−
   submissionExtended : BOOLEAN
+
  url : TEXT
 +
  }
 +
   class event_wikidata << Entity >> {
 +
   cityWikidataid : TEXT
 +
  countryId : TEXT
 +
  countryIso : TEXT
 +
  countryWikidataid : TEXT  
 +
   dblpId : TEXT  
 +
   describedAtUrl : TEXT  
 +
   doi : TEXT  
 +
   endDate : TIMESTAMP
 +
  eventInSeries : TEXT
 +
  eventInSeriesId : TEXT
 +
  eventTitle : TEXT
 +
  followedById : TEXT
 +
  gndId : TEXT
 +
  homepage : TEXT
 +
  language : TEXT
 +
  location : TEXT  
 +
   locationId : TEXT  
 +
   mainSubject : TEXT  
 +
   ppn : TEXT  
 +
   proceedings : TEXT
 +
  proceedingsLabel : TEXT
 +
  regionIso : TEXT
 +
  regionWikidataid : TEXT  
 +
   startDate : TIMESTAMP
 +
  url : TEXT  
 +
   wikiCfpId : TEXT
 
   }
 
   }
 +
  Event <|-- event_confref
 +
  Event <|-- event_gnd
 +
  Event <|-- event_wikicfp
 +
  Event <|-- event_orclone
 +
  Event <|-- event_tibkat
 +
  Event <|-- event_dblp
 
   Event <|-- event_crossref
 
   Event <|-- event_crossref
−
  Event <|-- event_orbackup
 
 
   Event <|-- event_wikidata
 
   Event <|-- event_wikidata
−
  Event <|-- event_or
 
−
  Event <|-- event_orclonebackup
 
−
  Event <|-- event_orclone
 
−
  Event <|-- event_wikicfp
 
−
  Event <|-- event_dblp
 
−
  Event <|-- event_confref
 
 
}
 
}
−
 
 
' BITPlan Corporate identity skin params
 
' BITPlan Corporate identity skin params
 
' Copyright (c) 2015-2020 BITPlan GmbH
 
' Copyright (c) 2015-2020 BITPlan GmbH
Line 335: Line 371:
 
=== EventSeries ===
 
=== EventSeries ===
 
<uml format='svg'>
 
<uml format='svg'>
 +
title
 
ConfIDent  EventSeries
 
ConfIDent  EventSeries
 
2021-08-21
 
2021-08-21
Line 564: Line 601:
 
' 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 =
 +
# {{Ticket
 +
|number=33
 +
|title=Event series completion
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-28 15:10:53+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=32
 +
|title=regression TemplateNotFound: fb4common/base.html
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-22 08:04:01+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=31
 +
|title=Provide RDF export of the data
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-21 15:04:52+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=30
 +
|title=add ordinal distribution query
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-14 14:27:00+00:00
 +
|closedAt=2022-01-14 14:27:38+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=29
 +
|title=add scholar RESTFul API
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-14 06:55:23+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=28
 +
|title=add generic search for scholarly items
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-14 06:54:39+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=27
 +
|title=openresearch results missing in multiquery
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-13 10:22:50+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=26
 +
|title=add bib file import
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-12 13:22:01+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=25
 +
|title=make multiquery result available via webapi with content negotiation
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-11 08:16:01+00:00
 +
|closedAt=2022-01-11 10:41:51+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=24
 +
|title=allow updating the database via webserver
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-10 08:38:57+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=23
 +
|title=dictOfLod Lookup result via commandline
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-06 15:34:46+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=22
 +
|title=add multi query option
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-03 17:03:25+00:00
 +
|closedAt=2022-01-11 08:14:31+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=21
 +
|title=add Webserver
 +
|project=ConferenceCorpus
 +
|createdAt=2022-01-01 11:10:30+00:00
 +
|closedAt=2022-01-03 16:58:11+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=20
 +
|title=Work around upstream Nominatim OSM Pythontools issue
 +
|project=ConferenceCorpus
 +
|createdAt=2021-12-13 06:11:42+00:00
 +
|closedAt=2021-12-15 13:19:46+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=19
 +
|title=Update Openresearch Samples
 +
|project=ConferenceCorpus
 +
|createdAt=2021-12-02 13:31:46+00:00
 +
|closedAt=2021-12-05 23:05:16+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=18
 +
|title=Update requirements.txt
 +
|project=ConferenceCorpus
 +
|createdAt=2021-11-09 22:41:47+00:00
 +
|closedAt=2021-12-12 16:43:29+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=17
 +
|title=include ACM digital library as a source
 +
|project=ConferenceCorpus
 +
|createdAt=2021-11-04 08:15:21+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=16
 +
|title=Steps towards csv upload
 +
|project=ConferenceCorpus
 +
|createdAt=2021-09-29 22:56:51+00:00
 +
|closedAt=2021-10-08 11:51:32+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=15
 +
|title=Filter obviously invalid Series and Event entries
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-10 12:12:27+00:00
 +
|closedAt=2021-08-10 12:15:42+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=14
 +
|title=wikiCFP 500 Internal Server and TimeOut Error Handling
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-07 05:52:42+00:00
 +
|closedAt=2021-08-07 06:53:26+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=12
 +
|title=Relevant FTX fields
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-04 12:18:12+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=11
 +
|title=Locality fixes
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-04 08:08:10+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=10
 +
|title=OpenResearch export option
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-04 07:51:24+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=9
 +
|title=offline access to EventCorpus.db
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-04 07:48:55+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=8
 +
|title=migrate confref data from Proceedings Title Parser here
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-04 07:17:09+00:00
 +
|closedAt=2021-08-04 07:17:13+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=7
 +
|title=migrate crossref data from proceedings title parser here
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-02 13:23:24+00:00
 +
|closedAt=2021-08-02 13:24:54+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=6
 +
|title=migrate dblp data source here from ptp and dblpconf
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-02 13:17:12+00:00
 +
|closedAt=2021-08-02 13:17:15+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=5
 +
|title=dblp xml parser skips some proceedings titles
 +
|project=ConferenceCorpus
 +
|createdAt=2021-08-01 04:16:18+00:00
 +
|closedAt=
 +
|state=open
 +
}}
 +
# {{Ticket
 +
|number=4
 +
|title=add commandline interface to CorpusLookup
 +
|project=ConferenceCorpus
 +
|createdAt=2021-07-31 18:51:20+00:00
 +
|closedAt=2021-08-01 04:06:46+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=3
 +
|title=add python api doc
 +
|project=ConferenceCorpus
 +
|createdAt=2021-07-31 06:04:06+00:00
 +
|closedAt=2021-07-31 06:50:18+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=2
 +
|title=Cache all SQL tables in the same SQLite database in a ".conferencecorpus" directory 
 +
|project=ConferenceCorpus
 +
|createdAt=2021-07-30 08:57:37+00:00
 +
|closedAt=2021-07-30 12:44:44+00:00
 +
|state=closed
 +
}}
 +
# {{Ticket
 +
|number=1
 +
|title=There should  be a common set of attributes for Event and EventSeries from different datasources
 +
|project=ConferenceCorpus
 +
|createdAt=2021-07-30 08:51:29+00:00
 +
|closedAt=
 +
|state=open
 +
}}

Revision as of 07:28, 20 November 2022

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  

Freitext

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=16400"