Skip to main content

Curating Covid-19 Data in Links

  • 315 Accesses

Part of the Lecture Notes in Computer Science book series (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, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-3-030-80960-7_19
  • Chapter length: 7 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   54.99
Price excludes VAT (USA)
  • ISBN: 978-3-030-80960-7
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   69.99
Price excludes VAT (USA)
Fig. 1.
Fig. 2.
Fig. 3.

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

    CrossRef  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

    CrossRef  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

    CrossRef  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

    CrossRef  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

Authors

Corresponding author

Correspondence to Vashti Galpin .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2021 Springer Nature Switzerland AG

About this paper

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)