Abstract
Semi-structured data has become more and more attention-getting with the emergence of XML, and it has aroused much enthusiasm for integrating XML and SQL in database community. Due to the complexity of XQuery, graphical XML query languages have been developed to help users query XML data. In this paper, we propose a new XML-to-SQL solution on the base of ORA-SS, a rich semantic model for semi-structured data. We model the data by ORA-SS schema and store them in an ORDB. Based on ORA-SS, we developed a graphical XML query language GLASS that not only expresses the query constraints and reconstruction structure in XML view but also the relational semantic in the XML view. This paper focuses on the translation algorithm from GLASS to SQLX, an XML extension on traditional SQL.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Ceri, S., Comai, S., Damiani, E., Fraternali, P., Paraboschi, S., Tanca, L.: XML-GL: a graphical language of querying and restructuring XML documents. In: Proc. WWW8, Toronto, Canada (May 1999)
Ceri, S., Comai, S., Damiani, E., Fraternali, P., Tanca, L.: Complex Queries in XML-GL. SAC (2), 888–893 (2000)
Cohen, S., Kanza, Y., Kogan, Y., Nutt, W., Sagiv, Y., Serebrenik, A.: Equix – Easy Querying in XML Databases. In: Proceedings of Webdb 1998 – The Web and Database Workshop (1998)
Comai, S., Damiani, E., Fraternali, P.: Computing Graphical Queries over XML Data. ACM Transactions on Information Systems 19(4), 371–430 (2001)
Dobbie, G., Wu, X.Y., Ling, T.W., Lee, M.L.: ORA-SS: An Object-Relationship-Attribute Model for Semistructured Data. TR21/00, Technical Report, Department of Computer Science, National University of Singapore (December 2000)
Information technology – Database languages – SQL – Part 14: XML-Related Specifications. ISO/IEC 9075-14:2003
Ludaescher, B., Papakonstantinou, Y., Velikhov, P.: Navigation-driven evaluation of virtual mediated views. In: Zaniolo, C., Grust, T., Scholl, M.H., Lockemann, P.C. (eds.) EDBT 2000. LNCS, vol. 1777, p. 150. Springer, Heidelberg (2000)
Mark, L., et al.: XMLApe. College of Computing, Georgia Institue of Technology, http://www.cc.gatech.edu/projects/XMLApe/
Munroe, K.D., Ludaescher, B., Papakonstantinou, Y.: Blended Browsing and Querying of XML in Lazy Mediator System. Konstanz, Germany (March 2000)
Ni, W., Ling, T.W.: GLASS: A Graphical Query Language for Semi-Structured Data. In: DASFAA 2003 (2003)
Papakonstantinou, Y., Petropoulos, M., Vassalos, V.: QURSED: Querying and Reporting Semistructured Data. In: ACM SIGMOD 2002, Madison, Wisconsin, USA, June 4-6 (2002)
XQuery 1.0: An XML Query Language. W3C Working Draft (August 22, 2003), http://www.w3.org/TR/xquery/
XML Path Language (XPath) 2.0. W3C Working Draft (August 22, 2003), http://www.w3.org/TR/xpath20/
XML Schema, http://www.w3.org/XML/Schema
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ni, W., Ling, T.W. (2005). Translate Graphical XML Query Language to SQLX. In: Zhou, L., Ooi, B.C., Meng, X. (eds) Database Systems for Advanced Applications. DASFAA 2005. Lecture Notes in Computer Science, vol 3453. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11408079_83
Download citation
DOI: https://doi.org/10.1007/11408079_83
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-25334-1
Online ISBN: 978-3-540-32005-0
eBook Packages: Computer ScienceComputer Science (R0)