Or, how the author of the infamous top-secret PPT presentation has clearly never seen the inside of a SQL table.
When The Guardian broke the story of the US Government’s digital intelligence gathering operation (code named “PRISM”), the oft-quoted line from the Top Secret presentation an NSA analyst gave to his colleagues was that the NSA had “direct access” to the servers at Google, Microsoft, Facebook, Yahoo!, Apple, among others (with Dropbox “coming soon” and Twitter conspicuous by its absence).
The response from these tech companies was swift and unequivocal. Turns out the NSA doesn’t actually tap directly into the servers at these companies; instead, it has computers on-site to which NSA analysts post queries. The NSA computers then download the relevant data.
The imprecision of the NSA’s presentation is clearly, obviously due to the fact that the author has never performed a SQL JOIN on two tables in a database tables!
In short, the way the PRISM works is the NSA collects as much data – every Google search, email, FB post and Verizon phone call – it can get its hands on. The NSA then cross-references this huge mountain of data with lists of known or suspected terrorists, persons of interest, et al. In other words, the NSA data analysts perform an INNER JOIN on the two tables!
Here’s a neat visualizing from Seldom Matt: