Skip to main content
SpringerLink
Log in
Book cover

Advances in Databases and Information Systems pp 143–157Cite as

Transforming Conceptual ER Schema into Object-Oriented Databases

  • Conference paper

  • 65 Accesses

Part of the book series: Workshops in Computing ((WORKSHOPS COMP.))

Abstract

We present the primary results of a re-engineering project. The work deals with a transformation process taking as input a E-R schema and delivering an object-oriented schema. We study the application of our ERHCB algorithm [5]. Indeed, we analyze the transformations according to the type of the represented association in the source model. We use thus the object technology in a framework of vertical integration in order to preserve existing applications and to reuse project components. Our solution allows translation of an ER diagram (more specifically an Entity-Association diagram) into object-oriented schemas represented in our HCB model. We show that the generation code in the target 02 Data Base Management System can be easily automated.

This is a preview of subscription content, 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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abrial, J-R., Data SemanticsS. Data Base Management. North-Holland, Amsterdam 74, pp.1–59.

    Google Scholar 

  2. Alabiso B., Transformation of data flow analysis models to object-oriented design. Proc. of the OOPSLAU88 Conf., San Diego (Calif.), Sept. 1988, pp.335–353.

    Google Scholar 

  3. Ayache M., Flory A., CASsiopeE: A three dimensional model for object-oriented modeling. Proc. of the Indo-French Workshop on Object-Oriented Systems. GOA(India), November 2–6, 1992.

    Google Scholar 

  4. Ayache M., Flory A., Ou-halima M., An Object Oriented Method for Information Systems development, Proc. of the 2nd Software Engineering Research Forum, SERF-93. Orlando, Florida, Nov. 11–12, 1993, pp. 9–16.

    Google Scholar 

  5. Ayache M., Flory A., A Generation Process of Object-Oriented Databases from E/R Schemas. Proc. of the Intern. Conf. on Software Engineering and

    Google Scholar 

  6. Knowledge Engineeing, SEKE’95. IEEE Computer Society (ed.), June 21–24, 1995, pp.147–150.

    Google Scholar 

  7. Booch G., Object-Oriented Design with Applications. Benjamin Cummings, 1991.

    Google Scholar 

  8. Brunet J., Modelling the World with Semantic Objects Proceedings of the IFIP TC8/WG8.1 Working Conference on Object-Oriented Approach in Information Systems. Quebec (Can.), Oct. 1991, Van Assche F., Moulin B., Rolland C., (eds.). North-Holland, 1991, pp. 361–380.

    Google Scholar 

  9. Castellani X., Le modele de la methode MCO d’analyse et de conception des systemes d’objets. Congres INFORSID, Paris (Fr.), 1991.

    Google Scholar 

  10. Castellani X., RMCO: Methodologie dUanalyse et de conception des systemes objets. Tome 1: Ingenierie des besoinsS. Masson, Paris, 1993.

    Google Scholar 

  11. Champeaux (de) D., Lea D., Faure P., The Process of Object-Oriented Design. Proc. of the OOPSLAU92 Conference, 45–62.

    Google Scholar 

  12. Chen P., The Entity-Relationship Model: Towards an Unified View of Data. ACM Transaction On Database Systems. Vol.1 N!l, 1976, pp.9–36.

    Google Scholar 

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

    Article  Google Scholar 

  14. Chikofsky E-J, Cross J-H., Reverse Engineering and design recovry: a Taxonomy. IEEE Software, Jan. 1990, pp.13–17.

    Google Scholar 

  15. Coad P., Yourdon E., Object-Oriented Analysis Prentice Hall, 2nd Edition, 1990.

    Google Scholar 

  16. Coad P., Object-oriented Patterns. Comm. of the ACM, Vol.35, N!9, Sept. 92, pp.152–159.

    Google Scholar 

  17. Herzig R., Gogolla M., Transforming conceptual Data models into an object model. Proc. of the 11th Intern. Conf. on ER approach. Karlsruhe, 1992, pp. 280–298.

    Google Scholar 

  18. Hong S., Goor G., Brinkkemper S., A Formal Approach to the Comparison of Object-Oriented Analysis and Design Methodologies. Proc. of the 26th Hawaii International Conference on Systems Sciences. Hawaii 1993, pp. 689–698.

    Google Scholar 

  19. Martin J., Information Engineering: Volumes1, 2 and 3. Prentice-Hall, 1990.

    Google Scholar 

  20. McClure C., The three Rs of software automation: Re-engineering, Repository, Reusability. Prentice Hall, Englewood Cliffs, New Jersey, 1992.

    Google Scholar 

  21. Meyer B., Reusability: the case for object-oriented Design. IEEE Software, March 87, pp.50–64

    Google Scholar 

  22. Monarchi D-E., Puhr G-I., A Research Typology for Object-Oriented Analysis and Design. Comm. of the ACM, Vol.35, N!9, Sept. 92, pp.112–123.

    Google Scholar 

  23. Premerlani W., Blaha M.R., An approach for Reverse Engineering of Relational Databases. Comm. of the ACM, Vol.37, N!5, May 1994, pp.42–49.

    Google Scholar 

  24. Rochfeld A., Les methodes de conception orientees objet. Congres INFOR-SID, Clermont-Ferrand, Mai 1992, pp.563–593.

    Google Scholar 

  25. Rochfeld A., Bouzeghoub M. From Merise to OOM. Ingenierie des Systemes d’Information, Vol.1, N.2, 1993, pp.151–176.

    Google Scholar 

  26. Rolland C., Cauvet C., Modelisation conceptuelle orientee objet. VIImes Journees Bases de Donnees Avancees, Lyon, 25–27 sept. 1991, pp. 299–325.

    Google Scholar 

  27. Rumbaugh J. et al., Object-Oriented Modeling and Design. Prentice-Hall, 91.

    Google Scholar 

  28. Shlaer S, Mellor S-J., Object-Oriented System Analysis: Modeling the World in Data. Prentice Hall, Englewood Cliffs, N.J., 1988.

    Google Scholar 

  29. Shlaer S, Mellor S-J., RObject Lifecycles: Modeling the World in StatesS. Yourdon Press, Englewood Cliffs, N.J., 1992.

    Google Scholar 

  30. Smith J., Smith D., Data Abstraction: Aggregation and Generalization. ACM Transaction On Database Systems, Vol. 2, N! 2, 1977.

    Google Scholar 

  31. Shoval P., Shreiber N., Database reverse engineering: From the Relational to the Binary Relationship model. Data and Knowledge Engineering 10 (1993), pp.293–315.

    Article  Google Scholar 

  32. Tardieu H, Rochfeld A., Colletti R., La methode Merise. Tome 1: Principes et outils. 4eme edition, Editions dUOrganisation, Paris 1991.

    Google Scholar 

  33. Wirfs-Brock R., Johnson R.E., Current Research in Object-Oriented Design. Comm. of the ACM, Vol.33, N!9, Sept. 1990, pp.105–123.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. L.I.S.I Bt-401 - INSA., 20 Av. Albert Einstein, F-69621, Villeurbanne, France

    M. Ayache & A. Flory

Authors
  1. M. Ayache
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. A. Flory
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institut für Informatik, Universität Klagenfurt, Universitätsstraße 65, A-9020, Klagenfurt, Austria

    Johann Eder

  2. Institute for Problems of Informatics, Russian Academy of Sciences, Vavilov Street 30/6, 117900, V-334, Moscow, Russian Federation

    Leonid A. Kalinichenko

Rights and permissions

Reprints and permissions

Copyright information

© 1996 British Computer Society

About this paper

Cite this paper

Ayache, M., Flory, A. (1996). Transforming Conceptual ER Schema into Object-Oriented Databases. In: Eder, J., Kalinichenko, L.A. (eds) Advances in Databases and Information Systems. Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-1486-4_10

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-1486-4_10

  • Publisher Name: Springer, London

  • Print ISBN: 978-3-540-76014-6

  • Online ISBN: 978-1-4471-1486-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation