Commenced in January 2007
Frequency: Monthly
Edition: International
Paper Count: 30455
Storing OWL Ontologies in SQL Relational Databases

Authors: Irina Astrova, Nahum Korda, Ahto Kalja


Relational databases are often used as a basis for persistent storage of ontologies to facilitate rapid operations such as search and retrieval, and to utilize the benefits of relational databases management systems such as transaction management, security and integrity control. On the other hand, there appear more and more OWL files that contain ontologies. Therefore, this paper proposes to extract ontologies from OWL files and then store them in relational databases. A prerequisite for this storing is transformation of ontologies to relational databases, which is the purpose of this paper.

Keywords: Ontologies, sql, Relational Databases, and OWL

Digital Object Identifier (DOI):

Procedia APA BibTeX Chicago EndNote Harvard JSON MLA RIS XML ISO 690 PDF Downloads 4804


[1] R. Harrison, and C. Chan, "Distributed ontology management system," in Proc. 18th Annual Canadian Conf. on Electrical and Computer Engineering, Saskatoon, Canada, 2005, pp. 661-664.
[2] Y. An, A. Borgida, and J. Mylopoulos, "Inferring complex semantic mappings between relational tables and ontologies from simple correspondences," in Proc. OMT Conf., Agia Napa, Cyprus, 2005, pp. 1152-1169.
[3] J. Barrasa, O. Corcho, G. Shen, and A. Gomez-Perez, "R2O: An extensible and semantically based database-to-ontology mapping language," in Proc. Workshop on Semantic Web and Databases, Edinburgh, Scotland, 2004, pp. 1069-1070.
[4] N. Konstantinou, D. Spanos, M. Chalas, E. Solidakis, and N. Mitrou, "VisAVis: An approach to an intermediate layer between ontologies and relational database contents," in Proc. Int. Workshop on Web Information Systems Modeling, Luxembourg, Grand Duchy of Luxembourg, 2006.
[5] Z. Xu, S. Zhang, and Y. Dong, "Mapping between relational database schema and OWL ontology for deep annotation," in Proc. of IEEE/WIC/ACM Int. Conf. on Web Intelligence, Hong Kong, China, 2006, pp. 548-552.
[6] A. Gali, C. Chen, K. Claypool, and R. Uceda-Sosa, "From ontology to relational databases," in Proc. Int. Workshop on Conceptual-Model Driven Web Information Integration and Mining, Shanghai, China, 2004, pp. 278-289.
[7] E. Vysniauskas, and L. Nemuraite, "Transforming ontology representation from OWL to relational database," Information Technology and Control, vol. 35A, no. 3, 2006, pp. 333-343.
[8] I. Astrova, A. Kalja, and N. Korda, "Automatic transformation of OWL ontologies to SQL relational databases," in Proc. IADIS European Conf. Data Mining (MCCSIS), Lisbon, Portugal, 2007, pp. 145-149.
[9] OWL Web Ontology Language Reference, 2004, Available:
[10] Database Language SQL. ANSI X3.135, 2002, Available:
[11] M. Sabou, "Extracting ontologies from software documentation: A semiautomatic method and its evaluation," in Proc. Workshop on Ontology Learning and Population, Valencia, Spain, 2004.