Warning: foreach() argument must be of type array|object, false given in /data01/virt140703/domeenid/www.mareklukk24.thkit.ee/htdocs/wp/wp-content/plugins/real3d-flipbook-lite/includes/Real3DFlipbook.php on line 1635
{"id":1044,"date":"2025-10-13T08:15:36","date_gmt":"2025-10-13T06:15:36","guid":{"rendered":"https:\/\/mareklukk24.thkit.ee\/wp\/?page_id=1044"},"modified":"2025-10-13T08:15:36","modified_gmt":"2025-10-13T06:15:36","slug":"ab-halduse-konspekt","status":"publish","type":"page","link":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/","title":{"rendered":"AB halduse konspekt"},"content":{"rendered":"\n
\n\n\n\n

AB kasutajate rollid:<\/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> — tagab, et \u00f5iged kasutajad saavad oma \u00f5igused
-AB projekteerija<\/strong> — loob tabeleid ja AB struktuuri<\/p>\n\n\n\n

\n\n\n\n

DBA — AB administraator liigid:<\/strong>
*s\u00fcsteemiadmin
*AB arhitektor
*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)<\/p>\n\n\n\n

\n\n\n\n

DBA kaks peamist eesm\u00e4rki(\u00fclesanded):<\/strong>
1.<\/strong> kasutajate toetus ja liigip\u00e4\u00e4su jagamine ja seadistamine.
2.<\/strong> AB turvalisus ja j\u00f5udluse tagamine<\/p>\n\n\n\n

\n\n\n\n

AB turvalisus — kolm p\u00f5hiaspekti:<\/strong>
*konfidentsialsus(confidentiality)<\/strong> — \u043a\u043e\u043d\u0444\u0435\u0434\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c

-GRANT role to user [identified by pwd] [with grant option];
-REVOKE role from user;

*andmete k\u00e4ttesaadavus(availability)<\/strong> — \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c <\/strong>— andmed me saame k\u00e4tte \u00f5igel ajal ja \u00f5igel kasutajal
*tervilikkus(integrity)<\/strong> — \u0446\u0435\u043b\u043e\u0441\u043d\u043e\u0441\u0442\u044c<\/strong> — usaldusv\u00e4\u00e4rne andmeallikad<\/p>\n\n\n\n

\n\n\n\n
Risk<\/td>Ohutuse aspekt<\/td><\/tr>
Inimlikud vead<\/td>konfedentsiaalsus, k\u00e4ttesaadavus, tervilikkus<\/td><\/tr>
F\u00fc\u00fcsilised vead(riistvara-\u0436\u0435\u043b\u0435\u0437\u043e \u043f\u043a)<\/td>k\u00e4ttesaadavus, tervilikkus<\/td><\/tr>
operatsioonis\u00fcsteemi rikked<\/td>k\u00e4ttesaadavus, tervilikkus, konfedentsiaalsus<\/td><\/tr>
andmebaasis\u00fcsteemi rikked<\/td>k\u00e4ttesaadavus, tervilikkus, konfedentsiaalsus<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

COMMIT<\/strong> \u2013 kinnitab muudatused andmebaasis (salvestab need j\u00e4\u00e4davalt).
ROLLBACK<\/strong> \u2013 t\u00fchistab viimased muudatused ja taastab andmebaasi eelmisse olekusse.
ROLLFORWARD <\/strong>\u2013 taastab andmebaasi p\u00e4rast t\u00f5rget, rakendades salvestatud logifaile uuesti, et viia andmed viimasesse \u00f5igesse olekusse.<\/p>\n\n\n\n

\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 peidetud mustrite otsimine \u2013 on meetod, millega anal\u00fc\u00fcsitakse suuri andmehulkasid, et leida seoseid ja trende, mida tavalisel vaatamisel ei m\u00e4rka.
Data Warehouse \u2013\u0425\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 — andmeladu<\/strong> \u2013 on suur andmeladu, kuhu kogutakse ja hoitakse suuri andmehulkasid erinevatest allikatest, et neid hiljem anal\u00fc\u00fcsida ja teha otsuseid.<\/p>\n\n\n\n

