{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:53:46Z","timestamp":1781110426613,"version":"3.54.1"},"reference-count":31,"publisher":"IGI Global Scientific Publishing","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2009,10,1]]},"abstract":"<p>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.<\/p>","DOI":"10.4018\/jdm.2009062502","type":"journal-article","created":{"date-parts":[[2010,4,30]],"date-time":"2010-04-30T08:37:32Z","timestamp":1272616652000},"page":"26-53","source":"Crossref","is-referenced-by-count":6,"title":["Designing Document SQL (DSQL)"],"prefix":"10.4018","volume":"20","author":[{"given":"Arijit","family":"Sengupta","sequence":"first","affiliation":[{"name":"Wright State University, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"V.","family":"Ramesh","sequence":"additional","affiliation":[{"name":"Indiana University, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"issue":"4","key":"jdm.2009062502-0","doi-asserted-by":"crossref","first-page":"727","DOI":"10.1007\/BF01354881","article-title":"The Power of Languages for the Manipulation of Complex Values.","volume":"4","author":"S.Abiteboul","year":"1995","journal-title":"The VLDB Journal"},{"key":"jdm.2009062502-1","doi-asserted-by":"crossref","first-page":"68","DOI":"10.1007\/s007990050005","article-title":"The Lorel Query language for Semistructured Data.","volume":"1","author":"S.Abiteboul","year":"1997","journal-title":"International Journal on Digital Libraries"},{"key":"jdm.2009062502-2","unstructured":"ANSI\/ISO. (2003). ANSI TC NCITS H2 ISO\/IEC JTC 1\/SC 32\/WG 3 Database (ISO-ANSI Working Draft) Information Technology - Database Languages - SQL - Part 14: XML-Related Specifications (SQL\/XML)."},{"key":"jdm.2009062502-3","unstructured":"Boag, S., Chamberlin, D., Fernandez, M., Florescu, D., Robie, J., & Simeon, J. (2007). XQuery 1.0: An XML Query Language. Retrieved from http:\/\/www.w3.org\/TR\/xquery\/"},{"issue":"1","key":"jdm.2009062502-4","doi-asserted-by":"crossref","first-page":"76","DOI":"10.1007\/s007780050084","article-title":"UnQL: a query language and algebra for semistructured data based on structural recursion.","volume":"9","author":"P.Buneman","year":"2000","journal-title":"VLDB Journal: Very Large Data Bases"},{"key":"jdm.2009062502-5","unstructured":"Cattell, R. G. G., Barry, D., Bartels, D., Berler, M., Eastman, J., Gamerman, S., et al. (1997). The Object Database Standard: ODMG 2.0."},{"key":"jdm.2009062502-6","unstructured":"Chamberlain, D., Fankhauser, P., Florescu, D., Marchiori, M., & Robie, J. (2002). XML Query Use Cases."},{"key":"jdm.2009062502-7","doi-asserted-by":"crossref","unstructured":"Chamberlin, D., Clark, J., Florescu, D., Robie, J., Simeon, J., & Stefanescu, M. (2001). XQuery 1.0: An XML Query Language.","DOI":"10.1007\/3-540-45271-0_1"},{"key":"jdm.2009062502-8","doi-asserted-by":"crossref","unstructured":"Chamberlin, D., Fankhauser, P., Marchiori, M., & Robie, J. (2003). XML Query (XQuery) Requirements - W3C Working Draft 12 November 2003.","DOI":"10.1145\/872757.872877"},{"key":"jdm.2009062502-9","first-page":"1","article-title":"Quilt: an XML Query Language for Heterogeneous Data Sources. The World Wide Web and Databases, Third International Workshop WebDB 2000, Dallas, Texas, USA, May 18-19, 2000","volume":"1997","author":"D.Chamberlin","year":"2001","journal-title":"Selected Papers"},{"issue":"2","key":"jdm.2009062502-10","doi-asserted-by":"crossref","first-page":"313","DOI":"10.1145\/191843.191901","article-title":"From Structured Documents to Novel Query Facilities.","volume":"23","author":"V.Christophides","year":"1994","journal-title":"SIGMOD Record"},{"key":"jdm.2009062502-11","unstructured":"Clark, J., & DeRose, S. (1999). XML Path Language XPath Version 1.0. Retrieved from http:\/\/www.w3.org\/TR\/xpath"},{"issue":"5","key":"jdm.2009062502-12","doi-asserted-by":"crossref","first-page":"279","DOI":"10.1016\/S0306-4379(98)00013-1","article-title":"Designing OQL: Allowing Objects To Be Queried.","volume":"23","author":"S.Cluet","year":"1998","journal-title":"Information Systems"},{"issue":"1","key":"jdm.2009062502-13","doi-asserted-by":"crossref","first-page":"71","DOI":"10.1023\/A:1009934820999","article-title":"An Empirical Investigation of Factors Influencing Object-Oriented Database Querying.","volume":"2","author":"P.De","year":"2001","journal-title":"Information Technology and Management"},{"key":"jdm.2009062502-14","unstructured":"Deach, S. (1998). Extensible Style Language (XSL) Specification."},{"key":"jdm.2009062502-15","doi-asserted-by":"crossref","unstructured":"Deutsch, A., Fernandez, M., Florescu, D., Levy, A., & Suciu, D. (1998). XML-QL: A query language for XML.","DOI":"10.1016\/S1389-1286(99)00020-1"},{"key":"jdm.2009062502-16","unstructured":"Draper, D., Fankhauser, P., Fernandez, M., Malhotra, A., Rose, K., Rys, M., et al. (2007). XQuery 1.0 and XPath 2.0 Formal Semantics. Retrieved from http:\/\/www.w3.org\/TR\/xquery-semantics\/"},{"key":"jdm.2009062502-17","unstructured":"Fernandez, M., Malhotra, A., Marsh, J., Nagy, M., & Walsh, N. (2007). XQuery 1.0 and XPath 2.0 Data Model (XDM). Retrieved from http:\/\/www.w3.org\/TR\/xpath-datamodel\/"},{"key":"jdm.2009062502-18","unstructured":"Kepser, S. (2003). A Simple Proof for the Turing-Completeness of XSLT and XQuery. Paper presented at the Proceedings: ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems."},{"key":"jdm.2009062502-19","unstructured":"Le Hors, A., Le Hegaret, P., Wood, L., Nicol, G., Robie, J., Champion, M., et al. (2004). Document Object Model (DOM) Level 3 Core Specification. Retrieved from http:\/\/www.w3.org\/TR\/2004\/REC-DOM-Level-3-Core-20040407\/"},{"key":"jdm.2009062502-20","doi-asserted-by":"crossref","first-page":"50","DOI":"10.1214\/aoms\/1177730491","article-title":"On a test of whether one of two random variables is stochastically larger than the other.","volume":"18","author":"H. B.Mann","year":"1947","journal-title":"Annals of Mathematical Statistics"},{"key":"jdm.2009062502-21","unstructured":"O'Reilly, T. (2005). What is Web 2.0 - Design Patterns and Business Models for the Next Generation of Software."},{"key":"jdm.2009062502-22","unstructured":"Robie, J., Lapp, J., & Schach, D. (1998). XML Query Language (XQL)."},{"key":"jdm.2009062502-23","unstructured":"Sengupta, A., & Mohan, S. (2003, March). Formal and conceptual models for XML structures - the past, present and future."},{"key":"jdm.2009062502-24","first-page":"230","article-title":"On Computable Numbers, with an Application to the Entscheidungsproblem.","volume":"42","author":"A.Turing","year":"1936","journal-title":"Proceedings of the London Mathematical Society"},{"key":"jdm.2009062502-25","doi-asserted-by":"crossref","unstructured":"Van den Bussche, J., & Vossen, G. (1993). An Extension of Path Expressions to Simplify Navigation in Object-Oriented Queries. Paper presented at the Proceedings of the third international conference on Deductive and Object-Oriented Databases (DOOD).","DOI":"10.1007\/3-540-57530-8_17"},{"key":"jdm.2009062502-26","doi-asserted-by":"crossref","first-page":"63","DOI":"10.1287\/isre.2.1.63","article-title":"Cognitive Fit: An Imperical Study of Information Acquisition.","volume":"2","author":"I.Vessey","year":"1991","journal-title":"Information Systems Research"},{"issue":"1","key":"jdm.2009062502-27","first-page":"2","article-title":"Human Factors Studies of Database Query Languages: SQL as a metric.","volume":"1","author":"C.Welty","year":"1990","journal-title":"Journal of Database Administration"},{"issue":"4","key":"jdm.2009062502-28","doi-asserted-by":"crossref","first-page":"626","DOI":"10.1145\/319628.319656","article-title":"Human Factors Comparison of a Procedural and a Nonprocedural Query Language.","volume":"6","author":"C.Welty","year":"1981","journal-title":"ACM Transactions on Database Systems"},{"key":"jdm.2009062502-29","doi-asserted-by":"crossref","unstructured":"Wyss, C. M., & Van Gucht, D. (2001). A Relational Algebra for Data\/Metadata Integration in a Federated Database System. Paper presented at the Proceedings of the 2001 ACM CIKM International Conference on Information and Knowledge Management.","DOI":"10.1145\/502585.502597"},{"issue":"1","key":"jdm.2009062502-30","doi-asserted-by":"crossref","first-page":"110","DOI":"10.1145\/383034.383038","article-title":"XRel: A Path-Based Approach to Storage and Retrieval of XML Documents Using Relational Databases.","volume":"1","author":"M.Yoshikawa","year":"2001","journal-title":"ACM Transactions on Internet Technology"}],"container-title":["Journal of Database Management"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=37211","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T22:59:59Z","timestamp":1654124399000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdm.2009062502"}},"subtitle":["An Accessible yet Comprehensive Ad-Hoc Querying Frontend for Query"],"short-title":[],"issued":{"date-parts":[[2009,10,1]]},"references-count":31,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2009,10]]}},"URL":"https:\/\/doi.org\/10.4018\/jdm.2009062502","relation":{},"ISSN":["1063-8016","1533-8010"],"issn-type":[{"value":"1063-8016","type":"print"},{"value":"1533-8010","type":"electronic"}],"subject":[],"published":{"date-parts":[[2009,10,1]]}}}