Construction of an Integrated Intelligent Database Platform for Antimicrobial-Resistant Strains

Abstract

Abstract:Antimicrobial resistance (AMR) poses a severe global public health threat, causing over 700,000 deaths annually. The fragmentation of AMR data hinders comprehensive research, clinical decision-making, and public health surveillance. Existing databases like CARD and CARSS often suffer from data silos, limited analytical tools, and insufficient localized data. This study aims to construct an integrated, operable database for drug-resistant bacterial strains to support AMR research and control.Methods:The study involved: (1) Systematic collection of data on resistant bacteria, genomes, and antimicrobial substances from public databases and literature; (2) Design of a relational database structure following normalization paradigms (1NF, 2NF, 3NF) and implementation using MySQL; (3) Data processing and batch import via Python and pandas; (4) Development of an interactive web platform using the Flask framework, with front-end interfaces built using HTML, CSS, JavaScript, and Layui for data overview, query, statistical visualization, and download.Results:A fully functional and locally deployable database website was successfully constructed. The system supports efficient data querying, dynamic statistical visualization (including pie charts for species distribution and bar charts for top proteins and drug classes), and data export. The platform integrates multi-source resistance data and offers a user-friendly interface for real-time data access and analysis, providing a practical tool for researchers and clinicians.Conclusion:This study developed a comprehensive and scalable database for drug-resistant bacteria, facilitating the centralized management and analysis of AMR data. The database aids in understanding resistance mechanisms, guiding clinical treatment, and informing public health strategies. Future work will focus on expanding data coverage, incorporating AI-driven analysis, and enhancing system automation and security to further support the global fight against antimicrobial resistance.