skip to main content
10.1145/1807167.1807288acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

Graphical XQuery in the aqualogic data services platform

Published: 06 June 2010 Publication History

Abstract

The AquaLogic Data Services Platform (ALDSP) is a middleware platform developed at BEA Systems for building services, referred to as data services, that integrate, access, and manipulate information coming from multiple heterogeneous sources of data (including databases, files, and other services). ALDSP uses functions that produce and consume XML to model heterogeneous information sources, so the integration logic for data access services in ALDSP is specified declaratively using the XQuery language. A challenge that we faced in developing ALDSP was providing effective graphical tooling to help data service developers to develop information integration queries. In this paper, we describe the graphical XQuery Editor (XQE) that resulted from our attempt to tackle this challenge. XQE handles the full XQuery language and provides a robust two-way editing experience involving both graphical and source views of each query. XQE is novel in being the first commercial graphical XQuery editor to support both of these features.

References

[1]
A. Raffio, et al. Clip: a visual language for explicit schema mappings. In ICDE, pages 30--39, 2008.
[2]
B. Alexe, et al. Stbenchmark: towards a benchmark for mapping systems. Proc. VLDB Endow., 2008.
[3]
BEA. Transforming data using the XQuery mapper. http://edocs.bea.com/alsb/docs26/dtguide/.
[4]
S. Boag. Building a tokenizer for XPath or XQuery. http://www.w3.org/TR/xquery-xpath-parsing/.
[5]
V. Borkar and M. Carey. Extending XQuery for grouping, duplicate elimination, and outer joins. In XML Conference and Expo., Nov. 2004.
[6]
M. Carey and the ALDSP Team. Data delivery in a service-oriented world: The BEA AquaLogic Data Services Platform. In Proc. of the ACM SIGMOD Conf. on Mgmt. of Data, Chicago, IL, June 2006.
[7]
D. Chamberlin and J. Robie. XQuery 1.1. http://www.w3.org/TR/xquery-11/.
[8]
D. Braga, et al. XQBE (XQuery By Example): A visual interface to the standard XML query language. ACM Trans. Database Syst., 30(2):398--443, 2005.
[9]
G. Robertson, et al. Visualization of mappings between schemas. In CHI 05: Proc. of the SIGCHI conf. on Human factors in computing systems, pages 431--439, New York, NY, 2005. ACM.
[10]
H. Jaakkola and B. Thalheim. Visual SQL - high-quality ER-based query treatment. In ER (Workshops), volume 2814 of Lecture Notes in Computer Science, pages 129--139. Springer, 2003.
[11]
K. Beyer, et al. Extending XQuery for analytics. In SIGMOD'05: Proc. of the 2005 ACM SIGMOD intl. conf. on mgmt. of data, New York, NY, 2005.
[12]
N. Mangtani and M. Carey. Liquid Data: XQuery-based enterprise information integration. In BEA WebLogic Developer's Journal, April 2003.
[13]
Oracle Corporation. ODSI 10gR3 (10.3). http://download.oracle.com/docs/cd/E13162_01/odsi/docs10gr3/.
[14]
Stylus Studio. XQuery Mapper. http://www.stylusstudio.com/xquery mapper.html.
[15]
V. Borkar, et al. XML data services. In Intl. Journal of Web Services Research, 2006.
[16]
V. Borkar, et al. XQSE: An XQuery Scripting Extension for the AquaLogic Data Services Platform. In Proc. of the 24th Intl. Conf. on Data Engineering, Cancun, Mexico, April 12-17 2008. IEEE.

Cited By

View all
  • (2019)An Automatic Data Service Generation Approach for Cross-origin DatasetsWeb Engineering10.1007/978-3-030-19274-7_27(374-390)Online publication date: 26-Apr-2019
  • (2013)LCRA, XML Keyword Search System, and LotusX, Graphical Query Processing SystemAn Introduction to XML Query Processing and Keyword Search10.1007/978-3-642-34555-5_8(267-283)Online publication date: 28-Jan-2013

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
June 2010
1286 pages
ISBN:9781450300322
DOI:10.1145/1807167
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 06 June 2010

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. data services
  2. graphical user interface
  3. information integration
  4. service-oriented architecture
  5. xml
  6. xquery

Qualifiers

  • Research-article

Conference

SIGMOD/PODS '10
Sponsor:
SIGMOD/PODS '10: International Conference on Management of Data
June 6 - 10, 2010
Indiana, Indianapolis, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)5
  • Downloads (Last 6 weeks)2
Reflects downloads up to 10 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2019)An Automatic Data Service Generation Approach for Cross-origin DatasetsWeb Engineering10.1007/978-3-030-19274-7_27(374-390)Online publication date: 26-Apr-2019
  • (2013)LCRA, XML Keyword Search System, and LotusX, Graphical Query Processing SystemAn Introduction to XML Query Processing and Keyword Search10.1007/978-3-642-34555-5_8(267-283)Online publication date: 28-Jan-2013

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media