从Oracle SQL迁移一个成熟的纵向队列数据库到研究电子数据输入 (REDCap):数据管理研究和设计研究
Katharina Kusejko1,2, Daniel Smith1, Alexandra Scherrer2
1Institute of Medical Virology, University of Zurich, Zurich, Switzerland.
JMIR formative research
|May 31, 2023
概括
这项研究成功地将瑞士母亲和儿童艾滋病毒队列研究 (MoCHiV) 的数据从Oracle SQL迁移到REDCap,从而增强了电子数据收集. 新系统提高了这一重要HIV研究的数据质量和可访问性.
科学领域:
- 医疗信息学 医疗信息学
- 流行病学 流行病学
- 艾滋病毒研究 艾滋病毒研究
背景情况:
- 大规模的多中心研究需要用户友好的电子数据收集工具,以获得高质量的研究数据.
- 自20世纪80年代以来,瑞士母婴艾滋病毒队列研究 (MoCHiV) 是一项纵向研究,历史上使用纸质数据收集.
- 研究电子数据捕获 (REDCap) 是一种软件解决方案,用于创建具有集成电子数据输入接口的研究数据库.
研究的目的:
- 在MoCHiV研究中为医生和研究护士开发一个用户友好的电子数据输入图形界面.
- 将现有的MoCHiV数据从Oracle SQL数据库迁移到REDCap平台.
主要方法:
- 该MoCHiV研究收集有关艾滋病毒感染妇女和艾滋病毒感染母亲出生的婴儿产科事件的数据.
- 存储在Oracle SQL中的数据被清理,格式化并迁移到REDCap,使用R进行数据处理和结构定义.
- 定义了REDCap数据库结构,包括分支逻辑,数据在进口前和进口后进行了系统的合规性检查.
主要成果:
- 为数据清理,格式化和比较建立了一个系统的管道,涉及REDCap中的数据库设计,数据准备和迁移.
- 使用R生成REDCap特定的变量和重复事件的编号,从而实现关系数据结构.
- 集成了诸如数据访问组,重定向和摘要报告等附加功能,以提高多中心MoCHiV研究中的可用性.
结论:
- 从Oracle SQL向REDCap的迁移通过将Oracle SQL,R和REDCap与系统数据管理管道集成成功实现.
- REDCap为定制研究设计提供了一个灵活的平台,包括使用多种数据臂进行纵向研究.
- 预处理REDCap的大型数据集需要额外的软件,如R,以便有效格式化和清理数据以满足结构要求.
关键词:
艾滋病病毒 艾滋病病毒 艾滋病病毒红帽公司 (REDCap)队列研究是一项队列研究.数据收集数据收集数据收集数字化解决方案数字化解决方案在eCRF中使用eCRF.电子案例报告表格 电子案例报告表格电子数据输入 电子数据输入软件 软件 软件 软件 软件更多相关视频
09:00TBase - an Integrated Electronic Health Record and Research Database for Kidney Transplant Recipients
Published on: April 13, 2021
4.6K
06:55Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index
Published on: January 8, 2020
14.5K
相关概念视频
Longitudinal Research
12.0K
Sometimes we want to see how people change over time, as in studies of human development and lifespan. When we test the same group of individuals repeatedly over an extended period of time, we are conducting longitudinal research. Longitudinal research is a research design in which data-gathering is administered repeatedly over an extended period of time. For example, we may survey a group of individuals about their dietary habits at age 20, retest them a decade later at age 30, and then again...
12.0K
Longitudinal Studies
191
Longitudinal studies are also widely used in other medical and social science fields. For instance, in cardiovascular research, they can monitor patients' health over decades to identify risk factors for heart disease, such as high cholesterol or smoking, and evaluate the long-term effectiveness of preventive measures. Similarly, in mental health studies, researchers might follow individuals from adolescence into adulthood to understand the development and progression of conditions like...
191
Data Reporting and Recording
4.8K
Reporting and recording are crucial in data documentation. The timely, thorough, and accurate documentation of facts is essential when recording patient data. Failure to record findings during an assessment or interpretation of a problem will result in loss of information and make the patient document unreliable. The reader is left with general impressions if the information is not specific. A recording is documenting data of the individual's health information in a traceable, secure, and...
4.8K
Migration
8.0K
Migration is long-range, seasonal movement from one region or habitat to another. This common strategy, carried out by many different organisms around the world, is an adaptive response that typically corresponds to changes in an organism’s environment, like resource availability or climate. Migrations can involve huge groups of thousands of animals as well as single individuals traveling alone and can range from thousands of kilometers to just a few hundred meters.
8.0K
Statistical Analysis System (SAS)
249
SAS, short for Statistical Analysis System, is a powerful data analysis, management, and visualization tool. Developed by the SAS Institute in the early 1970s, SAS has evolved into a comprehensive software suite used across various industries for statistical analysis, business intelligence, and predictive modeling.
Applications: SAS finds applications in numerous fields, including healthcare for clinical trial analysis, finance for risk assessment, marketing for customer data analysis, and...
Applications: SAS finds applications in numerous fields, including healthcare for clinical trial analysis, finance for risk assessment, marketing for customer data analysis, and...
249
Data Collection by Survey
6.5K
The systematic method of obtaining and analyzing accurate information of a population is called data collection. A survey is a standard method of data collection that involves collecting information from a target human population about their experience, opinion, or knowledge of a product, service, or process. The responses are recorded and interpreted. The most common survey examples are written questionnaires, face-to-face or telephonic conversations, focus groups, and electronic (e-mail or...
6.5K
