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 Citations (Scopus)

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

Geographic information systems
Health
Decision support systems
Data structures
Scalability
Durability
Servers
Visualization
Tuning
Processing

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).

A coherent healthcare system with RDBMS, NoSQL & GIS databases. / Wu, Huanmei; Ambavane, Ashish; Mukherjee, Sunanda; Mao, Songan.

Proceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017. The International Society for Computers and Their Applications (ISCA), 2017. p. 313-318.

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

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. The International Society for Computers and Their Applications (ISCA), pp. 313-318, 32nd International Conference on Computers and Their Applications, CATA 2017, Honolulu, United States, 3/20/17.
Wu H, Ambavane A, Mukherjee S, Mao S. A coherent healthcare system with RDBMS, NoSQL & GIS databases. In Proceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017. The International Society for Computers and Their Applications (ISCA). 2017. p. 313-318
Wu, Huanmei ; Ambavane, Ashish ; Mukherjee, Sunanda ; Mao, Songan. / A coherent healthcare system with RDBMS, NoSQL & GIS databases. Proceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017. The International Society for Computers and Their Applications (ISCA), 2017. pp. 313-318
@inproceedings{6ca1561d2e2243299c24168105c410ad,
title = "A coherent healthcare system with RDBMS, NoSQL & GIS databases",
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.",
keywords = "CDSS, EHRs, GIS, MongoDB, NoSQL",
author = "Huanmei Wu and Ashish Ambavane and Sunanda Mukherjee and Songan Mao",
year = "2017",
language = "English (US)",
pages = "313--318",
booktitle = "Proceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017",
publisher = "The International Society for Computers and Their Applications (ISCA)",

}

TY - GEN

T1 - A coherent healthcare system with RDBMS, NoSQL & GIS databases

AU - Wu, Huanmei

AU - Ambavane, Ashish

AU - Mukherjee, Sunanda

AU - Mao, Songan

PY - 2017

Y1 - 2017

N2 - 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.

AB - 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.

KW - CDSS

KW - EHRs

KW - GIS

KW - MongoDB

KW - NoSQL

UR - http://www.scopus.com/inward/record.url?scp=85016643716&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85016643716&partnerID=8YFLogxK

M3 - Conference contribution

AN - SCOPUS:85016643716

SP - 313

EP - 318

BT - Proceedings of the 32nd International Conference on Computers and Their Applications, CATA 2017

PB - The International Society for Computers and Their Applications (ISCA)

ER -