|
![](images/pix01.gif) |
|
|
|
Integration Mapping Rules: Transforming Relational Database to Semantic Web Ontology |
|
PP: 881-901 |
|
doi:10.18576/amis/100307
|
|
Author(s) |
|
Mohamed A. G. Hazber,
Ruixuan Li,
Xiwu Gu,
|
|
Abstract |
|
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. |
|
|
![](images/pix01.gif) |
|
|