Convert COBOL files to normalized MySQL Tables
The vendor will write a Perl script to load the data file into a MySQL MyISAM table. The vendor will analyze each column in the data set to determine the most efficient MySQL data type to hold the column's data. Where standard database best practices dictate, the vendor will eliminate redundancy in the table through normalization (creation of separate tables and a relation). The deliverables will be the Perl script and the MySQL table files (.MYD, .MYI, .frm files).
The vendor will work using his own machines. The data file is 107MB (gzipped) (761MB raw, 2.85 million lines) and will be provided to the vendor by FTP. The vendor will download the file, work with it, and then upload the gzipped MySQL table files to the same server. All deliverables must be compatible with Redhat Linux, Perl 5.8, and MySQL 4.0.
The vendor must complete the work within 7 calendar days of the project being assigned.
See the attached files for a sample of the data set (viol_head.txt), a description of the file format (.doc file), and more notes on the requirements for the data conversion (requirements.doc).
Approximate start date of the project after selecting a bid
Immediate (within 1-2 days)