Abstract
This paper presents VIREX (VIsual RElational to XML) as a flexible user interface for converting a selected portion of a given relational database into XML. VIREX works even when the catalogue of the relational database is missing; it extracts the required catalogue information by analyzing the database content. From the catalogue information, whether available or extracted, VIREX derives and displays on the screen a graph similar to the entity-relationship diagram. VIREX provides a user-friendly interface to specify on the graph certain factors to be considered while converting relational data into XML. Such factors include: 1) selecting the relations/attributes to be converted into XML; 2) specifying a predicate to be satisfied by the information to be converted into XML; 3) deciding on the order of nesting between the relations to be converted into XML. All of these are specified by a sequence of mouse clicks with minimum keyboard input. As a result, VIREX displays on the screen the XML schema that satisfies the specified characteristics and generates the XML documents from the relational database. Finally, VIREX helps in optimizing the amount of information to be transferred over a network. Also, it can be used to teach XML to beginners.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Document Type Definition (DTD), Webpage: http://ww.w3schools.com/DTD/
XML Schema, Webpage: http://www.w3schools.com/schema/
Creating XML Views Using Annotated XDR Schemas,Microsoft Corporation Webpage: http://msdn.microsoft.com/library/default.asp?url=/library/enus/xmlsql/acmschema5cfn.asp
Alhajj, R.: Extracting the Extended Entity-Relationship Model from a legacy Relational Database. Information Systems 28(6), 597–618 (2003)
Catarci, T., et al.: Visual Query Systems for Databases: A Survey. Journal of Visual Languages and Computing 8, 215–260 (1997)
Ceri, S., et al.: XML-GL: a graphical language for querying and restructuring XML documents. Computer Networks 31(11-16), 1171–1187 (1999)
Erwig, M.: Xing: A Visual XML Query Language. Journal of Visual Languages and Computing 14(1), 5–45 (2003)
Fernandez, M.F., Tan, W.C., Suciu, D.: SilkRoute: Trading between Relational and XML. In: Proc. of ACM WWW,Amsterdam (May 2000)
Goldman, R., Widom, J.: Interactive query and search in semistructured databases. In: Proc. of ACM SIGMOD WebDB Workshop (1998)
Lee, D., et al.: NeT and CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints. In: Proc. of ACM CIKM,McLean, Virginia (November 2002)
McHugh, J., et al.: Lore: A database management system for semistructured data. SIGMOD Record 26(3) (1997)
Munroe, K.D., Papakonstantinou, Y.: BBQ: A visual interface for browsing and querying of XML. In: Proc. of IFIP Working Conf. on Visual Database Systems, pp. 277–296 (2000)
Orsini, R., Pagotto, M.: Visual SQL-X: A Graphical Tool for Producing XML Documents from Relational Databases. In: Proc. of ACM WWW,Hong Kong (2001)
Pietriga, E., Vion-Dury, J.-Y.: VXT: Visual XML Transformer. In: Proc. of IEEE Symposium on Visual/Multimedia Approaches to Programming and Software Engineering (Human Centric Computing Languages and Environments) (2001)
Shanmugasundaram, J., et al.: Efficiently Publishing Relational Data as XML Documents. VLDB Journal 10, 133–154 (2001)
Zloof, M.M.: Query-By-Example: A Data Base Language. IBM Systems Journal 4(3), 324–343 (1977)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lo, A., Alhajj, R., Barker, K. (2004). Flexible User Interface for Converting Relational Data into XML. In: Christiansen, H., Hacid, MS., Andreasen, T., Larsen, H.L. (eds) Flexible Query Answering Systems. FQAS 2004. Lecture Notes in Computer Science(), vol 3055. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-25957-2_33
Download citation
DOI: https://doi.org/10.1007/978-3-540-25957-2_33
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22160-9
Online ISBN: 978-3-540-25957-2
eBook Packages: Springer Book Archive