Designing Quality XML Schemas from E-R Diagrams

  • Chengfei Liu
  • Jianxin Li
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4016)


XML has emerged as the standard for representing, exchanging and integrating data on the Web. To guarantee the quality of XML documents, the design of quality XML Schemas becomes essentially important. In this paper, we look into this problem by designing quality XML Schemas from given E-R diagrams. We first discuss several criteria in designing a good XML Schema. Following these criteria, transformation rules are then devised that take all constructs of an E-R diagram into account. Finally, a recursive algorithm is developed to transform an E-R diagram to a corresponding quality XML Schema.


Transformation Rule Relational Schema Root Element Information Preservation Dominant Relationship 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Kleiner, C., Lipeck, U.W.: Automatic Generation of XML DTDs from Conceptual Database Schemas. GI Jahrestagung (1), 396–405 (2001)Google Scholar
  2. 2.
    Sperberg-McQueen, C.M., Maler, E., Bray, T., Paoli, J., Yergeau, F.: Extensible Markup Language (XML) 1.0, 3rd edn. W3C Recommendation (2004),
  3. 3.
    Bird, L., Goodchild, A., Halpin, T.A.: Object Role Modeling and XML-Schema. In: ER 2002, pp. 309-322 (2002)Google Scholar
  4. 4.
    Bernus, P., Mertins, K., Schmidt, G.: Handbook on Architecture of Information Systems, ch. 4, pp. 81–101. Springer, Berlin (1998)CrossRefGoogle Scholar
  5. 5.
    Turau, V.: Making Legacy Data Accessible for XML Applications (2001),
  6. 6.
    Lee, D., Mani, M., Chiu, F., Chu, W.: NeT & CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints. In: CIKM 2002, pp. 282–291 (2002)Google Scholar
  7. 7.
    Baru, C.: XViews: XML Views of Relational Schemas. In: DEXA Workshop, pp. 700–705 (1999)Google Scholar
  8. 8.
    Liu, C., Vincent, M.W., Liu, J.: Constraint Preserving Transformation from Relational Schema to XML Schema. World Wide Web Journal 9(1), 93–110 (2006)CrossRefMathSciNetGoogle Scholar
  9. 9.
    Beech, D., Mendelsohn, N., Maloney, M., Thompson, H.S.: XML Schema Part 1: Structures, 2nd edn. W3C Recommendation,
  10. 10.
    Bohannon, P., Fan, W., Flaster, M., Narayan, P.P.S.: Information Preserving XML Schema Embedding. In: VLDB 2005, pp. 85–96 (2005)Google Scholar
  11. 11.
    Barbosa, D., Freire, J., Mendelzon, A.O.: Designing Information-Preserving Mapping Schemas for XML. In: VLDB 2005, pp. 109–120 (2005)Google Scholar
  12. 12.
    Atzeni, P., Ceri, S., Paraboschi, S., Torlone, R.: Database Systems Concepts, Languages & Architectures, part 2, pp. 163–179. McGraw-Hill International (UK) Limited, New York (1999)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Chengfei Liu
    • 1
  • Jianxin Li
    • 1
  1. 1.Faculty of Information and Communication TechnologiesSwinburne University of TechnologyMelbourneAustralia

Personalised recommendations