Warehousing DbSNP, Part III: Bulk Inserting SNP Data
Intro In Part II we parsed the JSON data found in the DbSNP JSON download. In Part III, we will bulk-insert this data into our PostgreSQL... »
Warehousing DbSNP, Part II: Streaming and Parsing SNP Data
Intro Part II of our adventure to warehouse a subset of DBbSNP’s JSON data picks up where Part I left off. Now that we have our... »
Warehousing DbSNP, Part I: Downloading Chromosome 1 & Creating our Database
Intro This series of posts cover how to migrate DbSNP’s newly downloadable JSON files into a slimmed-down, relational database, containing population frequency data, associated pubmed IDs,... »