{"id":74,"date":"2022-11-30T10:33:41","date_gmt":"2022-11-30T10:33:41","guid":{"rendered":"https:\/\/gis.tuzvo.sk\/agp\/?page_id=74"},"modified":"2023-05-22T15:11:05","modified_gmt":"2023-05-22T14:11:05","slug":"geograficke-databazy","status":"publish","type":"page","link":"https:\/\/gis.tuzvo.sk\/?page_id=74","title":{"rendered":"Geografick\u00e9 datab\u00e1zy"},"content":{"rendered":"\n<p>V r\u00e1mci predmetu sa \u0161tudenti nau\u010dia princ\u00edpy fungovania a prev\u00e1dzky datab\u00e1zov\u00fdch syst\u00e9mov, teoretick\u00e9 z\u00e1klady rela\u010dn\u00fdch datab\u00e1z, z\u00edskaj\u00fa z\u00e1kladn\u00e9 zru\u010dnosti s pr\u00e1cou s datab\u00e1zov\u00fdm syst\u00e9mom a spracovan\u00edm \u00fadajov, nau\u010dia sa vytv\u00e1ra\u0165 datab\u00e1zov\u00e9 sch\u00e9my a pou\u017e\u00edva\u0165 z\u00e1kladn\u00e9 pr\u00edkazy jazyka SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Obsah_predn_ok\">Obsah&nbsp;predn\u00e1\u0161ok<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignright size-large\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2022\/11\/comp7.png\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><em><strong>\u00davod do datab\u00e1zov\u00fdch syst\u00e9mov.<\/strong><\/em> \u00dadaje a inform\u00e1cie. Informa\u010dn\u00fd syst\u00e9m. Viacvrstvov\u00e1 architekt\u00fara. Datab\u00e1zov\u00e9 syst\u00e9my a ich aplik\u00e1cie. Legislat\u00edva a \u0161tandardiz\u00e1cia.<\/li>\n\n\n\n<li><em><strong>Datab\u00e1zov\u00e9 syst\u00e9my.<\/strong><\/em> Hist\u00f3ria. Klasifik\u00e1cia. Funkcie. S\u00faborov\u00e1, hierarchick\u00e1, sie\u0165ov\u00e1, rela\u010dn\u00e1, objektov\u00e1 datab\u00e1za. Hybridn\u00e9 datab\u00e1zy. V\u00fdhody a nev\u00fdhody datab\u00e1zov\u00fdch syst\u00e9mov. Grafick\u00e9 \u00fadaje, priestorov\u00e9 \u00fadaje, geografick\u00e9 \u00fadaje, opisn\u00e9 \u00fadaje.<\/li>\n\n\n\n<li><em><strong>Rela\u010dn\u00fd datab\u00e1zov\u00fd syst\u00e9m.<\/strong><\/em> Rela\u010dn\u00e1 datab\u00e1za. Tabu\u013eky, polia. Norm\u00e1lne formy. K\u013e\u00fa\u010de. Datab\u00e1zov\u00e1 sch\u00e9ma. Rela\u010dn\u00e9 modelovanie. Entitno-rela\u010dn\u00e9 diagramy.<\/li>\n\n\n\n<li><em><strong>Rela\u010dn\u00e1 algebra a rela\u010dn\u00fd kalkul.<\/strong><\/em> SQL Rela\u010dn\u00e1 algebra. Jazyk SQL. Pr\u00edkazy CREATE, INSERT, DELETE, UPDATE.<\/li>\n\n\n\n<li><em><strong>SQL SELECT.<\/strong><\/em> Pr\u00edkaz SELECT. Klauzuly WHERE, ORDER, GROUP. Zabudovan\u00e9 funkcie pre spracovanie textov\u00fdch a numerick\u00fdch pol\u00ed. Agrega\u010dn\u00e9 funkcie.<\/li>\n\n\n\n<li><em><strong>Indexovanie a vyh\u013ead\u00e1vanie.<\/strong><\/em> Princ\u00edpy indexovania. B-stromy. Vyv\u00e1\u017een\u00e9 B-stromy. Quadtree. Data-mining.<\/li>\n\n\n\n<li><em><strong>Rel\u00e1cie.<\/strong><\/em> Prepojenie \u00fadajov. Rel\u00e1cie (1-1, 1-m, n-m). Kontrola a oprava ch\u00fdb prepojenia. Integritn\u00e9 obmedzenia.<\/li>\n\n\n\n<li><em><strong>Objektovo-orientovan\u00e9 datab\u00e1zy.<\/strong><\/em> Princ\u00edpy objekto-orientovan\u00e9ho pr\u00edstupu: enkapsul\u00e1cia, dedenie, polymorfizmus. Jednoduch\u00e9 a viacn\u00e1sobn\u00e9 dedenie. Dynamick\u00e9 a statick\u00e9 dedenie. Univerz\u00e1lny a ad-hoc polymorfizmus. Objektovo-orientovan\u00e9 modelovanie.<\/li>\n\n\n\n<li><em><strong>Geografick\u00e1 datab\u00e1za.<\/strong><\/em> Ukladanie geografick\u00fdch \u00fadajov v datab\u00e1zach. Priestorov\u00e9 indexovanie. Roz\u0161\u00edrenia geografick\u00fdch datab\u00e1z. Dostupn\u00e9 syst\u00e9my pre spr\u00e1vu geografick\u00fdch \u00fadajov. Integr\u00e1cia GIS a DBMS.<\/li>\n\n\n\n<li><em><strong>Spracovanie datab\u00e1zov\u00fdch \u00fadajov a metainforma\u010dn\u00e9 syst\u00e9my.<\/strong><\/em> Aktualiz\u00e1cia \u00fadajov. Import\/export. Konverzia \u00fadajov \u2013 klasifik\u00e1cia, probl\u00e9my, postupy. Metainforma\u010dn\u00e9 syst\u00e9my. \u0160tandardiz\u00e1cia.<\/li>\n\n\n\n<li><em><strong>Prev\u00e1dzka datab\u00e1zov\u00e9ho syst\u00e9mu.<\/strong><\/em> Architekt\u00fara datab\u00e1zov\u00e9ho syst\u00e9mu. Spr\u00e1va datab\u00e1zov\u00e9ho syst\u00e9mu. Bezpe\u010dnos\u0165 a ochrana \u00fadajov. Z\u00e1lohovanie a obnova syst\u00e9mu.<\/li>\n\n\n\n<li><em><strong>Projekty informa\u010dn\u00fdch syst\u00e9mov.<\/strong><\/em> Podnikov\u00fd informa\u010dn\u00fd syst\u00e9m. Projekt informa\u010dn\u00e9ho syst\u00e9mu. Metodiky riadenia projektu informa\u010dn\u00e9ho syst\u00e9mu. Legislat\u00edva.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Odpor_an_literat_ra\">Odpor\u00fa\u010dan\u00e1&nbsp;literat\u00fara<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignright size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"128\" height=\"128\" src=\"https:\/\/gis.tuzvo.sk\/wp-content\/uploads\/2022\/11\/edu1.png\" alt=\"\" class=\"wp-image-80\"\/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Kore\u0148, M. (2009). Datab\u00e1zov\u00e9 syst\u00e9my. Vydala Technick\u00e1 univerzita vo Zvolene, ISBN 978-80-228-2084-4, 90 str.<\/li>\n\n\n\n<li>Mager I. (2001). Jak na po\u010d\u00edta\u010d Datab\u00e1ze v programu Access. Computer Press, Praha, 88 str.<\/li>\n\n\n\n<li>Rigaux Ph., Scholl M., Voisard A. (2002). Spatial Databases with applications to GIS. Morgan Kaufmann Publishers, San Francisco, 410 str.<\/li>\n\n\n\n<li>Riordan R. M. (2000). Vytv\u00e1\u0159\u00edme rela\u010dn\u00ed datab\u00e1zov\u00e9 aplikace. Computer Press, Praha, 294 str.<\/li>\n\n\n\n<li>Roman S. (2001). Microsoft Access N\u00e1vrh a programov\u00e1n\u00ed datab\u00e1z\u00ed. Computer Press, Praha, 270 str.<\/li>\n\n\n\n<li>Scheber, A. (1988). Datab\u00e1zov\u00e9 syst\u00e9my. Alfa\/SNTL, Bratislava.<\/li>\n\n\n\n<li>Tu\u010dek, J. (1998). Geografick\u00e9 informa\u010dn\u00ed syst\u00e9my \u2013 principy a praxe, Computer Press Praha, 1998, 424 s.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Sk_ka\">Sk\u00fa\u0161ka<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"128\" height=\"128\" src=\"https:\/\/gis.tuzvo.sk\/wp-content\/uploads\/2022\/11\/edu2.png\" alt=\"\" class=\"wp-image-81\"\/><\/figure>\n<\/div>\n\n\n<p>Sk\u00fa\u0161ka sa rob\u00ed \u00fastnou alebo p\u00edsomnou formou. \u0160tudent odpoved\u00e1 na 2 ot\u00e1zky vybrat\u00e9 n\u00e1hodne z pripraven\u00fdch zoznamov. Prv\u00e1 ot\u00e1zka je vyrie\u0161enie \u0161kolsk\u00e9ho pr\u00edkladu. Druh\u00e1 ot\u00e1zka je teoretick\u00e1.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Na_stiahnutie\">Na&nbsp;stiahnutie<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"\/wp-content\/uploads\/2023\/05\/gdb_priklady_vzor.pdf\" data-type=\"attachment\">Vzorov\u00e9 pr\u00edklady<\/a><\/li>\n\n\n\n<li><a href=\"\/wp-content\/uploads\/2023\/05\/gdb_otazky.pdf\" data-type=\"attachment\">Ot\u00e1zky na sk\u00fa\u0161ku<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V r\u00e1mci predmetu sa \u0161tudenti nau\u010dia princ\u00edpy fungovania a prev\u00e1dzky datab\u00e1zov\u00fdch syst\u00e9mov, teoretick\u00e9 z\u00e1klady rela\u010dn\u00fdch datab\u00e1z, z\u00edskaj\u00fa z\u00e1kladn\u00e9 zru\u010dnosti s pr\u00e1cou s datab\u00e1zov\u00fdm syst\u00e9mom a spracovan\u00edm \u00fadajov, nau\u010dia sa vytv\u00e1ra\u0165 datab\u00e1zov\u00e9 sch\u00e9my a pou\u017e\u00edva\u0165 z\u00e1kladn\u00e9 pr\u00edkazy jazyka SQL. Obsah&nbsp;predn\u00e1\u0161ok Odpor\u00fa\u010dan\u00e1&nbsp;literat\u00fara Sk\u00fa\u0161ka Sk\u00fa\u0161ka sa rob\u00ed \u00fastnou alebo p\u00edsomnou formou. \u0160tudent odpoved\u00e1 na 2 ot\u00e1zky vybrat\u00e9 n\u00e1hodne &hellip; <\/p>\n<div class=\"link-more\"><a href=\"https:\/\/gis.tuzvo.sk\/?page_id=74\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &#8220;Geografick\u00e9 datab\u00e1zy&#8221;<\/span><\/a><\/div>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-74","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=\/wp\/v2\/pages\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74"}],"version-history":[{"count":5,"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=\/wp\/v2\/pages\/74\/revisions"}],"predecessor-version":[{"id":1193,"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=\/wp\/v2\/pages\/74\/revisions\/1193"}],"wp:attachment":[{"href":"https:\/\/gis.tuzvo.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}