The Benefits of Enterprise Data Warehouse Implementation in Cloud vs. On-premises
DOI:
https://doi.org/10.54820/DMZS9230Keywords:
cloud, on-premises, enterprise, application, data warehouseAbstract
When we think about running enterprise applications on-premises, enterprises do two things for their servers, databases, and storage. Enterprises provision for peaks and put a lot of infrastructures to handle peak demand, although a lot of this capacity is not used at normal times. The other thing is a few instances that each application needs to have, typically between five and six. Multiplying this number by many times due to various applications causes a lot of costs and creates capacity that is not used. For such reasons, the enterprise applications in the cloud seem reasonable. In the cloud, two things are possible again. Instead of overprovisioning for peaks, enterprises can scale the capacity on on-demand and spin up instances on demand. This means a certain amount of cost-saving by running at a normal level instead of overprovisioning. In this paper, various factors will be considered, and the benefits for enterprise data warehouse implementation in the cloud vs. on-premises will be stated.
References
Agrawal, D., El Abbadi, A., Das, S., Elmore, A. J. (2011), Database scalability, elasticity, and autonomy in the cloud, in International Conference on Database Systems for Advanced Applications, Springer, Berlin, Heidelberg.
Alouffi, B., Hasnain, M., Alharbi, A., Alosaimi, W., Alyami, H., Ayaz, M. (2021), “A Systematic Literature Review on Cloud Computing Security: Threats and Mitigation Strategies”, IEEE Access, Vol. 9, pp. 57792-57807.
Bailey, M., Kanthan, C. (2020), “Cloud Growth, Migration, and Repatriation Continue to Gain Momentum. IDC Study”, available at: https://www.idc.com/getdoc.jsp?containerId=US46119020 (1 May 2021)
Brumec, S., Vrček, N. (2013), “Cost effectiveness of commercial computing clouds”, Information Systems, Vol. 38 No. 4, pp. 495-508.
Chen, X. (2004), “E-Business Data Warehouse Design and Implementation”, available at: http://iceb.johogo.com/proceedings/2004/Paper/CN073-paper.pdf (1 May 2021)
Dageville, B., Cruanes, T., Zukowski, M., Antonov, V., Avanes, A., Bock, J., Unterbrunner, P. (2016), “The snowflake elastic data warehouse”, in Proceedings of the 2016 International Conference on Management of Data, pp. 215-226.
Davenport, T. H., Dyché, J. (2013), “Big data in big companies”, International Institute for Analytics, Vol. 3, pp. 1-31.
EM360 Tech (2020), “Top 10 Cloud Data Warehouse Solution Providers”, available at: https://em360tech.com/data_management/tech-features-featuredtech-news/top-10-cloud-data-warehouse-solution-providers (7 April 2021)
European Commission (2021), “Shaping Europe’s digital future”, available at: https://digital-strategy.ec.europa.eu/en/policies/cloud-computing (8 July 2021)
Eurostat (2021), “Cloud computing - statistics on the use by enterprises”, available at: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Cloud_computing_-_statistics_on_the_use_by_enterprises (8 July 2021)
Gartner (2021), “When Cloud Meets COVID-19: Threats and Opportunities”, available at: https://www.gartner.com/en/conferences/hub/cloud-conferences/insights/when-cloud-meets-covid-19-threats-opportunities (6 July 2021)
Kaur, H., Agrawal, P., Dhiman, A. (2012), “Visualizing clouds on different stages of DWH-an introduction to data warehouse as a service”, in 2012 International Conference on Computing Sciences, IEEE, Phagwara, pp. 356-359.
Kurunji, S., Ge, T., Liu, B., Chen, C. X. (2012), “Communication cost optimization for cloud Data Warehouse queries”, in 4th IEEE International Conference on Cloud Computing Technology and Science Proceedings, IEEE, Taipei, pp. 512-519.
Nemati, H. R., Steiger, D. M., Iyer, L. S., Herschel, R. T. (2002), “Knowledge warehouse: an architectural integration of knowledge management, decision support, artificial intelligence and data warehousing”, Decision Support Systems, Vol. 33 No. 2, pp. 143-161.
Oracle (2021), “Data Warehouse In The Cloud, Bringing Decades of Data Management Innovations to the Cloud”, available at: https://www.oracle.com/a/ocom/docs/data-warehouse-in-the-cloud-brief-3157435.pdf (1 June 2021)
Pragmatic Works (2019), “On Premise vs Cloud Modern Data Warehouse”, available at: https://www.youtube.com/watch?v=i4t8c3K58Fo (31 May 2021)
Ramakrishna, R. (2021), “Data Warehouse 4.0 - Reimagining Data Warehouse for Cloud & Big Data”, available at: https://canvas.lntinfotech.com/images/PolarSled/WhitePapers/Data-Warehouse-4.0_Canvas-PolarSled-WP.pdf (7 July 2021)
Roberts, P. (2021), “Why is Cloud Repatriation Happening? Real-Time Insights”, available at: https://www.rtinsights.com/why-is-cloud-repatriation-happening (17 July 2021).
SeattleDataGuy (2020), “What Are the Benefits of Cloud Data Warehousing?”, available at: https://medium.com/smb-lite/what-are-the-benefits-of-cloud-data-warehousing-a7322947a479 (1 June 2021)
Shaikh, A. H., Meshram, B. B. (2021), “Security issues in cloud computing”, in Intelligent Computing and Networking, Springer, Singapore, pp. 63-77.
Shakhovska, N., Boyko, N., Pukach, P. (2018), “The Information Model of Cloud Data Warehouses”, in Advances in Intelligent Systems and Computing III, pp. 182-191.
Singh, R. P., Haleem, A., Javaid, M., Kataria, R., Singhal, S. (2021), “Cloud Computing in Solving Problems of COVID-19 Pandemic”, Journal of Industrial Integration and Management, Vol. 6 No. 2, pp. 209-219.
Talend (2021), “8 Benefits of a Cloud Data Warehouse”, available at: https://www.talend.com/resources/cloud-data-warehouse-benefits (10 May 2021)
Vaishnav, J., Prasad, N. H. (2021), “Security Aspects in Cloud Tools and Its Analysis - A Study”, in Inventive Systems and Control, Springer, Singapore, pp. 927-937.
Vaisman, A., Zimányi, E. (2014), “Data warehouse systems”, Springer.
Ying, Z., Yong, S. (2009), “Cloud storage management technology”, in 2009 Second International Conference on Information and Computing Science, IEEE Manchester, pp. 309-311.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2021 ENTRENOVA - ENTerprise REsearch InNOVAtion
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
