Decentralized Data Integrity: Integrating MySQL with Blockchain for Resilient Healthcare Systems
DOI:
https://doi.org/10.13052/jmm1550-4646.2124Keywords:
MySQL, Blockchain, Healthcare Information Systems, Data Security, Data IntegrationAbstract
A transformational solution to the problems created by healthcare data management is presented by the integration of MySQL and blockchain technology, centered around security, scalability, and efficiency. This paper presents MBHA MySQL-Blockchain Healthcare Architecture combining the structured data storage, querying capabilities of MySQL with the decentralized, tamper-proof framework of blockchain. The system shows impressive performance metrics with an average API response time of 1.54 seconds for user registration and 841 milliseconds for login. The database queries and data retrieval or insertion took less than 1 millisecond, and JWT tokens were generated for authentication in less than 50 milliseconds. Conclusion Results indicate an efficient real-time system to accomplish tasks with integrity in terms of data but also with safety in operations. This architectural model, discussed above, is issues regarding data security and access with a need to provide care-collaboration needs. Scalability would then be optimized while keeping down computational overhead; in fact, work toward readiness for adoption is mainly towards being more regulatory compliant.
Downloads
References
Pandey, Abhishek Kumar, Asif Irshad Khan, Yoosef B. Abushark, Md Mottahir Alam, Alka Agrawal, Rajeev Kumar, and Raees Ahmad Khan. “Key issues in healthcare data integrity: Analysis and recommendations.” IEEE Access 8 (2020): 40612–40628.
Zarour, Mohammad, Mamdouh Alenezi, Md Tarique Jamal Ansari, Abhishek Kumar Pandey, Masood Ahmad, Alka Agrawal, Rajeev Kumar, and Raees Ahmad Khan. “Ensuring data integrity of healthcare information in the era of digital health.” Healthcare Technology Letters 8, no. 3 (2021): 66–77.
Vimalachandran, Pasupathy, Hua Wang, Yanchun Zhang, Ben Heyward, and Frank Whittaker. “Ensuring data integrity in electronic health records: A quality health care implication.” In 2016 International Conference on Orange Technologies (ICOT), pp. 20–27. IEEE, 2016.
Sarker, M. (2024). Revolutionizing healthcare: the role of machine learning in the health sector. Journal of Artificial Intelligence General science (JAIGS) ISSN: 3006-4023, 2(1), 36–61.
Rath, K. C., Khang, A., Rath, S. K., Satapathy, N., Satapathy, S. K., and Kar, S. (2024). Artificial intelligence (AI)-enabled technology in medicine-advancing holistic healthcare monitoring and control systems. In Computer Vision and AI-Integrated IoT Technologies in the Medical Ecosystem (pp. 87–108). CRC Press.
Ogundipe, D. O. (2024). The impact of big data on healthcare product development: A theoretical and analytical review. International Medical Science Research Journal, 4(3), 341–360.
Ahammed, M. F., and Labu, M. R. (2024). Privacy-Preserving Data Sharing in Healthcare: Advances in Secure Multiparty Computation. Journal of Medical and Health Studies, 5(2), 37–47.
Ramani, R., Mary, A. R., Raja, S. E., and Shunmugam, D. A. (2024). Optimized data management and secured federated learning in the Internet of Medical Things (IoMT) with blockchain technology. Biomedical Signal Processing and Control, 93, 106213.
Chen, J., Yi, C., Du, H., Niyato, D., Kang, J., Cai, J., and Shen, X. (2024). A revolution of personalized healthcare: Enabling human digital twin with mobile AIGC. IEEE Network.
Zhao, X., Bai, Z., Zhan, X., Wang, J., Cheng, Y., and Xiao, X. (2024). Safety evaluation of traditional Chinese medicine: New era, new strategy. Acupuncture and Herbal Medicine, 4(2), 171–175.
Chowdhury, R. H. (2024). The evolution of business operations: unleashing the potential of Artificial Intelligence, Machine Learning, and Blockchain. World Journal of Advanced Research and Reviews, 22(3), 2135–2147.
Palaniappan, K., Lin, E. Y. T., and Vogel, S. (2024, February). Global regulatory frameworks for the use of artificial intelligence (AI) in the healthcare services sector. In Healthcare (Vol. 12, No. 5, p. 562). MDPI.
Song, D., Zhang, H., Shi, L., Xu, H., and Xu, Y. (2024). S5Utis: Structured State-Space Sequence SegNeXt UNet-like Tongue Image Segmentation in Traditional Chinese Medicine. Sensors, 24(13), 4046.
Baseer, K. K., Sivakumar, K., Veeraiah, D., Chhabra, G., Lakineni, P. K., Pasha, M. J., … and Harikrishnan, G. (2024). Healthcare diagnostics with an adaptive deep learning model integrated with the Internet of medical Things (IoMT) for predicting heart disease. Biomedical Signal Processing and Control, 92, 105988.
Raman, R., Verma, M. A., Kumar, V., Rastogi, S., Pillai, B. G., and Meenakshi, R. (2024, May). Fog Computing Integrated with and Blockchain Technology for Accurate Disease Prediction. In 2024 4th International Conference on Advance Computing and Innovative Technologies in Engineering (ICACITE) (pp. 677–682). IEEE.
Kasula, B. Y. (2023). The Role of Blockchain Technology in Securing Electronic Health Records. Transactions on Latest Trends in Artificial Intelligence, 4(4).
Thatikonda, R., Vaddadi, S. A., and Dash, B. (2024). Applications of blockchain technology in healthcare. In Research Advances in Network Technologies (pp. 189–205). CRC Press.
Hyrynsalmi, S., Hyrynsalmi, S. M., and Kimppa, K. K. (2021). The state of the art of the blockchain ethics in healthcare: A systematic literature review. Finnish Journal of eHealth and eWelfare, 13(3), 193–206.
Dubey, S., and Tiwary, A. K. (2023, June). Smart Education based on Blockchain Technology. In 2023 International Conference on Sustainable Computing and Smart Systems (ICSCSS) (pp. 1485–1490). IEEE.
Kumar, A., Singh, A. K., Ahmad, I., Kumar Singh, P., Anushree, Verma, P. K., … and Tag-Eldin, E. (2022). A novel decentralized blockchain architecture for the preservation of privacy and data security against cyberattacks in healthcare. Sensors, 22(15), 5921.
Healthcare database technologies with blockchain.
Attaran, M. (2022). Blockchain technology in healthcare: Challenges and opportunities. International Journal of Healthcare Management, 15(1), 70–83.
Haleem, A., Javaid, M., Singh, R. P., Suman, R., and Rab, S. (2021). Blockchain technology applications in healthcare: An overview. International Journal of Intelligent Networks, 2, 130–139.
Zaabar, B., Cheikhrouhou, O., Jamil, F., Ammi, M., and Abid, M. (2021). HealthBlock: A secure blockchain-based healthcare data management system. Computer Networks, 200, 108500.
Hussien, H. M., Yasin, S. M., Udzir, N. I., Ninggal, M. I. H., and Salman, S. (2021). Blockchain technology in the healthcare industry: Trends and opportunities. Journal of Industrial Information Integration, 22, 100217.
Al-Marridi, A. Z., Mohamed, A., and Erbad, A. (2024). Optimized blockchain-based healthcare framework empowered by mixed multi-agent reinforcement learning. Journal of Network and Computer Applications, 224, 103834.
Alijoyo, F. A., Prabha, B., Aarif, M., Fatma, G., and Rao, V. S. (2024, July). Blockchain-Based Secure Data Sharing Algorithms for Cognitive Decision Management. In 2024 International Conference on Electrical, Computer and Energy Technologies (ICECET (pp. 1–6). IEEE.
Hakimi, N., Fathi, Z., and Pourbahrami, B. (2024). Application of Metacombination Technique in the Financial Flow Based on Blockchain Technology in the Hospital Ecosystem. Dynamic Management and Business Analysis, 2(4), 74–93.
Mutambik, I., Lee, J., Almuqrin, A., and Alharbi, Z. H. (2024, January). Identifying the Barriers to Acceptance of Blockchain-Based Patient-Centric Data Management Systems in Healthcare. In Healthcare (Vol. 12, No. 3, p. 345). MDPI.
Rastogi, P., Singh, D., and Bedi, S. S. (2024). An improved blockchain framework for ORAP verification and data security in healthcare. Journal of Ambient Intelligence and Humanized Computing, 1–16.
Kumari, D., Parmar, A. S., Goyal, H. S., Mishra, K., and Panda, S. (2024). Healthrec-chain: patient-centric blockchain enabled ipfs for privacy preserving scalable health data. Computer Networks, 241, 110223.
SQL based data management in healthcare.
Kotsilieris, T. (2021, March). An efficient agent based data management method of NoSQL environments for health care applications. In Healthcare (Vol. 9, No. 3, p. 322). MDPI.
Sharma, D. P., Lashkari, A. H., and Parizadeh, M. (2024). Understanding Cybersecurity Management in Healthcare. Progress in IS.
Tripathi, A., Waqas, A., Venkatesan, K., Yilmaz, Y., and Rasool, G. (2024). Building flexible, scalable, and machine learning-ready multimodal oncology datasets. Sensors, 24(5), 1634.
Karras, A., Giannaros, A., Karras, C., Theodorakopoulos, L., Mammassis, C. S., Krimpas, G. A., and Sioutas, S. (2024). TinyML algorithms for Big Data Management in large-scale IoT systems. Future Internet, 16(2), 42.
Nagabhooshanam, N., Murthy, C. R., and CosioBorda, R. F. (2023). Neural network based single index evaluation for SQL injection attack detection in health care data. Measurement: Sensors, 27, 100779.
Doniec, R., Berepiki, E. O., Piaseczna, N., Sieciñski, S., Piet, A., Irshad, M. T., … and Glinkowski, W. (2024). Cardiovascular Disease Preliminary Diagnosis Application Using SQL Queries: Filling Diagnostic Gaps in Resource-Constrained Environments. Applied Sciences, 14(3), 1320.
Zhang, M., Ji, Z., Luo, Z., Wu, Y., and Chai, C. (2024, May). Applications and challenges for large language models: From data management perspective. In 2024 IEEE 40th International Conference on Data Engineering (ICDE) (pp. 5530–5541). IEEE.
Kathiravan, M., Lakshmi, I., Durga, V. S., Saravanan, S., Vijayakumar, M., and Bharathiraja, N. (2024, February). Java-Powered Digital Healthcare Management: innovating Medical Administration Systems. In 2024 IEEE International Conference on Computing, Power and Communication Technologies (IC2PCT) (Vol. 5, pp. 1333–1338). IEEE.
Walid, R., Joshi, K. P., and Choi, S. G. (2024). Leveraging semantic context to establish access controls for secure cloud-based electronic health records. International Journal of Information Management Data Insights, 4(1), 100211.
Zhong, C., Darbandi, M., Nassr, M., Latifian, A., Hosseinzadeh, M., and Navimipour, N. J. (2024). A new cloud-based method for composition of healthcare services using deep reinforcement learning and Kalman filtering. Computers in Biology and Medicine, 172, 108152.



