Storage Facility Management Framework Using NoSQL Database for Healthcare Sector
Keywords:
Framework, healthcare, management, NoSql, database, storage facilityAbstract
The tremendous adoption of new technology is responsible for the enormous volume of streaming data currently available. The traditional relational database paradigm faces many issues because of these enormous volumes of data. The primary concerns revolve around the efficiency of data retrieval and the database's ability to flexibly adjust its resources in response to changing requirements. However, because the new application architecture will be built on a NoSQL database, the adoption of NoSQL databases in new businesses is not a significant concern. However, a challenge arises when relational database-dependent systems that are already in place are redesigned to use NoSQL databases. To establish the fresh database structure, they need to review the system prerequisites once again. The goal of this project is to provide a framework for leveraging NoSQL databases to manage storage facilities for the healthcare industry. The notions of a relational structure (Table, Simple Attribute, Primary Key (PK), Foreign Key (FK), and Field List) and NoSQL concept (Document Collection, Document, Field, Embedded Field, ObjectId, DBRef) have been mapped conceptually. By creating object references between items that belong to documents, relationships were made possible. The metadata kept in the MySQL system tables was utilized by the mapping algorithm. PHP was used to implement the system. On the basis of migration speed and query speed, experiments on MySQL and MongoDB were carried out. Five queries were run to retrieve the number of rows from the product table to measure the read speed of each database. For each application, the average of these five requests was taken. MongoDB outperformed MySQL in a time comparison, clocking in at 1.78 sec versus 3.35 sec.
References
Feinleib D. (2012 Oct 8). Big Data and NoSQL: Five Key Insights. [Online]. Forbes online article retrieved from http://www.forbes.com/sites/davefeinleib/2012/10/08/big-data-and-nosql-five-key-insights.
Chen JK, Lee WZ. Data conversion from RDB to HBase. In 2017 IEEE 8th International Conference on Awareness Science and Technology (iCAST). 2017 Nov 8; 170–175.
Wasan SK, Bhatnagar V, Kaur H. The impact of data mining techniques on medical diagnostics. Data Sci J. 2006; 5: 119–26.
Wardani DW, Kiing J. Semantic mapping relational to graph model. In Proceedings of the IEEE International Conference on Computer, Control, Informatics and Its Applications (IC3INA). 2014; 160–165.
Kareem S, Ahmad RB, Sarlan AB. Framework for the Identification of Fraudulent Health Insurance Claims using Association Rule Mining. IEEE Conference on Big Data and Analytics (ICBDA). 2017; 99–104.
Karthika I, Porkodi KP. Fraud Claim Detection Using Spark. International Journal of Innovations in Engineering Research and Technology (IJIERT). 2017; 4(2): 10–13.
Karim R, Sahay R, Rebholz-Schuhmann D. A Scalable, Secure and Realtime Healthcare Analytics Framework with Apache Spark. In the Proceedings of 2nd Annual Insight Student Conference, NUIG, Ireland. 2015; 2(1): 1–2.
Sarraf S, Ostadhashem M. Big data spark solution for functional magnetic resonance imaging. arXiv preprint arXiv:1603.07064. 2016 Mar 23.
Băzăr C, Iosif CS. The Transition from RDBMS to NoSQL. A Comparative Analysis of Three Popular Non-Relational Solutions: Cassandra, MongoDB and Couchbase. Database Systems Journal. 2014 Apr 1;5(2).
Liao YT, Zhou J, Lu CH, Chen SC, Hsu CH, Chen W, Jiang MF, Chung YC. Data adapter for querying and transformation between SQL and NoSQL database. Future Gener Comput Syst. 2016 Dec 1; 65: 111–21.
Stanescu L, Brezovan M, Burdescu DD. Automatic mapping of MySQL databases to NoSQL MongoDB. In 2016 IEEE Federated Conference on Computer Science and Information Systems (FedCSIS). 2016 Sep 11; 837–840.
Kareem S, Ahmad RB, Sarlan AB. Framework for the identification of fraudulent health insurance claims using association rule mining. In 2017 IEEE Conference on Big Data and Analytics (ICBDA). 2017 Nov 16; 99–104.
