Mining Students and Patients Data of Dentistry College in the University of Mosul

This research paper includes the design and implementation of a system for mining student and patient data at the College of Dentistry at the University of Mosul using the Microsoft SQL Server database management system to design and implement the database system and WEKA program for database mining...

Full description

Bibliographic Details
Main Authors: Marwa Mustafa, Ammar Thaher Al Abd Alazeez
Format: Article
Language:Arabic
Published: College of Education for Pure Sciences 2024-03-01
Series:مجلة التربية والعلم
Subjects:
Online Access:https://edusj.mosuljournals.com/article_181717_4224413349fc3fb0ae95da69378306ee.pdf
_version_ 1797289951343149056
author Marwa Mustafa
Ammar Thaher Al Abd Alazeez
author_facet Marwa Mustafa
Ammar Thaher Al Abd Alazeez
author_sort Marwa Mustafa
collection DOAJ
description This research paper includes the design and implementation of a system for mining student and patient data at the College of Dentistry at the University of Mosul using the Microsoft SQL Server database management system to design and implement the database system and WEKA program for database mining, and the Microsoft Visual C# .NET 2012 language was used to program system interfaces. The main steps of the database included analysis, design and implementation, and the mining process included seven steps; data collection, data preprocessing, data exploration, data transformation, data modeling, evaluation, and deployment. The database mining process was divided into two parts; the first part is a smart cluster process for students of the Faculty of Dentistry for the fourth and fifth stages on laboratories (i.e. the number of chairs available for each laboratory) using three famous algorithms (Canopy, K-Means, EM), the second part is the process of classifying patients into four classes according to the type of treatment that each patient needs using three also famous algorithms (SVM, Naïve Bayes, Random Forest). ). After applying the system to the real data of the College of Dentistry at the University of Mosul, it was found that the best cluster algorithm is K-Means and the best classification algorithm is Naïve Bayes.
first_indexed 2024-03-07T19:13:26Z
format Article
id doaj.art-96ea46afa6e4483d812ca088337d9137
institution Directory Open Access Journal
issn 1812-125X
2664-2530
language Arabic
last_indexed 2024-03-07T19:13:26Z
publishDate 2024-03-01
publisher College of Education for Pure Sciences
record_format Article
series مجلة التربية والعلم
spelling doaj.art-96ea46afa6e4483d812ca088337d91372024-02-29T20:28:01ZaraCollege of Education for Pure Sciencesمجلة التربية والعلم1812-125X2664-25302024-03-01331465710.33899/edusj.2023.143880.1398181717Mining Students and Patients Data of Dentistry College in the University of MosulMarwa Mustafa0Ammar Thaher Al Abd Alazeez1Computer Science Department / College of Computer Science and Mathematics / University of MosulComputer Science Department / College of Computer Science and Mathematics / University of MosulThis research paper includes the design and implementation of a system for mining student and patient data at the College of Dentistry at the University of Mosul using the Microsoft SQL Server database management system to design and implement the database system and WEKA program for database mining, and the Microsoft Visual C# .NET 2012 language was used to program system interfaces. The main steps of the database included analysis, design and implementation, and the mining process included seven steps; data collection, data preprocessing, data exploration, data transformation, data modeling, evaluation, and deployment. The database mining process was divided into two parts; the first part is a smart cluster process for students of the Faculty of Dentistry for the fourth and fifth stages on laboratories (i.e. the number of chairs available for each laboratory) using three famous algorithms (Canopy, K-Means, EM), the second part is the process of classifying patients into four classes according to the type of treatment that each patient needs using three also famous algorithms (SVM, Naïve Bayes, Random Forest). ). After applying the system to the real data of the College of Dentistry at the University of Mosul, it was found that the best cluster algorithm is K-Means and the best classification algorithm is Naïve Bayes.https://edusj.mosuljournals.com/article_181717_4224413349fc3fb0ae95da69378306ee.pdfdatabase,,,،mining database,,,،dentistry applications
spellingShingle Marwa Mustafa
Ammar Thaher Al Abd Alazeez
Mining Students and Patients Data of Dentistry College in the University of Mosul
مجلة التربية والعلم
database,,
,،mining database,,
,،dentistry applications
title Mining Students and Patients Data of Dentistry College in the University of Mosul
title_full Mining Students and Patients Data of Dentistry College in the University of Mosul
title_fullStr Mining Students and Patients Data of Dentistry College in the University of Mosul
title_full_unstemmed Mining Students and Patients Data of Dentistry College in the University of Mosul
title_short Mining Students and Patients Data of Dentistry College in the University of Mosul
title_sort mining students and patients data of dentistry college in the university of mosul
topic database,,
,،mining database,,
,،dentistry applications
url https://edusj.mosuljournals.com/article_181717_4224413349fc3fb0ae95da69378306ee.pdf
work_keys_str_mv AT marwamustafa miningstudentsandpatientsdataofdentistrycollegeintheuniversityofmosul
AT ammarthaheralabdalazeez miningstudentsandpatientsdataofdentistrycollegeintheuniversityofmosul