溃疡性结肠炎Access数据库的初步建立

发布时间：2018-07-09 10:19

本文选题：溃疡性结肠炎 + 专题型数据库　；参考：《大连医科大学》2014年硕士论文

【摘要】：目的：溃疡性结肠炎（Ulcerative Colitis，UC）是一种慢性复发型疾病，近年来我国病例数量逐年上升，由于临床及科研工作的迫切需求，溃疡性结肠炎病例数据的整理、存储工作就变得愈加重要。由于过去临床医生常用的Excel表格的局限性，临床病例数据的存储、整理就需要借助于更加专业化、科学化的数据库管理系统（Database Management System，DBMS）的帮助。本研究的目的是如何利用国内临床最常用的数据库管理系统——Microsoft Access设计并建立溃疡性结肠炎Access数据库，从而更加有效、合理地存储、整理、分析溃疡性结肠炎患者的临床病例数据资料，为临床及科研工作提供支持。方法：1.根据溃疡性结肠炎的临床特点，设计数据库字段，涵盖了流行病学、症状、体征、实验室检查、影像学检查、治疗方案、治疗效果等各个方面的数据，尽可能全面地收录临床病例数据。 2.根据设计好的数据库字段，将125条字段分别建立成为11个独立的数据库表，根据每一个字段的临床意义设计其数据类型，特殊类型的数据则以科学化及减轻录入劳动强度为目的，通过字段属性列表的选项来更改属性细节。 3.根据每个独立的表与表之间的逻辑关系，建立表之间关系，通过表间关系将独立的数据表合理地连接成为一体。 4.在每一个数据表的基础上建立窗体，制造图形化的用户界面，并以整洁、美观为目的将各个窗体集合建立导航窗体，同时建立密码验证登录窗体。 5.根据不同功能的需要，建立相对应的宏命令。 6.数据库框架建立完成后，利用联众数字化病案浏览器、嘉和电子病历平台、中联医院信息系统（旗舰版）临床工作部件，搜索大连医科大学附属第一医院2000年1月1日以来的以“溃疡性结肠炎”、“溃疡性结肠炎？”及“炎症性肠病”为主要诊断的既往及住院病例，，并逐个分析，对于满足以腹泻或黏液脓血便为主诉入院，辅助检查未见结直肠以外的消化道病变的病例数据录入本数据库中。结果：溃疡性结肠炎Access数据库框架建立完成，成功生成accdb格式文件并保存，登录验证、窗体打开、数据录入等各项操作均调试成功。数据库具备数据录入及存储、导入及导出、查询及报表等多项功能，同时可对数据进行分析，并以多种图表形式显示分析结果。数据库可直接应用于临床病例的存储、整理工作及科学研究工作，也可作为网络共享和教学工作的辅助工具。结论：1. Microsoft Access2010数据库管理系统可应用于建立溃疡性结肠炎临床病例数据库。 2.本数据库具有数据全面、功能完善、结构清晰、界面整洁美观、安全性高等特点。 3.本数据库为溃疡性结肠炎临床病例的收集、整理、存储、分析等工作提供了强大而有力的辅助和支持。
[Abstract]:Objective: ulcerative colitis (UC) is a chronic recurrent disease. In recent years, the number of cases in China has increased year by year. Due to the urgent need of clinical and scientific research, the storage of ulcerative colitis data becomes more and more important. Due to the limitation of Excel tables commonly used by clinicians in the past, the storage of clinical case data needs the help of a more specialized and scientific database management system (DBMS). The purpose of this study is how to design and establish Access database for ulcerative colitis by using the most commonly used database management system, Microsoft Access, in order to store and organize ulcerative colitis more effectively and reasonably. To analyze the clinical data of patients with ulcerative colitis and provide support for clinical and scientific research. Method 1: 1. According to the clinical characteristics of ulcerative colitis, the database field is designed to cover the data of epidemiology, symptoms, signs, laboratory examination, imaging examination, treatment plan, therapeutic effect, etc. Collect clinical case data as fully as possible. 2. According to the designed database fields, 125 fields are established into 11 separate database tables, and their data types are designed according to the clinical significance of each field. Special types of data for the purpose of scientific and reduce the labor intensity of input, through the field property list options to change the property details. 3. According to the logical relationship between each independent table and the table, the relationship between the tables is established, and the independent data table is reasonably joined into one by the relationship between the tables. 4. 4. Create form on the basis of each data table, create graphical user interface, and set up navigation form for the purpose of neatness and beauty, and establish password verification login form. 5. According to the needs of different functions, build the corresponding macro command. 6. After the establishment of the database framework, the clinical work components of the Zhonglian Hospital Information system (flag edition) were made up of the joint digital medical record browser, the Jiahe electronic medical record platform and the Zhonglian Hospital Information system (flagship version). Search Dalian Medical University affiliated to the first hospital since January 1, 2000 with "ulcerative colitis", "ulcerative colitis?" And "inflammatory bowel disease" as the main diagnosis of the past and hospitalized cases, and analysis one by one, for the satisfaction of diarrhea or mucus blood as the main complaint of admission, auxiliary examination of the case without colorectal lesions of the digestive tract data entered into this database. Results: the Access database framework of ulcerative colitis was set up, the accdb format file was generated and saved successfully, the logon verification, the form opened and the data input were all debugged successfully. The database has many functions, such as data input and storage, import and export, query and report, etc. At the same time, the data can be analyzed, and the analysis results can be displayed in a variety of chart forms. The database can be directly applied to the storage, arrangement and scientific research of clinical cases, and it can also be used as a supplementary tool for network sharing and teaching. Conclusion 1. Microsoft Access2010 Database Management system can be used to establish a clinical case database of ulcerative colitis. 2. This database has the characteristics of comprehensive data, perfect function, clear structure, clean and beautiful interface, high security and so on. 3. This database provides powerful assistance and support for the collection, sorting, storage and analysis of clinical cases of ulcerative colitis.
【学位授予单位】：大连医科大学
【学位级别】：硕士
【学位授予年份】：2014
【分类号】：R574.62

【参考文献】