Consulta multilíngue em banco de dados relacionais: Uma revisão sistemática
Resumo
Para recuperar informações multilíngues armazenadas em bancos de dados relacionais, tradicionalmente a consulta inicial precisa ser reescrita em outros idiomas a fim de obter os resultados pretendidos. Este artigo apresenta uma revisão sistemática dos métodos de pré-processamento e tradução da consulta. A consulta multilíngue possibilita que uma pessoa sem conhecimento da linguagem de consulta estruturada (SQL) ou da estrutura do banco de dados submeta consultas utilizando linguagem natural ou palavras-chave em uma linguagem L1 e obtenha resultados na linguagem L2. De tal modo, pode-se, por exemplo, realizar consultas em Português obtendo resultados em outro idioma. Foi considerado as publicações dos u´ltimos cinco anos (2015-2019) indexadas por seis bases científicas reconhecidas internacionalmente.
Palavras-chave:
Bancos de dados relacionais, multilíngues, bancos de dados, revisão sistemática
Referências
Banerjee, S. and Lavie, A. (2005). METEOR: An automatic metric for MT evalua- tion with improved correlation with human judgments. In Proceedings of the ACL Workshop on Intrinsic and Extrinsic Evaluation Measures for Machine Translation and/or Summarization, pages 65–72, Ann Arbor, Michigan. Association for Computa- tional Linguistics.
Chandra, G. and Dwivedi, S. K. (2019). Query expansion for effective retrieval results of hindi–english cross-lingual IR. Applied Artificial Intelligence, 33(7):567–593.
Choudhary, M., Dua, M., and Virk, Z. S. (2015). A web-based bilingual natural language interface to database. In 2015 Third International Conference on Image Information Processing (ICIIP). IEEE.
Doddington, G. (2002). Automatic evaluation of machine translation quality using n- gram co-occurrence statistics. In Proceedings of the Second International Conference on Human Language Technology Research, HLT ’02, pages 138–145, San Francisco, CA, USA. Morgan Kaufmann Publishers Inc.
Madankar, M., Chandak, M., and Chavhan, N. (2016). Information retrieval system and machine translation: A review. Procedia Computer Science, 78:845–850.
Papineni, K., Roukos, S., Ward, T., and Zhu, W.-J. (2002). Bleu: A method for automatic evaluation of machine translation. In Proceedings of the 40th Annual Meeting on As- sociation for Computational Linguistics, ACL ’02, pages 311–318, Stroudsburg, PA, USA. Association for Computational Linguistics.
Poibeau, T. (2017). Machine Translation. The MIT Press Essential Knowledge Series, London, England, 1 edition.
Posevkin, R. and Bessmertny, I. (2016). Multilanguage natural user interface to data- base. In 2016 IEEE 10th International Conference on Application of Information and Communication Technologies (AICT). IEEE.
Rahmani, A. (2017). Adapting google translate for english-persian cross-lingual informa- tion retrieval in medical domain. In 2017 Artificial Intelligence and Signal Processing Conference (AISP). IEEE.
Satyamurty, C. V. S., Murthy, J. V. R., and Raghava, M. (2018). Metadata-based semantic query in multilingual databases. In Advances in Intelligent Systems and Computing, pages 249–255. Springer Singapore.
Singla, K., Dua, M., and Nanda, G. (2016). A language based comparison of different similarity functions and classifiers using web based bilingual question answering sys- tem developed using machine learning approach. In Proceedings of the Second Inter- national Conference on Information and Communication Technology for Competitive Strategies - ICTCS 16. ACM Press.
Thenmozhi, D. and Aravindan, C. (2018). Ontology-based tamil-english cross-lingual information retrieval system. Sa¯dhana¯, 43(10).
Valiveti, S., Tripathi, K., and Raval, G. (2017). Natural language interface for multilin- gual database. In Information and Communication Technology for Intelligent Systems (ICTIS 2017) - Volume 2, pages 113–120. Springer International Publishing.
Virk, Z. and Dua, M. (2017). An advanced web-based bilingual domain independent interface to database using machine learning approach. In Advances in Intelligent Systems and Computing, pages 581–589. Springer Singapore.
Chandra, G. and Dwivedi, S. K. (2019). Query expansion for effective retrieval results of hindi–english cross-lingual IR. Applied Artificial Intelligence, 33(7):567–593.
Choudhary, M., Dua, M., and Virk, Z. S. (2015). A web-based bilingual natural language interface to database. In 2015 Third International Conference on Image Information Processing (ICIIP). IEEE.
Doddington, G. (2002). Automatic evaluation of machine translation quality using n- gram co-occurrence statistics. In Proceedings of the Second International Conference on Human Language Technology Research, HLT ’02, pages 138–145, San Francisco, CA, USA. Morgan Kaufmann Publishers Inc.
Madankar, M., Chandak, M., and Chavhan, N. (2016). Information retrieval system and machine translation: A review. Procedia Computer Science, 78:845–850.
Papineni, K., Roukos, S., Ward, T., and Zhu, W.-J. (2002). Bleu: A method for automatic evaluation of machine translation. In Proceedings of the 40th Annual Meeting on As- sociation for Computational Linguistics, ACL ’02, pages 311–318, Stroudsburg, PA, USA. Association for Computational Linguistics.
Poibeau, T. (2017). Machine Translation. The MIT Press Essential Knowledge Series, London, England, 1 edition.
Posevkin, R. and Bessmertny, I. (2016). Multilanguage natural user interface to data- base. In 2016 IEEE 10th International Conference on Application of Information and Communication Technologies (AICT). IEEE.
Rahmani, A. (2017). Adapting google translate for english-persian cross-lingual informa- tion retrieval in medical domain. In 2017 Artificial Intelligence and Signal Processing Conference (AISP). IEEE.
Satyamurty, C. V. S., Murthy, J. V. R., and Raghava, M. (2018). Metadata-based semantic query in multilingual databases. In Advances in Intelligent Systems and Computing, pages 249–255. Springer Singapore.
Singla, K., Dua, M., and Nanda, G. (2016). A language based comparison of different similarity functions and classifiers using web based bilingual question answering sys- tem developed using machine learning approach. In Proceedings of the Second Inter- national Conference on Information and Communication Technology for Competitive Strategies - ICTCS 16. ACM Press.
Thenmozhi, D. and Aravindan, C. (2018). Ontology-based tamil-english cross-lingual information retrieval system. Sa¯dhana¯, 43(10).
Valiveti, S., Tripathi, K., and Raval, G. (2017). Natural language interface for multilin- gual database. In Information and Communication Technology for Intelligent Systems (ICTIS 2017) - Volume 2, pages 113–120. Springer International Publishing.
Virk, Z. and Dua, M. (2017). An advanced web-based bilingual domain independent interface to database using machine learning approach. In Advances in Intelligent Systems and Computing, pages 581–589. Springer Singapore.
Publicado
22/11/2019
Como Citar
VIEIRA, Robson C.; DA SILVA, João C..
Consulta multilíngue em banco de dados relacionais: Uma revisão sistemática. In: ESCOLA REGIONAL DE INFORMÁTICA DE GOIÁS (ERI-GO), 7. , 2019, Goiânia.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2019
.
p. 21-32.
