基于REDCap嗅觉障碍患者交互式电子数据库的设计

doi:10.6040/j.issn.1673-3770.0.2021.051

摘要/Abstract

摘要： 目的采用REDCap设计嗅觉障碍患者长期随访管理交互式共享电子数据库。方法基于嗅觉障碍患者随访管理的实际需要,使用西安交通大学开放研究数据平台提供的中文版REDCap临床研究数据收集系统,以患者基本资料、嗅觉障碍自我评估表、检查结果、医师评估表及治疗情况为主要内容,以治疗前,治疗后1个月、3个月、6个月、1年为5个事件采集点,设置和创建问卷工具表单,设置数据质量控制程序,设置用户使用权限,建立交互式共享电子数据库。结果按预定目标实现了上述交互式共享电子数据库的设计并投入临床使用。该数据库可实现多地点多终端同时输入,可实现医疗数据录入、质控及权限管理,可构建随访工作日历。结论运用REDCap搭建嗅觉障碍患者交互式共享电子数据库,设计流程简单、操作容易、信息收集完整,为耳鼻喉科医师开展嗅觉障碍相关临床研究提供一个免费、便利、高效及标准化的数据管理工具。

关键词: REDCap, 嗅觉障碍, 随访, 数据库, 电子数据采集系统

Abstract: Objective The application of REDCap to design an interactive shared electronic database for long-term follow-up management of olfactory disorder patients. Methods Based on the actual needs of follow-up management of patients with olfactory disorders, the Chinese version of REDCap clinical research data collection system provided by Xi'an Jiaotong University open research data platform was used. The main contents of the database include basic information of patients, olfactory dysfunction self-assessment form, examination results, physician assessment form and treatment. The database contains five event collection points, including before treatment, 1 month after treatment, 3 months after treatment, 6 months after treatment and 1 year after treatment. According to the above contents, set up and create questionnaire tool form, data quality control program, user permissions, and establish interactive sharing electronic database. Results According to the predetermined goal, the interactive sharing electronic database for olfactory disorder patients was designed and put into clinical use. The database can realize multi locations and multi terminal inputs at the same time, realize medical data entry, quality control and authority management, and construct follow-up work calendar. Conclusion The applicatiom of REDCap to build an interactive sharing electronic database for olfactory disorders patients has the advantages of simple design process, easy operation and comprehensive information collection. It provides a free, convenient, efficient and standardized data management tool for otolaryngologists to carry out olfactory disorders related clinical research.

Key words: REDCap, Olfactory dysfunction, Follow up, Database, Electronic data capture

中图分类号:

R765

喻超,陈敬国,米白冰,祝康,夏翠,高天喜,张燕妮,孙斌,任晓勇. 基于REDCap嗅觉障碍患者交互式电子数据库的设计[J]. 山东大学耳鼻喉眼学报, 2022, 36(2): 15-19.

YU Chao, CHEN Jingguo, MI Baibing, ZHU Kang, XIA Cui, GAO Tianxi, ZHANG Yanni, SUN Bin, REN Xiaoyong. The application of REDCap to design interactive electronic database for olfactory disorder patients[J]. Journal of Otolaryngology and Ophthalmology of Shandong University, 2022, 36(2): 15-19.

参考文献

