A data transformation model for relational and non-relational data
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 progra...
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | eng eng |
| Published: |
2023
|
| Subjects: | |
| Online Access: | https://etd.uum.edu.my/10515/1/s903028_01.pdf https://etd.uum.edu.my/10515/2/s903028_02.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| id |
my-uum-etd.10515 |
|---|---|
| record_format |
uketd_dc |
| spelling |
my-uum-etd.105152023-04-30T01:23:53Z A data transformation model for relational and non-relational data 2023 Hasan, Hasan Forat Falih Abu Bakar, Muhamad Shahbani Awang Had Salleh Graduate School of Arts & Sciences Awang Had Salleh Graduate School of Art & Sciences T58.6-58.62 Management information systems T Technology (General) 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. 2023 Thesis https://etd.uum.edu.my/10515/ https://etd.uum.edu.my/10515/1/s903028_01.pdf text eng 2025-05-18 staffonly https://etd.uum.edu.my/10515/2/s903028_02.pdf text eng public other doctoral Universiti Utara Malaysia |
| institution |
Universiti Utara Malaysia |
| collection |
UUM ETD |
| language |
eng eng |
| advisor |
Abu Bakar, Muhamad Shahbani |
| topic |
T58.6-58.62 Management information systems T Technology (General) |
| spellingShingle |
T58.6-58.62 Management information systems T Technology (General) Hasan, Hasan Forat Falih A data transformation model for relational and non-relational data |
| description |
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. |
| format |
Thesis |
| qualification_name |
other |
| qualification_level |
Doctorate |
| author |
Hasan, Hasan Forat Falih |
| author_facet |
Hasan, Hasan Forat Falih |
| author_sort |
Hasan, Hasan Forat Falih |
| title |
A data transformation model for relational and non-relational data |
| title_short |
A data transformation model for relational and non-relational data |
| title_full |
A data transformation model for relational and non-relational data |
| title_fullStr |
A data transformation model for relational and non-relational data |
| title_full_unstemmed |
A data transformation model for relational and non-relational data |
| title_sort |
data transformation model for relational and non-relational data |
| granting_institution |
Universiti Utara Malaysia |
| granting_department |
Awang Had Salleh Graduate School of Arts & Sciences |
| publishDate |
2023 |
| url |
https://etd.uum.edu.my/10515/1/s903028_01.pdf https://etd.uum.edu.my/10515/2/s903028_02.pdf |
| _version_ |
1776103833657671680 |