Skip to: search, navigation, or content.

Indiana University Bloomington

Operations & Decision Technologies

Kelley Advantage

Our Operations, Analytics and Information Systems faculty have written many of the definitive textbooks in the areas of operations, data analysis, database management, networking, and Excel modeling.

Recent Publications

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


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.


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.