Migrating relational data to an ODBMS: strategics and lessons from a molecular biology experience

  • Authors:
  • Jon Oler;Gary Lindstrom;Terence Critchlow

  • Affiliations:
  • Department of Computer Science, University of Utah, 50 S. Central Campus Drive, Rm. 3190, Salt Lake City, Utah;Department of Computer Science, University of Utah, 50 S. Central Campus Drive, Rm. 3190, Salt Lake City, Utah;Department of Computer Science, University of Utah, 50 S. Central Campus Drive, Rm. 3190, Salt Lake City, Utah

  • Venue:
  • Proceedings of the 12th ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications
  • Year:
  • 1997

Quantified Score

Hi-index 0.00

Visualization

Abstract

The growing maturity of ODBMS technology is causing many enterprises to consider migrating relational databases to ODBMS's. While data remapping is relatively straightforward 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.