Vol.68, No.2, 2021, pp.2711-2726, doi:10.32604/cmc.2021.015293
Using Semantic Web Technologies to Improve the Extract Transform Load Model
  • Amena Mahmoud1,*, Mahmoud Y. Shams2, O. M. Elzeki3, Nancy Awadallah Awad4
1 Department of Computer Science, Kafrelshiekh University, Kafrelshiekh, Egypt
2 Department of Machine Learning, Kafrelsheikh University, Kafrelshiekh, Egypt
3 Department of Computer Science, Mansoura University, Mansoura, Egypt
4 Department of Computer and Information Systems, Sadat Academy for Management Sciences, Cairo, Egypt
* Corresponding Author: Amena Mahmoud. Email:
Received 14 November 2020; Accepted 18 February 2021; Issue published 13 April 2021
Semantic Web (SW) provides new opportunities for the study and application of big data, massive ranges of data sets in varied formats from multiple sources. Related studies focus on potential SW technologies for resolving big data problems, such as structurally and semantically heterogeneous data that result from the variety of data formats (structured, semi-structured, numeric, unstructured text data, email, video, audio, stock ticker). SW offers information semantically both for people and machines to retain the vast volume of data and provide a meaningful output of unstructured data. In the current research, we implement a new semantic Extract Transform Load (ETL) model that uses SW technologies for aggregating, integrating, and representing data as linked data. First, geospatial data resources are aggregated from the internet, and then a semantic ETL model is used to store the aggregated data in a semantic model after converting it to Resource Description Framework (RDF) format for successful integration and representation. The principal contribution of this research is the synthesis, aggregation, and semantic representation of geospatial data to solve problems. A case study of city data is used to illustrate the semantic ETL model’s functionalities. The results show that the proposed model solves the structural and semantic heterogeneity problems in diverse data sources for successful data aggregation, integration, and representation.
Semantic web; big data; ETL model; linked data; geospatial data
Cite This Article
A. Mahmoud, M. Y. Shams, O. M. Elzeki and N. A. Awad, "Using semantic web technologies to improve the extract transform load model," Computers, Materials & Continua, vol. 68, no.2, pp. 2711–2726, 2021.
This work is licensed under a Creative Commons Attribution 4.0 International License , which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.