The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
Path Expressions in SQL: A User Study on Query Formulation
|
|
Author(s): Marko Junkkari (School of Information Sciences, University of Tampere, Tampere, Finland), Johanna Vainio (School of Information Sciences, University of Tampere, Tampere, Finland), Kati Iltanen (School of Information Sciences, University of Tampere, Tampere, Finland), Paavo Arvola (School of Information Sciences, University of Tampere, Tampere, Finland), Heidi Kari (School of Information Sciences, University of Tampere, Tampere, Finland)and Jaana Kekäläinen (School of Information Sciences, University of Tampere, Tampere, Finland)
Copyright: 2016
Volume: 27
Issue: 3
Pages: 22
Source title:
Journal of Database Management (JDM)
Editor(s)-in-Chief: Keng Siau (City University of Hong Kong, Hong Kong SAR)
DOI: 10.4018/JDM.2016070101
Purchase
|
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.
Related Content
|
Pasi Raatikainen, Samuli Pekkola, Maria Mäkelä.
© 2024.
30 pages.
|
|
Zhongliang Li, Yaofeng Tu, Zongmin Ma.
© 2024.
25 pages.
|
|
Zongmin Ma, Daiyi Li, Jiawen Lu, Ruizhe Ma, Li Yan.
© 2024.
32 pages.
|
|
Lavlin Agrawal, Pavankumar Mulgund, Raj Sharman.
© 2024.
37 pages.
|
|
Jizi Li, Xiaodie Wang, Justin Z. Zhang, Longyu Li.
© 2024.
34 pages.
|
|
Amit Singh, Jay Prakash, Gaurav Kumar, Praphula Kumar Jain, Loknath Sai Ambati.
© 2024.
25 pages.
|
|
Ruizhe Ma, Weiwei Zhou, Zongmin Ma.
© 2024.
21 pages.
|
|
|