Automatic Generation of XQuery View Definitions from ORA-SS Views

Many Internet-based applications have adopted XML as the standard data exchange format. These XML data are typically stored in its native form, thus creating the need to present XML views over the underlying data files, and to allow users to query these views. Using a conceptual model for the design and querying of XML views provides a fast and user-friendly approach to retrieve XML data. The Object-Relationship-Attribute model for SemiStructured data (ORA-SS) is a semantically rich model that facilitates the design of valid XML views. It preserves semantic information in the source data. In this paper, we develop a method that automatically generates view definitions in XQuery from views that have been designed using the ORA-SS model. This technique can be used to materialize the views and map queries issued on XML views into the equivalent queries in XQuery syntax on the source XML data. This removes the need for users to manually write XQuery expressions. An analysis of the correctness of the proposed algorithm is also given.

[1]  Dan Suciu,et al.  Efficient evaluation of XML middle-ware queries , 2001, SIGMOD '01.

[2]  Donald D. Chamberlin,et al.  XQuery: a query language for XML , 2003, SIGMOD '03.

[3]  Tova Milo,et al.  Active Views for Electronic Commerce , 1999, VLDB.

[4]  Tok Wang Ling,et al.  A Case Tool for Designing XML Views , 2002, DIWeb.

[5]  Serge Abiteboul,et al.  On views and XML , 1999, PODS '99.

[6]  Michael J. Carey,et al.  XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents , 2000, VLDB.

[7]  Michael J. Carey,et al.  XPERANTO: Publishing Object-Relational Data as XML , 2000, WebDB.

[8]  M. Lee,et al.  ORA-SS: An Object-Relationship-Attribute Model for Semi-structured Data , 2000 .

[9]  Vassilis Christophides,et al.  On wrapping query languages and efficient XML integration , 2000, SIGMOD '00.

[10]  Tova Milo,et al.  Views in a large-scale XML repository , 2002, The VLDB Journal.

[11]  Chaitanya K. Baru,et al.  XML-based information mediation for digital libraries , 1999, DL '99.

[12]  Chaitanya K. Baru,et al.  XML-based information mediation with MIX , 1999, SIGMOD '99.

[13]  Dan Suciu,et al.  SilkRoute: trading between relations and XML , 2000, Comput. Networks.

[14]  Tok Wang Ling,et al.  Designing Valid XML Views , 2002, ER.

[15]  Ioana Manolescu,et al.  Answering XML Queries on Heterogeneous Data Sources , 2001, VLDB.

[16]  Tok Wang Ling,et al.  Storing and maintaining semistructured data efficiently in an object-relational database , 2002, Proceedings of the Third International Conference on Web Information Systems Engineering, 2002. WISE 2002..

[17]  Letizia Tanca,et al.  XML-GL: A Graphical Language for Querying and Restructuring XML Documents , 1999, SEBD.

[18]  Serge Abiteboul,et al.  XML Repository and Active Views Demonstration , 1999, VLDB.

[19]  Eugene J. Shekita,et al.  XTABLES: Bridging relational technology and XML , 2002, IBM Syst. J..

[20]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.