{"id":697,"date":"2025-10-13T08:42:48","date_gmt":"2025-10-13T06:42:48","guid":{"rendered":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/?page_id=697"},"modified":"2025-10-13T08:42:48","modified_gmt":"2025-10-13T06:42:48","slug":"ab-halduse-konspekt","status":"publish","type":"page","link":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/","title":{"rendered":"AB halduse konspekt"},"content":{"rendered":"\n
AB kasutajate rollid:

AB kasutaja - tavakasutaja, mis muuta, lisa,filtreerida ja otseda vastavalt vajadusele

AB programmeerija - loob funktsioonid, protseduurid, triggerid

DBA - andmebaasi administraator - tagab, et oiged kasutajad saavad oma oigused

AB projekteerija - loob tabelid ja AB struktuuri<\/pre>\n\n\n\n

DBA - AB administraator liigid:
*s\u00fcsteemiadmin
*AB arhitekt
*AB anal\u00fc\u00fctik
*Data warehouse admin<\/strong> - \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (andmeladu)
<\/pre>\n\n\n\n
DBA kaks peamist eesmarki:
1. kasutajate  toetus ja liigip\u00e4\u00e4su jagamine ja seadistamine.
2. AB turvalisus ja joudluse tagamine<\/pre>\n\n\n\n
AB turvalisus - 3 pohiaspekti:
*konfidentsiaalsus <\/strong>(confidentiality)

GRANT role to user [identified by pwd] [with grant option];
REVOKE role from user;<\/em><\/strong>

*k\u00e4ttesaadavus <\/strong>(availability) - andmed me saame katte oigel ajal ja oigel kasutaja<\/em>l<\/strong>

*terviklikkus <\/strong>(integrity) - usaldusv\u00e4\u00e4rne andmeallikad<\/pre>\n\n\n\n
Risk<\/strong><\/td>Ohustuse aspekt<\/strong><\/td><\/tr>
Inimlikud vead<\/td>konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus<\/em><\/td><\/tr>
F\u00fc\u00fcsilised vead (tarkvara)<\/td>k\u00e4ttesaadavus, terviklikkus<\/em> <\/td><\/tr>
Operatsioonisusteemi rikked<\/td>konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus<\/em><\/td><\/tr>
AB rikked<\/td>konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus<\/em><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
COMMIT<\/strong> - L\u00f5petab tehingu ja salvestab k\u00f5ik muudatused andmebaasis.
(Muudatusi ei saa enam tagasi v\u00f5tta)<\/em>

ROLLBACK<\/strong>- T\u00fchistab k\u00f5ik muudatused,tehtud tehingu jooksulja tagastab andmebaasi eelmisesse seisundisse enne kui on tehtud 
commit<\/strong>. 
(Kasutatakse vigade korral v\u00f5i kui soovitakse muudatused tagasi v\u00f5tta)
<\/em>
ROLLFORWARD<\/strong>- Andmete taastamise meetod p\u00e4rast s\u00fcsteemiviga, et taastada andmed p\u00e4rast varukoopia taastamist.
(Kasutatakse s\u00fcsteemiadministraatorite poolt)<\/em>
<\/pre>\n\n\n\n
Data Mining<\/strong> - Andmete anal\u00fc\u00fcsimise meetod, mille eesm\u00e4rk on leida varjatud mustreid ja seoseid.
(Kasutab statistikat ja anal\u00fc\u00fctikat)<\/em>
<\/pre>\n\n\n\n
Data Warehouse<\/strong> \u2013\u0425\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 - Suur andmeladu kuhu kogutakse suured andmehulgad erinevatest allikatest. 
(Hoiab andmeid)<\/em>
<\/pre>\n\n\n\n
Group By- pannakse sarnased asjad kokku (r\u00fchmitada sarnased andmeread kokku)<\/p>\n\n\n\n
N\u00e4ide: <\/p>\n\n\n
\nselect country, gender, sum(salary) as totalsalary\nfrom employees\ngroup by country, gender\n\n<\/pre><\/div>\n\n\n
UNION ALL – liidab andmed kokku, aga ei eemalda korduvaid ridu<\/p>\n\n\n\n
N\u00e4ide:<\/p>\n\n\n
\nselect country, null, sum(salary) as totalsalary\nfrom employees\ngroup by country\n\nunion all\n\nselect null, gender, sum(salary) as totalsalary\nfrom employees\ngroup by gender\n\nunion all\n\n<\/pre><\/div>\n\n\n
GROUPING – aitab teada saada, kas mingi r\u00fchm on olemas, kui tegemist on r\u00fchmitatud kokkuv\u00f5ttega (kasutatakse koos GROUP BY<\/strong> k\u00e4suga, et kontrollida, kas veerg on grupitulemuses kohal v\u00f5i mitte)<\/p>\n\n\n\n
N\u00e4ide:<\/p>\n\n\n
\nselect country, gender, sum(salary) as totalsalary\nfrom employees\ngroup by \nGROUPING 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
ROLLUP – SQL serveris kokkuarvutatav operaator. aitab teha kogu kokkuv\u00f5tte<\/strong>, mitte ainult \u00fcksikute r\u00fchmade kohta.<\/p>\n\n\n\n
N\u00e4ide:<\/p>\n\n\n
\nselect country, sum(salary) as TotalSalary\nfrom employees\n\ngroup by rollup(country)\n\n<\/pre><\/div>\n\n\n
CUBE – sql serveris loob olukorra, kus genereeritakse k\u00f5ik kombinatsioonid t\u00e4psustatud veerus GROUP BY CUBE(). aitab saada k\u00f5ikide v\u00f5imalikud kokkuv\u00f5tted<\/strong> k\u00f5ikidest r\u00fchmadest.<\/p>\n\n\n\n
N\u00e4ide:<\/p>\n\n\n
\nselect country, gender, sum(salary) as totalSalary\nfrom employees\ngroup by cube (country, gender)\n\n\n--voi\n\nselect country, gender, sum(salary) as totalSalary\nfrom employees\ngroup by country, gender with cube \n\n<\/pre><\/div>\n\n\n
Nende erinevused:<\/p>\n\n\n\n
ROLLUP<\/strong><\/td>CUBE<\/strong><\/td><\/tr>
Summerib hierarhiliselt valitud veerud<\/td>Arvutab summad igas veerus<\/td><\/tr>
Loob kokkuv\u00f5tteid ainult \u00fches suunas<\/strong><\/td>Loob k\u00f5ikide v\u00f5imalikud kombinatsioonide kokkuv\u00f5tted<\/strong>.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
AB kasutajate rollid:AB kasutaja – tavakasutaja, mis muuta, lisa,filtreerida ja otseda vastavalt vajaduseleAB programmeerija – loob funktsioonid, protseduurid, triggeridDBA – andmebaasi administraator – tagab, et oiged kasutajad saavad oma oigusedAB projekteerija – loob tabelid ja AB struktuuri DBA – AB administraator liigid:*s\u00fcsteemiadmin*AB arhitekt*AB anal\u00fc\u00fctik*Data warehouse admin – \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (andmeladu) DBA kaks peamist eesmarki:1. kasutajate […]<\/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-697","page","type-page","status-publish","hentry"],"yoast_head":"\nAB halduse konspekt - Adriana Pikaljov 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:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB halduse konspekt - Adriana Pikaljov Portfolio ||| ENG\" \/>\n<meta property=\"og:description\" content=\"AB kasutajate rollid:AB kasutaja - tavakasutaja, mis muuta, lisa,filtreerida ja otseda vastavalt vajaduseleAB programmeerija - loob funktsioonid, protseduurid, triggeridDBA - andmebaasi administraator - tagab, et oiged kasutajad saavad oma oigusedAB projekteerija - loob tabelid ja AB struktuuri DBA - AB administraator liigid:*s\u00fcsteemiadmin*AB arhitekt*AB anal\u00fc\u00fctik*Data warehouse admin - \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (andmeladu) DBA kaks peamist eesmarki:1. kasutajate […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:site_name\" content=\"Adriana Pikaljov Portfolio ||| ENG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/ab-halduse-konspekt\\\/\",\"url\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/ab-halduse-konspekt\\\/\",\"name\":\"AB halduse konspekt - Adriana Pikaljov Portfolio ||| ENG\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"datePublished\":\"2025-10-13T06:42:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/ab-halduse-konspekt\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/ab-halduse-konspekt\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/ab-halduse-konspekt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB halduse konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Adriana Pikaljov Portfolio ||| ENG\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/adrianapikaljov24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB halduse konspekt - Adriana Pikaljov 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:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/","og_locale":"en_GB","og_type":"article","og_title":"AB halduse konspekt - Adriana Pikaljov Portfolio ||| ENG","og_description":"AB kasutajate rollid:AB kasutaja - tavakasutaja, mis muuta, lisa,filtreerida ja otseda vastavalt vajaduseleAB programmeerija - loob funktsioonid, protseduurid, triggeridDBA - andmebaasi administraator - tagab, et oiged kasutajad saavad oma oigusedAB projekteerija - loob tabelid ja AB struktuuri DBA - AB administraator liigid:*s\u00fcsteemiadmin*AB arhitekt*AB anal\u00fc\u00fctik*Data warehouse admin - \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (andmeladu) DBA kaks peamist eesmarki:1. kasutajate […]","og_url":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/","og_site_name":"Adriana Pikaljov Portfolio ||| ENG","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/","url":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/","name":"AB halduse konspekt - Adriana Pikaljov Portfolio ||| ENG","isPartOf":{"@id":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/#website"},"datePublished":"2025-10-13T06:42:48+00:00","breadcrumb":{"@id":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/ab-halduse-konspekt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"AB halduse konspekt"}]},{"@type":"WebSite","@id":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/","name":"Adriana Pikaljov Portfolio ||| ENG","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=697"}],"version-history":[{"count":0,"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/697\/revisions"}],"wp:attachment":[{"href":"https:\/\/adrianapikaljov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}