Find Jobs
Hire Freelancers

Write SQL query / Stored procedure / PHP script to identify similar records by keyword matches

$30-250 USD

Closed
Posted almost 8 years ago

$30-250 USD

Paid on delivery
See attached for the use case. We have a database of over million records, which we need to find which one is similar to which one. We want to do this by comparing keywords in each record, so the higher # of overlapping keyword rank higher. For each record, we want to get it's top 10 similar records by this keyword overlapping mechanism. It will be delivered by Mysql query or stored procedure or PHP script. We want it to be fast and effective as possible. Thanks
Project ID: 10571660

About the project

28 proposals
Remote project
Active 8 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
28 freelancers are bidding on average $186 USD for this job
User Avatar
Hello, sir. My ranking is TOP 5TH in freelancer.com as you can see my profile: (https://www.freelancer.com/u/kchg.html). I'd like to discuss with you in detail. Kind Regards
$250 USD in 3 days
4.9 (434 reviews)
9.6
9.6
User Avatar
Hello sir , Waiting for your positive response , so we can start the work soon ... Thank you ...
$133 USD in 3 days
5.0 (550 reviews)
7.8
7.8
User Avatar
Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them https://www.freelancer.com/u/AltiuseCreaton.html. Hope they make some small help trust on me for your job. Regards Rina
$377 USD in 5 days
5.0 (110 reviews)
7.4
7.4
User Avatar
Dear Employer , i've read your project description and we're interested to discuss further with you. we have been in this industry for more than 7 years and such a task is a daily job for us. As you can see we have small amount of reviews but that because we have joined freelancer lately , but definitely you can see good reviews on our account. Our team is fully available to be dedicated on your project to deliver in the time we will discuss in the highest quality with advanced technology. We are waiting to hear from you to discuss further requirement for your project. Best Regards
$155 USD in 0 day
5.0 (18 reviews)
5.1
5.1
User Avatar
Hi, There are many ways to achieve what you want, I suggest to use something like neo4j to pre build a word catch if you are really worried about time efficiency, else this can be done easily in PHP. Also if you want a more advanced and intelligent version of similar records feature using natural language processing and machine learning, I can help you with that as well. Although the quote is not for this strategy. Let me know if you have any queries. Thanks
$444 USD in 10 days
5.0 (6 reviews)
5.2
5.2
User Avatar
Hello, Thanks for posting project related to my workspace.I have 10+ years experience in Php,Social Api, WordPress, Magento, CakePhp, Codeigniter, HTML5, Bootstrap,Ajax, MySQL. I have done many projects using above technologies.I believe every project is different and require different approach to get the job done. So I think I am capable of doing this job and will prove myself. I want to discuss more before placing proper bid according to the project requirement. please leave a message..
$155 USD in 2 days
4.8 (21 reviews)
5.0
5.0
User Avatar
I have read the details and can provide you php methods to perform these task in 2 days. The quality and accuracy of work is prime objective of our firm. Looking forward to be working with you.
$100 USD in 3 days
4.7 (28 reviews)
4.9
4.9
User Avatar
Hi, I have 15 years for Oracle Database experience with vast knowledge on SQL, Database design, Database modeling. If you could give more details about the project, we could discuss on this and work it out. I should be able to develop MySQL query or a Store procedure that will retrieve duplicate/similar records (based on the keyword search). Considering the huge data in the table, hope there are indexes created on the search columns, if not then index could be created on the column(s)
$200 USD in 3 days
5.0 (8 reviews)
3.8
3.8
User Avatar
I am expert in SQL, PHP and Oracle Certified Professional. Can do the task as per your requirements with complete accuracy.
$90 USD in 3 days
4.4 (14 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$222 USD in 5 days
4.7 (8 reviews)
2.8
2.8
User Avatar
Hello. Have experience in heavy tables query optimizations in MySQL (flight data). To do you project I need more clear description (keywords, how they are stored etc), with access to your test DB via SSH for excample to look at data stuctures and futher sql query developing. Regards, Valentin.
$250 USD in 7 days
5.0 (1 review)
2.3
2.3
User Avatar
A proposal has not yet been provided
$111 USD in 2 days
4.6 (1 review)
2.2
2.2
User Avatar
I will complete your task within your timeline . The cost of this project or task is 155 dollarss.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7 years experience in MS SQL and My SQL technologies. Been involved in T-SQL, SSAS, SSRS, SSIS and Crystal report project. Thus I can deliver the job as per requirement within three days upon successful notification by you. I will use SELECT and JOIN and also table variables technique to search and compare your set of data. I open for any discussion.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understand YOUR work requirement and I can write and implement such sql query in 1 day plz let me a chance to do ...
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
For this project I would need the database schema that you are using or access to the database. I would add indexes if they do not exist already and create the logic in both php and a MySQL stored procedure so you could choose. I would include a simple web form and result page. I am a senior PHP developer with over 10 years experience in Florida USA
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , i can do it with quality and accuracy. i am having 7 years of exp on database development field. i can ensure to deliver this asap. Thanks Ajay Verma
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi We are excellent at sql scripting, we will provide you a fine tuned stored procedure to achieve your task. We want you provide a Stored procedure with parameter, where you can specify top 10 or top 5 matches if required. Regards, RSSGlobalSolutions
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HONG KONG
Cheung Sha Wan, Hong Kong
5.0
65
Payment method verified
Member since Feb 23, 2010

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.