Skip to main content
SpringerLink
Log in

XQBE: A Graphical Environment to Query XML Data

  • Published:
World Wide Web Aims and scope Submit manuscript

Abstract

XQuery, the standard query language for XML, is increasingly popular among computer scientists with SQL background, since XQuery and SQL require comparable skills. However, these experts are limited in number, and the availability of easier XQuery “dialects” could be extremely valuable. With this motivation in mind, we designed XQBE, a visual dialect of XQuery inspired by the QBE language (Query by Example). Coherent with the hierarchical nature of XML, XQBE uses one or more hierarchical structures to denote the input documents and one structure to denote the document produced in output. These structures are annotated to express selection predicates; explicit binding edges connecting the nodes of these structures visualize the input/output mappings. This paper presents XQBE through several examples and describes the main features of our implementation of the language, a visual editor coupled with an XQBE-to-XQuery translator. Indeed, the XQBE front-end is a general purpose user-friendly visual query interface, capable of providing access to any data storage system that exposes XQuery APIs. Available schema information can be exploited to guide users in querying data sets they are not familiar with. Also, switching between the visual and textual versions of the same query could be helpful for XQuery learners.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. M. Angelaccio, T. Catarci, and G. Santucci, “QBD*: A graphical query language with recursion,” IEEE Transactions on Software Engineering 16(10), 1990, 1150–1163.

    Article  Google Scholar 

  2. L. Bouganim, T. Chan-Sine-Ying, T.-T. Dang-Ngoc, J. L. Darroux, G. Gardarin, and F. Sha, “Miro web: Integrating multiple data sources through semistructured data types,” in Proc. of the 25th Int. Conf. on Very, Large Data, Bases (VLDB’99), Edinburgh, Scotland, UK, 1999, pp. 750–753.

  3. D. Braga, and A. Campi, 2003, “XQBE, W,eb Site”. http://dbgroup.elet.polimi.it/XQBE.

  4. D. Braga, A. Campi, and S. Ceri, “A graphical environment to query XML data with XQuery,” in Proc. of the ACM-SAC 2003, Melbourne, Florida, USA, 2003

  5. D. Braga, A. Campi, and S. Ceri, 2005, “XQBE (XQuery by example): A visual interface to the standard XML query language,” ACM Transactions on Database Systems (TODS). To appear in June 2005.

  6. M. Carey, L. Haas, V. Maganty, and J. Williams, “PESTO: An integrated querybrowser for object databases”. in D. McLeod, R. Sacks-Davis, and H. Schek (eds.), in Proc. of the 22nd Int. Conf. on Very, Large Data, Bases (VLDB’96), 1996, pp. 203–214.

  7. T. Catarci, M. F. Costabile, S. Levialdi, and C. Batini, “Visual query systems: Analysis and comparison,” ACM TODS—Transactions on Database Systems 8(2), 1997, 215–260.

    Google Scholar 

  8. S. Chawathe, T. Baby, and J. Yeo, “VQBD: Exploring semistructured data (demonstration description),” in Proc. of the ACM SIGMOD, 2001, p. 603.

  9. S. Cohen, Y. Kanza, Y. A. Kogan, W. Nutt, Y. Sagiv, and A. Serebrenik, “EquiX easy querying in XML databases,” in WebDB (Informal, Proceedings), 1999, pp. 43–48.

  10. S. Cohen, Y. Kanza, Y. A. Kogan, W. Nutt, Y. Sagiv, and A. Serebrenik, “Combining the power of searching and querying,” in 5th Int. Conf. on Cooperative, Information Systems, 2000.

  11. S. Comai, E. Damiani, and P. Fraternali, “Computing graphical queries over XML data,” ACM TOIS 19(4), 2001, 371–430.

    Article  Google Scholar 

  12. S. Comai, E. Damiani, R. Posenato, and L. Tanca, “A schema based approach to modeling and querying WWW data,” in FQAS’98.1998, pp. 110–125.

  13. M. P. Consens, and A. O. Mendelzon, “The G+/GraphLog visual query system,” in Proc. of the 1990 ACM SIGMOD, Atlantic, City, NJ, May 23–25, 1990, p. 388.

  14. I. F. Cruz, A. O. Mendelzon, and P. T. Wood, “A graphical query language supporting recursion,” in Proc. of the ACM SIGMOD 1987, pp. 323–330.

  15. I. F. Cruz, A. O. Mendelzon, and P. T. Wood, “G+: Recursive queries without recursion,” in 2nd Int. Conf. on Expert, Database Systems, 1988, pp. 355–368.

  16. M. Fernandez, J. Siméon, P. Wadler, S. Cluet, A. Deutsch, D. Florescu, A. Levy, D. Maier, J. McHugh, J. Robie, D. Suciu, and J. Widom, 1999, “XML query languages: Experiences and exemplars,” http://www-db.research.belllabs.com/user/simeon/xquery.ps.

  17. I. M. R. E. Filha, A. H. F. Laender, and A. S. da Silva, “Querying semistructured data by example: The, Qsbye interface,” in Workshop on Information, Integration on the Web, 2001, pp. 156–163.

  18. Fraunhofer Gesellschaft IPSI: 2003, “IPSI-XQ — The, XQuery Demonstrator”. http://ipsi.fhg.de/oasys/projects/ipsi-xq/index_e.html

  19. Z. G. Ives and Y. Lu, “XML query languages in practice: An evaluation,” in Proc. of WAIM’00, 2000, pp. 29–40.

  20. G. Jaeschke and H. J. Schek, “Remarks on the algebra on non first normal form relations,” in Proc. of 1st ACM SIGACT-SIGMOD, Symposium on the Principles of Database, Systems, 1982, pp. 124–138.

  21. B. Ludaescher, Y. Papakonstantinou, P. Velikhov, and V. Vianu, “View, Definition and DTD, inference for XML,” in Proc. Post-IDCT, Workshop, 1999.

  22. K. Munroe and Y. Papakonstantinou, “BBQ: A visual interface for browsing and querying XML,” in Proc. of the 5th Working Conference on Visual Database Systems, 2000, pp. 277–296.

  23. Y. Papakonstantinou, M. Petropoulos, and V. Vassalos, “QURSED: querying and reporting semistructured data,” in Proc. of the ACM SIGMOD, 2002.

  24. J. Paredaens, J. V. den Bussche, M. Andries, M. Gemis, M. Gyssens, I. Thyssens, D. V. Gucht, V. Sarathy, and L. V. Saxton, “An overview of GOOD,” SIGMOD Record 21(1), 1992, 25–31.

    Google Scholar 

  25. J. Paredaens, P. Peelman, and L. Tanca, “G-Log a declarative graph-based language,” IEEE, T,rans. on Knowledge and Data Eng, 1995.

  26. M. Petropoulos, V. Vassalos, and Y. Papakonstantinou, “XML Query Forms (XQForms): Declarative, Specification of XML Query Interfaces,” in Proc. of the 10th WWW, Conference, 2001.

  27. W3C: 2004a, “XML, Query Use, Cases,” http://www.w3.org/TR/xmlquery-use-cases

  28. W3C: 2004b, “XQuery: An, XML, query language,” http://www.w3.org/XML/Query

  29. M. M. Zloof, “Query-by-Example: A data base language,” IBM, Systems Journal 16(4), 1977, 324–343.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Politecnico di Milano - Dipartimento di Elettronica e Informazione, Piazza Leonardo da Vinci 32, 20133, Milano, Italy

    Daniele Braga & Alessandro Campi

Authors
  1. Daniele Braga
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Alessandro Campi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Daniele Braga.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Braga, D., Campi, A. XQBE: A Graphical Environment to Query XML Data. World Wide Web 8, 287–316 (2005). https://doi.org/10.1007/s11280-005-0646-x

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s11280-005-0646-x

Keywords

Search

Navigation