{"id":1143,"date":"2025-10-16T10:54:21","date_gmt":"2025-10-16T08:54:21","guid":{"rendered":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/?p=1143"},"modified":"2025-10-16T10:54:21","modified_gmt":"2025-10-16T08:54:21","slug":"ab-haldus-konspekt-2","status":"publish","type":"post","link":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143","title":{"rendered":"AB haldus konspekt"},"content":{"rendered":"\n
AB kasutajate rollid:\n\n-AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele\n\n-AB programmerija -loob funktsioonid protseduurid (trigerid)\n\n- DBA - AB administratoor - tagab, et \u00f5iged kasutajad saavad oma \u00f5igused\n\n- AB projekteerija - loob tabeleid ja AB struktuuri<\/code><\/pre>\n\n\n\n
DBA -AB administratoor liigid:<\/strong>\n*s\u00fcsteemiadmin\n*AB arhitekt\n*AB anal\u00fc\u00fctik\n*Data warehouse admin -  \u0430\u0434\u043c\u0438\u043d \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (admeladu)\n<\/code><\/pre>\n\n\n\n
DBA kaks peamist eesm\u00e4rki (\u00fclesanded):<\/strong>
1. kasutajate toetus ja ligip\u00e4\u00e4su jagamine ja seadistamine
2. AB turvalisus ja j\u00f5udluse tagamine<\/pre>\n\n\n\n
AB turvalisus - 3 p\u00f5hiaspekti:<\/strong>
*andmete konfidentsiaalsus<\/em><\/strong> (confidentiality)
GRANT role to user [identified by pwd] [with grant option];
REVOKE role from user;

*andmete k\u00e4ttesaadavus<\/em><\/strong> (availability)- \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c <\/strong>- andmed me samme k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal
*andmete terviklikkus<\/em><\/strong>(integrity) - \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c <\/strong>- usaldusv\u00e4\u00e4rne andmeallikad<\/pre>\n\n\n\n
Risk<\/strong><\/td>Ohutuse aspekt<\/strong><\/td><\/tr>
Inimlikud vead<\/td>konfidentsiaalsus<\/strong>, k\u00e4ttesaadavus<\/strong>, terviklikkus<\/strong><\/td><\/tr>
f\u00fc\u00fcsilised vead (riistvara – hardware)<\/td>k\u00e4ttesaadavus<\/strong>, terviklikkus<\/strong><\/td><\/tr>
operatsioonis\u00fcsteemi rikked<\/td>k\u00e4ttesaadavus<\/strong>, terviklikkus<\/strong>, konfidentsiaalsus<\/strong><\/td><\/tr>
andmebaasis\u00fcsteemi rikked<\/td>k\u00e4ttesaadavus<\/strong>, terviklikkus<\/strong>, konfidentsiaalsus<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
-COMMIT<\/strong> -COMMIT-k\u00e4sku kasutatakse k\u00f5igi praeguse tehingu k\u00e4igus tehtud muudatuste salvestamiseks andmebaasi. Kui tehing on kinnitatud, muutuvad muudatused p\u00fcsivaks. 

-ROLLBACK<\/strong> - Kui tekib viga, n\u00e4iteks p\u00e4ringu probleem, saate ROLLBACK-i abil t\u00fchistada k\u00f5ik tehingu k\u00e4igus tehtud muudatused

-ROLLFORWARD<\/strong> - k\u00e4sk taastab andmebaasi, rakendades andmebaasi logifailidesse salvestatud tehinguid. 

-Data mining<\/strong> - v\u00e4\u00e4rtuslike mustrite ja j\u00e4relduste avastamine suurte andmekogumite p\u00f5hjal, kasutades masin\u00f5ppe, statistika ja andmebaasis\u00fcsteemide meetodeid.

-Data warehouse<\/strong> - on erinevatest allikatest integreeritud andmete keskne hoidla. Need hoiavad praeguseid ja varasemaid andmeid, mis on organiseeritud viisil, mis on optimeeritud andmete anal\u00fc\u00fcsimiseks, aruannete koostamiseks ja integreeritud andmete p\u00f5hjal j\u00e4relduste tegemiseks.

GROUP BY<\/strong> - lause r\u00fchmitab samade v\u00e4\u00e4rtustega read kokkuv\u00f5tete ridadeks, n\u00e4iteks \u201eleia klientide arv igas riigis\u201d

SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country;

UNION ALL<\/strong> - k\u00e4sk \u00fchendab kahe v\u00f5i enama SELECT-lause tulemusjoukonna (lubab dubleeritud v\u00e4\u00e4rtusi)

SELECT City FROM Customers
UNION ALL
SELECT City FROM Suppliers
ORDER BY City;

GROUPING <\/strong>- M\u00e4\u00e4rab, kas GROUP BY loendis olev veeruavaldis on agregeeritud v\u00f5i mitte

SELECT SalesQuota, SUM(SalesYTD) 'TotalSalesYTD', GROUPING(SalesQuota) AS 'Grouping'  
FROM Sales.SalesPerson  
GROUP BY SalesQuota WITH ROLLUP;  
GO  

- ROLLUP <\/strong>- operaator t\u00e4iustab GROUP BY-klausli v\u00f5imekust, v\u00f5imaldades arvutada veergude kogumi vahe- ja kogusummasid.

select COALESCE(Department, 'Total') as Department SUM(Salary)
from Employee1
Group By ROLLUP (Department);

- CUBE <\/strong>- on GROUP BY-klausli laiendus, mis v\u00f5imaldab genereerida k\u00f5ik v\u00f5imalikud r\u00fchmade kombinatsioonid m\u00e4\u00e4ratud veergude jaoks, sealhulgas vahesummad ja kogusumma.

SELECT state, SUM(salary) AS salary
FROM salary_reports
GROUP BY CUBE(state)
ORDER BY state;

Erunevus ROLLUP and CUBE<\/strong> - ROLLUP teeb kokkuv\u00f5tte GROUP BY-klauslis kasutatud veergude hierarhia alusel. CUBE r\u00fchmitab k\u00f5ikide v\u00e4\u00e4rtuste kombinatsioonide j\u00e4rgi. \/ Rollup summerib hierarhiliselt valitud veergud CUBE, arvatub summad igas veerus\/kombinatrsioonis<\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
DBA kaks peamist eesm\u00e4rki (\u00fclesanded):1. kasutajate toetus ja ligip\u00e4\u00e4su jagamine ja seadistamine2. AB turvalisus ja j\u00f5udluse tagamine AB turvalisus – 3 p\u00f5hiaspekti:*andmete konfidentsiaalsus (confidentiality)GRANT role to user [identified by pwd] [with grant option];REVOKE role from user;*andmete k\u00e4ttesaadavus (availability)- \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c – andmed me samme k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal*andmete terviklikkus(integrity) – \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c – usaldusv\u00e4\u00e4rne andmeallikad […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1143","post","type-post","status-publish","format-standard","hentry","category-maaratlemata"],"yoast_head":"\nAB haldus konspekt - Hussein Tahmazov portfolio eng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB haldus konspekt - Hussein Tahmazov portfolio eng\" \/>\n<meta property=\"og:description\" content=\"DBA kaks peamist eesm\u00e4rki (\u00fclesanded):1. kasutajate toetus ja ligip\u00e4\u00e4su jagamine ja seadistamine2. AB turvalisus ja j\u00f5udluse tagamine AB turvalisus - 3 p\u00f5hiaspekti:*andmete konfidentsiaalsus (confidentiality)GRANT role to user [identified by pwd] [with grant option];REVOKE role from user;*andmete k\u00e4ttesaadavus (availability)- \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c - andmed me samme k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal*andmete terviklikkus(integrity) - \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c - usaldusv\u00e4\u00e4rne andmeallikad […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143\" \/>\n<meta property=\"og:site_name\" content=\"Hussein Tahmazov portfolio eng\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-16T08:54:21+00:00\" \/>\n<meta name=\"author\" content=\"Hussein\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hussein\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143\"},\"author\":{\"name\":\"Hussein\",\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/#\\\/schema\\\/person\\\/f75baafdedeb73cd9ef1d8d87311bbb0\"},\"headline\":\"AB haldus konspekt\",\"datePublished\":\"2025-10-16T08:54:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143\"},\"wordCount\":35,\"commentCount\":0,\"articleSection\":[\"M\u00e4\u00e4ratlemata\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143\",\"url\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143\",\"name\":\"AB haldus konspekt - Hussein Tahmazov portfolio eng\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"datePublished\":\"2025-10-16T08:54:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/#\\\/schema\\\/person\\\/f75baafdedeb73cd9ef1d8d87311bbb0\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?p=1143#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB haldus konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Hussein Tahmazov portfolio eng\",\"description\":\"Junior Software Developer\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/#\\\/schema\\\/person\\\/f75baafdedeb73cd9ef1d8d87311bbb0\",\"name\":\"Hussein\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e10dcd9bae99726932e7824a93117d2a279e021c0f4ff3cc2972016580127314?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e10dcd9bae99726932e7824a93117d2a279e021c0f4ff3cc2972016580127314?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e10dcd9bae99726932e7824a93117d2a279e021c0f4ff3cc2972016580127314?s=96&d=mm&r=g\",\"caption\":\"Hussein\"},\"sameAs\":[\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\"],\"url\":\"https:\\\/\\\/khusseintakhmazov24.thkit.ee\\\/wp\\\/eng\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB haldus konspekt - Hussein Tahmazov portfolio eng","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:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143","og_locale":"en_GB","og_type":"article","og_title":"AB haldus konspekt - Hussein Tahmazov portfolio eng","og_description":"DBA kaks peamist eesm\u00e4rki (\u00fclesanded):1. kasutajate toetus ja ligip\u00e4\u00e4su jagamine ja seadistamine2. AB turvalisus ja j\u00f5udluse tagamine AB turvalisus - 3 p\u00f5hiaspekti:*andmete konfidentsiaalsus (confidentiality)GRANT role to user [identified by pwd] [with grant option];REVOKE role from user;*andmete k\u00e4ttesaadavus (availability)- \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c - andmed me samme k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal*andmete terviklikkus(integrity) - \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c - usaldusv\u00e4\u00e4rne andmeallikad […]","og_url":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143","og_site_name":"Hussein Tahmazov portfolio eng","article_published_time":"2025-10-16T08:54:21+00:00","author":"Hussein","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hussein","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143#article","isPartOf":{"@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143"},"author":{"name":"Hussein","@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/#\/schema\/person\/f75baafdedeb73cd9ef1d8d87311bbb0"},"headline":"AB haldus konspekt","datePublished":"2025-10-16T08:54:21+00:00","mainEntityOfPage":{"@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143"},"wordCount":35,"commentCount":0,"articleSection":["M\u00e4\u00e4ratlemata"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143#respond"]}]},{"@type":"WebPage","@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143","url":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143","name":"AB haldus konspekt - Hussein Tahmazov portfolio eng","isPartOf":{"@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/#website"},"datePublished":"2025-10-16T08:54:21+00:00","author":{"@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/#\/schema\/person\/f75baafdedeb73cd9ef1d8d87311bbb0"},"breadcrumb":{"@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?p=1143#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng"},{"@type":"ListItem","position":2,"name":"AB haldus konspekt"}]},{"@type":"WebSite","@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/","name":"Hussein Tahmazov portfolio eng","description":"Junior Software Developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/#\/schema\/person\/f75baafdedeb73cd9ef1d8d87311bbb0","name":"Hussein","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/e10dcd9bae99726932e7824a93117d2a279e021c0f4ff3cc2972016580127314?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e10dcd9bae99726932e7824a93117d2a279e021c0f4ff3cc2972016580127314?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e10dcd9bae99726932e7824a93117d2a279e021c0f4ff3cc2972016580127314?s=96&d=mm&r=g","caption":"Hussein"},"sameAs":["https:\/\/khusseintakhmazov24.thkit.ee\/wp"],"url":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/?author=1"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/posts\/1143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1143"}],"version-history":[{"count":0,"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/posts\/1143\/revisions"}],"wp:attachment":[{"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/khusseintakhmazov24.thkit.ee\/wp\/eng\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}