SQL stored procedure -- 2
Budget: $250 – $750 USD
Description
Products are stored in a mysql DB where each product has a colour stored in HEX
The big picture is that we need to do nearest neighbour search in a table to find the closest matching colour to a specific HEX colour.
There are many ways, but we need an experienced coder to do this little job to implement the Delta E or any other better search function in MySQL.
We can for example use Delta E for CIELAB that can be made in SQL (https://stackoverflow.com/questions/31798883/performance-of-delta-e-cie-lab-calculating-and-sorting-in-sql)
Euclidean distance can not be used since the Delta E is considering the perception of the Eye's way of perceiving colours. CIELAB 2000 Delta E considers this too.
If you have done this kind of work in SQL previously and colour search this is the job for you.
Work to do:
A. adjust the code in the URL so it fits our table in a MSQL DB
B. Make Nearest Neighbour Search, NNS (similar to K-NN), only find the nearest neighbor if the Delta E value >3.
A. Distance calculation - Delta E:
1. copy the code and make it work in MySQL
2. change table names
3. write Delta E to the table for each row of colours
B. NN search
1. Receive center colour and category from Magento
2. Find central colour in the table
3. Add alternative colours, 5 lighter nearby neighbours with the same product and Delta E >3 to former neighbour
4. Add alternative colours, 5 Darker nearby neighbours with the same product and Delta E >3 to former neighbour
5. Reply with an array of alternative colours to Magento
Time:
The time this will take to copy the code in the URL and then adjust it for our needs and make NN searches will take approx 2 days for you to do.
Not much more.
Your experience:
- colour search
- stored procedure
- SQL
- 5+ years of work as experience
Products are stored in a mysql DB where each product has a colour stored in HEX
The big picture is that we need to do nearest neighbour search in a table to find the closest matching colour to a specific HEX colour.
There are many ways, but we need an experienced coder to do this little job to implement the Delta E or any other better search function in MySQL.
We can for example use Delta E for CIELAB that can be made in SQL (https://stackoverflow.com/questions/31798883/performance-of-delta-e-cie-lab-calculating-and-sorting-in-sql)
Euclidean distance can not be used since the Delta E is considering the perception of the Eye's way of perceiving colours. CIELAB 2000 Delta E considers this too.
If you have done this kind of work in SQL previously and colour search this is the job for you.
Work to do:
A. adjust the code in the URL so it fits our table in a MSQL DB
B. Make Nearest Neighbour Search, NNS (similar to K-NN), only find the nearest neighbor if the Delta E value >3.
A. Distance calculation - Delta E:
1. copy the code and make it work in MySQL
2. change table names
3. write Delta E to the table for each row of colours
B. NN search
1. Receive center colour and category from Magento
2. Find central colour in the table
3. Add alternative colours, 5 lighter nearby neighbours with the same product and Delta E >3 to former neighbour
4. Add alternative colours, 5 Darker nearby neighbours with the same product and Delta E >3 to former neighbour
5. Reply with an array of alternative colours to Magento
Time:
The time this will take to copy the code in the URL and then adjust it for our needs and make NN searches will take approx 2 days for you to do.
Not much more.
Your experience:
- colour search
- stored procedure
- SQL
- 5+ years of work as experience