Abstract
Although XML is the dominant standard for publishing and exchanging data for Internet-based business applications, data is typically stored in relational or object-relational databases. Thus, it is necessary to define XML views over these traditional databases. Unfortunately, it is not easy for users to manually write SQLX queries to define the XML views. This paper describes a method to automatically generate SQLX view definitions from object-relational databases. We utilize the semantically rich ORA-SS data model to capture the schematic structure and semantics of the underlying data. Valid ORA-SS views are first designed on the ORA-SS schema, before they are mapped to XML views. The generated view definitions are SQL queries with XML extension (SQLX) that can be directly evaluated on object-relational databases to materialize the views. This approach removes the need to manually write executable view definitions for the XML views, and provides a user-friendly interface to retrieve XML data via views.
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
Baru, C., Gupta, A., Ludaescher, B., et al.: XML-Based Information Mediation with MIX. In: ACM SIGMOD (1999) (Demo)
Carey, M., Kiernan, J., Shanmugasundaram, J., et al.: XPERANTO: A Middleware for Publishing Object-Relational Data as XML Documents. In: VLDB (2000)
Chen, Y.B., Ling, T.W., Lee, M.L.: Designing Valid XML Views. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, p. 463. Springer, Heidelberg (2002)
Christophides, V., Cluet, S., Simeon, J.: On Wrapping Query Languages and Efficient XML Integration. In: ACM SIGMOD (2000)
Cluet, S., Veltri, P., Vodislav, D.: Views in a Large Scale XML Repository. In: VLDB (2001)
Dobbie, G., Wu, X.Y., Ling, T.W., Lee, M.L.: ORA-SS: An Object-Relationship-Attribute Model for SemiStructured Data, Technical Report TR21/00, School of Computing, National University of Singapore (2000)
Fernandez, M., Tan, W., Suciu, D.: SilkRoute: Trading Between Relations and XML. In: World Wide Web Conference (1999)
Manolescu, I., Florescu, D., Kossmann, D.: Answering XML Queries over Heterogeneous Data Sources. In: VLDB (2001)
Mo, Y.Y., Ling, T.W.: Storing and Maintaining Semistructured Data Efficiently in an Object-Relational Database. In: WISE Conference (2002)
SQLX, http://www.sqlx.org
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
Chen, Y.B., Ling, T.W., Lee, M.L. (2004). Automatic Generation of SQLX View Definitions from ORA-SS Views. In: Lee, Y., Li, J., Whang, KY., Lee, D. (eds) Database Systems for Advanced Applications. DASFAA 2004. Lecture Notes in Computer Science, vol 2973. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24571-1_44
Download citation
DOI: https://doi.org/10.1007/978-3-540-24571-1_44
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-21047-4
Online ISBN: 978-3-540-24571-1
eBook Packages: Springer Book Archive