There is a similar question [Large data - storage and query](https://stackoverflow.com/questions/352895/large-data-storage-and-query)
But I think my question is even more harder.

I have a huge data set, to simplify the problem, suppose each record has 3 fields, 

Date, Location, Object

means on which day, object visits which place.

For each day there can be 50 million new records. I need to keep 100 days data.

And queries are like these:

1. Given a date range, list all the objects who have visited specific location X;
2. Given a date range, list all the locations a specific object have visited.

How should I design on this? Is it possible to give a solution? Any tools should I have a try? Can I use mongodb or hadoop?

And what's more, the query should not take much long time since it will be queried from front end.

Thanks.