Parse genetic data file and upload to SQL Server 2008 R2

  • Status Closed
  • Budget $30 - $5000 USD
  • Total Bids 2

Project Description

We require a contractor to develop PERL code that will parse and upload the following example file to a SQL Server 2008 R2 instance. The database design is required for this project and must be normalized to minimize redundancy (i.e., multiple tables with unique IDs and foreign keys). We will import many files of this type so the code must obtain and assign unique IDs. Database design must also incorporate appropriate indexes.

The example file may be accessed through the vendor's FTP server site at:

<ftp://[url removed, login to view]>.

It is located within the compressed TAR file named: GS19240-1100-36-ASM-VAR-files.tar. Once extracted, follow the directory structure below:




Extract the compressed BZ2 file named: var-GS19240-1100-36-ASM.tsv.bz2. The table contains the header rows which must be contained in one or more separate tables.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online