Storing OWL Ontologies in SQL Relational Databases

Authors: Irina Astrova, Nahum Korda, Ahto Kalja

Abstract:

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, relational databases, SQL, and OWL.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1071690

References:

[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: http://www.w3.org/TR/owl-ref
[10] Database Language SQL. ANSI X3.135, 2002, Available: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
[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.