Distributed Database Strategies In A Healthcare Record Systems

  • Doan Thanh Nghi An Giang University, Long Xuyen, Vietnam
  • Huynh Ly Thanh Nhan An Giang University, Long Xuyen, Vietnam
  • Nguyen Thanh Loi An Giang University, Long Xuyen, Vietnam
  • Bui Thi Thuy Trang An Giang University, Long Xuyen, Vietnam
Keywords: Distributed database management system, Healthcare record system, Multi-Master replication

Abstract

The rapid development of information technology has brought various opportunities to the healthcare sector, particularly in facilitating medical examination and treatment as well as hospital management. However, in Vietnam, the healthcare software systems still have many limitations. These include such as inaccurate processing process compared to the actual requirements which are usually developed in discrete, with no common standards, and no data connection with each other. Therefore, it leads to the existence of many separate, duplicated, inaccurate and incomplete databases. A patient comes to medical examination and treatment at a new facility still has to provide the necessary information to the medical personnel from the beginning, causing delay in the treatment and management of patients. The improper system entails inconvenience in terms of storing, checking and monitoring medical records, especially when emergency cases arised. In recent years, the need to collect, store and exchange information has become more and more tangible, forming large blocks of data. The traditional database management systems and centralized data management have no longer met this requirement. Instead, distributed data management technologies development proven to be more optimum, reliable, widely used and popular. Therefore, we have studied and built an information system with a distributed database to apply to the management of medical examination and treatment at medical facilities. This paper will present the construction of information and health information system, learn the dispersion model and deploy Multi-Master replication model of MySQL Replication. Our system has satisfied the basic operations, expanding the necessary functions, thus bringing high efficiency in practical applications. The medical information and treatment system using the humanized dispersion model helps the medical examination and treatment data to be synchronized and retrieved quickly, saving time, avoiding information redundancy, thereby improving