{"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\/hu\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","title":{"rendered":"K\u00e9nyelmes adatb\u00e1zis-kezel\u0151 rendszer","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Meg szeretn\u00e9m osztani a tapasztalataimat az adatb\u00e1zis-szolg\u00e1ltat\u00e1sok fejl\u0151d\u00e9s\u00e9r\u0151l a GLASHA nyelvi online iskol\u00e1ban.<\/p>\n

Az iskola 2012-ben alakult, \u00e9s a munka kezdet\u00e9n mind\u00f6ssze 12 hallgat\u00f3 tanult benne, \u00edgy nem voltak probl\u00e9m\u00e1k az \u00f3rarend \u00e9s a befizet\u00e9sek kezel\u00e9s\u00e9vel. Azonban a n\u00f6veked\u00e9s, a fejl\u0151d\u00e9s \u00e9s az \u00faj di\u00e1kok megjelen\u00e9s\u00e9vel egyre s\u00fcrget\u0151bb\u00e9 v\u00e1lt az adatb\u00e1zis-kezel\u0151 rendszer kiv\u00e1laszt\u00e1sa.<\/p>\n

A feladat az volt, hogy:
\n<\/a><\/noindex> <\/p>\n

    \n
  1. k\u00e9sz\u00edts\u00fcnk egy nyilv\u00e1ntart\u00e1st az \u00f6sszes kliensr\u0151l (di\u00e1kr\u00f3l), meg\u0151rizve a nev\u00fcket, id\u0151z\u00f3n\u00e1jukat, el\u00e9rhet\u0151s\u00e9geiket \u00e9s megjegyz\u00e9seiket;<\/li>\n
  2. hasonl\u00f3 list\u00e1t a tan\u00e1rokr\u00f3l, ugyanezekkel az inform\u00e1ci\u00f3kkal r\u00f3luk;<\/li>\n
  3. k\u00e9sz\u00edts\u00fcnk \u00f3rarendet a tan\u00e1rok sz\u00e1m\u00e1ra ugyanebben a rendszerben;<\/li>\n
  4. automatikus \u00f3rak\u00f6nyv-gener\u00e1l\u00e1st k\u00e9sz\u00edts\u00fcnk;\n

    \"K\u00e9nyelmes<\/li>\n

  5. k\u00f6vess\u00fck a foglalkoz\u00e1sok t\u00f6rt\u00e9net\u00e9t;\n

    \"K\u00e9nyelmes<\/li>\n

  6. kezelj\u00fck a p\u00e9nz\u00fcgyeket minden di\u00e1k k\u00f6lts\u00e9gvet\u00e9s\u00e9nek levon\u00e1s\u00e1hoz \u00e9s a tan\u00e1rok fizet\u00e9s\u00e9hez;\n

    \"K\u00e9nyelmes<\/li>\n

  7. ny\u00fajtsunk inform\u00e1ci\u00f3t az ad\u00f3sok nyomon k\u00f6vet\u00e9s\u00e9r\u0151l a di\u00e1kok k\u00f6z\u00f6tt;<\/li>\n
  8. k\u00e9sz\u00edts\u00fcnk jegyzetf\u00fczetet a tan\u00f3r\u00e1k egyes r\u00e9szleteir\u0151l felugr\u00f3 eml\u00e9keztet\u0151kkel.<\/li>\n<\/ol>\n

    \nA meglep\u0151 dolog, hogy ezt a bonyolult jelent\u00e9st Excel seg\u00edts\u00e9g\u00e9vel siker\u00fclt elk\u00e9sz\u00edten\u00fcnk.<\/p>\n

    S\u0151t, a t\u00e1bl\u00e1zatok lehet\u0151v\u00e9 tett\u00e9k, hogy egyes\u00edts\u00fck a di\u00e1kok k\u00f6lts\u00e9gvet\u00e9s\u00e9t (ha egy csal\u00e1d tagjaik\u00e9nt tanulnak), egyes\u00edts\u00fck a tan\u00e1rok k\u00f6lts\u00e9gvet\u00e9s\u00e9t (ha partneriskol\u00e1kat k\u00e9pviselnek), k\u00fcl\u00f6nf\u00e9le szorz\u00f3kat alkalmazzunk a tan\u00e1rok fizet\u00e9sekor, k\u00fcl\u00f6nb\u00f6z\u0151 \u00e1rakat \u00e1ll\u00edtsunk be a di\u00e1kok sz\u00e1m\u00e1ra, \u00e9s nyomon k\u00f6vethess\u00fck a Skype iskola oper\u00e1torainak b\u00f3nuszait \u00e9s b\u00fcntet\u00e9seit, valamint elemezz\u00fck a befizet\u00e9seket \u00e9s az \u00f3r\u00e1kat.<\/p>\n

    Azonban, amikor a di\u00e1kok sz\u00e1ma 200-ra, a tan\u00e1rok\u00e9 pedig 75-re n\u0151tt, ez a funkci\u00f3, amelyet az Excel hat\u00e1rain\u00e1l alak\u00edtottunk ki, k\u00e9nyelmetlenn\u00e9 v\u00e1lt. <\/p>\n

    El\u0151sz\u00f6r is, a jelent\u00e9sek sz\u00e1ma nem volt elegend\u0151 a kezel\u0151 rendszer sz\u00e1m\u00e1ra, m\u00e1sodszor, az offline verzi\u00f3 folyamatos tiszt\u00edt\u00e1st ig\u00e9nyelt a magas munkasebess\u00e9g meg\u0151rz\u00e9se \u00e9rdek\u00e9ben. Ezenk\u00edv\u00fcl integr\u00e1ci\u00f3ra volt sz\u00fcks\u00e9g a botokkal a tan\u00e1rok szabad helyeinek ellen\u0151rz\u00e9s\u00e9re, a di\u00e1kok k\u00e9r\u00e9s\u00e9re a saldo ellen\u0151rz\u00e9s\u00e9re, \u00f3r\u00e1k lemond\u00e1s\u00e1r\u00f3l SMS k\u00fcld\u00e9s\u00e9re stb.<\/p>\n

    Id\u0151vel l\u00e9trehoztuk a GLASHA webalkalmaz\u00e1st, amely l\u00e9nyeg\u00e9ben Egy ERP rendszer<\/a><\/noindex>, amely lehet\u0151v\u00e9 teszi a tan\u00e1rok terhel\u00e9s\u00e9nek tervez\u00e9s\u00e9t, a di\u00e1kok \u00f3rarendj\u00e9nek kezel\u00e9s\u00e9t, valamint a p\u00e9nz\u00fcgyi nyilv\u00e1ntart\u00e1s vezet\u00e9s\u00e9t. Ennek k\u00f6sz\u00f6nhet\u0151en k\u00fcl\u00f6nf\u00e9le jelent\u00e9st\u00edpusok v\u00e1ltak el\u00e9rhet\u0151v\u00e9, a havi adatb\u00e1zis-korrekci\u00f3 sz\u00fcks\u00e9gess\u00e9ge megsz\u0171nt, lehet\u0151s\u00e9g ny\u00edlt a kliens szem\u00e9lyes fi\u00f3kj\u00e1nak l\u00e9trehoz\u00e1s\u00e1ra \u00e9s otthoni feladatok, tud\u00e1sellen\u0151rz\u0151 tesztek felt\u00f6lt\u00e9s\u00e9re, az \u00f3rarend \u00f6sszekapcsol\u00e1s\u00e1ra minden di\u00e1k id\u0151z\u00f3n\u00e1j\u00e1val stb.<\/p>\n

    \"K\u00e9nyelmes
    \n
    \n\u00dagy gondolom, hogy egy ilyen tervez\u00e9si rendszer hasznos lenne b\u00e1rmilyen \u00fczlet\u00e1g optimaliz\u00e1l\u00e1s\u00e1ra.
    \n
    Forr\u00e1s:     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\udd47K\u00e9nyelmes adatb\u00e1zis-kezel\u0151 rendszer | ProHoster","description":"Szeretn\u00e9m megosztani a tapasztalataimat az adatb\u00e1zis-kezel\u0151 rendszerek fejl\u0151d\u00e9s\u00e9r\u0151l a GLASHA nyelvi online iskol\u00e1ban. Az iskola 2012-ben alakult, \u00e9s a kezdetekben mind\u00f6ssze 12 di\u00e1k tanult benne, \u00edgy nem voltak probl\u00e9m\u00e1k.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/36470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=36470"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/36470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/27293"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=36470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=36470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=36470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}