[1] 倪道凤. 嗅觉障碍和嗅觉功能检查[J]. 临床耳鼻咽喉科杂志, 2003, 17(9): 571-575. doi:10.3969/j.issn.1001-1781.2003.09.044.
[2] 杨秀芬, 尤冉, 马秀梅, 等. 以医院为基础的中心性浆液性脉络膜视网膜病变流行病学调查及危险因素的研究[J]. 山东大学耳鼻喉眼学报, 2020, 34(4): 75-79. doi:10.6040/j.issn.1673-3770.1.2020.046. YANG Xiufen, YOU Ran, MA Xiumei, et al. Prevalence and risk factors of central serous chorioretinopathy in a hospital-based population[J]. Journal of Otolaryngology and Ophthalmology of Shandong University, 2020, 34(4): 75-79. doi:10.6040/j.issn.1673-3770.1.2020.046.
[3] 李超凡, 张立红, 王文伦, 等. 耳鼻咽喉科门诊患者咽喉反流性疾病、焦虑抑郁患病率及二者关系[J]. 中华耳鼻咽喉头颈外科杂志, 2020, 55(3): 241-248. doi:10.3760/cma.j.issn.1673-0860.2020.03.010. LI Chaofan, ZHANG Lihong, WANG Wenlun, et al. The prevalence and relationship between laryngopharyngeal reflux disease, anxiety and depression in otolaryngology outpatients[J]. Chinese Journal of Otorhinolaryngology Head and Neck Surgery, 2020, 55(3): 241-248. doi:10.3760/cma.j.issn.1673-0860.2020.03.010.
[4] Read K, LaPolla FWZ. A new hat for librarians: providing REDCap support to establish the library as a central data hub[J]. J Med Libr Assoc, 2018, 106(1): 120-126. doi:10.5195/jmla.2018.327.
[5] Research Electronic Data Capture. Homepage[EB/OL]. [2020-12-31]. https://projectredcap.org.
[6] 张彬艳, 米白冰, 武文韬, 等. 基于REDCap的妊娠期高血压危险因素监测交互式在线调查系统的设计[J]. 西安交通大学学报(医学版), 2020, 41(4): 612-616. doi:10.7652/jdyxb202004026. ZHANG Binyan, MI Baibing, WU Wentao, et al. Application of research electronic data capture in an interactive online survey system for monitoring hypertension risk factors during pregnancy[J]. Journal of Xi'an Jiaotong University(Medical Sciences), 2020, 41(4): 612-616. doi:10.7652/jdyxb202004026.
[7] 李蒙, 田国祥, 贺海蓉, 等. 如何利用REDCap实现重复测量数据的录入及管理[J]. 中国循证心血管医学杂志, 2018, 10(6): 647-650. doi:10.3969/j.issn.1674-4055.2018.06.02. LI Meng, TIAN Guoxiang, HE Hairong, et al. How to realize the repeated measurement data entry and management in usage of the Research Electronic Data Capture REDCap system[J]. Chinese Journal of Evidence-Based Cardiovascular Medicine, 2018, 10(6): 647-650. doi:10.3969/j.issn.1674-4055.2018.06.02.
[8] 贺海蓉, 田国祥, 任晓东, 等. 如何利用REDCap实现临床试验的随机化操作[J]. 中国循证心血管医学杂志, 2018, 10(9): 1039-1042. doi:10.3969/j.issn.1674-4055.2018.09.03. HE Hairong, TIAN Guoxiang, REN Xiaodong, et al. How to realize the randomization in clinical trials using the Research Electronic Data Capture REDCap system[J]. Chinese Journal of Evidence-Bases Cardiovascular Medicine, 2018, 10(9): 1039-1042. doi:10.3969/j.issn.1674-4055.2018.09.03.
[9 ] 耿辉, 贺海蓉, 郑婕, 等. 多中心临床数据采集系统REDCap权限设置与管理[J]. 中国循证心血管医学杂志, 2018, 10(1): 11-13. doi:10.3969/j.issn.1674-4055.2018.01.02. GENG Hui, HE Hairong, ZHENG Jie, et al. Permission setting and management of REDCap system for multi- center clinical data acquisition system[J]. Chinese Journal of Evidence-Bases Cardiovascular Medicine, 2018, 10(1): 11-13. doi:10.3969/j.issn.1674-4055.2018.01.02.
[10] 陶丹丹, 董红军, 褚云锋, 等. 慢性鼻-鼻窦炎伴鼻息肉患者组织嗜酸性粒细胞与嗅觉功能障碍的相关性研究[J]. 山东大学耳鼻喉眼学报, 2020, 34(6): 16-20. doi:10.6040/j.issn.1673-3770.0.2019.388. TAO Dandan, DONG Hongjun, CHU Yunfeng, et al. Correlation between eosinophils and olfactory dysfunction in patients with CRSwNP after nasal operation[J]. Journal of Otolaryngology and Ophthalmology of Shandong University, 2020, 34(6): 16-20. doi:10.6040/j.issn.1673-3770.0.2019.388.
[11] Tomko RL, Gray KM, Oppenheimer SR, et al. Using REDCap for ambulatory assessment: Implementation in a clinical trial for smoking cessation to augment in-person data collection[J]. Am J Drug Alcohol Abuse, 2019, 45(1): 26-41. doi:10.1080/00952990.2018.1437445.
[12] 姚宏伟, 张忠涛. 基于规范化的临床实践和数据管理做好中国结直肠外科的临床研究[J]. 中华消化外科杂志, 2019, 18(1): 31-34. doi:10.3760/cma.j.issn.1673-9752.2019.01.007. YAO Hongwei, ZHANG Zhongtao. Clinical research on colorectal surgery in China based on standardized clinical practice and data management[J]. Chinese Journal of Digestive Surgery, 2019, 18(1): 31-34. doi:10.3760/cma.j.issn.1673-9752.2019.01.007.
[13 ] Harris PA, Taylor R, Thielke R, et al. Research electronic data capture(REDCap): a metadata-driven methodology and workflow process for providing translational research informatics support[J]. JBiomed Inform, 2009, 42(2): 377-381. doi:10.1016/j.jbi.2008.08.010.
[14] Harris P. Research Electronic Data Capture(REDCap)- planning, collecting and managing data for clinical and translational research[J]. BMC Bioinformatics, 2012, 13(suppl 12): A15. doi:10.1186/1471-2105-13-s12-a15.
[15] 庞晓清. 基于REDCap的急性呼吸窘迫综合征/脓毒症数据库构建及其应用[D]. 广州:广州医科大学, 2014.
[16] Read KB, LaPolla FW, Tolea MI, et al. Improving data collection, documentation, and workflow in a dementia screening study[J]. J Med Libr Assoc, 2017, 105(2): 160-166. doi:10.5195/jmla.2017.221.
[17] Altieri MS, Yang J, Wang L, et al. Surgeons' perceptions on industry relations: a survey of 822 surgeons[J]. Surgery, 2017, 162(1): 164-173. doi:10.1016/j.surg.2017.01.010.
[18] Franklin JD, Guidry A, Brinkley JF. A partnership approach for Electronic Data Capture in small-scale clinical trials[J]. J Biomed Inform, 2011, 44(Suppl 1): S103-S108. doi:10.1016/j.jbi.2011.05.008.
[19] Dargie JM, Zhou GW, Dornan BK, et al. Vestibular evoked myogenic potential testing for the diagnosis of conductive hearing loss: survey of pediatric otolaryngologists' knowledge and beliefs[J]. Int J Pediatr Otorhinolaryngol, 2014, 78(11): 1937-1939. doi:10.1016/j.ijporl.2014.08.029.

