Infibeam Interview Question for SDE-2s


Country: India
Interview Type: Phone Interview




Comment hidden because of low score. Click to expand.
0
of 0 vote

what kind of places you are talking about?
Location table: Coordinates + Location properties(category, name, phone number, street, city, etc)
Categories table: restaurant/mall/parks/etc..
Cities table:
...
this can be a very large db

- Eric Lei April 30, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

MongoDB was used during one of startup tasks to achieve this.

- Siva May 11, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

I think GeoHash can help to solve this problem.
for each position on the map, can use the GeoHash to encode the position to an string.
so for each location, we will store , geohash Key, location.
and the benefit of geohash is the near location will has the same prefix of the hash key.
which can help to fast get the near location from Data base.
with select location where hashKey likes "hashkey prefix"

- suwei19870312 June 17, 2014 | Flag Reply


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More