Web Information Systems Engineering, International Conference on (2001)
Dec. 3, 2001 to Dec. 6, 2001
Wenyue Du , National University of Singapore
Mong Li , National University of Singapore
Lee Tok , National University of Singapore
Wang Ling , National University of Singapore
XML is increasingly being adopted for information publishing on the World Wide Web. However, the underlying data is often stored in the relational databases. Some mechanism is needed to convert the relational data into XML data. In this work, we employ a semantically rich semistructured data model, the Object-Relationship-Attribute model for semistructured data, as a middleware to support the schema conversion from semantically enriched relational schema to XML Schema. This approach allows us to handle the translation of a set of related relations and to distinguish attributes of relationship types from attributes of object classes, multi-valued attributes, and different types of relationships such as binary, n-ary, recursive and ISA. The resulting XML structures are able to reflect the inherent semantics and implicit structure in the underlying relational database. We also show that the appropriate use of references is able to avoid unnecessary redundancy and the proliferation of disconnected XML elements.
M. Li, W. Du, W. Ling and L. Tok, "XML Structures for Relational Data," Proceedings of 2nd International Conference on Web Information Systems Engineering(WISE), Kyoto, Japan, 2001, pp. 0151.