A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model
DOI:
https://doi.org/10.31642/JoKMC/2018/030104Keywords:
Data Warehouse, Data Cube, Preprocessing, Star Model, Link AnalysisAbstract
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.Downloads
References
Jiawei Han and MichelineKamber ,"Data Mining: Concepts and Techniques”,3rd Edition , Morgan Kaufmann, 2012.
M. H. Dunham, “Data Mining: Introductory and Advanced Topics”,
Prentice Hall, 2002.
M. Durairaj, V. Ranjani, “Data Mining Applications In Healthcare Sector: A Study”, NTERNATIONAL JOURNAL OF SCIENTIFIC & TECHNOLOGYRESEARCH VOLUME 2, ISSUE 10, OCTOBER 2013 ISSN 2277-8616 29
DivyaTomar and Sonaligarwal,” A survey on Data Mining approaches for Healthcare”, International Journal of Bio-Science and Bio-Technology Vol.5, No.5 (2013), pp. 241-266, ISSN: 2233-7849 DOI: https://doi.org/10.14257/ijbsbt.2013.5.5.25
Tianyi Wu, Yuguo Chen and JiaweiHan, “Association Mining in LargeDatabases: A Re-Examination of ItsMeasures”, in Proc. 2007 Int. Conf. onPrinciples and Practice of KnowledgeDiscovery in Databases (PKDD'07),Warsaw, Poland, Sept. 2007.
Dr. Bushra M. Hussan ," Data Mining based Prediction of Medical data Using K-means algorithm" , Basrah Journal of Science (A), Vol.30(1),46-56 2012.
Krzysztof J. Cios ,WitoldPedrycz, Roman W. Swiniarski and Lukasz A.
Kurgan," Data Mining :A Knowledge DiscoveryApproach",Congress,2007,
ISBN-13: 978-0-387-33333-5.
Kadhim B. SwadiAljanabi ," An Improved Algorithm for Data Preprocessing in Mining Crime Data Set", Journal of Kufa forMathematics and Computer , Vol. 1 , No .4 , Nov ., 2011, pp.81- 87.
Krzysztof J. Cios, G. William Moore, "Uniqueness of medical data mining", Journal of Artificial Intelligence in Medicine, volume 26, Issues 1-2, 2002 Pages 1–24. DOI: https://doi.org/10.1016/S0933-3657(02)00049-0
Jules J Berman, "Confidentiality issues for medical data miners", Journal of Artificial Intelligence in Medicine, Volume 26, Issues 1-2, 2002 Pages 25–36. DOI: https://doi.org/10.1016/S0933-3657(02)00050-7
Joseph L. Breault, Colin R. Goodall, Peter J. Fos, "Data mining a diabetic data warehouse", Journal of Artificial Intelligence in Medicine, Volume 26, Issues 1-2, 2002 Pages 37–54. DOI: https://doi.org/10.1016/S0933-3657(02)00051-9
J. C. Prather, D. F. Lobach, L. K. Goodwin, J. W. Hales, M. L. Hage, and W. E. Hammond, "Medical data mining: knowledge discovery in a clinical data warehouse", Proc AMIA Annul Fall Symposium. 1997 : Pages 101–105.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2016 Kadhim B. S. AlJanabi
This work is licensed under a Creative Commons Attribution 4.0 International License.
which allows users to copy, create extracts, abstracts, and new works from the Article, alter and revise the Article, and make commercial use of the Article (including reuse and/or resale of the Article by commercial entities), provided the user gives appropriate credit (with a link to the formal publication through the relevant DOI), provides a link to the license, indicates if changes were made and the licensor is not represented as endorsing the use made of the work.