Help Create a Normalized Data Schema for a Database
$30-250 USD
Closed
Posted over 15 years ago
$30-250 USD
Paid on delivery
Hi,
I'm working on creating a SQL Server 2008 database. My source data are .csv files with about 2400 columns, representing financial information on stocks. I want to use these, but I can't make a table that is 2400 columns wide for performance reasons.
That's why I'm on here-- to find someone smart to do this for me, since I'm too busy at the moment. I have very good documentation on the data format from the data vendor, which should answer most questions for you.
Please note that I am looking to hire only people significant experience with development and programming. The job of modeling a DB schema isn't rocket science, but it is difficult to do the right way. You will also need to have good english language skills, because your primary source of information will be the vendor's DB documentation. I will then take the results of the
If I do hire you, my plan is to send you the CSV file by ftp or google talk, as well, as the data documentation, and have you create a new database on your computer. Normalize the data and create db diagrams, and when you are done, send me the database backup file so I can integrate it into my existing server.
Please, only bid if you 1) have done work like this in the recent past and 2) are confident that you can start prompty and finish in a reasonable time frame.
If you have any questions, or want to look at some of the data and the documentation before bidding, send me a PM and we can work something out.
I look forward to working with you!
Hi,
I am a computer engineer , having more than 4 yrs , S/W devlopment experience(.NET2.0,3.0,C#,Sqlserver2005/)
i am keen to intersted in your work, can start work on immediately effect.
Thanx
Hello sir, I am a qualified software engineer working with a top most company in India. Thus you will be getting the benefits of processes followed by a large software company. I would be interested in taking up this project as a part time assignment. I saw your sample data and it contains only 256 columns. I first need to know what kind of database performance expectations you have and what reports you plan to generate. Then we can have a database restructure plan which either splits this large table vertically or does some other sort of normalization. I have good amount of SQL experience for this kind of projects. We need to discuss details so if you are interested, please post a private message.