{"id":756,"date":"2016-07-29T10:52:28","date_gmt":"2016-07-29T08:52:28","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=756"},"modified":"2016-07-29T10:52:56","modified_gmt":"2016-07-29T08:52:56","slug":"winccoa-rdb-manager-with-oracle-vs-mongodb","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=756","title":{"rendered":"WinCC OA RDB-Manager with Oracle vs MongoDB"},"content":{"rendered":"<p><iframe loading=\"lazy\" title=\"WinCCOA RDB-Manager with Oracle vs WinCC OA with MongoDB\" width=\"584\" height=\"329\" src=\"https:\/\/www.youtube.com\/embed\/twUv7hfankQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>Keep in Mind: It is not a comparison of the databases only. With Oracle we used the WinCC OA RDB Manager with OA Query-RDB Direct option, and the RDB-Manager has lot of more functionalities than the NoSQL Prototyp! The other databases were tested with a NoSQL Logger Prototyp written in Java, and the implementations for writing and reading are different, because there are different interfaces for each database &#8211; for PostgreSQL we used the PostgreSQL JDBC driver, MongoDB has it&#8217;s own Java API and InfluxDB uses REST\/HTTP. So, not only the speed of the database itself is compared &#8211; also the interfaces to WinCC OA and the implementations of reading are taken into account.<\/p>\n<p>Oracle and OA RDB-Manager Results:<br \/>\n2016.07.29 09:09:03.302[&#8220;start&#8230;&#8221;]<br \/>\n2016.07.29 09:09:39.628[36.326][33669]<br \/>\n2016.07.29 09:11:22.051[&#8220;start&#8230;&#8221;]<br \/>\n2016.07.29 09:11:36.213[14.159][33669]<\/p>\n<p>MongoDB Results:<br \/>\n2016.07.29 09:10:37.449[&#8220;start&#8230;&#8221;]<br \/>\n2016.07.29 09:10:53.171[15.72][33669]<br \/>\n2016.07.29 09:11:42.932[&#8220;start&#8230;&#8221;]<br \/>\n2016.07.29 09:11:52.918[9.986][33669]<\/p>\n<p>InfluxDB Results:<br \/>\nWCCOAui1:2016.07.29 09:47:33.441[&#8220;start&#8230;&#8221;]<br \/>\nWCCOAui1:2016.07.29 09:47:42.477[9.035][33668]<br \/>\nWCCOAui1:2016.07.29 09:48:12.733[&#8220;start&#8230;&#8221;]<br \/>\nWCCOAui1:2016.07.29 09:48:18.745[6.011][33668]<\/p>\n<p>it is faster than MongoDB. And our InfluxDB is running on a MacMini (Hyper-V) and the data is stored on a shared Synology NAS for home usage (DS414 slim) &#8211; much less power for InfluxDB compared to the four 7.2k disks and to the i7 where the Oracle DB and MonogDB is running on.<\/p>\n<p>PostgreSQL Results:<br \/>\nWCCOAui1:2016.07.29 09:56:55.062[&#8220;start&#8230;&#8221;]<br \/>\nWCCOAui1:2016.07.29 09:57:03.475[8.41][33669]<br \/>\nWCCOAui1:2016.07.29 09:57:14.767[&#8220;start&#8230;&#8221;]<br \/>\nWCCOAui1:2016.07.29 09:57:20.196[5.427][33669]<\/p>\n<p>PostgreSQL is running on the same machine and disks as Oracle and MongoDB.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Keep in Mind: It is not a comparison of the databases only. With Oracle we used the WinCC OA RDB Manager with OA Query-RDB Direct option, and the RDB-Manager has lot of more functionalities than the NoSQL Prototyp! The other &hellip; <a href=\"https:\/\/www.rocworks.at\/wordpress\/?p=756\">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-756","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\/756","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=756"}],"version-history":[{"count":2,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/756\/revisions"}],"predecessor-version":[{"id":758,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/756\/revisions\/758"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}