Tradução de consultas XQUERY para SQL

Abstract

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.