Skip to main content
SpringerLink
Log in

Tool Support for Migration from a Relational to an Object-Oriented Database

  • Conference paper
OOIS’ 95

  • 52 Accesses

Abstract

The work described in this paper represents some early results from a long term project to provide support for the migration of data and meta-data from a relational to an Object-Oriented database. The initial tool processes the schema of a relational database and presents it to the user as the equivalent object-oriented schema. The results of this processing is an initial version of the object schema and requires user intervention in the naming of new abstract classes built by the system.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Benford and J. A. Maraini. Virtual Environments for Sharing and Visualisation — Populated Information Terrains. proc. of 2nd Internationalconf. on User Interfaces to Databases. Ambleside, UK. Ed. P. Sawyer. 1994.

    Google Scholar 

  2. J. Boyle, J. Fothergill and P. Gray. Amaze: A 3-D Graphical User Interface for an Object-Oriented Database. proc. of 2nd Internationalconf. on User Interfaces to Databases. Ambleside, UK. Ed. P. Sawyer. 1994.

    Google Scholar 

  3. P. P. Chen. The Entity-Relationship Model — Towards a Unified View of Data. ACM Trans. Database Sys. 1(1). pp 9–36. 1976.

    Article  Google Scholar 

  4. R. H. L. Chiang, T. M. Barron and V. C. Storey. Reverse engineering of relational databases: Extraction of an EER model from a relational database. Data & Knowledge Engineering. 12 (pp 107–142. 1994.

    Article  Google Scholar 

  5. K. H. Davies and A. K. Arora. Converting a relational database model into an Entity-Relationship model. in Entity-Relationship Approach. Ed. S. T. March. Elsevier. pp 271–285. 1988.

    Google Scholar 

  6. J. Duhl and C. Damon. A Performance Comparison of Object and Relational Databases Using the Sun Benchmark. proc. of OOPSLA’88. Ed. 153–163. 1988.

    Google Scholar 

  7. E. M. Elgalal. Minimally-Redundant Data Structures and Reasonable Hypotheses: Some General Heuristic Methods of Knowledge Processing. PhD. Thesis. University of Strathclyde, Glasgow, UK. 1985.

    Google Scholar 

  8. R. Elmasri and S. B. Navathe. Fundamentals of Database Systems. Benjamin/Cummings. 1989.

    Google Scholar 

  9. D. Fishman, D. Beech and H. Cate. Iris: An Object-oriented Database Management System. ACM Trans. on Office Information Systems. 5(1). pp 48–69. 1987.

    Google Scholar 

  10. W. A. Gray, G. N. Wikramanayake and N. J. Fiddian. Assisting Legacy Database Migration. proc. of Legacy Information Systems — Barriers to Business Process Re-Engineering. Ed. 1994.

    Google Scholar 

  11. Y. W. Huang and L. T. Fan. Designing an Object-Relation Hybrid Database for Chemical Process Engineering. Comput Chem Engng. 12(9/10). pp 973–983. 1988.

    Article  Google Scholar 

  12. S. R. Monk. Schema Evolution in Object-Oriented Databases Using Class Versioning. SIGMOD Record. 22(3). pp 16–22. 1993.

    Article  Google Scholar 

  13. S. R. Monk and I. Sommerville. A Model for Versioning of Classes in Object-Oriented Databases. proc. of BNCOD 10. Aberdeen. Ed. P. M. D. Gray and R. J. Lucas. 42–58. 1992.

    Google Scholar 

  14. A. Ramfos, N. J. Fiddian and W. A. Gray. A Meta-translation System for Object-Oriented to Relational Schema Translations. proc. of BNCOD 91. Wolverhampton, UK. Ed. M. S. Jackson and A. E. Robinson. 245–268. 1991.

    Google Scholar 

  15. M. H. Rapley and J. B. Kennedy. Three Dimensional Interface for an Object-Oriented Database. proc. of 2nd International conf. on User Interfaces to Databases. Ambleside, UK. Ed. P. Sawyer. 1994.

    Google Scholar 

  16. G. G. Robertson, S. K. Card and J. D. Mackinlay. Cone Trees: Animated 3D Visualisation of Hierarchical Information. proc. of ACM CHI’91. Ed. 184–194. 1991.

    Google Scholar 

  17. A. P. Sheth. Semantic Issues in Multidatabase Systems. SIGMOD Record. 20(4). pp 5–9. 1991.

    Google Scholar 

  18. S. D. Urban and J. Wu. Resolving Semantic Heterogeneity Through the Explicit Representation of Data Model Semantics. SIGMOD Record. 20(4). pp 55–58. 1991.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Computing Department, University of Central Lancashire, Preston, PR1 2TQ, UK

    Simon Monk & Helen Campbell

  2. Computing Department, Lancaster University, Lancaster, LA1 4YR, UK

    John Mariani & Beshir Elgalal

Authors
  1. Simon Monk
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Helen Campbell
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. John Mariani
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Beshir Elgalal
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. School of Computer Applications Faculty of Computing and Mathematical Sciences, Dublin City University, Glasnevin, Dublin 9, Ireland

    John Murphy  & Brian Stone  & 

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag London Limited

About this paper

Cite this paper

Monk, S., Campbell, H., Mariani, J., Elgalal, B. (1996). Tool Support for Migration from a Relational to an Object-Oriented Database. In: Murphy, J., Stone, B. (eds) OOIS’ 95. Springer, London. https://doi.org/10.1007/978-1-4471-1009-5_23

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-1009-5_23

  • Publisher Name: Springer, London

  • Print ISBN: 978-3-540-76010-8

  • Online ISBN: 978-1-4471-1009-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation