A Comprehensive Health Electronic Record System with MySQL RDMS, QGIS Database and MongoDB (original) (raw)
Related papers
A Coherent Healthcare System with RDBMS, NoSQL and GIS Databases
2017
With new database system development and new data types emerging, many applications are no longer using a monolithic, simple client/server structure, but using more than one types of database systems to store heterogeneous data. In this project, we exploit the benefits of combing Relational Database Management System (RDBMS) and NoSQL systems in the development of better Electronic Health Records (EHRs) and Clinical Decision Support Systems (CDSS). Specifically, MySQL, MongoDB, and GIS databases are integrated to improve EHR systems and to provide better clinical decision supports. The ACID (atomicity, consistency, isolation, durability) properties of the RDBMS ensure data integrity, database security, efficient SQL queries, easy data access, and effective transaction processing. MongoDB provides the system with clear internal data structure, easy scaling-out, fine-tuning, and convenient mapping of application objects to the database objects. The GIS database allows vivid visualizat...
Designing and Implementing of Electronic Health Record System in Ksa Using SQL & ASP.NET
2015
Electronic health record (EHR) rapid progress for reporting electronic data storage that employs uniform data standards will enable health care organizations to respond more quickly to federal state, and private reporting requirements, including those that support patient safety and disease surveillance. An examination of many hospitals that recently implemented in King Saudi Arabia (KSA). A little of electronic health record (EHR) system finds that clinical and administrative leaders built EHR adoption into their strategic plans to integrate, inpatient and outpatient care system and a provide continuum of coordinated services. Using Relational Data Base Management Systems (RDBMS) with eXtend Marker Language (XML) Systems and ASP.NET as web based system. Successful implementation depended on: strong leadership, full involvement of clinical staff in design and implementation, mandatory staff training, and strict adherence to timeline and budget. The EHR systems facilitate patient sa...
Design and Implementation of a Hospital Database Management System (HDMS) for Medical Doctors
International Journal of Computer Theory and Engineering, 2018
This paper aimed at designing and implementing an automated system that will alleviate the problem of handling patients' data in a hospital. The researchers were motivated to embark on this project because of the inherent problems of the manual system of hospitals file management. This manual system has so many problems associated with it such as insecurity of files, poor file retrieval system and inefficient file update system etc. This paper examines an existing information system of a hospital and designed an automated system that can help Medical Doctors and those who handle hospitals' data to perform their work more effectively and efficiently. The System would be developed with a Window, Apache, MySQL and PHP (WAMP) software. The HDBMS would be a web application that runs in a computer network. It would provide easy and fast access to stored data as needed by different users with security against unauthorized access. Any authorized user can add, delete and update data into the database base on their user-assigned-role. It would equally have the facility to give a unique identity for every persons and stores the details of every patient and the staff automatically. It includes a search facility to know the current status of each room in the hospital. A user can search availability of doctors and the details of a patient using the system. The interface is very user-friendly.
Integrated Document-based Electronic Health Records Persistence Framework
International Journal of Advanced Computer Science and Applications, 2021
Electronic health record systems work beyond just recording patients` health data. They have multiple secondary functionalities, such as data reporting and clinical decision support. As each of these systems` workloads has contradictory different needs, managing a multipurpose electronic health record is a challenge. This paper proposes a unified healthcare data framework that can simplify health information system infrastructure. It investigates the suitability of the documentbased NoSQL persistence mechanism, storing electronic health records data as a design choice for managing varied complexity ad hoc queries used in operational business intelligence. The performance of the most popular two document-based NoSQL back-ends, Couchbase Server and MongoDB, is compared according to the size of the database and query execution time. Results showed that while MongoDB can execute simple singledocument queries nearly in milliseconds. It does not provide satisfactory response time for unplanned complex queries spanning multiple documents. By utilizing its analytics services and multi-dimensional scaling architecture, Couchbase Server multi-node cluster outperforms the response times of MongoDB for both simple and complex healthcare data access patterns. The primary advantage of the proposed tightly coupled EHRs processing framework is its flexibility to manage workload according to changing requirements.
BMC medical informatics and decision making, 2017
The objective of this research is to compare the relational and non-relational (NoSQL) database systems approaches in order to store, recover, query and persist standardized medical information in the form of ISO/EN 13606 normalized Electronic Health Record XML extracts, both in isolation and concurrently. NoSQL database systems have recently attracted much attention, but few studies in the literature address their direct comparison with relational databases when applied to build the persistence layer of a standardized medical information system. One relational and two NoSQL databases (one document-based and one native XML database) of three different sizes have been created in order to evaluate and compare the response times (algorithmic complexity) of six different complexity growing queries, which have been performed on them. Similar appropriate results available in the literature have also been considered. Relational and non-relational NoSQL database systems show almost linear a...
International Journal of Computer Science and Mobile Computing Hospital Database Management System
A database is a collection of data in an organized manner so that its content can easily be accessed, retrieved, managed and updated as per need. It is think of electronic filing system. DBMS (Database Management System) is the keeper of database facilitating the creation & maintenance of database. It Provides fast secure access to the data in the database. A database contains objects which
Online Database System for Patients Data Organization
Through this paper we investigate the significance of the online database system which can manage health records. The ehealth systems can able to store mass of individual patients' data. In this paper with the help of the investigation we have prepared a questionnaire to extract user perception and surveyed them extensively. We understand that many parameters and facts need to considered while processing health care data. It is also important to get specific as well as detailed data to plan the ehealth data system.
The Electronic Health Record and its Contribution to Healthcare Information Systems Interoperability
One of the main advantages of using computational systems in the health care activity comes from their ability to provide useful information for decision making to health professionals. Thus, their main purpose is to increment the quality and efficiency of healthcare delivery. In order to achieve these purposes, Health Information Systems must fulfill interoperability standards, quality, security, scalability, reliability and timeliness in data storage and processing terms. One of the main existing problems in this area is the fact that informatics applications do not share information, or share it in a very low level. When communication between different Health Information Systems exists, it is mainly achieved through proprietary integration solutions. In this paper is made a survey of the main advantages of Electronic Health Records and presented a proposal of some general guidelines for building them and promote the integration of different information resources.