A coherent healthcare system with RDBMS, NoSQL & GIS databases

Huanmei Wu, Ashish Ambavane, Sunanda Mukherjee, Songan Mao

Research output: Chapter in Book/Report/Conference proceedingConference contribution

3 Scopus citations

Abstract

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 visualization of the geographic locations of patients, physician offices, and medical facilities. The integrations of these database systems in healthcare help application systems to comply with the EHR HIPAA requirements without compromising on scalability and performance.

Original languageEnglish (US)
Title of host publicationProceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017
PublisherThe International Society for Computers and Their Applications (ISCA)
Pages313-318
Number of pages6
ISBN (Electronic)9781943436064
StatePublished - 2017
Event32nd International Conference on Computers and Their Applications, CATA 2017 - Honolulu, United States
Duration: Mar 20 2017Mar 22 2017

Other

Other32nd International Conference on Computers and Their Applications, CATA 2017
CountryUnited States
CityHonolulu
Period3/20/173/22/17

    Fingerprint

Keywords

  • CDSS
  • EHRs
  • GIS
  • MongoDB
  • NoSQL

ASJC Scopus subject areas

  • Computer Science Applications

Cite this

Wu, H., Ambavane, A., Mukherjee, S., & Mao, S. (2017). A coherent healthcare system with RDBMS, NoSQL & GIS databases. In Proceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017 (pp. 313-318). The International Society for Computers and Their Applications (ISCA).