Ce fac Hackerii in filme?

De fiecare data, cand vedeam in vre-un film cum un hacker isi face treaba, imi era interesant ce scrie el acolo… ­čÖé de multe ori vroiam sa pun pauza la film si sa vad monitorul unde lucreaza hackerul. Programmistii companiei Oracle s-au interesat ce tapeaza hackerul din filmul “The Girl with the Dragon Tattoo”, cand ┬áLisbeth Salander ├«ncepe s─â rezolve un caz de omor , de 40 de ani vechime, folosind SQL interogarile.

Lipind mai multe cadre, putem vizualiza interogarea scrisa:

Se poate observa c─â acest lucru nu poate fi facut in Oracle SQL – ├«n mod evident cuv├óntul cheie AS nu se foloseste pentru alias-urile table. Apoi se mai vede si terminalul (promt-ul ) cu denumirea MySQL si mai apoi sintaxa de conexiune use [dbname]

In sfarsit, avem interogare + raspunsul

mai jos uitativa reconstructia

SELECT DISTINCT v.fname, v.lname, i.year, i.location, i.report_file
FROM   Incident AS i
       LEFT JOIN V(ictim?)...  <em>-- presumably v.incident_id = i.id</em>
       LEFT JOIN Keyword AS k ON k.incident_id = i.id
WHERE  i.year BETWEEN 1947 AND 1966
AND    i.type = 'HOMICIDE'
AND    v.sex = 'F'
AND    i.status = 'UNSOLVED'
AND    ...
       OR v.fname IN ('Mari', 'Magda')
       OR SUBSTR ...
AND    (k.keyword IN ('rape', 'decapitation', 'dismemberment', 'fire', 'altar', 'priest', 'prostitute')
       ...
       AND SUBSTR(v.fname, 1, 1) = 'R' AND SUBSTR(v.lname, 1, 1) = 'L');

+--------+---------+------+-----------+----------------------------------+
| fname  | lname   | year | location  | report_file                      |
+--------+---------+------+-----------+----------------------------------+
| Anna   | Wedin   | 1956 | Mark      | FULL POLICE REPORT NOT DIGITIZED |
| Linda  | Janson  | 1955 | Mariestad | FULL POLICE REPORT NOT DIGITIZED |
| Simone | Grau    | 1958 | Goteborg  | FULL POLICE REPORT NOT DIGITIZED |
| Lea    | Persson | 1962 | Uddevalla | FULL POLICE REPORT NOT DIGITIZED |
| Kajsa  | Severin | 1962 | Dals-Ed   | FULL POLICE REPORT NOT DIGITIZED |
+--------+---------+------+-----------+----------------------------------+

Putem face urmatoarele concluzii, cum cel mai mare hacker nu stie despre operatorul LIKE si de ce  draq nici o victima nu are initialele  R. L.

via Oracle WTF