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.
This is a preview of subscription content, access via your institution.
Buying options
Preview
Unable to display preview. Download preview PDF.
References
Bell, D., Grimson, J.: Distributed Database Systems. Addison-Wesley, Reading (1992)
BizQuery: A Software System for Virtual Integration of Disparate Data. ATS (August 22, 2005), http://www.atssoft.com/products/bizquery.htm
Sheth, A.P., Larson, J.A.: Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys 22(3) (September 1990)
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)
Elmagarmid, A., Rusinkiewicz, M., Sheth, A.: Management of Heterogeneous and Autonomous Database Systems. Morgan Kaufmann Publishers Inc., San Francisco (1999)
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)
Jahnkuhn, H.: Transformation von SQL- in XQuery-Anfragen innerhalb föderierter Informationssysteme. University of Rostock. Department of Computer Science. Student research project (2005)
JDBCforXML: Sunopsis XML Driver (JDBC Edition) (August 22, 2005), http://www.sunopsis.com/corporate/us/products/jdbcforxml/
Michiels, P.: XQuery Optimization. In: Proceedings of VLDB 2003 Ph.D Workshop, Berlin (2003)
Rost, G.: Implementierung von XQuery auf objektrelationalen Datenbanken. University of Rostock. Department of Computer Science. Diploma thesis (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jahnkuhn, H., Bruder, I., Balouch, A., Nelius, M., Heuer, A. (2006). Query Transformation of SQL into XQuery Within Federated Environments. In: , et al. Current Trends in Database Technology – EDBT 2006. EDBT 2006. Lecture Notes in Computer Science, vol 4254. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11896548_43
Download citation
DOI: https://doi.org/10.1007/11896548_43
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-46788-5
Online ISBN: 978-3-540-46790-8
eBook Packages: Computer ScienceComputer Science (R0)