Closed

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

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

Skills: Big Data Sales, Database Programming, MySQL, PHP, SQL

See more: top query, script php sql mp3 projects, dating netzwerk script php sql, php, mysql, sql, machine learning, ajax refresh script php sql, migrations script php sql, keyword suggestion script php, software write edid, free software write company profile, software write websites idea, software write book images, script php sql mp3, software write books, keyword density script php, software write protection, free software write book, software write book

About the Employer:
( 43 reviews ) Hong Kong, Hong Kong

Project ID: #10571660

29 freelancers are bidding on average $185 for this job

kchg

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
(399 Reviews)
9.4
AltiuseCreaton

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://ww More

$377 USD in 5 days
(72 Reviews)
7.1
mahamadali

Hello sir , Waiting for your positive response , so we can start the work soon ... Thank you ...

$133 USD in 3 days
(125 Reviews)
6.3
tuanpht

Hello, I am working in your project. I created a stored procedure with one parameter is the ID of record, and it return top 10 similar records. I am testing with data from Excel file, you can see example here: http:// More

$180 USD in 7 days
(10 Reviews)
6.1
Climaxwares

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 More

$155 USD in 0 days
(18 Reviews)
5.1
ankitfrenz

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 More

$444 USD in 10 days
(6 Reviews)
5.2
awantech

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
(28 Reviews)
4.9
angel915

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 t More

$155 USD in 2 days
(19 Reviews)
5.0
itbarduga

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 More

$200 USD in 3 days
(5 Reviews)
3.6
tappedxyz

Hi there, I'm a Canadian web developer specializing in scripts built on both MySQL and PHP. As I understand it, you need a script to rank 1 million records in your database based on their similarity to each other. M More

$200 USD in 1 day
(3 Reviews)
2.8
$300 USD in 10 days
(2 Reviews)
3.0
anujayk

A proposal has not yet been provided

$222 USD in 5 days
(8 Reviews)
2.8
valentine8

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 excampl More

$250 USD in 7 days
(1 Review)
2.3
ZishanChuhan

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
(6 Reviews)
2.6
sumanrajpura

A proposal has not yet been provided

$111 USD in 2 days
(1 Review)
2.2
Karthika6

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
chris407x

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 coul More

$155 USD in 3 days
(0 Reviews)
0.0
SridharDas

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
akv1986

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 Reviews)
0.0
ultimateronak87

I have worked in top IT company(Tata consulatcny services) on similar project.I have 6 year experience in IT . I am Gold medallist in Indian NAtional Cyber olympiad .I am new to Freelancer so giving you my service a More

$155 USD in 3 days
(0 Reviews)
0.0