{"id":36470,"date":"2019-10-31T22:11:48","date_gmt":"2019-10-31T19:11:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/udobnaya-sistema-upravleniya-bazami-dannyh\/"},"modified":"2019-10-31T22:11:48","modified_gmt":"2019-10-31T19:11:48","slug":"udobnaya-sistema-upravleniya-bazami-dannyh","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","title":{"rendered":"Mugav andmebaasiraha haldamise s\u00fcsteem","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Soovin jagada kogemusi andmebaasis\u00fcsteemide arengust GLASHA keelekursustes.<\/p>\n

Kool loodi 2012. aastal ja alguses \u00f5ppis seal 12 \u00f5pilast, mist\u00f5ttu ei olnud probleemideks tunniplaani ja maksete haldamine. Kuid koos kasvu, arengu ja uute \u00f5pilaste saabumisega t\u00f5usis terav k\u00fcsimus andmebaasis\u00fcsteemi valikust.<\/p>\n

\u00dclesanne seisnes:
\n<\/a><\/noindex> <\/p>\n

    \n
  1. kliendi (\u00f5pilaste) register, mis salvestab nende t\u00e4ielikud nimed, ajav\u00f6\u00f6ndid, kontaktandmed ja m\u00e4rkmed;<\/li>\n
  2. sarnane nimekiri \u00f5petajatest sama teabega;<\/li>\n
  3. \u00f5petajate tunniplaani koostamine samas s\u00fcsteemis;<\/li>\n
  4. \u00f5ppetundide ajakirja automaatne genereerimine;\n

    \"Mugav<\/li>\n

  5. tundide ajaloo j\u00e4lgimine;\n

    \"Mugav<\/li>\n

  6. finantsk\u00e4tet nii \u00f5pilaste eelarvetest maha arvestamiseks kui ka \u00f5petajatele tasumise jaoks;\n

    \"Mugav<\/li>\n

  7. \u00fcli\u00f5pilaste v\u00f5lgnevuste j\u00e4lgimise s\u00fcsteem;<\/li>\n
  8. m\u00e4rkmete tegemise vihik, et j\u00e4lgida \u00f5ppetundide \u00fcksikasju koos h\u00fcpikm\u00e4lestustega.<\/li>\n<\/ol>\n

    \nKummaliselt, kogu see keeruline arvestus \u00f5nnestus Exceli abil.<\/p>\n

    Lisaks v\u00f5imaldavad tabelid \u00fchendada \u00f5pilaste eelarved \u00fchte (kui nad on \u00fchte perre kuuluvad), \u00fchendada \u00f5petajate eelarved (kui nad esindavad partnerkoolide koole), sisestada erinevad koefitsiendid \u00f5petajatele maksmiseks, m\u00e4\u00e4rata \u00f5pilastele erinevaid hindasid, j\u00e4lgida operaatorite boonuseid ja trahve Skype'i koolis, vaadata maksete ja tundide statistikat.<\/p>\n

    Kuid kui \u00f5pilaste arv kasvas kahele sajale ja \u00f5petajate arv 75-le, siis see funktsioon, mis oli loodud Exceli v\u00f5imaluste piiril, muutus ebamugavaks. <\/p>\n

    Esiteks, aruannete arv osutus s\u00fcsteemi haldamiseks ebapiisavaks, teiseks n\u00f5udis offline versioon regulaarset puhastamist, et s\u00e4ilitada k\u00f5rge t\u00f6\u00f6 kiirus. Lisaks oli vajalik integreerimine botidega \u00f5petajate vabade kohtade kontrollimiseks, \u00fcli\u00f5pilaste tasakaalu kontrollimiseks, SMS-ide saatmiseks tundide t\u00fchistamisest jne.<\/p>\n

    Nii l\u00f5ime aja jooksul veebirakenduse GLASHA, mis sisuliselt on ERP s\u00fcsteem<\/a><\/noindex>, mis v\u00f5imaldab planeerida \u00f5petajate koormust, hallata \u00fcli\u00f5pilaste isiklikke tunni plaane ning pidada arvet finantside \u00fcle. T\u00e4nu sellele on saadaval erinevad aruandevormid, kadus vajadus igakuiste andmebaasi korrektuuride j\u00e4rele, tekkis v\u00f5imalus luua kliendi isiklik konto ja laadida sinna \u00fcles kodut\u00f6\u00f6d, testid teadmiste kontrollimiseks, siduda tunniplaan iga \u00fcli\u00f5pilase ajav\u00f6\u00f6ndiga jne.<\/p>\n

    \"Mugav
    \n
    \nArvan, et selline planeerimiss\u00fcsteem oleks igasuguste ettev\u00f5tete optimeerimiseks v\u00e4ga kasulik.
    \n
    Allikas:     habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

    \u0425\u043e\u0447\u0443 \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u043e\u043f\u044b\u0442\u043e\u043c \u044d\u0432\u043e\u043b\u044e\u0446\u0438\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0438\u0441\u0442\u0435\u043c \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u044f\u0437\u044b\u043a\u043e\u0432\u043e\u0439 \u043e\u043d\u043b\u0430\u0439\u043d \u0448\u043a\u043e\u043b\u0435 GLASHA. \u0428\u043a\u043e\u043b\u0430 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043b\u0430\u0441\u044c \u0432 2012 \u0433\u043e\u0434\u0443 \u0438 \u0432 \u043d\u0430\u0447\u0430\u043b\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u0432 \u043d\u0435\u0439 \u043e\u0431\u0443\u0447\u0430\u043b\u043e\u0441\u044c \u0432\u0441\u0435 12 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432, \u0442\u0430\u043a \u0447\u0442\u043e \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435\u043c \u0438 \u043e\u043f\u043b\u0430\u0442\u0430\u043c\u0438 \u043d\u0435 \u0431\u044b\u043b\u043e. \u041e\u0434\u043d\u0430\u043a\u043e \u043f\u043e \u043c\u0435\u0440\u0435 \u0440\u043e\u0441\u0442\u0430, \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u044f \u0438 \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u044f \u043d\u043e\u0432\u044b\u0445 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432 \u043e\u0441\u0442\u0440\u043e \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u043e \u0432\u044b\u0431\u043e\u0440\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0431\u0430\u0437\u044b […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36470","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\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 Mugav andmebaaside haldamise s\u00fcsteem | ProHoster","description":"Soovin jagada kogemust andmebaasis\u00fcsteemide arengust keeleline veebikool GLASHA. Kool asutati 2012. aastal ja alguses \u00f5ppis seal k\u00f5igest 12 \u00fcli\u00f5pilast, nii et tunni- ja maksete haldamisel ei olnud probleeme. Kuid koos kasvu, arengu ja uute \u00fcli\u00f5pilaste lisandumisega kerkis terav k\u00fcsimus andmebaasis\u00fcsteemi valikust.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\u0423\u0434\u043e\u0431\u043d\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 | ProHoster","og:description":"\u0425\u043e\u0447\u0443 \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c\u0441\u044f \u043e\u043f\u044b\u0442\u043e\u043c \u044d\u0432\u043e\u043b\u044e\u0446\u0438\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0438\u0441\u0442\u0435\u043c \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u044f\u0437\u044b\u043a\u043e\u0432\u043e\u0439 \u043e\u043d\u043b\u0430\u0439\u043d \u0448\u043a\u043e\u043b\u0435 GLASHA. \u0428\u043a\u043e\u043b\u0430 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043b\u0430\u0441\u044c \u0432 2012 \u0433\u043e\u0434\u0443 \u0438 \u0432 \u043d\u0430\u0447\u0430\u043b\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u0432 \u043d\u0435\u0439 \u043e\u0431\u0443\u0447\u0430\u043b\u043e\u0441\u044c \u0432\u0441\u0435 12 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432, \u0442\u0430\u043a \u0447\u0442\u043e \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0441 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u0435\u043c \u0438 \u043e\u043f\u043b\u0430\u0442\u0430\u043c\u0438 \u043d\u0435 \u0431\u044b\u043b\u043e. \u041e\u0434\u043d\u0430\u043a\u043e \u043f\u043e \u043c\u0435\u0440\u0435 \u0440\u043e\u0441\u0442\u0430, \u0440\u0430\u0437\u0432\u0438\u0442\u0438\u044f \u0438 \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u044f \u043d\u043e\u0432\u044b\u0445 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u043e\u0432 \u043e\u0441\u0442\u0440\u043e \u0432\u0441\u0442\u0430\u043b \u0432\u043e\u043f\u0440\u043e\u0441 \u043e \u0432\u044b\u0431\u043e\u0440\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0431\u0430\u0437\u044b","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","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":"2019-10-31T19:11:48+00:00","article:modified_time":"2019-10-31T19:11:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36470","title":null,"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-01-22 03:28:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 15:14:33","updated":"2026-01-22 03:28:19"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/36470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=36470"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/36470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/27293"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=36470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=36470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=36470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}