Skip to: search, navigation, or content.


Indiana University Bloomington

Doctoral Programs

1960 Notable

From 1960-2013, we prepared nearly 1,200 men and women
for rewarding academic careers — that’s more than any other university.

Journal Articles

Designing Document SQL (DSQL)- an Accessible Yet Comprehensive Ad-hoc Querying Frontend for XQuery

2009, Journal of Database Management

A. Sengupta, Ramesh Venkataraman

Abstract

This article presents DSQL, a conservative extension of SQL, as an ad-hoc query language for XML. The development of DSQL follows the theoretical foundations of first order logic, and uses common query semantics already accepted for SQL. DSQL represents a core subset of XQuery that lends well to optimization techniques, while at the same time allows easy integration into current databases and applications that useSQL. The intent of DSQL is not to replace XQuery, the current W3C recommended XML query language, but to serve as an ad-hoc querying frontend to XQuery. Further, the authors present proofs for important query language properties such as complexity and closure. An empirical study comparing DSQL and XQuery for the purpose of ad-hoc querying demonstrates that users perform better with DSQL for both flat and tree structures, in terms of both accuracy and efficiency.

Citation

Sengupta, A and V. Ramesh (2009), "Designing Document SQL (DSQL)- an Accessible Yet Comprehensive Ad-hoc Querying Frontend for XQuery," Journal of Database Management, Vol. 20, No. 4, October, pp. 26-53.