{"id":231,"date":"2026-02-02T14:29:06","date_gmt":"2026-02-02T12:29:06","guid":{"rendered":"https:\/\/olegberezevski.wordpress.com\/?page_id=231"},"modified":"2026-02-02T14:29:06","modified_gmt":"2026-02-02T12:29:06","slug":"andmebaasisusteemid","status":"publish","type":"page","link":"https:\/\/olegberezevski.eu\/wp\/andmebaasisusteemid\/","title":{"rendered":"Andmebaaside p\u00f5him\u00f5isted"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Tunnis kasutame kolme andmebaaside haldamise programmi (andmebaasihaldurit):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>MS SQL Server Management Studio<\/strong> (SQL Server)<\/li>\n\n\n\n<li><strong>XAMPP \/ phpMyAdmin<\/strong><\/li>\n\n\n\n<li><strong>MS Access<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Andmebaaside t\u00fc\u00fcbid<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Lameandmebaas<\/strong> \u2013 n\u00e4iteks Exceli tabel<\/li>\n\n\n\n<li><strong>Desktop-andmebaasid<\/strong> \u2013 t\u00f6\u00f6tavad ainult <em>localhost\u2019i<\/em> keskkonnas<\/li>\n\n\n\n<li><strong>Hierarhilised andmebaasid<\/strong> \u2013 puustruktuuril p\u00f5hinev andmebaasimudel<\/li>\n\n\n\n<li><strong>Relatsioonilised andmebaasid<\/strong> (<em>relation<\/em> \u2013 suhted\/seosed) \u2013 koosnevad omavahel seotud andmetabelitest<\/li>\n\n\n\n<li><strong>NoSQL-andmebaasid<\/strong> (nt <strong>MongoDB<\/strong>) \u2013 dokumendip\u00f5hised andmebaasid<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">P\u00f5him\u00f5isted<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Andmebaas<\/strong><\/li>\n\n\n\n<li><strong>Tabel<\/strong> = olem (<em>entity<\/em>, \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u044c)<\/li>\n\n\n\n<li><strong>Veerg<\/strong> = v\u00e4li (<em>field<\/em>, \u043f\u043e\u043b\u044f)<\/li>\n\n\n\n<li><strong>Rida<\/strong> = kirje (<em>record<\/em>, \u0437\u0430\u043f\u0438\u0441\u0438)<\/li>\n\n\n\n<li><strong>Tunnused<\/strong> = atribuudid (<em>attributes<\/em>, \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u044b)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00f5tmed<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Primaarv\u00f5ti<\/strong> (<em>PRIMARY KEY<\/em>) \u2013 veerg unikaalse identifikaatoriga (nt <em>id<\/em>)<\/li>\n\n\n\n<li><strong>V\u00f5\u00f5rv\u00f5ti<\/strong> (<em>FOREIGN KEY<\/em>) \u2013 veerg, mis seob \u00fche tabeli teise tabeli primaarv\u00f5tmega<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Seosed tabelite vahel<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u00dcks-\u00fchele<\/strong> (nt mees \u2013 naine)<\/li>\n\n\n\n<li><strong>\u00dcks-mitmele<\/strong> (nt ema \u2013 lapsed)<\/li>\n\n\n\n<li><strong>Mitu-mitmele<\/strong> (nt t\u00f6\u00f6tajad \u2013 osakonnad)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">CRUD-operatsioonid<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Create<\/strong> \u2013 andmete loomine<\/li>\n\n\n\n<li><strong>Read<\/strong> \u2013 andmete lugemine<\/li>\n\n\n\n<li><strong>Update<\/strong> \u2013 andmete muutmine<\/li>\n\n\n\n<li><strong>Delete<\/strong> \u2013 andmete kustutamine<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Piirangud &#8211; constraint:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Primary key<\/li>\n\n\n\n<li>Foreign key<\/li>\n\n\n\n<li>UNIQUE<\/li>\n\n\n\n<li>not null<\/li>\n\n\n\n<li>check -?<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tunnis kasutame kolme andmebaaside haldamise programmi (andmebaasihaldurit): Andmebaaside t\u00fc\u00fcbid P\u00f5him\u00f5isted V\u00f5tmed Seosed tabelite vahel CRUD-operatsioonid Piirangud &#8211; constraint:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-231","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/pages\/231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/comments?post=231"}],"version-history":[{"count":0,"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/pages\/231\/revisions"}],"wp:attachment":[{"href":"https:\/\/olegberezevski.eu\/wp\/wp-json\/wp\/v2\/media?parent=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}