Desarrollo de una aplicación web para el agendamiento y control de citas médicas utilizando seguridad a nivel base de datos

Abstract

Because every day our society is more dynamic, globalized and interconnected, so the use of a web application is no longer an alternative but an essential requirement in different areas such as: health, education, commerce, finance, among others. The reality of the health crisis that is being experienced worldwide, in the area of health, the demand for patients has increased, in order to respond in an appropriate way to all the requirements of the population and provide adequate medical care, it is urgent that all Hospital centers, both public and private, use technology as a strategic resource. Specifically, at the Johnson Clinic, patients currently come when they feel a breakdown in their health, they are treated by the staff available at that time and request a medical appointment with specialist professionals who on certain occasions are not available, this generates discomfort for both the patient as to the clinic staff, due to the lack of a person in charge exclusively for scheduling; The owner of the Johnson clinic felt the need to optimize resources, maximize time and improve efficiency in terms of scheduling medical appointments. In response to this problem, the idea of developing a web application that allows the management and control of medical appointments was born. For the development of this technology proposal, the Extreme Programming methodology is used, since it is one of the most popular agile methodologies today because it is based on communication and customer needs. For the implementation of this project, the JavaScript language was used mainly, which is widely used in web-oriented applications in view of the abundance of libraries and frameworks, for the frontend side ReactJS were used, a framework designed to create user interfaces while NodeJS and Express technology were used for the backend, which provides modules for writing handlers with HTTP verbs, simplifying the configuration of a web server. To store the information, MongoDB was used as a non-relational database and a 3 node architecture was implemented that allows the replication of the information, ensuring the availability and reliability of the data. The web application has 2 types of users: Doctor and Patient. The patient can choose the doctor with the necessary specialty according to her symptoms, when choosing the doctor, he will see the calendar with the availability of the professional and finally he will be able to select the date and time to request an appointment. The doctor can configure his availability by defining a work schedule with a check-in time, a checkout time and a break time. After this process, he is available to schedule or reject requests medical appointments. With this application, the scheduling of medical appointments is significantly optimized, increasing the productivity of the clinic and generating patient satisfaction. In the final section of this work is the evaluation of the system based on the ISO/IEC-9126 quality standard, obtaining qualifications with acceptable results.