Tradução de consultas XQUERY para SQL
Autor(a) principal: | |
---|---|
Data de Publicação: | 2013 |
Tipo de documento: | Dissertação |
Idioma: | por |
Título da fonte: | Biblioteca Digital de Teses e Dissertações do UFSM |
Texto Completo: | http://repositorio.ufsm.br/handle/1/22317 |
Resumo: | Even with the extensive use of XML as the standard for data exchange, most corporate data is stored in Relational Databases (RDB). Furthermore, many applications require efficient storage of XML data (eXtensible Markup Language), which can be achieved using a RDB. Thus, the ability to manage both kinds of data (relational and XML) becomes essential for organizations. Therefore, one of the alternatives to perform this storage consists of mapping the structure of XML documents to a relational schema. This mapping becomes complex since the XML documents have different structures even representing data from a common domain. In this case, in addition to mapping the structure and the XML data to relations in a RBD, it is also required to translate XML queries to SQL, the standard language used by RBD. In order to perform this translation, this work proposes a mechanism that translates XQuery queries to equivalent SQL queries, called QMap (Query Mapper). The proposal is part of a framework named X2Rel (XML to Relational), an environment for storing, managing and querying XML data in heterogeneous RBDs. |
id |
UFSM_0e295cabff072db908e892d7aa7c5988 |
---|---|
oai_identifier_str |
oai:repositorio.ufsm.br:1/22317 |
network_acronym_str |
UFSM |
network_name_str |
Biblioteca Digital de Teses e Dissertações do UFSM |
repository_id_str |
|
spelling |
2021-10-01T18:00:46Z2021-10-01T18:00:46Z2013-07-16http://repositorio.ufsm.br/handle/1/22317Even with the extensive use of XML as the standard for data exchange, most corporate data is stored in Relational Databases (RDB). Furthermore, many applications require efficient storage of XML data (eXtensible Markup Language), which can be achieved using a RDB. Thus, the ability to manage both kinds of data (relational and XML) becomes essential for organizations. Therefore, one of the alternatives to perform this storage consists of mapping the structure of XML documents to a relational schema. This mapping becomes complex since the XML documents have different structures even representing data from a common domain. In this case, in addition to mapping the structure and the XML data to relations in a RBD, it is also required to translate XML queries to SQL, the standard language used by RBD. In order to perform this translation, this work proposes a mechanism that translates XQuery queries to equivalent SQL queries, called QMap (Query Mapper). The proposal is part of a framework named X2Rel (XML to Relational), an environment for storing, managing and querying XML data in heterogeneous RBDs.Mesmo com a ampla utilização de XML como padrão para a troca de dados, a maior parte dos dados corporativos é armazenada em Bancos de Dados Relacionais (BDR). Além disso, muitas aplicações requerem o armazenamento eficiente de dados XML (eXtensible Markup Language), o que pode ser alcançado usando um BDR. Dessa forma, a capacidade de gerenciar ambos os tipos de dados (relacionais e XML) torna-se essencial para as organizações. Com isso, uma das alternativas para realizar esse armazenamento consiste no mapeamento da estrutura de documentos XML para um esquema relacional. Esse mapeamento torna-se complexo a medida em que os documentos XML possuem estruturas diferentes, mesmo representando dados de um domínio comum. Nesse caso, além da mapear a estrutura e os dados XML para tabelas em um BDR, é necessária a tradução de consultas XML, antes executadas sobre os documentos originais, para SQL, linguagem padrão utilizada nos BDRs. Com a finalidade de realizar essa tradução, este trabalho propõe um mecanismo que traduz consultas XQuery, linguagem de consulta XML, para consultas SQL equivalentes, chamado QMap (Query Mapper). A proposta está inserida no contexto do framework X2Rel (XML to Relational), um ambiente para armazenamento, gerenciamento e consulta a dados XML heterogêneos em BDRs.Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - CAPESporUniversidade Federal de Santa MariaCentro de TecnologiaPrograma de Pós-Graduação em InformáticaUFSMBrasilCiência da ComputaçãoAttribution-NonCommercial-NoDerivatives 4.0 Internationalhttp://creativecommons.org/licenses/by-nc-nd/4.0/info:eu-repo/semantics/openAccessXQuerySQLTraduçãoTranslationCNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAOTradução de consultas XQUERY para SQLTranslation of XQUERY queries to SQLinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisSaccol, Deise de Brumhttp://lattes.cnpq.br/7758924784164781Vizzotto, Juliana KaizerMoreira, Viviane Pereirahttp://lattes.cnpq.br/3452656759670690Loose, Marta Breunig1003000000076006006002e6c7d37-c038-485e-8d37-b25fb90e69abf7bcae2c-df57-464b-921b-671b8b72ad84a28a3f9d-068c-4165-b538-7bab497c78dcc21c09c3-d285-47f8-92a5-072dbd9c7b05reponame:Biblioteca Digital de Teses e Dissertações do UFSMinstname:Universidade Federal de Santa Maria (UFSM)instacron:UFSMORIGINALDIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdfDIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdfDissertação de Mestradoapplication/pdf1953498http://repositorio.ufsm.br/bitstream/1/22317/1/DIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdffdcd0d8b3175d2cb3e33e7b745673607MD51CC-LICENSElicense_rdflicense_rdfapplication/rdf+xml; charset=utf-8805http://repositorio.ufsm.br/bitstream/1/22317/2/license_rdf4460e5956bc1d1639be9ae6146a50347MD52LICENSElicense.txtlicense.txttext/plain; charset=utf-81956http://repositorio.ufsm.br/bitstream/1/22317/3/license.txt2f0571ecee68693bd5cd3f17c1e075dfMD53TEXTDIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.txtDIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.txtExtracted texttext/plain219888http://repositorio.ufsm.br/bitstream/1/22317/4/DIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.txt89966b93709e2d356efb7fe86c823c6aMD54THUMBNAILDIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.jpgDIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.jpgIM Thumbnailimage/jpeg4560http://repositorio.ufsm.br/bitstream/1/22317/5/DIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.jpga083265009b9c2766260e6b5b4ad52d3MD551/223172021-10-02 03:02:13.58oai:repositorio.ufsm.br:1/22317TElDRU7Dh0EgREUgRElTVFJJQlVJw4fDg08gTsODTy1FWENMVVNJVkEKCkNvbSBhIGFwcmVzZW50YcOnw6NvIGRlc3RhIGxpY2Vuw6dhLCB2b2PDqiAobyBhdXRvciAoZXMpIG91IG8gdGl0dWxhciBkb3MgZGlyZWl0b3MgZGUgYXV0b3IpIGNvbmNlZGUgw6AgVW5pdmVyc2lkYWRlCkZlZGVyYWwgZGUgU2FudGEgTWFyaWEgKFVGU00pIG8gZGlyZWl0byBuw6NvLWV4Y2x1c2l2byBkZSByZXByb2R1emlyLCAgdHJhZHV6aXIgKGNvbmZvcm1lIGRlZmluaWRvIGFiYWl4byksIGUvb3UKZGlzdHJpYnVpciBhIHN1YSB0ZXNlIG91IGRpc3NlcnRhw6fDo28gKGluY2x1aW5kbyBvIHJlc3VtbykgcG9yIHRvZG8gbyBtdW5kbyBubyBmb3JtYXRvIGltcHJlc3NvIGUgZWxldHLDtG5pY28gZQplbSBxdWFscXVlciBtZWlvLCBpbmNsdWluZG8gb3MgZm9ybWF0b3Mgw6F1ZGlvIG91IHbDrWRlby4KClZvY8OqIGNvbmNvcmRhIHF1ZSBhIFVGU00gcG9kZSwgc2VtIGFsdGVyYXIgbyBjb250ZcO6ZG8sIHRyYW5zcG9yIGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbwpwYXJhIHF1YWxxdWVyIG1laW8gb3UgZm9ybWF0byBwYXJhIGZpbnMgZGUgcHJlc2VydmHDp8Ojby4KClZvY8OqIHRhbWLDqW0gY29uY29yZGEgcXVlIGEgVUZTTSBwb2RlIG1hbnRlciBtYWlzIGRlIHVtYSBjw7NwaWEgYSBzdWEgdGVzZSBvdQpkaXNzZXJ0YcOnw6NvIHBhcmEgZmlucyBkZSBzZWd1cmFuw6dhLCBiYWNrLXVwIGUgcHJlc2VydmHDp8Ojby4KClZvY8OqIGRlY2xhcmEgcXVlIGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyDDqSBvcmlnaW5hbCBlIHF1ZSB2b2PDqiB0ZW0gbyBwb2RlciBkZSBjb25jZWRlciBvcyBkaXJlaXRvcyBjb250aWRvcwpuZXN0YSBsaWNlbsOnYS4gVm9jw6ogdGFtYsOpbSBkZWNsYXJhIHF1ZSBvIGRlcMOzc2l0byBkYSBzdWEgdGVzZSBvdSBkaXNzZXJ0YcOnw6NvIG7Do28sIHF1ZSBzZWphIGRlIHNldQpjb25oZWNpbWVudG8sIGluZnJpbmdlIGRpcmVpdG9zIGF1dG9yYWlzIGRlIG5pbmd1w6ltLgoKQ2FzbyBhIHN1YSB0ZXNlIG91IGRpc3NlcnRhw6fDo28gY29udGVuaGEgbWF0ZXJpYWwgcXVlIHZvY8OqIG7Do28gcG9zc3VpIGEgdGl0dWxhcmlkYWRlIGRvcyBkaXJlaXRvcyBhdXRvcmFpcywgdm9jw6oKZGVjbGFyYSBxdWUgb2J0ZXZlIGEgcGVybWlzc8OjbyBpcnJlc3RyaXRhIGRvIGRldGVudG9yIGRvcyBkaXJlaXRvcyBhdXRvcmFpcyBwYXJhIGNvbmNlZGVyIMOgIFVGU00Kb3MgZGlyZWl0b3MgYXByZXNlbnRhZG9zIG5lc3RhIGxpY2Vuw6dhLCBlIHF1ZSBlc3NlIG1hdGVyaWFsIGRlIHByb3ByaWVkYWRlIGRlIHRlcmNlaXJvcyBlc3TDoSBjbGFyYW1lbnRlCmlkZW50aWZpY2FkbyBlIHJlY29uaGVjaWRvIG5vIHRleHRvIG91IG5vIGNvbnRlw7pkbyBkYSB0ZXNlIG91IGRpc3NlcnRhw6fDo28gb3JhIGRlcG9zaXRhZGEuCgpDQVNPIEEgVEVTRSBPVSBESVNTRVJUQcOHw4NPIE9SQSBERVBPU0lUQURBIFRFTkhBIFNJRE8gUkVTVUxUQURPIERFIFVNIFBBVFJPQ8ONTklPIE9VCkFQT0lPIERFIFVNQSBBR8OKTkNJQSBERSBGT01FTlRPIE9VIE9VVFJPIE9SR0FOSVNNTyBRVUUgTsODTyBTRUpBIEEgVUZTTQosIFZPQ8OKIERFQ0xBUkEgUVVFIFJFU1BFSVRPVSBUT0RPUyBFIFFVQUlTUVVFUiBESVJFSVRPUyBERSBSRVZJU8ODTyBDT01PClRBTULDiU0gQVMgREVNQUlTIE9CUklHQcOHw5VFUyBFWElHSURBUyBQT1IgQ09OVFJBVE8gT1UgQUNPUkRPLgoKQSBVRlNNIHNlIGNvbXByb21ldGUgYSBpZGVudGlmaWNhciBjbGFyYW1lbnRlIG8gc2V1IG5vbWUgKHMpIG91IG8ocykgbm9tZShzKSBkbyhzKQpkZXRlbnRvcihlcykgZG9zIGRpcmVpdG9zIGF1dG9yYWlzIGRhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbywgZSBuw6NvIGZhcsOhIHF1YWxxdWVyIGFsdGVyYcOnw6NvLCBhbMOpbSBkYXF1ZWxhcwpjb25jZWRpZGFzIHBvciBlc3RhIGxpY2Vuw6dhLgoKBiblioteca Digital de Teses e Dissertaçõeshttps://repositorio.ufsm.br/ONGhttps://repositorio.ufsm.br/oai/requestatendimento.sib@ufsm.br||tedebc@gmail.comopendoar:2021-10-02T06:02:13Biblioteca Digital de Teses e Dissertações do UFSM - Universidade Federal de Santa Maria (UFSM)false |
dc.title.por.fl_str_mv |
Tradução de consultas XQUERY para SQL |
dc.title.alternative.eng.fl_str_mv |
Translation of XQUERY queries to SQL |
title |
Tradução de consultas XQUERY para SQL |
spellingShingle |
Tradução de consultas XQUERY para SQL Loose, Marta Breunig XQuery SQL Tradução Translation CNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO |
title_short |
Tradução de consultas XQUERY para SQL |
title_full |
Tradução de consultas XQUERY para SQL |
title_fullStr |
Tradução de consultas XQUERY para SQL |
title_full_unstemmed |
Tradução de consultas XQUERY para SQL |
title_sort |
Tradução de consultas XQUERY para SQL |
author |
Loose, Marta Breunig |
author_facet |
Loose, Marta Breunig |
author_role |
author |
dc.contributor.advisor1.fl_str_mv |
Saccol, Deise de Brum |
dc.contributor.advisor1Lattes.fl_str_mv |
http://lattes.cnpq.br/7758924784164781 |
dc.contributor.referee1.fl_str_mv |
Vizzotto, Juliana Kaizer |
dc.contributor.referee2.fl_str_mv |
Moreira, Viviane Pereira |
dc.contributor.authorLattes.fl_str_mv |
http://lattes.cnpq.br/3452656759670690 |
dc.contributor.author.fl_str_mv |
Loose, Marta Breunig |
contributor_str_mv |
Saccol, Deise de Brum Vizzotto, Juliana Kaizer Moreira, Viviane Pereira |
dc.subject.por.fl_str_mv |
XQuery SQL Tradução |
topic |
XQuery SQL Tradução Translation CNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO |
dc.subject.eng.fl_str_mv |
Translation |
dc.subject.cnpq.fl_str_mv |
CNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO |
description |
Even with the extensive use of XML as the standard for data exchange, most corporate data is stored in Relational Databases (RDB). Furthermore, many applications require efficient storage of XML data (eXtensible Markup Language), which can be achieved using a RDB. Thus, the ability to manage both kinds of data (relational and XML) becomes essential for organizations. Therefore, one of the alternatives to perform this storage consists of mapping the structure of XML documents to a relational schema. This mapping becomes complex since the XML documents have different structures even representing data from a common domain. In this case, in addition to mapping the structure and the XML data to relations in a RBD, it is also required to translate XML queries to SQL, the standard language used by RBD. In order to perform this translation, this work proposes a mechanism that translates XQuery queries to equivalent SQL queries, called QMap (Query Mapper). The proposal is part of a framework named X2Rel (XML to Relational), an environment for storing, managing and querying XML data in heterogeneous RBDs. |
publishDate |
2013 |
dc.date.issued.fl_str_mv |
2013-07-16 |
dc.date.accessioned.fl_str_mv |
2021-10-01T18:00:46Z |
dc.date.available.fl_str_mv |
2021-10-01T18:00:46Z |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/masterThesis |
format |
masterThesis |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://repositorio.ufsm.br/handle/1/22317 |
url |
http://repositorio.ufsm.br/handle/1/22317 |
dc.language.iso.fl_str_mv |
por |
language |
por |
dc.relation.cnpq.fl_str_mv |
100300000007 |
dc.relation.confidence.fl_str_mv |
600 600 600 |
dc.relation.authority.fl_str_mv |
2e6c7d37-c038-485e-8d37-b25fb90e69ab f7bcae2c-df57-464b-921b-671b8b72ad84 a28a3f9d-068c-4165-b538-7bab497c78dc c21c09c3-d285-47f8-92a5-072dbd9c7b05 |
dc.rights.driver.fl_str_mv |
Attribution-NonCommercial-NoDerivatives 4.0 International http://creativecommons.org/licenses/by-nc-nd/4.0/ info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Attribution-NonCommercial-NoDerivatives 4.0 International http://creativecommons.org/licenses/by-nc-nd/4.0/ |
eu_rights_str_mv |
openAccess |
dc.publisher.none.fl_str_mv |
Universidade Federal de Santa Maria Centro de Tecnologia |
dc.publisher.program.fl_str_mv |
Programa de Pós-Graduação em Informática |
dc.publisher.initials.fl_str_mv |
UFSM |
dc.publisher.country.fl_str_mv |
Brasil |
dc.publisher.department.fl_str_mv |
Ciência da Computação |
publisher.none.fl_str_mv |
Universidade Federal de Santa Maria Centro de Tecnologia |
dc.source.none.fl_str_mv |
reponame:Biblioteca Digital de Teses e Dissertações do UFSM instname:Universidade Federal de Santa Maria (UFSM) instacron:UFSM |
instname_str |
Universidade Federal de Santa Maria (UFSM) |
instacron_str |
UFSM |
institution |
UFSM |
reponame_str |
Biblioteca Digital de Teses e Dissertações do UFSM |
collection |
Biblioteca Digital de Teses e Dissertações do UFSM |
bitstream.url.fl_str_mv |
http://repositorio.ufsm.br/bitstream/1/22317/1/DIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf http://repositorio.ufsm.br/bitstream/1/22317/2/license_rdf http://repositorio.ufsm.br/bitstream/1/22317/3/license.txt http://repositorio.ufsm.br/bitstream/1/22317/4/DIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.txt http://repositorio.ufsm.br/bitstream/1/22317/5/DIS_PPGINFORMATICA_2013_LOOSE_MARTA.pdf.jpg |
bitstream.checksum.fl_str_mv |
fdcd0d8b3175d2cb3e33e7b745673607 4460e5956bc1d1639be9ae6146a50347 2f0571ecee68693bd5cd3f17c1e075df 89966b93709e2d356efb7fe86c823c6a a083265009b9c2766260e6b5b4ad52d3 |
bitstream.checksumAlgorithm.fl_str_mv |
MD5 MD5 MD5 MD5 MD5 |
repository.name.fl_str_mv |
Biblioteca Digital de Teses e Dissertações do UFSM - Universidade Federal de Santa Maria (UFSM) |
repository.mail.fl_str_mv |
atendimento.sib@ufsm.br||tedebc@gmail.com |
_version_ |
1801485200022044672 |