DBRepo: a Semantic Digital Repository for Relational Databases

Data curation is a complex, multi-faceted task. While dedicated data stewards are starting to take care of these activities in close collaboration with researchers for many types of (usually file-based) data in many institutions, this is rarely yet the case for data held in relational databases. Be...

Full description

Bibliographic Details
Main Authors: Martin Weise, Moritz Staudinger, Cornelia Michlits, Eva Gergely, Kirill Stytsenko, Raman Ganguly, Andreas Rauber
Format: Article
Language:English
Published: University of Edinburgh 2022-09-01
Series:International Journal of Digital Curation
Online Access:http://www.ijdc.net/article/view/825
_version_ 1798035493622906880
author Martin Weise
Moritz Staudinger
Cornelia Michlits
Eva Gergely
Kirill Stytsenko
Raman Ganguly
Andreas Rauber
author_facet Martin Weise
Moritz Staudinger
Cornelia Michlits
Eva Gergely
Kirill Stytsenko
Raman Ganguly
Andreas Rauber
author_sort Martin Weise
collection DOAJ
description Data curation is a complex, multi-faceted task. While dedicated data stewards are starting to take care of these activities in close collaboration with researchers for many types of (usually file-based) data in many institutions, this is rarely yet the case for data held in relational databases. Beyond large-scale infrastructures hosting e.g. climate or genome data, researchers usually have to create, build and maintain their database, care about security patches, and feed data into it in order to use it in their research. Data curation, if at all, usually happens after a project is finished, when data may be exported for digital preservation into file repository systems. We present DBRepo, a semantic digital repository for relational databases in a private cloud setting designed to (1) host research data stored in relational databases right from the beginning of a research project, (2) provide separation of concerns, allowing the researchers to focus on the domain aspects of the data and their work while bringing in experts to handle classic data management tasks, (3) improve findability, accessibility and reusability by offering semantic mapping of metadata attributes, and (4) focus on reproducibility in dynamically evolving data by supporting versioning and precise identification/cite-ability for arbitrary subsets of data. 
first_indexed 2024-04-11T20:58:04Z
format Article
id doaj.art-24b930dcd35b4140b7fa1a7fe3ee77eb
institution Directory Open Access Journal
issn 1746-8256
language English
last_indexed 2024-04-11T20:58:04Z
publishDate 2022-09-01
publisher University of Edinburgh
record_format Article
series International Journal of Digital Curation
spelling doaj.art-24b930dcd35b4140b7fa1a7fe3ee77eb2022-12-22T04:03:35ZengUniversity of EdinburghInternational Journal of Digital Curation1746-82562022-09-0117110.2218/ijdc.v17i1.825DBRepo: a Semantic Digital Repository for Relational DatabasesMartin Weise0Moritz Staudinger1Cornelia Michlits2Eva Gergely3Kirill Stytsenko4Raman Ganguly5Andreas Rauber6TU WienTU WienTU WienUniversity of ViennaUniversity of ViennaUniversity of ViennaTU Wien Data curation is a complex, multi-faceted task. While dedicated data stewards are starting to take care of these activities in close collaboration with researchers for many types of (usually file-based) data in many institutions, this is rarely yet the case for data held in relational databases. Beyond large-scale infrastructures hosting e.g. climate or genome data, researchers usually have to create, build and maintain their database, care about security patches, and feed data into it in order to use it in their research. Data curation, if at all, usually happens after a project is finished, when data may be exported for digital preservation into file repository systems. We present DBRepo, a semantic digital repository for relational databases in a private cloud setting designed to (1) host research data stored in relational databases right from the beginning of a research project, (2) provide separation of concerns, allowing the researchers to focus on the domain aspects of the data and their work while bringing in experts to handle classic data management tasks, (3) improve findability, accessibility and reusability by offering semantic mapping of metadata attributes, and (4) focus on reproducibility in dynamically evolving data by supporting versioning and precise identification/cite-ability for arbitrary subsets of data.  http://www.ijdc.net/article/view/825
spellingShingle Martin Weise
Moritz Staudinger
Cornelia Michlits
Eva Gergely
Kirill Stytsenko
Raman Ganguly
Andreas Rauber
DBRepo: a Semantic Digital Repository for Relational Databases
International Journal of Digital Curation
title DBRepo: a Semantic Digital Repository for Relational Databases
title_full DBRepo: a Semantic Digital Repository for Relational Databases
title_fullStr DBRepo: a Semantic Digital Repository for Relational Databases
title_full_unstemmed DBRepo: a Semantic Digital Repository for Relational Databases
title_short DBRepo: a Semantic Digital Repository for Relational Databases
title_sort dbrepo a semantic digital repository for relational databases
url http://www.ijdc.net/article/view/825
work_keys_str_mv AT martinweise dbrepoasemanticdigitalrepositoryforrelationaldatabases
AT moritzstaudinger dbrepoasemanticdigitalrepositoryforrelationaldatabases
AT corneliamichlits dbrepoasemanticdigitalrepositoryforrelationaldatabases
AT evagergely dbrepoasemanticdigitalrepositoryforrelationaldatabases
AT kirillstytsenko dbrepoasemanticdigitalrepositoryforrelationaldatabases
AT ramanganguly dbrepoasemanticdigitalrepositoryforrelationaldatabases
AT andreasrauber dbrepoasemanticdigitalrepositoryforrelationaldatabases