{"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\/pl\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","title":{"rendered":"Wygodny system zarz\u0105dzania bazami danych","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Chc\u0119 podzieli\u0107 si\u0119 do\u015bwiadczeniem ewolucji wykorzystania system\u00f3w baz danych w internetowej szkole j\u0119zykowej GLASHA.<\/p>\n

Szko\u0142a powsta\u0142a w 2012 roku, a na pocz\u0105tku jej dzia\u0142alno\u015bci ucz\u0119szcza\u0142o do niej tylko 12 uczni\u00f3w, wi\u0119c nie by\u0142o \u017cadnych problem\u00f3w z zarz\u0105dzaniem harmonogramem i p\u0142atno\u015bciami. Jednak wraz z rozwojem i wzrostem liczby nowych uczni\u00f3w pojawi\u0142a si\u0119 pilna potrzeba wyboru systemu baz danych.<\/p>\n

Zadanie polega\u0142o na tym, aby stworzy\u0107:
\n<\/a><\/noindex> <\/p>\n

    \n
  1. katalog wszystkich klient\u00f3w (uczni\u00f3w), przechowuj\u0105c ich imi\u0119 i nazwisko, stref\u0119 czasow\u0105, dane kontaktowe oraz notatki;<\/li>\n
  2. analogiczny spis nauczycieli z t\u0105 sam\u0105 informacj\u0105 o nich;<\/li>\n
  3. utworzy\u0107 harmonogram nauczycieli w tym samym systemie;<\/li>\n
  4. zrealizowa\u0107 automatyczne generowanie dziennik\u00f3w zaj\u0119\u0107;\n

    \"Wygodny<\/li>\n

  5. \u015bledzi\u0107 histori\u0119 zaj\u0119\u0107;\n

    \"Wygodny<\/li>\n

  6. prowadzenie rozlicze\u0144 finansowych zar\u00f3wno w kwestii wydatk\u00f3w z bud\u017cet\u00f3w uczni\u00f3w, jak i wynagrodze\u0144 dla nauczycieli;\n

    \"Wygodny<\/li>\n

  7. schemat monitorowania d\u0142u\u017cnik\u00f3w w\u015br\u00f3d uczni\u00f3w;<\/li>\n
  8. notatnik do zapisywania uwag na temat r\u00f3\u017cnych aspekt\u00f3w lekcji z wyskakuj\u0105cymi przypomnieniami.<\/li>\n<\/ol>\n

    \nJak si\u0119 okaza\u0142o, ca\u0142\u0105 t\u0119 z\u0142o\u017con\u0105 dokumentacj\u0119 uda\u0142o si\u0119 stworzy\u0107 przy u\u017cyciu Excela.<\/p>\n

    Co wi\u0119cej, arkusze kalkulacyjne umo\u017cliwi\u0142y \u0142\u0105czenie bud\u017cet\u00f3w uczni\u00f3w w jedn\u0105 ca\u0142o\u015b\u0107 (je\u015bli ucz\u0105 si\u0119 cz\u0142onkowie tej samej rodziny), \u0142\u0105czenie bud\u017cet\u00f3w nauczycieli (je\u015bli reprezentuj\u0105 szko\u0142y partnerskie), wprowadzanie r\u00f3\u017cnych wsp\u00f3\u0142czynnik\u00f3w dla wynagrodze\u0144 nauczycieli, ustalanie r\u00f3\u017cnych cen dla uczni\u00f3w, monitorowanie bonus\u00f3w i kar dla operator\u00f3w szko\u0142y Skype, a tak\u017ce przegl\u0105danie analityki dotycz\u0105cej p\u0142atno\u015bci i lekcji.<\/p>\n

    Jednak gdy liczba uczni\u00f3w wzros\u0142a do dwustu, a liczba nauczycieli do 75, ta funkcjonalno\u015b\u0107, opracowana na granicy mo\u017cliwo\u015bci Excela, przesta\u0142a by\u0107 wygodna. <\/p>\n

    Po pierwsze, liczba raport\u00f3w sta\u0142a si\u0119 niewystarczaj\u0105ca dla systemu zarz\u0105dzania, po drugie, wersja offline wymaga\u0142a regularnego czyszczenia, aby zachowa\u0107 wysok\u0105 wydajno\u015b\u0107. Opr\u00f3cz tego potrzebna by\u0142a integracja z botami do sprawdzania dost\u0119pnych slot\u00f3w u nauczycieli, weryfikowania salda na \u017c\u0105danie uczni\u00f3w, wysy\u0142ania SMS-\u00f3w o odwo\u0142aniu lekcji itp.<\/p>\n

    I z czasem stworzyli\u015bmy aplikacj\u0119 webow\u0105 GLASHA, kt\u00f3ra w zasadzie jest systemem ERP<\/a><\/noindex>, kt\u00f3ra umo\u017cliwia planowanie obci\u0105\u017cenia nauczycieli, prowadzenie indywidualnych harmonogram\u00f3w zaj\u0119\u0107 dla student\u00f3w, a tak\u017ce zarz\u0105dzanie finansami. Dzi\u0119ki temu dost\u0119pne sta\u0142y si\u0119 r\u00f3\u017cne formy raport\u00f3w, znikn\u0119\u0142a potrzeba comiesi\u0119cznej korekty bazy danych, pojawi\u0142a si\u0119 mo\u017cliwo\u015b\u0107 stworzenia panelu klienta oraz przesy\u0142ania tam pracy domowej, test\u00f3w do weryfikacji wiedzy, powi\u0105zania harmonogramu z stref\u0105 czasow\u0105 ka\u017cdego studenta itp.<\/p>\n

    \"Wygodny
    \n
    \nMy\u015bl\u0119, \u017ce taki system planowania by\u0142by przydatny do optymalizacji w ka\u017cdej formie biznesu.
    \n
    \u0179r\u00f3d\u0142o:     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\udd47Wygodny system zarz\u0105dzania bazami danych | ProHoster","description":"Chc\u0119 podzieli\u0107 si\u0119 do\u015bwiadczeniem ewolucji wykorzystania system\u00f3w baz danych w internetowej szkole j\u0119zykowej GLASHA. Szko\u0142a powsta\u0142a w 2012 roku i na pocz\u0105tku w niej uczy\u0142o si\u0119 zaledwie 12 student\u00f3w, wi\u0119c nie by\u0142o \u017cadnych problem\u00f3w z.","canonical_url":"https:\/\/prohoster.info\/pl\/blog\/administrirovanie\/udobnaya-sistema-upravleniya-bazami-dannyh","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pl_PL","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\/pl\/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\/pl\/wp-json\/wp\/v2\/posts\/36470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/comments?post=36470"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/36470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media\/27293"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media?parent=36470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/categories?post=36470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/tags?post=36470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}