USING SQL/XML FOR EFFICIENTLY TRANSLATING QUERIES OVER XML VIEW OF RELATIONAL DATA

Fernando Lemos, Clayton Costa, Vânia Vidal

2010

Abstract

XML and Web services are becoming the standard means of publishing and integrating data over the Web. A convenient way to provide universal access (over the Web) to different data sources is to implement Web services that encapsulate XML views of the underlying relational data (Data Access Web Services). Given that most business data is currently stored in relational database systems, the generation of Web services for publishing XML view of relational data has special significance. In this work, we propose RelP, a framework for publishing and querying relational databases through XML views. The main contribution of the paper is an algorithm that translates XML queries over a published XML view schema into a single SQL/XML query over the data source schema.

References

  1. Benham, S E 2003, 'XML-Enabled Data Management Product Architecture and Technology', XML Data Management, Native XML and XML-Enable Database Systems, Addison Wesley.
  2. Bohannon, P et al 2004, 'Incremental evaluation of schemadirected XML publishing', SIGMOD'04, pp. 503-514.
  3. Eisenberg, A et al 2004, 'SQL:2003 has been published' SIGMOD'04, pp. 119-126.
  4. Fernández, M et al 2002, 'SilkRoute: A framework for Publishing relational data in XML', TODS'02, pp.438-493.
  5. Funderburk, J E et al 2002, 'XTABLES: Bridging relational technology and XML', IBM Systems Journal, vol.41, n. 4.
  6. Haas, L M et al 2005, 'Clio Grows Up: From Research Prototype to Industrial Tool', SIGMOD'05, pp. 805-810.
  7. Jiang, H et al 2007, 'Mapping-driven XML Transformation', WWW'07, pp. 1063-1072.
  8. Krishnamurthy, R et al 2003, 'XML-to-SQL Query Translation Literature: The State of the Art and Open Problems', XSym'03, pp. 1-18.
  9. Lemos, F C et al 2010, 'Using SQL/XML for Efficiently Translating Queries over XML View of Relational Data', Technical Report, http://lia.ufc.br/arida Liu, Z H et al 2005, 'Native XQuery Processing in Oracle XMLDB', SIGMOD International Conference on Management of Data, pp. 828-833.
  10. Melnik, S et al 2005, 'Supporting Executable Mappings in Model Management', SIGMOD'05, pp. 167-178.
  11. Popa, L et al 2002, 'Translating Web Data', VLDB'02, pp. 598-609.
  12. Vidal, V M P & Lemos, FC 2007, 'XVBA: A Tool for Semi-Automatic Generation of SQL/XML Views', IV Demo Session, SBBD'07, pp. 57-62.
  13. Vidal, V M P et al 2006, 'Automatic Generation of SQL/XML Views', SBBD'06, pp. 221-235.
  14. Vidal, V M P et al 2004, 'XML Publisher: Um Framework para Publicação de Dados Armazenados em Banco de Dados Relacional ou Objeto Relacional como XML', 1st Demo Session, SBBD'04, pp. 07-12.
Download


Paper Citation


in Harvard Style

Lemos F., Costa C. and Vidal V. (2010). USING SQL/XML FOR EFFICIENTLY TRANSLATING QUERIES OVER XML VIEW OF RELATIONAL DATA . In Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8425-04-1, pages 269-274. DOI: 10.5220/0002909302690274


in Bibtex Style

@conference{iceis10,
author={Fernando Lemos and Clayton Costa and Vânia Vidal},
title={USING SQL/XML FOR EFFICIENTLY TRANSLATING QUERIES OVER XML VIEW OF RELATIONAL DATA},
booktitle={Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2010},
pages={269-274},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002909302690274},
isbn={978-989-8425-04-1},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 12th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - USING SQL/XML FOR EFFICIENTLY TRANSLATING QUERIES OVER XML VIEW OF RELATIONAL DATA
SN - 978-989-8425-04-1
AU - Lemos F.
AU - Costa C.
AU - Vidal V.
PY - 2010
SP - 269
EP - 274
DO - 10.5220/0002909302690274