KSII Transactions on Internet and Information Systems (TIIS)

Korean Society for Internet Information (한국인터넷정보학회)
권호 표지
DOI QR코드

DOI QR Code

A Study on The Conversion Factor between Heterogeneous DBMS for Cloud Migration

  • Joonyoung Ahn (Department of IT Policy and Management, Graduated School of Soongsil University) ;
  • Kijung Ryu (Department of IT Policy and Management, Graduated School of Soongsil University) ;
  • Changik Oh (Department of IT Policy and Management, Graduated School of Soongsil University) ;
  • Taekryong Han (Department of IT Policy and Management, Graduated School of Soongsil University) ;
  • Heewon Kim (Global School of Media, Soongsil University) ;
  • Dongho Kim (Global School of Media, Soongsil University)
  • Received : 2024.04.08
  • Accepted : 2024.06.03
  • Published : 2024.08.31
Download PDF
⟨ Previous Next ⟩

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.

Keywords

Acknowledgement

This work was supported by Innovative Human Resource Development for Local Intellectualization program through the Institute of Information & Communications Technology Planning & Evaluation(IITP) grant funded by the Korea government(MSIT)(IITP-2024-RS-2022-00156360)

References

  1. Kopackova, Hana, and Sann Thawdar Htoo, "Cloud Computing Services - Emerging Trends During the Times of Pandemic," in Proc. of 2023 18th Iberian Conference on Information Systems and Technologies (CISTI), pp.1-6, 2023.
  2. Chen, Mei et al., "Net and configurational effects of determinants on cloud computing adoption by SMEs under cloud promotion policy using PLS-SEM and fsQCA," Journal of Innovation & Knowledge, vol.8, no.3, 2023.
  3. Ranganathan, Chitra Sabapathy, and Rajeshkumar Sampathrajan, "Cloud Migration Meets Targeted Deadlines," in Proc. of 2023 4th International Conference on Electronics and Sustainable Communication Systems (ICESC), pp.672-676, 2023.
  4. Ahmadi, Sina, "Elastic Data Warehousing: Adapting To Fluctuating Workloads With Cloud-Native Technologies," Journal of Knowledge Learning and Science Technology, vol.2, no.3, pp.282-301, 2023.
  5. L'Esteve, Ron C., "Influencing Change and Driving Cloud Adoption," The Cloud Leader's Handbook: Strategically Innovate, Transform, and Scale Organizations. Berkeley, pp.13-30, 2023.
  6. Muhammad, Tayyab, "A Comprehensive Study on Software-Defined Load Balancers: Architectural Flexibility & Application Service Delivery in On- Premises Ecosystems," International Journal of Computer Science and Technology (IJCST), vol.6, no.1, pp. 1-24, 2022.
  7. Fahmideh, Mahdi et al., "A generic cloud migration process model," European Journal of Information Systems, vol.28, no.3, pp.233-255, 2019.
  8. Parvathy, L. Rama, "A Comprehensive Analysis of Cloud Migration Strategies: Efficiency Comparison of Trickle, Big Bang, Refactoring, Lift and Shift, Replatforming Approaches," in Proc. of 2023 9th International Conference on Smart Structures and Systems (ICSSS), pp.1-7, 2023.
  9. Jonghei Ra, "A Guideline for Hardware Sizing of Information Systems," TTA Journal, vol.172, pp.80-82, 2017.
  10. Jonghei Ra, "A Guideline for Hardware Sizing of Information Systems," Telecommunications Technology Association, pp.1-50, 2018.
  11. Jonghei Ra, Kwangdon Choi, "A Study on the Capacity Calculation Method for Estimating the Size of Information System Introduction," Korea Association of Information Systems, pp.307-313, 2005.
  12. Transaction Processing Performance Council, TPC BenchmarkTM H Standard Specification Revision 3.0.1, 2022.
  13. Min, Jae-H., Sungwoo Chang, and Kyung-shik Shin, "A Hybrid Approach to Information System Sizing and Selection using Simulation and Genetic Algorithm," Korean Management Science Review, vol.24, no.2, pp.143-155, 2007.
  14. Elnaffar, Said et al., "Is it DSS or OLTP: automatically identifying DBMS workloads," Journal of Intelligent Information Systems, vol.30, pp.249-271, 2008.
  15. Gini, Corrado, "Tables of Random Permutations by Lincoln E. Moses, Robert V. Oakford," Journal of the American Statistical Association, vol.58, no.303, pp.870-871, Sep. 1963.