AI-Driven Database Sharding Strategies for Nationwide Prescription Drug Monitoring Programs

Authors

  • Karan Radadiya PhD, Information Technology, University of the Cumberlands, KY, USA Author

DOI:

https://doi.org/10.56830/IJSIE202620

Keywords:

AI-Driven Sharding, Prescription Drug Monitoring Programs (PDMPs), Database Scalability, Healthcare Data Security

Abstract

Prescription Drug Monitoring Programs (PDMPs) are databases of prescription information that are used to assist in the monitoring of controlled substances. As more data accumulates and cross-shard queries increase, traditional database architecture can easily lead to an imbalanced workload, increased cross-shard queries, and delayed responses to jurisdictional needs. The objective of the study is to share a national PDMP data management system based on artificial intelligence (AI). It has a hierarchical partitioning structure, with geographic jurisdiction as the lowest (first) level in the hierarchy, and the patient identifier is hashed within each jurisdiction. Historical retrieval is supported by temporal indexing, and risk classifications are metadata rather than shards. Short-term (Days) workload predictions are made using query activity and resource metrics with a regression model named XGBoost. The forecasts determine where hotspots will be found and where they should be placed. Access was governed through jurisdiction-aware query routing, role- and attribute-based access controls, and audit logging. Rebalancing is performed with hysteresis and migration costs to minimise data movement during rebalancing. The methodology is based on a comparative evaluation using synthetically generated PDMP-like data in a PostgreSQL-Citus environment. Static and adaptive configurations are evaluated based on query latency, query throughput, shard-load distribution, forecasting error, hotspot detection and rebalancing overhead. The framework offers methods to handle PDMP data at scale. No quantitative improvement in performance or clinical outcome is claimed, as there are no operational measurements. More testing with workloads and approved operational data is required before deployment.

References

Chadha, K. S. (2025). Machine learning–augmented ETL pipelines for fraud-resistant insurance claims processing. International Journal of Data Science and Machine Learning, 5(1), 410–436. https://doi.org/10.55640/ijdsml-05-01-30

Chadha, K. S., Vennamaneni, P. R., & Sardana, J. (2025). Leveraging advanced analytics and AI-powered solutions for transforming healthcare and retail e-commerce: Enhancing data security, personalization, and compliance. International Journal of Applied Mathematics, 38(9s), 1310–1334. https://doi.org/10.12732/ijam.v38i9s.862

Dhanagari, M. R. (2025). Aerospike vs traditional databases: Solving the speed vs. consistency dilemma. International Journal of Computational and Experimental Science and Engineering, 11(3). https://doi.org/10.22399/ijcesen.3780

Durgam, S. (2025). Peer benchmarking systems for RIA performance evaluation in investment technology. Computer Fraud & Security. https://computerfraudsecurity.com/index.php/journal/article/view/785

Gadde, H. (2022). AI in dynamic data sharding for optimized performance in large databases. International Journal of Machine Learning Research in Cybersecurity and Artificial Intelligence, 13(1), 413–440. https://www.academia.edu/download/119017192/413_440_ijmlrcai_2022.pdf

Gundla, S. R. (2025a). AI-augmented testing: GitHub Copilot for JUnit/Mockito generation. Computer Fraud & Security. https://computerfraudsecurity.com/index.php/journal/article/view/784

Gundla, S. R. (2025b). PostgreSQL tuning for cloud-native Java: Connection pooling vs. reactive drivers. International Journal of Computational and Experimental Science and Engineering. https://ijcesen.com/index.php/ijcesen/article/view/3479

Hariharan, R. (2024). API gateway threat prevention in large-scale applications. SciPubHouse. https://scipubhouse.com/wp-content/uploads/2025/10/011- API_gateway_threat_prevention_in_large-scale_applications.pdf

Hariharan, R. (2025). AI-driven identity and access management in enterprise systems. International Journal of Internet of Things. https://www.academicpublishers.org/journals/index.php/ijiot/article/view/4300

Jha, C., Gannavarapu, P., & Durgam, S. (2025). Machine learning-driven security system for next-generation ultra-low-latency financial network governance. IEEE. https://ieeexplore.ieee.org/abstract/document/11374574

Jhawar, R., & Piuri, V. (2017). Fault tolerance and resilience in cloud computing environments. In J. R. Vacca (Ed.), Computer and information security handbook (pp. 155–173). Morgan Kaufmann. https://doi.org/10.1016/B978-0-443-13223-0.00009-6

