低钾血症患者信息管理系统的构建

发布时间：2018-06-12 01:43

本文选题：低钾血症 + 数据库　；参考：《安徽医科大学》2015年硕士论文

【摘要】：目的:建立一个低钾血症患者信息管理系统专病数据库,全面收集低钾血症相关的病历资料,为临床医疗和科研创建有力的平台。方法:利用Microsoft Access 2010软件设计和建立低钾血症患者信息管理系统数据库。首先,根据需求调研,初步设定数据库的功能版块和录入信息的条目;然后根据设定的条目信息建立用于存储数据资料的表格,准确设置每一个字段的属性,使其尽可能的达到结构化和标准化地录入,减少手动输入的录入方式,设定各表的主键;将一般信息表通过“身份证号”与其他各数据表的“身份证号”建立起“一对多”的关系;将用于信息录入的各表作为记录源建立对应的窗体;建立基于各数据表的组合查询。结果:成功建立了低钾血症患者信息管理系统数据库。打开数据库首先进入“登录界面”,正确输入用户信息后进入数据库的“主页”,“主页”包含录入、随访、查询、帮助和用户管理五大功能版块,其中“录入”版块包含患者一般信息、临床表现、近期用药史、伴随疾病、实验室检查等功能按钮,点击各按钮则进入相应的各录入窗体或子菜单。本数据库可对患者一般资料、临床表现、用药史、伴随疾病、实验室检查的各字段进行组合查询,数据可以直接对接SPSS软件,也可以将查询的结果导出为Excel文件,通过运用SPSS、SAS等统计软件,进而将这些导出的数据进行复杂的统计分析。帮助版块提供本数据库的使用说明信息,用户管理版块可以添加、删除、编辑和修改用户信息。总体来说,本数据库可以全面而准确地收集低钾血症患者的初诊和随访的相关病历资料,数据能够导出,便于数据的统计和管理,运行稳定,数据错误和丢失等情况尚未出现,给日常的临床工作和科学研究带来了极大的方便。结论:1、低钾血症患者信息管理系统能可以全面而准确地收集低钾血症患者的初诊和随访的相关病历资料,给繁杂的低钾血症患者病历信息准确、便捷的录入提供便利,便于患者信息的管理。2、本数据库界面友好、简洁,易于操作,即使不太熟悉计算机的人也能轻松上手。3、结构化标准化的字段设计,确保了数据录入的准确性,避免了数据的杂乱无章,便于检索和使用。4、数据可以直接对接SPSS软件,也可以将查询的结果导出为Excel文件,通过运用SPSS、SAS等统计软件,进而将这些导出的数据进行复杂的统计分析。5、可以实现日常工作和科研积累的有机结合,并能达到“滚雪球”效应,为后续的研究积累大量的资料。6、将和医院HIS系统实现对接,减少数据的录入量,提高利用率,可以广泛地应用于门诊和病房,未来将进一步接入互联网,和低钾血症网络诊断平台互为补充,实现网络资源的共享。
[Abstract]:Objective: to set up a database of information management system for patients with hypokalemia, collect the medical records of hypokalemia, and establish a powerful platform for clinical medical treatment and scientific research. Methods: the database of information management system for patients with hypokalemia was designed and established by Microsoft Access 2010 software. First of all, according to the requirement investigation, we initially set up the functional section of the database and the entry of the input information. Then, according to the set item information, we set up a table to store the data, and set up the attributes of each field accurately. Make it as structured and standardized input as possible, reduce the manual input way, set the primary key of each table; A "one-to-many" relationship is established between the general information table and the ID number of other data tables through "ID number"; each table used for information input is used as a record source to establish a corresponding form; and a combination query based on each data table is established. Results: the database of information management system for patients with hypokalemia was established successfully. Open the database first into the "login interface", enter user information correctly and enter the database's "home page". The "home page" contains five functional sections: input, follow up, query, help and user management. The "input" section contains general information of patients, clinical manifestations, recent drug history, associated diseases, laboratory examination and other functional buttons. Click on each button to enter the corresponding input form or submenu. This database can query the general information of patients, clinical manifestations, history of medication, associated diseases, laboratory examination fields. The data can be directly connected with SPSS software, or the results of the query can be exported to Excel files. By using SPSS SAS and other statistical software, the derived data are analyzed. Help section provides instructions for the use of this database, user management section can add, delete, edit and modify user information. In general, this database can collect the relevant medical records of the patients with hypokalemia at first visit and follow-up, and the data can be exported, which is convenient for the statistics and management of the data, runs stably, and the data errors and losses have not yet occurred. It brings great convenience to daily clinical work and scientific research. Conclusion the information management system of hypokalemia patients can collect the relevant medical records of the patients with hypokalemia at first visit and follow up, and provide convenience for the complicated patients with hypokalemia. The database interface is friendly, simple, easy to operate, even those who are not familiar with the computer can easily use. 3, structured standardized field design, to ensure the accuracy of data entry, The data can be easily retrieved and used. The data can be directly docked with SPSS software, and the results of the query can also be exported to Excel files. Through the use of statistical software such as SPSS SAS, Furthermore, the complicated statistical analysis of these derived data. 5 can realize the organic combination of daily work and scientific research accumulation, and can achieve the "snowball" effect, accumulate a large amount of data for the subsequent research .6. it will link up with the hospital his system. It can be widely used in outpatient clinics and wards by reducing the data input and increasing the utilization ratio. In the future, it will be further connected to the Internet and complement each other with the hypokalemia network diagnosis platform, so as to realize the sharing of network resources.
【学位授予单位】：安徽医科大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：R591.1;R197.32

【参考文献】