Top

Software and Systems Modeling

Published in:

26-12-2022 | Regular Paper

Visual query languages to design complex queries: a systematic literature review

Authors: Edson Silva, Robson Fidalgo, Márcio Ferro, Natália Franco

Published in: Software and Systems Modeling | Issue 4/2023

Activate our intelligent search to find suitable subject content or patents.

search-config

AI-assisted search

Off

Abstract

Structured query language (SQL) is a widely used language for accessing both relational and non-relational databases. SQL is the standard form of access in relational databases, while in non-relational databases, SQL is becoming increasingly available and consolidating itself as an access interface for querying data in cluster environments. Despite its declarative syntax, the specification of SQL queries is not a trivial task, even for experts, because some queries demand complex constructs (i.e., subqueries, joins, set operations, conditional expressions, grouping restrictions, and recursion). Visual query languages (VQLs) are an alternative to reduce this complexity. However, although several VQLs have been proposed, they are not widely used in practice. By identifying and analyzing the support provided by VQLs that make it possible to design complex SQL queries, this study collected evidence that helps discover the strengths and weaknesses of each VQL, providing useful feedback for other research initiatives that seek to propose improved VQLs. For this purpose, a systematic literature review was carried out. After analyzing 22 relevant studies and performing 462 inspections, this review points to the need for more expressive VQLs, computer-aided software engineering (CASE) tools available to end users, and more rigorous evaluations to investigate the VQL syntax and semantics.

previous article Flexmi: a generic and modular textual syntax for domain-specific modelling

next article MBIPV: a model-based approach for identifying privacy violations from software requirements

Dont have a licence yet? Then find out more about our products and how to get one now:

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!

inform now

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!

inform now

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!

inform now

http://www.core.edu.au/.

https://www.covidence.org—a meta-analysis tool to assist in screening the search results to identify the included studies, carry out the risk of bias assessment and data extraction.

http://queryvis.com/online.

https://dsqlcase.github.io.

Abouzied, A., Hellerstein, J., Silberschatz, A.: Dataplay: Interactive tweaking and example-driven correction of graphical database queries. In: Proceedings of the 25th Annual ACM Symposium on User Interface Software and Technology, UIST ’12, pp. 207–218. ACM, New York, NY, USA (2012). https://doi.org/10.1145/2380116.2380144

ACM, IEEE: Computer science curricula,: curriculum guidelines for undergraduate degree programs in computer science. ACM, NY, USA 2013, 999133 (2013)

ACM/IEEE: Information technology curricula 2017: curriculum guidelines for baccalaureate degree programs in information technology. ACM, NY, USA (2017)

Amazon: Amazon dynamodb documentation. https://docs.amazonaws.cn/en_us/dynamodb/index.html (2021). Accessed: 2021-01-20

Amazon: Mariadb server documentation. https://mariadb.com/kb/en/documentation/ (2021). Accessed: 2021-01-20

Apache: Apache drill. https://drill.apache.org/docs/drill-introduction/ (2021). Accessed: 2021-01-20

Badampudi, D., Wohlin, C., Petersen, K.: Experiences from using snowballing and database searches in systematic literature studies. In: Proceedings of the 19th International Conference on Evaluation and Assessment in Software Engineering, pp. 1–10 (2015)

Badre, A.N., Catarci, T., Massari, A., Santucci, G.: Comparative ease of use of a diagrammatic vs. an iconic query language. In: IDS, p. 4 (1996)

Bakke, E., Karger, D.R.: Expressive query construction through direct manipulation of nested relational results. In: Proceedings of the 2016 International Conference on Management of Data, SIGMOD ’16, pp. 1377–1392. ACM, New York, NY, USA (2016). https://doi.org/10.1145/2882903.2915210

10.

Bloesch, A.C., Halpin, T.A.: Conceptual queries using conquer-ii. In: International Conference on Conceptual Modeling, pp. 113–126. Springer (1997)

11.

Borges, C.R., Macías, J.A.: Feasible database querying using a visual end-user approach. In: Proceedings of the 2Nd ACM SIGCHI Symposium on Engineering Interactive Computing Systems, EICS ’10, pp. 187–192. ACM, New York, NY, USA (2010). https://doi.org/10.1145/1822018.1822047

12.

Brambilla, M., Cabot, J., Wimmer, M.: Model-Driven Software Engineering in Practice: Second Edition. Synthesis Lectures on Software Engineering 3(1), 1–207 (2017). https://doi.org/10.2200/S00751ED2V01Y201701SWE004

13.

Catarci, T., Costabile, M.F., Levialdi, S., Batini, C.: Visual query systems for databases: a survey. J. Vis. Lang. Comput. 8(2), 215–260 (1997)CrossRef

14.

Catarci, T., Santucci, G.: Diagrammatic vs textual query languages: a comparative experiment, pp. 69–83. Springer US, Boston, MA (1995). https://doi.org/10.1007/978-0-387-34905-3_5

15.

