This paper proposes an approach to automatic transformation of relational databases to ontologies, where constraints CHECK are also considered. A relational database is written in SQL and an ontology is written in OWL. The proposed approach can be used for integrating data that are scattered across many different domains and that reside in many separate relational databases.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Buccella A, Cechich A (2003) An Ontology Approach to Data Integration. JCS…T, 3:62 68
Berners-Lee T (1998) Relational Databases on the Semantic Web. http://www.w3.org/DesignIssues/RDB-RDF.html. Accessed 17 January 2008
SQL (2002) Database language SQL. ANSI X3.135. http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt. Accessed 17 January 2008
OWL (2004) OWL Web Ontology Language Reference. http://www.w3.org/TR/owl-ref. Accessed 17 January 2008
Li M, Du X, Wang S (2005) Learning Ontology from Relational Database. Proceedings of the 4th International Conference on Machine Learning and Cybernetics. 6:3410 3415
Shen G, Huang Z, Zhu X, Zhao X (2006) Research on the Rules of Mapping from Relational Model to OWL. Proceedings of the Workshop on OWL: Experiences and Directions. 216
Astrova I, Kalja A (2006) Towards the Semantic Web: Extracting OWL Ontologies from SQL Relational Schemata. Proceedings of IADIS International Conference WWW/Internet. 62 66
Buccella A, Penabad M, Rodriguez F, Farina A, Cechich A (2004) From Relational Databases to OWL Ontologies. Proceedings of the 6th National Russian Research Conference
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer Science+Business Media, LLC
About this paper
Cite this paper
Astrova, I. (2009). Rules for Mapping SQL Relational Databases to OWL Ontologies. In: Sicilia, MA., Lytras, M.D. (eds) Metadata and Semantics. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-77745-0_40
Download citation
DOI: https://doi.org/10.1007/978-0-387-77745-0_40
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-77744-3
Online ISBN: 978-0-387-77745-0
eBook Packages: Computer ScienceComputer Science (R0)