\n\n\n\n

GROUP by — <\/strong>See on SQL-i k\u00e4sk, mis grupeerib read kindlaksm\u00e4\u00e4ratud veergude j\u00e4rgi ja v\u00f5imaldab teostada agregatsioonitoiminguid (n\u00e4iteks summade, keskmiste v\u00e4\u00e4rtuste arvutamine) iga grupi jaoks.
UNION ALL —<\/strong> See on SQL-i k\u00e4sk, mis \u00fchendab mitu p\u00e4ringut \u00fcheks tabeliks, sisaldades k\u00f5iki ridu, isegi kui need on duplikaadid.
GROUPING — <\/strong>See funktsioon aitab m\u00f5ista, kas veerg on osa l\u00f5ppsummast, n\u00e4iteks p\u00e4ringutes, kus kasutatakse ROLLUP<\/code> v\u00f5i CUBE<\/code>. See tagastab 1, kui veerg on kokkuv\u00f5ttes, ja 0, kui ei ole.
ROLLUP- <\/strong>
Erinevus ROLLUP ja CUBE — ROLLUP<\/strong> summeerib hierarhiliselt valitud veergud, CUBE <\/strong>arvutab summad igas veerus\/kombinatsioonis<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

AB kasutajate rollid:— AB kasutaja — tavakasutaja mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele-AB programmeerija — loob funktsioonid ja protseduurid(trigerid)-DBA(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-1044","page","type-page","status-publish","hentry"],"yoast_head":"\nAB halduse konspekt - Marek Lukk portfolio | rus<\/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:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB halduse konspekt - Marek Lukk portfolio | rus\" \/>\n<meta property=\"og:description\" content=\"AB kasutajate rollid:— AB kasutaja — tavakasutaja mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele-AB programmeerija — loob funktsioonid ja protseduurid(trigerid)-DBA(AB […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/\" \/>\n<meta property=\"og:site_name\" content=\"Marek Lukk portfolio | rus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 \u043c\u0438\u043d\u0443\u0442\u044b\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/ab-halduse-konspekt\\\/\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/ab-halduse-konspekt\\\/\",\"name\":\"AB halduse konspekt - Marek Lukk portfolio | rus\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/#website\"},\"datePublished\":\"2025-10-13T06:15:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/ab-halduse-konspekt\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/ab-halduse-konspekt\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/ab-halduse-konspekt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB halduse konspekt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/#website\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/\",\"name\":\"Marek Lukk portfolio | rus\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB halduse konspekt - Marek Lukk portfolio | rus","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:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/","og_locale":"ru_RU","og_type":"article","og_title":"AB halduse konspekt - Marek Lukk portfolio | rus","og_description":"AB kasutajate rollid:— AB kasutaja — tavakasutaja mis saab muuta, lisada, filtreerida ja otsida vastavalt vajadusele-AB programmeerija — loob funktsioonid ja protseduurid(trigerid)-DBA(AB […]","og_url":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/","og_site_name":"Marek Lukk portfolio | rus","twitter_card":"summary_large_image","twitter_misc":{"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"2 \u043c\u0438\u043d\u0443\u0442\u044b"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/","url":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/","name":"AB halduse konspekt - Marek Lukk portfolio | rus","isPartOf":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/#website"},"datePublished":"2025-10-13T06:15:36+00:00","breadcrumb":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/ab-halduse-konspekt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/"},{"@type":"ListItem","position":2,"name":"AB halduse konspekt"}]},{"@type":"WebSite","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/#website","url":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/","name":"Marek Lukk portfolio | rus","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"}]}},"_links":{"self":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/1044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/comments?post=1044"}],"version-history":[{"count":0,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/1044\/revisions"}],"wp:attachment":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/media?parent=1044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}