{"id":882,"date":"2025-10-13T08:35:14","date_gmt":"2025-10-13T06:35:14","guid":{"rendered":"https:\/\/illiablahun24.thkit.ee\/wp\/?page_id=882"},"modified":"2025-11-13T16:07:10","modified_gmt":"2025-11-13T14:07:10","slug":"ab-halduse-konspekt","status":"publish","type":"page","link":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/","title":{"rendered":"AB halduse konspekt"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#%F0%9F%97%84%EF%B8%8F_AB_ja_andmebaaside_konsoolid_AB_%D0%B8_%D0%B1%D0%B0%D0%B7%D1%8B_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85\" >\ud83d\uddc4\ufe0f AB ja andmebaaside konsoolid \/ AB \u0438 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#1%EF%B8%8F%E2%83%A3_AB_kasutajate_rollid_%D0%A0%D0%BE%D0%BB%D0%B8_%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D1%82%D0%B5%D0%BB%D0%B5%D0%B9_AB\" >1\ufe0f\u20e3 AB kasutajate rollid \/ \u0420\u043e\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 AB<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#DBA_liigid_%D0%92%D0%B8%D0%B4%D1%8B_DBA\" >DBA liigid \/ \u0412\u0438\u0434\u044b DBA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#DBA_peamised_eesmargid_%D0%9E%D1%81%D0%BD%D0%BE%D0%B2%D0%BD%D1%8B%D0%B5_%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B8_DBA\" >DBA peamised eesm\u00e4rgid \/ \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0437\u0430\u0434\u0430\u0447\u0438 DBA<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#2%EF%B8%8F%E2%83%A3_AB_turvalisus_%D0%91%D0%B5%D0%B7%D0%BE%D0%BF%D0%B0%D1%81%D0%BD%D0%BE%D1%81%D1%82%D1%8C_AB\" >2\ufe0f\u20e3 AB turvalisus \/ \u0411\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u044c AB<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#Kolm_pohiaspekti_%D0%A2%D1%80%D0%B8_%D0%BE%D1%81%D0%BD%D0%BE%D0%B2%D0%BD%D1%8B%D1%85_%D0%B0%D1%81%D0%BF%D0%B5%D0%BA%D1%82%D0%B0\" >Kolm p\u00f5hiaspekti \/ \u0422\u0440\u0438 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0430\u0441\u043f\u0435\u043a\u0442\u0430<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#Riskid_ja_ohustused_%D0%A0%D0%B8%D1%81%D0%BA%D0%B8_%D0%B8_%D1%83%D0%B3%D1%80%D0%BE%D0%B7%D1%8B\" >Riskid ja ohustused \/ \u0420\u0438\u0441\u043a\u0438 \u0438 \u0443\u0433\u0440\u043e\u0437\u044b<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#3%EF%B8%8F%E2%83%A3_Tehingud_%D0%A2%D1%80%D0%B0%D0%BD%D0%B7%D0%B0%D0%BA%D1%86%D0%B8%D0%B8\" >3\ufe0f\u20e3 Tehingud \/ \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#4%EF%B8%8F%E2%83%A3_Andmeladustamine_ja_andmete_analuus_%D0%A5%D1%80%D0%B0%D0%BD%D0%B8%D0%BB%D0%B8%D1%89%D0%B0_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85_%D0%B8_%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7\" >4\ufe0f\u20e3 Andmeladustamine ja andmete anal\u00fc\u00fcs \/ \u0425\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0430\u043d\u0430\u043b\u0438\u0437<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#5%EF%B8%8F%E2%83%A3_Adventure_AB_SQL_naited_%D0%9F%D1%80%D0%B8%D0%BC%D0%B5%D1%80%D1%8B_SQL_Adventure_AB\" >5\ufe0f\u20e3 Adventure AB SQL n\u00e4ited \/ \u041f\u0440\u0438\u043c\u0435\u0440\u044b SQL Adventure AB<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#GROUP_BY\" >GROUP BY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#UNION_ALL\" >UNION ALL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#GROUPING\" >GROUPING<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#ROLLUP\" >ROLLUP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#CUBE\" >CUBE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#Erinevus_ROLLUP_vs_CUBE\" >Erinevus ROLLUP vs CUBE<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%97%84%EF%B8%8F_AB_ja_andmebaaside_konsoolid_AB_%D0%B8_%D0%B1%D0%B0%D0%B7%D1%8B_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85\"><\/span>\ud83d\uddc4\ufe0f AB ja andmebaaside konsoolid \/ AB \u0438 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1%EF%B8%8F%E2%83%A3_AB_kasutajate_rollid_%D0%A0%D0%BE%D0%BB%D0%B8_%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D1%82%D0%B5%D0%BB%D0%B5%D0%B9_AB\"><\/span>1\ufe0f\u20e3 AB kasutajate rollid \/ \u0420\u043e\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 AB<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AB kasutaja<\/strong> \u2013 tavakasutaja, saab muuta, lisada, filtreerida ja otsida andmeid vastavalt vajadusele.<\/li>\n\n\n\n<li><strong>AB programmeerija<\/strong> \u2013 loob funktsioonid, protseduurid ja trigerid.<\/li>\n\n\n\n<li><strong>DBA (AB administraator)<\/strong> \u2013 tagab, et \u00f5iged kasutajad saavad \u00f5iged ligip\u00e4\u00e4sud.<\/li>\n\n\n\n<li><strong>AB projekteerija<\/strong> \u2013 loob tabelid ja AB struktuuri.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DBA_liigid_%D0%92%D0%B8%D0%B4%D1%8B_DBA\"><\/span>DBA liigid \/ \u0412\u0438\u0434\u044b DBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00fcsteemiadmin<\/li>\n\n\n\n<li>AB arhitekt<\/li>\n\n\n\n<li>AB anal\u00fc\u00fctik<\/li>\n\n\n\n<li>Data warehouse spetsialist<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DBA_peamised_eesmargid_%D0%9E%D1%81%D0%BD%D0%BE%D0%B2%D0%BD%D1%8B%D0%B5_%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B8_DBA\"><\/span>DBA peamised eesm\u00e4rgid \/ \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0437\u0430\u0434\u0430\u0447\u0438 DBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Kasutajate toetus ja ligip\u00e4\u00e4su seadistamine<\/li>\n\n\n\n<li>AB turvalisuse ja j\u00f5udluse tagamine<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2%EF%B8%8F%E2%83%A3_AB_turvalisus_%D0%91%D0%B5%D0%B7%D0%BE%D0%BF%D0%B0%D1%81%D0%BD%D0%BE%D1%81%D1%82%D1%8C_AB\"><\/span><a href=\"https:\/\/habr.com\/ru\/companies\/otus\/articles\/732850\/\">2\ufe0f\u20e3 AB turvalisus \/ \u0411\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u044c AB<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kolm_pohiaspekti_%D0%A2%D1%80%D0%B8_%D0%BE%D1%81%D0%BD%D0%BE%D0%B2%D0%BD%D1%8B%D1%85_%D0%B0%D1%81%D0%BF%D0%B5%D0%BA%D1%82%D0%B0\"><\/span>Kolm p\u00f5hiaspekti \/ \u0422\u0440\u0438 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0430\u0441\u043f\u0435\u043a\u0442\u0430<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Konfidentsiaalsus (Confidentiality)<\/strong>\n<ul class=\"wp-block-list\">\n<li>GRANT role to user [identified by pwd] [with grant option];<\/li>\n\n\n\n<li>REVOKE role from user;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>K\u00e4ttesaadavus (Availability)<\/strong>\n<ul class=\"wp-block-list\">\n<li>Andmed peavad olema k\u00e4ttesaadavad \u00f5igel ajal ja \u00f5igel kasutajal.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Terviklikkus (Integrity)<\/strong>\n<ul class=\"wp-block-list\">\n<li>Andmebaasi usaldusv\u00e4\u00e4rsus ja andmete terviklikkus.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Riskid_ja_ohustused_%D0%A0%D0%B8%D1%81%D0%BA%D0%B8_%D0%B8_%D1%83%D0%B3%D1%80%D0%BE%D0%B7%D1%8B\"><\/span>Riskid ja ohustused \/ \u0420\u0438\u0441\u043a\u0438 \u0438 \u0443\u0433\u0440\u043e\u0437\u044b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Ohustuse allikas<\/th><th>M\u00f5jutatud aspektid<\/th><\/tr><\/thead><tbody><tr><td>Inimlikud vead<\/td><td>Konfidentsiaalsus, K\u00e4ttesaadavus, Terviklikkus<\/td><\/tr><tr><td>F\u00fc\u00fcsilised vead (riistvara)<\/td><td>K\u00e4ttesaadavus, Terviklikkus<\/td><\/tr><tr><td>OS rikked<\/td><td>K\u00e4ttesaadavus, Terviklikkus, Konfidentsiaalsus<\/td><\/tr><tr><td>DB s\u00fcsteemi rikked<\/td><td>K\u00e4ttesaadavus, Terviklikkus, Konfidentsiaalsus<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3%EF%B8%8F%E2%83%A3_Tehingud_%D0%A2%D1%80%D0%B0%D0%BD%D0%B7%D0%B0%D0%BA%D1%86%D0%B8%D0%B8\"><\/span>3\ufe0f\u20e3 <a href=\"https:\/\/proselyte.net\/tutorials\/sql\/sql-transactions\/\">Tehingud \/ \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>COMMIT<\/strong> \u2013 kinnitab tehingu; salvestab k\u00f5ik muudatused andmebaasis.<\/li>\n\n\n\n<li><strong>ROLLBACK<\/strong> \u2013 t\u00fchistab k\u00f5ik muudatused p\u00e4rast viimast COMMIT.<\/li>\n\n\n\n<li><strong>ROLLFORWARD<\/strong> \u2013 taastab andmebaasi, rakendades logis salvestatud kinnitatud muudatused p\u00e4rast s\u00fcsteemi riket.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4%EF%B8%8F%E2%83%A3_Andmeladustamine_ja_andmete_analuus_%D0%A5%D1%80%D0%B0%D0%BD%D0%B8%D0%BB%D0%B8%D1%89%D0%B0_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85_%D0%B8_%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7\"><\/span>4\ufe0f\u20e3 Andmeladustamine ja andmete anal\u00fc\u00fcs \/ \u0425\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0430\u043d\u0430\u043b\u0438\u0437<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Data Mining \/ Andmete kaevandamine<\/strong> \u2013 peidetud mustrite ja seoste leidmine andmetes; kasutab statistikat ja masin\u00f5pet.<\/li>\n\n\n\n<li><strong>Data Warehouse \/ Andmeladu (EDW)<\/strong> \u2013 platvorm, mis koondab andmeid erinevatest allikatest, v\u00f5imaldab anal\u00fc\u00fcsi ja aruandlust (m\u00fc\u00fck, turundus, kliendihaldus).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5%EF%B8%8F%E2%83%A3_Adventure_AB_SQL_naited_%D0%9F%D1%80%D0%B8%D0%BC%D0%B5%D1%80%D1%8B_SQL_Adventure_AB\"><\/span>5\ufe0f\u20e3 Adventure AB SQL n\u00e4ited \/ \u041f\u0440\u0438\u043c\u0435\u0440\u044b SQL Adventure AB<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GROUP_BY\"><\/span>GROUP BY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM DimEmployee\nGROUP BY Country, Gender;\n\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>R\u00fchmitab andmed \u00fche v\u00f5i mitme veeru j\u00e4rgi ja arvutab koondtulemusi (SUM, AVG, COUNT).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"UNION_ALL\"><\/span>UNION ALL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM DimEmployee\nGROUP BY Country, Gender\n\nUNION ALL\n\nSELECT Country, NULL, SUM(Salary) AS TotalSalary\nFROM DimEmployee\nGROUP BY Country\n\nUNION ALL\n\nSELECT NULL, Gender, SUM(Salary) AS TotalSalary\nFROM DimEmployee\n\nUNION ALL\n\nSELECT NULL, NULL, SUM(Salary) AS TotalSalary\nFROM DimEmployee;\n\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Liidab tulemused, s\u00e4ilitades k\u00f5ik read, sealhulgas duplikaadid.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"GROUPING\"><\/span>GROUPING<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM DimEmployee\nGROUP BY \n    GROUPING SETS\n    (\n        (Country, Gender),\n        (Country),\n        (Gender),\n        ()\n    )\nORDER BY GROUPING(Country), GROUPING(Gender), Gender;\n\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>N\u00e4itab, millised read on koondatud ja millised algandmed.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ROLLUP\"><\/span>ROLLUP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM DimEmployee\nGROUP BY ROLLUP(Country, Gender);\n\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Hierarhiline koondamine: alamgrupid \u2192 riik \u2192 \u00fcldsumma.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"CUBE\"><\/span>CUBE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Country, Gender, SUM(Salary) AS TotalSalary\nFROM DimEmployee\nGROUP BY CUBE(Country, Gender);\n\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Koondab k\u00f5ikides veergude kombinatsioonides; n\u00e4itab <strong>t\u00e4ielikku mitmem\u00f5\u00f5tmelist kokkuv\u00f5tet<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Erinevus_ROLLUP_vs_CUBE\"><\/span>Erinevus ROLLUP vs CUBE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Funktsioon<\/th><th>Arvutus<\/th><th>Tulemus<\/th><\/tr><\/thead><tbody><tr><td><strong>ROLLUP<\/strong><\/td><td>Hierarhiliselt<\/td><td>Koondab summad hierarhia tasanditel<\/td><\/tr><tr><td><strong>CUBE<\/strong><\/td><td>K\u00f5ik kombinatsioonid<\/td><td>Koondab summad k\u00f5igis veergude kombinatsioonides<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\uddc4\ufe0f AB ja andmebaaside konsoolid \/ AB \u0438 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 1\ufe0f\u20e3 AB kasutajate rollid \/ \u0420\u043e\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 AB DBA liigid \/ \u0412\u0438\u0434\u044b DBA DBA peamised eesm\u00e4rgid \/ \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0437\u0430\u0434\u0430\u0447\u0438 DBA 2\ufe0f\u20e3 AB turvalisus \/ \u0411\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u044c AB Kolm p\u00f5hiaspekti \/ \u0422\u0440\u0438 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0430\u0441\u043f\u0435\u043a\u0442\u0430 Riskid ja ohustused \/ \u0420\u0438\u0441\u043a\u0438 \u0438 \u0443\u0433\u0440\u043e\u0437\u044b Ohustuse allikas M\u00f5jutatud aspektid Inimlikud vead [&hellip;]<\/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-882","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AB halduse konspekt - Illia Blahun portfoolio<\/title>\n<meta name=\"description\" content=\"Konspekt AB-s\u00fcsteemidest ja andmebaasidest: AB kasutajate ja DBA rollid ning \u00fclesanded, turvalisus ja ligip\u00e4\u00e4su\u00f5igused.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB halduse konspekt - Illia Blahun portfoolio\" \/>\n<meta property=\"og:description\" content=\"Konspekt AB-s\u00fcsteemidest ja andmebaasidest: AB kasutajate ja DBA rollid ning \u00fclesanded, turvalisus ja ligip\u00e4\u00e4su\u00f5igused.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:site_name\" content=\"Illia Blahun portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T14:07:10+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/\",\"url\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/\",\"name\":\"AB halduse konspekt - Illia Blahun portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2025-10-13T06:35:14+00:00\",\"dateModified\":\"2025-11-13T14:07:10+00:00\",\"description\":\"Konspekt AB-s\u00fcsteemidest ja andmebaasidest: AB kasutajate ja DBA rollid ning \u00fclesanded, turvalisus ja ligip\u00e4\u00e4su\u00f5igused.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/ab-halduse-konspekt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB halduse konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/\",\"name\":\"Illia Blahun portfoolio\",\"description\":\"Noorem tarvaarendaja\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/illiablahun24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB halduse konspekt - Illia Blahun portfoolio","description":"Konspekt AB-s\u00fcsteemidest ja andmebaasidest: AB kasutajate ja DBA rollid ning \u00fclesanded, turvalisus ja ligip\u00e4\u00e4su\u00f5igused.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/","og_locale":"et_EE","og_type":"article","og_title":"AB halduse konspekt - Illia Blahun portfoolio","og_description":"Konspekt AB-s\u00fcsteemidest ja andmebaasidest: AB kasutajate ja DBA rollid ning \u00fclesanded, turvalisus ja ligip\u00e4\u00e4su\u00f5igused.","og_url":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/","og_site_name":"Illia Blahun portfoolio","article_modified_time":"2025-11-13T14:07:10+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/","url":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/","name":"AB halduse konspekt - Illia Blahun portfoolio","isPartOf":{"@id":"https:\/\/illiablahun24.thkit.ee\/wp\/#website"},"datePublished":"2025-10-13T06:35:14+00:00","dateModified":"2025-11-13T14:07:10+00:00","description":"Konspekt AB-s\u00fcsteemidest ja andmebaasidest: AB kasutajate ja DBA rollid ning \u00fclesanded, turvalisus ja ligip\u00e4\u00e4su\u00f5igused.","breadcrumb":{"@id":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/illiablahun24.thkit.ee\/wp\/ab-halduse-konspekt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/illiablahun24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"AB halduse konspekt"}]},{"@type":"WebSite","@id":"https:\/\/illiablahun24.thkit.ee\/wp\/#website","url":"https:\/\/illiablahun24.thkit.ee\/wp\/","name":"Illia Blahun portfoolio","description":"Noorem tarvaarendaja","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/illiablahun24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=882"}],"version-history":[{"count":8,"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/882\/revisions"}],"predecessor-version":[{"id":1021,"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/882\/revisions\/1021"}],"wp:attachment":[{"href":"https:\/\/illiablahun24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}