基于SQL Server的糖尿病信息管理与分析系统

Information management and analysis system for diabetes mellitus based on SQL Server

目的:为了对糖尿病患者丰富的临床检查信息进行有效管理,建立一个糖尿病信息管理与分析系统,可实现糖尿病患者实验室检查及量表测试的信息存储、查询及量表测试的数据分析。方法:运用SQL Server作为后台数据库完成数据的存储,以Visual Studio C++6.0作为开发语言,通过Active X数据对象媒介连接数据库,再运用SQL查询语句对相应字段进行精确查询,采用简单易行的添加消息映射实现对糖尿病量表数据的分析计算功能。结果:系统包括数据库管理、信息管理、信息查询及数据分析4大模块,可实现糖尿病患者检查数据的增添、删改及查询功能,并可实现量表测试的分析。结论:系统界面友好,易于操作,利用已完成的数据分析系统进行糖尿病患者信息的管理、查询及量表测试的分析,有助于糖尿病相关的临床、教学及科研工作。

Objective To manage the clinical examination information of diabetic patients by establishing an information management and analysis system for diabetes mellitus which realizes the storage and query of the information of laboratory examination and scale test, and the data analysis of scale test. Methods SQL Server was used as the database to complete the storage of the data, and Visual Studio C＋＋6.0 was used as the development language. The databases were linked by ActiveX data objects media. The SQL query statement was instructed to realize the exact queries to corresponding field. Calculation of diabetic scale data was completed by adding a message mapping. Results The system had four models, including database management, information management, information query and data analysis, which realized the adding, deletion and searching of the data in the database, and the calculation of scale test. Conclusion With a friendly interface, easy to operate, the proposed system is helpful in the clinical, teaching and research work about diabetes mellitus by realizing the management and query of the information of diabetic patients, and the analysis of scale test.