Analysis of the possibility of managing the database stored in the cloud
Rafał Góźdź
rafal.gozdz@pollub.edu.plLublin University of Technology (Poland)
Maria Skublewska-Paszkowska
Lublin University of Technology (Poland)
Abstract
The article presents a comparative analysis of the performance of selected database systems. The time of execution of SQL statements has been compared by prepared database service which are running in the cloud. Prepared Northwind database running on SQL Server has been moved to systems Oracle and PostgreSQL, and then three of these bases have been placed in the cloud Microsoft Azure. The research process was divided into three stages. Firstly, queries with Select are analyzed. In the second stage, the analysis focuses on the performance of SQL DDL, and the final stage of the analysis describes the SQL DML.
Keywords:
cloud computing; database; performance analysisReferences
[1] Peter Mell, Timothy Grance, The NIST Definition of Cloud Computing, http://nvlpubs.nist.gov/nistpubs/Legacy/SP/nistspecialpublicatio
n800-145.pdf, [11.09.2016]
[2] Daniel J. Abadi, Data Management in the Cloud: Limitations and Opportunitie, strony 2-5 , Yale University 2009.
[3] Ben Kepes, Understanding the Cloud Computing Stack: SaaS, PaaS, IaaS, https://support.rackspace.com/whitepaper/understanding-the-cloud-computing-stack-saas-paasiaas/, [11.09.2016]
[4] Scott Zhang, Install and configure PostgreSQL on Azure, https://azure.microsoft.com/plpl/documentation/articles/virtual-machines-linux-postgresqlinstall/, [11.09.2016]
[5] Andrzej Klusiewicz, Kurs Oracle, http://andrzejklusiewicz.blogspot.com/2010/11/kurs-oracle-sqlpodstawowe-definicje.html, [11.09.2016]
[6] Lech Banchowski, Realizacja SZBD w SQL Server, http://edu.pjwstk.edu.pl/wyklady/szb/scb/wyklad15/w15.htm, [11.09.2016]
[7] Pentaho Data Integration manual, http://www.pentaho.pl/kettleetl.html. [11.09.2016]
[8] T. Redkar, T. Guidici, Platforma Windows Azure, Helion 2013.
[9] Rob Boucher, Introducing Microsoft Azure, https://azure.microsoft.com/en-us/documentation/articles/fundamentals-introduction-to-azure, [11.09.2016]
n800-145.pdf, [11.09.2016]
[2] Daniel J. Abadi, Data Management in the Cloud: Limitations and Opportunitie, strony 2-5 , Yale University 2009.
[3] Ben Kepes, Understanding the Cloud Computing Stack: SaaS, PaaS, IaaS, https://support.rackspace.com/whitepaper/understanding-the-cloud-computing-stack-saas-paasiaas/, [11.09.2016]
[4] Scott Zhang, Install and configure PostgreSQL on Azure, https://azure.microsoft.com/plpl/documentation/articles/virtual-machines-linux-postgresqlinstall/, [11.09.2016]
[5] Andrzej Klusiewicz, Kurs Oracle, http://andrzejklusiewicz.blogspot.com/2010/11/kurs-oracle-sqlpodstawowe-definicje.html, [11.09.2016]
[6] Lech Banchowski, Realizacja SZBD w SQL Server, http://edu.pjwstk.edu.pl/wyklady/szb/scb/wyklad15/w15.htm, [11.09.2016]
[7] Pentaho Data Integration manual, http://www.pentaho.pl/kettleetl.html. [11.09.2016]
[8] T. Redkar, T. Guidici, Platforma Windows Azure, Helion 2013.
[9] Rob Boucher, Introducing Microsoft Azure, https://azure.microsoft.com/en-us/documentation/articles/fundamentals-introduction-to-azure, [11.09.2016]
Góźdź, R., & Skublewska-Paszkowska, M. (2016). Analysis of the possibility of managing the database stored in the cloud . Journal of Computer Sciences Institute, 2, 127–132. https://doi.org/10.35784/jcsi.128
Authors
Maria Skublewska-PaszkowskaLublin University of Technology Poland
Statistics
Abstract views: 278PDF downloads: 98
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
