Welcome to the InfoSci Platform
Reference Hub4
Path Expressions in SQL: A User Study on Query Formulation

Path Expressions in SQL: A User Study on Query Formulation

Marko Junkkari, Johanna Vainio, Kati Iltanen, Paavo Arvola, Heidi Kari, Jaana Kekäläinen
Copyright: © 2016 |Volume: 27 |Issue: 3 |Pages: 22
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781466688841|DOI: 10.4018/JDM.2016070101
Cite Article Cite Article

MLA

Junkkari, Marko, et al. "Path Expressions in SQL: A User Study on Query Formulation." JDM vol.27, no.3 2016: pp.1-22. http://doi.org/10.4018/JDM.2016070101

APA

Junkkari, M., Vainio, J., Iltanen, K., Arvola, P., Kari, H., & Kekäläinen, J. (2016). Path Expressions in SQL: A User Study on Query Formulation. Journal of Database Management (JDM), 27(3), 1-22. http://doi.org/10.4018/JDM.2016070101

Chicago

Junkkari, Marko, et al. "Path Expressions in SQL: A User Study on Query Formulation," Journal of Database Management (JDM) 27, no.3: 1-22. http://doi.org/10.4018/JDM.2016070101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

This article focuses on testing a path-oriented querying approach to hierarchical data in relational databases. The authors execute a user study to compare the path-oriented approach and traditional SQL from two perspectives: correctness of queries and time spent in querying. They also analyze what kinds of errors are typical in path-oriented SQL. Path-oriented query languages are popular in the context of object-orientation and XML. However, relational databases are the most common paradigm for storing data and SQL is most common for manipulating data. When querying hierarchical data in SQL, the user must specify join conditions explicitly between hierarchy levels. Path-oriented SQL is a new alternative for expressing hierarchical queries in relational databases. In the authors' study, the users spent significantly less time in writing path-oriented SQL queries and made fewer errors in query formulation.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.