| Offset 1, 8 lines modified | Offset 1, 8 lines modified |
| 1 | <FILENAME·filename="index.html"><html><head><title>Kexi·käsiraamat</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="description"·content="Kexi·on·kontoritööpaketi·Calligra·andmebaaside·loomise·ja·nende·haldamise·rakendus."><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·andmebaas"><link·rel="home"·href="index.html"·title="Kexi·käsiraamat"><link·rel="next"·href="introduction.html"·title="Peatükk·1.·Sissejuhatus"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="header_content"><div·id="header_left"><div·id="header_right"><img·src="hel·✂ | 1 | <FILENAME·filename="index.html"><html><head><title>Kexi·käsiraamat</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="description"·content="Kexi·on·kontoritööpaketi·Calligra·andmebaaside·loomise·ja·nende·haldamise·rakendus."><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·andmebaas"><link·rel="home"·href="index.html"·title="Kexi·käsiraamat"><link·rel="next"·href="introduction.html"·title="Peatükk·1.·Sissejuhatus"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="header_content"><div·id="header_left"><div·id="header_right"><img·src="hel·✂ |
| 2 | </p></div></div><div·id="footer"><div·class="navCenter"><table·class="navigation"><tr><td·class="prevCell"><a·accesskey="p"·href="index.html">Eelmine</a></td><td·class="upCell"><a·accesskey="h"·href="index.html">Esileht</a></td><td·class="nextCell"><a·accesskey="n"·href="kexi-basics.html">Järgmine</a></td></tr><tr><td·class="prevCell"><span·class="application">Kexi</span>·käsiraamat </td><td·class="upCell"> </td><td·class="nextCell"> Kexi·põhitõed</td></tr></table></div><div·id="footer_text">Kas·soovid·midagi·kommenteerida·või·seda·lehekülge·täiendada?<br>Saada·oma·tagasiside·<a·href="mailto:kde-doc-english@kde.org"·class="footer_email">KDE·dokumentatsiooni·meeskonnale</a></div></div></div></body></html></FILENAME><FILENAME·filename="kexi-basics.html"><html><head><title>Peatükk·2.·Kexi·põhitõed</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-lo·✂ | 2 | </p></div></div><div·id="footer"><div·class="navCenter"><table·class="navigation"><tr><td·class="prevCell"><a·accesskey="p"·href="index.html">Eelmine</a></td><td·class="upCell"><a·accesskey="h"·href="index.html">Esileht</a></td><td·class="nextCell"><a·accesskey="n"·href="kexi-basics.html">Järgmine</a></td></tr><tr><td·class="prevCell"><span·class="application">Kexi</span>·käsiraamat </td><td·class="upCell"> </td><td·class="nextCell"> Kexi·põhitõed</td></tr></table></div><div·id="footer_text">Kas·soovid·midagi·kommenteerida·või·seda·lehekülge·täiendada?<br>Saada·oma·tagasiside·<a·href="mailto:kde-doc-english@kde.org"·class="footer_email">KDE·dokumentatsiooni·meeskonnale</a></div></div></div></body></html></FILENAME><FILENAME·filename="kexi-basics.html"><html><head><title>Peatükk·2.·Kexi·põhitõed</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-lo·✂ |
| 3 | </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html"·title="Olemasoleva·Kexi·andmebaasifaili·avamine">Olemasoleva·Kexi·andmebaasifaili·avamine</a> </p><div·class="itemizedlist"><ul·class="itemizedlist"·type="circle"><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-a-database-file-in-the-open-existing-project-dialog"·title="Andmebaasifaili·avamine·dialoogis·Projekti·avamine">Andmebaasifaili·avamine·dialoogis·Olemasoleva·projekti·avamine</a> </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-an-existing-kexi-database-file-by-clicking-on--kexi-files-icon"·title="Olemasoleva·Kexi·andmebaasifaili·avamine·.kexi-faili·ikoonile·klõpsates">Olemasoleva·Kexi·andmebaasifaili·avamine·.kexi-faili·ikoonile·klõpsates</a> </p></li></ul></div><p> | 3 | </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html"·title="Olemasoleva·Kexi·andmebaasifaili·avamine">Olemasoleva·Kexi·andmebaasifaili·avamine</a> </p><div·class="itemizedlist"><ul·class="itemizedlist"·type="circle"><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-a-database-file-in-the-open-existing-project-dialog"·title="Andmebaasifaili·avamine·dialoogis·Projekti·avamine">Andmebaasifaili·avamine·dialoogis·Olemasoleva·projekti·avamine</a> </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-an-existing-kexi-database-file-by-clicking-on--kexi-files-icon"·title="Olemasoleva·Kexi·andmebaasifaili·avamine·.kexi-faili·ikoonile·klõpsates">Olemasoleva·Kexi·andmebaasifaili·avamine·.kexi-faili·ikoonile·klõpsates</a> </p></li></ul></div><p> |
| 4 | </p></li><li·class="listitem"><p><a·class="link"·href="using-built-in-help.html"·title="Sisseehitatud·abi·kasutamine">Sisseehitatud·abi·kasutamine</a> </p></li></ul></div><div·class="sect1"><div·class="titlepage"><div><div><h2·class="title"·style="clear:·both"><a·name="kexi-databases"></a>Kexi·andmebaasid</h2></div></div></div><p>Paljud·rakendused,·näiteks·<span·class="trademark">OpenOffice.org</span>®,·<span·class="trademark">LibreOffice</span>®·või·<span·class="application"><span·class="trademark">Microsoft</span>®·Excel</span>,·loovad·faile,·mida·nimetatakse·dokumendiks.·Ka·<span·class="application">Kexi</span>·loob·faile,·kuid·meie·nimetame·neid·<span·class="application">Kexi</span>·andmebaasifailideks·või·lihtsalt·andmebaasifailideks.·</p><p>Lisaks·andmebaaside·salvestamisele·andmebaasifailidena·võib·<span·class="application">Kexi</span>·kasutada·ka·andmebaase·andmebaasiserverites,·mistõttu·me·nimetame·neid·andmebaasifailideks,·mitte·aga·lihtsalt·andmebaasideks.·</p><p>Ka·mõistet·<span·class="application·✂ | 4 | </p></li><li·class="listitem"><p><a·class="link"·href="using-built-in-help.html"·title="Sisseehitatud·abi·kasutamine">Sisseehitatud·abi·kasutamine</a> </p></li></ul></div><div·class="sect1"><div·class="titlepage"><div><div><h2·class="title"·style="clear:·both"><a·name="kexi-databases"></a>Kexi·andmebaasid</h2></div></div></div><p>Paljud·rakendused,·näiteks·<span·class="trademark">OpenOffice.org</span>®,·<span·class="trademark">LibreOffice</span>®·või·<span·class="application"><span·class="trademark">Microsoft</span>®·Excel</span>,·loovad·faile,·mida·nimetatakse·dokumendiks.·Ka·<span·class="application">Kexi</span>·loob·faile,·kuid·meie·nimetame·neid·<span·class="application">Kexi</span>·andmebaasifailideks·või·lihtsalt·andmebaasifailideks.·</p><p>Lisaks·andmebaaside·salvestamisele·andmebaasifailidena·võib·<span·class="application">Kexi</span>·kasutada·ka·andmebaase·andmebaasiserverites,·mistõttu·me·nimetame·neid·andmebaasifailideks,·mitte·aga·lihtsalt·andmebaasideks.·</p><p>Ka·mõistet·<span·class="application·✂ |
| 5 | </p></div><FILENAME·filename="creating-a-new-database-file.html"><html><head><title>Uue·andmebaasifaili·loomine</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·andmebaas"><link·rel="home"·href="index.html"·title="Kexi·käsiraamat"><link·rel="up"·href="kexi-basics.html"·title="Peatükk·2.·Kexi·põhitõed"><link·rel="prev"·href="kexi-basics.html"·title="Peatükk·2.·Kexi·põhitõed"><link·rel="next"·href="the-kexi-main-window.html"·title="Kexi·peaaken"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="heade·✂ | 5 | </p></div><FILENAME·filename="creating-a-new-database-file.html"><html><head><title>Uue·andmebaasifaili·loomine</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·andmebaas"><link·rel="home"·href="index.html"·title="Kexi·käsiraamat"><link·rel="up"·href="kexi-basics.html"·title="Peatükk·2.·Kexi·põhitõed"><link·rel="prev"·href="kexi-basics.html"·title="Peatükk·2.·Kexi·põhitõed"><link·rel="next"·href="the-kexi-main-window.html"·title="Kexi·peaaken"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="heade·✂ |
| 6 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="newproject.png"><hr></div></div><p> | 6 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="newproject.png"><hr></div></div><p> |
| 7 | </p><div·class="orderedlist"><ol·class="orderedlist"·type="1"><li·class="listitem"><p>Käivita·<span·class="application">Kexi</span>·või·kui·see·juba·töötab,·vali·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenu">Kexi</span></span>·→·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenuitem">Uus...·(Ctrl+N)</span></span>.</p></li><li·class="listitem"><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Uue·projekti</span></span>·leheküljel·vali·sektsioonis·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tühjad·projektid</span></span>·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tühi·andmebaas</span></span>.·</p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="projectstorage.png"><hr></div></div></li><li·class="list·✂ | 7 | </p><div·class="orderedlist"><ol·class="orderedlist"·type="1"><li·class="listitem"><p>Käivita·<span·class="application">Kexi</span>·või·kui·see·juba·töötab,·vali·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenu">Kexi</span></span>·→·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenuitem">Uus...·(Ctrl+N)</span></span>.</p></li><li·class="listitem"><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Uue·projekti</span></span>·leheküljel·vali·sektsioonis·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tühjad·projektid</span></span>·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tühi·andmebaas</span></span>.·</p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="projectstorage.png"><hr></div></div></li><li·class="list·✂ |
| 8 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_mainwindow.png"><hr></div></div><p> | 8 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_mainwindow.png"><hr></div></div><p> |
| Offset 41, 25 lines modified | Offset 41, 25 lines modified |
| 41 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_form_design_tab.png"><hr></div></div><p> | 41 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_form_design_tab.png"><hr></div></div><p> |
| 42 | </p><p>Kaardil·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Vormi·kujundus</span></span>·saab·valida·vidinaid,·mida·lisada·vormi.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Viit</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Viit</span></span>·lülitab·vidina·valimise·režiimi.</p></dd></dl></div><div·class="note"·style="margin-left:·0.5in;·margin-right:·0.5in;"><h3·class="title">Märkus</h3><p>Suvalise·vidina·valimine·lülitab·vidina·lisamise·režiimi.·Seejärel·võib·klõpsata·sobivale·kohale·vormis,·et·vidin·paika·asetada.</p></div><p> | 42 | </p><p>Kaardil·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Vormi·kujundus</span></span>·saab·valida·vidinaid,·mida·lisada·vormi.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Viit</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Viit</span></span>·lülitab·vidina·valimise·režiimi.</p></dd></dl></div><div·class="note"·style="margin-left:·0.5in;·margin-right:·0.5in;"><h3·class="title">Märkus</h3><p>Suvalise·vidina·valimine·lülitab·vidina·lisamise·režiimi.·Seejärel·võib·klõpsata·sobivale·kohale·vormis,·et·vidin·paika·asetada.</p></div><p> |
| 43 | </p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span></strong></span></span></dt><dd><p>Vidin·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span>·kuvab·vormis·määratud·teavet.·Tavaliselt·kasutatakse·seda·pealdisena·teiste·andmetundlike·vidinate·kõrval.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tekstikast</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tekstikast</span></span>·on·üherealine·tabelis·leiduvate·andmete·konteiner.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tekstiredakto·✂ | 43 | </p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span></strong></span></span></dt><dd><p>Vidin·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span>·kuvab·vormis·määratud·teavet.·Tavaliselt·kasutatakse·seda·pealdisena·teiste·andmetundlike·vidinate·kõrval.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tekstikast</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tekstikast</span></span>·on·üherealine·tabelis·leiduvate·andmete·konteiner.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tekstiredakto·✂ |
| 44 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_report_design_tab.png"><hr></div></div><p> | 44 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_report_design_tab.png"><hr></div></div><p> |
| 45 | </p><p>Kaardil·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Aruande·kujundus</span></span>·saab·valida·vidinaid,·mida·lisada·aruandesse.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span></strong></span></span></dt><dd><p>Vidin·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span>·kuvab·aruandes·määratud·teavet·Tavaliselt·kasutatakse·seda·pealdisena·teiste·andmetundlike·vidinate·kõrval.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Väli</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Väli</span></span>·on·üherealine·tabelis·leiduvate·andmete·k·✂ | 45 | </p><p>Kaardil·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Aruande·kujundus</span></span>·saab·valida·vidinaid,·mida·lisada·aruandesse.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span></strong></span></span></dt><dd><p>Vidin·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pealdis</span></span>·kuvab·aruandes·määratud·teavet·Tavaliselt·kasutatakse·seda·pealdisena·teiste·andmetundlike·vidinate·kõrval.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Väli</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Väli</span></span>·on·üherealine·tabelis·leiduvate·andmete·k·✂ |
| 46 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="contact-example.png"><hr></div></div><p> | 46 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="contact-example.png"><hr></div></div><p> |
| 47 | </p><p>Toodud·pildil·on·näha·kaks·kontakti,·kumbki·omaette·kaardil.·Tabelis·saab·sellise·kaardi·seada·ühele·reale:·</p><p> | 47 | </p><p>Toodud·pildil·on·näha·kaks·kontakti,·kumbki·omaette·kaardil.·Tabelis·saab·sellise·kaardi·seada·ühele·reale:·</p><p> |
| 48 | </p><div·class="table"><a·name="idp149393976"></a><p·class="title"><b>Tabel·6.1.·<span·class="emphasis"><em>Kontaktide·tabel</em></span></b></p><div·class="table-contents"><table·summary="Kontaktide·tabel"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel.·nr.</span></span></th></tr></thead><tbody><tr><td> | 48 | </p><div·class="table"><a·name="idp149430840"></a><p·class="title"><b>Tabel·6.1.·<span·class="emphasis"><em>Kontaktide·tabel</em></span></b></p><div·class="table-contents"><table·summary="Kontaktide·tabel"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel.·nr.</span></span></th></tr></thead><tbody><tr><td> |
| 49 | ····<p>Joan</p> | 49 | ····<p>Joan</p> |
| 50 | ····</td><td> | 50 | ····</td><td> |
| 51 | ····<p>699·23·43·12</p> | 51 | ····<p>699·23·43·12</p> |
| 52 | ····</td></tr><tr><td> | 52 | ····</td></tr><tr><td> |
| 53 | ····<p>Adam</p> | 53 | ····<p>Adam</p> |
| 54 | ····</td><td> | 54 | ····</td><td> |
| 55 | ····<p>711·19·77·21</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 55 | ····<p>711·19·77·21</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 56 | </p><p>Mõisted:·konkreetsed·andmed,·mis·moodustavad·osa·suuremast·kogust,·kannavad·nimetust·<span·class="emphasis"><em>rida</em></span>·või·kui·kasutada·professionaalsemat·väljendit,·siis·<span·class="emphasis"><em>kirje</em></span>.·Kogu·ise·kannab·tavaliselt·nimetust·<span·class="emphasis"><em>tabel</em></span>.·Kõige·mõistlikum·on·üldiselt·anda·tabelile·nimi,·mis·väljendab·selles·peituvate·andmete·sisu·-·antud·juhul·siis·Kontaktid.·Iga·rida·koosneb·mitmest·veerust,·mida·mõnikord·nimetatakse·ka·<span·class="emphasis"><em>väljadeks</em></span>.·Tabelis·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontaktid</code></em></span>·on·kaks·veergu·(välja):·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span>·ja·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel.·nr.</span></span>·</p><p>Lihtsamas·tähenduses·moodustab·juba·üks·tabel·andmebaasi.·✂ | 56 | </p><p>Mõisted:·konkreetsed·andmed,·mis·moodustavad·osa·suuremast·kogust,·kannavad·nimetust·<span·class="emphasis"><em>rida</em></span>·või·kui·kasutada·professionaalsemat·väljendit,·siis·<span·class="emphasis"><em>kirje</em></span>.·Kogu·ise·kannab·tavaliselt·nimetust·<span·class="emphasis"><em>tabel</em></span>.·Kõige·mõistlikum·on·üldiselt·anda·tabelile·nimi,·mis·väljendab·selles·peituvate·andmete·sisu·-·antud·juhul·siis·Kontaktid.·Iga·rida·koosneb·mitmest·veerust,·mida·mõnikord·nimetatakse·ka·<span·class="emphasis"><em>väljadeks</em></span>.·Tabelis·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontaktid</code></em></span>·on·kaks·veergu·(välja):·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span>·ja·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel.·nr.</span></span>·</p><p>Lihtsamas·tähenduses·moodustab·juba·üks·tabel·andmebaasi.·✂ |
| 57 | </p></div><FILENAME·filename="database-and-spreadsheet.html"><html><head><title>Andmebaas·ja·arvutustabel</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·andmebaas"><link·rel="home"·href="index.html"·title="Kexi·käsiraamat"><link·rel="up"·href="appendix-a--introduction-to-databases.html"·title="Peatükk·6.·Lisa·A.·Sissejuhatus·andmebaasidesse"><link·rel="prev"·href="appendix-a--introduction-to-databases.html"·title="Peatükk·6.·Lisa·A.·Sissejuhatus·andmebaasidesse"><link·rel="next"·href="database-design.html"·title="Andmebaasi·disain"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link·✂ | 57 | </p></div><FILENAME·filename="database-and-spreadsheet.html"><html><head><title>Andmebaas·ja·arvutustabel</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·andmebaas"><link·rel="home"·href="index.html"·title="Kexi·käsiraamat"><link·rel="up"·href="appendix-a--introduction-to-databases.html"·title="Peatükk·6.·Lisa·A.·Sissejuhatus·andmebaasidesse"><link·rel="prev"·href="appendix-a--introduction-to-databases.html"·title="Peatükk·6.·Lisa·A.·Sissejuhatus·andmebaasidesse"><link·rel="next"·href="database-design.html"·title="Andmebaasi·disain"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link·✂ |
| 58 | </p><div·class="table"><a·name="idp149413176"></a><p·class="title"><b>Tabel·6.2.·<span·class="emphasis"><em>Kontaktide·tabel</em></span></b></p><div·class="table-contents"><table·summary="Kontaktide·tabel"·border="1"><colgroup><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Ees-·ja·perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel.·nr.</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Aadress</span></span></th></tr></thead><tbody><tr><td> | 58 | </p><div·class="table"><a·name="idp149450040"></a><p·class="title"><b>Tabel·6.2.·<span·class="emphasis"><em>Kontaktide·tabel</em></span></b></p><div·class="table-contents"><table·summary="Kontaktide·tabel"·border="1"><colgroup><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Ees-·ja·perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel.·nr.</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Aadress</span></span></th></tr></thead><tbody><tr><td> |
| 59 | ····<p>Joan·Smith</p> | 59 | ····<p>Joan·Smith</p> |
| 60 | ····</td><td> | 60 | ····</td><td> |
| 61 | ····<p>699·23·43·12</p> | 61 | ····<p>699·23·43·12</p> |
| 62 | ····</td><td> | 62 | ····</td><td> |
| 63 | ····<p>Brama·Zachodnia·1,·Varssavi</p> | 63 | ····<p>Brama·Zachodnia·1,·Varssavi</p> |
| 64 | ····</td></tr><tr><td> | 64 | ····</td></tr><tr><td> |
| 65 | ····<p>Adam·Willson</p> | 65 | ····<p>Adam·Willson</p> |
| Offset 82, 24 lines modified | Offset 82, 24 lines modified |
| 82 | ····</td></tr><tr><td> | 82 | ····</td></tr><tr><td> |
| 83 | ····<p>ADAM·Willson</p> | 83 | ····<p>ADAM·Willson</p> |
| 84 | ····</td><td> | 84 | ····</td><td> |
| 85 | ····<p>231·83·02·04</p> | 85 | ····<p>231·83·02·04</p> |
| 86 | ····</td><td> | 86 | ····</td><td> |
| 87 | ····<p>Frogs·Drive·5,·London</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 87 | ····<p>Frogs·Drive·5,·London</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 88 | </p><p>Sellist·tabelit·võib·luua·nii·arvutustabeli·kui·andmebaasina.·Arvutustabeli·kasutamine·on·loomulikult·väga·lihtne.·Milliste·probleemidega·me·hetkel·silmitsi·seisame?·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="referential-data-integrity"></a>Andmete·viiteterviklus</h3></div></div></div><p>Oletame,·et·kasutad·arvutustabelit·ja·sul·tuleb·muuta·vähemalt·ühe·isiku·aadressi.·Sinu·ees·seisab·pisike·probleem:·sageli·tuleb·selleks·muuta·aadressi·paljudel·ridadel.·Nii·võib·näiteks·Joan·esineda·kolmel·real.·Probleem·tekib·siis,·kui·unustad·üht·neist·ridadest·muuta:·isikule·omistatud·aadress·muutub·mitmetähenduslikuks,·see·aga·tähendab,·et·sinu·andmed·kaotavad·tervikluse.·</p><p>Pealegi·pole·kuigi·lihtsat·võimalust·mõnda·isikut·tabelist·kustutada:·selleks·tuleb·kustutada·kõik·teda·sisaldavad·read.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-redundancy"></a>Andmete·liiasus</h3></div></div></div><p>See·on·otseselt·seotud··✂ | 88 | </p><p>Sellist·tabelit·võib·luua·nii·arvutustabeli·kui·andmebaasina.·Arvutustabeli·kasutamine·on·loomulikult·väga·lihtne.·Milliste·probleemidega·me·hetkel·silmitsi·seisame?·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="referential-data-integrity"></a>Andmete·viiteterviklus</h3></div></div></div><p>Oletame,·et·kasutad·arvutustabelit·ja·sul·tuleb·muuta·vähemalt·ühe·isiku·aadressi.·Sinu·ees·seisab·pisike·probleem:·sageli·tuleb·selleks·muuta·aadressi·paljudel·ridadel.·Nii·võib·näiteks·Joan·esineda·kolmel·real.·Probleem·tekib·siis,·kui·unustad·üht·neist·ridadest·muuta:·isikule·omistatud·aadress·muutub·mitmetähenduslikuks,·see·aga·tähendab,·et·sinu·andmed·kaotavad·tervikluse.·</p><p>Pealegi·pole·kuigi·lihtsat·võimalust·mõnda·isikut·tabelist·kustutada:·selleks·tuleb·kustutada·kõik·teda·sisaldavad·read.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-redundancy"></a>Andmete·liiasus</h3></div></div></div><p>See·on·otseselt·seotud··✂ |
| 89 | </p><div·class="table"><a·name="idp149435576"></a><p·class="title"><b>Tabel·6.3.·<span·class="emphasis"><em>Isikute·tabel</em></span></b></p><div·class="table-contents"><table·summary="Isikute·tabel"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Ees-·ja·perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Aadress</span></span></th></tr></thead><tbody><tr><td> | 89 | </p><div·class="table"><a·name="idp149472440"></a><p·class="title"><b>Tabel·6.3.·<span·class="emphasis"><em>Isikute·tabel</em></span></b></p><div·class="table-contents"><table·summary="Isikute·tabel"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Ees-·ja·perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Aadress</span></span></th></tr></thead><tbody><tr><td> |
| 90 | ····<p>Joan·Smith</p> | 90 | ····<p>Joan·Smith</p> |
| 91 | ····</td><td> | 91 | ····</td><td> |
| 92 | ····<p>Brama·Zachodnia·1,·Varssavi</p> | 92 | ····<p>Brama·Zachodnia·1,·Varssavi</p> |
| 93 | ····</td></tr><tr><td> | 93 | ····</td></tr><tr><td> |
| 94 | ····<p>Adam·Willson</p> | 94 | ····<p>Adam·Willson</p> |
| 95 | ····</td><td> | 95 | ····</td><td> |
| 96 | ····<p>Frogs·Drive·5,·London</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 96 | ····<p>Frogs·Drive·5,·London</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 97 | </p><p>Iga·tabeli·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Isikud</code></em></span>·rida·vastab·ainult·ühele·isikule.·Tabel·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontaktid</code></em></span>·on·nüüd·seotud·tabeliga·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Isikud</code></em></span>.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-integrity-and-validity"></a>Andmeterviklus·ja·-õigsus</h3></div></div></div><p>Pane·tähele,·kuidas·on·andmed·sisestatud·väljadele·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Ees-·ja·perekonnanimi</code></em></span>·ning·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Aadress</code></em></span>.·Andmeid·sisestavad·ini·✂ | 97 | </p><p>Iga·tabeli·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Isikud</code></em></span>·rida·vastab·ainult·ühele·isikule.·Tabel·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontaktid</code></em></span>·on·nüüd·seotud·tabeliga·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Isikud</code></em></span>.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-integrity-and-validity"></a>Andmeterviklus·ja·-õigsus</h3></div></div></div><p>Pane·tähele,·kuidas·on·andmed·sisestatud·väljadele·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Ees-·ja·perekonnanimi</code></em></span>·ning·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Aadress</code></em></span>.·Andmeid·sisestavad·ini·✂ |
| 98 | </p><div·class="table"><a·name="idp149454776"></a><p·class="title"><b>Tabel·6.4.·<span·class="emphasis"><em>Isikute·tabel</em></span></b></p><div·class="table-contents"><table·summary="Isikute·tabel"·border="1"><colgroup><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tänav</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Majanumber</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Linn</span></span></th></tr></thead><tbody><tr><td> | 98 | </p><div·class="table"><a·name="idp149495736"></a><p·class="title"><b>Tabel·6.4.·<span·class="emphasis"><em>Isikute·tabel</em></span></b></p><div·class="table-contents"><table·summary="Isikute·tabel"·border="1"><colgroup><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tänav</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Majanumber</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Linn</span></span></th></tr></thead><tbody><tr><td> |
| 99 | ····<p>Joan</p> | 99 | ····<p>Joan</p> |
| 100 | ····</td><td> | 100 | ····</td><td> |
| 101 | ····<p>Smith</p> | 101 | ····<p>Smith</p> |
| 102 | ····</td><td> | 102 | ····</td><td> |
| 103 | ····<p>Brama·Zachodnia</p> | 103 | ····<p>Brama·Zachodnia</p> |
| 104 | ····</td><td> | 104 | ····</td><td> |
| 105 | ····<p>1</p> | 105 | ····<p>1</p> |
| Offset 124, 15 lines modified | Offset 124, 15 lines modified |
| 124 | ····</td><td> | 124 | ····</td><td> |
| 125 | ····<p>nõutav·väli</p> | 125 | ····<p>nõutav·väli</p> |
| 126 | ····</td><td> | 126 | ····</td><td> |
| 127 | ····<p>nõutav·väli</p> | 127 | ····<p>nõutav·väli</p> |
| 128 | ····</td><td> | 128 | ····</td><td> |
| 129 | ····<p>nõutav·väli</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 129 | ····<p>nõutav·väli</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 130 | </p><p>Tänu·tingimuse·nõutav·väli·lisamisele·võime·olla·kindlad,·et·sisestatud·andmed·on·täielikud.·Mõningate·tabelite·korral·võib·muidugi·andmete·sisestamisel·lubada·teatud·väljade·tühjaksjätmist.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="limiting-data-view"></a>Andmevaate·piiramine</h3></div></div></div><p>Arvutustabelid·näitavad·tabeli·kõiki·ridu·ja·veerge,·mis·eriti·väga·suurte·andmetabelite·korral·on·päris·tülikas.·Arvutustabelis·võib·muidugi·ridu·filtreerida·ja·sorteerida,·kuid·seejuures·peab·olema·väga·ettevaatlik.·Arvutustabeli·kasutajad·võivad·sageli·unustada,·et·andmevaade·on·filtreeritud,·mis·võib·kaasa·tuua·eksimusi.·Näiteks·summa·arvutamisel·võid·arvata,·et·sul·ongi·100·andmerida,·ehkki·tegelikult·on·veel·20,·aga·need·on·peidetud.·</p><p>Kui·soovid·kasutada·andmete·väiksemat·hulka,·näiteks·saata·neid·teistele·redigeerimiseks,·võib·need·kopeerida·ja·asetada·teise·arvutustabelisse·ning·redigeerimise·järel·muudetud·andmed·taas·põhitabelisse·asetada.·Kui·✂ | 130 | </p><p>Tänu·tingimuse·nõutav·väli·lisamisele·võime·olla·kindlad,·et·sisestatud·andmed·on·täielikud.·Mõningate·tabelite·korral·võib·muidugi·andmete·sisestamisel·lubada·teatud·väljade·tühjaksjätmist.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="limiting-data-view"></a>Andmevaate·piiramine</h3></div></div></div><p>Arvutustabelid·näitavad·tabeli·kõiki·ridu·ja·veerge,·mis·eriti·väga·suurte·andmetabelite·korral·on·päris·tülikas.·Arvutustabelis·võib·muidugi·ridu·filtreerida·ja·sorteerida,·kuid·seejuures·peab·olema·väga·ettevaatlik.·Arvutustabeli·kasutajad·võivad·sageli·unustada,·et·andmevaade·on·filtreeritud,·mis·võib·kaasa·tuua·eksimusi.·Näiteks·summa·arvutamisel·võid·arvata,·et·sul·ongi·100·andmerida,·ehkki·tegelikult·on·veel·20,·aga·need·on·peidetud.·</p><p>Kui·soovid·kasutada·andmete·väiksemat·hulka,·näiteks·saata·neid·teistele·redigeerimiseks,·võib·need·kopeerida·ja·asetada·teise·arvutustabelisse·ning·redigeerimise·järel·muudetud·andmed·taas·põhitabelisse·asetada.·Kui·✂ |
| 131 | </p><div·class="table"><a·name="idp149477560"></a><p·class="title"><b>Tabel·6.5.·<span·class="emphasis"><em>Isikute·tabel</em></span></b></p><div·class="table-contents"><table·summary="Isikute·tabel"·border="1"><colgroup><col><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tänav</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Majanumber</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Linn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Sissetulek</sp·✂ | 131 | </p><div·class="table"><a·name="idp149518520"></a><p·class="title"><b>Tabel·6.5.·<span·class="emphasis"><em>Isikute·tabel</em></span></b></p><div·class="table-contents"><table·summary="Isikute·tabel"·border="1"><colgroup><col><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Perekonnanimi</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tänav</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Majanumber</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Linn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Sissetulek</sp·✂ |
| 132 | ····<p>Joan</p> | 132 | ····<p>Joan</p> |
| 133 | ····</td><td> | 133 | ····</td><td> |
| 134 | ····<p>Smith</p> | 134 | ····<p>Smith</p> |
| 135 | ····</td><td> | 135 | ····</td><td> |
| 136 | ····<p>Brama·Zachodnia</p> | 136 | ····<p>Brama·Zachodnia</p> |
| 137 | ····</td><td> | 137 | ····</td><td> |
| 138 | ····<p>1</p> | 138 | ····<p>1</p> |
| Offset 149, 15 lines modified | Offset 149, 15 lines modified |
| 149 | ····</td><td> | 149 | ····</td><td> |
| 150 | ····<p>5</p> | 150 | ····<p>5</p> |
| 151 | ····</td><td> | 151 | ····</td><td> |
| 152 | ····<p>London</p> | 152 | ····<p>London</p> |
| 153 | ····</td><td> | 153 | ····</td><td> |
| 154 | ····<p>1900</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 154 | ····<p>1900</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 155 | </p><p>Eeldame,·et·lisatud·veerg·Sissetulek·sisaldab·konfidentsiaalseid·andmeid.·Kuidas·jagada·nüüd·näiteks·isikute·kontaktandmeid·oma·kaastöötajatega·ilma·nende·isikute·sissetulekut·paljastamata?·See·on·võimalik,·kui·jagad·ainult·päringu,·aga·mitte·terve·tabeli.·Päring·võib·valida·kõik·veerud,·välja·arvatud·veerg·Sissetulek.·Andmebaaside·maailmas·kannab·selline·päring·sageli·nimetust·vaade.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="performance-and-capacity"></a>Jõudlus·ja·võimsus</h3></div></div></div><p>Sinu·arvuti·võib·olla·küll·võimas,·aga·peaaegu·kindlasti·koged,·et·väga·suurte·arvutustabelite·korral·jääb·see·ometi·aeglaseks.·Selle·põhjuseks·on·esmajoones·indeksi·puudumine,·mis·kiirendaks·andmete·otsingut.·Andmebaasid·pakuvad·sellist·võimalust.·Kui·aga·kasutad·näiteks·süsteemset·lõikepuhvrit,·võib·isegi·andmete·kopeerimisele·kuluda·närviajavalt·palju·aega.·</p><p>Suuri·andmekogumeid·sisaldavate·arvutustabelite·avamisele·võib·kuluda·väga·palju·aega.·Arvutusta·✂ | 155 | </p><p>Eeldame,·et·lisatud·veerg·Sissetulek·sisaldab·konfidentsiaalseid·andmeid.·Kuidas·jagada·nüüd·näiteks·isikute·kontaktandmeid·oma·kaastöötajatega·ilma·nende·isikute·sissetulekut·paljastamata?·See·on·võimalik,·kui·jagad·ainult·päringu,·aga·mitte·terve·tabeli.·Päring·võib·valida·kõik·veerud,·välja·arvatud·veerg·Sissetulek.·Andmebaaside·maailmas·kannab·selline·päring·sageli·nimetust·vaade.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="performance-and-capacity"></a>Jõudlus·ja·võimsus</h3></div></div></div><p>Sinu·arvuti·võib·olla·küll·võimas,·aga·peaaegu·kindlasti·koged,·et·väga·suurte·arvutustabelite·korral·jääb·see·ometi·aeglaseks.·Selle·põhjuseks·on·esmajoones·indeksi·puudumine,·mis·kiirendaks·andmete·otsingut.·Andmebaasid·pakuvad·sellist·võimalust.·Kui·aga·kasutad·näiteks·süsteemset·lõikepuhvrit,·võib·isegi·andmete·kopeerimisele·kuluda·närviajavalt·palju·aega.·</p><p>Suuri·andmekogumeid·sisaldavate·arvutustabelite·avamisele·võib·kuluda·väga·palju·aega.·Arvutusta·✂ |
| 156 | </p><div·class="table"><a·name="idp149671096"></a><p·class="title"><b>Tabel·7.1.·<span·class="emphasis"><em>Kexi·ja·teiste·andmebaasirakenduste·andmetüüpide·võrdlus</em></span></b></p><div·class="table-contents"><table·summary="Kexi·ja·teiste·andmebaasirakenduste·andmetüüpide·võrdlus"·border="1"><colgroup><col><col><col><col></colgroup><thead><tr><th><span·class="application">Kexi</span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">MS·Access</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">dBase/FoxPro</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Paradox</span></span></th></tr></thead><tbody><tr><td> | 156 | </p><div·class="table"><a·name="idp149683384"></a><p·class="title"><b>Tabel·7.1.·<span·class="emphasis"><em>Kexi·ja·teiste·andmebaasirakenduste·andmetüüpide·võrdlus</em></span></b></p><div·class="table-contents"><table·summary="Kexi·ja·teiste·andmebaasirakenduste·andmetüüpide·võrdlus"·border="1"><colgroup><col><col><col><col></colgroup><thead><tr><th><span·class="application">Kexi</span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">MS·Access</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">dBase/FoxPro</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Paradox</span></span></th></tr></thead><tbody><tr><td> |
| 157 | ····<p>Text·(Text)</p> | 157 | ····<p>Text·(Text)</p> |
| 158 | ····</td><td> | 158 | ····</td><td> |
| 159 | ····<p>Text</p> | 159 | ····<p>Text</p> |
| 160 | ····</td><td> | 160 | ····</td><td> |
| 161 | ····<p>Character</p> | 161 | ····<p>Character</p> |
| 162 | ····</td><td> | 162 | ····</td><td> |
| 163 | ····<p>Alphanumeric</p> | 163 | ····<p>Alphanumeric</p> |