{"id":979,"date":"2025-10-13T08:20:36","date_gmt":"2025-10-13T06:20:36","guid":{"rendered":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979"},"modified":"2025-11-13T14:38:07","modified_gmt":"2025-11-13T12:38:07","slug":"ab-halduse-konkpeks","status":"publish","type":"page","link":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979","title":{"rendered":"AB halduse konkpeks"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">AB kasutaja rollid:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>AB kasutaja<\/em> <\/strong>&#8211; tavakasutaja saab muuta, lisuda, filtreerida ja otside vastavalt vajadusel<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em><strong>AB programmerija<\/strong><\/em> &#8211; loob funktsioonid ja protseduurid (triggerid)<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>DBA &#8211; AB administrator<\/em><\/strong> &#8211; tagab, et \u00f5igused kasutajad saavad oma \u00f5igused<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>AB projekteerija<\/em><\/strong> &#8211; loob tabelid ja AB struktuuri<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><em>DBA &#8211; AB administrator<\/em> liigid: <\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>s\u00fcsteemadmin<\/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 &#8211; \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (andmeladu admin)<\/li>\n<\/ul>\n\n\n\n<p><strong>DBA kaks peamist eesm\u00e4rk<\/strong> (ulesanded):<br>1. Kasutajate teotus ja ligap\u00e4\u00e4s jagamine ja seadistamine<br>2. AB turvalisus ja j\u00f5udluse tagamine<br><\/p>\n\n\n\n<p><strong>AB turvalisus &#8211; 3 p\u00f5hiaspekt<\/strong>:\n*Konfidentsiaalsus (<strong>confidentiality<\/strong>)\n\nGRANT role to user [identified by pwd] [with grant option];\nREVOKE role from user;\n\n\n*K\u00e4ttesaadavus (<strong>availability<\/strong>) &#8211; \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c\nAndmed me saame k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal\n\n*Terviklikkus (<strong>integrity<\/strong>) &#8211; \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c\nUsaldusv\u00e4\u00e4rne andmealiikad\n<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<figure class=\"wp-block-table alignfull\"><table class=\"has-fixed-layout\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Risk<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>Ohustuse aspekt<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Inimlikud vead<\/td><td class=\"has-text-align-center\" data-align=\"center\">Konfidentsiaalsus, k\u00e4ttesaadavus, terkvikilkkus<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">F\u00fc\u00fcsilised vead(riistvara)<\/td><td class=\"has-text-align-center\" data-align=\"center\">K\u00e4ttesaadavus, terviklikus<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Operatsioonis\u00fcsteem rikked<\/td><td class=\"has-text-align-center\" data-align=\"center\">Konfidentsiaalsus, k\u00e4ttesaadavus, terkvikilkkus<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Andmebaasis\u00fcsteem rikked<\/td><td class=\"has-text-align-center\" data-align=\"center\">Konfidentsiaalsus, k\u00e4ttesaadavus, terkvikilkkus<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<p><strong>COMMIT<\/strong> \u2014 salvestab muudatused andmebaasi, teeb need p\u00fcsivaks.<br><strong>ROLLBACK<\/strong> \u2014 t\u00fchistab muudatused, taastades andmebaasi eelmisesse (\u00f5igesse) olekusse.<br><strong>ROLLFORWARD<\/strong> \u2014 taastab andmebaasi, rakendades muudatused p\u00e4rast varukoopia tegemist, kui juhtus t\u00f5rge.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Data Mining \u2013 andmete kaevandamine, meetod, mille abil otsitakse andmetest peidetud mustreid ja seoseid.<br><br>Data Warehouse \u2013 Spetsiaalselt v\u00e4lja t\u00f6\u00f6tatud ja m\u00f5eldud andmebaas aruannete koostamiseks ja \u00e4rianal\u00fc\u00fcsiks, et toetada organisatsiooni otsuste tegemist. P\u00f5hineb andmebaaside haldamise s\u00fcsteemidel ja otsuste tegemise toetamise s\u00fcsteemidel.<\/pre>\n\n\n\n<p><strong>GROUP BY<\/strong> &#8211; operaator r\u00fchmitab \u00fchesuguste v\u00e4\u00e4rtustega read kokkuv\u00f5tlikeks ridadeks.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\nSELECT g.CountryRegionCode AS Country, e.Gender, SUM(e.YearlyIncome) AS TotalSalary\nFROM DimCustomer e\nJOIN DimGeography g ON e.GeographyKey = g.GeographyKey\n<strong>GROUP BY<\/strong> g.CountryRegionCode, e.Gender\nORDER BY Country, Gender<\/code><\/pre>\n\n\n\n<p><strong>UNION ALL<\/strong> &#8211; See on viis, kuidas \u00fchendada kahe (v\u00f5i enama) p\u00e4ringu tulemused \u00fcheks nimekirjaks.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT g.CountryRegionCode AS Country, e.Gender, SUM(e.YearlyIncome) AS TotalSalary\nFROM DimCustomer e\nJOIN DimGeography g ON e.GeographyKey = g.GeographyKey\nGROUP BY g.CountryRegionCode, e.Gender\n\nUNION ALL\n\nSELECT g.CountryRegionCode AS Country, NULL AS Gender, SUM(e.YearlyIncome) AS TotalSalary\nFROM DimCustomer e\nJOIN DimGeography g ON e.GeographyKey = g.GeographyKey\nGROUP BY g.CountryRegionCode\nORDER BY Country, Gender;\n<\/code><\/pre>\n\n\n\n<p><strong>GROUPING <\/strong>&#8211; See on spetsiaalne funktsioon, mis aitab eristada tavalisi ridu ridadest, mis on loodud funktsioonide <strong>GROUP BY <\/strong>ja <strong>ROLLUP <\/strong>v\u00f5i <strong>CUBE <\/strong>abil.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales,\nGROUPING (Continent) AS GP_Continent,\nGROUPING (Country) AS GP_Country,\nGROUPING(City) AS GP_City\nFROM Sales\nGROUP BY ROLLUP (Continent, Country, City)<\/code><\/pre>\n\n\n\n<p><strong>ROLLUP <\/strong>&#8211; See on viis vahetulemuste saamiseks r\u00fchmitamisel.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT ISNULL(Continent, 'All') AS Continent,\n\tISNULL(Country, 'All') AS Country, \n\tISNULL(City, 'All') AS City,\n\tSUM (SaleAmount) AS TotalSales\nFROM Sales\nGROUP BY ROLLUP (Continent, Country, City)<\/code><\/pre>\n\n\n\n<p>Erinevus <strong>ROLLUP <\/strong>ja <strong>CUBE<\/strong>:<br><br><strong>ROLLUP <\/strong>\u2014 lisab tulemused tasandite kaupa \u00fclalt alla.<\/p>\n\n\n\n<p><strong>CUBE <\/strong>\u2014 lisab k\u00f5ik v\u00f5imalikud tulemuste kombinatsioonid.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Allikad:<br><a href=\"https:\/\/www.w3schools.com\/\">w3schools<\/a><br><a href=\"http:\/\/google.com\">Google<\/a><br><\/p>\n\n\n\n<p>Samuti v\u00f5ite vaadata mu teisi SQL-i konspekte siin:<\/p>\n\n\n\n<p><a href=\"https:\/\/nikitanikiforov24.thkit.ee\/wp\/blog\/2025\/02\/21\/sql\/\n\">https:\/\/nikitanikiforov24.thkit.ee\/wp\/blog\/2025\/02\/21\/sql\/<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AB kasutaja rollid: DBA &#8211; AB administrator liigid: DBA kaks peamist eesm\u00e4rk (ulesanded):1. Kasutajate teotus ja ligap\u00e4\u00e4s jagamine ja seadistamine2. AB turvalisus ja j\u00f5udluse tagamine AB turvalisus &#8211; 3 p\u00f5hiaspekt: *Konfidentsiaalsus (confidentiality) GRANT role to user [identified by pwd] [with grant option]; REVOKE role from user; *K\u00e4ttesaadavus (availability) &#8211; \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c Andmed me saame k\u00e4tte \u00f5igel [&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-979","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 konkpeks - Nikita Nikiforov Portfolio .Kokkuv\u00f5te planeedi targemast inimesest<\/title>\n<meta name=\"description\" content=\"AB kasutaja rollid: AB kasutaja, AB programmerija, DBA, AB projekteerija. DBA liigid: s\u00fcsteemadmin, AB arhitekt, AB anal\u00fc\u00fctik, Data ........\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB halduse konkpeks - Nikita Nikiforov Portfolio .Kokkuv\u00f5te planeedi targemast inimesest\" \/>\n<meta property=\"og:description\" content=\"AB kasutaja rollid: AB kasutaja, AB programmerija, DBA, AB projekteerija. DBA liigid: s\u00fcsteemadmin, AB arhitekt, AB anal\u00fc\u00fctik, Data ........\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Nikiforov Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T12:38:07+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:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=979\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=979\",\"name\":\"AB halduse konkpeks - Nikita Nikiforov Portfolio .Kokkuv\u00f5te planeedi targemast inimesest\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2025-10-13T06:20:36+00:00\",\"dateModified\":\"2025-11-13T12:38:07+00:00\",\"description\":\"AB kasutaja rollid: AB kasutaja, AB programmerija, DBA, AB projekteerija. DBA liigid: s\u00fcsteemadmin, AB arhitekt, AB anal\u00fc\u00fctik, Data ........\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=979#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=979\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=979#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB halduse konkpeks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\",\"name\":\"Nikita Nikiforov Portfolio\",\"description\":\"Noorem Tarkvarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Nikita Nikiforov Portfolio\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png\",\"width\":150,\"height\":137,\"caption\":\"Nikita Nikiforov Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB halduse konkpeks - Nikita Nikiforov Portfolio .Kokkuv\u00f5te planeedi targemast inimesest","description":"AB kasutaja rollid: AB kasutaja, AB programmerija, DBA, AB projekteerija. DBA liigid: s\u00fcsteemadmin, AB arhitekt, AB anal\u00fc\u00fctik, Data ........","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:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979","og_locale":"et_EE","og_type":"article","og_title":"AB halduse konkpeks - Nikita Nikiforov Portfolio .Kokkuv\u00f5te planeedi targemast inimesest","og_description":"AB kasutaja rollid: AB kasutaja, AB programmerija, DBA, AB projekteerija. DBA liigid: s\u00fcsteemadmin, AB arhitekt, AB anal\u00fc\u00fctik, Data ........","og_url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979","og_site_name":"Nikita Nikiforov Portfolio","article_modified_time":"2025-11-13T12:38:07+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979","name":"AB halduse konkpeks - Nikita Nikiforov Portfolio .Kokkuv\u00f5te planeedi targemast inimesest","isPartOf":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#website"},"datePublished":"2025-10-13T06:20:36+00:00","dateModified":"2025-11-13T12:38:07+00:00","description":"AB kasutaja rollid: AB kasutaja, AB programmerija, DBA, AB projekteerija. DBA liigid: s\u00fcsteemadmin, AB arhitekt, AB anal\u00fc\u00fctik, Data ........","breadcrumb":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=979#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"AB halduse konkpeks"}]},{"@type":"WebSite","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#website","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/","name":"Nikita Nikiforov Portfolio","description":"Noorem Tarkvarendaja","publisher":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#organization","name":"Nikita Nikiforov Portfolio","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png","contentUrl":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png","width":150,"height":137,"caption":"Nikita Nikiforov Portfolio"},"image":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/979","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=979"}],"version-history":[{"count":10,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/979\/revisions"}],"predecessor-version":[{"id":1146,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/979\/revisions\/1146"}],"wp:attachment":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}