{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,25]],"date-time":"2026-02-25T22:41:47Z","timestamp":1772059307397,"version":"3.50.1"},"reference-count":42,"publisher":"Wiley","issue":"1","license":[{"start":{"date-parts":[[2019,2,1]],"date-time":"2019-02-01T00:00:00Z","timestamp":1548979200000},"content-version":"vor","delay-in-days":396,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#vor"}],"content-domain":{"domain":["asistdl.onlinelibrary.wiley.com"],"crossmark-restriction":true},"short-container-title":["Proc. Assoc. Info. Sci. Tech."],"published-print":{"date-parts":[[2018,1]]},"abstract":"<jats:title>ABSTRACT<\/jats:title>\n                  <jats:p>Migration of data collections from one platform to another is an important component of data curation \u2013 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\u2010going \u2013 rather than occasional \u2013 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 \u201cmigration patterns\u201d in the practices of database curators. It also outlines the strategies they use when facing collection\u2010level data migration and describes the limitations of existing tools in supporting LAM and \u201csmall science\u201d research database migration. We conclude by outlining future research directions for the maintenance and migration of collections and complex digital objects.<\/jats:p>","DOI":"10.1002\/pra2.2018.14505501055","type":"journal-article","created":{"date-parts":[[2019,2,1]],"date-time":"2019-02-01T16:52:19Z","timestamp":1549039939000},"page":"504-513","update-policy":"https:\/\/doi.org\/10.1002\/crossmark_policy","source":"Crossref","is-referenced-by-count":11,"title":["Supporting the long\u2010term curation and migration of natural history museum collections databases"],"prefix":"10.1002","volume":"55","author":[{"given":"Andrea K.","family":"Thomer","sequence":"first","affiliation":[{"name":"School of Information University of Michigan USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Nicholas M.","family":"Weber","sequence":"additional","affiliation":[{"name":"Information School University of Washington USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael B.","family":"Twidale","sequence":"additional","affiliation":[{"name":"School of Information Sciences University of Illinois at Urbana\u2010Champaign USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"311","published-online":{"date-parts":[[2019,2]]},"reference":[{"key":"e_1_2_8_2_1","doi-asserted-by":"publisher","DOI":"10.17161\/bi.v7i2.3991"},{"key":"e_1_2_8_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/2503792.2503808"},{"key":"e_1_2_8_4_1","first-page":"7","article-title":"Mass digitization of scientific collections","volume":"209","author":"Beaman R.","year":"2012","journal-title":"New opportunities to transform the use of biological specimens and underwrite biodiversity science. ZooKeys"},{"key":"e_1_2_8_5_1","volume-title":"Migrating legacy systems: gateways, interfaces & the incremental approach","author":"Brodie M. L.","year":"1995"},{"key":"e_1_2_8_6_1","doi-asserted-by":"crossref","unstructured":"Buneman P. Chapman A. &Cheney J.(2006).Provenance management in curated databases (p. 539). ACM Press.https:\/\/doi.org\/10.1145\/1142473.1142534","DOI":"10.1145\/1142473.1142534"},{"key":"e_1_2_8_7_1","doi-asserted-by":"crossref","unstructured":"Buneman P. Cheney J. Tan W.\u2010C. &Vansummeren S.(2008).Curated Databases. In Proceedings of the Twenty\u2010seventh ACM SIGMOD\u2010SIGACT\u2010SIGART Symposium on Principles of Database Systems (pp.1\u201312). New York NY USA: ACM.https:\/\/doi.org\/10.1145\/1376916.1376918","DOI":"10.1145\/1376916.1376918"},{"key":"e_1_2_8_8_1","doi-asserted-by":"publisher","DOI":"10.2218\/ijdc.v4i3.126"},{"key":"e_1_2_8_9_1","unstructured":"Chan S.(2014 November 7).The API at the center of the museum. Retrieved June 8 2018 fromhttps:\/\/labs.cooperhewitt.org\/2014\/the-api-at-the-center-of-the-museum\/"},{"key":"e_1_2_8_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/362384.362685"},{"key":"e_1_2_8_11_1","doi-asserted-by":"crossref","unstructured":"Codd E. F.(1971).Normalized data base structure: a brief tutorial (p. 1). ACM Press.https:\/\/doi.org\/10.1145\/1734714.1734716","DOI":"10.1145\/1734714.1734716"},{"key":"e_1_2_8_12_1","doi-asserted-by":"publisher","DOI":"10.1098\/rsta.2010.0165"},{"key":"e_1_2_8_13_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1008709725729"},{"key":"e_1_2_8_14_1","unstructured":"DPLA API Codex. (n.d.). Retrieved June 8 2018 fromhttps:\/\/pro.dp.la\/developers\/api-codex"},{"key":"e_1_2_8_15_1","first-page":"vii","volume-title":"Appropriating technology: vernacular science and social power","author":"Eglash R.","year":"2004"},{"key":"e_1_2_8_16_1","doi-asserted-by":"crossref","unstructured":"Henry S. Hoon S. Hwang M. Lee D. &DeVore M. D.(2005).Engineering trade study: extract transform load tools for data migration. In 2005 IEEE Design Symposium Systems and Information Engineering (pp.1\u20138).https:\/\/doi.org\/10.1109\/SIEDS.2005.193231","DOI":"10.1109\/SIEDS.2005.193231"},{"key":"e_1_2_8_17_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10796-016-9730-2"},{"key":"e_1_2_8_18_1","doi-asserted-by":"publisher","DOI":"10.1177\/0306312706054047"},{"key":"e_1_2_8_19_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF02985207"},{"key":"e_1_2_8_20_1","unstructured":"Importing External Data into Specify 6. (2013 August 17).Specify Software Proejct. Retrieved fromhttp:\/\/www.sustain.specifysoftware.org\/wp-content\/uploads\/2017\/03\/Importing-External-Data-into-Specify-6.pdf"},{"key":"e_1_2_8_21_1","doi-asserted-by":"crossref","unstructured":"Jagadish H. V. Chapman A. Elkiss A. Jayapandian M. Li Y. Nandi A. &Yu C.(2007).Making database systems usable (p. 13). ACM Press.https:\/\/doi.org\/10.1145\/1247480.1247483","DOI":"10.1145\/1247480.1247483"},{"key":"e_1_2_8_22_1","doi-asserted-by":"publisher","DOI":"10.1016\/0306-4573(90)90071-9"},{"key":"e_1_2_8_23_1","doi-asserted-by":"publisher","DOI":"10.1080\/10919399609540276"},{"key":"e_1_2_8_24_1","doi-asserted-by":"crossref","unstructured":"Mello J. F.(1975).The Use of the Selgem System in Support of Systematics. In Computers in Botanical Collections (pp.125\u2013138). Springer Boston MA.https:\/\/doi.org\/10.1007\/978-1-4684-2157-6_17","DOI":"10.1007\/978-1-4684-2157-6_17"},{"key":"e_1_2_8_25_1","unstructured":"migration. (n.d.).Glossary of Archival and Records Terminology. Society of American Archivists. Retrieved fromhttps:\/\/www2.archivists.org\/glossary\/terms\/m\/migration"},{"key":"e_1_2_8_26_1","volume-title":"Scientific collections: mission\u2010critical infrastructure for federal science agencies: a report of the Interagency Working Group on Scientific Collections","author":"National Science and Technology Council, & Scientific collections: mission\u2010critical infrastructure for federal science agencies: a report of the Interagency Working Group on Scientific Collections","year":"2009"},{"key":"e_1_2_8_27_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-0-12-374720-4.00001-7"},{"issue":"6","key":"e_1_2_8_28_1","article-title":"Collections as data","volume":"79","author":"Padilla T. G.","year":"2018","journal-title":"Implications for enclosure. College & Research Libraries News"},{"key":"e_1_2_8_29_1","doi-asserted-by":"crossref","unstructured":"Palmer C. L. Zavalina O. L. &Fenlon K.(2010).Beyond size and search: Building contextual mass in digital aggregations for scholarly use. Proceedings of the American Society for Information Science and Technology 47(1) 1\u201310.https:\/\/doi.org\/10.1002\/meet.14504701213","DOI":"10.1002\/meet.14504701213"},{"key":"e_1_2_8_30_1","doi-asserted-by":"crossref","unstructured":"Plantin J.\u2010C. Lagoze C. Edwards P. N. &Sandvig C.(2016).Infrastructure studies meet platform studies in the age of Google and Facebook. New Media & Society 1461444816661553.https:\/\/doi.org\/10.1177\/1461444816661553","DOI":"10.1177\/1461444816661553"},{"key":"e_1_2_8_31_1","doi-asserted-by":"publisher","DOI":"10.1371\/journal.pone.0102623"},{"key":"e_1_2_8_32_1","unstructured":"Sarasan L. Neuner A. M. &Association of Systematics Collections(Eds.). (1983).Museum collections and computers: report of an ASC survey. Lawrence Kan. U.S.A: Association of Systematics Collections."},{"issue":"0","key":"e_1_2_8_33_1","article-title":"Mammals of the World","volume":"1","author":"Stein B. R.","year":"2004","journal-title":"MaNIS as an example of data integration in a distributed network environment. Biodiversity Informatics"},{"key":"e_1_2_8_34_1","unstructured":"Tate. (2018).collection: Tate Collection metadata. Python Tate Modern. Retrieved fromhttps:\/\/github.com\/tategallery\/collection(Original work published 2013)"},{"key":"e_1_2_8_35_1","unstructured":"Thibodeau K.(2002).Overview of Technological Approaches to Digital Preservation and Challenges in Coming Years (The State of Digital preservation: An International Perspective). Washington D.C.: CLIR and the Library of Congress. Retrieved fromhttps:\/\/www.clir.org\/pubs\/reports\/pub107\/thibodeau\/"},{"key":"e_1_2_8_36_1","doi-asserted-by":"publisher","DOI":"10.1016\/0306-4379(78)90001-7"},{"key":"e_1_2_8_37_1","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2009070101"},{"key":"e_1_2_8_38_1","doi-asserted-by":"publisher","DOI":"10.5670\/oceanog.2000.02"},{"key":"e_1_2_8_39_1","doi-asserted-by":"crossref","unstructured":"Voida A. Harmon E. &Al\u2010Ani B.(2011).Homebrew databases: complexities of everyday information management in nonprofit organizations (p. 915). ACM Press.https:\/\/doi.org\/10.1145\/1978942.1979078","DOI":"10.1145\/1978942.1979078"},{"key":"e_1_2_8_40_1","unstructured":"Wickett K. M.(in press). A logic\u2010based framework for collection\/item metadata relationships.Journal of Documentation."},{"key":"e_1_2_8_41_1","doi-asserted-by":"crossref","unstructured":"Wickett K. M. Renear A. H. &Urban R. J.(2010).Rule categories for collection\/item metadata relationships. Proceedings of the American Society for Information Science and Technology 47(1) 1\u201310.https:\/\/doi.org\/10.1002\/meet.14504701218","DOI":"10.1002\/meet.14504701218"},{"key":"e_1_2_8_42_1","volume-title":"Case study research: Design and methods","author":"Yin R. K.","year":"2009"},{"key":"e_1_2_8_43_1","doi-asserted-by":"publisher","DOI":"10.1080\/19386380802627109"}],"container-title":["Proceedings of the Association for Information Science and Technology"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.wiley.com\/onlinelibrary\/tdm\/v1\/articles\/10.1002%2Fpra2.2018.14505501055","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1002\/pra2.2018.14505501055","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/full-xml\/10.1002\/pra2.2018.14505501055","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/asistdl.onlinelibrary.wiley.com\/doi\/pdf\/10.1002\/pra2.2018.14505501055","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,21]],"date-time":"2025-10-21T17:40:52Z","timestamp":1761068452000},"score":1,"resource":{"primary":{"URL":"https:\/\/asistdl.onlinelibrary.wiley.com\/doi\/10.1002\/pra2.2018.14505501055"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018,1]]},"references-count":42,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2018,1]]}},"alternative-id":["10.1002\/pra2.2018.14505501055"],"URL":"https:\/\/doi.org\/10.1002\/pra2.2018.14505501055","archive":["Portico"],"relation":{},"ISSN":["2373-9231","2373-9231"],"issn-type":[{"value":"2373-9231","type":"print"},{"value":"2373-9231","type":"electronic"}],"subject":[],"published":{"date-parts":[[2018,1]]},"assertion":[{"value":"2019-02-01","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}