Approaches and Informatics Tools to Assist in the Integration of Similar Clinical Research Questionnaires

Summary

Objective: The integration of similar clinical research questionnaires is a complex process that can benefit from informatics approaches and tools that provide a systematic structure for performing mapping and integration. This systematic approach is necessary to address complex issues in integration such as data heterogeneity, differing levels of granularity of questions and responses, and other issues involving semantic differences. Informatics tools and approaches have been successfully applied to various standard clinical vocabulary integration processes but not for questionnaire integration or mapping.

Methods: A systematic approach to questionnaire integration was developed in the context of a collaboration of researchers using Trial/DB, a database designed to support clinical research. This approach was applied to the integration of questionnaires involving breast cancer risk factors from each of three research sites.

Results: From 375 questions on the three original questionnaires, we identified 65 concepts that were measured by two or three of the sites. An algorithm was developed and used to formalize the process of mapping questions and answers across the questionnaires. The approach was applied to previously collected data and prospective data in disparate database systems to import and merge the data from these three sites into Trial/DB.

Conclusion: Informatics tools that support a systematic approach to mapping questionnaires can be used throughout the research process from questionnaire integration and creation, legacy data integration to data library maintenance and curation.

Keywords

Vocabulary mapping - data integration - pooled analysis - surveys - questionnaires

• References

• 1 National Cancer Institute. The Cancer Genetics Network. 2002.
• 2 Blettner M. et al. Traditional reviews, metaanalyses and pooled analyses in epidemiology. Int J Epidemiol 1999; 28 (01) 1-9.
• 3 Friedenreich CM. Commentary: improving pooled analyses in epidemiology. Int J Epidemiol 2002; 31 (01) 86-7.
• 4 Smith-Warner SA. et al. Intake of fruits and vegetables and risk of breast cancer: a pooled analysis of cohort studies. JAMA 2001; 285 (06) 769-76.
• 5 Smith-Warner SA. et al. Types of dietary fat and breast cancer: a pooled analysis of cohort studies. Int J Cancer 2001; 92 (05) 767-74.
• 6 Chalmers I. The Cochrane collaboration: preparing, maintaining, and disseminating systematic reviews of the effects of health care. Ann N Y Acad Sci 1993; 703: 156-63. discussion 163-5
• 7 Early Breast Cancer Trialists’ Collaborative Group. Systemic treatment of early breast cancer by hormonal, cytotoxic, or immune therapy. 133 randomised trials involving 31,000 recurrences and 24,000 deaths among 75,000 women. Lancet 1992; 339 8785 71-85.
• 8 Jeng GT, Scott JR, Burmeister LF. A comparison of meta-analytic results using literature vs individual patient data. Paternal cell immunization for recurrent miscarriage. JAMA 1995; 274 (10) 830-6.
• 9 Clarke M, Oxman A. Cochrane Reviewers’ Handbook 4.1.6: Reviews Using Individual Patient Data. 2003, Cochrane Collaboration.
• 10 Brandt CA. et al. Re-engineering a Database for Clinical Trials Management: Lessons for System Architects. Controlled Clinical Trials 2000; 21 (05) 441-61.
• 11 Nadkarni PM. et al. Managing attribute-value clinical trials data using the ACT/DB clientserver database system. JAMIA 1998; 5 (02) 139-51.
• 12 Nadkarni PM, Brandt CA, Marenco L. WebEAV: automatic metadata-driven generation of web interfaces to entity-attribute-value databases. JAMIA 2000; 7 (04) 343-56.
• 13 Webster’s New World College Dictionary, Fourth Edition, IDG Books Worldwide, Inc, Foster City, CA 2001 35.
• 14 Campbell JR. et al. Phase II evaluation of clinical coding schemes: completeness, taxonomy, mapping, definitions, and clarity. CPRI Work Group on Codes and Structures. JAMIA 1997; 4 (03) 238-51.
• 15 Cimino JJ. Desiderata for Controlled Medical Vocabularies in the the Twenty-First Century. Methods Inf Med 1998; 39: 394-403.
• 16 Dolin RH. et al. Evaluation of a “lexically assign, logically refine” strategy for semi-automated integration of overlapping terminologies. JAMIA 1998; 5 (02) 203-13.
• 17 Kannry JL. et al. Portability issues for a structured clinical vocabulary: mapping from Yale to the Columbia Medical Entities Dictionary. JAMIA 1996; 3: 66-78.
• 18 Bakken S. et al. Evaluation of the clinical LOINC (Logical Observation Identifiers, Names, and Codes) semantic structure as a terminology model for standardized assessment measures. JAMIA 2000; 7 (06) 529-38.
• 19 White TM, Hauan MJ. Extending the LOINC conceptual schema to support standardized assessment instruments. JAMIA 2002; 9 (06) 586-99.