Supporting the long-term curation and migration of natural history museum collections databases

Andrea K. Thomer, Nicholas M. Weber, Michael Bernard Twidale

Research output: Contribution to journalArticle

Abstract

Migration of data collections from one platform to another is an important component of data curation – yet, there is surprisingly little guidance for information professionals faced with this task. Data migration may be particularly challenging when these data collections are housed in relational databases, due to the complex ways that data, data schemas, and relational database management software become intertwined over time. Here we present results from a study of the maintenance, evolution and migration of research databases housed in Natural History Museums. We find that database migration is an on-going – rather than occasional – process for many Collection managers, and that they creatively appropriate and innovate on many existing technologies in their migration work. This paper contributes descriptions of a preliminary set of common adaptations and “migration patterns” in the practices of database curators. It also outlines the strategies they use when facing collection-level data migration and describes the limitations of existing tools in supporting LAM and “small science” research database migration. We conclude by outlining future research directions for the maintenance and migration of collections and complex digital objects.

Original languageEnglish (US)
Pages (from-to)504-513
Number of pages10
JournalProceedings of the Association for Information Science and Technology
Volume55
Issue number1
DOIs
StatePublished - Jan 1 2018

Fingerprint

Museums
museum
migration
history
migration research
Managers
manager
science
management

Keywords

  • Data curation
  • database migration
  • museum informatics
  • natural history museums

ASJC Scopus subject areas

  • Computer Science(all)
  • Library and Information Sciences

Cite this

Supporting the long-term curation and migration of natural history museum collections databases. / Thomer, Andrea K.; Weber, Nicholas M.; Twidale, Michael Bernard.

In: Proceedings of the Association for Information Science and Technology, Vol. 55, No. 1, 01.01.2018, p. 504-513.

Research output: Contribution to journalArticle

@article{b52944cabe3345dbab3dd2753234f481,
title = "Supporting the long-term curation and migration of natural history museum collections databases",
abstract = "Migration of data collections from one platform to another is an important component of data curation – yet, there is surprisingly little guidance for information professionals faced with this task. Data migration may be particularly challenging when these data collections are housed in relational databases, due to the complex ways that data, data schemas, and relational database management software become intertwined over time. Here we present results from a study of the maintenance, evolution and migration of research databases housed in Natural History Museums. We find that database migration is an on-going – rather than occasional – process for many Collection managers, and that they creatively appropriate and innovate on many existing technologies in their migration work. This paper contributes descriptions of a preliminary set of common adaptations and “migration patterns” in the practices of database curators. It also outlines the strategies they use when facing collection-level data migration and describes the limitations of existing tools in supporting LAM and “small science” research database migration. We conclude by outlining future research directions for the maintenance and migration of collections and complex digital objects.",
keywords = "Data curation, database migration, museum informatics, natural history museums",
author = "Thomer, {Andrea K.} and Weber, {Nicholas M.} and Twidale, {Michael Bernard}",
year = "2018",
month = "1",
day = "1",
doi = "10.1002/pra2.2018.14505501055",
language = "English (US)",
volume = "55",
pages = "504--513",
journal = "Proceedings of the Association for Information Science and Technology",
issn = "2373-9231",
publisher = "John Wiley and Sons Inc.",
number = "1",

}

TY - JOUR

T1 - Supporting the long-term curation and migration of natural history museum collections databases

AU - Thomer, Andrea K.

AU - Weber, Nicholas M.

AU - Twidale, Michael Bernard

PY - 2018/1/1

Y1 - 2018/1/1

N2 - Migration of data collections from one platform to another is an important component of data curation – yet, there is surprisingly little guidance for information professionals faced with this task. Data migration may be particularly challenging when these data collections are housed in relational databases, due to the complex ways that data, data schemas, and relational database management software become intertwined over time. Here we present results from a study of the maintenance, evolution and migration of research databases housed in Natural History Museums. We find that database migration is an on-going – rather than occasional – process for many Collection managers, and that they creatively appropriate and innovate on many existing technologies in their migration work. This paper contributes descriptions of a preliminary set of common adaptations and “migration patterns” in the practices of database curators. It also outlines the strategies they use when facing collection-level data migration and describes the limitations of existing tools in supporting LAM and “small science” research database migration. We conclude by outlining future research directions for the maintenance and migration of collections and complex digital objects.

AB - Migration of data collections from one platform to another is an important component of data curation – yet, there is surprisingly little guidance for information professionals faced with this task. Data migration may be particularly challenging when these data collections are housed in relational databases, due to the complex ways that data, data schemas, and relational database management software become intertwined over time. Here we present results from a study of the maintenance, evolution and migration of research databases housed in Natural History Museums. We find that database migration is an on-going – rather than occasional – process for many Collection managers, and that they creatively appropriate and innovate on many existing technologies in their migration work. This paper contributes descriptions of a preliminary set of common adaptations and “migration patterns” in the practices of database curators. It also outlines the strategies they use when facing collection-level data migration and describes the limitations of existing tools in supporting LAM and “small science” research database migration. We conclude by outlining future research directions for the maintenance and migration of collections and complex digital objects.

KW - Data curation

KW - database migration

KW - museum informatics

KW - natural history museums

UR - http://www.scopus.com/inward/record.url?scp=85064486496&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85064486496&partnerID=8YFLogxK

U2 - 10.1002/pra2.2018.14505501055

DO - 10.1002/pra2.2018.14505501055

M3 - Article

AN - SCOPUS:85064486496

VL - 55

SP - 504

EP - 513

JO - Proceedings of the Association for Information Science and Technology

JF - Proceedings of the Association for Information Science and Technology

SN - 2373-9231

IS - 1

ER -