A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model
The work in this paper presents a proposed solution for preprocessing, analyzing, mining and data warehouse model for personal medical data collected from different hospitals and clinics. The proposed solution contains different phases and steps, including Extraction, Transforming and Loading (ETL)...
Main Author: | |
---|---|
Format: | Article |
Language: | English |
Published: |
Faculty of Computer Science and Mathematics, University of Kufa
2016-06-01
|
Series: | Journal of Kufa for Mathematics and Computer |
Subjects: | |
Online Access: | https://journal.uokufa.edu.iq/index.php/jkmc/article/view/2123 |
_version_ | 1797267020229640192 |
---|---|
author | Kadhim B. S. AlJanabi |
author_facet | Kadhim B. S. AlJanabi |
author_sort | Kadhim B. S. AlJanabi |
collection | DOAJ |
description | The work in this paper presents a proposed solution for preprocessing, analyzing, mining and data warehouse model for personal medical data collected from different hospitals and clinics. The proposed solution contains different phases and steps, including Extraction, Transforming and Loading (ETL) and data preprocessing focuses on converting the logged data into categories suitable for analysis and mining process, a star warehouse model was implemented that fulfills the required processing techniques, data are represented by multi-dimensional cubes for efficient and better data representation, and finally link analysis was applied on the data.
The proposed framework is simple and straight forward for implementation. Personal medical data from different sources mostly in Excel files were converted into clean, complete and consistent data by different preprocessing techniques. Logged data were converted into high quality, reliable and suitable for analysis and mining process. Star warehouse schema was implemented since it is very suitable for such type of data and mining techniques. 19900 patients records were collected and used in this work. Excel and WEKA software were used for the analysis and mining processes. |
first_indexed | 2024-04-25T01:09:56Z |
format | Article |
id | doaj.art-f81a50def73047c58d32515943bfe7ef |
institution | Directory Open Access Journal |
issn | 2076-1171 2518-0010 |
language | English |
last_indexed | 2024-04-25T01:09:56Z |
publishDate | 2016-06-01 |
publisher | Faculty of Computer Science and Mathematics, University of Kufa |
record_format | Article |
series | Journal of Kufa for Mathematics and Computer |
spelling | doaj.art-f81a50def73047c58d32515943bfe7ef2024-03-10T10:38:38ZengFaculty of Computer Science and Mathematics, University of KufaJournal of Kufa for Mathematics and Computer2076-11712518-00102016-06-013110.31642/JoKMC/2018/030104A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse ModelKadhim B. S. AlJanabi0University of KufaThe work in this paper presents a proposed solution for preprocessing, analyzing, mining and data warehouse model for personal medical data collected from different hospitals and clinics. The proposed solution contains different phases and steps, including Extraction, Transforming and Loading (ETL) and data preprocessing focuses on converting the logged data into categories suitable for analysis and mining process, a star warehouse model was implemented that fulfills the required processing techniques, data are represented by multi-dimensional cubes for efficient and better data representation, and finally link analysis was applied on the data. The proposed framework is simple and straight forward for implementation. Personal medical data from different sources mostly in Excel files were converted into clean, complete and consistent data by different preprocessing techniques. Logged data were converted into high quality, reliable and suitable for analysis and mining process. Star warehouse schema was implemented since it is very suitable for such type of data and mining techniques. 19900 patients records were collected and used in this work. Excel and WEKA software were used for the analysis and mining processes.https://journal.uokufa.edu.iq/index.php/jkmc/article/view/2123Data Warehouse Data CubePreprocessingStar ModelLink Analysis |
spellingShingle | Kadhim B. S. AlJanabi A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model Journal of Kufa for Mathematics and Computer Data Warehouse Data Cube Preprocessing Star Model Link Analysis |
title | A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model |
title_full | A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model |
title_fullStr | A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model |
title_full_unstemmed | A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model |
title_short | A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model |
title_sort | newframework for analyzing and mining medical data with aproposed data warehouse model |
topic | Data Warehouse Data Cube Preprocessing Star Model Link Analysis |
url | https://journal.uokufa.edu.iq/index.php/jkmc/article/view/2123 |
work_keys_str_mv | AT kadhimbsaljanabi anewframeworkforanalyzingandminingmedicaldatawithaproposeddatawarehousemodel AT kadhimbsaljanabi newframeworkforanalyzingandminingmedicaldatawithaproposeddatawarehousemodel |