Wu, HuanmeiAmbavane, AshishMukherjee, SunandaMao, Songan2017-12-282017-12-282017Wu, 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).https://hdl.handle.net/1805/14911With 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.enPublisher PolicyEHRsCDSSNoSQLArticle