]> git.somenet.org - pub/jan/adbs.git/blob - ex1/main.tex
GITOLITE.txt
[pub/jan/adbs.git] / ex1 / main.tex
1 %\RequirePackage{snapshot} % stats of included files: $filename.dep
2
3 \documentclass[a4paper]{scrartcl}
4 \usepackage[utf8]{inputenc}
5 \usepackage[naustrian]{babel}
6 \usepackage[T1]{fontenc}
7 \usepackage{amsmath,enumerate}
8 \usepackage{amsfonts}
9 \usepackage{graphicx}
10 \usepackage{multicol}
11 \usepackage{subfig}
12 \usepackage{float}
13 \usepackage{listings}
14 \lstset{language=sql,basicstyle=\small,keywordstyle=\ttfamily,morekeywords={REFERENCES,DEFERRED}}
15 \usepackage{tabularx}
16 \PassOptionsToPackage{hyphens}{url}\usepackage{hyperref}
17 \usepackage{enumitem}
18
19 \usepackage{scrpage2}
20 \pagestyle{scrheadings}
21
22 % includable git commit info
23 \usepackage[missing=run\ build.sh\ or\ gitinfohook.sh]{gitinfo}
24
25 \newcommand{\ul}[1]{\underline{#1}}
26 \newcommand{\ra}{\rightarrow}
27 \newcommand{\R}{\ensuremath{\mathcal{R}}}
28
29 \newtheorem{ex}{Aufgabe}
30 \newenvironment{exercise}[2]%
31 {\def\tmp{}%
32         \ifx\points\tmp
33         \begin{ex}
34                 \else
35                 \def\tmp{1}%
36                 \begin{ex}[#1][#2 Punkt\ifx\points\tmp\else e\fi]
37                         \fi
38                         \normalfont
39                 }%
40                 {\end{ex} %
41 }
42
43 %% HINWEIS!
44 %% 
45 %% Die vorgegebene Formatierung der Loesung ist nur als
46 %% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
47 %% werden.
48
49
50 \title{Exercise Sheet 1, 2019}
51 \subtitle{6.0 VU Advanced Database Systems}
52 \author{David Kaufmann (00700719)\\Jan VALES (00726236)}
53
54 \automark{section}
55 \ohead{\pagemark}
56 \makeatletter
57 \chead{@author}
58 \makeatother
59 \cfoot{}
60
61 \begin{document}
62 \maketitle
63 \vspace{\fill}
64 \subsubsection*{Version}
65 \begin{footnotesize}
66 \url{https://git.somenet.org/priv/jan/adbs.git}\\
67 This is revision: \textbf{\gitAbbrevHash} Document (.tex) compiled on: \textbf{\today}
68 \end{footnotesize}\newpage
69
70
71 \begin{exercise}{I/O}{1}
72 \input{main_1.tex}
73 \end{exercise}
74 \newpage
75
76 \begin{exercise}{I/O in Query Plans}{2}
77 \input{main_2.tex}
78 \end{exercise}
79 \newpage
80
81 \begin{exercise}{Selectivity}{3}
82 \input{main_3.tex}
83 \end{exercise}
84 \newpage
85
86 \begin{exercise}{The Query Planner and You}{4}
87 \input{main_4.tex}
88 \end{exercise}
89 \newpage
90
91 \begin{exercise}{Optimizing Queries}{5}
92 \input{main_5.tex}
93 \end{exercise}
94 \newpage
95
96 \end{document}