Analysis of the possibility of managing the database stored in the cloud


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 analysis

[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]

Published : 2016-12-30


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

Rafał Góźdź  rafal.gozdz@pollub.edu.pl
Lublin University of Technology  Poland
Maria Skublewska-Paszkowska 
Lublin University of Technology  Poland