How does Google store search trends in backend?

Posted by Achshar on Programmers See other posts from Programmers or by Achshar
Published on 2012-10-21T19:03:41Z Indexed on 2012/10/21 23:18 UTC
Read the original article Hit count: 175

Filed under:
|

Google trends shows what query has been searched how many times and some other properties of the said query. But how is this data stored in a database?

Storing a new row for every search does not seem right. They also tell the query on a time graph, so they must have some way to look for individual searches made by users, but the number of queries they get every day, it does not feel right that they would store every search in a database row along with a time-stamp.

This does not apply to just Google trends or Google in general but any other big site that gets awful number of queries and then has tools to see them in depth. I am not an expert on this but I am interested to know some high level structure of how things work behind the scenes.

© Programmers or respective owner

Related posts about database

Related posts about big-data