caa.tex

\documentclass[xcolor=x11names, aspectratio=169,usenames,dvipsnames]{beamer}
\usepackage[british]{babel}
\usepackage{amsmath}
\usepackage{amssymb}
\usepackage{amsfonts}
\usepackage{mathpazo}
\usepackage{enumerate}
\usepackage{setspace}
\usepackage{array,booktabs}
\usepackage{tikz}
\usepackage{verbatim}
\usepackage{multirow}
\usepackage{appendixnumberbeamer}
\usepackage{tabularx}
\usetikzlibrary{overlay-beamer-styles,shadows,matrix,backgrounds,patterns,arrows,decorations.markings,shapes,positioning,calc,chains,scopes,fit}
\usepackage{caption}

\usetheme[titleformat title=regular,titleformat frame=regular,titleformat section=allcaps,numbering=fraction]{metropolis}

\author[Felix Kußmaul]{\large Felix Kußmaul\inst{1}}
\title[FMSync]{\Large FMSync}
\subtitle{\normalsize An Open Source Solution for Synchronising Distributed Archaeological Databases in a Centralised Open Access System}
\institute[Cologne]{\inst{1} Archaeological Institute, University of Cologne}
\date[\today]{\vspace*{1em}CAA 2018, Tübingen\\[.5em] 21 March 2018\vspace*{1em}}

\titlegraphic{
    \tikz[overlay,remember picture]
        \node[xshift=-17em,yshift=13em,at=(current page.south east), anchor=north west] {
            \includegraphics[width=0.55\textwidth]{img/uni.eps}
        };
}
\input{config.tex}
\definecolor{morange}{HTML}{FF8200}
\metroset{block=fill}

\setbeamercolor{background canvas}{bg=white}
 
\begin{document}

\begin{frame}[plain]
\titlepage
\end{frame}

\section{Motivation}

\begin{frame}{Status Quo}\large
\textbf{FileMaker} is widespread across archaeological projects. \alert{\textbf{Problems:}}
\begin{spacing}{1.5}
\begin{enumerate}[<+->]
\item FileMaker products have \textbf{expensive license} concepts (Apple)

$\Rightarrow$ everyone just uses the \textbf{offline} license FM Pro
\item FM Pro does not include mechanisms for sharing or publishing data

$\Rightarrow$ everyone has \textbf{independent} database instances
\item Independent FM Pro databases cannot simply be merged
\end{enumerate}
\end{spacing}
\end{frame}

\begin{frame}{FileMaker Pro: Sharing Data}
\begin{figure}
	\begin{tikzpicture}
\only<1-4>{\draw[thick, dashed,gray] (5.75,-3) -- (5.75,3);}
\only<5->{\draw[thick, dashed,gray] (5.75,-4.7) -- (5.75,2);}
\node (pc) at (0,0) {\reflectbox{\includegraphics[width=2cm]{img/pc.jpg}}};
\node[right of=pc, node distance=11.5cm] (pc2) {\includegraphics[width=2cm]{img/pc.jpg}};
\node[left of=pc2, node distance=3em] (db3) {\includegraphics[width=2em]{img/db2}};
\node[below of=pc, node distance=4em] {\large FileMaker $A$};
\node[below of=pc2, node distance=4em] {\large FileMaker $B$};
\node[right of=pc, node distance=3em] (db) {\includegraphics[width=2em]{img/db}};
\only<2->{
	\node[right of=pc, node distance=4cm](usb) {\includegraphics[width=3em]{img/usb}};
	\node[below right of=usb, node distance=1em] (db2) {\includegraphics[width=1em]{img/db}};
	\draw[arrows=-latex,ultra thick] (db) -- node [above] {\small{copy}} (usb);
}
\only<3->{
	\node[right of=usb, node distance=3.5cm](usb2) {\includegraphics[width=3em]{img/usb}};
	\node[below right of=usb2, node distance=1em] (db4) {\includegraphics[width=1em]{img/db}};
	\draw[arrows=-latex,ultra thick] (usb) -- node[above] (box) {\includegraphics[width=3em]{img/box}} (usb2);
}
\only<4->{
	\node[below left of=db3, node distance=1em] (dbb3) {\includegraphics[width=2em]{img/db}};
	\draw[arrows=-latex,ultra thick] (usb2) -- node [above] {\small{copy}} (dbb3);
}
\only<5->{
	\node[below of=usb, node distance=3cm](usbb) {\includegraphics[width=3em]{img/usb}};
	\node[below right of=usbb, node distance=1em] (db2b) {\includegraphics[width=1em]{img/db2}};
	\node[below right of=db, node distance=1em] (db3b) {\includegraphics[width=2em]{img/db2}};
	\draw[arrows=-latex,ultra thick] (usbb) -- node [below left] {\small{copy}} (db3b);
	\node[right of=usbb, node distance=3.5cm](usb2b) {\includegraphics[width=3em]{img/usb}};
	\node[below right of=usb2b, node distance=1em] (db4b) {\includegraphics[width=1em]{img/db2}};
	\draw[arrows=-latex,ultra thick] (usb2b) -- node[above] (boxb) {\includegraphics[width=3em]{img/box}} (usbb);
%	\node[right of=pcb, node distance=11.5cm] (pc2b) {\includegraphics[width=2cm]{img/pc.jpg}};
%	\node[below left of=db3b, node distance=1em] {\includegraphics[width=2em]{img/db}};
	\draw[arrows=-latex,ultra thick] (dbb3) -- node [below right] {\small{copy}} (usb2b);
}
\end{tikzpicture}
\end{figure}
\end{frame}

\begin{frame}{FileMaker Pro: Publishing Data}
\begin{figure}
	\vspace{-2.5em}
	\begin{tikzpicture}
	\draw[thick, dashed,gray] (5.75,-3) -- (5.75,3);
	\node (pc) at (0,0) {\reflectbox{\includegraphics[width=2cm]{img/pc.jpg}}};
	\node[below of=pc, node distance=4em] {\large FileMaker};
	\node[right of=pc, node distance=3em] (db) {\includegraphics[width=2em]{img/db}};
	\node[right of=pc, node distance=11cm] (pc2) {\includegraphics[width=3cm]{img/serv.pdf}};
	\node[below of=pc2, node distance=4em] {\large MySQL / Oracle / \dots};
	
	\visible<2>{
		\node at ($(db)!0.5!(pc)$) {\reflectbox{\includegraphics[width=3.5cm]{img/x}}};
	}
	
	\visible<3->{
		\node[right of=pc, node distance=4cm](usb) {\includegraphics[width=3em]{img/usb}};
		\node[below right of=usb, node distance=1em] (db2) {\includegraphics[width=1em]{img/db}};
		\draw[arrows=-latex,ultra thick] (db) -- node [above] {\small{copy}} (usb);
	
		\node[right of=usb, node distance=3.5cm](usb2) {\includegraphics[width=3em]{img/usb}};
		\node[below right of=usb2, node distance=1em] (db4) {\includegraphics[width=1em]{img/db}};
		\draw[arrows=-latex,ultra thick] (usb) -- node[above] (box) {\includegraphics[width=3em]{img/box}} (usb2);
%		\draw[arrows=-latex,ultra thick] (usb2) -- (pc2);
	}
	
	\visible<4->{
		\node at (10,0) {\includegraphics[width=5cm]{img/no-fucks-given.jpg}};
	}
	\end{tikzpicture}
\end{figure}
\end{frame}

\section{Approach}

\begin{frame}{FMSync: Topology}
\begin{figure}
	\includegraphics[height=.8\textheight]{img/topo.pdf}
\end{figure}
\end{frame}

