From 3b9bbc8464fa0bc7105b656c0a83c0d1b2b94600 Mon Sep 17 00:00:00 2001 From: David Kaufmann Date: Sun, 16 Jun 2019 22:18:20 +0200 Subject: [PATCH] add first ex3.3 results --- ex3/main.tex | 30 ++++++++++++++++++++++++++++ ex3/main_3.tex | 41 +++++++++++++++++++++++++++----------- ex3/results/result_3a.tex | 27 +++++++++++++++++++++++++ ex3/results/result_3b1.tex | 27 +++++++++++++++++++++++++ ex3/results/result_3b2.tex | 27 +++++++++++++++++++++++++ ex3/results/result_3b3.tex | 23 +++++++++++++++++++++ 6 files changed, 163 insertions(+), 12 deletions(-) create mode 100644 ex3/results/result_3a.tex create mode 100644 ex3/results/result_3b1.tex create mode 100644 ex3/results/result_3b2.tex create mode 100644 ex3/results/result_3b3.tex diff --git a/ex3/main.tex b/ex3/main.tex index be2c171..d1e1ad0 100644 --- a/ex3/main.tex +++ b/ex3/main.tex @@ -40,6 +40,36 @@ {\end{ex} % } +\usepackage{listings} +\usepackage{color} + +\definecolor{backcolour}{rgb}{0.95,0.95,0.92} +\lstdefinestyle{block}{ + backgroundcolor=\color{white}, + basicstyle=\small\ttfamily, + columns=flexible, + breaklines=true, + showstringspaces=false +} +\lstdefinestyle{command}{ + backgroundcolor=\color{backcolour}, + basicstyle=\small\ttfamily, + columns=flexible, + breaklines=true, + showspaces=false, + showstringspaces=false, + frame=single +% xleftmargin=0pt, +% xrightmargin=0pt, +% breakindent=0pt, +% resetmargins=true +} +\lstset{style=block} +\usepackage{array} +\newcolumntype{P}[1]{>{\centering\arraybackslash}p{#1}} +\newcolumntype{M}[1]{>{\arraybackslash}p{#1}} + + %% HINWEIS! %% %% Die vorgegebene Formatierung der Loesung ist nur als diff --git a/ex3/main_3.tex b/ex3/main_3.tex index ca1f8e1..cf0ccfa 100644 --- a/ex3/main_3.tex +++ b/ex3/main_3.tex @@ -5,16 +5,17 @@ \begin{itemize} \item\textbf{List all the distinct countries for which addresses are registered in the database.} - \begin{verbatim} - MATCH (n:Address) RETURN DISTINCT n.countries - \end{verbatim} + \begin{lstlisting}[style=command] +MATCH (n:Address) RETURN DISTINCT n.countries AS countries + \end{lstlisting} This returns 222 different countries. We chose ''Austria''. \item\textbf{Choose one of these countries and list 5 entities which are based in that country.} - \begin{verbatim} - MATCH (n:Address {countries: 'Austria'})<-[r:REGISTERED_ADDRESS]-(e:Entity) - RETURN DISTINCT e LIMIT 5 - \end{verbatim} + \begin{lstlisting}[style=command] +MATCH (n:Address {countries: 'Austria'})<-[r:REGISTERED_ADDRESS]-(e:Entity) + RETURN DISTINCT e AS entity LIMIT 5 + \end{lstlisting} + \input{results/result_3a.tex} \end{itemize} \item \begin{enumerate}[label=\theenumiii] @@ -22,13 +23,29 @@ those 10 intermediaries that have the most outgoing \texttt{INTERMEDIARY\_OF} edges. Output the name of the intermediary as well as the number of relevant edges.} - \item\textbf{Extend the query of i to also count outgoing + \begin{lstlisting}[style=command] +MATCH (n:Intermediary)-[r:INTERMEDIARY_OF]->() + RETURN n.name AS name, COUNT(r) AS count ORDER BY count DESC LIMIT 10 + \end{lstlisting} + \input{results/result_3b1.tex} + \item\textbf{Extend the query of \texttt{i} to also count outgoing \texttt{OFFICER\_OF} edges to determine the top intermediaries. Output the name of the intermediary as well as the number of relevant edges.} - \item\textbf{For the top intermediary from query ii, output all the - outgoing edges, except for those that have type either - \texttt{OFFICER\_OF} or \texttt{INTERMEDIARY\_OF}. Also output - the respective nodes at the other side of the edges.} + \begin{lstlisting}[style=command] +MATCH (n:Intermediary)-[r:INTERMEDIARY_OF|OFFICER_OF]->() + RETURN n.name AS name, COUNT(r) AS count ORDER BY count DESC LIMIT 10 + \end{lstlisting} + \input{results/result_3b2.tex} + \item\textbf{For the top intermediary from query \texttt{ii}, + output all the outgoing edges, except for those that have type + either \texttt{OFFICER\_OF} or \texttt{INTERMEDIARY\_OF}. Also + output the respective nodes at the other side of the edges.} + \begin{lstlisting}[style=command] +MATCH (n:Intermediary {node_id: "54662"})-[r]->(t) + WHERE NOT (n)-[r:INTERMEDIARY_OF|OFFICER_OF]->(t) + RETURN type(r) AS relation, t.node_id AS node + \end{lstlisting} + \input{results/result_3b3.tex} \end{enumerate} \end{enumerate} diff --git a/ex3/results/result_3a.tex b/ex3/results/result_3a.tex new file mode 100644 index 0000000..54ad7d2 --- /dev/null +++ b/ex3/results/result_3a.tex @@ -0,0 +1,27 @@ +\lstset{style=block} +\begin{tabular}{ |M{12.5cm}| } +\hline +entity \\ +\hline +\hline +\begin{lstlisting} +"{sourceID:Paradise Papers - Appleby,closed_date:15-JUN-2007,valid_until:Appleby data is current through 2014,ibcRUC:127348,jurisdiction:KY,name:Latintrade Ltd. ** INCOMPLETE **,country_codes:AUT;CYM,service_provider:Appleby,countries:Austria;Cayman Islands,jurisdiction_description:Cayman Islands,incorporation_date:11-JUL-2003,node_id:82002136}" +\end{lstlisting} \\ +\hline +\begin{lstlisting} +"{sourceID:Paradise Papers - Appleby,closed_date:15-JUN-2007,valid_until:Appleby data is current through 2014,ibcRUC:130370,jurisdiction:KY,name:Agro Commodity Ltd. ** INCOMPLETE **,country_codes:AUT;CYM,service_provider:Appleby,countries:Austria;Cayman Islands,jurisdiction_description:Cayman Islands,incorporation_date:07-NOV-2003,node_id:82002216}" +\end{lstlisting} \\ +\hline +\begin{lstlisting} +"{sourceID:Panama Papers,jurisdiction:BVI,struck_off_date:30-APR-2008,service_provider:Mossack Fonseca,countries:Austria,jurisdiction_description:British Virgin Islands,valid_until:The Panama Papers data is current through 2015,ibcRUC:191199,name:ELITE TECHNOLOGIES LIMITED,country_codes:AUT,inactivation_date:02-MAY-2008,incorporation_date:04-JUL-1996,node_id:10071089,status:Defaulted}" +\end{lstlisting} \\ +\hline +\begin{lstlisting} +"{sourceID:Offshore Leaks,valid_until:The Offshore Leaks data is current through 2010,jurisdiction:XXX,name:The Internet Consulting Corporation,country_codes:AUT;XXX,service_provider:Commonwealth Trust Limited,countries:Austria;Not identified,jurisdiction_description:Undetermined,incorporation_date:18-JUL-1997,node_id:195933,status:Dead}" +\end{lstlisting} \\ +\hline +\begin{lstlisting} +"{sourceID:Offshore Leaks,company_type:Business Company Limited by Shares,jurisdiction:XXX,service_provider:Commonwealth Trust Limited,countries:Austria;British Virgin Islands,jurisdiction_description:Undetermined,valid_until:The Offshore Leaks data is current through 2010,ibcRUC:1010445,name:MIRA CONSTRUCTION AND DEVELOPMENT CORPORATION,country_codes:AUT;VGB,incorporation_date:13-FEB-2006,node_id:227537,status:Dead}" +\end{lstlisting} \\ +\hline +\end{tabular} \ No newline at end of file diff --git a/ex3/results/result_3b1.tex b/ex3/results/result_3b1.tex new file mode 100644 index 0000000..d4a6cfd --- /dev/null +++ b/ex3/results/result_3b1.tex @@ -0,0 +1,27 @@ +\lstset{style=block} +\begin{tabular}{ |M{9.5cm}|P{3cm}| } +\hline +name & count \\ +\hline +\hline +\verb|Morning Star Holdings Limited| & 35358 \\ +\hline +\verb|MOSSACK FONSECA & CO. (BAHAMAS) LIMITED| & 14903 \\ +\hline +\verb|UBS TRUSTEES (BAHAMAS) LTD.| & 9731 \\ +\hline +\verb|CREDIT SUISSE TRUST LIMITED| & 8305 \\ +\hline +\verb|TRIDENT CORPORATE SERVICES (BAH) LTD| & 8302 \\ +\hline +\verb|MMG BAHAMAS LTD.| & 8157 \\ +\hline +\verb|Internal User| & 7900 \\ +\hline +\verb|ORION HOUSE SERVICES (HK) LIMITED| & 7017 \\ +\hline +\verb|Unitrust Corporate Services Ltd.| & 5699 \\ +\hline +\verb|K.M.C. CORPORATE SERVICES LTD.| & 5318 \\ +\hline +\end{tabular} \ No newline at end of file diff --git a/ex3/results/result_3b2.tex b/ex3/results/result_3b2.tex new file mode 100644 index 0000000..81e3a11 --- /dev/null +++ b/ex3/results/result_3b2.tex @@ -0,0 +1,27 @@ +\lstset{style=block} +\begin{tabular}{ |M{9.5cm}|P{3cm}| } +\hline +name & count \\ +\hline +\hline +\verb|Portcullis TrustNet (BVI) Limited| & 36375 \\ +\hline +\verb|Morning Star Holdings Limited| & 35358 \\ +\hline +\verb|MOSSACK FONSECA & CO. (BAHAMAS) LIMITED| & 14903 \\ +\hline +\verb|UBS TRUSTEES (BAHAMAS) LTD.| & 9731 \\ +\hline +\verb|CREDIT SUISSE TRUST LIMITED| & 8305 \\ +\hline +\verb|TRIDENT CORPORATE SERVICES (BAH) LTD| & 8302 \\ +\hline +\verb|MMG BAHAMAS LTD.| & 8157 \\ +\hline +\verb|Internal User| & 7900 \\ +\hline +\verb|ORION HOUSE SERVICES (HK) LIMITED| & 7017 \\ +\hline +\verb|Unitrust Corporate Services Ltd.| & 5699 \\ +\hline +\end{tabular} \ No newline at end of file diff --git a/ex3/results/result_3b3.tex b/ex3/results/result_3b3.tex new file mode 100644 index 0000000..025f81f --- /dev/null +++ b/ex3/results/result_3b3.tex @@ -0,0 +1,23 @@ +\lstset{style=block} +\begin{tabular}{ |M{9.5cm}|P{3cm}| } +\hline +relation & node \\ +\hline +\hline +\verb|REGISTERED_ADDRESS| & 269677 \\ +\hline +\verb|REGISTERED_ADDRESS| & 236879 \\ +\hline +\verb|REGISTERED_ADDRESS| & 236748 \\ +\hline +\verb|REGISTERED_ADDRESS| & 236931 \\ +\hline +\verb|REGISTERED_ADDRESS| & 250183 \\ +\hline +\verb|REGISTERED_ADDRESS| & 254223 \\ +\hline +\verb|REGISTERED_ADDRESS| & 236724 \\ +\hline +\verb|UNDERLYING| & 90485 \\ +\hline +\end{tabular} -- 2.43.0