{"id":25266,"date":"2019-04-09T15:42:13","date_gmt":"2019-04-09T15:42:13","guid":{"rendered":"https:\/\/dev1.ats-global.com\/sber-vizualizace-a-zpracovani-dat-z-testovaciho-zarizeni-kontrola-sledu-vyrobniho-procesu-sprava-databaze\/"},"modified":"2024-12-18T11:23:19","modified_gmt":"2024-12-18T11:23:19","slug":"sber-vizualizace-a-zpracovani-dat-z-testovaciho-zarizeni-kontrola-sledu-vyrobniho-procesu-sprava-databaze","status":"publish","type":"post","link":"https:\/\/www.ats-global.com\/cs\/sber-vizualizace-a-zpracovani-dat-z-testovaciho-zarizeni-kontrola-sledu-vyrobniho-procesu-sprava-databaze\/","title":{"rendered":"Sb\u011br, vizualizace a zpracov\u00e1n\u00ed dat z testovac\u00edho za\u0159\u00edzen\u00ed, kontrola sledu v\u00fdrobn\u00edho procesu, spr\u00e1va datab\u00e1ze"},"content":{"rendered":"

Z\u00e1kazn\u00edk po\u017eadoval p\u0159i zah\u00e1jen\u00ed testov\u00e1n\u00ed v\u00fdrobku kontrolovat, zda v\u00fdrobek pro\u0161el p\u0159edchoz\u00edm pracovi\u0161t\u011bm s v\u00fdsledkem OK. Z\u00e1kazn\u00edk d\u00e1le po\u017eadoval sb\u011br dat z testov\u00e1n\u00ed,
\njejich okam\u017eit\u00e9 zobrazen\u00ed, mo\u017enost exportu dat do textov\u00fdch soubor\u016f, tvorbu graf\u016f a jejich ukl\u00e1d\u00e1n\u00ed do obr\u00e1zkov\u00fdch soubor\u016f a u\u017eivatelsky p\u0159\u00edjemn\u00fd n\u00e1stroj pro spr\u00e1vu datab\u00e1ze.Aby bylo mo\u017en\u00e9 kontrolovat, zda v\u00fdrobek pro\u0161el p\u0159edchoz\u00edm pracovi\u0161t\u011bm s v\u00fdsledkem OK, bylo nutn\u00e9 vytvo\u0159it aplikaci zaji\u0161\u0165uj\u00edc\u00ed propojen\u00ed datab\u00e1ze s testovac\u00edm za\u0159\u00edzen\u00edm
\novl\u00e1dan\u00fdm programovateln\u00fdm logick\u00fdm kontrol\u00e9rem (d\u00e1le jen PLC). Aplikace musela v r\u00e1mci jedin\u00e9 obrazovky poskytovat obsluze p\u0159ehled o v\u00fdsledc\u00edch test\u016f a umo\u017e\u0148ovat pr\u00e1ci s daty.<\/p>\n

\"rozhran\u00ed
Rozhran\u00ed aplikace<\/p>\n

Po vlo\u017een\u00ed do testovac\u00edho za\u0159\u00edzen\u00ed je v\u00fdrobek identifikov\u00e1n pomoc\u00ed 2D k\u00f3du, testovac\u00ed cyklus se spust\u00ed, provede se kontrola v\u00fdsledku z p\u0159edchoz\u00edho pracovi\u0161t\u011b a v\u00fdsledek aktu\u00e1ln\u00edho testu je zaps\u00e1n do datab\u00e1ze a
\nzobrazen v hlavn\u00ed obrazovce na monitoru PC.<\/p>\n

Hlavn\u00ed obrazovka je u\u017eivatelsky konfigurovateln\u00e1, lze volit mezi on-line re\u017eimy zobrazen\u00ed aktu\u00e1ln\u00edho testu a off-line re\u017eimem filtrov\u00e1n\u00ed, zobrazen\u00ed a exportu dat na z\u00e1klad\u011b
\n\u010dasov\u00e9ho obdob\u00ed nebo 2D k\u00f3du.<\/p>\n

P\u0159es\u00e1hne-li mno\u017estv\u00ed dat ulo\u017een\u00fdch do datab\u00e1ze nastavenou mez, je u\u017eivateli nab\u00eddnuta mo\u017enost data archivovat stiskem
\ntla\u010d\u00edtka. Pr\u00e1va p\u0159\u00edstupu jsou p\u0159id\u011blov\u00e1na na z\u00e1klad\u011b
\nu\u017eivatelsk\u00fdch hesel.<\/p>\n

Aplikace byla realizov\u00e1na v prost\u0159ed\u00ed .NET v jazyce C# a krom\u011b vizualizace m\u00e1 n\u00e1sleduj\u00edc\u00ed rozhran\u00ed:<\/p>\n

    \n
  • Rozhran\u00ed p\u0159ipojen\u00ed k PLC p\u0159es OPC server<\/li>\n
  • Rozhran\u00ed p\u0159ipojen\u00ed k datab\u00e1zi<\/li>\n
  • Rozhran\u00ed exportu dat<\/li>\n<\/ul>\n

    Jako OPC server je pou\u017eit KEPServerEX verze 5.7 Siemens Suite, kter\u00fd je nainstalov\u00e1n na stejn\u00e9m PC jako datab\u00e1zov\u00fd server Microsoft SQL Server 2005 Express. Aplikace
    \nvyu\u017e\u00edv\u00e1 dvou datab\u00e1z\u00ed s p\u0159edpokladem um\u00edst\u011bn\u00ed obou na jednom datab\u00e1zov\u00e9m serveru. Prvn\u00ed datab\u00e1z\u00ed je datab\u00e1ze v\u00fdsledk\u016f z p\u0159edchoz\u00edho pracovi\u0161t\u011b a druhou je datab\u00e1ze v\u00fdsledk\u016f aktu\u00e1ln\u00edch test\u016f.<\/p>\n

    Microsoft SQL Server 2005 Express m\u00e1 omezen\u00ed velikosti jedn\u00e9 datab\u00e1ze do 4096MB. Kontrola velikosti datab\u00e1ze prob\u011bhne p\u0159i startu aplikace a pot\u00e9 v intervalech 24 hodin.
    \nP\u0159i p\u0159ekro\u010den\u00ed definovan\u00e9 velikosti datab\u00e1ze je u\u017eivateli nab\u00eddnuta mo\u017enost automatick\u00e9 archivace datab\u00e1ze.<\/p>\n

    B\u011bhem procesu archivace je nejprve proveden shrink aktu\u00e1ln\u00ed datab\u00e1ze, pot\u00e9 je vytvo\u0159ena jej\u00ed z\u00e1loha. Z\u00e1loha je obnovena do z\u00e1lohov\u00e9 datab\u00e1ze se zn\u00e1m\u00fdm \u010d\u00edslem
    \nposledn\u00edho z\u00e1znamu. V aktu\u00e1ln\u00ed datab\u00e1zi jsou vymaz\u00e1na data s \u010d\u00edslem z\u00e1znamu men\u0161\u00edm nebo rovn\u00fdm \u010d\u00edslu posledn\u00edho z\u00e1znamu v datab\u00e1zi z\u00e1lohov\u00e9. Archivace kon\u010d\u00ed shrinkem redukovan\u00e9 aktu\u00e1ln\u00ed datab\u00e1ze a vymaz\u00e1n\u00edm jej\u00ed p\u016fvodn\u00ed z\u00e1lohy.<\/p>\n

    Softwarov\u00e9 po\u017eadavky:<\/b><\/p>\n

      \n
    • Microsoft Visual C# 2010 Express<\/li>\n
    • Microsoft .NET Framework 4<\/li>\n
    • Microsoft SQL Server 2005 nebo vy\u0161\u0161\u00ed<\/li>\n
    • Microsoft SQL Server Management Studio (nepovinn\u00fd n\u00e1stroj pro datab\u00e1zovou administraci)<\/li>\n
    • KepServerEX v 5.7 (sou\u010d\u00e1st dod\u00e1vky)<\/li>\n<\/ul>\n

      Dal\u0161\u00ed fotodokumentaci je mo\u017eno zaslat na vy\u017e\u00e1d\u00e1n\u00ed.<\/p>\n<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[336],"tags":[],"success_stories_industry":[],"business_offerings":[],"page_categories":[],"knowledge_services":[],"class_list":["post-25266","post","type-post","status-publish","format-standard","hentry","category-automotive-cs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/posts\/25266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/comments?post=25266"}],"version-history":[{"count":0,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/posts\/25266\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/media?parent=25266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/categories?post=25266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/tags?post=25266"},{"taxonomy":"success_stories_industry","embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/success_stories_industry?post=25266"},{"taxonomy":"business_offerings","embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/business_offerings?post=25266"},{"taxonomy":"page_categories","embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/page_categories?post=25266"},{"taxonomy":"knowledge_services","embeddable":true,"href":"https:\/\/www.ats-global.com\/cs\/wp-json\/wp\/v2\/knowledge_services?post=25266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}