Skip to main content
SpringerLink
Log in

Curating Covid-19 Data in Links

  • Conference paper
  • First Online:
Book cover Provenance and Annotation of Data and Processes (IPAW 2020, IPAW 2021)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 12839))

Abstract

Curated scientific databases play an important role in the scientific endeavour and support is needed for the significant effort that goes into their creation and maintenance. This demonstration and case study illustrate how curation support has been developed in the Links cross-tier programming language, a functional, strongly typed language with language-integrated query and support for temporal databases. The chosen case study uses weekly released Covid-19 fatality figures from the Scottish government which exhibit updates to previously released data. This data allows the capture and query of update provenance in our prototype. This demonstration will highlight the potential for language-integrated support for curation to simplify and streamline prototyping of web-applications in support of scientific databases.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    https://links-lang.org/.

  2. 2.

    The dataset has the feature that it contains counts for categories that subsume other categories. We decided to capture all categories rather than just the minimal ones to support checking for inconsistencies.

References

  1. Armstrong, J., et al.: The IUPHAR/BPS guide to PHARMACOLOGY in 2020: extending immunopharmacology content and introducing the IUPHAR/MMV Guide to MALARIA PHARMACOLOGY. Nucleic Acids Res. 48, D1006–D1021 (2020)

    Google Scholar 

  2. Buneman, P., Cheney, J., Tan, W.-C., Vansummeren, S.: Curated databases. In: Proceedings of the Twenty-Seventh ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2008, pp. 1–12 (2008)

    Google Scholar 

  3. Cooper, E., Lindley, S., Wadler, P., Yallop, J.: Links: web programming without tiers. In: de Boer, F.S., Bonsangue, M.M., Graf, S., de Roever, W.-P. (eds.) FMCO 2006. LNCS, vol. 4709, pp. 266–296. Springer, Heidelberg (2007). https://doi.org/10.1007/978-3-540-74792-5_12

    Chapter  Google Scholar 

  4. Fowler, S., Harding, S., Sharman, J., Cheney, J.: Cross-tier web programming for curated databases: a case study. Int. J. Digital Curation 16 (2020)

    Google Scholar 

  5. Jensen, C., Snodgrass, R.: Temporal database. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems. Springer, Boston (2009). https://doi.org/10.1007/978-0-387-39940-9_395

    Chapter  Google Scholar 

  6. Kulkarni, K., Michels, J.: Temporal features in SQL: 2011. SIGMOD Rec. 41(3), 34–43 (2012)

    Google Scholar 

  7. MariaDB: What’s new in MariaDB Server 10.3 (2018). https://mariadb.com/resources/blog/whats-new-in-mariadb-server-10-3/. Accessed 23 Apr 2021

  8. National Records of Scotland: Deaths involving coronavirus (COVID-19) in Scotland: archive (2021). https://www.nrscotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/vital-events/general-publications/weekly-and-monthly-data-on-births-and-deaths/deaths-involving-coronavirus-covid-19-in-scotland/archive. Accessed 23 Apr 2021

  9. Ricciotti, W., Cheney, J.: Query lifting. In: ESOP 2021. LNCS, vol. 12648, pp. 579–606. Springer, Cham (2021). https://doi.org/10.1007/978-3-030-72019-3_21

    Chapter  Google Scholar 

  10. Snodgrass, R.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann Publishers Inc., Burlington (1999)

    Google Scholar 

  11. Torp, K.: Temporal strata. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems. Springer, Boston (2009). https://doi.org/10.1007/978-0-387-39940-9_409

    Chapter  Google Scholar 

Download references

Acknowledgements

This work was supported by ERC Consolidator Grant Skye (grant number 682315) and by an ISCF Metrology Fellowship grant provided by the UK government’s Department for Business, Energy and Industrial Strategy (BEIS). We thank Simon Fowler for his assistance in using the temporal extensions to Links.

Author information

Authors and Affiliations

  1. University of Edinburgh, Edinburgh, UK

    Vashti Galpin & James Cheney

  2. The Alan Turing Institute, London, UK

    James Cheney

Authors
  1. Vashti Galpin
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. James Cheney
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Vashti Galpin .

Editor information

Editors and Affiliations

  1. Illinois Institute of Technology, Chicago, IL, USA

    Boris Glavic

  2. Fluminense Federal University, Niterói, Brazil

    Vanessa Braganholo

  3. Northern Illinois University, DeKalb, IL, USA

    David Koop

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Galpin, V., Cheney, J. (2021). Curating Covid-19 Data in Links. In: Glavic, B., Braganholo, V., Koop, D. (eds) Provenance and Annotation of Data and Processes. IPAW IPAW 2020 2021. Lecture Notes in Computer Science(), vol 12839. Springer, Cham. https://doi.org/10.1007/978-3-030-80960-7_19

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-80960-7_19

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-80959-1

  • Online ISBN: 978-3-030-80960-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation