\NeedsTeXFormat{LaTeX2e}
\documentclass[11pt,pdf,serpaggi,slideColor,colorBG,accumulate,nototal]{prosper}
\usepackage{hyperref}
\usepackage{graphicx}

\newcommand{\mygraphic}[2][width=3in]{
    \begin{center}
    \includegraphics[#1]{#2}
    \end{center}
}

\begin{document}

\title{
    Achieving Flexibility in Wireless Network Simulation Data Processing
    by Logging and Using SQL
}
\author{
    David Baird
}
\date{
    March 23, 2005
}
\institution{
    Electrical Engineering Department\\
    New Mexico Institute of Mining and Technology\\
    Socorro, New Mexico 87801
}
\maketitle

\begin{slide}{Introduction}
    \begin{itemize}
    \item Export simulation data into a simple tabular format
    \item Use SQL to process and filter the data
    \end{itemize}
\end{slide}

\begin{slide}{Background}
    \begin{itemize}
    \item SQL is a language for asking questions about data stored
        in tables
    \item A schema is a collection of table definitions
    \end{itemize}
\end{slide}

\begin{slide}{Background: Example}
    Here is the schema:
    {
        \tiny
        \begin{itemize}
        \item CREATE TABLE students (student\_id, name, birthyear, gender)
        \item CREATE TABLE classes (class\_id, name)
        \item CREATE TABLE grades (student\_id, class\_id, points)
        \end{itemize}
    }
\end{slide}

\begin{slide}{Background: Example}
    Here is the data: \\
    {
    \tiny
    \begin{minipage}{24em}
        students: \\
        \begin{tabular}{|l|l|l|l|}
        \hline
        student\_id & name & birthyear & gender \\ \hline \hline
        1 & Kadjo & 1979 & M \\ \hline
        2 & Baird & 1981 & M \\ \hline
        3 & Goober & 1800 & M \\ \hline
        \end{tabular}
    \end{minipage}
    \begin{minipage}{15em}
        grades: \\
        \begin{tabular}{|l|l|l|}
        \hline
        student\_id & class\_id & points \\ \hline \hline
        1 & ECON490 & 1.0 \\ \hline
        2 & ECON490 & 2.0 \\ \hline
        2 & EE231 & 3.0 \\ \hline
        3 & EE231 & 4.0 \\ \hline
        \end{tabular}
    \end{minipage}
    \begin{minipage}{15em}
        classes: \\
        \begin{tabular}{|l|l|}
        \hline
        class\_id & name \\ \hline \hline
        ECON490 & IT Economics \\ \hline
        EE231 & Digital Electronics \\ \hline
        \end{tabular}
    \end{minipage}
    }
\end{slide}

\begin{slide}{Background: Example}
Here are some queries: \\ \vspace{1em}
    {
    \tiny
    \begin{minipage}{24em}
\begin{verbatim}
SELECT c.name,
       SUM(g.points)/COUNT(g.points)
    FROM grades AS g,
         classes AS c
    WHERE g.class_id = c.class_id
    GROUP BY c.class_id;
\end{verbatim}
    \end{minipage}
    \begin{minipage}{15em}
        \begin{tabular}{|l|l|}
        \hline
        class\_name & average\_points \\ \hline \hline
        IT Economics & 1.5 \\ \hline
        Digital Electronics & 3.5 \\ \hline
        \end{tabular}
    \end{minipage}
    \\ \vspace{2em}
    \begin{minipage}{24em}
\begin{verbatim}
SELECT s.name,
       SUM(g.points)/COUNT(g.points)
    FROM grades AS g,
         students AS s
    WHERE g.student_id = s.student_id
    GROUP BY s.student_id;
\end{verbatim}
    \end{minipage}
    \begin{minipage}{15em}
        \begin{tabular}{|l|l|}
        \hline
        student\_name & average\_points \\ \hline \hline
        Kadjo & 1 \\ \hline
        Baird & 2.5 \\ \hline
        Goober & 4 \\ \hline
        \end{tabular}
    \end{minipage}
    }
\end{slide}

\begin{slide}{Motivation}
    \begin{itemize}
        \item Simplification of data formats
        \item Convenient access
        \item Separation of concerns: writing a simulation and processing
            the data are separate problems
    \end{itemize}
\end{slide}

\begin{slide}{Procedure}
    \begin{enumerate}
        \item Define a schema
        \item Export data from simulation into tables
        \item Import data into SQL database
        \item Use queries to extract useful information
    \end{enumerate}
    \mygraphic{g_model}
\end{slide}

\begin{slide}{Future Work}
    \begin{itemize}
        \item Apply these concepts to SPICE simulations
        %\item Investigate the use of DSMS
    \end{itemize}
\end{slide}

\begin{slide}{Conclusion}
    \begin{itemize}
        \item By following a simple set of rules, simulations can
            be easier to run and the data can be eaiser to analyze.
        \item SQL is good at filtering, relating, and processing data.
    \end{itemize}
\end{slide}

\end{document}