A tool for curating and searching databases proving traceable analysis of data and workflows

Authors

  • Frederic Brochu-Williams NPL
  • Michael Chrubasik
  • Spencer A. Thomas

DOI:

https://doi.org/10.21014/actaimeko.v12i1.1408

Keywords:

searchable metadata; reproducibility; data curation; data traceability; FAIR

Abstract

We present a framework for easy annotating, archiving, retrieving, and searching measurement data from a large-scale data archival system. Our tool extends and simplifies the interaction with the database and is implemented in popular scientific applications used for data analysis, namely MATLAB, and Python. This allows scientists to execute complex interactions with the database for data curation and retrieval tasks in a few simple lines of accessible templated code. Scientists can now ensure their measurement data is well curated and FAIR (findable, accessible, interoperable, and reusable) compliant without requiring specific data skills or knowledge. Our tools allow users to perform SQL-type (Structured Query Language) queries on the data from simple templated scripts allowing data retrieval from long-term storage systems.

Downloads

Published

2023-03-22

Issue

Vol. 12 No. 1 (2023)

Section

Research Papers

License

Copyright (c) 2023 Frederic Brochu-Williams, Michael Chrubasik, Spencer A. Thomas

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under the CC BY 4.0, Creative Commons Attribution 4.0 International License.

Users are free to

  • share, i.e. copy and redistribute the material in any medium or format for any purpose, even commercially;
  • adapt, i.e. remix, transform, and build upon the material for any purpose, even commercially.

At the same time, the user must give appropriate credit, provide a link to the license, and indicate if changes were made.
Additional information about the license can be found at: https://creativecommons.org/licenses/by/4.0/.

Authors are

  • able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  • permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).