title: Design database for quantitative trait loci (QTL) data warehouse, data mining, and meta-analysis.
abstract: A database can be used to warehouse quantitative trait loci (QTL) data from multiple sources for comparison, genomic data mining, and meta-analysis. A robust database design involves sound data structure logistics, meaningful data transformations, normalization, and proper user interface designs. This chapter starts with a brief review of relational database basics and concentrates on issues associated with curation of QTL data into a relational database, with emphasis on the principles of data normalization and structure optimization. In addition, some simple examples of QTL data mining and meta-analysis are included. These examples are provided to help readers better understand the potential and importance of sound database design.
authors.affiliation: Department of Animal Science, Center for Integrated Animal Genomics Iowa State University, 2255 Kildee Hall, Ames, IA 50011-3150, USA. zhilianghu@gmail.com
authors.forename: Zhi-Liang
authors.initials: ZL
authors.lastname: Hu
authors.forename: James M
authors.initials: JM
authors.lastname: Reecy
authors.forename: Xiao-Lin
authors.initials: XL
authors.lastname: Wu
mesh_terms: D000818:Animals; D057225:Data Mining; D006801:Humans; D015201:Meta-Analysis as Topic; D040641:Quantitative Trait Loci / Q000235:genetics*