From Entity Relationship to XML Schema: A Graph-Theoretic Approach

  • Massimo Franceschet
  • Donatella Gubiani
  • Angelo Montanari
  • Carla Piazza
Conference paper

DOI: 10.1007/978-3-642-03555-5_14

Part of the Lecture Notes in Computer Science book series (LNCS, volume 5679)
Cite this paper as:
Franceschet M., Gubiani D., Montanari A., Piazza C. (2009) From Entity Relationship to XML Schema: A Graph-Theoretic Approach. In: Bellahsène Z., Hunt E., Rys M., Unland R. (eds) Database and XML Technologies. XSym 2009. Lecture Notes in Computer Science, vol 5679. Springer, Berlin, Heidelberg

Abstract

We propose a mapping from the Enhanced Entity Relationship conceptual model to the W3C XML Schema Language with the following properties: information and integrity constraints are preserved, no redundance is introduced, different hierarchical views of the conceptual information are available, the resulting XML structure is highly connected, and the design is reversible. We investigate two different ways to nest the XML structure: a maximum connectivity nesting, that minimizes the number of schema constraints used in the mapping of the conceptual schema reducing the validation overhead, and a maximum depth nesting, that keeps low the number of (expensive) join operations that are necessary to reconstruct the information at query time using the mapped schema. We propose a graph-theoretic linear-time algorithm to find a maximum connectivity nesting and show that finding a maximum depth nesting is NP-complete. We complement our investigation with an implementation of the devised translation and we embed the implemented module in a software framework for the conceptual and logical design of spatio-temporal databases.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Massimo Franceschet
    • 1
  • Donatella Gubiani
    • 1
  • Angelo Montanari
    • 1
  • Carla Piazza
    • 1
  1. 1.Department of Mathematics and Computer ScienceUniversity of UdineUdineItaly

Personalised recommendations