Storing OWL Ontologies in SQL Relational Databases
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.
[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.
[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.
@article{"International Journal of Information, Control and Computer Sciences:57939", author = "Irina Astrova and Nahum Korda and Ahto Kalja", title = "Storing OWL Ontologies in SQL Relational Databases ", 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.", volume = "1", number = "5", pages = "1345-6", }