Cerullo, C., Porta, M.: A system for database visual querying and query visualization: Complementing text and graphics to increase expressiveness. In: 18th International Workshop on Database and Expert Systems Applications (DEXA 2007), pp. 109–113 (2007). https://doi.org/10.1109/DEXA.2007.91

16.

Chamberlin, D.: SQL in encyclopedia of database systems, pp. 2753–2760. Springer US, Boston, MA (2009). https://doi.org/10.1007/978-0-387-39940-9_1091

17.

Czejdo, B.D., Tucci, R.P., Embley, D.W., Liddle, S.W.: Graphical query specification with participation constraints. In: Computing and Information, 1993. Proceedings ICCI ’93., Fifth International Conference on, pp. 433–437 (1993). https://doi.org/10.1109/ICCI.1993.315334

18.

Darmawikarta, D.: Oracle SQL. a beginner’s tutorial. Brainy Software Inc, Boston (2016)

19.

DeMarco, T.: Structure analysis and system. in: specification pioneers and their contributions to software engineering. Springer, Cham (1979)

20.

El-Mahgary, S., Soisalon-Soininen, E.: A form-based query interface for complex queries. J. Vis. Lang. Comput. 29, 15–53 (2015). https://doi.org/10.1016/j.jvlc.2015.03.001CrossRef

21.

Epstein, R.G.: The tabletalk query language. J. Vis. Lang. Comput. 2(2), 115–141 (1991). https://doi.org/10.1016/S1045-926X(05)80026-6CrossRef

22.

Gryz, J., Wang, Q., Qian, X., Zuzarte, C.: Sql queries with case expressions. in: foundations of intelligent systems. Springer, Berlin Heidelberg, Berlin (2008)CrossRef

23.

Halpin, T., Bloesch, A.: Data modeling in uml and orm: a comparison. J. Database Manage.(JDM) 10(4), 4–13 (1999)CrossRef

24.

Harel, D.: On visual formalisms. Commun. ACM 31(5), 514–530 (1988). https://doi.org/10.1145/42411.42414MathSciNetCrossRef

25.

Hvorecký, J., Drlík, M., Munk, M.: The effect of visual query languages on the improvement of information retrieval skills. procedia - social and behavioral sciences 2(2), 717 – 723 (2010). https://doi.org/10.1016/j.sbspro.2010.03.090. innovation and creativity in education

26.

Ioannidis, Y.E.: Visual user interfaces for database systems. ACM Comput. Surv. 28, 4 (1996). https://doi.org/10.1145/242224.242399CrossRef

27.

Jaakkola, H., Thalheim, B.: Visual SQL - high-quality ER-based query treatment. Springer, Berlin Heidelberg, Berlin (2003)CrossRef

28.

Kawash, J.: Complex quantification in structured query language (sql): a tutorial using relational calculus. J. Computers Math. Sci. Teach. 23(2), 169–190 (2004)

29.

Keim, D.A., Lum, V.: Visual query specification in a multimedia database system. In: Proceedings of the 3rd Conference on Visualization ’92, VIS ’92, pp. 194–201. IEEE Computer Society Press, Los Alamitos, CA, USA (1992)

30.

Keramopoulos, E., Pouyioutas, P., Sadler, C.: Goql, a graphical query language for object-oriented database systems. In: Proceedings of the 3rd Basque International Workshop on Information Technology (BIWIT ’97), BIWIT ’97, pp. 35–. IEEE Computer Society, Washington, DC, USA (1997)

31.

Kitchenham, B., Charters, S.: Guidelines for performing systematic literature reviews in software engineering. Keele University and Durham University Joint Report, Tech. rep. (2007)

32.

Klug, A.C.: Abe: A query language for constructing aggregates-by-example. In: Proceedings of the 1st LBL Workshop on Statistical Database Management, SSDBM’81, pp. 190–205. Lawrence Berkeley Laboratory, Berkeley, CA, US (1981)

33.

Kwak, J.C., Moon, S.: Two-dimensional specification of queries in object-oriented databases. Microprocess. Microprogram. 41(3), 227–244 (1995). https://doi.org/10.1016/0165-6074(95)00005-9CrossRef

34.

Leventidis, A., Zhang, J., Dunne, C., Gatterbauer, W., Jagadish, H., Riedewald, M.: Queryvis: Logic-based diagrams help users understand complicated sql queries faster. In: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data, pp. 2303–2318 (2020)

35.

Lloret-Gazo, J.: A survey on visual query systems in the web era. In: Hartmann, S., Ma, H. (eds.) Database and expert systems applications. Springer International Publishing, Cham (2016)

36.

Maxwell, J.A.: Qualitative research design: an interactive approach. Sage publications, London (2012)

37.

Microsoft: Azure cosmos db. https://azure.microsoft.com/pt-br/services/cosmos-db/ (2021). Accessed: 2021-01-20

38.

Mohan, L., Kashyap, R.L.: A visual query language for graphical interaction with schema-intensive databases. IEEE Trans. Knowl. Data Eng. 5(5), 843–858 (1993). https://doi.org/10.1109/69.243513CrossRef

