UUM Electronic Theses and Dissertation
UUM ETD | Universiti Utara Malaysian Electronic Theses and Dissertation
FAQs | Feedback | Search Tips | Sitemap

A data transformation model for relational and non-relational data

Hasan, Hasan Forat Falih (2023) A data transformation model for relational and non-relational data. Doctoral thesis, Universiti Utara Malaysia.

[thumbnail of s903028_01.pdf] Text
Restricted to Repository staff only until 18 May 2025.

Download (6MB) | Request a copy
[thumbnail of s903028_02.pdf] Text

Download (1MB)


The information systems that support small, medium, and large organisations need data transformation solutions from multiple data sources to fulfill the requirements of new applications and decision-making to stay competitive. Relational data is the foundation for the majority of applications programme, whereas non-relational data is the foundation for the majority of newly produced applications. The relational model is the most elegant one; nonetheless, this kind of database has a drawback when it comes to managing very large volumes of data. Because they can handle massive volumes of data, non-relational databases have evolved into relational database substitutes. The key issue is that rules for data transformation processes across various data types are becoming less well-defined, leading to a steady decline in data quality. Therefore, to handle relational and non-relational data and satisfy the requirements for data quality, an empirical model in this domain knowledge is required. This study seeks to develop a data transformation model used for different data sources while satisfying data quality requirements, especially the transformation processes in relational and non-relational model, named Data Transformation with Two ETL Phases and Central-Library (DTTEPC). The different stages and methods in the developed model are used to transform the metadata information and stored data from relational to non-relational systems, and vice versa. The model is developed and validated through expert review, and the prototype based on the final version is employed in two case studies: education and healthcare. The results of the usability test demonstrate that the developed model is capable of transforming metadata data and stored data across systems. So enhancing the information systems in various organizations through data transformation solutions. The DTTEPC model improved the integrity and completeness of the data transformation processes. Moreover, supports decision-makers by utilizing information from various sources and systems in real-time demands.

Item Type: Thesis (Doctoral)
Supervisor : Abu Bakar, Muhamad Shahbani
Item ID: 10515
Uncontrolled Keywords: Data transformation, Data quality, ETL, Relational and Non-Relational Model, Heterogeneous data.
Subjects: T Technology > T Technology (General) > T58.6-58.62 Management information systems
T Technology > T Technology (General)
Divisions: Awang Had Salleh Graduate School of Arts & Sciences
Date Deposited: 30 Apr 2023 01:23
Last Modified: 30 Apr 2023 01:23
Department: Awang Had Salleh Graduate School of Art & Sciences
Name: Abu Bakar, Muhamad Shahbani
URI: https://etd.uum.edu.my/id/eprint/10515

Actions (login required)

View Item
View Item