Skip to main content

2018 | OriginalPaper | Buchkapitel

The Utility of the Abstract Relational Model and Attribute Paths in SQL

verfasst von : Weicong Ma, C. Maria Keet, Wayne Oldford, David Toman, Grant Weddell

Erschienen in: Knowledge Engineering and Knowledge Management

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche um passende Fachinhalte oder Patente zu finden.

search-config
loading …

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Fußnoten
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.
 
Literatur
1.
Zurück zum Zitat 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 query answering over first order knowledge bases. In: Proceedings of KR 2016, pp. 319–328. ACM (2016)
3.
Zurück zum Zitat 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)CrossRef 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)CrossRef
4.
Zurück zum Zitat 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) 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)
5.
Zurück zum Zitat 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) 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)
6.
Zurück zum Zitat 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)CrossRef 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)CrossRef
7.
Zurück zum Zitat 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) 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)
8.
Zurück zum Zitat Ma, W.: On the Utility of Adding an Abstract Domain and Attribute Paths to SQL. Master’s thesis, University of Waterloo (2018) Ma, W.: On the Utility of Adding an Abstract Domain and Attribute Paths to SQL. Master’s thesis, University of Waterloo (2018)
9.
Zurück zum Zitat Mylopoulos, J., Bernstein, P.A., Wong, H.K.T.: A language facility for designing database-intensive applications. ACM TODS 5(2), 185–207 (1980)CrossRef Mylopoulos, J., Bernstein, P.A., Wong, H.K.T.: A language facility for designing database-intensive applications. ACM TODS 5(2), 185–207 (1980)CrossRef
10.
Zurück zum Zitat 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)CrossRef 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)CrossRef
11.
Zurück zum Zitat 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) 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)
12.
Zurück zum Zitat Vainio, J., Junkkari, M.: SQL-based semantics for path expressions over hierarchical data in relational databases. J. Info. Sci. 40(3), 293–312 (2014)CrossRef Vainio, J., Junkkari, M.: SQL-based semantics for path expressions over hierarchical data in relational databases. J. Info. Sci. 40(3), 293–312 (2014)CrossRef
13.
Zurück zum Zitat Weddell, G.: Reasoning about functional dependencies generalized for semantic data models. TODS 17(1), 32–64 (1992)MathSciNetCrossRef Weddell, G.: Reasoning about functional dependencies generalized for semantic data models. TODS 17(1), 32–64 (1992)MathSciNetCrossRef
Metadaten
Titel
The Utility of the Abstract Relational Model and Attribute Paths in SQL
verfasst von
Weicong Ma
C. Maria Keet
Wayne Oldford
David Toman
Grant Weddell
Copyright-Jahr
2018
DOI
https://doi.org/10.1007/978-3-030-03667-6_13