Interoperability mapping from XML schemas to ER diagrams

Authors:
Giuseppe Della Penna;Antinisca Di Marco;Benedetto Intrigila;Igor Melatti;Alfonso Pierantonio
Affiliations:
Dipartimento di Informatica, Università di L'Aquila, L'Aquila, Italy;Dipartimento di Informatica, Università di L'Aquila, L'Aquila, Italy and Computer Science Department, University College London, London, UK;Dipartimento di Matematica, Università di Roma "Tor Vergata", Rome, Italy;Dipartimento di Informatica, Università di L'Aquila, L'Aquila, Italy;Dipartimento di Informatica, Università di L'Aquila, L'Aquila, Italy
Venue:
Data & Knowledge Engineering
Year:
2006

Citing 15
Cited 2

From structured documents to novel query facilities

SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
Application of OODB and SGML techniques in text database: an electronic dictionary system

ACM SIGMOD Record
Software architecture: perspectives on an emerging discipline

Software architecture: perspectives on an emerging discipline
Proximal nodes: a model to query document databases by content and structure

ACM Transactions on Information Systems (TOIS)
Storing semistructured data with STORED

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
The entity-relationship model—toward a unified view of data

ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
SilkRoute: trading between relations and XML

Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking
Efficient evaluation of XML middle-ware queries

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
XRel: a path-based approach to storage and retrieval of XML documents using relational databases

ACM Transactions on Internet Technology (TOIT)
Relational Databases for Querying XML Documents: Limitations and Opportunities

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
A Semantic Approach to Integrating XML and Structured Data Sources

CAiSE '01 Proceedings of the 13th International Conference on Advanced Information Systems Engineering
Converting XML DTDs to UML diagrams for conceptual data integration

Data & Knowledge Engineering - Special issue: Data integration over the Web
From XML Schema to Relations: A Cost-Based Approach to XML Storage

ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Xere: towards a natural interoperability between XML and ER diagrams

FASE'03 Proceedings of the 6th international conference on Fundamental approaches to software engineering
XML conceptual modeling using UML

ER'00 Proceedings of the 19th international conference on Conceptual modeling

XML: some papers in a haystack

ACM SIGMOD Record
When conceptual model meets grammar: A dual approach to XML data modeling

Data & Knowledge Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

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 storing, querying and retrieving a great amount of data contained in XML documents. Unfortunately, XML data often need to coexist with historical data. At 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 structures' logical model (e.g., the relational model of a DBMS). In this paper, we introduce a technique called Xere (XML entity relationship exchange) 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.