{"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\/sv\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","title":{"rendered":"Ett anv\u00e4ndarv\u00e4nligt databasadministrationssystem","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Jag vill dela med mig av erfarenheterna av utvecklingen av databassystemen inom den spr\u00e5kliga online-skolan GLASHA.<\/p>\n

Skolan grundades \u00e5r 2012 och i b\u00f6rjan fanns det bara 12 studenter, s\u00e5 det fanns inga problem med schemal\u00e4ggning eller betalningar. Men i takt med tillv\u00e4xten, utvecklingen och fler studenter blev valet av databassystem en akut fr\u00e5ga.<\/p>\n

Uppgiften var att skapa:
\n<\/a><\/noindex> <\/p>\n

    \n
  1. ett register \u00f6ver alla kunder (studenter) med deras namn, tidszon, kontaktuppgifter och anteckningar;<\/li>\n
  2. en liknande lista \u00f6ver l\u00e4rare med samma information;<\/li>\n
  3. att skapa ett schema f\u00f6r l\u00e4rarna i samma system;<\/li>\n
  4. att g\u00f6ra automatiserad generering av lektioners journal;\n

    \"Ett<\/li>\n

  5. att sp\u00e5ra lektionshistorik;\n

    \"Ett<\/li>\n

  6. finansiell redovisning f\u00f6r att hantera b\u00e5de debiteringar fr\u00e5n studenternas budgetar och betalningar till l\u00e4rarna;\n

    \"Ett<\/li>\n

  7. ett system f\u00f6r att sp\u00e5ra skuldsatta studenter;<\/li>\n
  8. ett anteckningsblock f\u00f6r att notera speciella detaljer om lektionerna med popup-p\u00e5minnelser.<\/li>\n<\/ol>\n

    \nKonstigt nog lyckades hela denna komplexa rapportering g\u00f6ras med hj\u00e4lp av Excel.<\/p>\n

    Dessutom till\u00e4t kalkylbladen att sammanf\u00f6ra studenternas budgetar till en (om de \u00e4r medlemmar av samma familj), sl\u00e5 ihop l\u00e4rarnas budgetar (om de representerar partner skolor), ange olika koefficienter f\u00f6r l\u00e4rarl\u00f6ner, st\u00e4lla in olika priser f\u00f6r studenter, sp\u00e5ra bonusar och avgifter f\u00f6r operat\u00f6rerna i skypeskolan, samt analysera betalningar och lektioner.<\/p>\n

    Men n\u00e4r antalet studenter \u00f6kade till tv\u00e5hundra och antalet l\u00e4rare till 75, blev denna funktionalitet, som var p\u00e5 gr\u00e4nsen till vad Excel klarade av, inte l\u00e4ngre anv\u00e4ndbar. <\/p>\n

    F\u00f6r det f\u00f6rsta blev antalet rapporter otillr\u00e4ckligt f\u00f6r ledningssystemet, f\u00f6r det andra kr\u00e4vde offline-versionen regelbundet rensning f\u00f6r att beh\u00e5lla h\u00f6g hastighet. Dessutom blev integration med bottar n\u00f6dv\u00e4ndig f\u00f6r att kolla lediga tider hos l\u00e4rarna, kontrollera saldon vid studenternas f\u00f6rfr\u00e5gningar, skicka SMS om inst\u00e4llda lektioner osv.<\/p>\n

    Och med tiden skapade vi webbapplikationen GLASHA, som i grunden \u00e4r en ERP-system.<\/a><\/noindex>, som g\u00f6r det m\u00f6jligt att schemal\u00e4gga l\u00e4rarnas arbetsbelastning, hantera studenternas personliga kursplaner och \u00e4ven h\u00e5lla reda p\u00e5 ekonomin. Tack vare detta har olika rapporteringsformer blivit tillg\u00e4ngliga, behovet av m\u00e5natlig korrigering av databasen har f\u00f6rsvunnit, det har blivit m\u00f6jligt att skapa en kunds personlig portal och ladda upp hemarbete, test f\u00f6r kunskapskontroll, koppla schemat till varje students tidszon, osv.<\/p>\n

    \"Ett
    \n
    \nJag tror att ett s\u00e5dant planeringssystem skulle vara anv\u00e4ndbart f\u00f6r att optimera alla former av verksamhet.
    \n
    K\u00e4lla:     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\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 Praktiskt databasadministrationssystem | ProHoster","description":"Jag vill dela med mig av erfarenheten av utvecklingen av databasystem i den spr\u00e5kliga online-skolan GLASHA. Skolan grundades 2012 och i b\u00f6rjan av verksamheten undervisades alla 12 studenter, s\u00e5 det fanns inga problem med.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","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.","og:url":"https:\/\/prohoster.info\/sv\/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","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/36470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=36470"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/36470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media\/27293"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=36470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=36470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=36470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}