{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,4]],"date-time":"2026-03-04T08:17:45Z","timestamp":1772612265794,"version":"3.50.1"},"reference-count":34,"publisher":"MDPI AG","issue":"3","license":[{"start":{"date-parts":[[2026,3,2]],"date-time":"2026-03-02T00:00:00Z","timestamp":1772409600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100003725","name":"National Research Foundation of Korea","doi-asserted-by":"crossref","award":["RS-2025-02217071"],"award-info":[{"award-number":["RS-2025-02217071"]}],"id":[{"id":"10.13039\/501100003725","id-type":"DOI","asserted-by":"crossref"}]},{"name":"Institute of Information & Communications Technology Planning & Evaluation","award":["RS-2025-02305436"],"award-info":[{"award-number":["RS-2025-02305436"]}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Systems"],"abstract":"<jats:p>Integrating flood-response datasets across municipalities is often hindered by heterogeneous and non-standard variable names, a challenge amplified in Korean by local naming conventions and linguistic variation. This study addresses scalable schema alignment to standardize municipal flood datasets with reduced manual effort while maintaining semantic consistency for downstream modeling. We propose a BERT-based schema matching framework that augments standardized attribute names with paraphrases generated by a generative language model and filtered to reduce semantic drift. Both standardized and target variable names are encoded using a flood-domain-adapted Korean BERT model, and candidate correspondences are retrieved via cosine-similarity ranking to produce top-k match suggestions for automated or human-in-the-loop alignment. Experiments on real flood-related tables from Busan and Incheon, evaluated jointly to diversify variable expressions, show that augmentation substantially improves top-k retrieval accuracy. In the combined evaluation, Hit@5 improves from 0.71 to 0.95, supporting more reliable schema harmonization for simulation-ready inputs.<\/jats:p>","DOI":"10.3390\/systems14030267","type":"journal-article","created":{"date-parts":[[2026,3,2]],"date-time":"2026-03-02T14:06:56Z","timestamp":1772460416000},"page":"267","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["BERT-Based Schema Matching for Integrating Heterogeneous Flood Data: A Case Study in Korea"],"prefix":"10.3390","volume":"14","author":[{"ORCID":"https:\/\/orcid.org\/0009-0000-1052-0104","authenticated-orcid":false,"given":"Taeyoung","family":"Choe","sequence":"first","affiliation":[{"name":"Department of Computer Science and Engineering, Chung-Ang University, Seoul 06974, Republic of Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3018-8609","authenticated-orcid":false,"given":"Mincheol","family":"Shin","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Engineering, Chung-Ang University, Seoul 06974, Republic of Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kwangyoung","family":"Kim","sequence":"additional","affiliation":[{"name":"Department of Data Headquarters Strategy Team, Korea Institute of Science and Technology Information (KISTI), Daejeon 34141, Republic of Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Myungseok","family":"Yang","sequence":"additional","affiliation":[{"name":"Department of Data Headquarters Strategy Team, Korea Institute of Science and Technology Information (KISTI), Daejeon 34141, Republic of Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ka Lok","family":"Man","sequence":"additional","affiliation":[{"name":"School of Advanced Technology, Xi\u2019an Jiaotong-Liverpool University, Suzhou 215123, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mucheol","family":"Kim","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Engineering, Chung-Ang University, Seoul 06974, Republic of Korea"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1968","published-online":{"date-parts":[[2026,3,2]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","first-page":"132","DOI":"10.1016\/j.envsci.2017.11.016","article-title":"Urban Pluvial Flooding and Stormwater Management: A Contemporary Review of China\u2019s Challenges and \u201cSponge Cities\u201d Strategy","volume":"80","author":"Jiang","year":"2018","journal-title":"Env. Sci. Policy"},{"key":"ref_2","doi-asserted-by":"crossref","first-page":"522","DOI":"10.1002\/2014RG000464","article-title":"Future Changes to the Intensity and Frequency of Short-duration Extreme Rainfall","volume":"52","author":"Westra","year":"2014","journal-title":"Rev. Geophys."},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"823","DOI":"10.1016\/j.gloenvcha.2012.07.004","article-title":"Global Exposure to River and Coastal Flooding: Long Term Trends and Changes","volume":"22","author":"Jongman","year":"2012","journal-title":"Glob. Environ. Chang."},{"key":"ref_4","doi-asserted-by":"crossref","unstructured":"Li, C., Sun, N., Lu, Y., Guo, B., Wang, Y., Sun, X., and Yao, Y. (2022). Review on Urban Flood Risk Assessment. Sustainability, 15.","DOI":"10.3390\/su15010765"},{"key":"ref_5","doi-asserted-by":"crossref","first-page":"334","DOI":"10.1007\/s007780100057","article-title":"A Survey of Approaches to Automatic Schema Matching","volume":"10","author":"Rahm","year":"2001","journal-title":"VLDB J."},{"key":"ref_6","doi-asserted-by":"crossref","first-page":"158","DOI":"10.1109\/TKDE.2011.253","article-title":"Ontology Matching: State of the Art and Future Challenges","volume":"25","author":"Shvaiko","year":"2011","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"ref_7","doi-asserted-by":"crossref","first-page":"377","DOI":"10.1007\/s12145-019-00439-3","article-title":"An Ontology-Based Framework for Heterogeneous Data Management and Its Application for Urban Flood Disasters","volume":"13","author":"Wu","year":"2020","journal-title":"Earth Sci. Inf."},{"key":"ref_8","unstructured":"Koutras, C., Fragkoulis, M., Katsifodimos, A., and Lofi, C. (2020, January 30). REMA: Graph Embeddings-Based Relational Schema Matching. Proceedings of the EDBT\/ICDT Workshops, Copenhagen, Denmark."},{"key":"ref_9","unstructured":"H\u00e4ttasch, B., Truong-Ngoc, M., Schmidt, A., and Binnig, C. (2022). It\u2019s AI Match: A Two-Step Approach for Schema Matching Using Embeddings. arXiv."},{"key":"ref_10","doi-asserted-by":"crossref","first-page":"101943","DOI":"10.1016\/j.datak.2021.101943","article-title":"Leapme: Learning-Based Property Matching with Embeddings","volume":"137","author":"Ayala","year":"2022","journal-title":"Data Knowl. Eng."},{"key":"ref_11","unstructured":"Parciak, M., Vandevoort, B., Neven, F., Peeters, L.M., and Vansummeren, S. (2024). Schema Matching with Large Language Models: An Experimental Study. arXiv."},{"key":"ref_12","first-page":"100547","article-title":"Employing Word-Embedding for Schema Matching in Standard Lifecycle Management","volume":"38","author":"Oh","year":"2024","journal-title":"J. Ind. Inf. Integr."},{"key":"ref_13","unstructured":"Sheetrit, E., Brief, M., Mishaeli, M., and Elisha, O. (2024). Rematch: Retrieval Enhanced Schema Matching with LLMs. arXiv."},{"key":"ref_14","doi-asserted-by":"crossref","unstructured":"Kired, N.E., Ravat, F., Song, J., and Teste, O. (2024). Embedding-Based Data Matching for Disparate Data Sources. Proceedings of the International Conference on Big Data Analytics and Knowledge Discovery, Springer.","DOI":"10.1007\/978-3-031-68323-7_5"},{"key":"ref_15","first-page":"83","article-title":"Semantic Integration Research in the Database Community: A Brief Survey","volume":"26","author":"Doan","year":"2005","journal-title":"AI Mag."},{"key":"ref_16","doi-asserted-by":"crossref","unstructured":"Bellahsene, Z., Bonifati, A., and Rahm, E. (2011). Schema Matching and Mapping, Springer. [1st ed.].","DOI":"10.1007\/978-3-642-16518-4"},{"key":"ref_17","doi-asserted-by":"crossref","unstructured":"Do, H.-H., and Rahm, E. (2002). COMA\u2014A System for Flexible Combination of Schema Matching Approaches. Proceedings of the VLDB\u201902: Proceedings of the 28th International Conference on Very Large Databases, Elsevier.","DOI":"10.1016\/B978-155860869-6\/50060-3"},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1109\/TKDE.2007.250581","article-title":"Duplicate Record Detection: A Survey","volume":"19","author":"Elmagarmid","year":"2006","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"ref_19","doi-asserted-by":"crossref","unstructured":"Kedad, Z., and Xue, X. (2005). Mapping Discovery for XML Data Integration. Proceedings of the OTM Confederated International Conferences \u201cOn the Move to Meaningful Internet Systems\u201d, Springer.","DOI":"10.1007\/11575771_13"},{"key":"ref_20","first-page":"10","article-title":"BigGorilla: An Open-Source Ecosystem for Data Preparation and Integration","volume":"41","author":"Chen","year":"2018","journal-title":"IEEE Data Eng. Bull."},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"443","DOI":"10.1162\/dint_a_00058","article-title":"The Semantic Data Dictionary\u2013an Approach for Describing and Annotating Data","volume":"2","author":"Rashid","year":"2020","journal-title":"Data Intell."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"120405","DOI":"10.1016\/j.eswa.2023.120405","article-title":"A Semi-Automated Hybrid Schema Matching Framework for Vegetation Data Integration","volume":"229","author":"Hossain","year":"2023","journal-title":"Expert. Syst. Appl."},{"key":"ref_23","doi-asserted-by":"crossref","unstructured":"Wu, K., Zhang, J., and Ho, J.C. (2023). CONSchema: Schema Matching with Semantics and Constraints. Proceedings of the European Conference on Advances in Databases and Information Systems, Springer.","DOI":"10.1007\/978-3-031-42941-5_21"},{"key":"ref_24","doi-asserted-by":"crossref","unstructured":"Pan, Z., Pan, G., and Monti, A. (2022). Semantic-Similarity-Based Schema Matching for Management of Building Energy Data. Energies, 15.","DOI":"10.3390\/en15238894"},{"key":"ref_25","doi-asserted-by":"crossref","unstructured":"Mukherjee, D., Bandyopadhyay, A., Chowdhury, R., and Bhattacharya, I. (2021). Learning Knowledge Graph for Target-Driven Schema Matching. Proceedings of the 3rd ACM India Joint International Conference on Data Science & Management of Data (8th ACM IKDD CODS & 26th COMAD), ACM.","DOI":"10.1145\/3430984.3431013"},{"key":"ref_26","doi-asserted-by":"crossref","unstructured":"Narayan, A., Chami, I., Orr, L., Arora, S., and R\u00e9, C. (2022). Can Foundation Models Wrangle Your Data?. arXiv.","DOI":"10.14778\/3574245.3574258"},{"key":"ref_27","unstructured":"Devlin, J., Chang, M.-W., Lee, K., and Toutanova, K. (2019). BERT: Pre-Training of Deep Bidirectional Transformers for Language Understanding. Proceedings of the 2019 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, Volume 1 (Long and Short Papers), Association for Computational Linguistics."},{"key":"ref_28","unstructured":"Vaswani, A., Shazeer, N., Parmar, N., Uszkoreit, J., Jones, L., Gomez, A.N., Kaiser, \u0141., and Polosukhin, I. (2017). Attention Is All You Need. Adv. Neural Inf. Process Syst., 30."},{"key":"ref_29","doi-asserted-by":"crossref","unstructured":"Pires, T., Schlinger, E., and Garrette, D. (2019). How Multilingual Is Multilingual BERT?. arXiv.","DOI":"10.18653\/v1\/P19-1493"},{"key":"ref_30","doi-asserted-by":"crossref","first-page":"1234","DOI":"10.1093\/bioinformatics\/btz682","article-title":"BioBERT: A Pre-Trained Biomedical Language Representation Model for Biomedical Text Mining","volume":"36","author":"Lee","year":"2020","journal-title":"Bioinformatics"},{"key":"ref_31","doi-asserted-by":"crossref","unstructured":"Lee, S., Jang, H., Baik, Y., Park, S., and Shin, H. (2020). Kr-Bert: A Small-Scale Korean-Specific Language Model. arXiv.","DOI":"10.5626\/JOK.2020.47.7.682"},{"key":"ref_32","unstructured":"Brain, S.K.T. (2026, February 10). KoBERT: Korean BERT Pre-Trained Cased 2019. GitHub repository. Available online: https:\/\/github.com\/SKTBrain\/KoBERT."},{"key":"ref_33","doi-asserted-by":"crossref","first-page":"155","DOI":"10.1017\/S1351324916000334","article-title":"Word2Vec","volume":"23","author":"Church","year":"2017","journal-title":"Nat. Lang. Eng."},{"key":"ref_34","doi-asserted-by":"crossref","unstructured":"Feng, F., Yang, Y., Cer, D., Arivazhagan, N., and Wang, W. (2022). Language-Agnostic BERT Sentence Embedding. Proceedings of the Proceedings of the 60th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), Association for Computational Linguistics.","DOI":"10.18653\/v1\/2022.acl-long.62"}],"container-title":["Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2079-8954\/14\/3\/267\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,3,4]],"date-time":"2026-03-04T05:17:18Z","timestamp":1772601438000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2079-8954\/14\/3\/267"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,3,2]]},"references-count":34,"journal-issue":{"issue":"3","published-online":{"date-parts":[[2026,3]]}},"alternative-id":["systems14030267"],"URL":"https:\/\/doi.org\/10.3390\/systems14030267","relation":{},"ISSN":["2079-8954"],"issn-type":[{"value":"2079-8954","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,3,2]]}}}