AI-Driven Database Sharding Strategies for Nationwide Prescription Drug Monitoring Programs
DOI:
https://doi.org/10.56830/IJSIE202620Keywords:
AI-Driven Sharding, Prescription Drug Monitoring Programs (PDMPs), Database Scalability, Healthcare Data SecurityAbstract
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






