Find Jobs
Hire Freelancers

Match Similar Data and Merge in MySQL

$50-100 USD

Abgeschlossen
Veröffentlicht vor mehr als 7 Jahren

$50-100 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 11372089

Über das Projekt

29 Vorschläge
Remote Projekt
Aktiv vor 8 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 Tagen
5,0 (1 Bewertung)
3,5
3,5
29 Freelancer bieten im Durchschnitt $92 USD für diesen Auftrag
Avatar des Nutzers
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 Tagen
4,9 (378 Bewertungen)
7,7
7,7
Avatar des Nutzers
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 Tagen
5,0 (40 Bewertungen)
5,3
5,3
Avatar des Nutzers
I have done similar task before as you can from my profile.
$100 USD in 2 Tagen
5,0 (15 Bewertungen)
4,9
4,9
Avatar des Nutzers
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 Tagen
4,9 (30 Bewertungen)
4,9
4,9
Avatar des Nutzers
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 Tagen
4,8 (16 Bewertungen)
4,4
4,4
Avatar des Nutzers
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 Tagen
4,8 (21 Bewertungen)
4,5
4,5
Avatar des Nutzers
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 Tagen
5,0 (10 Bewertungen)
4,0
4,0
Avatar des Nutzers
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 Tagen
4,7 (12 Bewertungen)
4,3
4,3
Avatar des Nutzers
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 Tagen
5,0 (7 Bewertungen)
3,8
3,8
Avatar des Nutzers
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 Tagen
5,0 (2 Bewertungen)
3,5
3,5
Avatar des Nutzers
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 Tagen
5,0 (19 Bewertungen)
3,5
3,5
Avatar des Nutzers
Hello More 20 years programming experience. I need more details to set real price and time. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$100 USD in 5 Tagen
5,0 (1 Bewertung)
1,4
1,4
Avatar des Nutzers
A proposal has not yet been provided
$88 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$55 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
South Jordan, United States
5,0
15
Zahlungsmethode verifiziert
Mitglied seit März 25, 2015

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.