Building Ontology from Relational Database

Andrejs Kaulins, Arkady Borisov


This paper proposes an approach of building OWL2 ontology from data in a relational database. Compared with existing methods, the approach can acquire ontology from a relational database automatically by using a group of learning rules. Approach is independent from database implementation; it is designed based on standards, used to manage database systems. In this paper, we describe object mapping from a relational database and OWL2 ontology including classes, data properties, object properties, instances, axioms and annotations. Axioms are important part of OWL2 specification, and the approach is also suitable for the axiom building process.


Ontology; ontology building; relational database; relational model

Full Text:



E. F. Codd, “A Relational Model of Data for Large Shared Data Banks”, Communications of ACM, vol. 13, no. 6, June 1970, pp. 377–387.

T. R. Gruber, “A translation approach to portable ontology specifications”, technical report KSL 92–71, 1993.

C. J. Date, An introduction to Database Systems, 8th ed., Addison- Wesley, 2004, p. 1024.

H. A. Santoso, S. C. Haw, Z. N. Abdul-Mehdi, “Ontology extraction from relational database: Concept hierarchy as background knowledge,” Knowledge-Based Systems, vol. 24, issue 3, Apr. 2011, pp. 457–464, 2010.

M. Li, X.Y. Du, S. Wang, “Learning ontology from relational database”, 4th International Conference on Machine Learning and Cybernetics, 2005, pp. 3410–3415.

N. Lammari, I. Comyn-Wattiau, J. Akoka, “Extracting generalization hierarhies from relational database: A reverse engineering approach”, Data & Knowledge Engineering vol. 63, issue 2, 2007, pp. 568–589.

R. Leyderman, Oracle Database Sample Schemas, 11g Release 2 (11.2), E10831-02, Oracle, 2010.

ISO/IEC SQL/Framework Standard, ISO/IEC 9075-1:1999, ISO, 1999.

B. Motik, P. F. Patel-Schneider, B. Parsia, OWL 2 Web Ontology Language Structural Specification and Functional-Style Syntax. Available:, [Accessed Oct. 12, 2014].

M. Reda Chbihi Louhdi, H. Behja and S. Ouatik El Alaoui, “Transformation rules for building OWL Ontologies from relational databases”, Second International Conference on Advanced Information Technologies and Applications, ICAITA-2013, 2013, pp. 271–283.

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

H. V. Jagadish, T. Nadeau, S. S. Lightstone, T. J. Teorey, Database Modeling and Design, 5th ed., Morgan Kaufmann, 2011.


  • There are currently no refbacks.

Copyright (c) 2014 Andrejs Kaulins, Arkady Borisov

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.