@article{ART003383515},
author={Dong-Bin Lim and Eun-jin Oh and Kim Jae Woong},
title={An LLM-Assisted Heterogeneous DBMS Migration Model},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2026},
volume={31},
number={9},
pages={135-142}
TY - JOUR
AU - Dong-Bin Lim
AU - Eun-jin Oh
AU - Kim Jae Woong
TI - An LLM-Assisted Heterogeneous DBMS Migration Model
JO - Journal of The Korea Society of Computer and Information
PY - 2026
VL - 31
IS - 9
PB - The Korean Society Of Computer And Information
SP - 135
EP - 142
SN - 1598-849X
AB - This study proposes an LLM-assisted migration model for heterogeneous DBMS environments that integrates T0-based initial loading, LLM-based SQL transformation and normalization, deterministic SQL post-processing, and CDC-based synchronization. Unlike prior studies that treat SQL dialect translation, LLM-based SQL generation, and change replication separately, the proposed model combines these functions in a single migration workflow. Source metadata and object definitions are embedded in DBMS-pair-specific prompts, and executable SQL is extracted and corrected before target application. MariaDB-to-PostgreSQL validation confirmed table loading, procedural-object transformation, CDC application, checkpoint management, and execution logging. Source and target row counts matched for four tables containing 2,980 rows; two procedures, two functions, and two triggers were applied without SQL execution errors; and all 162 CDC events were processed without failure. No manual SQL correction was required, and total processing time was 449.328 seconds. Academically, the model structures LLM-based SQL transformation as a post-processed migration workflow; practically, it reduces manual correction and improves traceability.
Future work will evaluate additional DBMS pairs, LLMs, recovery behavior, and larger workloads.
KW - Heterogeneous DBMS Migration;LLM;SQL Transformation;CDC;Procedural Objects
DO -
UR -
ER -
Dong-Bin Lim, Eun-jin Oh and Kim Jae Woong. (2026). An LLM-Assisted Heterogeneous DBMS Migration Model. Journal of The Korea Society of Computer and Information, 31(9), 135-142.
Dong-Bin Lim, Eun-jin Oh and Kim Jae Woong. 2026, "An LLM-Assisted Heterogeneous DBMS Migration Model", Journal of The Korea Society of Computer and Information, vol.31, no.9 pp.135-142.
Dong-Bin Lim, Eun-jin Oh, Kim Jae Woong "An LLM-Assisted Heterogeneous DBMS Migration Model" Journal of The Korea Society of Computer and Information 31.9 pp.135-142 (2026) : 135.
Dong-Bin Lim, Eun-jin Oh, Kim Jae Woong. An LLM-Assisted Heterogeneous DBMS Migration Model. 2026; 31(9), 135-142.
Dong-Bin Lim, Eun-jin Oh and Kim Jae Woong. "An LLM-Assisted Heterogeneous DBMS Migration Model" Journal of The Korea Society of Computer and Information 31, no.9 (2026) : 135-142.
Dong-Bin Lim; Eun-jin Oh; Kim Jae Woong. An LLM-Assisted Heterogeneous DBMS Migration Model. Journal of The Korea Society of Computer and Information, 31(9), 135-142.
Dong-Bin Lim; Eun-jin Oh; Kim Jae Woong. An LLM-Assisted Heterogeneous DBMS Migration Model. Journal of The Korea Society of Computer and Information. 2026; 31(9) 135-142.
Dong-Bin Lim, Eun-jin Oh, Kim Jae Woong. An LLM-Assisted Heterogeneous DBMS Migration Model. 2026; 31(9), 135-142.
Dong-Bin Lim, Eun-jin Oh and Kim Jae Woong. "An LLM-Assisted Heterogeneous DBMS Migration Model" Journal of The Korea Society of Computer and Information 31, no.9 (2026) : 135-142.