多维度评价

Viewed

Full text

Abstract

Cited

Shared

Discussed

[1]	李丹, 陈腾宇, 黄演芬, 周敏, 周熠星, 阮岩, 闫亚杰. 国内嗅觉障碍相关研究——基于Citespace的可视化分析[J]. 山东大学耳鼻喉眼学报, 2022, 36(4): 40-48.
[2]	姜超,周炫辰,韩杰,岳志勇. IVc期下咽癌特征分析及列线图预后模型构建[J]. 山东大学耳鼻喉眼学报, 2022, 36(4): 49-54.
[3]	王欢,胡俐,余洪猛. 慢性鼻窦炎相关嗅觉功能障碍研究进展[J]. 山东大学耳鼻喉眼学报, 2022, 36(3): 43-49.
[4]	曾宪廷,王广科,孙占伟,武天义,李世超,王卫卫. 伴咽喉反流的难治性鼻窦炎术后应用质子泵抑制剂的疗效观察[J]. 山东大学耳鼻喉眼学报, 2022, 36(3): 189-194.
[5]	薛刚,孙新民,林旭,吴靖芳. KCNK5双孔钾通道蛋白在甲状腺乳头状癌中的表达及临床意义[J]. 山东大学耳鼻喉眼学报, 2021, 35(4): 64-69.
[6]	黄俊伟,陈学军,刘宏飞,陶冶,李祖飞,陈平,张洋. 细胞周期蛋白E2在下咽癌中的表达及其意义[J]. 山东大学耳鼻喉眼学报, 2020, 34(5): 132-137.
[7]	杨微,郑莉,许志飞. 中重度阻塞性睡眠呼吸暂停低通气综合征儿童无创正压[J]. 山东大学耳鼻喉眼学报, 2018, 32(2): 19-24.
[8]	张立庆,宋圣花,王愿,刘晓静,董伟达,周涵. 低温等离子刀、超声刀及传统方式行扁桃体切除术的术后两年随访比较[J]. 山东大学耳鼻喉眼学报, 2017, 31(5): 67-71.
[9]	张霞1，夏立军2. 20例慢性鼻-鼻窦炎鼻内镜术后随访及生活质量研究[J]. 山东大学耳鼻喉眼学报, 2012, 26(2): 51-54.
[10]	刘庆华1，李志春2. 慢性鼻窦炎嗅觉障碍嗅上皮中IGF-1R和Ki-67的表达及意义[J]. 山东大学耳鼻喉眼学报, 2011, 25(3): 55-.
[11]	刘婷婷张念凯. 药物治疗慢性鼻-鼻窦炎嗅觉障碍的疗效观察[J]. 山东大学耳鼻喉眼学报, 2009, 23(4): 45-47.
[12]	杨彩虹1 ，肖二彬2 . 功能性鼻内镜手术对慢性鼻窦炎患者嗅觉的影响[J]. 山东大学耳鼻喉眼学报, 2009, 23(2): 56-58 .
[13]	邱恩惠,李志春,方文旭 . 嗅觉障碍的中西医治疗[J]. 山东大学耳鼻喉眼学报, 2008, 22(3): 253-257 .
[14]	颜永毅,谢佳 . 慢性鼻-鼻窦炎术后随访的对比观察[J]. 山东大学耳鼻喉眼学报, 2007, 21(1): 43-45 .
[15]	刘庆华,李瑞玉,李志春,林昶 . 成纤维生长因子2在慢性鼻窦炎嗅觉障碍嗅上皮中的表达[J]. 山东大学耳鼻喉眼学报, 2006, 20(5): 410-412 .