Design of A Data Warehouse for Medical Information System Using Data Mining Techniques

Farooqui, Nafees Akhter; Mehra, Ritika

doi:10.1109/pdgc.2018.8745864

Cited by 28 publications

(13 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…DW plays an active role in daily life and many other fields, such as medicine, business, banking, finance, web marketing, market segmentation and manufacturing, that consist of many stages, including process design, product planning, production and scheduling. Long-term strategic issues and profitability are closely related to and influenced by the decisions made, and many industries need decision-making systems [14]. DW technology is better than traditional decision-making techniques because it relies on different applications to collect, consolidate and store data, leading to the expansion of operations and increased efficiency.…”

Section: Dw's Applicationsmentioning

confidence: 99%

Design and implementation of the web (extract, transform, load) process in data warehouse application

Al-Rahman

Hasan²,

Sagheer³

2023

IJ-AI

View full text Add to dashboard Cite

<p>Recently, due to an increase size and complexity of data in addition to the management issues, data storage is required a great deal of attention to employ it in realistic applications, so the requirement for designing and implementing a data warehouse system has become an urgent necessity, ETL represents a vital side of data warehouse architecture. This paper, designed data warehouse application contains a web ETL process that divides its work between the input device and server. This system proposed to solve the problem lack of partition of the work between the input device and server. The proposed and designed system can be used and applied in many branches and disciplines for its high performance in adding data, analyzing data using a web server and building queries. The analysis of the results has been proven that a faster time is achieved in cleaning data and transferring it between the remote parts of the system connected to the Internet. Where ETL without Missing for any data took 0.00582 seconds.</p>

show abstract

Section: Dw's Applicationsmentioning

confidence: 99%

Design and implementation of the web (extract, transform, load) process in data warehouse application

Al-Rahman

Hasan²,

Sagheer³

2023

IJ-AI

View full text Add to dashboard Cite

show abstract

“…, (1) where K is the total number of clusters, l is the total number of instances and c is the current centroid.…”

Section: Sse = ∑ ∑ ( − ) 2 =1 =1mentioning

confidence: 99%

“…Today, computer-based solutions have become compulsory and are seen in medicine, too. Current medical studies are on Data Mining [1], Artificial Intelligence (AI) [2], Machine Learning, and Deep Learning ranging from processing medical images on radiological data to early diagnosis issues [3,4]. Examples of intelligent solutions for malignant diseases such as heart disease, cancer, and diabetes are also encountered [5,6].…”

Section: Introductionmentioning

confidence: 99%

Knowledge Discovery Using Clustering Methods in Medical Database: A Case Study for Reflux Disease

Doğan

Ridaoui

2021

Sakarya University Journal of Science

View full text Add to dashboard Cite

Digitalization spreads day by day around the world; thus, the amount of data collected is on the rise. An increasing amount of data leads us to use the data and get the advantage of it by using methods like Data mining. Data mining is used in several industries. Especially as medical data is essential to be understood, it is crucial to work on it. Reflux disease is a painful illness spreading around the world. Reflux is more common compared to formerly known numbers of patients. Even though reflux is not as fatal as cancer, it decreases the quality of life and makes many people suffer in their daily life. So, reflux is affecting mental health directly. If we can ease the process of diagnosis of reflux, we may provide a better quality of life for people. In this study, various data mining algorithms are applied, and it is seen from results that medical care can be improved by changing. Nowadays, artificial intelligence applications in the field of gastroenterology stand out in various sources in the literature. However, a large database required that is specific for Reflux disease to implement these applications is available only at the Reflux Research Center in Ege University in Turkey. By benefiting the Short Form36 and Quadrad12 questionnaire data in this database, 3,909 patients and many artificial intelligence algorithms were used to discover the hidden associations among responses in the quality of life of these patients. The algorithms used in the tests are Apriori, Frequent Pattern Growth, Density-Based Spatial Clustering of Applications with Noise, Self-Organizing Map, and KMeans. In the tests, it was observed that the most successful algorithm in terms of the structure of the data was KMeans, and a set of remarkable 27 rules according to the optimal Sum of Square Error value was obtained.

show abstract

“…Sudarmojo et al (2018) [19] design a data warehouse for a library to analyze data about the transaction process for getting smart decisions in similar service feature evaluation in libraries. Farooqui et al (2018) [20] introduce a methodology for the construction of a data warehouse for a medical information system; this data warehouse will help to improve the data analysis and assisting clinical managers to identify decisive patterns, diseases, and their support by enhancing the decision making.…”

Section: Related Workmentioning

confidence: 99%

An Optimal Warehouse Design for Crime Dataset

2020

IJATCSE

View full text Add to dashboard Cite

Data science and analytics represent one of the most emerging fields nowadays. Collecting, storing and analyzing the data are challenging issues in the field since they require the most advanced techniques and technologies. Data Warehouse and Data Marts represent some solutions for collecting, storing and accessing the data. Good Warehouse design leads to better analysis results. Among different application fields of the data, crime data is an important and complex discipline that contains a number of complex relationships between its contents, a wide range of applications and its crucial importance. The aim of the work in this paper is building an optimal Data warehouse for crime dataset using real crime data collected from the internet. Among the different DW modules available in this field galaxy module is used in this work. The data warehouse will support the decision-making process for lawmaker and police departments by understanding crime subjects, and statistics that allow them to track actions, foretell the probability of occurring crimes and efficiently use supplies which are inverted in this paper. The proposed design of the DW shows more reliability, better storing and accessing capabilities and lower anomalies among the other designs. The proposed design was supported with a crime database design to remove heterogonous of the data and to apply some preprocessing issues from which they require data is extracted, transformed and loaded (ETL) into the warehouse. Finally, more than six million high quality, clean, and preprocessed of crime records data are available for the researchers.

show abstract

Design of A Data Warehouse for Medical Information System Using Data Mining Techniques

Cited by 28 publications

References 8 publications

Design and implementation of the web (extract, transform, load) process in data warehouse application

Design and implementation of the web (extract, transform, load) process in data warehouse application

Knowledge Discovery Using Clustering Methods in Medical Database: A Case Study for Reflux Disease

An Optimal Warehouse Design for Crime Dataset

Contact Info

Product

Resources

About