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

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

作　　者：花琦琦 刘新凤[2] 焦青[1] 崔栋[1] 薛雅卓[3] 董蓉蓉[3] 陈晓凤[3] 郭永新[1] 

机构地区：[1]泰山医学院放射学院电子与电工技术教研室,山东泰安271016 [2]山东省泰山疗养院内分泌科,山东泰安271000 [3]泰山医学院护理学院护理学基础教研室,山东泰安271016

出　　处：《中国医学物理学杂志》2016年第11期1183-1188,共6页Chinese Journal of Medical Physics

基　　金：国家自然科学基金(81371531);山东省高等学校科技计划项目(J14LK55);泰安市科技发展计划(2015NS2073;201440774)

摘　　要：目的:为了对糖尿病患者丰富的临床检查信息进行有效管理,建立一个糖尿病信息管理与分析系统,可实现糖尿病患者实验室检查及量表测试的信息存储、查询及量表测试的数据分析。方法:运用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.

关 键 词：糖尿病 SQL SERVER 数据库 数据分析处理 

分 类 号：TP315[自动化与计算机技术—计算机软件与理论] R587.1[自动化与计算机技术—计算机科学与技术]