Open Access iconOpen Access



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: email

Computers, Materials & Continua 2021, 68(2), 2711-2726.


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.


Cite This Article

APA Style
Mahmoud, A., Shams, M.Y., Elzeki, O.M., Awad, N.A. (2021). Using semantic web technologies to improve the extract transform load model. Computers, Materials & Continua, 68(2), 2711-2726.
Vancouver Style
Mahmoud A, Shams MY, Elzeki OM, Awad NA. Using semantic web technologies to improve the extract transform load model. Comput Mater Contin. 2021;68(2):2711-2726
IEEE Style
A. Mahmoud, M.Y. Shams, O.M. Elzeki, and N.A. Awad "Using Semantic Web Technologies to Improve the Extract Transform Load Model," Comput. Mater. Contin., vol. 68, no. 2, pp. 2711-2726. 2021.

cc 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.
  • 2911


  • 1163


  • 0


Share Link