血吸虫病监测预警系统数据库的设计与优化

Design and Optimization of Database for Monitoring and Early Warning System in Schistosomiasis

血吸虫病的实时监测预警具有重大的意义。针对血防系统的滞后性,采用B-S架构,应用关系型数据库mysql创建血吸虫病实时监测预警平台的数据库,建立了9个实体类。通过需求分析,概念设计以及逻辑设计,将E-R关系模型转化为DBMS所支持的数据模型,并从信息安全,分类存储和约束索引三个方面对数据库进行了进一步的设计优化,有效提高了系统的性能。

Schistosomiasis real-time monitoring and early warning is of great significance.For the hysteresis of schistosomiasis controlsystem,mysql is applied to create a database of schistosomiasis surveillance and early warning platform,including the establishment of nineentities,which is based on the B-S architecture.The E-R relational model is transformed into the data model supported by DBMS withrequirement analysis,conceptual design and logic design.Then the database is further optimized from three aspects,information security,classification storage and constraint index.The performance of the system is improved effectively.