{"id":1,"date":"2016-12-08T07:27:10","date_gmt":"2016-12-08T07:27:10","guid":{"rendered":"http:\/\/www.langdo.com\/blog\/?p=1"},"modified":"2016-12-10T22:03:18","modified_gmt":"2016-12-10T20:03:18","slug":"neo4j_101","status":"publish","type":"post","link":"http:\/\/www.langdo.com\/blog\/2016\/12\/08\/neo4j_101\/","title":{"rendered":"Forensic accounting \/ Neo4J 101"},"content":{"rendered":"<style type=\"text\/css\" scoped>\n<p>\n.datagrid table { border-collapse: collapse; text-align: left; width: 100%; direction: ltr;} .datagrid {font: normal 12px\/150% Arial, Helvetica, sans-serif; background: #fff; overflow: hidden; border: 1px solid #006699; -webkit-border-radius: 3px; -moz-border-radius: 3px; border-radius: 3px; }.datagrid table td, .datagrid table th { padding: 3px 10px; }.datagrid table thead th {background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #006699), color-stop(1, #00557F) );background:-moz-linear-gradient( center top, #006699 5%, #00557F 100% );filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#006699', endColorstr='#00557F');background-color:#006699; color:#FFFFFF; font-size: 15px; font-weight: bold; border-left: 1px solid #0070A8; } .datagrid table thead th:first-child { border: none; }.datagrid table tbody td { color: #00557F; border-left: 1px solid #E1EEF4;font-size: 12px;font-weight: normal; }.datagrid table tbody .alt td { background: #E1EEf4; color: #00557F; }.datagrid table tbody td:first-child { border-left: none; }.datagrid table tbody tr:last-child td { border-bottom: none; }.datagrid table tfoot td div { border-top: 1px solid #006699;background: #E1EEf4;} .datagrid table tfoot td { padding: 0; font-size: 12px } .datagrid table tfoot td div{ padding: 2px; }.datagrid table tfoot td ul { margin: 0; padding:0; list-style: none; text-align: right; }.datagrid table tfoot  li { display: inline; }.datagrid table tfoot li a { text-decoration: none; display: inline-block;  padding: 2px 8px; margin: 1px;color: #FFFFFF;border: 1px solid #006699;-webkit-border-radius: 3px; -moz-border-radius: 3px; border-radius: 3px; background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #006699), color-stop(1, #00557F) );background:-moz-linear-gradient( center top, #006699 5%, #00557F 100% );filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#006699', endColorstr='#00557F');background-color:#006699; }.datagrid table tfoot ul.active, .datagrid table tfoot ul a:hover { text-decoration: none;border-color: #00557F; color: #FFFFFF; background: none; background-color:#006699;}div.dhtmlx_window_active, div.dhx_modal_cover_dv { position: fixed !important; } caption, th, td { text-align: left; direction: ltr; }\n<\/p>\n<\/style>\n<p style=\"text-align: right;\">\u05de\u05e1\u05de\u05db\u05d9 \u05e4\u05e0\u05de\u05d4 \u05d4\u05dd \u05db\u05d9\u05e0\u05d5\u05d9 \u05dc\u05d4\u05d3\u05dc\u05e4\u05ea \u05e2\u05e0\u05e7 \u05e9\u05dc \u05de\u05e1\u05de\u05db\u05d9 \u05de\u05e9\u05e8\u05d3 \u05e2\u05d5\u05e8\u05db\u05d9 \u05d3\u05d9\u05df \u05e4\u05e0\u05de\u05d9 \u05e9\u05de\u05ea\u05e2\u05e1\u05e7 <em><strong>\u05db\u05e0\u05e8\u05d0\u05d4<\/strong> <\/em>\u05d1\u05e2\u05d9\u05e7\u05e8 \u05d1\u05d4\u05e7\u05de\u05ea \u05d7\u05d1\u05e8\u05d5\u05ea \u05e7\u05e9 \u05d1\u05de\u05e7\u05dc\u05d8\u05d9 \u05de\u05e1.<br \/>\n\u05d4<em><strong>\u05db\u05e0\u05e8\u05d0\u05d4<\/strong> <\/em>\u05de\u05e6\u05d1\u05d9\u05e2 \u05e2\u05dc \u05d6\u05d4 \u05e9\u05d0\u05d9\u05df \u05dc\u05d9 \u05db\u05d5\u05d5\u05e0\u05d4 \u05dc\u05d8\u05e2\u05d5\u05df \u05d1\u05e0\u05d7\u05e8\u05e6\u05d5\u05ea \u05d3\u05d1\u05e8\u05d9\u05dd \u05dc\u05d2\u05d1\u05d9 \u05d0\u05e3 \u05d0\u05d7\u05ea \u05de\u05d4\u05d9\u05e9\u05d5\u05d9\u05d5\u05ea \u05e9\u05d9\u05e6\u05d5\u05e6\u05d5 \u05d1\u05e7\u05d1\u05e6\u05d9\u05dd. \u05d0\u05dd \u05db\u05d1\u05e8 \u05e0\u05d0\u05de\u05e8 \u05de\u05e9\u05d4\u05d5 &#8211; \u05d4\u05db\u05dc \u05d9\u05d4\u05d9\u05d4 \u05e2\u05dc \u05e4\u05d9 \u05de\u05e7\u05d5\u05e8\u05d5\u05ea \u05d6\u05e8\u05d9\u05dd.<br \/>\n\u05db\u05d5\u05d5\u05e0\u05ea \u05d4\u05e4\u05d5\u05e1\u05d8 \u05d4\u05d9\u05d0 \u05e8\u05e7 \u05dc\u05e1\u05e4\u05e7 \u05e7\u05e8\u05e7\u05e2 \u05e0\u05d5\u05d7\u05d4 \u05d5\u05de\u05e2\u05e0\u05d9\u05d9\u05e0\u05ea \u05dc\u05de\u05e9\u05d7\u05e7\u00a0 hands on \u05e2\u05dd \u05d8\u05db\u05e0\u05d5\u05dc\u05d5\u05d2\u05d9\u05d9\u05ea \u05d4GraphDB \u05d5\u05d0\u05d9\u05df \u05d1\u05e1\u05d9\u05e1 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05de\u05e2\u05e0\u05d9\u05d9\u05df \u05d9\u05d5\u05ea\u05e8 \u05de\u05d0\u05e9\u05e8 \u05de\u05e1\u05de\u05db\u05d9 \u05e4\u05e0\u05de\u05d4 \u05dc\u05e6\u05d5\u05e8\u05da \u05d4\u05e2\u05e0\u05d9\u05d9\u05df.<br \/>\n(<a href=\"https:\/\/en.wikipedia.org\/wiki\/Panama_Papers\">\u05d5\u05d9\u05e7\u05d9 \u05d0\u05e0\u05d2\u05dc\u05d9\u05ea<\/a>, <a href=\"https:\/\/he.wikipedia.org\/wiki\/%D7%9E%D7%A1%D7%9E%D7%9B%D7%99_%D7%A4%D7%A0%D7%9E%D7%94\">\u05d5\u05d9\u05e7\u05d9 \u05e2\u05d1\u05e8\u05d9\u05ea<\/a>, \u05d4\u05d0\u05ea\u05e8 \u05e2\u05e6\u05de\u05d5:\u00a0<a href=\"https:\/\/offshoreleaks.icij.org\/\">Offshore Leaks Database<\/a> )<\/p>\n<p style=\"text-align: right;\">\u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e2\u05e6\u05de\u05dd \u05e0\u05de\u05e6\u05d0\u05d9\u05dd <a href=\"https:\/\/offshoreleaks.icij.org\/pages\/database\">\u05db\u05d0\u05df<\/a>:<br \/>\n\u05d5\u05e0\u05d9\u05ea\u05e0\u05d9\u05dd \u05dc\u05d4\u05d5\u05e8\u05d3\u05d4 \u05d1\u05e9\u05ea\u05d9 \u05e6\u05d5\u05e8\u05d5\u05ea: <a href=\"https:\/\/cloudfront-files-1.publicintegrity.org\/offshoreleaks\/data-csv.zip.torrent#_ga=1.45384612.1448118329.1481020505\">CSV<\/a> \u05d0\u05d5 <a href=\"https:\/\/cloudfront-files-1.publicintegrity.org\/offshoreleaks\/neo4j\/panama-papers-windows-2016-11-30.zip.torrent#_ga=1.45384612.1448118329.1481020505\">DB \u05de\u05d5\u05db\u05df \u05e9\u05dc Neo4J <\/a>\u05d1\u05e9\u05e0\u05d9 \u05d4\u05de\u05e7\u05e8\u05d9\u05dd \u05e9\u05de\u05ea\u05d9 \u05d0\u05ea \u05d4\u05dc\u05d9\u05e0\u05e7 \u05dc\u05e7\u05d5\u05d1\u05e5 \u05d4\u05d8\u05d5\u05e8\u05e0\u05d8.<\/p>\n<p style=\"text-align: right;\">\u05d4\u05e6\u05e2\u05d3 \u05d4\u05e8\u05d0\u05e9\u05d5\u05df \u05d4\u05d5\u05d0 \u05d4\u05d5\u05e8\u05d3\u05d4 \u05e9\u05dc \u05d4DB \u05e2\u05e6\u05de\u05d5 \u05de<a href=\"https:\/\/neo4j.com\/download\/community-edition\/\">\u05db\u05d0\u05df<\/a>.<br \/>\n\u05dc\u05d0\u05d7\u05e8 \u05d4\u05d5\u05e8\u05d3\u05d4 \u05d4\u05ea\u05e7\u05e0\u05d4 \u05d5\u05d4\u05e8\u05e6\u05d4 (next next)<br \/>\n\u05d9\u05e4\u05ea\u05d7 \u05dc\u05d9\u05e0\u05e7 \u05dcBrowser \u05de\u05d2\u05e0\u05d9\u05d1 \u05de\u05e2\u05dc \u05d4DB \u05d4\u05dc\u05d5\u05e7\u05d0\u05dc\u05d9 \u05d1\u05db\u05ea\u05d5\u05d1\u05ea: <a href=\"http:\/\/localhost:7474\/browser\/\">http:\/\/localhost:7474\/browser<\/a><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-9 aligncenter\" src=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-connection-page-300x137.png\" alt=\"\" width=\"700\" height=\"320\" srcset=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-connection-page-300x137.png 300w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-connection-page-768x350.png 768w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-connection-page-1024x467.png 1024w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-connection-page.png 1885w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p style=\"text-align: right;\">\u05d1\u05db\u05e0\u05d9\u05e1\u05d4 \u05d4\u05e8\u05d0\u05e9\u05d5\u05e0\u05d4 \u05e6\u05e8\u05d9\u05da \u05dc\u05d4\u05ea\u05d7\u05d1\u05e8 \u05dc\u05e9\u05e8\u05ea \u05e2\u05dd \u05d4\u05e1\u05d9\u05e1\u05de\u05d0 \u05d4\u05d3\u05d9\u05e4\u05d5\u05dc\u05d8\u05d9\u05ea, \u05dc\u05d4\u05d2\u05d3\u05d9\u05e8 \u05d7\u05d3\u05e9\u05d4 \u05d5\u05d0\u05d6 \u05d0\u05ea\u05dd \u05d1\u05e4\u05e0\u05d9\u05dd.<\/p>\n<p style=\"text-align: right;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10\" src=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-welcome-page-300x130.png\" alt=\"\" width=\"577\" height=\"250\" srcset=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-welcome-page-300x130.png 300w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-welcome-page-768x332.png 768w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-welcome-page-1024x442.png 1024w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-welcome-page.png 1705w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/p>\n<p style=\"text-align: right;\"><em><strong>Learn about\u00a0 Neo4J<\/strong><\/em> \u05e0\u05d5\u05d2\u05e2 \u05e7\u05e6\u05ea \u05d1\u05de\u05d5\u05e0\u05d7\u05d9\u05dd \u05d5\u05d4<em><strong>Jump into code<\/strong><\/em> \u05de\u05d0\u05e4\u05e9\u05e8 \u05e6\u05dc\u05d9\u05dc\u05d4 \u05de\u05d0\u05d5\u05d3 \u05e0\u05d5\u05d7\u05d4 \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea DB \u05e1\u05e8\u05d8\u05d9\u05dd \u05d5\u05d0\u05d6 \u05ea\u05d9\u05d7\u05e7\u05d5\u05e8 \u05e9\u05dc\u05d5.<br \/>\n\u05d4\u05ea\u05d7\u05e7\u05d5\u05e8 \u05de\u05ea\u05d1\u05e6\u05e2 \u05d1\u05e9\u05e4\u05ea <a href=\"https:\/\/neo4j.com\/developer\/cypher\/\">Cypher<\/a> \u05e9\u05d4\u05d9\u05d0 \u05d7\u05dc\u05e7 \u05d2\u05d3\u05d5\u05dc \u05de\u05d4\u05d9\u05d5\u05e4\u05d9 \u05d1\u05db\u05dc \u05d4\u05e2\u05e0\u05d9\u05d9\u05df.<\/p>\n<p style=\"text-align: right;\">\u05d1\u05d4\u05d7\u05dc\u05d8 \u05e8\u05d0\u05d5\u05d9 \u05dc\u05d0\u05d6\u05db\u05e8 \u05db\u05d0\u05df \u05d0\u05ea <a href=\"https:\/\/he.wikipedia.org\/wiki\/%D7%94%D7%99%D7%A4%D7%95%D7%AA%D7%96%D7%AA_%D7%A1%D7%A4%D7%99%D7%A8-%D7%95%D7%95%D7%A8%D7%A3\">\u05d4\u05d9\u05e4\u05d5\u05ea\u05d6\u05ea \u05e1\u05e4\u05d9\u05e8-\u05d5\u05d5\u05dc\u05e3 <\/a>\u05e9\u05d4\u05e9\u05e4\u05d4 \u05de\u05e9\u05e4\u05d9\u05e2\u05d4 \u05e2\u05dc \u05d0\u05d5\u05e4\u05e0\u05d9 \u05d4\u05d7\u05e9\u05d9\u05d1\u05d4. \u05d2\u05dd \u05d0\u05dd \u05d0\u05e4\u05e9\u05e8 \u05dc\u05ea\u05d7\u05e7\u05e8 \u05d4\u05db\u05dc \u05d1SQL, \u05d0\u05d5 \u05d1\u05e9\u05e4\u05ea \u05ea\u05db\u05e0\u05d5\u05ea \u05d4\u05e8\u05d9 \u05e9\u05e9\u05e4\u05ea \u05d4\u05ea\u05d7\u05e7\u05d5\u05e8 \u05dc\u05dc\u05d0 \u05e1\u05e4\u05e7 \u05d4\u05d5\u05e4\u05db\u05ea \u05e9\u05d0\u05dc\u05d5\u05ea \u05e8\u05d1\u05d5\u05ea \u05dc\u05e0\u05d2\u05d9\u05e9\u05d5\u05ea \u05d9\u05d5\u05ea\u05e8 \u05dc\u05e9\u05d0\u05dc\u05d4.<\/p>\n<div class=\"content code-panel\" style=\"width: 100%; height: auto; text-align: left; direction: ltr;\">\n<pre class=\"code programlisting cm-s-neo cm-s-neo\" style=\"font-size: 16px; font-weight: 100;\" data-lang=\"cypher\"><span class=\"cm-keyword\">MATCH<\/span> <span class=\"cm-node\">(<\/span><span class=\"cm-atom\">actor:Person<\/span><span class=\"cm-node\">)<\/span>-<span class=\"cm-node\">[<\/span><span class=\"cm-variable\">:ACTED_IN<\/span><span class=\"cm-node\">]<\/span>-&gt;<span class=\"cm-node\">(<\/span><span class=\"cm-atom\">movie:Movie<\/span><span class=\"cm-node\">)<\/span>\r\n<span class=\"cm-keyword\">WHERE<\/span> <span class=\"cm-variable\">movie<\/span><span class=\"cm-node\">.<\/span><span class=\"cm-variable\">title<\/span> <span class=\"cm-variable\">STARTS<\/span> <span class=\"cm-keyword\">WITH<\/span> <span class=\"cm-string\">\"T\"<\/span>\r\n<span class=\"cm-keyword\">RETURN<\/span> <span class=\"cm-variable\">movie<\/span><span class=\"cm-node\">.<\/span><span class=\"cm-variable\">title<\/span> <span class=\"cm-keyword\">AS<\/span> <span class=\"cm-variable\">title<\/span><span class=\"cm-node\">,<\/span> <span class=\"cm-builtin\">collect<\/span><span class=\"cm-node\">(<\/span><span class=\"cm-variable\">actor<\/span><span class=\"cm-node\">.<\/span><span class=\"cm-variable\">name<\/span><span class=\"cm-node\">)<\/span> <span class=\"cm-keyword\">AS<\/span> <span class=\"cm-variable\">cast<\/span>\r\n<span class=\"cm-keyword\">ORDER<\/span> <span class=\"cm-keyword\">BY<\/span> <span class=\"cm-variable\">title<\/span> <span class=\"cm-keyword\">ASC<\/span> <span class=\"cm-keyword\">LIMIT<\/span> <span class=\"cm-variable\">10<\/span><span class=\"cm-node\">;<\/span><\/pre>\n<\/div>\n<p style=\"text-align: right;\">\u05d4\u05e9\u05e4\u05d4 \u05e2\u05e6\u05de\u05d4 \u05de\u05d0\u05d5\u05d3 \u05de\u05d6\u05db\u05d9\u05e8\u05d4 SQL \u05e2\u05dd \u05e7\u05e6\u05ea \u05dc\u05d5\u05d2\u05d9\u05e7\u05d4 \u05e9\u05dc RegEx<br \/>\n\u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d0 \u05d4\u05d1\u05e1\u05d9\u05e1\u05d9\u05ea \u05db\u05e4\u05d9 \u05e9\u05d4\u05d9\u05d0 \u05de\u05d5\u05e4\u05d9\u05e2\u05d4 \u05dc\u05de\u05e2\u05dc\u05d4 \u05db\u05d5\u05dc\u05dc\u05ea:<br \/>\nMATCH &#8211; \u05d7\u05dc\u05e7 \u05e9\u05d1\u05d5 \u05e0\u05ea\u05d0\u05e8 \u05ea\u05d1\u05e0\u05d9\u05ea \u05e9\u05dc\u05e4\u05d9\u05d4 \u05e0\u05e4\u05dc\u05d8\u05e8 \u05d3\u05d0\u05d8\u05d4 \u05e9\u05ea\u05d5\u05d0\u05de\u05ea \u05dc\u05d4. (\u05d0\u05d5 \u05de\u05e1\u05e4\u05e8 \u05ea\u05d1\u05e0\u05d9\u05d5\u05ea \u05de\u05d5\u05e4\u05e8\u05d3\u05d5\u05ea \u05d1\u05e4\u05e1\u05d9\u05e7)<\/p>\n<div class=\"content code-panel\" style=\"width: 100%; height: auto; text-align: left; direction: ltr;\">\n<pre class=\"code programlisting cm-s-neo cm-s-neo\" style=\"font-size: 16px; font-weight: 100;\" data-lang=\"cypher\"><span class=\"cm-keyword\">MATCH<\/span> <span class=\"cm-node\">(<\/span><span class=\"cm-atom\">_ALIAS_TO_BE_USED_LATER_IN_THE QUERY_:_NODE_TYPE_<\/span><span class=\"cm-node\">)<\/span>-<span class=\"cm-node\">[<\/span><span class=\"cm-variable\">:_RELATION_TYPE_<\/span><span class=\"cm-node\">]<\/span>-&gt;<span class=\"cm-node\">(<\/span><span class=\"cm-atom\">movie:Movie<\/span><span class=\"cm-node\">)<\/span><\/pre>\n<\/div>\n<p style=\"text-align: right;\">\u00a0WHERE &#8211; \u05e1\u05d8\u05e0\u05d3\u05e8\u05d8\u05d9 \u05db\u05de\u05d5 \u05d1SQL. (\u05e9\u05d9\u05de\u05d5 \u05dc\u05d1 \u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1movie \u05d4alias \u05e9\u05d4\u05d5\u05d2\u05d3\u05e8 \u05d1MATCH)<\/p>\n<p style=\"text-align: right;\">RETURN &#8211; \u05d0\u05d7\u05e8\u05d9 \u05e9\u05d4\u05d2\u05d3\u05e8\u05e0\u05d5 \u05d5\u05e4\u05d9\u05dc\u05d8\u05e8\u05e0\u05d5 \u05d0\u05e4\u05e9\u05e8 \u05dc\u05d4\u05d2\u05d3\u05d9\u05e8 \u05de\u05d4 \u05e0\u05e8\u05e6\u05d4 \u05dc\u05d4\u05d7\u05d6\u05d9\u05e8. \u05e9\u05d9\u05de\u05d5 \u05dc\u05d1 \u05e9\u05d9\u05e9 \u05db\u05d0\u05df \u05d1\u05e2\u05e6\u05dd implicit group by \u05e2\u05dc \u05e4\u05d9 \u05d4\u05e9\u05d3\u05d5\u05ea \u05d4\u05de\u05d5\u05d7\u05d6\u05e8\u05d9\u05dd \u05d5\u05e9\u05d0\u05d9\u05e0\u05dd aggregated (\u05d1\u05de\u05e7\u05e8\u05d4 \u05e9\u05dc\u05e0\u05d5 movie.title)<br \/>\n\u05d5\u05d4\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d4 <a href=\"https:\/\/neo4j.com\/docs\/developer-manual\/current\/cypher\/#aggregation-collect\">collect<\/a> \u05d0\u05d5\u05d2\u05d3\u05ea \u05dc\u05e2\u05e8\u05da \u05d0\u05d7\u05d3 \u05de\u05e1\u05e4\u05e8 \u05e2\u05e8\u05db\u05d9\u05dd.<\/p>\n<p style=\"text-align: right;\">&#8230;<br \/>\n\u05e9\u05d9\u05d7\u05e7\u05ea\u05dd \u05e2\u05dd \u05d4Movie DB =&gt; \u05d1\u05d5\u05d0\u05d5 \u05e0\u05e2\u05d1\u05d5\u05e8 \u05d4\u05dc\u05d0\u05d4.<\/p>\n<p style=\"text-align: right;\">\u05e2\u05db\u05e9\u05d9\u05d5 \u05d4\u05d6\u05de\u05df \u05dc\u05d4\u05d5\u05e8\u05d9\u05d3\u00a0 \u05d5\u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1 DB \u05e9\u05dc \u05de\u05e1\u05de\u05db\u05d9 \u05e4\u05e0\u05de\u05d4 \u05e9\u05d4\u05d5\u05e8\u05d3\u05ea\u05dd. ( <a href=\"https:\/\/cloudfront-files-1.publicintegrity.org\/offshoreleaks\/neo4j\/panama-papers-windows-2016-11-30.zip.torrent#_ga=1.45384612.1448118329.1481020505\">\u05dc\u05d9\u05e0\u05e7 )<\/a><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19\" src=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-DB_Choosing-300x198.png\" alt=\"\" width=\"300\" height=\"198\" srcset=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-DB_Choosing-300x198.png 300w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/Neo4J-DB_Choosing.png 495w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: right;\">\u05e1\u05d3\u05e8 \u05d4\u05e4\u05e2\u05d5\u05dc\u05d5\u05ea \u05d4\u05d5\u05d0:<br \/>\n1. stop<br \/>\n2. choose the &quot;panama-papers-windows\\neo4j.data\\panama.graphdb&quot; directory<br \/>\n3. start<\/p>\n<p>\u05db\u05d3\u05d9 \u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d4\u05db\u05dc \u05e2\u05d1\u05d3 \u05d1\u05d5\u05d0 \u05e0\u05e8\u05d9\u05e5 \u05d0\u05ea \u05d4query :<\/p>\n<div class=\"content code-panel\" style=\"width: 100%; height: auto; text-align: left; direction: ltr;\">\n<pre class=\"code programlisting cm-s-neo cm-s-neo\" style=\"font-size: 16px; font-weight: 100;\" data-lang=\"cypher\">MATCH (a)\r\nwhere \r\na.countries = 'Israel'\r\nRETURN labels(a) , count(*)<\/pre>\n<\/div>\n<p>\u05d5\u05d0\u05e0\u05d7\u05e0\u05d5 \u05d0\u05de\u05d5\u05e8\u05d9\u05dd \u05dc\u05e7\u05d1\u05dc:<\/p>\n<div class=\"datagrid\" style=\"text-align: left; direction: ltr;\">\n<table>\n<thead>\n<tr>\n<th>count(*)<\/th>\n<th>labels(a)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1094<\/td>\n<td>[Officer]<\/td>\n<\/tr>\n<tr class=\"alt\">\n<td>663<\/td>\n<td>[Entity]<\/td>\n<\/tr>\n<tr>\n<td>865<\/td>\n<td>[Address]<\/td>\n<\/tr>\n<tr class=\"alt\">\n<td>146<\/td>\n<td>[Intermediary]<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\u05d5\u05e2\u05db\u05e9\u05d9\u05d5 \u05d0\u05e0\u05d7\u05e0\u05d5 \u05d1\u05ea\u05d5\u05da \u05d4DB \u05e9\u05dc \u05de\u05e1\u05de\u05db\u05d9 \u05e4\u05e0\u05de\u05d4, \u05de\u05d5\u05db\u05e0\u05d9\u05dd \u05dc\u05e7\u05e6\u05ea Forensic accounting.<\/p>\n<p>\u05d4query \u05d4\u05e8\u05d0\u05e9\u05d5\u05df \u05e9\u05e0\u05e8\u05d9\u05e5 \u05d9\u05d4\u05d9\u05d4:<\/p>\n<div class=\"content code-panel\" style=\"width: 100%; height: auto; text-align: left; direction: ltr;\">\n<pre class=\"code programlisting cm-s-neo cm-s-neo\" style=\"font-size: 16px; font-weight: 100;\" data-lang=\"cypher\">MATCH (a)-[*1..1]-(b)\r\nwhere \r\nlabels(a) &lt;&gt; 'Address'\r\nand a.countries = 'Israel'\r\nRETURN a.node_id,labels(a),a.name,count(*) as cnt \r\nORDER BY cnt desc\r\nlimit 10<\/pre>\n<\/div>\n<p>\u05d5\u05e0\u05e7\u05d1\u05dc:<\/p>\n<div class=\"datagrid\" style=\"text-align: left; direction: ltr;\">\n<table>\n<thead>\n<tr>\n<th>a.node_id<\/th>\n<th>labels(a)<\/th>\n<th>a.name<\/th>\n<th>cnt<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>11013202<\/td>\n<td>[Intermediary]<\/td>\n<td>OFIR TSHORNY, ADV (CPA)<\/td>\n<td>215<\/td>\n<\/tr>\n<tr class=\"alt\">\n<td>10165699<\/td>\n<td>[Entity]<\/td>\n<td>ParagonEX Limited<\/td>\n<td>80<\/td>\n<\/tr>\n<tr>\n<td>11003993<\/td>\n<td>[Intermediary]<\/td>\n<td>MORDECHAI KUPERSCHMIDT, ADVOCATE<\/td>\n<td>49<\/td>\n<\/tr>\n<tr class=\"alt\">\n<td>11006928<\/td>\n<td>[Intermediary]<\/td>\n<td>MOSSACK FONSECA &amp; CO. (ISRAEL) LIMITED<\/td>\n<td>24<\/td>\n<\/tr>\n<tr>\n<td>11009424<\/td>\n<td>[Intermediary]<\/td>\n<td>BANK HAPOALIM SWITZERLAND<\/td>\n<td>23<\/td>\n<\/tr>\n<tr class=\"alt\">\n<td>12223915<\/td>\n<td>[Officer]<\/td>\n<td>SEMION BUKHMAN<\/td>\n<td>17<\/td>\n<\/tr>\n<tr>\n<td>10097850<\/td>\n<td>[Entity]<\/td>\n<td>G.S.S. Group Ltd.<\/td>\n<td>16<\/td>\n<\/tr>\n<tr class=\"alt\">\n<td>21957<\/td>\n<td>[Officer]<\/td>\n<td>Tal Hackmey<\/td>\n<td>15<\/td>\n<\/tr>\n<tr>\n<td>11004430<\/td>\n<td>[Intermediary]<\/td>\n<td>LAURENCE WIZEL FAMILY OFFICE<\/td>\n<td>15<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\u05db\u05dc \u05d4\u05d9\u05e9\u05d5\u05d9\u05d5\u05ea \u05d4\u05d0\u05dc\u05d5 \u05de\u05d5\u05e4\u05d9\u05e2\u05d5\u05ea \u05d1\u05de\u05e1\u05de\u05db\u05d9\u05dd.<br \/>\n\u05d5\u05d0\u05e4\u05e9\u05e8 \u05dc\u05d4\u05ea\u05d7\u05d9\u05dc \u05dc\u05e6\u05dc\u05d5\u05dc \u05d5\u05dc\u05e8\u05d0\u05d5\u05ea \u05d0\u05d9\u05da \u05e0\u05e8\u05d0\u05d4 \u05de\u05d4 \u05e9\u05e0\u05d7\u05e9\u05e3.<\/p>\n<p>\u05e0\u05ea\u05de\u05e7\u05d3 \u05dc\u05d3\u05d5\u05d2\u05de\u05d0 \u05d1\u05d9\u05e9\u05d5\u05ea \u05d4\u05e9\u05e0\u05d9\u05d4<br \/>\n\u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d0 \u05d4\u05d1\u05d0\u05d4 \u05de\u05d2\u05d3\u05d9\u05e8\u05d4 \u05ea\u05d1\u05e0\u05d9\u05ea \u05e9\u05dc \u05e7\u05e9\u05e8 \u05d0\u05d7\u05d3 (a \u05de\u05e7\u05d5\u05e9\u05e8 \u05dcb)<br \/>\n\u05de\u05d2\u05d3\u05d9\u05e8\u05d4 \u05d0\u05ea a \u05db\u05d9\u05e9\u05d5\u05ea \u05de\u05e1\u05d5\u05d9\u05d9\u05de\u05ea ( node_id:10165699 ) \u05d5\u05d1\u05e2\u05e6\u05dd \u05de\u05d7\u05d6\u05d9\u05e8\u05d4 \u05d0\u05ea \u05db\u05dc \u05d4\u05e7\u05e9\u05e8\u05d9\u05dd \u05e9\u05dc\u05d5.<\/p>\n<p>\u05d0\u05d7\u05d3 \u05d4\u05d3\u05d1\u05e8\u05d9\u05dd \u05e9\u05de\u05d0\u05d5\u05d3 \u05de\u05e7\u05dc \u05e2\u05dc \u05d4\u05d1\u05e0\u05ea \u05d4\u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05d6\u05d4 \u05d4viewer \u05e9\u05de\u05e6\u05d9\u05d2 \u05d2\u05e8\u05e4\u05d9\u05dd \u05d5\u05de\u05d0\u05e4\u05e9\u05e8 \u05d2\u05dd \u05dc\u05d8\u05d9\u05d9\u05dc \u05d1\u05d4\u05dd.<br \/>\n(\u05de\u05e6\u05d3 \u05e9\u05e0\u05d9 \u05e2\u05d1\u05d5\u05d3\u05d4 \u05d9\u05d5\u05ea\u05e8 \u05de\u05e9\u05de\u05e2\u05d5\u05ea\u05d9\u05ea \u05d0\u05d9\u05ea\u05d5 \u05de\u05e1\u05d1\u05d9\u05e8\u05d4 \u05d0\u05ea \u05d4\u05d2\u05d3\u05d5\u05dc\u05d4 \u05d1\u05de\u05de\u05e9\u05e7 \u05e9\u05dc <a href=\"https:\/\/www.youtube.com\/watch?v=dVsx4I8gkKk\">\u05e4\u05dc\u05e0\u05d8\u05d9\u05e8<\/a>)<\/p>\n<div class=\"content code-panel\" style=\"width: 100%; height: auto; text-align: left; direction: ltr;\">\n<pre class=\"code programlisting cm-s-neo cm-s-neo\" style=\"font-size: 16px; font-weight: 100;\" data-lang=\"cypher\">MATCH (a)-[*1..1]-(b)\r\nwhere \r\na.node_id = \"10165699\"\r\nRETURN a,b<\/pre>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-36\" src=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/ParagonEX-Limited-graph_small-300x132.png\" alt=\"\" width=\"609\" height=\"268\" srcset=\"http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/ParagonEX-Limited-graph_small-300x132.png 300w, http:\/\/www.langdo.com\/blog\/wp-content\/uploads\/2016\/12\/ParagonEX-Limited-graph_small.png 500w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/p>\n<p>\u05de\u05d4 \u05e9\u05d1\u05e2\u05e6\u05dd \u05e8\u05d5\u05d0\u05d9\u05dd \u05db\u05d0\u05df<br \/>\n\u05d6\u05d4 \u05d9\u05e9\u05d5\u05ea \u05de\u05e8\u05db\u05d6\u05d9\u05ea \u05d0\u05d7\u05ea: ParagonEX Limited<br \/>\n\u05e2\u05dd \u05db\u05de\u05d4 \u05e2\u05e9\u05e8\u05d5\u05ea \u05e7\u05e9\u05e8\u05d9\u05dd \u05dc\u05d9\u05e9\u05d5\u05d9\u05d5\u05ea \u05de\u05e1\u05d5\u05d2 Officer \u05e9\u05de\u05d5\u05d2\u05d3\u05e8\u05d5\u05ea \u05db SHAREHOLDER \u05e9\u05e9\u05d9\u05de\u05e9\u05d5 (\u05d0\u05e0\u05d9 \u05de\u05e0\u05d9\u05d7) \u05dc\u05d7\u05dc\u05d5\u05e7\u05ea \u05d0\u05d5\u05e4\u05e6\u05d9\u05d5\u05ea \u05d1\u05d7\u05dc\u05e7\u05df. (\u05e9\u05de\u05d5\u05ea \u05db\u05d2\u05d5\u05df: ESOP for X)<\/p>\n<p>\u05d7\u05dc\u05e7 \u05de\u05d4\u05e9\u05de\u05d5\u05ea \u05e6\u05e4\u05d5 \u05de\u05d0\u05d6 \u05d4\u05e4\u05e8\u05e1\u05d5\u05dd \u05d1\u05e2\u05d9\u05ea\u05d5\u05e0\u05d5\u05ea : ( \u05dc\u05d3\u05d5\u05d2\u05de\u05d0 <a href=\"http:\/\/www.themarker.com\/law\/1.3091782\">\u05db\u05d0\u05df<\/a> )<\/p>\n<p>\u05e8\u05d5\u05e6\u05d9\u05dd \u05dc\u05d3\u05e2\u05ea \u05e2\u05d5\u05d3?<br \/>\n\u05ea\u05d5\u05e8\u05d9\u05d3\u05d5 \u05d5\u05ea\u05e9\u05ea\u05e2\u05e9\u05e2\u05d5<br \/>\nit's that simple<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u05de\u05e1\u05de\u05db\u05d9 \u05e4\u05e0\u05de\u05d4 \u05d4\u05dd \u05db\u05d9\u05e0\u05d5\u05d9 \u05dc\u05d4\u05d3\u05dc\u05e4\u05ea \u05e2\u05e0\u05e7 \u05e9\u05dc \u05de\u05e1\u05de\u05db\u05d9 \u05de\u05e9\u05e8\u05d3 \u05e2\u05d5\u05e8\u05db\u05d9 \u05d3\u05d9\u05df \u05e4\u05e0\u05de\u05d9 \u05e9\u05de\u05ea\u05e2\u05e1\u05e7 \u05db\u05e0\u05e8\u05d0\u05d4 \u05d1\u05e2\u05d9\u05e7\u05e8 \u05d1\u05d4\u05e7\u05de\u05ea \u05d7\u05d1\u05e8\u05d5\u05ea \u05e7\u05e9 \u05d1\u05de\u05e7\u05dc\u05d8\u05d9 \u05de\u05e1. \u05d4\u05db\u05e0\u05e8\u05d0\u05d4 \u05de\u05e6\u05d1\u05d9\u05e2 \u05e2\u05dc \u05d6\u05d4 \u05e9\u05d0\u05d9\u05df \u05dc\u05d9 \u05db\u05d5\u05d5\u05e0\u05d4 \u05dc\u05d8\u05e2\u05d5\u05df \u05d1\u05e0\u05d7\u05e8\u05e6\u05d5\u05ea \u05d3\u05d1\u05e8\u05d9\u05dd \u05dc\u05d2\u05d1\u05d9 \u05d0\u05e3 \u05d0\u05d7\u05ea \u05de\u05d4\u05d9\u05e9\u05d5\u05d9\u05d5\u05ea \u05e9\u05d9\u05e6\u05d5\u05e6\u05d5 \u05d1\u05e7\u05d1\u05e6\u05d9\u05dd. \u05d0\u05dd \u05db\u05d1\u05e8 \u05e0\u05d0\u05de\u05e8 \u05de\u05e9\u05d4\u05d5 &#8211; \u05d4\u05db\u05dc \u05d9\u05d4\u05d9\u05d4 \u05e2\u05dc \u05e4\u05d9 \u05de\u05e7\u05d5\u05e8\u05d5\u05ea \u05d6\u05e8\u05d9\u05dd. \u05db\u05d5\u05d5\u05e0\u05ea \u05d4\u05e4\u05d5\u05e1\u05d8 \u05d4\u05d9\u05d0 \u05e8\u05e7 \u05dc\u05e1\u05e4\u05e7 \u05e7\u05e8\u05e7\u05e2 \u05e0\u05d5\u05d7\u05d4 \u05d5\u05de\u05e2\u05e0\u05d9\u05d9\u05e0\u05ea &hellip; <a href=\"http:\/\/www.langdo.com\/blog\/2016\/12\/08\/neo4j_101\/\" class=\"more-link\">\u05dc\u05d4\u05de\u05e9\u05d9\u05da \u05dc\u05e7\u05e8\u05d5\u05d0 <span class=\"screen-reader-text\">Forensic accounting \/ Neo4J 101<\/span> <span class=\"meta-nav\">&larr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":36,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-2"],"_links":{"self":[{"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/posts\/1","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/comments?post=1"}],"version-history":[{"count":10,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":47,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/posts\/1\/revisions\/47"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/media\/36"}],"wp:attachment":[{"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/media?parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/categories?post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.langdo.com\/blog\/wp-json\/wp\/v2\/tags?post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}