Design of an Efficient Hospital Management Database System for Enhanced Data Management

Wenjie Mo

2024

Abstract

The rapid advancement of digital technologies has significantly impacted the informatization of the medical industry, particularly in data management. This study aims to design and implement an efficient, secure, and reliable hospital management database system to address the limitations of traditional manual data processing methods. Utilizing relational database management system principles, the study employs Entity-Relationship (ER) diagrams to model the complex relationships among hospital entities. The ER model is then converted into a relational schema and implemented using My Structured Query Language (MySQL). The system is designed to manage key hospital data, including medical records, doctor files, and prescriptions, optimizing data storage through normalization and indexing techniques. Data for this study was generated using the Mockaroo data generator to simulate a real hospital environment. Experimental results demonstrate that the proposed system significantly enhances data retrieval efficiency and system reliability, particularly under high data loads. The system effectively reduces data redundancy, improves query performance, and supports large-scale medical data management. Overall, this study provides a scalable solution that contributes to the broader goal of digital transformation in healthcare.

Paper Citation

in Harvard Style

Mo W. (2024). Design of an Efficient Hospital Management Database System for Enhanced Data Management. In Proceedings of the 2nd International Conference on Data Analysis and Machine Learning - Volume 1: DAML; ISBN 978-989-758-754-2, SciTePress, pages 311-316. DOI: 10.5220/0013516300004619

in Bibtex Style

@conference{daml24,
author={Wenjie Mo},
title={Design of an Efficient Hospital Management Database System for Enhanced Data Management},
booktitle={Proceedings of the 2nd International Conference on Data Analysis and Machine Learning - Volume 1: DAML},
year={2024},
pages={311-316},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0013516300004619},
isbn={978-989-758-754-2},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 2nd International Conference on Data Analysis and Machine Learning - Volume 1: DAML
TI - Design of an Efficient Hospital Management Database System for Enhanced Data Management
SN - 978-989-758-754-2
AU - Mo W.
PY - 2024
SP - 311
EP - 316
DO - 10.5220/0013516300004619
PB - SciTePress