\begin{frame}{Wait a second!}\large
Yo, Felix! 'Tis nuthin nu.\pause\bigskip

\normalsize

\begin{quote}
	\textbf{SymmetricDS} supports [\dots] \alert{Oracle}, \alert{MySQL}, MariaDB, \alert{PostgreSQL}, MS SQL Server (including Azure), IBM DB2 (UDB, iSeries, and zSeries), H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, \alert{SQLite}, Sybase ASE, Sybase ASA (SQL Anywhere), Amazon Redshift, \alert{MongoDB}, and VoltDB databases.
\end{quote}\vspace{-1em}
\begin{flushright}
	\texttt{https://www.symmetricds.org/}
\end{flushright}
\end{frame}

\begin{frame}{FileMaker Solution}
\begin{figure}
\includegraphics[width=\linewidth]{img/order.png}
\end{figure}\vspace{-2em}
\begin{itemize}
\item Proprietary, badly written software
\item Still totally not worth the price
\end{itemize}
\end{frame}

\begin{frame}{Our Solution}\large
\dots\ is better than the existing ones, since

\begin{itemize}[<+->]
	\item it is \alert{open source} (GPL 3 license)
	\item it is free
	\item it allows \alert{open access} scenarios
	\item it is Java-based, thus \alert{platform-independent} and flexible
	\item it is user-friendly
	\item it allows to already \textbf{\alert{keep data in sync} while collecting}
\end{itemize}
\end{frame}

\section{Implementation}

\begin{frame}{Main Window}
\begin{figure}
	\includegraphics[width=\linewidth]{img/main}
\end{figure}
\end{frame}

\begin{frame}{Detail Window}
\begin{figure}
	\includegraphics[width=\linewidth]{img/diff}
\end{figure}
\end{frame}

\begin{frame}{Foreign Key Difficulty}\ttfamily\footnotesize
\begin{figure}
	\begin{tikzpicture}[/tikz/ampersand replacement=\&, label distance=.5cm,  every node/.style = {anchor= north west},every label/.style={font=\normalsize\sffamily\bfseries},
		table/.style={matrix of nodes, nodes in empty cells, column sep=-\pgflinewidth, row sep=-\pgflinewidth, nodes={draw,text depth=.5ex,text height=2ex,minimum width=2.5em}, row 1/.style={font=\bfseries, nodes={fill=lightgray!50,minimum height=1.7em}}}]
		
		\matrix(tl) [table, label=left:Type] {
			ID \& \dots \& FK\_Fabric \& \dots\only<1,3->{\\
			14 \& \dots \& \phantom{FKhl}3\phantom{abri} \& \dots}\only<2>{\\
			14 \& \dots \&|[fill=Green!40]| \phantom{FKhl}3\phantom{abri} \& \dots} \\};
		
		\matrix(fl) [table, label=left:Fabric, below=2.5cm of tl.south west,right] {
			ID \& color\&\dots\only<1,3->{\\
			3 \& brown\&\dots}
			\only<2>{\\
			|[fill=Green!40]| 3 \& brown\&\dots}\\};
	
	\visible<2>{\draw[ultra thick,->,color=OliveGreen!50!Green] (tl-2-3.south)-- (fl-2-1.north);}	
	
	\visible<3->{
		\draw[thick, dashed,gray] (5.75,-5.5) -- (5.75,0.5);
		\matrix(tr) [table, right=7cm of tl.north west, anchor=north west] {
			ID \& \dots \& FK\_Fabric \& \dots \\
			105 \& \dots \& \phantom{FKhl}x\phantom{abri} \& \dots\only<5,6>{\\
			106 \& \dots \& \phantom{FKhl}3\phantom{abri} \& \dots}\only<4>{\\
			|[fill=Green!40]| 106 \& \dots \& \phantom{FKhl}3\phantom{abri} \& \dots}\only<7->{\\
			106 \& \dots \&|[fill=red!40]|  \phantom{FKhl}3\phantom{abri} \& \dots} \\};
		
		\matrix(fr) [table, right=7cm of fl.north west, anchor=north west] {
			ID \& color\&\dots \\
			81 \& red\phantom{xt}\&\dots\only<6>{\\
			82 \& brown\&\dots}\only<5>{\\
			|[fill=Green!40]| 82 \& brown\&\dots}\only<7->{\\
			|[fill=red!40]| 82 \& brown\&\dots} \\};
	}
	\only<4>{\draw[ultra thick,->,color=OliveGreen!50!Green] (tl-2-4.east)-- node[above]{insert} (tr-3-1.west);}
	\only<5>{\draw[ultra thick,->,color=OliveGreen!50!Green] (fl-2-3.east)-- node[above]{insert} (fr-3-1.west);}
	\only<8>{\draw[ultra thick,->,color=red] (tr-3-3.south)--($(fr-1-1.north)+(0,0.5)$) node[below]{\dots} ;}
	\end{tikzpicture}
\end{figure}
\end{frame}

\begin{frame}{Solution Example}\ttfamily\scriptsize
\begin{figure}
	\begin{tikzpicture}[/tikz/ampersand replacement=\&, every node/.style = {anchor= north west},every label/.style={font=\normalsize\sffamily\bfseries},
	table/.style={matrix of nodes, nodes in empty cells, column sep=-\pgflinewidth, row sep=-\pgflinewidth, nodes={draw,text depth=.5ex,text height=2ex,minimum width=2.5em}, row 1/.style={font=\bfseries, nodes={fill=lightgray!50,minimum height=1.7em}}}]
	
	\matrix(typea) [table, label=left:\rotatebox{90}{Type}] {
		ID \& \dots \& FKF \& FKP\only<1>{\\
		5 \& \dots \& 29 \& 8}\only<2->{\\
		5 \& \dots \&|[fill=violet!40]| 29 \&|[fill=orange!40]| 8} \\};
		
	\matrix(fabrica) [table, label=left:\rotatebox{90}{Fabric}, below left=1cm of typea.south] {
		ID \& \dots \& FKC \only<1>{\\
		29 \& \dots \& 3 }\only<2->{\\|[fill=violet!40]|
		29 \& \dots \&|[fill=NavyBlue!40]| 3}\\};
		
	\matrix(placea) [table, label=left:\rotatebox{90}{Place}, right=5em of fabrica.north east,anchor=north west] {
		ID \& \dots \only<1>{\\
		8 \& \dots}\only<2->{\\|[fill=orange!40]|
		8 \& \dots}\\};
	
	\matrix(colora) [table, label=left:\rotatebox{90}{Color}, below right=1cm of fabrica.south west] {
		ID \& color\&\dots\only<1>{\\
		3 \& brown\&\dots}\only<2->{\\|[fill=NavyBlue!40]| 
		3 \& brown\&\dots}\\};
	
	\visible<3->{
		\draw[thick, dashed, gray] (5,-5.5) -- (5,0.5);
		\visible<4->{
			\matrix(colorb) [table, label=left:\rotatebox{90}{Color}, right=5cm of colora] {
				ID \& color\&\dots\only<8-12>{\\
				19 \& brown\&\dots}\only<4>{\\|[fill=Green!40]| 
				19 \& brown\&\dots}\only<5-7,13>{\\|[fill=NavyBlue!40]| 
				19 \& brown\&\dots}\\};
		}
		\visible<6->{
			\matrix(fabricb) [table, label=left:\rotatebox{90}{Fabric}, above left=1cm of colorb, anchor=south west] {
				ID \& \dots \& FKC\only<6>{\\|[fill=Green!40]|
				45 \& \dots \& 19}\only<8-12>{\\|[fill=violet!40]|
				45 \& \dots \& 19}\only<7,13>{\\|[fill=violet!40]|
				45 \& \dots \&|[fill=NavyBlue!40]| 19}\\};
		}
		\visible<9->{
			\matrix(placeb) [table, label=left:\rotatebox{90}{Place}, right=5em of fabricb.north east,anchor=north west] {
				ID \& \dots\only<9>{\\|[fill=Green!40]|
				67 \& \dots}\only<10-13>{\\|[fill=orange!40]|
				67 \& \dots}\\};
		}
		\visible<11->{
			\matrix(typeb) [table, label=left:\rotatebox{90}{Type}, above right=1cm of fabricb, anchor=south] {
				ID \& \dots \& FKF \& FKP\only<11>{\\|[fill=Green!40]|
				98 \& \dots \& 45 \& 67}\only<12->{\\
				98 \& \dots \&|[fill=violet!40]| 45 \&|[fill=orange!40]| 67} \\};
		}
	}
	
	\only<2->{
		\draw[ultra thick,->,color=violet] (typea-2-3.south)-- (fabrica-2-1.north);
		\draw[ultra thick,->,color=orange] (typea-2-4.south)-- (placea-2-1.north);
		\draw[ultra thick,->,color=NavyBlue] (fabrica-2-3.south)-- (colora-2-1.north);
	}
	\only<4>{\draw[ultra thick,->,color=OliveGreen!50!Green] (colora-2-3.east)-- node[above]{insert} (colorb-2-1.west);}
	\only<6>{\draw[ultra thick,->,color=OliveGreen!50!Green,bend right=25] (fabrica-2-3.south east) to node[above]{insert} node[below,color=NavyBlue]{\textbf{FKC=19}} (fabricb-2-1.south west);}
	\only<7,13>{\draw[ultra thick,->,color=NavyBlue](fabricb-2-3.south) -- (colorb-2-1.north);}
	\only<9>{\draw[ultra thick,->,color=OliveGreen!50!Green,bend right=20] (placea-2-2.south east) to node[above]{insert} (placeb-2-1.south west);}
	\only<11>{\draw[ultra thick,->,color=OliveGreen!50!Green] (typea-2-4.east) to node[above]{insert} node[below]{\textbf{\textcolor{violet}{FKF=45}}\quad\textbf{\textcolor{orange}{FKP=67}}}  (typeb-2-1.west);}
	\only<12->{\draw[ultra thick,->,color=violet](typeb-2-3.south) -- (fabricb-2-1.north);}
	\only<12->{\draw[ultra thick,->,color=orange](typeb-2-4.south) -- (placeb-2-1.north);}
	\end{tikzpicture}
\end{figure}
\end{frame}

\begin{frame}{Outlook}\large
\begin{center}\LARGE
\includegraphics[width=1em]{img/github}\  \texttt{horle/fmsync}
\end{center}

FMSync is in an \textbf{early alpha} state.\pause

\begin{itemize}[<+->]
\item Foreign key handling is \emph{not} implemented \emph{yet}
\item Currently designed for CeramEgypt and Arachne, needs generalisation!
\item Many things to optimise, e.\,g.\ UI behaviour
\end{itemize}
\end{frame}

\begin{frame}[plain,standout]
\vfill
\begin{center}\Large
Thank you very much for your attention!\\\bigskip

Questions?
\end{center}\vfill
\end{frame}

\maketitle

\appendix

\begin{frame}{Foreign Key Difficulty: Solution (simplified)}\large\ttfamily
\begin{spacing}{1.5}
\begin{tabbing}
\textbf{For each} new row:\\
\qquad\= \textbf{If} row contains \alert{further FK's}, then \textbf{for each} FK:\\
\>\qquad\= Jump into referenced table, start over;\\
\> \textbf{Else:}\\
\>\> Check for duplicates in target DB and \alert{insert row};\\
\>\> \alert{Replace returned ID in parent row's FK field};
\end{tabbing}
\end{spacing}
\end{frame}

\end{document}