Advertisement

Query Transformation of SQL into XQuery Within Federated Environments

  • Heiko Jahnkuhn
  • Ilvio Bruder
  • Ammar Balouch
  • Manja Nelius
  • Andreas Heuer
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4254)

Abstract

Federated information systems integrate various heterogeneous autonomic databases and information systems. Queries respect to the federation have to be translated into the local query language and must be transformed with respect to the local data model. This paper deals with the problem of a global query according to an object-relational federation service. This SQL query is to be translated into an equivalent XQuery expression, so that it can be processed by the corresponding XML component database system according to the local schema.

Keywords

Aggregate Function Transformation Step Splitting Node Path Expression Query Tree 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Bell, D., Grimson, J.: Distributed Database Systems. Addison-Wesley, Reading (1992)MATHGoogle Scholar
  2. 2.
    BizQuery: A Software System for Virtual Integration of Disparate Data. ATS (August 22, 2005), http://www.atssoft.com/products/bizquery.htm
  3. 3.
    Sheth, A.P., Larson, J.A.: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys 22(3) (September 1990)Google Scholar
  4. 4.
    DeHaan, D., Toman, D., Consens, M.P., Özsu, M.T.: A comprehensive XQuery to SQL translation using dynamic interval encoding. In: Proceedings of the 2003 ACM SIGMOD Int. Conf., San Diego (2003)Google Scholar
  5. 5.
    Elmagarmid, A., Rusinkiewicz, M., Sheth, A.: Management of Heterogeneous and Autonomous Database Systems. Morgan Kaufmann Publishers Inc., San Francisco (1999)Google Scholar
  6. 6.
    Escobar, F., Espinosa, E., Lozano, R.: XML Information Retrieval Using SQL2Xquery. Tecnológico de Monterrey-Campus cd. De México. Departmento do Computación (2002)Google Scholar
  7. 7.
    Jahnkuhn, H.: Transformation von SQL- in XQuery-Anfragen innerhalb föderierter Informationssysteme. University of Rostock. Department of Computer Science. Student research project (2005)Google Scholar
  8. 8.
    JDBCforXML: Sunopsis XML Driver (JDBC Edition) (August 22, 2005), http://www.sunopsis.com/corporate/us/products/jdbcforxml/
  9. 9.
    Michiels, P.: XQuery Optimization. In: Proceedings of VLDB 2003 Ph.D Workshop, Berlin (2003)Google Scholar
  10. 10.
    Rost, G.: Implementierung von XQuery auf objektrelationalen Datenbanken. University of Rostock. Department of Computer Science. Diploma thesis (2002)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Heiko Jahnkuhn
    • 1
  • Ilvio Bruder
    • 1
  • Ammar Balouch
    • 1
  • Manja Nelius
    • 1
  • Andreas Heuer
    • 1
  1. 1.Department of Computer ScienceUniversity of RostockRostockGermany

Personalised recommendations