Automatic Transformation of Relational Database Schema into OWL Ontologies

Imants Zarembo


Ontology alignment, or ontology matching, is a technique to map different concepts between ontologies. For this purpose at least two ontologies are required. In certain scenarios, such as data integration, heterogeneous database integration and data model compatibility evaluation, a need to transform a relational database schema to an ontology can arise.

To conduct a successful transformation it is necessary to identify the differences between relational database schema and ontology information representation methods, and then to define transformation rules. The most straight forward but time consuming way to carry out transformation is to do it manually. Often this is not an option due to the size of data to be transformed. For this reason there is a need for an automated solution.

The automatic transformation of OWL ontology from relational database schema is presented in this paper; the data representation differences between relational database schema and OWL ontologies are described; the transformation rules are defined and the transformation tool’s prototype is developed to perform the described transformation.


ERD; OWL; transformation

Full Text:



W3C. “OWL 2 Web Ontology Language Document Overview (Second Edition)”, 2012. [Online]. Available: [Accessed March 10, 2015].

D. E. Spanos, P. Starvrou and N. Mitrou, Bringing Relational Databases into the Semantic Web: A Survey, Semantic Web, vol 3, pp. 169-209, Apr. 2012.

L. Zhang and J. Li, Automatic Generation of Ontology Based on Database, Journal of Computational Information Systems, pp. 1148-1154, Apr. 2011.

W. Hu and Y. Qu, Discovering Simple Mappings Between Relational Database Schemas and Ontologies, ISWC'07/ASWC'07 Proceedings of the 6th international The semantic web and 2nd Asian conference on Asian semantic web conference, pp. 225-238, 2007.

N. Alalwan, H. Zedan and F. Siewe, “Generating OWL Ontology for Database Integration”, Advances in Semantic Processing, 2009. SEMAPRO '09, pp. 22-31, Oct. 2009.

M. Li, X. Y. Du and S. Wang, Learning Ontology from Relational Database, Machine Learning and Cybernetics, 2005. Proceedings of 2005 International Conference, pp. 3410-3415, Aug. 2005.

S. Zhou, H. Ling, M. Han and H. Zhang, “Ontology Generator from Relational Database Based on Jena”, Computer and Information Science, pp. 263-267, 2010.

Z. Telnarova, Relational database as a source of ontology creation, Computer Science and Information Technology (IMCSIT), Proceedings of the 2010 International Multiconference, pp. 135-139, Oct. 2010.

I. Astrova, N. Korda and A. Kalja, Rule-Based Transformation of SQL Relational Databases to OWL Ontologies, In Proceedings of the 2nd International Conference on Metadata & Semantics Research, 2007.

F. Baadar, I. Horrocks and U. Sattler, “Description Logics as Ontology Languages for the Semantic Web”, Festschrift in honor of Jörg Siekmann, Lecture Notes in Artificial Intelligence, 2003.

R. Ghawi and N. Cullot, “Database-to-Ontology Mapping Generation for Semantic Interoperability”, VLDB ‘07, September 23-28, 2007.

J. Euzenat and P. Shvaiko, Ontology Matching, 2nd edition. Springer-Verlag, Berlin Heidelberg (DE), 2013

M. Fahad, “ER2OWL Generating OWL Ontology from ER Diagram”, Intelligent Information Processing IV, pp. 28-37, 2008.

I. Zarembo, S. Kodors, Automatic Transformation of UML Geospatial Profile to OWL Ontologies, Virtual Multidisciplinary Conference (QUAESTI 2013), ISBN: 978-80-554-0826-2, Slovak Republic, pp. 225-229, Dec. 2013.

I. Zarembo, A. Teilans, A. Rausis, J. Buls, “Assessment of Name Based Algorithms for Land Administration Ontology Matching,” ICTE in Regional Development, vol. 43, pp. 53-61, Dec. 2014.



  • There are currently no refbacks.

SCImago Journal & Country Rank