Document SQL (DSQL): A conservative extension to SQL as an ad-hoc querying frontend for XQuery
Book Chapter
Sengupta, A, Ramesh, V. (2011). Document SQL (DSQL): A conservative extension to SQL as an ad-hoc querying frontend for XQuery
. 316-344. 10.4018/978-1-60960-521-6.ch013
Sengupta, A, Ramesh, V. (2011). Document SQL (DSQL): A conservative extension to SQL as an ad-hoc querying frontend for XQuery
. 316-344. 10.4018/978-1-60960-521-6.ch013
This chapter 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 query optimization techniques; while at the same time allows easy integration into current databases and applications that use SQL. 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.
