\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{LouisDK2} \pdfinfo{ /Title (database.pdf) /Creator (Cheatography) /Author (LouisDK2) /Subject (Database Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{72A341} \definecolor{LightBackground}{HTML}{F6F9F3} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Database Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{LouisDK2} via \textcolor{DarkBackground}{\uline{cheatography.com/45513/cs/13432/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}LouisDK2 \\ \uline{cheatography.com/louisdk2} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Not Yet Published.\\ Updated 10th November, 2017.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{3} \begin{tabularx}{5.377cm}{x{1.94103 cm} x{3.03597 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Datatyper}} \tn % Row 0 \SetRowColor{LightBackground} int & Heltal \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} nchar & Karakterer \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \seqsplit{uniqueidentifier} & Unikt ID \tn % Row Count 4 (+ 2) % Row 3 \SetRowColor{white} date & Pågældende dato \tn % Row Count 5 (+ 1) % Row 4 \SetRowColor{LightBackground} tinyint & heltal mellem 0-255 \tn % Row Count 6 (+ 1) % Row 5 \SetRowColor{white} bit & enkelt værdi (0 eller 1) \tn % Row Count 8 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.23965 cm} x{2.73735 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Begreber}} \tn % Row 0 \SetRowColor{LightBackground} Metadata & data om data \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Master-database & Hoveddb med info om andre DBs \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} DML & ændring af tabeller på brugerniveau \tn % Row Count 5 (+ 2) % Row 3 \SetRowColor{white} DDL & Modificering af db/tabeller på adminniveau \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} DCL & Administration af rettigheder \tn % Row Count 9 (+ 2) % Row 5 \SetRowColor{white} TCL & Administration af udveksling \tn % Row Count 11 (+ 2) % Row 6 \SetRowColor{LightBackground} Stored Procedures & Opbevaring af prodcurer, der kan tilgås efter validering \tn % Row Count 14 (+ 3) % Row 7 \SetRowColor{white} Views & virtuel tabel \tn % Row Count 15 (+ 1) % Row 8 \SetRowColor{LightBackground} Database Management System (DBMS) & Applikation til admin af database (generel betegenelse) \tn % Row Count 18 (+ 3) % Row 9 \SetRowColor{white} SQL & Sprog til søgning i databaser \tn % Row Count 20 (+ 2) % Row 10 \SetRowColor{LightBackground} Index & Lookup tabeler, der gør det hurtigere at finde en forspørgsel (fx. vha WHERE) \tn % Row Count 24 (+ 4) % Row 11 \SetRowColor{white} SQL Server Agent & \seqsplit{Jobplanlægningsværktøj} \tn % Row Count 26 (+ 2) % Row 12 \SetRowColor{LightBackground} Transaktionslog & Log over hændelser. Essentiel ved restore. \tn % Row Count 28 (+ 2) % Row 13 \SetRowColor{white} Design & Opbygning af tabeller \tn % Row Count 29 (+ 1) % Row 14 \SetRowColor{LightBackground} b-three & Binært træ. Kigger i midten og går den ene eller anden vej og frasorterer resten af databasen. \tn % Row Count 34 (+ 5) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.89126 cm} x{3.08574 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Installation af MSSQL}} \tn % Row 0 \SetRowColor{LightBackground} Firewall & Dynamisk, App Rule igennem firewallen \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} Database Engine Service & Muliggør kommunikation med db. Vælges v. install \tn % Row Count 5 (+ 3) % Row 2 \SetRowColor{LightBackground} Client Tools Connectivity & Klientforbindelse. Vælges v. install \tn % Row Count 7 (+ 2) % Row 3 \SetRowColor{white} Mixed mode & Tillader at AD- samt lokal bruger udover SQL-brugere også kan logge på. \tn % Row Count 11 (+ 4) % Row 4 \SetRowColor{LightBackground} SA-bruger & Administratorbruger til MSSQL \tn % Row Count 13 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Installation af SQL Management Studio (SSMS)}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{2}{x{5.377cm}}{Installation af SSMS} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{2}{x{5.377cm}}{Håndtere Databaser} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{2}{x{5.377cm}}{Håndtere Tabler} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{2}{x{5.377cm}}{Håndtere Bruger} \tn % Row Count 4 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.4931 cm} x{3.4839 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Active Directory}} \tn % Row 0 \SetRowColor{LightBackground} Create User & Active Directory \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Add User to Group & MSSQL Group I Active Directory \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} ADDS & Kommunikation m. klienter, printer \tn % Row Count 5 (+ 2) % Row 3 \SetRowColor{white} DNS & Oversætning af URLs/hostnames til IP-addr. \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} DHCP & Muliggør at fx. klientmaskiner auto får IP-addr. \tn % Row Count 9 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.93643 cm} x{2.04057 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Klient Win10}} \tn % Row 0 \SetRowColor{LightBackground} Installeret & som virtuel \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Tilmeldt domæne & zbc4.local \tn % Row Count 2 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.74195 cm} x{3.23505 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Microsoft SQL Server 2016/17-krav}} \tn % Row 0 \SetRowColor{LightBackground} CPU-model & Server: Intel/AMD x86\_64, Klient: Intel/AMD x86/x86\_64 \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} CPU-hastighed & min. 1.4 GHz, 2+ GHz anbefalet \tn % Row Count 5 (+ 2) % Row 2 \SetRowColor{LightBackground} RAM & Express $\frac{1}{2}$ GB, andre: 1 GB, 4+ GB anbefalet \tn % Row Count 7 (+ 2) % Row 3 \SetRowColor{white} .NET-version opkrævet & 4.6.1 el. nyere \tn % Row Count 9 (+ 2) % Row 4 \SetRowColor{LightBackground} \seqsplit{Operativsystem} & Windoiws 8+/ Server 2012+ \tn % Row Count 10 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{0.9954 cm} x{3.9816 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Microsoft SQL Server-udgaver}} \tn % Row 0 \SetRowColor{LightBackground} Express & gratis, max. 1 cpu-kerner, 1 gb ram samt 10 gb datafiler \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} \seqsplit{Enterprise} & understøtter DBs på op til 525 PB, 12 TB ram, 640 cpu-kerner \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} \seqsplit{Standard} & neddroslet udg. Understøtter bl.a ikke hot-swap memory og færre parelle indexes \tn % Row Count 7 (+ 3) % Row 3 \SetRowColor{white} Web & neddroslet udgave målrettet webhosting \tn % Row Count 9 (+ 2) % Row 4 \SetRowColor{LightBackground} Azure & Cloud-optimeret udgave \tn % Row Count 10 (+ 1) % Row 5 \SetRowColor{white} \seqsplit{Developer} & Enterprise-udg. Må benyttes til testing og udvikling \tn % Row Count 12 (+ 2) % Row 6 \SetRowColor{LightBackground} \seqsplit{Evaluation} & Prøveversion af Entrprise. 180 dage. \tn % Row Count 14 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.34379 cm} x{3.63321 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Montorering}} \tn % Row 0 \SetRowColor{LightBackground} SSMS & Højreklik på DB-server, vælg Activity Monitor \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} Overview & Oversigt over aktive database-elementer \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} Processor & Aktive elementer \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} Resource waites & Ventende resourcer \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} Datafile I/O & Indkommende/Udgående datafiler \tn % Row Count 9 (+ 2) % Row 5 \SetRowColor{white} \mymulticolumn{2}{x{5.377cm}}{Recent Expensive Queries} \tn % Row Count 10 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{2}{x{5.377cm}}{Active Expensive Queries} \tn % Row Count 11 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.28942 cm} x{2.68758 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Tillad login med ugyldigt certifikat i SSMS}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{2}{x{5.377cm}}{Connect -\textgreater{} Database engine} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{2}{x{5.377cm}}{Options -\textgreater{} Connection Properties} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} Sæt hak i felter under Connection & Encrypt connection + Trust server certificate \tn % Row Count 5 (+ 3) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.4885 cm} x{2.4885 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Tlllad SSMS-login fra klient}} \tn % Row 0 \SetRowColor{LightBackground} SQL Server Configuration Manager → SQL Server Network Configuration → (Dbname) → TCP/IP & Enable under fanebladene Protocol og IP Addresses \tn % Row Count 5 (+ 5) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.9908 cm} x{2.9862 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{MSSQL logfiler}} \tn % Row 0 \SetRowColor{LightBackground} Program Files\textbackslash{}Microsoft SQL & Lokation for logfiler \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} SSMS server logs & Management -\textgreater{} SQL Server logs \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} Log File Viewer & GUI-tool til at gennemse logfiler for bl.a SQL Server og SQL Server Agent \tn % Row Count 8 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.4885 cm} x{2.4885 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{MSSQL kommandosyntax}} \tn % Row 0 \SetRowColor{LightBackground} create database \textless{}tabelnavn\textgreater{} & Opretter database \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} drop database \textless{}tabelnavn\textgreater{} & Sletter database \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} backup database \textless{}tabelnavn\textgreater{} \textless{}sti\textgreater{} & Opret backup af db til sti \tn % Row Count 6 (+ 2) % Row 3 \SetRowColor{white} create login \textless{}loginnavn\textgreater{} & Opretter login \tn % Row Count 8 (+ 2) % Row 4 \SetRowColor{LightBackground} with password 'pass'; & Angiv pass til ovenstående login \tn % Row Count 10 (+ 2) % Row 5 \SetRowColor{white} create user \textless{}loginnavn\textgreater{} for login \textless{}brugernavn\textgreater{} & Opretter bruger til loginet \tn % Row Count 13 (+ 3) % Row 6 \SetRowColor{LightBackground} grant \textless{}rettighed\textgreater{} on \textless{}tabel\textgreater{} to \textless{}brugernavn\textgreater{} & Tildeler rettighed på tabel for bestemt bruger \tn % Row Count 16 (+ 3) % Row 7 \SetRowColor{white} select * from \textless{}tabel\textgreater{} where værdi = 1 & Vælger alt fra en tabel, hvor "værdi" er sat til 1 \tn % Row Count 19 (+ 3) % Row 8 \SetRowColor{LightBackground} go & kommandoseperator \tn % Row Count 20 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.89126 cm} x{3.08574 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Administration via SSMS}} \tn % Row 0 \SetRowColor{LightBackground} Opret login & Security -\textgreater{} Logins \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Opret bruger & \textless{}db\textgreater{} -\textgreater{} Security -\textgreater{} Users \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} Foretag backup & \textless{}db\textgreater{} -\textgreater{} tasks -\textgreater{} back up \tn % Row Count 4 (+ 1) % Row 3 \SetRowColor{white} Restore backup & \textless{}db\textgreater{} -\textgreater{} tasks -\textgreater{} restore -\textgreater{} database \tn % Row Count 6 (+ 2) % Row 4 \SetRowColor{LightBackground} Opret ny database & Højreklik på dbs -\textgreater{} new database \tn % Row Count 8 (+ 2) % Row 5 \SetRowColor{white} Optimering af DB og filer & \textless{}db\textgreater{} -\textgreater{} Tasks -\textgreater{} Shrink -\textgreater{} Database and files \tn % Row Count 10 (+ 2) % Row 6 \SetRowColor{LightBackground} Opret index & \textless{}db\textgreater{} -\textgreater{} \textless{}tabel\textgreater{} -\textgreater{} Index \tn % Row Count 11 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.44333 cm} x{3.53367 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Alternative databaser}} \tn % Row 0 \SetRowColor{LightBackground} MySQL & Relationsopbygget database, benyttes bl.a i websammenhænge \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} MariaDB & Community fork af MySQL \tn % Row Count 4 (+ 1) % Row 2 \SetRowColor{LightBackground} \seqsplit{PostgressSQL} & Objekt-orienteret database, benyttes primært til sikker opbevaring og udveksling af data \tn % Row Count 8 (+ 4) % Row 3 \SetRowColor{white} Microsoft Access & Benytter Microsoft Jet Database Engine, kan benyttes til .net-udvikling og i samspil med SSMS \tn % Row Count 12 (+ 4) % Row 4 \SetRowColor{LightBackground} Oracle & Data opbevares logisk i tabeller. Kan håndtere større database end MySQL \tn % Row Count 15 (+ 3) % Row 5 \SetRowColor{white} IBM Db2 & Propræitær db, primært brugt i cloud-løsninger \tn % Row Count 17 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.69218 cm} x{3.28482 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Databasetyper}} \tn % Row 0 \SetRowColor{LightBackground} \seqsplit{Cloud-database} & Data gemmes på ekstern server \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} \seqsplit{Realtime-database} & Data behandles i realtid \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} Aktiv database & Agerer på baggrund af predifnerede events/triggers \tn % Row Count 6 (+ 2) % Row 3 \SetRowColor{white} in-memory database & Ligger i ram grundet performance med backup på disk \tn % Row Count 8 (+ 2) % Row 4 \SetRowColor{LightBackground} distribueret database & oprerer på flere systemer, ofte med synk \tn % Row Count 10 (+ 2) % Row 5 \SetRowColor{white} embedded database & indbygget i et program, typisk skjult for slutbruger \tn % Row Count 12 (+ 2) % Row 6 \SetRowColor{LightBackground} graf-baseret database & Opbevarer og oprerer ved hjælp af grafer \tn % Row Count 14 (+ 2) % Row 7 \SetRowColor{white} \seqsplit{vidensdatabase} & Søgebar database m. dokumenteret know-how \tn % Row Count 16 (+ 2) % Row 8 \SetRowColor{LightBackground} parallel database & Database der oprerer i samarbejde med i identiske database for bedre performance \tn % Row Count 20 (+ 4) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}