eBay Interview Question: Write an algorithm to find ou... | Glassdoor

Interview Question

Software Engineer II Interview San Jose, CA

Write an algorithm to find out the price for a keyword of

  an item based on the values present in the existing tables. He gave me 2 tables and some columns with item details. Keywords to search for those items etc.. The keywords can have multiple words. For example if you have existing high volume keywords in the the table like iPOD with a certain price then how much price should be the phrase "iPOD Touch 8gb" (a potential low volume keyword).
Tags:
database, algorithm, queries
Answer

Interview Answer

1 Answer

0

He was looking for some 5 criteria in the algorithm. We should come up with queries joining the two tables and some aggregate functions - some amount of data mining details involved. I gave him db query solutions as well as some more ideas on how we can leverage that data to come up with a price for the low volume keywords.

Interview Candidate on Mar 4, 2010

Add Answers or Comments

To comment on this, Sign In or Sign Up.