A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model


  • Kadhim B. S. AlJanabi University of Kufa




Data Warehouse, Data Cube, Preprocessing, Star Model, Link Analysis


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.


Download data is not yet available.


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.




How to Cite

AlJanabi, K. B. S. (2016). A NewFramework for Analyzing and Mining Medical Data with aProposed Data Warehouse Model. Journal of Kufa for Mathematics and Computer, 3(1), 22–29. https://doi.org/10.31642/JoKMC/2018/030104

Similar Articles

1 2 3 4 5 6 7 8 > >> 

You may also start an advanced similarity search for this article.