talk · Thursday 24 September · 09:40–⁠09:55 · SAL A

From Legacy Database to Cloud: Challenges in Migrating Legacy Collection Data to a FAIR Collection Management System

Marije Timmermans · From Cabinets to Clouds - Bridging the gap between collection- and database management

Recording time 1:57:00–2:13:36Open on Vimeo ↗

Summaries and key moments are machine-produced. Check the recording for the speaker’s exact words.

The short versionA dedicated data manager who acts as liaison and uses iterative prototypes can make a small institute's move to a shared CMS workable despite fragmented legacy practices.

Overview

What this was about

Marije Timmermans, the first data manager at SDEI (since February 2026), described preparing for migration to the DINA collection management system, which Senckenberg's central Data and Modelling Centre implements across eight institutes. SDEI's five entomology sub-collections use separate Corel Paradox database instances with diverging schemas, plus card catalogues and personal spreadsheets. Collection data is treated as a management tool rather than research infrastructure, and there is no formal data governance. She acts as liaison, runs one-on-one sessions and workshops, and proposes mappings. Her working method is design-thinking prototypes that domain specialists test.

Why it matters. It shows the organisational side of CMS migration: divergent schemas, missing governance and the value of empathy-led prototyping. Several audience members picked this up in the discussion.

Key ideas

In the room

  • Senckenberg has about 900 staff, eight research institutions and seven locations; SDMC implements DINA for all of them.
  • SDEI was founded in 1886 in Berlin, joined Senckenberg in 2009 and has about 35 people including volunteers.
  • Four of five sub-collections use Corel Paradox instances (from the 1990s) on individual computers; one manager keeps a card catalogue backup and another uses personal spreadsheets.
  • Schemas have diverged as managers added, moved and renamed fields; practices like putting subspecies in the species field hinder sharing.
  • There is no formal data governance or ownership, and decision power varies between technical assistants and scientific heads.
  • Her role: data life cycle documentation, legacy structure assessment, training, liaison with SDMC, and workflows for enrichment, mapping and migration.
  • Treating work as prototypes (design thinking) and letting specialists test them builds ownership.
Jump in

Notable moments

In their words

Transcript

Automatically generated captions can contain mistakes, especially in names and technical terms. Times are relative to the room recording.

Read the transcript ↓
Loading transcript…
Programme abstract

From Legacy Database to Cloud: Challenges in Migrating Legacy Collection Data to a FAIR Collection Management System

Marije Timmermans

Natural science collections play a vital role in scientific research, yet they often rely on outdated legacy databases that reflect years of curatorial practices. At Senckenberg German Entomological Institute, these collections are currently managed across Corel Paradox relational databases and additional spreadsheets, each with customized schemas and specific entomological terminology. However, only 22,470 of our estimated 3,800,000 specimens are accessible through the GBIF Global Registry of Scientific Collections. The lack of standardization, interoperability and accessibility restricts the potential of our valuable collection data for biodiversity research. We present a working example of our approach and processes to migrate heterogeneous data into the DINA Collection Management System. We identify three key challenges in this migration process. First, we must reconcile inconsistent database schemas and curatorial terms with DINA's data model, which is closely aligned with the Darwin Core standard. Second, we must tackle data quality issues that arise from maintaining a legacy curation tool, for example, outdated taxonomic names and discrepancies with public taxonomic backbones, such as the Catalog of Life. Finally, we must coordinate efforts across different institutes within Senckenberg, each with unique schemas, curation workflows and institutional cultures. By completing the migration to DINA, we anticipate achieving FAIR-compliant, identifier-based collection data that enhances accessibility and usability through GBIF and for researchers worldwide. We aim to demonstrate how data managers can bridge collection management expertise and new digital infrastructure to implement data migration projects that meet FAIR standards.

Submitted to the conference programme before the talk, so the talk itself may differ.