]> git.donarmstrong.com Git - debbugs-presentations.git/blob - debbugs_layout_db.tex
move SQL design earlier
[debbugs-presentations.git] / debbugs_layout_db.tex
1 \pgfdeclarelayer{background layer}
2 \pgfsetlayers{background layer,main}
3
4
5
6
7 \begin{tikzpicture}
8   \tikzstyle{getstyle}=[fill opacity=1,draw opacity=1]
9   \tikzstyle{programnode}=[minimum height=0.75cm, text width=2cm, text centered, draw=black,fill opacity=0.8];
10   \useasboundingbox (0,-4) rectangle (13,3);
11   %\draw (8,2.5) node[name=keywords,style=programnode,anchor=west,text width=2cm,fill=yellow!90] {\small Keywords};
12   \draw (2,1) node[name=mail_in,style=programnode,style=getstyle,anchor=west,fill=blue!60] {\small Mail In};
13   \draw (2,0) node[name=spamscan,style=programnode,style=getstyle,anchor=west,fill=green!60] {\small spamscan};
14   \draw (2,0) node[name=spam,style=programnode,style=getstyle,anchor=west,fill=red!60] {\small spam};
15   \draw (2,-1) node[name=processall,style=programnode,style=getstyle,anchor=west,fill=green!60] {\small processall};
16   \draw (0.75,-2) node[name=service,style=programnode,style=getstyle,anchor=west,fill=green!60] {\small service};
17   \draw (3.25,-2) node[name=process,style=programnode,style=getstyle,anchor=west,fill=green!60] {\small process};
18   \draw[style=getstyle,-stealth,line width = 1pt] (mail_in.-90) -- (spamscan.90);
19   \draw[style=getstyle,-stealth,line width = 1pt] (spamscan.-90) -- (processall.90);
20   \draw[style=getstyle,-stealth,line width = 1pt] (processall.-120) -- (service.60);
21   \draw[style=getstyle,-stealth,line width = 1pt] (processall.-60) -- (process.60);
22   
23   \draw (5.5,-2) node[name=db-h,style=programnode,style=getstyle,anchor=west,fill=yellow!60] {\small db-h};
24   \draw[style=getstyle,-stealth,line width = 1pt] (process.-90) |- (6.4,-2.75) -- (db-h.-120);
25   \draw[style=getstyle,-stealth,line width = 1pt] (service.-90) |- (6.85,-3) -- (db-h.-60);
26   \draw (5.5,-1) node[name=indexes,style=programnode,style=getstyle,anchor=west,fill=yellow!60] {\small indexes};
27   \draw[style=getstyle,-stealth,line width = 1pt] (db-h.90) -- (indexes.-90);
28   \draw (5.5,0) node[name=cgi,style=programnode,style=getstyle,anchor=west,fill=blue!20] {\small cgi/...};
29   \draw[style=getstyle,-stealth,line width = 1pt] (indexes.90) -- (cgi.-90);
30
31   \draw (8,-2) node[name=loadsql,style=programnode,style=getstyle,anchor=west,fill=green!60] {\small debbugs-loadsql};
32   \draw[style=getstyle,-stealth,line width = 1pt] (db-h.0) -- (loadsql.180);
33   \draw (8,-0.9) node[name=database,style=programnode,style=getstyle,anchor=west,fill=yellow!60] {\small database};
34   \draw[style=getstyle,-stealth,line width = 1pt] (loadsql.90) -- (database.-90);
35   \draw[style=getstyle,-stealth,line width = 1pt] (database.90) |- (cgi.0);
36
37   % \draw (2,1) node[name=parse_ncbi,style=programnode,style=parsestyle,anchor=west,fill=red!60] {\small parse\_ncbi\_results};
38   % \draw (2,0) node[name=parse_genecard,style=programnode,style=parsestyle,anchor=west,fill=red!60] {\small parse\_genecard\_results};
39   % \draw (2,-1) node[name=parse_harvester,style=programnode,style=parsestyle,anchor=west,fill=red!60] {\small parse\_harvester\_results};
40   % \draw[-stealth,style=parsestyle,line width = 1pt] (get_harvester) -- (parse_harvester);
41   % \draw[-stealth,style=parsestyle,line width = 1pt] (get_ncbi) -- (parse_ncbi);
42   % \draw[-stealth,style=parsestyle,line width = 1pt] (get_genecard) -- (parse_genecard);
43   % \draw (1,0) node[name=combine_results,style=programnode,style=combinestyle,anchor=center,fill=green!40,rotate=90,text width=3cm] {\small combine\_results};
44   % \draw[-stealth,style=combinestyle,line width = 1pt] (parse_harvester.west) -- (combine_results);
45   % \draw[-stealth,style=combinestyle,line width = 1pt] (parse_ncbi.west) -- (combine_results);
46   % \draw[-stealth,style=combinestyle,line width = 1pt] (parse_genecard.west) -- (combine_results);
47   % 
48   % \draw (2,-2) node[name=expert_judgement,style=programnode,style=expertstyle,anchor=west,fill=blue!20!red!20] {\small Expert Information};
49   % \draw[-stealth,line width = 2pt,style=expertstyle] (combine_results.north) -| (0.25,-2) -- (expert_judgement.west);
50   % 
51   % \draw (7,-2) node[name=snp_selection,style=programnode,style=snpselectionstyle,anchor=west,fill=blue!20!red!20] {\small SNP Selection};
52   % \draw[-stealth,style=snpselectionstyle,line width = 1pt] (expert_judgement) -- (snp_selection);
53 \end{tikzpicture}
54
55 % Use only<>{} to get the above to change appropriately