Migrating Relational Data to an ODBMS: Strategies and Lessons from a Molecular Biology Experience
Abstract
The growing maturity of ODBMS technology is causing many enterprises to consider migrating relational databases to ODBIMS's. While data remapping is relatively straight-forward in most cases, greater challenges lie in economically and non-invasively adapting legacy application software. We report on a genetics laboratory database migration experiment, which was facilitated by both organization of the relational data in object-like form and a C++-framework designed to insulate application code from relational artifacts. Although this experiment was largely successful, we discovered to our surprise that the framework failed to encapsulate three subtle aspects of the relational implementation, thereby ''contaminating'' application code. We analyze the underlying issues, and offer cautionary guidance to future migrators.
- Authors:
- Publication Date:
- Research Org.:
- Lawrence Livermore National Lab. (LLNL), Livermore, CA (United States)
- Sponsoring Org.:
- USDOE Office of Defense Programs (DP) (US)
- OSTI Identifier:
- 793852
- Report Number(s):
- UCRL-JC-136674
TRN: US200221%%222
- DOE Contract Number:
- W-7405-Eng-48
- Resource Type:
- Conference
- Resource Relation:
- Conference: OOPSLA, Conference location not supplied, Conference dates not supplied; Other Information: PBD: 1 Dec 1999
- Country of Publication:
- United States
- Language:
- English
- Subject:
- 59 BASIC BIOLOGICAL SCIENCES; 99 GENERAL AND MISCELLANEOUS//MATHEMATICS, COMPUTING, AND INFORMATION SCIENCE; GENETICS; IMPLEMENTATION; MOLECULAR BIOLOGY
Citation Formats
Oler, J, Lindstrom, G, and Critchlow, T. Migrating Relational Data to an ODBMS: Strategies and Lessons from a Molecular Biology Experience. United States: N. p., 1999.
Web. doi:10.1145/263698.263741.
Oler, J, Lindstrom, G, & Critchlow, T. Migrating Relational Data to an ODBMS: Strategies and Lessons from a Molecular Biology Experience. United States. https://doi.org/10.1145/263698.263741
Oler, J, Lindstrom, G, and Critchlow, T. 1999.
"Migrating Relational Data to an ODBMS: Strategies and Lessons from a Molecular Biology Experience". United States. https://doi.org/10.1145/263698.263741. https://www.osti.gov/servlets/purl/793852.
@article{osti_793852,
title = {Migrating Relational Data to an ODBMS: Strategies and Lessons from a Molecular Biology Experience},
author = {Oler, J and Lindstrom, G and Critchlow, T},
abstractNote = {The growing maturity of ODBMS technology is causing many enterprises to consider migrating relational databases to ODBIMS's. While data remapping is relatively straight-forward in most cases, greater challenges lie in economically and non-invasively adapting legacy application software. We report on a genetics laboratory database migration experiment, which was facilitated by both organization of the relational data in object-like form and a C++-framework designed to insulate application code from relational artifacts. Although this experiment was largely successful, we discovered to our surprise that the framework failed to encapsulate three subtle aspects of the relational implementation, thereby ''contaminating'' application code. We analyze the underlying issues, and offer cautionary guidance to future migrators.},
doi = {10.1145/263698.263741},
url = {https://www.osti.gov/biblio/793852},
journal = {},
number = ,
volume = ,
place = {United States},
year = {Wed Dec 01 00:00:00 EST 1999},
month = {Wed Dec 01 00:00:00 EST 1999}
}