{"id":1427,"date":"2025-10-13T06:15:40","date_gmt":"2025-10-13T06:15:40","guid":{"rendered":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?page_id=1427"},"modified":"2025-10-20T06:05:23","modified_gmt":"2025-10-20T06:05:23","slug":"ab-halduse-konspekt","status":"publish","type":"page","link":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/","title":{"rendered":"AB halduse konspekt"},"content":{"rendered":"\n

AB halduse konspekt
<\/h2>\n\n\n\n
AB kasutajate rollid:<\/kbd><\/mark><\/strong>
- AB kasutaja<\/strong> - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele
- AB programmeerija<\/strong> - loob funktsioonid ja protseduurid (trigerid)
- DBA - AB administraator<\/strong> <\/em>- tagab, et kasutajad saavad oma \u00f5igused
- AB projekteerija<\/strong> - loob tabeleid ja AB struktuuri
<\/pre>\n\n\n\n
DBA - AB administraator liigid:<\/strong>
*s\u00fcsteemiadmin
*AB arhitekt
*AB anal\u00fc\u00fctik
*Data warehouse admin - \u0430\u0434\u043c\u0438\u043d \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (andmeladu admin)
<\/pre>\n\n\n\n
DBA kaks peamist eesm\u00e4rki (\u00fclesanded):<\/strong>
1. kasutaja 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(confidentiality)<\/strong>
            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<\/strong>
   - andmed me saame k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal
 
* andmete terviklikkus (integrity) - \u0446\u0435\u043b\u043e\u0441\u043d\u043e\u0441\u0442\u044c<\/strong>
   - usaldusv\u00e4\u00e4rne andmeallikad
<\/strong><\/pre>\n\n\n\n
Risk<\/strong><\/td>Ohutuse aspekt<\/strong><\/td><\/tr>
Inimlikud vead<\/td>konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus<\/em><\/td><\/tr>
F\u00fc\u00fcsilised vead (riistvara)<\/td>k\u00e4ttesaadavus, terviklikkus<\/em><\/td><\/tr>
Operatsioonis\u00fcsteemi rikked<\/td>k\u00e4ttesaadavus, terviklikkus<\/em>, konfidentsiaalsus<\/em><\/td><\/tr>
Andmebaasis\u00fcsteemi rikked<\/td>konfidentsiaalsus, k\u00e4ttesaadavus, terviklikkus<\/em><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/p>\n\n\n\n
- COMMIT <\/strong>- muutuste salvestamine, mis muutuvad p\u00fcsivaks(\u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0441\u0442\u0430\u043d\u043e\u0432\u044f\u0442\u0441\u044f \u043f\u043e\u0441\u0442\u043e\u044f\u043d\u043d\u044b\u043c\u0438)
- ROLLBACK <\/strong>- muutuste t\u00fchistamine(\u043e\u0442\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439)
- ROLLFORWARD <\/strong>- andmebaasi taastamine(\u0432\u043e\u0441c\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445)
<\/pre>\n\n\n\n
Data Mining \u2013 \u043f\u043e\u0438\u0441\u043a \u0441\u043a\u0440\u044b\u0442\u044b\u0445 \u0448\u0430\u0431\u043b\u043e\u043d\u043e\u0432 <\/strong>
\u2013 meetod peidetud mustrite, seadusp\u00e4rasuste ja kasuliku teabe leidmiseks suurtes andmemahtudes
Data Warehouse \u2013 \u0425\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/strong> 
- s\u00fcsteem andmete kogumiseks, t\u00f6\u00f6tlemiseks ja salvestamiseks erinevatest allikatest
<\/pre>\n\n\n\n
    \n
  • GROUP by<\/strong> – r\u00fchmitab ridad, millel on samad v\u00e4\u00e4rtused<\/li>\n<\/ul>\n\n\n
    \nselect City, Gender, SUM(Salary) as TotalSalary\nfrom tblEmployee\ngroup by City, Gender\n\n<\/pre><\/div>\n\n\n
      \n
    • UNION ALL<\/strong> – kasutatakse kahe v\u00f5i enama SELECT-operaatori tulemuste \u00fchendamiseks<\/li>\n<\/ul>\n\n\n
      \nselect City, Gender, SUM(Salary) as TotalSalary\nFrom tblEmployee\ngroup by City, Gender\nUnion all \nSelect City, Null, SUM(Salary) as TotalSalary\nFrom tblEmployee\ngroup by City\n\n<\/pre><\/div>\n\n\n
        \n
      • GROUPING<\/strong> – r\u00fchmab samade v\u00e4\u00e4rtustega read m\u00e4\u00e4ratud veergudes<\/li>\n<\/ul>\n\n\n
        \nselect City, Gender, SUM(Salary) TotalSalary\nfrom tblEmployee\nGroup by\nGROUPING sets(\n(City, Gender),\n(City),\n(Gender),\n())\n\n<\/pre><\/div>\n\n\n
          \n
        • ROLLUP<\/strong> – grupib mitte ainult veerge, vaid kogu tabeli<\/li>\n<\/ul>\n\n\n
          \nSelect City, SUM(Salary) as TotalSalary\nfrom tblEmployee\nGroup By Rollup(City)\n\n<\/pre><\/div>\n\n\n
            \n
          • CUBE<\/strong> – teeb k\u00f5ik v\u00f5imalikud kombinatsioonid r\u00fchmade kaupa vastavalt m\u00e4rgitud veergudele<\/li>\n<\/ul>\n\n\n
            \nselect City, Gender, SUM(Salary) as TotalSalary\nfrom tblEmployee\ngroup by cube(City, Gender)\n\n--or\n\nselect City, Gender, SUM(Salary) as TotalSalary\nfrom tblEmployee\ngroup by City, Gender with Cube\n\n<\/pre><\/div>\n\n\n
              \n
            • Erinevus ROLLUP ja CUBE<\/strong> – ROLLUP summeerib hierarhiliselt valitud veerud, CUBE arvutab summad  igas veerus\/kombinatsioonis<\/li>\n<\/ul>\n\n\n\n
              <\/p>\n","protected":false},"excerpt":{"rendered":"
              AB halduse konspekt AB kasutajate rollid:- AB kasutaja – tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele- AB […]<\/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-1427","page","type-page","status-publish","hentry"],"yoast_head":"\nAB halduse konspekt - Oleksandra Ryshniak Portfolio<\/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:\/\/oleksandraryshniak24.thkit.ee\/wp1\/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 - Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"og:description\" content=\"AB halduse konspekt AB kasutajate rollid:- AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele- AB […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:site_name\" content=\"Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-20T06:05:23+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:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/ab-halduse-konspekt\\\/\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/ab-halduse-konspekt\\\/\",\"name\":\"AB halduse konspekt - Oleksandra Ryshniak Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\"},\"datePublished\":\"2025-10-13T06:15:40+00:00\",\"dateModified\":\"2025-10-20T06:05:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/ab-halduse-konspekt\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/ab-halduse-konspekt\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/ab-halduse-konspekt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB halduse konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\",\"name\":\"Oleksandra Ryshniak Portfolio\",\"description\":\"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/?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 - Oleksandra Ryshniak Portfolio","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:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/","og_locale":"et_EE","og_type":"article","og_title":"AB halduse konspekt - Oleksandra Ryshniak Portfolio","og_description":"AB halduse konspekt AB kasutajate rollid:- AB kasutaja - tavakasutaja, mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele- AB […]","og_url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/","og_site_name":"Oleksandra Ryshniak Portfolio","article_modified_time":"2025-10-20T06:05:23+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/","name":"AB halduse konspekt - Oleksandra Ryshniak Portfolio","isPartOf":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website"},"datePublished":"2025-10-13T06:15:40+00:00","dateModified":"2025-10-20T06:05:23+00:00","breadcrumb":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/ab-halduse-konspekt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/"},{"@type":"ListItem","position":2,"name":"AB halduse konspekt"}]},{"@type":"WebSite","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/","name":"Oleksandra Ryshniak Portfolio","description":"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/comments?post=1427"}],"version-history":[{"count":11,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1427\/revisions"}],"predecessor-version":[{"id":1526,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1427\/revisions\/1526"}],"wp:attachment":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/media?parent=1427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}