title: Managing large SNP datasets with SNPpy.
abstract: Using relational databases to manage SNP datasets is a very useful technique that has significant advantages over alternative methods, including the ability to leverage the power of relational databases to perform data validation, and the use of the powerful SQL query language to export data. SNPpy is a Python program which uses the PostgreSQL database and the SQLAlchemy Python library to automate SNP data management. This chapter shows how to use SNPpy to store and manage large datasets.
authors.affiliation: Duke University, Durham, NC, USA.
authors.forename: Faheem
authors.initials: F
authors.lastname: Mitha
mesh_terms: D003627:Data Interpretation, Statistical; D003628:Database Management Systems / Q000295:instrumentation*; D030541:Databases, Genetic; D055106:Genome-Wide Association Study / Q000706:statistics & numerical data*; D006801:Humans; D016247:Information Storage and Retrieval / Q000706:statistics & numerical data*; D020641:Polymorphism, Single Nucleotide; D012984:Software