Mapeamento de esquemas XML integrados para bancos de dados relacionais

Abstract

Many applications require XML data storage (eXtensible Markup Language). One strategy is to store XML documents using a relational database. For that, transformation rules are applied, so that when an XML document is submitted to these rules, its representation becomes a set of tables and relationships between them, in a relational format. However, XML documents from the same application domain can have different structures, making harder the mapping of these documents into a single relational schema. To overcome that, we can previously generate an integrated schema that represents the structures of the various documents, and then map the integrated schema to the relational model. Subsequently, the data can be converted into the relational format, stored and retrieved (using SQL).This work is based on the discussed approach that stores XML data into relational databases, aiming to: (a) to propose a mechanism for generating relational model from integrated XML files, whose schema is described by an ontology, (b) to define a set of mapping rules from the integrated schema to the relational model, and (c) to implement a prototype of our technique in order to validate the proposed work.