{"id":41921,"date":"2017-04-21T00:00:00","date_gmt":"2017-04-20T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/administrirovanie-sql-servera-razrabot"},"modified":"2020-02-18T13:44:41","modified_gmt":"2020-02-18T10:44:41","slug":"administrirovanie-sql-servera-razrabot","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","title":{"rendered":"Administracija SQL stre\u017enika: razvoj, varnost, ustvarjanje BDP","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

SQL Server<\/strong> \u2013 edinstven izdelek, sposoben delovati z ogromnimi koli\u010dinami informacijskih baz, opravlja funkcije programiranja in upravljanja.<\/span><\/p>\n

Upravljanje SQL stre\u017enika vklju\u010duje razvoj informacijskega sistema, ustvarjanje varnostnega sistema, oblikovanje podatkovne zbirke, obiektov ter omogo\u010da uporabnikom dostop do informacij v bazi. <\/span>
\nAdministrator redno ustvarja varnostne kopije, preverja celovitost informacijskega sistema, nadzira dovoljeno velikost informacijskih datotek in dnevnikov transakcij.<\/span><\/p>\n

\u0411\u0414 — \u043f\u043e\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0441\u043e\u0432\u043e\u043a\u0443\u043f\u043d\u043e\u0441\u0442\u044c \u0432\u0437\u0430\u0438\u043c\u043e\u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0441\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0445<\/span><\/strong><\/p>\n

Ta baza se upravlja s posebno platformo, ki predstavlja kompleks jezikov in programskih orodij, ki podpirajo njeno aktualnost in organizirajo hitro iskanje potrebnih informacij. <\/span>
\nStrukturiranje BD<\/span>
\nZa kakovostno organizacijo informacijskega sistema se mora administrator odgovorno lotiti dela, natan\u010dno preu\u010diti \u0161tevilne mo\u017enosti uporabe razpolo\u017eljivih informacij, predvideti mo\u017eno integracijo z drugimi sistemi in dostop ter vklju\u010diti sodobne tehnologije ter uvesti potrebne spremembe v sistem.<\/span><\/p>\n

Upravljanje SQL stre\u017enika<\/a> se izvaja v dveh razli\u010dicah<\/span><\/strong><\/p>\n

Prva \u2013 datote\u010dni stre\u017enik, pri katerem je BD name\u0161\u010dena na datote\u010dnem stre\u017eniku,stre\u017enikom<\/a>, ki omogo\u010da shranjevanje informacijskih baz in dostop do njih za uporabnike, ki delajo na razli\u010dnih ra\u010dunalnikih. Obdelava poteka na delovnih postajah, kamor se prena\u0161ajo datoteke BD. Na osebnih ra\u010dunalnikih strank je name\u0161\u010den upravljalni sistem, ki obdeluje prenesene informacije.<\/span>
\nKlient-stre\u017enik, poleg varnosti, omogo\u010da obdelavo celotne koli\u010dine podatkov. Zahteva, poslana v izvedbo s strani klienta, spro\u017ei iskanje in pridobivanje potrebnih informacij. Po omre\u017eju se prenesejo te informacije od stre\u017enika do klienta.<\/span>
\nKlient-stre\u017enik je sestavljen iz dveh delov: klientskega in stre\u017eni\u0161kega.<\/span>
\nKlientski del je name\u0161\u010den na osebnem ra\u010dunalniku in opravlja funkcije zagotavljanja grafi\u010dnega vmesnika.<\/span>
\nStre\u017eni\u0161ki del se nahaja na dediciranom serveru<\/a> in omogo\u010da delitev informacij, upravljanje z informacijskimi bazami, storitve upravljanja in varnostne ukrepe. <\/span>
\nZa sistem klient-server je zna\u010dilna uporaba posebne jezikovne tehnike, ki strukturira poizvedbe ter zagotavlja u\u010dinkovita orodja za dostop do podatkovne baze.<\/span><\/p>\n

 <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

SQL Server je edinstven izdelek, ki lahko deluje z ogromnim \u0161tevilom informacijskih baz in opravlja funkcije programiranja ter administracije. Administracija SQL stre\u017enika predvideva razvoj sistema informacijske baze, vzpostavitev varnostnega sistema in ustvarjanje baze podatkov ter dostop uporabnikov do informacij, ki so na voljo v bazi.<\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":1016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-41921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Pla\u010dano upravljanje SQL stre\u017enikov s strani na\u0161ih strokovnjakov | ProHoster","description":"SQL Server je edinstven izdelek, ki lahko deluje z ogromnim \u0161tevilom informacijskih baz, opravlja funkcije programiranja in upravljanja.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47 \u041f\u043b\u0430\u0442\u043d\u043e\u0435 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 SQL \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u043d\u0430\u0448\u0438\u043c\u0438 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u0430\u043c\u0438 | ProHoster","og:description":"SQL Server \u2013 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442, \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 \u043e\u0433\u0440\u043e\u043c\u043d\u044b\u043c \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e\u043c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f.","og:url":"https:\/\/prohoster.info\/sl\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2017-04-20T21:00:00+00:00","article:modified_time":"2020-02-18T10:44:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"41921","title":"\ud83e\udd47 \u041f\u043b\u0430\u0442\u043d\u043e\u0435 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 SQL \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u043d\u0430\u0448\u0438\u043c\u0438 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u0430\u043c\u0438 | #site_title","description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-22 15:36:49","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 00:08:31","updated":"2026-02-22 15:36:49","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/41921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=41921"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/41921\/revisions"}],"predecessor-version":[{"id":162054,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/41921\/revisions\/162054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media\/1016"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=41921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=41921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=41921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}