AUTOMATIC TRANSFORMATION OF SQL RELATIONAL DATABASES TO OWL ONTOLOGIES

Irina Astrova, Ahto Kalja

Abstract

This paper proposes a novel approach to automatic transformation of relational databases (written in SQL) to ontologies (written in OWL), where domains and constraints CHECK are also considered. The proposed approach can identify (inverse) functional, symmetric and transitive properties, cardinality and value restrictions, and enumerated classes and data types.

References

  1. Astrova, I., Kalja, A., 2006. Towards the Semantic Web: Extracting OWL ontologies from SQL relational schemata. In ICWI'06, IADIS International Conference WWW/Internet.
  2. Buccella, A., Penabad, M., Rodriguez, F., Farina, A., Cechich, A., 2004. From relational databases to OWL ontologies. In RCDL'04, 6th National Russian Research Conference.
  3. Li, M., Du, X., Wang, S., 2005. Learning ontology from relational database. In ICMLC'05, 4th International Conference on Machine Learning and Cybernetics.
  4. McFadden, F., Hoffer, J., Prescott, M., 1999. Modern Database Management. 5th edition, Addison-Wesley.
  5. OWL, 2004. OWL Web Ontology Language Reference. http://www.w3.org/TR/owl-ref
  6. Sequeda, J., Tirmizi, S., Miranker, D., 2007. SQL Databases are a Moving Target. In W3C Workshop on RDF Access to Relational Databases.
  7. Shen, G., Huang, Z., Zhu, X., Zhao, X., 2006. Research on the rules of mapping from relational model to OWL. In OWLED'06, OWL: Experiences and Directions.
  8. SQL, 2002. Database language SQL. ANSI X3.135. www.contrib.andrew.cmu.edu/shadow/sql/sql1992.txt
  9. Xu, Z., Zhang, S., Dong, Y., 2006. Mapping between relational database schema and OWL ontology for deep annotation. In WI'06, IEEE/WIC/ACM International Conference on Web Intelligence.
Download


Paper Citation


in Harvard Style

Astrova I. and Kalja A. (2008). AUTOMATIC TRANSFORMATION OF SQL RELATIONAL DATABASES TO OWL ONTOLOGIES . In Proceedings of the Fourth International Conference on Web Information Systems and Technologies - Volume 2: WEBIST, ISBN 978-989-8111-27-2, pages 131-136. DOI: 10.5220/0001515101310136


in Bibtex Style

@conference{webist08,
author={Irina Astrova and Ahto Kalja},
title={AUTOMATIC TRANSFORMATION OF SQL RELATIONAL DATABASES TO OWL ONTOLOGIES},
booktitle={Proceedings of the Fourth International Conference on Web Information Systems and Technologies - Volume 2: WEBIST,},
year={2008},
pages={131-136},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001515101310136},
isbn={978-989-8111-27-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Fourth International Conference on Web Information Systems and Technologies - Volume 2: WEBIST,
TI - AUTOMATIC TRANSFORMATION OF SQL RELATIONAL DATABASES TO OWL ONTOLOGIES
SN - 978-989-8111-27-2
AU - Astrova I.
AU - Kalja A.
PY - 2008
SP - 131
EP - 136
DO - 10.5220/0001515101310136