Find Jobs
Hire Freelancers

Match Similar Data and Merge in MySQL

$50-100 USD

Completato
Pubblicato più di 7 anni fa

$50-100 USD

Pagato al completamento
I have two sets of tables in the same database with similar information I need to merge. Data will need to be matched initially using 100% name + other field matches and then using a % of name string matched along with other fields. After matches are made, we will need to copy data between the tables using the new matches. There are approximately 30,000 records we are matching, but we do not expect 100% though we are hoping for somewhere around 75% match after making several passes. We will ask the freelancer to perform the following passes in the database and excluding matches for each progressive pass. For this, several passes will be needed, each of them applied only to those rows that haven't been affected by previous passes: - 1. Name, city and state fields matching 100%. - 2. Name fields matching 90%, plus city, state and country 100%. - 3. Name fields matching 75%, plus city, state and country 100%. - 4. Name fields matching 75%, plus state 100%. - 5. Name fields matching 75% only.
Rif. progetto: 11372089

Info sul progetto

29 proposte
Progetto a distanza
Attivo 8 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hi my name is Brian Burditt and your project is right up my alley. I have performed this exact thing many times in my career and know how to get the best matches for you. My approach will match your requirements, but I would also like to include some addition methods that include phonetic algorithms such as Metaphone, Soundex, and Levenshtein distance. Below you will find links to the wikipedia pages for each. I've also included a link to my Linkedin profile so that you may review my qualifications and experience. [login to view URL] [login to view URL] [login to view URL] [login to view URL] I've included proposed milestones. This feature requires that I put a minimum of $5 for each, however, I would only require/expect full payment due upon satisfactory delivery of your data set. Thanks and I look forward to hearing from you. Brian
$100 USD in 3 giorni
5,0 (1 valutazione)
3,5
3,5
29 freelance hanno fatto un'offerta media di $92 USD
Avatar dell'utente
I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactorily completed. I estimate a 2-3 day turnaround (including weekends) on this project. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$100 USD in 3 giorni
4,9 (378 valutazioni)
7,7
7,7
Avatar dell'utente
Hello I can help you with this but need more information on the algorithm which you'd like me to use to determine a 90%, 75% match. Please provide some examples so that I can better understand what you consider a match. Example: Jane Carter and Johan Carter Yields an 87% score via the PHP method I'd plan to use. I have more than 10 years of experience with HTML, Javascript, PHP, MySQL, Linux and web development in general. Thanks, Danny
$100 USD in 3 giorni
5,0 (40 valutazioni)
5,3
5,3
Avatar dell'utente
I have done similar task before as you can from my profile.
$100 USD in 2 giorni
5,0 (15 valutazioni)
4,9
4,9
Avatar dell'utente
Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: Expert in SQL Server, Oracle and MS Access Databases Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script Expert in excel Macro Expert in C & C ++ Programming I have experience in all the above areas which I have gained during execution of project work As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble
$105 USD in 10 giorni
4,9 (30 valutazioni)
4,9
4,9
Avatar dell'utente
Hello, Can you share the Db tables and it would be great if you share the DB backup file to me. I will help you on this. Thanks, Sheik
$80 USD in 3 giorni
4,8 (16 valutazioni)
4,4
4,4
Avatar dell'utente
Hi! I need dump script with schema of tables and if it possible records of data. Then I need chat with you for discuss some detail.
$100 USD in 2 giorni
4,8 (21 valutazioni)
4,5
4,5
Avatar dell'utente
Hi There! I am a professional software developer and data mining expert. i have completed many jobs in data mining field and its my area of expertise. your problem can be solved by using any sort of string matching algorithms and then on the base of results the tasks will be performed or even we can enter each value and also enter their matching value so in the end you can simply delete those values with a threshold less than your choice. :)
$100 USD in 10 giorni
5,0 (10 valutazioni)
4,0
4,0
Avatar dell'utente
I can merge the data and run the matching rules in the sequence specified. After running through the set of 30000 records. Have expertise in Database, Querying, reprorting - MS Access, MY SQL, Excel. Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use. - Please review my portfolio on recent projects completed.
$60 USD in 2 giorni
4,7 (12 valutazioni)
4,3
4,3
Avatar dell'utente
Hello, Myself Barduga, I have 15 years of experience in database design and development. In my career I have written number of SQL queries and PLSQL programs. Please provide more details on the project. Regards Barduga
$88 USD in 5 giorni
5,0 (7 valutazioni)
3,8
3,8
Avatar dell'utente
Hi! I've read the description of the project carefully and I'm quite confident I can get it done for you. From what I understand, you have 2 MySQL tables and you need to match the rows between them. I can get this done since I have quite a lot of experience with MySQL. Best regards
$100 USD in 2 giorni
5,0 (2 valutazioni)
3,5
3,5
Avatar dell'utente
Hello, I am interested in your project. I am software engineer and I have profissional experience with MySQL. Thank you, Best regards, David
$100 USD in 3 giorni
5,0 (19 valutazioni)
3,5
3,5
Avatar dell'utente
Hello More 20 years programming experience. I need more details to set real price and time. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$100 USD in 5 giorni
5,0 (1 valutazione)
1,4
1,4
Avatar dell'utente
A proposal has not yet been provided
$88 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$55 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi there , i fully realize your data matching back requirement as described against this project. I do have over 6 plus years of database programming experience in SQL Server and MySQL. I do have a half built ready made solution which i can easily modify as per your requirement and can provide you more sooner than expected. Data matching using various params like Name , CIty and Country etc. is not a big deal for me as i have developed very complex business logic layers via stored procedures for my various employers over the past years. So lets chat to further discuss the database and its related tables details and start this task right away. Please inbox , me waiting for your quick response. Stay blessed ! Regards, Qudrat Ali
$88 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
We have a professional software development team with a overall experience of more than 6 years in SDLC. We are very familiar with .Net Framework , SQL Server and experience in creating web services and also have delivered complex ASP.NET MVC applications for different area and most of them were developed backend with using SQL, Azure, WEB API, RESTful and custom rich UI on Front end with using HTML, Bootstrap, Angular, and Angular 2.
$83 USD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
South Jordan, United States
5,0
15
Metodo di pagamento verificato
Membro dal mar 25, 2015

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.