ACM Home Page
Please provide us with feedback. Feedback
Digital Library logoTake a look at the new version of this page: [ beta version ]. Tell us what you think.
Converting XML DTDs to UML diagrams for conceptual data integration
Source Data & Knowledge Engineering archive
Volume 44 ,  Issue 3  (March 2003) table of contents
Special issue: Data integration over the Web
Pages: 323 - 346  
Year of Publication: 2003
Mikael R. Jensen  Department of Computer Science, Aalborg University, Fredrik Bajers Vej 7E, 9220 Aalborg Ø, Denmark
Thomas H. Møller  Department of Computer Science, Aalborg University, Fredrik Bajers Vej 7E, 9220 Aalborg Ø, Denmark
Torben Bach Pedersen  Department of Computer Science, Aalborg University, Fredrik Bajers Vej 7E, 9220 Aalborg Ø, Denmark
Elsevier Science Publishers B. V.  Amsterdam, The Netherlands, The Netherlands
Downloads (6 Weeks): n/a,   Downloads (12 Months): n/a,   Citation Count: 2
Additional Information:

abstract   references   cited by   index terms   collaborative colleagues  

Tools and Actions: Review this Article  
DOI Bookmark: 10.1016/S0169-023X(02)00142-8


Extensible Markup Language (XML) is fast becoming the new standard for data representation and exchange on the World Wide Web, e.g., in B2B e-commerce. Modern enterprises need to combine data from many sources in order to answer important business questions, creating a need for integration of web-based XML data. Previous web-based data integration efforts have focused almost exclusively on the logical level of data models, creating a need for techniques that focus on the conceptual level in order to communicate the structure and properties of the available data to users at a higher level of abstraction. The most widely used conceptual model at the moment is the Unified Modeling Language (UML).This paper presents algorithms for automatically constructing UML diagrams from XML DTDs, enabling fast and easy graphical browsing of XML data sources on the web. The algorithms capture important semantic properties of the XML data such as precise cardinalities and aggregation (containment) relationships between the data elements. As a motivating application, it is shown how the generated diagrams can be used for the conceptual design of data warehouses based on web data, and an integration architecture is presented. The choice of data warehouses and On-Line Analytical Processing as the motivating application is another distinguishing feature of the presented approach.


Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

{1} S. Aboteboul et al., Tools for data translation and integration, IEEE Data Engineering Bulletin 22 (1) (1999) 3-8.
{3} Computer Associates. ERwin Brochure. Current as of July 7th, 2001.
{4} R. Conard et al., XML conceptual modelling using UML, in: Proceedings of ER, 2000, pp. 558-571.
{7} D. Florescu, D. Kossmann, Storing and querying XML data using an RDBMS, IEEE Data Engineering Bulletin 22 (3) (1999) 27-34.
{9} J.M. Hellerstein et al., Independent, open enterprise data integration, IEEE Data Engineering Bulletin 22 (1) (1999) 43-49.
{11} R. Kimball, The Data Warehouse Toolkit, Wiley, 1996.
Tirthankar Lahiri , Serge Abiteboul , Jennifer Widom, Ozone: Integrating Structured and Semistructured Data, Revised Papers from the 7th International Workshop on Database Programming Languages: Research Issues in Structured and Semistructured Database Programming, p.297-323, September 01-03, 1999
Peter McBrien , Alexandra Poulovassilis, A Uniform Approach to Inter-model Transformations, Proceedings of the 11th International Conference on Advanced Information Systems Engineering, p.333-348, June 14-18, 1999
{16} Microsoft Corporation. SQL Server 2000 Analysis Services Whitepaper, 2000.
{19} Object Management Group. Unified Modelling Language Specification 1.3, resources/documentation/index.jsp. Current as of July 7th, 2001.
{23} Silicon Integration Initiative The Electronic Component Information Exchange QuickData Architecture, http:// Current as of July 7th, 2001.
{25} World Wide Web Consortium Extensible Markup Language (XML) 1.0 (Second Edition), W3C Recommendations,, Oct. 6 2000. Current as of July 7th, 2001.
{26} World Wide Web Consortium XML Schema, W3C Candidate Recommendation, Schema.html. Current as of July 7th, 2001.

Collaborative Colleagues:
Mikael R. Jensen: colleagues
Thomas H. Møller: colleagues
Torben Bach Pedersen: colleagues