title: Integrating clinical and laboratory data in genetic studies of complex phenotypes: a network-based data management system.
abstract: The identification of genes underlying a complex phenotype can be a massive undertaking, and may require a much larger sample size than thought previously. The integration of such large volumes of clinical and laboratory data has become a major challenge. In this paper we describe a network-based data management system designed to address this challenge. Our system offers several advantages. Since the system uses commercial software, it obviates the acquisition, installation, and debugging of privately-available software, and is fully compatible with Windows and other commercial software. The system uses relational database architecture, which offers exceptional flexibility, facilitates complex data queries, and expedites extensive data quality control. The system is particularly designed to integrate clinical and laboratory data efficiently, producing summary reports, pedigrees, and exported files containing both phenotype and genotype data in a virtually unlimited range of formats. We describe a comprehensive system that manages clinical, DNA, cell line, and genotype data, but since the system is modular, researchers can set up only those elements which they need immediately, expanding later as needed.
authors.affiliation: Department of Psychiatry and Behavioral Sciences, The Johns Hopkins University School of Medicine, Baltimore, Maryland 21287-7381, USA. fmcm@welchlink.wech.jhu.edu
authors.forename: F J
authors.initials: FJ
authors.lastname: McMahon
authors.forename: C J
authors.initials: CJ
authors.lastname: Thomas
authors.forename: R J
authors.initials: RJ
authors.lastname: Koskela
authors.forename: T S
authors.initials: TS
authors.lastname: Breschel
authors.forename: T C
authors.initials: TC
authors.lastname: Hightower
authors.forename: N
authors.initials: N
authors.lastname: Rohrer
authors.forename: C
authors.initials: C
authors.lastname: Savino
authors.forename: M G
authors.initials: MG
authors.lastname: McInnis
authors.forename: S G
authors.initials: SG
authors.lastname: Simpson
authors.forename: J R
authors.initials: JR
authors.lastname: DePaulo
mesh_terms: D002984:Clinical Laboratory Information Systems; D003628:Database Management Systems; D005823:Genetics; D006801:Humans; D010375:Pedigree; D010641:Phenotype