Khatiwada, P., Yang, B., Lin, J. C., & Blobel, B. (2024). Patient-generated health data (PGHD): Understanding, requirements, challenges, and existing techniques for data security and privacy. Journal of Personalized Medicine, 14(3), 282. https://doi.org/10.3390/jpm14030282

Kim, I. K., Wang, W., Qi, Y., & Humphrey, M. (2022). Forecasting cloud application workloads with CloudInsight for predictive resource management. IEEE Transactions on Cloud Computing, 10(3), 1848–1863. https://drive.google.com/file/d/17MLIufoh5OVAlw3qu62qCF4jtMaiBCDW/view

Kumar, N. (2025a). Accessibility first design systems for multi-brand food apps. American Journal of Technology, 4(3). https://doi.org/10.58425/ajt.v4i3.457

Kumar, N. (2025b). Edge computing patterns for real-time order flow optimization. International Journal of Applied Mathematics, 38(12s). https://doi.org/10.12732/ijam.v38i12s.1494

Lingamgunta, R. K. K., Ubale, A., & Vanama, S. K. R. (2025). Edge AI for on-site health risk scoring: A RAG-enabled framework. American Journal of Technology, 4(3), 1–14. https://doi.org/10.58425/ajt.v4i3.451

Nangi, P. R., & Obannagari, C. K. R. N. (2024). High-performance distributed database partitioning using machine learning-driven workload forecasting and query optimization. American International Journal of Computer Science and Technology, 6(2), 11–21. https://aijcst.org/index.php/aijcst/article/download/132/117

Oliva, J. D. (2019). Prescription-drug policing: The right to health information privacy preand post-Carpenter. Duke Law Journal, 69, 775. https://scholarship.law.duke.edu/cgi/viewcontent.cgi?article=4007&context=dlj

Rangu, S. (2025a). Analyzing the impact of AI-powered call center automation on operational efficiency in healthcare. Journal of Information Systems Engineering and Management. https://www.jisem-journal.com/index.php/journal/article/view/8901

Rangu, S. (2025b). Enterprise digital transformation in financial services: Emerging trends and technologies. Computer Fraud & Security. https://computerfraudsecurity.com/index.php/journal/article/view/786

Samala, S. (2025a). Architecting multi-instance Jira deployments: Scalability challenges for global enterprises. International Journal of Engineering Applications. https://gprjournals.org/journals/index.php/ijea/article/view/353

Samala, S. (2025b). Reducing release failures by 35%: A case study on Jira–Jenkins–Azure DevOps integration. Journal of Information Systems Engineering and Management. https://www.jisem-journal.com/index.php/journal/article/view/8904

Sardana, J., Chadha, K. S., & Durgam, S. (2025). Advancing healthcare technology through secure data systems. International Journal of Applied Mathematics, 38(10s). https://doi.org/10.12732/ijam.v38i10s.1138

Ubale, A. (2025). Privacy-preserving federated learning frameworks for telematics data in auto insurance analytics. International Journal of Artificial Intelligence, Data Science, and Machine Learning, 6(4), 41–48. https://ijaidsml.org/index.php/ijaidsml/article/view/314

Vanama, S. K. R. (2023). Integrating site reliability engineering (SRE) principles into enterprise architecture for predictive resilience. International Journal of Emerging Trends in Computer Science and Information Technology, 4(3), 164–170. https://ijetcsit.org/index.php/ijetcsit/article/view/514

Vanama, S. K. R. (2024). AI-augmented CI/CD pipeline optimization for scalable cloudnative deployment. International Journal of Artificial Intelligence, Data Science, and Machine Learning, 5(4), 175–187. https://ijaidsml.org/index.php/ijaidsml/article/view/368

Vishwakarma, S. K. (2025a). Circular economy in aerospace: Recycling composites and rare metals. International Journal of Management, Business, and Development. https://aimjournals.com/index.php/ijmbd/article/view/102

Vishwakarma, S. K. (2025b). Sustainable aviation fuel (SAF) procurement challenges. Journal of Information Systems Engineering and Management. https://www.jisemjournal.com/index.php/journal/article/view/9420

Zhang, Y., Zhao, K., Yang, Y., & Zhou, Z. (2025). Real-time service migration in edge networks: A survey. Journal of Sensor and Actuator Networks, 14(4), 79. https://www.mdpi.com/2224-2708/14/4/79

Downloads

Published

2026-11-18

Issue

Section

Articles