Semantically enriching relational databases into an object oriented semantic model

  • Malú Castellanos 
  • Félix Saltor
  • Manuel García-Solaco
Object-Oriented Modelling
Part of the Lecture Notes in Computer Science book series (LNCS, volume 856)


A method to convert relational schemas to an object oriented semantic model is presented. It makes explicit knowledge about the semantic of the database that was implicit in the schemas or in the extension, through a knowledge acquisition phase. The method is general, semiautomatic, and has a number of applications.

Key words

Semantic enrichment knowledge acquisition semantic level reverse engineering object oriented models semantic models 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Cas93]
    M.Castellanos: Semiautomatic Semantic Enrichment for the Integrated Access to Interoperable Databases. PhD dissertation, Dept. LSI, UPC, June 1993.Google Scholar
  2. [CasAma83]
    M.Casanova & J.Amarel: “Designing ER Schemas from Conventional Information Systems”. Proceedings, third International ER Conf, 1983.Google Scholar
  3. [CasSal93]
    M.Castellanos & F.Saltor: “Extraction of Data Dependencies”. In: Proceedings, The 3rd European-Japanese Seminar on Information Modelling and Knowledge Bases, Budapest, 1993.Google Scholar
  4. [CasSalGar91]
    M.Castellanos, F.Saltor & M.García-Solaco: “The Development of Semantic Concepts in the BLOOM Model using an Object Metamodel”. Report LSI-91-22. U.P.C., Barcelona.Google Scholar
  5. [ChiBarSto93]
    R.Chiang, T.Barron & V.Storey: “Performance Evaluation of Reverse Engineering Relational Databases into Extended Entity-Relationship Models”. Proc. 12th Int. Conf. on Entity-Relationship Approach, Arlington, TX, 1993.Google Scholar
  6. [DavAro87]
    Davis & Arora: “Converting a Relational Database Model into an ER Model”. In [Mar88].Google Scholar
  7. [GarCasSal93]
    M.García-Solaco, M.Castellanos & F.Saltor: “Discovering Interdatabase Resemblance of Classes for Interoperable Databases”. In: H. Schek, A. Sheth & B. Czejdo (eds.): Proceedings 2nd Int. Workshop on Interoperability in Multidatabase Systems (RIDE IMS-93). IEEE-CS Press. Vienna. Apr. 1993.Google Scholar
  8. [JohKal89]
    Johannesson & Kalman: “A Method for Translating Relational Schemas into Conceptual Schemas”. Proc. 8th Int. ER Conference, Toronto, 1989.Google Scholar
  9. [ManRai86]
    H.Mannila & K-J.Räihä: Algorithms for Inferring Functional Dependencies. Dept. of Computer Science, Univ. of Helsinki, Report C-1991-41.Google Scholar
  10. [Mar88]
    S.March (ed.): Proceedings of the 6th International Conference on the Entity-Relationship Approach. NewYork, 1987.Google Scholar
  11. [MarMak90]
    Markowitz & Makowsky: “Identifying Extended ER object Structures in Relational Schemas”. IEEE Trans. on Software Engineering, Vol.16, No.8. 1990.Google Scholar
  12. [NavAwo87]
    Navathe & Awong: “Abstracting Relational and Hierarchical Data with a Semantic Data Model”. In [Mar88].Google Scholar
  13. [Sal+94]
    F.Saltor, M.Castellanos, M.García & T.Kudrass: “Modelling Specialization as BLOOM Semilattices”. To appear in Proceedings of the 4th. Euro-Japanese Seminar on Information Modelling and Knowledge Bases. Stockholm. 1994.Google Scholar
  14. [SalCasGar91]
    F.Saltor, M.Castellanos & M.García-Solaco: “Suitability of Data Models as Canonical Models for Federated Databases”. ACM SIGMOD Record, Vol.20, No.4 (Dec. 1991)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Malú Castellanos 
    • 1
  • Félix Saltor
    • 1
  • Manuel García-Solaco
    • 1
  1. 1.Dept. Llenguatges i Sistemes InformàticsUniversität Politècnica de CatalunyaEspagne

Personalised recommendations