Abstract
It is well-known that querying information is difficult for domain experts, for they are not familiar with querying actual relational schemata due to the notions of primary and foreign keys and the various ways of representing and storing information in a relational database. To overcome these problems, the Abstract Relational Model and the query language, SQLP, have been proposed. They are the theoretical foundations and ensure that explicit primary and foreign keys are hidden from the user’s view and that queries can be expressed more compactly. In this paper we evaluate these theoretical advantages with user studies that compare SQLP to plain SQL as the baseline. The experiments show significant statistical evidence that SQLP indeed requires less time for understanding and authoring queries, with no loss in accuracy. Considering the positive results, we develop a method to reverse engineer legacy relational schemata into abstract relational ones.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
This is essentially the syntax for SQL’s create table commands.
- 2.
as stated in their abstract; despite efforts, we were not able to obtain the full paper.
References
Borgida, A., Toman, D., Weddell, G.: On referring expressions in query answering over first order knowledge bases. In: Proceedings of KR 2016, pp. 319–328. ACM (2016)
Borgida, A., Toman, D., Weddell, G.: On referring expressions in information systems derived from conceptual modelling. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 183–197. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-46397-1_14
Bowen, P.L., O’Farrell, R.A., Rohde, F.H.: An empirical investigation of end-user query development: the effects of improved model expressiveness vs. complexity. Info. Syst. Res. 20(4), 565–584 (2009)
Calvanese, D., Keet, C.M., Nutt, W., RodrÃguez-Muro, M., Stefanoni, G.: Web-based graphical querying of databases through an ontology: the WONDER system. In: Proceedings of ACM SAC 2010, pp. 1389–1396. ACM (2010)
Jacques, J.S., Toman, D., Weddell, G.E.: Object-relational queries over \(\cal{CFDI}_\mathit{}nc\) knowledge bases: OBDA for the SQL-Literate. In: IJCAI 2016, pp. 1258–1264 (2016)
Jih, W.J., Bradbard, D.A., Snyder, C.A., Thompson, N.G.A.: The effects of relational and entity-relationship data models on query performance of end-users. Int. J. Man-Mach. Stu. 31(3), 257–267 (1989)
Junkkari, M., Vainio, J., Iltanenan, K., Arvola, P., Kari, H., Kekäläinen, J.: Path expressions in SQL: a user study on query formulation. J. DB Mgmt. 22(3), 22p (2016)
Ma, W.: On the Utility of Adding an Abstract Domain and Attribute Paths to SQL. Master’s thesis, University of Waterloo (2018)
Mylopoulos, J., Bernstein, P.A., Wong, H.K.T.: A language facility for designing database-intensive applications. ACM TODS 5(2), 185–207 (1980)
Siau, K.L., Chan, H.C., Wei, K.K.: Effects of query complexity and learning on novice user query performance with conceptual and logical database interfaces. IEEE Trans. Sys., Man Cybern. 34(2), 276–281 (2004)
Toman, D., Weddell, G.E.: On adding inverse features to the description logic \(\cal{CFD}^{\forall }_{\mathit{}nc}\). In: Proceedings of PRICAI 2014, pp. 587–599 (2014)
Vainio, J., Junkkari, M.: SQL-based semantics for path expressions over hierarchical data in relational databases. J. Info. Sci. 40(3), 293–312 (2014)
Weddell, G.: Reasoning about functional dependencies generalized for semantic data models. TODS 17(1), 32–64 (1992)
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Switzerland AG
About this paper
Cite this paper
Ma, W., Keet, C.M., Oldford, W., Toman, D., Weddell, G. (2018). The Utility of the Abstract Relational Model and Attribute Paths in SQL. In: Faron Zucker, C., Ghidini, C., Napoli, A., Toussaint, Y. (eds) Knowledge Engineering and Knowledge Management. EKAW 2018. Lecture Notes in Computer Science(), vol 11313. Springer, Cham. https://doi.org/10.1007/978-3-030-03667-6_13
Download citation
DOI: https://doi.org/10.1007/978-3-030-03667-6_13
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-03666-9
Online ISBN: 978-3-030-03667-6
eBook Packages: Computer ScienceComputer Science (R0)