Skip to main content

Formal Approach and Automated Tool for Translating ER Schemata into OWL Ontologies

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 3056))

Abstract

Ontologies play a key role in creating machine-processable Web content to enable the Semantic Web. Extracting domain knowledge from database schemata can profitably support ontology development and then semantic markup of the instance data with the ontologies. The Entity-Relationship (ER) model is an industrial standard for conceptually modeling databases. This paper presents a formal approach and an automated tool for translating ER schemata into Web ontologies in the OWL Web Ontology Language. The tool can firstly read in an XML-coded ER schema produced with ER CASE tools such as PowerDesigner. Following the predefined knowledge-preserving mapping rules from ER schema to OWL DL (a sublanguage of OWL) ontology, it then automatically translates the schema into the ontology in both the abstract syntax and the RDF/XML syntax for OWL DL. Case studies show that the approach is feasible and the tool is efficient, even to large-scale ER schemata.

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

Buying options

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. Baader, F., McGuinness, D.L., Nardi, D., Patel-Schneider, P.F. (eds.): The Description Logic Handbook: Theory, Implementation, and Applications. Cambridge University Press, Cambridge (2003)

    MATH  Google Scholar 

  2. Beckett, D., Grant, J.: Mapping Semantic Web Data with RDBMSes. IST Project SWAD-Europe Deliverable 10.2, February 18 (2003), Online at http://www.w3.org/2001/sw/Europe/reports/scalable_rdbms_mapping_report

  3. Berners-Lee, T., Hendler, J., Lassila, O.: The Semantic Web. Scientific American 284(5), 34–43 (2001)

    Article  Google Scholar 

  4. Calvanese, D., Lenzerini, M., Nardi, D.: Unifying Class-based Representation Formalisms. Journal of Artificial Intelligence Research 11, 199–240 (1999)

    MATH  MathSciNet  Google Scholar 

  5. Dean, M., Schreiber, G. (eds.): OWL Web Ontology Language Reference. W3C Recommendation, February 10 (2004), Online at http://www.w3.org/TR/2004/REC-owl-ref-20040210/

  6. Fensel, D., Pérez, A.G. (eds.): A Survey on Ontology Tools. IST Project OntoWeb Deliverable 1.3 (May 2002), Online at ontoweb.aifb.uni-karlsruhe.de/About/Deliverables/D13_v1-0.zip

  7. Franconi, E., Ng, G.: The i.com Tool for Intelligent Conceptual Modeling. In: Proc. of the 7th Int’l Workshop on Knowledge Representation Meets Databases. CEUR Electronic Workshop Proceedings, pp. 45–53 (2000), Online at CEUR-WS.org/Vol-29/

  8. Gómez-Pérez, A., Manzano-Macho, D. (eds.): A Survey of Ontology Learning Methods and Techniques. IST Project OntoWeb Deliverable 1.5 (June 2003), Online at ontoweb.aifb.uni-karlsruhe.de/Members/ruben/Deliverable%201.5

  9. Handschuh, S., Staab, S., Volz, R.: On Deep Annotation. In: Proc. of the 12th Int’l World Wide Web Conf., pp. 431–438. ACM Press, New York (2003)

    Google Scholar 

  10. Hori, M., Euzenat, J., Patel-Schneider, P.F.: OWL Web Ontology Language XML Presentation Syntax. W3C Note, June 11 (2003), Online at http://www.w3.org/TR/2003/NOTE-owl-xmlsyntax-20030611/

  11. Horrocks, I., Patel-Schneider, P.F., van Harmelen, F., Zienberer, J.Y.: From SHIQ and RDF to OWL: The Making of a Web Ontology Language. Journal of Web Semantics 1(1) (December 2003), Online at www.websemanticsjournal.org/volume1/issue1/Horrocksetal2003/index.html

  12. Maedche, A., Staab, S.: Ontology Learning for the Semantic Web. IEEE Intelligent Systems 16(2), 72–79 (2001)

    Article  Google Scholar 

  13. Patel-Schneider, P.F., Hayes, P., Horrocks, I. (eds.): OWL Web Ontology Language Semantics and Abstract Syntax. W3C Recommendation, February 10 (2004), Online at http://www.w3.org/TR/2004/REC-owl-semantics-20040210/

  14. Stojanovic, L., Stojanovic, N., Volz, R.: Migrating Data-intensive Web Sites into the Semantic Web. In: Proc. of the 17th ACM Symposium on Applied Computing, pp. 1100–1107. ACM Press, New York (2002)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Xu, Z., Cao, X., Dong, Y., Su, W. (2004). Formal Approach and Automated Tool for Translating ER Schemata into OWL Ontologies. In: Dai, H., Srikant, R., Zhang, C. (eds) Advances in Knowledge Discovery and Data Mining. PAKDD 2004. Lecture Notes in Computer Science(), vol 3056. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24775-3_57

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-24775-3_57

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-22064-0

  • Online ISBN: 978-3-540-24775-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics