The pros and cons healthcare database system

MIS602: DATA MODELLING AND DATABASE DESIGN

Reflective Research Report

This report provides an overview of data management and design techniques along with various cognitive technology which provides an effective solution for generating and visualizing insights from the hospital data and provides possible recommendations to the patients. Concluding the report by addressing various scenarios and challenges and limitations.

TABLE OF CONTENTS

3

The Royal Rundle Hospital (RRH) is a multi-specialty hospital that provides health services and a 24-hour emergency department. The RRH has been serving in the region for over 50 years. The hospital provides a broad range of services to the community including surgical, maternity, dialysis, mental health, etc.

4

Static Data Management: The static data management technique comes under the traditional method of storing the data. The traditional method of storing and managing the data is paper-based and requires more time to search and access.

Despite the range of areas where information technology and digitalization make a substantial contribution to enhancing the health access and quality of services. The industry lacking the

5

Request server

Response
PC
RRH Database

The above diagram is an entity-relationship diagram (ERD) for Royal Rundle Hospital. This is a visual representation of the database design for the RRH hospital. This helps to generate an over-view of the schema design for the hospital. There is one to many relationships with patients to hospital and zero to one relationship for a patient’s to doctor. In the case of one to many, one patient has multiple records, where many to one many patients admitted to the same hospital. Also one to many relationships with the hospital to a doctor, i.e. many doctors work for the same hospital. There is one to many relationships between department to hospital where each hospital have various departments The given ER diagram represents main entities and attributes for the Royal Rundle hospital in which all the departments, facilities, and specific details are included.

The entity-relationship diagram represented in this figure is lead to the major portion required for the hospital to provide a more generic way of representation and design of the

 Patient Attribute: Patient name, Patient ID, Patient address, Patient sex, Patient contact. Medical record Attribute: Date admitted, Date discharged, Health problem.

 Hospital Department: Department name, Department functionality.

2. DESIGNING OF DATABASE AND IMPLEMENTATION

The database design for the RRH includes all the departments and necessary facilities along with the complete doctor and patient’s details as shown in the entity-relationship diagram. The more effective database for this multi-specialty hospital is based on no SQL based architecture which helps to manage fault, increases the efficiency, [ CITATION YHi20 \l 1033 ]and more reliable architecture for further analytics from the stored data in databases.

 Integrity to the alteration of data inside the database and have access grant to specific people or according to the administrative level.

 Security is the core part of any organization. In the case of the database, it is most important and plays a major role to prevent the necessary and highly sensitive data of users (patients, doctors, staff members from third parties, and vulnerabilities.

3. EFFECT OF DATA MODELLING:

Data modeling creates a data model for the data stored in a database. The [ CITATION Jyo15 \l 1033 ]data model provides a way or structure to organize and need of data and less focus on operations part of data. In more general data modeling helps to develop a data model for the data stored in the database. In the case of RRH, data modeling provides a conceptual and physical data model for the data stored in the database which helps to organize the data and to demonstrate the specific need of data for particular operations.

Fig: Work-flow of data modeling for different requirement
Data modeling emphasizes the data organization and need of data to make the effective use of the data stored in the database for analytics and further use-case to generates relevant insights and results.

4. BENEFITS OF DATA IN HOSPITAL

RRH hospital predictive analysis of data helps to improve the services and benefits for Requirements Physical Data
further development and growth of the hospital. Modelling

Performance Physical Data Major components of hospitals are health professionals (doctors and nurses), Requirement Model health facilities (testing labs, emergency services, medicines delivery, and other treatment technologies). These components generate a big-data repository for Business Data
RRH which helps to improve the healthcare system. Create/Update Data Data Patient data is most important for an effective and concise analysis of a particular hospital. Data generated from the patient’s side contains the feedback about

The above figure represents the analytical framework for precise analysis of the hospital data which store in the data warehouse. The main data warehouse of hospital contains variety of data comes from various departments, from patients and clinical data and pass them through analytics

12

Here are some listed challenges of the current operating system in RRH:
 Using the modern architecture of the database management system increases some cost but it’s beneficial for the hospital to know more about patients using the data
 Requires IT support when some failure occurs or any external problems. The database is designed in a more scalable and optimized technique but in some external cases occurs.

6. Conclusion

A) List of figures mentioned in the diagram are manual generated and specifies the illustrations of the data modelling and database components
B) Entity-Relationship diagram is generated using Lucid Chart and attached in document.

8. References

Jyothi, S. (2015). A STUDY ON BIG DATA MODELING TECHNIQUES. JOUR, 19-26.

Serdar Yegulalp. (2017, Dec 7). What is NoSQL? Databases for a cloud-scale future. Retrieved from InfoWorld: https://www.infoworld.com/article/3240644/what-is-nosql-databases-for-a-cloud-scale-future.html

15