Abstract
Developing ontology for modeling the universe of a Relational Database (RDB) is a key success for many RDB related domains, including semantic-query of RDB, Linked Data and semantic interoperability of information systems. However, the manual development of ontology is a tedious task, error-prone and requires much time. The research field of ontology learning aims to provide (semi-) automatic approaches for building ontology. However, one big challenge in the automatic transformation, is how to label the relationships between concepts. This challenge depends heavily on the correct extraction of the relationship types. In fact, the RDB model does not store the meaning of relationships between entities, it only indicates the existence of a link between them. This paper suggests a solution consisting of a meta-model for the semantic enrichment of the RDB model and of a classification of relationships. A case study shows the effectiveness of our approach.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Alalwan, N., Zedan, H., Siewe, F.: Generating owl ontology for database integration. In: Third International Conference on Advances in Semantic Processing, SEMAPRO 2009, pp. 22–31. IEEE (2009)
Astrova, I., Korda, N., Kalja, A.: Rule-based transformation of sql relational databases to owl ontologies. In: Proceedings of the 2nd International Conference on Metadata & Semantics Research. Citeseer (2007)
El Idrissi, B., Baïna, S., Baïna, K.: A methodology to prepare real-world and large databases to ontology learning. In: Enterprise Interoperability VI, pp. 175–185. Springer (2014)
El Idrissi, B., Baïna, S., Baïna, K.: Upgrading the semantics of the relational model for rich owl 2 ontology learning. Journal of Theoretical and Applied Information Technology 68(1) (2014)
Evens, M.W.: Relational models of the lexicon: Representing knowledge in semantic networks. Cambridge University Press (2009)
Gómez-Pérez, A., Manzano-Macho, D., et al.: A survey of ontology learning methods and techniques. OntoWeb Deliverable D 1, 5 (2003)
Gruber, T.R., et al.: A translation approach to portable ontology specifications. Knowledge Acquisition 5(2), 199–220 (1993)
Ling, H., Zhou, S.: Mapping relational databases into owl ontology. International Journal of Engineering and Technology (IJET) 5(6), 4735–4740 (2013)
Louhdi, M.R.C., Behja, H., El Alaoui, S.O.: Transformation rules for building owl ontologies from relational databases. In: 2nd ICAITA, pp. 271–283 (2013)
Petasis, G., Karkaletsis, V., Paliouras, G., Krithara, A., Zavitsanos, E.: Ontology population and enrichment: State of the art. In: Paliouras, G., Spyropoulos, C.D., Tsatsaronis, G. (eds.) Multimedia Information Extraction. LNCS (LNAI), vol. 6050, pp. 134–166. Springer, Heidelberg (2011)
SAP ERP Solutions, www.sap.com
Sequeda, J.F., Arenas, M., Miranker, D.P.: On directly mapping relational databases to rdf and owl (extended version). arXiv preprint arXiv:1202.3667 (2012)
Spanos, D.E., Stavrou, P., Mitrou, N.: Bringing relational databases into the semantic web: A survey. Semantic Web 3(2), 169–209 (2012)
Storey, V.C.: Understanding semantic relationships. The VLDB Journal 2(4), 455–488 (1993)
Teorey, T.J., Lightstone, S.S., Nadeau, T., Jagadish, H.V.: Database modeling and design: logical design. Elsevier (2011)
The Apache DB Project DdlUtils, https://db.apache.org/ddlutils/
Tirmizi, S.H., Sequeda, J., Miranker, D.P.: Translating SQL applications to the semantic web. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds.) DEXA 2008. LNCS, vol. 5181, pp. 450–464. Springer, Heidelberg (2008)
Ullrich, H., Purao, S., Storey, V.C.: An ontology for classifying the semantics of relationships in database design. In: Bouzeghoub, M., Kedad, Z., Métais, E. (eds.) NLDB 2000. LNCS, vol. 1959, pp. 91–102. Springer, Heidelberg (2001)
W3C: Owl 2 web ontology language structural specification and functional-style syntax (second edition). (December 2012), http://www.w3.org/TR/owl2-syntax/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
El Idrissi, B., Baïna, S., Baïna, K. (2015). Ontology Learning from Relational Database: How to Label the Relationships Between Concepts?. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_21
Download citation
DOI: https://doi.org/10.1007/978-3-319-18422-7_21
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-18421-0
Online ISBN: 978-3-319-18422-7
eBook Packages: Computer ScienceComputer Science (R0)