COMPARATIVE ANALYSIS OF ON PREMISES SERVER, CLOUD DATABASE AND CLOUD VIRTUAL MACHINE
analyzeit - updated on March 27, 2024 . 3 Min Read
Objectives of this study
Comparing performance between three platforms, on premises server, cloud database and cloud virtual machine.
Aim of this study
- To determine which platform is quicker
- Which platform perform better with different query types
- Which platform is more agile.
- Slow down factor between traditional and cloud database for different entries
- To determine which platform perform better with different query types the following result answers that.
The above fig shows us the performance of each platform during the updating process of the each database for each records and the speed of the updating process is shown in milliseconds. We observe that for 100,000 record update the cloud virtual machine performs faster followed by on premises server and then cloud database. While for 500,000 update the cloud virtual machine performs quicker than the remaining platforms and for the 1,000,000 record update the cloud virtual machine still performs better. The cloud virtual machine performs better across the different queries.
The above descriptive statistics shows the average time for each platform to perform the update query and it shows that for 100,000, 500,000, and 1,000,000 records the cloud database performed faster among all platforms.
Multiple Comparisons Tukey HSD
From the above table 2 we can see that there is significant difference in the average updating time for each of the platforms. We observe this through our p values (0.001) which is smaller than our level of significance (0.05). From table 1 above we also see that VM has the lowest mean speed of updating to the database therefore making VM faster and perform better A tukey post hoc test revealed that the time (milliseconds) to complete the query was statistically significant
The above fig shows us the performance of each platform during the updating process of the each database for each records and the speed of the updating process is shown in milliseconds. We observe that for reading 100,000 record, the cloud database performs faster followed by cloud virtual machine and then On Premises server. While for 500,000 record the cloud database performs slower than the remaining platforms and for the 1,000,000 record update the cloud virtual machine still performs better. The cloud virtual machine performs better across two read queries.
The above graph answers the question of which platform performs better across the different queries we can see that the cloud virtual machine performs better across the three queries because it is faster and agile.