Find Jobs
Hire Freelancers

database combine and dedupe

$30-250 USD

Closed
Posted about 10 years ago

$30-250 USD

Paid on delivery
I have 3 databases in csv format of businesses there about 1 million records in each csv They need to be combined and deduped with the newest entry from the database- DB 1 Newest DB2-a/b 2nd newest which will extract one state from so there is much less than 1 million here. DB 3 oldest Each DB has descriptions for each business. You will take the description from each DB and create a column business name | address | etc | DB1 descr. | DB2 desc | DB 3 descr here is sample screen of one DB [login to view URL]
Project ID: 5691028

About the project

15 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $156 USD for this job
User Avatar
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce, Zen cart-Drupal I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$185 USD in 8 days
4.8 (221 reviews)
7.6
7.6
User Avatar
Hello sir, i can do it, but, what output would you want to have? another csv? sql database? mysql? Thanks!
$155 USD in 3 days
4.7 (70 reviews)
6.2
6.2
User Avatar
Hello. Some questions: do all your databases have the same columns? If no: do you want to unite columns from different databases? Where is description on screen shot? I don't see it. In which format do you want to have a rsult? MySQL database or still csv? If say e-mail for the same business differ in db1 and db2 which one do you want to have in the result?
$120 USD in 2 days
5.0 (21 reviews)
5.3
5.3
User Avatar
Hi, I'm very interested helping you combining your databases, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$100 USD in 1 day
4.9 (35 reviews)
5.3
5.3
User Avatar
Hello, If I understand right that you want to merge those three databases with only specific information? I am online here so lets disccuss this job :)
$166 USD in 1 day
5.0 (4 reviews)
2.6
2.6
User Avatar
Hi . I have wide experience in projects dealing with Big data. I had been working on tools like Spotfire and Qlikview - data analytic tools. I can assure that I can complete the project, provided the complete information is shared. Hoping for a positive reply. Thanks & Regards, K459
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Professional MySQL DBA I have made some research of duplicated data. Comparing four method, included delete duplicated through php, I can choose most appropriated way which is fastest, reliable, security.
$155 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have work experience of 7 years in DB with world's biggest IT company.................................................................I think that's enough. Thanks
$88 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Load data can be done. Since your data size is high so we have take consideration of best practice DB configuration to provide best performance of your application. Looking forward your positive acceptance of my proposal. Thank you, Bharat
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Boca Raton, United States
4.9
13
Payment method verified
Member since Sep 27, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.