Interoperability mapping from XML schemas to ER diagrams

Giuseppe Della Penna, Antinisca Di Marco, Benedetto Intrigila, Igor Melatti, Alfonso Pierantonio
2006 Data & Knowledge Engineering  
The eXtensible Markup Language (XML) is a de facto standard on the Internet and is now being used to exchange a variety of data structures. This leads to the problem of efficiently store, query and retrieve a great amount of data contained in XML documents. Unfortunately, XML data needs often to coexist with historical data. At the present, the best solution for storing XML into pre-existing data structures is to extract the information from the XML documents and adapt it to the data
more » ... logical model (e.g., the relational model of a DBMS). In this paper, we introduce a technique called Xere (XML E ntity Relationship E xchange) to assist the integration of XML data with other data sources. To this aim, we present an algorithm that maps XML Schemas into Entity-Relationship diagrams, discuss its soundness and completeness and show its implementation in XSLT.
doi:10.1016/j.datak.2005.08.002 fatcat:vdxxlimndffn3phvntml6ezisq