Vol. 18, No. 8, August 31, 2024
10.3837/tiis.2024.08.022,
Download Paper (Free):
Abstract
Many legacy information systems are currently being clouded. This is due to the advantage of being able to respond flexibly to the changes in user needs and system environment while reducing the initial investment cost of IT infrastructure such as servers and storage. The infrastructure of the information system migrated to the cloud is being integrated through the API connections, while being subdivided by using MSA (Micro Service Architecture) internally. DBMS (Database Management System) is also becoming larger after cloud migration. Scale calculation in most layers of the application architecture can be measured and calculated from auto-scaling perspective, but the method of hardware scale calculation for DBMS has not been established as standardized methodology. If there is an error in hardware scale calculation of DBMS, problems such as poor performance of the information system or excessive auto-scaling may occur. In addition, evaluating hardware size is more crucial because it also affects the financial cost of the migration.
CPU is the factor that has the greatest influence on hardware scale calculation of DBMS. Therefore, this paper aims to calculate the conversion factor for CPU scale calculation that will facilitate the cloud migration between heterogeneous DBMS. In order to do that, we utilize the concept and definition of hardware capacity planning and scale calculation in the on-premise information system. The methods to calculate the conversion factor using TPC-H tests are proposed and verified. In the future, further research and testing should be conducted on the size of the segmented CPU and more heterogeneous DBMS to demonstrate the effectiveness of the proposed test model.
Statistics
Show / Hide Statistics
Statistics (Cumulative Counts from December 1st, 2015)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.
Cite this article
[IEEE Style]
J. Ahn, K. Ryu, C. Oh, T. Han, H. Kim, D. Kim, "A Study on The Conversion Factor between Heterogeneous DBMS for Cloud Migration," KSII Transactions on Internet and Information Systems, vol. 18, no. 8, pp. 2450-2462, 2024. DOI: 10.3837/tiis.2024.08.022.
[ACM Style]
Joonyoung Ahn, Kijung Ryu, Changik Oh, Taekryong Han, Heewon Kim, and Dongho Kim. 2024. A Study on The Conversion Factor between Heterogeneous DBMS for Cloud Migration. KSII Transactions on Internet and Information Systems, 18, 8, (2024), 2450-2462. DOI: 10.3837/tiis.2024.08.022.
[BibTeX Style]
@article{tiis:101110, title="A Study on The Conversion Factor between Heterogeneous DBMS for Cloud Migration", author="Joonyoung Ahn and Kijung Ryu and Changik Oh and Taekryong Han and Heewon Kim and Dongho Kim and ", journal="KSII Transactions on Internet and Information Systems", DOI={10.3837/tiis.2024.08.022}, volume={18}, number={8}, year="2024", month={August}, pages={2450-2462}}