Integration mapping rules: Transforming relational database to semantic web ontology

Publication Type:
Journal Article
Applied Mathematics and Information Sciences, 2016, 10 (3), pp. 881 - 901
Issue Date:
Filename Description Size
981c0pe1881cm1.pdfPublished Version863.51 kB
Adobe PDF
Full metadata record
© 2016 NSP. Semantic integration became an attractive area of research in several disciplines, such as information integration, databases and ontologies. Huge amount of data is still stored in relational databases (RDBs) that can be used to build ontology, and the database cannot be used directly by the semantic web. Therefore, one of the main challenges of the semantic web is mapping relational databases to ontologies (RDF(S)-OWL). Moreover, the use of manual work in the mapping of web contents to ontologies is impractical because it contains billions of pages and the most of these contents are generated from relational databases. Hence, we propose a new approach, which enables semantic web applications to access relational databases and their contents by semantic methods. Domain ontologies can be used to formulate relational database schema and data in order to simplify the mapping (transformation) of the underlying data sources. Our method consists of two main phases: building ontology from an RDB schema and the generation of ontology instances from an RDB data automatically. In the first phase, we studied different cases of RDB schema to be mapped into ontology represented in RDF(S)-OWL, while in the second phase, the mapping rules are used to transform RDB data to ontological instances represented in RDF triples. Our approach is demonstrated with examples, validated by ontology validator and implemented using Apache Jena in Java Language and MYSQL. This approach is effective for building ontology and important for mining semantic information from huge web resources.
Please use this identifier to cite or link to this item: