Abstract

In natural history museums, knowledge organization systems have gradually been migrated from paper-based catalog ledgers to electronic databases; these databases in turn must be migrated from one platform or software version to another. These migrations are by no means straightforward, particularly when one data schema must be mapped to another-or, when a database has been used in other-than-its-intended manner. There are few tools or methods available to support the necessary work of comparing divergent data schemas. Here we present a proof-of-concept in which we compare two versions of a subset of the Specify 6 data model using Euler/X, a logic-based reasoning tool. Specify 6 is a popular natural history museum database system whose data model has undergone several changes over its lifespan. We use Euler/X to produce visualizations (called "possible worlds") of the different ways that two versions of this data model might be mapped to one another. This proof-of-concept lays groundwork for further approaches that could aid data curators in database migration and maintenance work. It also contributes to research on the unique challenges to knowledge organization within natural history museums, and on the applicability of logic-based approaches to database schema migration or crosswalking.

Original languageEnglish (US)
Pages (from-to)545-558
Number of pages14
JournalKnowledge Organization
Volume44
Issue number7
StatePublished - Jan 1 2017

Fingerprint

logic
museum
history
migration
organization
life-span
knowledge
visualization
electronics

Keywords

  • Database migration
  • Database schema
  • Euler/X
  • Possible worlds

ASJC Scopus subject areas

  • Library and Information Sciences

Cite this

Logic-based schema alignment for natural history museum databases. / Thomer, Andrea; Cheng, Yi Yun; Schneider, Jodi A; Twidale, Michael Bernard; Ludaescher, Bertram.

In: Knowledge Organization, Vol. 44, No. 7, 01.01.2017, p. 545-558.

Research output: Contribution to journalArticle

@article{624b79cbbe2749fea24afe07084a38fd,
title = "Logic-based schema alignment for natural history museum databases",
abstract = "In natural history museums, knowledge organization systems have gradually been migrated from paper-based catalog ledgers to electronic databases; these databases in turn must be migrated from one platform or software version to another. These migrations are by no means straightforward, particularly when one data schema must be mapped to another-or, when a database has been used in other-than-its-intended manner. There are few tools or methods available to support the necessary work of comparing divergent data schemas. Here we present a proof-of-concept in which we compare two versions of a subset of the Specify 6 data model using Euler/X, a logic-based reasoning tool. Specify 6 is a popular natural history museum database system whose data model has undergone several changes over its lifespan. We use Euler/X to produce visualizations (called {"}possible worlds{"}) of the different ways that two versions of this data model might be mapped to one another. This proof-of-concept lays groundwork for further approaches that could aid data curators in database migration and maintenance work. It also contributes to research on the unique challenges to knowledge organization within natural history museums, and on the applicability of logic-based approaches to database schema migration or crosswalking.",
keywords = "Database migration, Database schema, Euler/X, Possible worlds",
author = "Andrea Thomer and Cheng, {Yi Yun} and Schneider, {Jodi A} and Twidale, {Michael Bernard} and Bertram Ludaescher",
year = "2017",
month = "1",
day = "1",
language = "English (US)",
volume = "44",
pages = "545--558",
journal = "Knowledge Organization",
issn = "0943-7444",
publisher = "International Society for Knowledge Organization",
number = "7",

}

TY - JOUR

T1 - Logic-based schema alignment for natural history museum databases

AU - Thomer, Andrea

AU - Cheng, Yi Yun

AU - Schneider, Jodi A

AU - Twidale, Michael Bernard

AU - Ludaescher, Bertram

PY - 2017/1/1

Y1 - 2017/1/1

N2 - In natural history museums, knowledge organization systems have gradually been migrated from paper-based catalog ledgers to electronic databases; these databases in turn must be migrated from one platform or software version to another. These migrations are by no means straightforward, particularly when one data schema must be mapped to another-or, when a database has been used in other-than-its-intended manner. There are few tools or methods available to support the necessary work of comparing divergent data schemas. Here we present a proof-of-concept in which we compare two versions of a subset of the Specify 6 data model using Euler/X, a logic-based reasoning tool. Specify 6 is a popular natural history museum database system whose data model has undergone several changes over its lifespan. We use Euler/X to produce visualizations (called "possible worlds") of the different ways that two versions of this data model might be mapped to one another. This proof-of-concept lays groundwork for further approaches that could aid data curators in database migration and maintenance work. It also contributes to research on the unique challenges to knowledge organization within natural history museums, and on the applicability of logic-based approaches to database schema migration or crosswalking.

AB - In natural history museums, knowledge organization systems have gradually been migrated from paper-based catalog ledgers to electronic databases; these databases in turn must be migrated from one platform or software version to another. These migrations are by no means straightforward, particularly when one data schema must be mapped to another-or, when a database has been used in other-than-its-intended manner. There are few tools or methods available to support the necessary work of comparing divergent data schemas. Here we present a proof-of-concept in which we compare two versions of a subset of the Specify 6 data model using Euler/X, a logic-based reasoning tool. Specify 6 is a popular natural history museum database system whose data model has undergone several changes over its lifespan. We use Euler/X to produce visualizations (called "possible worlds") of the different ways that two versions of this data model might be mapped to one another. This proof-of-concept lays groundwork for further approaches that could aid data curators in database migration and maintenance work. It also contributes to research on the unique challenges to knowledge organization within natural history museums, and on the applicability of logic-based approaches to database schema migration or crosswalking.

KW - Database migration

KW - Database schema

KW - Euler/X

KW - Possible worlds

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

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

M3 - Article

AN - SCOPUS:85044716446

VL - 44

SP - 545

EP - 558

JO - Knowledge Organization

JF - Knowledge Organization

SN - 0943-7444

IS - 7

ER -