Parse genetic data file and upload to SQL Server 2008 R2

Closed

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:

.\GS19240-1100-36-ASM

GS0028-DNA_C01

ASM

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.

Skills: MySQL, Perl, Software Architecture, SQL

See more: upload genetic data, type of data structure in c, type of data structure, tables in data structure, table data structure, sql server contractor, may 11. 2008, design a data structure, data structure type, data structure through c, data structure example, data structure design, data structure code, data structure and c, sql server or, upload to server, sql server c# 2008, sql import, r2, parse, parse and, import sql, file upload code, database design sql

Project ID: #3627465

2 freelancers are bidding on average $515 for this job

siberiangirl

See private message.

$501.5 USD in 4 days
(133 Reviews)
6.0
darwinduck

See private message.

$529 USD in 4 days
(8 Reviews)
3.3