Accelerating SQL with Complex Visual Querying
Autor(a) principal: | |
---|---|
Data de Publicação: | 2021 |
Tipo de documento: | Dissertação |
Idioma: | eng |
Título da fonte: | Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
Texto Completo: | http://hdl.handle.net/10362/151776 |
Resumo: | This dissertation addresses the usability improvement of a graphical user interface that allows query formulation without using textual query languages, such as SQL. This visual tool, called Aggregates, is provided on the OutSystems Low-Code Development Platform, to formulate data queries, through interaction and manipulation of visual components. Since Aggregates do not support all the existing functionalities of SQL, the OutSys- tems Platform allows users to build queries using this textual query language. Nonethe- less, by evaluating customers’ SQL queries, it was revealed that a considerable subset of the queries written in SQL could have been formulated using the visual tool. The users’ interviews and the results of the SQL queries evaluation have foreseen that the cause of the reduced acceptance of the visual approach, could be the existing usability problems on the interface. Furthermore, the interface is inadequate to build more complex queries, which involve more entities and conditions. Through an iterative design process, this dissertation includes the design, implemen- tation, and evaluation of prototypes with different fidelity levels. The aim is to optimize the effectiveness and efficiency of the process where users communicate to the system what data they intend to extract from the database. Moreover, the readability and com- prehension improvement of the query visual representation is intended, reducing the time and the effort required to understand what data will be gathering from the database. The final implemented interface is currently incorporated on the OutSystems Platform to accelerate the query formulation process without harming the learnability of the system. |
id |
RCAP_04e502c15ec0f35c1e28121f3af6df17 |
---|---|
oai_identifier_str |
oai:run.unl.pt:10362/151776 |
network_acronym_str |
RCAP |
network_name_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository_id_str |
7160 |
spelling |
Accelerating SQL with Complex Visual QueryingVisual Query InterfacesLow-Code DevelopmentUser-Centered DesignHuman-computer InteractionIterative DesignDatabase QueryingDomínio/Área Científica::Engenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e InformáticaThis dissertation addresses the usability improvement of a graphical user interface that allows query formulation without using textual query languages, such as SQL. This visual tool, called Aggregates, is provided on the OutSystems Low-Code Development Platform, to formulate data queries, through interaction and manipulation of visual components. Since Aggregates do not support all the existing functionalities of SQL, the OutSys- tems Platform allows users to build queries using this textual query language. Nonethe- less, by evaluating customers’ SQL queries, it was revealed that a considerable subset of the queries written in SQL could have been formulated using the visual tool. The users’ interviews and the results of the SQL queries evaluation have foreseen that the cause of the reduced acceptance of the visual approach, could be the existing usability problems on the interface. Furthermore, the interface is inadequate to build more complex queries, which involve more entities and conditions. Through an iterative design process, this dissertation includes the design, implemen- tation, and evaluation of prototypes with different fidelity levels. The aim is to optimize the effectiveness and efficiency of the process where users communicate to the system what data they intend to extract from the database. Moreover, the readability and com- prehension improvement of the query visual representation is intended, reducing the time and the effort required to understand what data will be gathering from the database. The final implemented interface is currently incorporated on the OutSystems Platform to accelerate the query formulation process without harming the learnability of the system.Esta dissertação apresenta um estudo sobre o melhoramento da usabilidade de uma inter- face gráfica que permite consultar dados sem recorrer a linguagens de consulta textuais, tais como o SQL. A ferramenta visual abordada, denominada Aggregates, está inserida na Plataforma de Desenvolvimento Low-Code OutSystems, de modo a permitir a formula- ção de consultas a bases de dados, através da interação e manipulação de componentes visuais. Tendo em conta que a interface gráfica disponibilizada não suporta todos os tipos de consultas suportadas pelo SQL, os utilizadores podem recorrer a esta linguagem textual para construir as suas pesquisas. No entanto, ao avaliar estas consultas criadas textual- mente em SQL, por clientes da plataforma, percebeu-se que um conjunto considerável de consultas foram construídas usando SQL, embora pudessem ter sido construídas usando a ferramenta visual disponibilizada. Tanto as entrevistas aos utilizadores, como a análise das consultas construídas usando SQL, indicaram que a falta de aceitação do método visual de construção de consultas era causada por problemas de usabilidade na interface. Para além disso, quando as consultas de dados envolvem mais entidades ou condições, os utilizadores sentem dificuldade a usar a interface. Através de um processo de desenho iterativo, esta dissertação apresenta o desenho, im- plementação e avaliação de protótipos com diferentes níveis de fidelidade. Foi optimizada a eficácia e a eficiência do processo de utilização da interface para consultar dados. Além disso, também se melhorou a legibilidade da representação visual da consulta, de modo a diminuir o tempo e esforço necessário para compreender que dados pretendem ser extraídos da base de dados. A implementação final da interface encontra-se atualmente incorporada na Plataforma OutSystems, acelerando o processo de criação de consultas de dados sem dificultar a aprendizagem necessária para utilizar o sistema.Romão, TeresaNóbrega, RuiSimões, TiagoRUNRodrigues, Pedro Santos2023-04-13T09:00:26Z2021-012021-01-01T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10362/151776enginfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2024-03-11T05:34:08Zoai:run.unl.pt:10362/151776Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-20T03:54:41.489211Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse |
dc.title.none.fl_str_mv |
Accelerating SQL with Complex Visual Querying |
title |
Accelerating SQL with Complex Visual Querying |
spellingShingle |
Accelerating SQL with Complex Visual Querying Rodrigues, Pedro Santos Visual Query Interfaces Low-Code Development User-Centered Design Human-computer Interaction Iterative Design Database Querying Domínio/Área Científica::Engenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e Informática |
title_short |
Accelerating SQL with Complex Visual Querying |
title_full |
Accelerating SQL with Complex Visual Querying |
title_fullStr |
Accelerating SQL with Complex Visual Querying |
title_full_unstemmed |
Accelerating SQL with Complex Visual Querying |
title_sort |
Accelerating SQL with Complex Visual Querying |
author |
Rodrigues, Pedro Santos |
author_facet |
Rodrigues, Pedro Santos |
author_role |
author |
dc.contributor.none.fl_str_mv |
Romão, Teresa Nóbrega, Rui Simões, Tiago RUN |
dc.contributor.author.fl_str_mv |
Rodrigues, Pedro Santos |
dc.subject.por.fl_str_mv |
Visual Query Interfaces Low-Code Development User-Centered Design Human-computer Interaction Iterative Design Database Querying Domínio/Área Científica::Engenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e Informática |
topic |
Visual Query Interfaces Low-Code Development User-Centered Design Human-computer Interaction Iterative Design Database Querying Domínio/Área Científica::Engenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e Informática |
description |
This dissertation addresses the usability improvement of a graphical user interface that allows query formulation without using textual query languages, such as SQL. This visual tool, called Aggregates, is provided on the OutSystems Low-Code Development Platform, to formulate data queries, through interaction and manipulation of visual components. Since Aggregates do not support all the existing functionalities of SQL, the OutSys- tems Platform allows users to build queries using this textual query language. Nonethe- less, by evaluating customers’ SQL queries, it was revealed that a considerable subset of the queries written in SQL could have been formulated using the visual tool. The users’ interviews and the results of the SQL queries evaluation have foreseen that the cause of the reduced acceptance of the visual approach, could be the existing usability problems on the interface. Furthermore, the interface is inadequate to build more complex queries, which involve more entities and conditions. Through an iterative design process, this dissertation includes the design, implemen- tation, and evaluation of prototypes with different fidelity levels. The aim is to optimize the effectiveness and efficiency of the process where users communicate to the system what data they intend to extract from the database. Moreover, the readability and com- prehension improvement of the query visual representation is intended, reducing the time and the effort required to understand what data will be gathering from the database. The final implemented interface is currently incorporated on the OutSystems Platform to accelerate the query formulation process without harming the learnability of the system. |
publishDate |
2021 |
dc.date.none.fl_str_mv |
2021-01 2021-01-01T00:00:00Z 2023-04-13T09:00:26Z |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/masterThesis |
format |
masterThesis |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://hdl.handle.net/10362/151776 |
url |
http://hdl.handle.net/10362/151776 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.source.none.fl_str_mv |
reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação instacron:RCAAP |
instname_str |
Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
instacron_str |
RCAAP |
institution |
RCAAP |
reponame_str |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
collection |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) |
repository.name.fl_str_mv |
Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação |
repository.mail.fl_str_mv |
|
_version_ |
1799138135342317568 |