{"id":13391,"date":"2019-05-07T12:16:06","date_gmt":"2019-05-07T12:16:06","guid":{"rendered":"http:\/\/www.whichwarehouse.com\/blog\/?p=13391"},"modified":"2025-07-28T09:15:06","modified_gmt":"2025-07-28T09:15:06","slug":"cloud-data-warehousing-pros-cons","status":"publish","type":"post","link":"https:\/\/www.whichwarehouse.com\/blog\/3pl\/cloud-data-warehousing-pros-cons\/","title":{"rendered":"Cloud Data Warehousing \u2013 What are the Pros &amp; Cons?"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">A data warehouse is an electronic system that gathers data from a wide range of sources within a company and uses the data to support management decision-making. However, what are the advantages and disadvantages of such a system?<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">\u2018Panoply\u2019 is a cloud data warehouse and management service. They explain that:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>\u201cCompanies are increasingly moving towards cloud-based data warehouses instead of traditional on premise systems. Cloud-based data warehouses differ from traditional warehouses in the following ways:<\/em><\/strong><\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>There is no need to purchase physical hardware.<\/em><\/strong><\/span><\/li>\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>It\u2019s quicker and cheaper to set up and scale cloud data warehouses.<\/em><\/strong><\/span><\/li>\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>Cloud-based data warehouse architectures can typically perform complex analytical queries much faster because they use massively parallel processing (MPP).\u201d<\/em><\/strong><\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><!--more--><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">However, how does your company decide if this investment is right for you?<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">Ever since the development of cloud technology, one option that you have had is to replace local backup methods with off-site, cloud storage. With this or any kind of platform, there are advantages and disadvantages that should be considered in determining if cloud storage is compatible with your company\u2019s Information Technology\u2019s infrastructure.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">With that in mind, Grace Halverson (IT Pro) states that there are four business benefits of cloud data warehousing:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em><span style=\"color: #ff6600;\">\u201c1: Cloud data warehousing meets current and future needs<\/span><\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>Flexibility is an important factor of cloud data warehousing. Organisations will have the ability to scale compute and storage independently, pending the company\u2019s needs. So, if a business needs more storage today, they won\u2019t also be forced to add more compute. But if their situation changes in the future, they can adjust however needed.<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #ff6600;\"><strong><em>2: Data is accommodated and integrated in one place<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>With the help of data analytics, semi-structured data has the capability to provide next-level insights beyond what traditional data can provide. But semi-structured data must be loaded and transformed before an organisation can analyse it\u2014this is a process most traditional data warehouses can\u2019t handle, but one that cloud data warehouses can. This ability to support diverse data without performance issues ensures all an organisation\u2019s data can be loaded and integrated in one location. This not only increases flexibility, but it also means all data can be managed and maintained in one system, reducing costs.<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #ff6600;\"><strong><em>3: Cloud data warehousing saves money<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>Between licensing fees, hardware, set-up, management, securing and backing up data, and more, conventional data warehouses can cost millions. Not to mention building one that can hold the variety and volume required by today\u2019s standards ups the cost even more. However, using cloud data warehousing as a service (as it is commonly used today) can cut costs significantly, while keeping all the same features. Relying on service providers to maintain systems and only purchasing the amount of support needed helps organisations stretch their budgets further and avoid paying for unnecessary features.<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #ff6600;\"><strong><em>4: Data is secured at rest and in transit<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>An important aspect to analysing and storing data is keeping that data safe. In addition to the use of vendor-conducted penetration tests to check for vulnerabilities in the system, modern data warehouses do this through confidentiality and integrity measures. Confidentiality practices prevent unauthorised access to data, and are usually done through role-based access control, which only allows those permitted to access the data to do so, and multi-factor authentication, which requires users to enter a code (usually one sent to a mobile phone) and ensures a stolen username and password can\u2019t be used to access the system. Integrity measures guarantee data isn\u2019t modified or corrupted, and entails the use of encryption practices and encryption keys to protect data from &#8220;unauthorised prying eyes.\u201d<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">The data warehouse \u2018Snowflake\u2019, is a leading cloud provider in this most competitive field. They offer warehouse solutions offering a new SQL database engine with a unique architecture designed for the cloud. To the user, Snowflake has many similarities to other enterprise data warehouses, but their claims are for additional functionality and unique capabilities.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">Wow, this sounds wonderful, what\u2019s not to like. Mmmmm, not so fast, things in life are rarely black and white, but manifest themselves in shades of grey. Therefore, on the flip-side, what are the disadvantages of Cloud Storage?<\/span><\/p>\n<ol style=\"text-align: justify;\">\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>Usability: Be careful when using drag\/drop to move a document into the cloud storage folder. This will permanently move your document from its original folder to the cloud storage location. Do a copy and paste instead of drag\/drop if you want to retain the document\u2019s original location in addition to moving a copy onto the cloud storage folder.<\/em><\/strong><\/span><\/li>\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em> Bandwidth: Several cloud storage services have a specific bandwidth allowance. If an organization surpasses the given allowance, the additional charges could be significant. However, some providers allow unlimited bandwidth. This is a factor that companies should consider when looking at a cloud storage provider.<\/em><\/strong><\/span><\/li>\n<\/ol>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em> Accessibility: If you have no internet connection, you have no access to your data.<\/em><\/strong><\/span><\/li>\n<\/ol>\n<ol style=\"text-align: justify;\" start=\"5\">\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em> Data Security: There are concerns with the safety and privacy of important data stored remotely. The possibility of private data commingling with other organizations makes some businesses uneasy.<\/em><\/strong><\/span><\/li>\n<li><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em> Software: If you want to be able to manipulate your files locally through multiple devices, you\u2019ll need to download the service on all devices.\u201d <\/em><\/strong>(Baiju NT, Big Data Made Simple)<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">Do the advantages cancel out the disadvantages, in your opinion?<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">In summary, weighing up all these factors, what is the final analysis for your company? Only your managers and ultimately your directors, can decide.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">Amy Pritchett writing in Compare the Cloud, concludes:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><strong><em>\u201cDespite concerns about the security of cloud storage, many businesses see that the cost savings, accessibility and disaster recovery are more valuable than the associated risks. Cloud storage is certainly here to stay for some time and worth considering for your company\u2019s infrastructure and budget.<\/em><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">Confused? Don\u2019t be. There is much knowledge, information and advice out there. Do your research, weigh up the pros and cons, there could be advantages for your company.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">There is no such confusion at whichwarehouse.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">We specialise in sourcing warehouse space &amp; logistics services within the UK and Ireland.\u00a0 Contact us for any requirements relating to storage, fulfilment and distribution.\u00a0 We even have access to industrial properties that are available for rent (short and long term) as well as office space on site (at some locations)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.whichwarehouse.com\/find-space.html\"><strong>Find space<\/strong><\/a><\/span> &#8211; Search and find shared-user warehouse space and properties from over 1,800 locations nationwide! All whichwarehouse locations offer associated logistics services, from basic pallet storage, through to end to end supply chain management. Including: receipt and despatch, pick and pack, rework activity, national transport, international freight and much, much more!<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\"><a style=\"color: #000000;\" href=\"https:\/\/www.whichwarehouse.com\/fill-space.html\"><strong><span style=\"color: #ff6600;\">Fill space<\/span><\/strong><\/a> &#8211; Is your warehouse or racking looking empty? Would you like to earn extra revenue by maximising your unutilised space? Then whichwarehouse can help.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">Our excellent website whichwarehouse.com, is dedicated to sourcing warehouse space and logistics services nationwide. We find organisations that need warehouse space and match them with companies that have warehouse space to fill. Sending out details of multiple warehouse opportunities nationally to members daily. We have multiple membership packages on offer to suit all budgets.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif; color: #000000;\">In a world driven by technology, whichwarehouse are not just another dotcom, we are on hand to communicate and provide free value added support and advice.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif;\"><strong style=\"color: #ff9900;\"><u>Contact whichwarehouse direct on:<\/u><\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial, helvetica, sans-serif;\"><strong style=\"color: #ff9900;\">Email: <a href=\"mailto:info@whichwarehouse.com\">info@whichwarehouse.com<\/a> or Free Phone: 0800 1707 555<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A data warehouse is an electronic system that gathers data from a wide range of sources within a company and uses the data&#8230;&nbsp;<span class=\"cmtcnt\">0<\/span><\/p>\n","protected":false},"author":136,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_wp_rev_ctl_limit":""},"categories":[91],"tags":[],"_links":{"self":[{"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/posts\/13391"}],"collection":[{"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/users\/136"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/comments?post=13391"}],"version-history":[{"count":0,"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/posts\/13391\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/media?parent=13391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/categories?post=13391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whichwarehouse.com\/blog\/wp-json\/wp\/v2\/tags?post=13391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}