{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,8,25]],"date-time":"2026-08-25T23:22:03Z","timestamp":1787700123505,"version":"build-2784847793"},"reference-count":19,"publisher":"Sociedade Brasileira de Computa\u00e7\u00e3o - SBC","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"abstract":"<jats:p>Banco de dados relacionais s\u00e3o largamente utilizados para armazenar dados de aplica\u00e7\u00f5es diversas. No entanto, apresentam limita\u00e7\u00f5es em cen\u00e1rios com alta escalabilidade e com dados semi-estruturados, abrindo espa\u00e7o para o uso de bancos NoSQL. Nestes cen\u00e1rios, abordagens para migrar dados entre bases relacionais e n\u00e3o relacionais s\u00e3o cruciais. Este artigo prop\u00f5em uma abordagem que gera rotinas de migra\u00e7\u00e3o de dados, usando LLMs (Large Language Models) para analisar metadados da base relacional e gerar esquema de destino NoSQL com base em um conjunto de consultas fornecido pelo usu\u00e1rio. Experimentos realizados para migrar uma base PostgreSQL para MongoDB mostraram a viabilidade da abordagem.<\/jats:p>","DOI":"10.5753\/sbbd.2025.247262","type":"proceedings-article","created":{"date-parts":[[2025,10,21]],"date-time":"2025-10-21T19:26:36Z","timestamp":1761074796000},"page":"441-454","source":"Crossref","is-referenced-by-count":1,"title":["Abordagem de migra\u00e7\u00e3o de bases relacionais para bases orientadas a documentos apoiada por LLM"],"prefix":"10.5753","author":[{"given":"Luan Felipe","family":"Marmentini","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-4040-0151","authenticated-orcid":false,"given":"Evandro Miguel","family":"Kuszera","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"3742","published-online":{"date-parts":[[2025,9,29]]},"reference":[{"key":"1","unstructured":"Brown, T. B., Mann, B., Ryder, N., Subbiah, M., Kaplan, J., Dhariwal, P., Neelakantan, A., Shyam, P., Sastry, G., Askell, A., Agarwal, S., Herbert-Voss, A., Krueger, G., Henighan, T., Child, R., Ramesh, A., Ziegler, D. M., Wu, J., Winter, C., Hesse, C., Chen, M., Sigler, E., Litwin, M., Gray, S., Chess, B., Clark, J., Berner, C., McCandlish, S., Radford, A., Sutskever, I., and Amodei, D. (2020). Language models are few-shot learners."},{"key":"2","doi-asserted-by":"crossref","unstructured":"Freitas, M. C. d., Souza, D. Y., and Salgado, A. C. (2016). Conceptual Mappings to Convert Relational into NoSQL Databases. In Proceedings of the 18th International Conference on Enterprise Information Systems, ICEIS 2016, page 174\u2013181, Setubal, PRT. SCITEPRESS - Science and Technology Publications, Lda.","DOI":"10.5220\/0005836301740181"},{"key":"3","doi-asserted-by":"crossref","unstructured":"Hamouda, S., Anbar, M., and Elejla, O. E. (2023). Normalization and denormalization for a document-oriented data. In ICAART (3), pages 972\u2013979.","DOI":"10.5220\/0011868100003393"},{"key":"4","doi-asserted-by":"crossref","unstructured":"Jia, T., Zhao, X., Wang, Z., Gong, D., and Ding, G. (2016). Model Transformation and Data Migration from Relational Database to MongoDB. In 2016 IEEE International Congress on Big Data (BigData Congress), pages 60\u201367.","DOI":"10.1109\/BigDataCongress.2016.16"},{"key":"5","doi-asserted-by":"crossref","unstructured":"Karnitis, G. and Arnicans, G. (2015). Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation. In 2015 7th International Conference on Computational Intelligence, Communication Systems and Networks, pages 113\u2013118.","DOI":"10.1109\/CICSyN.2015.30"},{"key":"6","doi-asserted-by":"crossref","unstructured":"Kuszera, E. M., Peres, L. M., and Didonet Del Fabro, M. (2022). Exploring data structure alternatives in the rdb to nosql document store conversion process. Information Systems, 105:101941.","DOI":"10.1016\/j.is.2021.101941"},{"key":"7","doi-asserted-by":"crossref","unstructured":"Lee, C. and Zheng, Y. (2015). SQL-to-NoSQL Schema Denormalization and Migration: A Study on Content Management Systems. In 2015 IEEE International Conference on Systems, Man, and Cybernetics, pages 2022\u20132026.","DOI":"10.1109\/SMC.2015.353"},{"key":"8","unstructured":"L\u00f3scio, B. F., OLIVEIRA, H. d., and PONTES, J. d. S. (2011). Nosql no desenvolvimento de aplica\u00e7\u00f5es web colaborativas. VIII Simp\u00f3sio Brasileiro de Sistemas Colaborativos, 10(1):11."},{"key":"9","unstructured":"Minaee, S., Mikolov, T., Nikzad, N., Chenaghlu, M., Socher, R., Amatriain, X., and Gao, J. (2025). Large language models: A survey."},{"key":"10","doi-asserted-by":"crossref","unstructured":"Mior, M. J., Salem, K., Aboulnaga, A., and Liu, R. (2016). NoSE: Schema design for NoSQL applications. In 2016 IEEE 32nd ICDE, pages 181\u2013192.","DOI":"10.1109\/ICDE.2016.7498239"},{"key":"11","unstructured":"Sadalage, P. and Fowler, M. (2013). NoSQL Essencial: Um Guia Conciso para o Mundo Emergente da Persist\u00eancia Poliglota. Novatec Editora."},{"key":"12","doi-asserted-by":"crossref","unstructured":"Santos, M. Y. and Costa, C. (2016). Data Models in NoSQL Databases for Big Data Contexts. In Tan, Y. and Shi, Y., editors, Data Mining and Big Data, pages 475\u2013485, Cham. Springer International Publishing.","DOI":"10.1007\/978-3-319-40973-3_48"},{"key":"13","doi-asserted-by":"crossref","unstructured":"Serrano, D., Han, D., and Stroulia, E. (2015). From Relations to Multi-dimensional Maps: Towards an SQL-to-HBase Transformation Methodology. In 2015 IEEE 8th International Conference on Cloud Computing, pages 81\u201389.","DOI":"10.1109\/CLOUD.2015.21"},{"key":"14","doi-asserted-by":"crossref","unstructured":"Stanescu, L., Brezovan, M., and Burdescu, D. D. (2016). Automatic mapping of MySQL databases to NoSQL MongoDB. In 2016 Federated Conference on Computer Science and Information Systems (FedCSIS), pages 837\u2013840.","DOI":"10.15439\/2016F45"},{"key":"15","unstructured":"Stonebraker, M., Madden, S., Abadi, D. J., Harizopoulos, S., Hachem, N., and Helland, P. (2007). The end of an architectural era (it\u2019s time for a complete rewrite). In Proceedings of the 33rd VLDB, University of Vienna, Austria, 2007, pages 1150\u20131160."},{"key":"16","doi-asserted-by":"crossref","unstructured":"Vajk, T., Feh\u00e9r, P., Fekete, K., and Charaf, H. (2013). Denormalizing data into schema-free databases. In 2013 IEEE 4th International Conference on Cognitive Infocommunications (CogInfoCom), pages 747\u2013752.","DOI":"10.1109\/CogInfoCom.2013.6719198"},{"key":"17","doi-asserted-by":"crossref","unstructured":"Xiang Li, Zhiyi Ma, and Hongjie Chen (2014). QODM: A query-oriented data modeling approach for NoSQL databases. In 2014 IEEE WARTIA, pages 338\u2013345.","DOI":"10.1109\/WARTIA.2014.6976265"},{"key":"18","doi-asserted-by":"crossref","unstructured":"Zhao, G., Li, L., Li, Z., and Lin, Q. (2014). Multiple Nested Schema of HBase for Migration from SQL. In 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing, pages 338\u2013343.","DOI":"10.1109\/3PGCIC.2014.127"},{"key":"19","doi-asserted-by":"crossref","unstructured":"Zhao, G., Lin, Q., Li, L., and Li, Z. (2014). Schema Conversion Model of SQL Database to NoSQL. In Proceedings of the 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing, 3PGCIC \u201914, page 355\u2013362, USA. IEEE Computer Society.","DOI":"10.1109\/3PGCIC.2014.137"}],"event":{"name":"Simp\u00f3sio Brasileiro de Banco de Dados","location":"Brasil","acronym":"SBBD 2025","number":"40"},"container-title":["Anais do XL Simp\u00f3sio Brasileiro de Banco de Dados (SBBD 2025)"],"original-title":[],"link":[{"URL":"https:\/\/sol.sbc.org.br\/index.php\/sbbd\/article\/download\/37256\/37039","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/sol.sbc.org.br\/index.php\/sbbd\/article\/download\/37256\/37039","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,21]],"date-time":"2025-10-21T19:29:57Z","timestamp":1761074997000},"score":1,"resource":{"primary":{"URL":"https:\/\/sol.sbc.org.br\/index.php\/sbbd\/article\/view\/37256"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,9,29]]},"references-count":19,"URL":"https:\/\/doi.org\/10.5753\/sbbd.2025.247262","relation":{},"subject":[],"published":{"date-parts":[[2025,9,29]]}}}