{"id":671,"date":"2015-12-28T10:49:27","date_gmt":"2015-12-28T08:49:27","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=671"},"modified":"2016-03-31T21:09:59","modified_gmt":"2016-03-31T19:09:59","slug":"databases-for-wincc-oa-logging","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=671","title":{"rendered":"Databases for WinCC OA Logging&#8230;."},"content":{"rendered":"<p>I have implemented a Database Logger for WinCC OA which supports different databases.<\/p>\n<p>I did now a first test to compare some\u00a0databases with WinCC OA and time series logging.<\/p>\n<p>The logger is writing 1000 values\/second to four databases in parallel: MSSQL Server, InfluxDB, Phoenix (based on Hadoop\/HBase) and Oracle.<\/p>\n<p>There are now about 160.000.000 values in each database. About 3.600.000 values are added every hour&#8230;<\/p>\n<p>Four Ctrl-Scripts are querying data with dpGetPeriod every 10 seconds, random\u00a0time frames (between 1 and 2 hours of data).<\/p>\n<p><a href=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-09.33.27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-672\" src=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-09.33.27-1024x955.png\" alt=\"Screen Shot 2015-12-28 at 09.33.27\" width=\"604\" height=\"563\" srcset=\"https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-09.33.27-1024x955.png 1024w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-09.33.27-300x280.png 300w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-09.33.27.png 1254w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/a><\/p>\n<p>Oracle seems to be slower (i think this is related to my test environment), but the access and response times are stable with growing amount of data in the database.<\/p>\n<p><a href=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-10.37.13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-679\" src=\"http:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-10.37.13-1024x657.png\" alt=\"Screen Shot 2015-12-28 at 10.37.13\" width=\"604\" height=\"388\" srcset=\"https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-10.37.13-1024x657.png 1024w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-10.37.13-300x192.png 300w, https:\/\/www.rocworks.at\/wordpress\/wp-content\/uploads\/2015\/12\/Screen-Shot-2015-12-28-at-10.37.13.png 1813w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/a><\/p>\n<p>remark: at 10pm the Oracle DB backup starts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have implemented a Database Logger for WinCC OA which supports different databases. I did now a first test to compare some\u00a0databases with WinCC OA and time series logging. The logger is writing 1000 values\/second to four databases in parallel: &hellip; <a href=\"https:\/\/www.rocworks.at\/wordpress\/?p=671\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,3],"tags":[],"class_list":["post-671","post","type-post","status-publish","format-standard","hentry","category-bigdatanosql","category-wincc-oa"],"_links":{"self":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=671"}],"version-history":[{"count":5,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/671\/revisions"}],"predecessor-version":[{"id":681,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/671\/revisions\/681"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}