39.

MongoDB: Mongodb connector for spark. https://docs.mongodb.com/spark-connector/current/ (2021). Accessed: 2021-01-20

40.

Moody, D.: The physics of notations: toward a scientific basis for constructing visual notations in software engineering. IEEE Trans. Softw. Eng. 35(6), 756–779 (2009). https://doi.org/10.1109/TSE.2009.67CrossRef

41.

Mun-Kew, L., Boon-Siong, C., Chun-Hong, K., Jyh-Jang, L., Narasimhalu, D.: The implementation of a visual language interface for an object-oriented multimedia database system. J. Vis. Lang. Comput. 1(3), 275–289 (1990). https://doi.org/10.1016/S1045-926X(05)80010-2CrossRef

42.

Murray, N.S., Paton, N.W., Goble, C.A., Bryce, J.: Kaleidoquery-a flow-based visual language and its evaluation. J. Vis. Lang. Comput. 11(2), 151–189 (2000). https://doi.org/10.1006/jvlc.1999.0150CrossRef

43.

Ramos, H.B.: Design and implementation of a graphical sql with generic capabilities. In: Cooper, R. (ed.) Interfaces to database systems (IDS92). Springer, London (1993)

44.

Santucci, G., Sottile, P.A.: Query by diagram: a visual environment for querying databases. Softw: Pract Exp 23(3), 317–340 (1993)

45.

Silva, E., Franco, N., Ferro, M., Fidalgo, R.: Mental workload impact of a visual language on understanding sql queries. In: Brazilian Symposium on Computers in Education (Simpósio Brasileiro de Informática na Educação-SBIE), vol. 30, p. 239 (2019)

46.

Sockut, G.H., Burns, L.M., Malhotra, A., Whang, K.Y.: Graqula: a graphical query language for entity-relationship or relational databases. Data Knowl. Eng. 11(2), 171–202 (1993). https://doi.org/10.1016/0169-023X(93)90004-9CrossRefMATH

47.

Song, E., Yin, S., Ray, I.: Using uml to model relational database operations. Computer Standards & Interfaces 29(3), 343–354 (2007). https://doi.org/10.1016/j.csi.2006.05.006CrossRef

48.

Spark: Spark sql. https://spark.apache.org/sql/ (2021). Accessed: 2021-01-20

49.

StackOverflow: Stack overflow developer survey results 2019. https://insights.stackoverflow.com/survey/2019 (2019). Accessed: 2019-12-14

50.

Tan, K.P., Chan, H.C., Siau, K.L.: A graphical knowledge level approach for user-database interaction. In: Proceedings., Fourteenth Annual International Computer Software and Applications Conference, pp. 453–458 (1990). https://doi.org/10.1109/CMPSAC.1990.139408

51.

Tansel, A.U., Arkun, M.E., Ozsoyoglu, G.: Time-by-example query language for historical databases. IEEE Trans. Softw. Eng. 15(4), 464–478 (1989). https://doi.org/10.1109/32.16597CrossRefMATH

52.

VoltDB: Voltdb documentation. https://docs.voltdb.com/UsingVoltDB/sqlref_select.php (2021). Accessed: 2021-01-20

53.

Ware, C.: Chapter 9 - images, words, and gestures. In: Ware, C. (ed.) Information visualization (second edition), interactive technologies, second, edition Academic Press, San Diego (2004)

54.

Whang, K.Y., Malhotra, A., Sockut, G.H., Burns, L., Choi, K.S.: Two-dimensional specification of universal quantification in a graphical database query language. IEEE Trans. Softw. Eng. 18(3), 216–224 (1992). https://doi.org/10.1109/32.126770CrossRef

55.

Zhang, G., Chu, W.W., Meng, F., Kong, G.: Query formulation from high-level concepts for relational databases. In: Proceedings User Interfaces to Data Intensive Systems, pp. 64–74 (1999). https://doi.org/10.1109/UIDIS.1999.791463

56.

Zloof, M.M., et al.: Query by example. In: AFIPS national computer conference, vol. 44, pp. 431–438 (1975)

Title: Visual query languages to design complex queries: a systematic literature review
Authors: Edson Silva
Robson Fidalgo
Márcio Ferro
Natália Franco
Publication date: 26-12-2022
Publisher: Springer Berlin Heidelberg
Published in: Software and Systems Modeling / Issue 4/2023
Print ISSN: 1619-1366
Electronic ISSN: 1619-1374
DOI: https://doi.org/10.1007/s10270-022-01071-4

Springer Professional

Abstract

Please log in to get access to your license.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Springer Professional "Wirtschaft"

Springer Professional "Technik"

Other articles of this Issue 4/2023

A generic framework for representing and analyzing model concurrency

MBIPV: a model-based approach for identifying privacy violations from software requirements

The complexities of the satisfiability checking problems of feature diagram sublanguages

Flexmi: a generic and modular textual syntax for domain-specific modelling

On the use of domain knowledge for process model repair

CalcGraph: taming the high costs of deep learning using models

Premium Partner