TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Google Correlate

161 pointsby ssnalmost 14 years ago

31 comments

leotalmost 14 years ago
Methods section of their whitepaper:<p>In our Approximate Nearest Neighbor (ANN) system, we achieve a good balance of precision and speed by using a two-pass hash-based system. In the first pass, we compute an approximate distance from the target series to a hash of each series in our database. In the second pass, we compute the exact distance function on the top results returned from the first pass.<p>Each query is described as a series in a high-dimensional space. For instance, for us-weekly, we use normalized weekly counts from January 2003 to present to represent each query in a 400+ dimensional space. For us-states, each query is represented as a 51-dimensional vector (50 states and the District of Columbia). Since the number of queries in the database is in the tens of millions, computing the exact correlation between the target series and each database series is costly. To make search feasible at a large scale, we employ an ANN system that allows fast and efficient search in high-dimensional spaces.<p>Traditional tree-based nearest neighbors search methods are not appropriate for Google Correlate due to the high dimensionality of the data resulting in sparseness of the data. Most of these methods reduce to brute force linear search with such data. For Google Correlate, we used a novel asymmetric hashing technique which uses the concept of projected quantization [16] to reduce the search complexity. The core idea behind projected quantization is to exploit the clustered nature of the data, typically observed with various real-world applications. At the training time, the database query series are projected in to a set of lower dimensional spaces.<p>Each set of projections is further quantized using a clustering method such as K-means. K-means is appropriate when the distance between two series is given by Euclidean distance. Since Pearson correlation can be easily converted into Euclidean distance by normalizing each series to be a standard Gaussian (mean of zero, variance of one) followed by a simple scaling (for details, see appendix), K-means clustering gives good quantization performance with the Google Correlate data. Next, each series in the database is represented by the center of the corresponding cluster.<p>This gives a very compact representation of the query series. For instance, if 256 clusters are generated, each query series can be represented via a unique ID from 0 to 255. This requires only 8 bits to represent a vector. This process is repeated for each set of projections. In the above example, if there are m sets of projections, it yield an 8m bit representation for each vector.<p>During the online search, given the target series, the most correlated database series are retrieved by asymmetric matching. The key concept in asymmetric matching is that the target query is not quantized but kept as the original series. It is compared against the quantized version of each database series. For instance, in our example, each database series is represented as an 8m bit code. While matching, this code is expanded by replacing each of the 8 bits by the corresponding K-means center obtained at training time, and Euclidean distance is computed between the target series and the expanded database series. The sum of the Euclidean distances between the target series and the database series in m subspaces represents the approximate distance between the two. Approximate distance between target series and the database series is used to rank all the database series. Since the number of centers is usually small, matching of the target series against all the database series can be done very quickly.<p>To further improve the precision, we take the top one thousand series from the database returned by our approximate search system (the first pass) and reorder those by doing exact correlation computation (the second pass). By combining asymmetric hashes and reordering, the system is able to achieve more than 99% precision for the top result at about 100 requests per second on O(100) machines, which is orders of magnitude faster than exact search.
wxsalmost 14 years ago
Heh, time correlation of "exam schedule" tells a sad story.<p>Shifted 1 week: gpa calculator<p>Shifted 2 weeks: final grades<p>Shifted 3 weeks: academic suspension<p>Shifted 4 weeks: academic dismissal<p><a href="http://correlate.googlelabs.com/search?e=exam+schedule&#38;t=weekly&#38;shift=1" rel="nofollow">http://correlate.googlelabs.com/search?e=exam+schedule&#38;t...</a><p><a href="http://correlate.googlelabs.com/search?e=exam+schedule&#38;t=weekly&#38;shift=2" rel="nofollow">http://correlate.googlelabs.com/search?e=exam+schedule&#38;t...</a><p><a href="http://correlate.googlelabs.com/search?e=exam+schedule&#38;t=weekly&#38;shift=3" rel="nofollow">http://correlate.googlelabs.com/search?e=exam+schedule&#38;t...</a><p><a href="http://correlate.googlelabs.com/search?e=exam+schedule&#38;t=weekly&#38;shift=4" rel="nofollow">http://correlate.googlelabs.com/search?e=exam+schedule&#38;t...</a>
hugh3almost 14 years ago
There's certainly the potential to extract interesting data here, but I haven't found it yet.<p>I do note with distress, however, that:<p><a href="http://correlate.googlelabs.com/search?e=why+is+my+poop+green&#38;t=weekly#" rel="nofollow">http://correlate.googlelabs.com/search?e=why+is+my+poop+gree...</a><p>searches for "Why is my poop green?" peaked in March 2010 before subsiding, and that it's correlated with "hiv symptoms in women" and "how to get a guy to ask you out".<p>Meanwhile, "why is my poop black?" is correlated with "How to say I love you in French"
评论 #2584952 未加载
评论 #2585594 未加载
评论 #2585091 未加载
评论 #2585138 未加载
评论 #2584874 未加载
leotalmost 14 years ago
What many here seem to miss is that this looks at coincidences in the timing of searches. This is not "within-subject": it's not that people-who-search-for-x-also-search-for-y. Rather, it's WHEN-people-search-x-other-people-are-also-likely-to-search-y .<p>That being the case, can anyone come up with an explanation for this? <a href="http://correlate.googlelabs.com/search?e=accident&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=accident&#38;t=week...</a>
评论 #2586203 未加载
评论 #2586388 未加载
koanarcalmost 14 years ago
Interestingly, migraine headaches (<a href="http://correlate.googlelabs.com/search?e=migraine+headaches&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=migraine+headaches&...</a>) correlate with:<p>- small business development<p>- us copyright office<p>- education grants<p>- legal advice
yesbabyyesalmost 14 years ago
Search by drawing is really cool. <a href="http://correlate.googlelabs.com/draw" rel="nofollow">http://correlate.googlelabs.com/draw</a><p>A bug report: I get 500 Internal Server Error when inputting non-ascii characters:<p><a href="http://correlate.googlelabs.com/search?e=santa+f%C3%A9&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=santa+f%C3%A9&#38;t...</a>
zzleeperalmost 14 years ago
This is not robust to outliers. See for instance: <a href="http://correlate.googlelabs.com/search?e=payday&#38;e=payday%20loan&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=payday&#38;e=payday...</a><p>Maybe they could use a different (and probably more computationally intensive) correlation to fix this.
hammockalmost 14 years ago
Interesting to go to Winter example then shift the lag-time (lefthand side). If you shift it 2 months, you get summer internships. If you shift it 4 months, you get summer camps. Five months, you get baseball. Eight months, you get spiders fleas and fire ants.
评论 #2585016 未加载
JonnieCachealmost 14 years ago
Nice to see that the tradition of comic book product launches is still going strong.<p><a href="http://correlate.googlelabs.com/comic" rel="nofollow">http://correlate.googlelabs.com/comic</a>
iandanforthalmost 14 years ago
Anyone play the real-estate market?<p>A great leading indicator of 'selling a home' seems to be 'european airfare' and 'florida apartments.' So here's what you do. Take out google adwords for these searches, offer 'great deals' in return for your zipcode and email address.<p>Then you can use these addresses to send inquiries about home sales and get in on sales before they hit the market!<p>There, go make money.<p>P.S. If this actually works, be nice enough to let me know :)
jfageralmost 14 years ago
This is cool, but I'd like to see it include the volume of the search term and provide a way to filter out terms above or below a specified volume threshold (i.e., show me the terms within the top 20% of all terms by volume that best correlate to this curve).<p>If that's too much to ask, it could at least provide a way of skipping the step of manually entering the returned search terms into Trends.
nck4222almost 14 years ago
Some of those are really obvious ("treatment for flu" had the highest correlation with flu activity), but "disney vacation package" correlating with a states average rainfall was a bit surprising (in that the highest correlation wasn't a search for umbrellas).
评论 #2585046 未加载
moonbootsalmost 14 years ago
Looking forward to version 2.0, Google Causality
tibbonalmost 14 years ago
Now seems to be a good time to remember...<p>"correlation is not causation"
fogusalmost 14 years ago
Dear lord -- Clojure is the most pornographic programming language ever!
orijingalmost 14 years ago
<a href="http://correlate.googlelabs.com/search?e=hacker+news&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=hacker+news&#38;t=w...</a><p>So many git commands...
powertoweralmost 14 years ago
&#62; Google Correlate is an experimental new tool on Google Labs which enables you to find queries with a similar pattern to a target data series.<p>I don't understand what the correlation is here. Is this just matching queries by frequency of search?<p>So you could have completely random and unconnected search phrases/queries "correlating" because the quantity and time/date are matching?
评论 #2585684 未加载
评论 #2585459 未加载
lostbitalmost 14 years ago
A bunch of Portuguese words seems to follow a pattern with a big rise on 2008 and a huge drop following. Looks like something was wrong with the data. <a href="http://correlate.googlelabs.com/search?e=suporte&#38;t=weekly#" rel="nofollow">http://correlate.googlelabs.com/search?e=suporte&#38;t=weekl...</a><p>I searched: suporte, cadeira, filho, barata, coelho, figueira, orkut.
Semiapiesalmost 14 years ago
"War" gives an interesting and very regular yearly pattern, aside from the obvious spike in 2003. Part of it might be explained by the summer slowdowns in insurgent activity in Iraq, but the rest of it - especially the drop right at the beginning of the year - mystifies me.<p>Maybe people avoid searching for anything war-related around the holidays.
评论 #2585412 未加载
BradGuttingalmost 14 years ago
I'd like to see a search feature that maximizes "happy accidents," kind of like how major scientific discoveries have been made inadvertently. Goes along with the notion that sometimes it's more important to create conditions in which success can occur rather than just "zero in" on something that you think (possibly inaccurately?) to be successful.
评论 #2586356 未加载
rhygaralmost 14 years ago
The infamous "facebook login" search has some interesting correlations: <a href="http://correlate.googlelabs.com/search?e=facebook+login&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=facebook+login&#38;...</a><p>Also, there seems to have been a huge drop-off in this search over the last few months.
eagletuskalmost 14 years ago
<a href="http://correlate.googlelabs.com/search?e=losing%20weight&#38;e=rental%20homes&#38;t=weekly#" rel="nofollow">http://correlate.googlelabs.com/search?e=losing%20weight&#38...</a><p>This is strange:<p>US Web Search activity for losing weight and rental homes (r=0.9418)
otalmost 14 years ago
I wonder how much (if at all) query autocompletion biases the results. I think they rank higher queries that are spiking right now, to give fresh suggestions, and this may create some feedback effect on spikes.<p>BTW, how does "google" correlate (0.98) with "kratom"???
headShrinkeralmost 14 years ago
Are people getting more sick or are they just searching it more?<p><a href="http://correlate.googlelabs.com/search?e=sore+throat&#38;t=weekly" rel="nofollow">http://correlate.googlelabs.com/search?e=sore+throat&#38;t=w...</a>
dmboydalmost 14 years ago
<a href="http://correlate.googlelabs.com/search?e=id:6n3Ji59CZ3S&#38;t=weekly#" rel="nofollow">http://correlate.googlelabs.com/search?e=id:6n3Ji59CZ3S&#38;...</a><p>Did hemorrhoids cause the GFC?
torsteinalmost 14 years ago
Anyone care to explain why almost every computer related queries have declined since 2004?<p>Is it as simple as more "normal" people use the internet?
ciexalmost 14 years ago
Does anyone know how they can match these so fast?
评论 #2585624 未加载
评论 #2585637 未加载
meowalmost 14 years ago
A quick search of programming languages (C#, java, C++, Objective C) is ... disturbing ... :(
leotalmost 14 years ago
... ultra-cool would be rankings by mutual information ...
Andrew_Quentinalmost 14 years ago
google adwords correlates with<p>county detention center pain in ln nauseous sharp pain pain in back right side el paso tx constantly take
klbarryalmost 14 years ago
What I see from this is that I could make a lot of correlations seem 95% certain to laymen with this tool that don't mean anything. Almost any term can get an unrelated term matching perfectly. Search "Eco fashion".