A Survey of Query Languages for Geographic Information Systems

Aufaure-Portier, Marie-Aude; Trépied, Claude

doi:10.14236/ewic/ids1996.1

Cited by 13 publications

(2 citation statements)

References 25 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…A semi-structured interview approach in addition to the SUS was chosen above methods such as heuristic evaluation or cognitive walkthroughs to evaluate usability given that these methods often require the input of those with specialist experience to guide the assessment process [ 30 ]. Furthermore, the use of semi-structured interviews and content analysis allowed the end-users and researcher to utilise natural language as a method to assess usability, avoiding the need for expert input, additional learning by end-users or potential ambiguity in analysing results associated with other structured query language (SQL) such as graphical and visual languages [ 31 ]. The open-ended interview approach aimed to generate discussion not only on the usability of the tool but also general themes of data utilisation, visualisation and personal experience.…”

Section: Methodsmentioning

confidence: 99%

Evaluating the usability and acceptability of a geographical information system (GIS) prototype to visualise socio-economic and public health data

et al. 2021

View full text Add to dashboard Cite

Background Understanding the impact of socio-economic inequality on health outcomes is arguably more relevant than ever before given the global repercussions of Covid-19. With limited resources, innovative methods to track disease, population needs, and current health and social service provision are essential. To best make use of currently available data, there is an increasing reliance on technology. One approach of interest is the implementation and integration of mapping software. This research aimed to determine the usability and acceptability of a methodology for mapping public health data using GIS technology. Methods Prototype multi-layered interactive maps were created demonstrating relationships between socio-economic and health data (vaccination and admission rates). A semi-structured interview schedule was developed, including a validated tool known as the System Usability Scale (SUS), which assessed the usability of the mapping model with five stakeholder (SH) groups. Fifteen interviews were conducted across the 5 SH and analysed using content analysis. A Kruskal-Wallis H test was performed to determine any statistically significant difference for the SUS scores across SH. The acceptability of the model was not affected by the individual use of smart technology among SHs. Results The mean score from the SUS for the prototype mapping models was 83.17 out of 100, indicating good usability. There was no statistically significant difference in the usability of the maps among SH (p = 0.094). Three major themes emerged with respective sub-themes from the interviews including: (1) Barriers to current use of data (2) Design strengths and improvements (3) Multiple benefits and usability of the mapping model. Conclusion Irrespective of variations in demographics or use of smart technology amongst interviewees, there was no significant difference in the usability of the model across the stakeholder groups. The average SUS score for a new system is 68. A score of 83.17 was calculated, indicative of a “good” system, as falling within the top 10% of scores. This study has provided a potential digital model for mapping public health data. Furthermore, it demonstrated the need for such a digital solution, as well as its usability and future utilisation avenues among SH.

show abstract

Section: Methodsmentioning

confidence: 99%

Evaluating the usability and acceptability of a geographical information system (GIS) prototype to visualise socio-economic and public health data

et al. 2021

View full text Add to dashboard Cite

show abstract

“…Using a complex query, an aggregated value (e.g., a count or an average) from a large data set can be calculated. Complex queries are typical in various application domains such as Enterprise information systems [9], Geographical information systems [10], Bioinformatics [11] and CAD systems [12]. The sample data of the present paper relate to Enterprise information systems.…”

Section: Introductionmentioning

confidence: 99%

Performance of Graph and Relational Databases in Complex Queries

2022

View full text Add to dashboard Cite

In developing NoSQL databases, a major motivation is to achieve better efficient query performance compared with relational databases. The graph database is a NoSQL paradigm where navigation is based on links instead of joining tables. Links can be implemented as pointers, and following a pointer is a constant time operation, whereas joining tables is more complicated and slower, even in the presence of foreign keys. Therefore, link-based navigation has been seen as a more efficient query approach than using join operations on tables. Existing studies strongly support this assumption. However, query complexity has received less attention. For example, in enterprise information systems, queries are usually complex so data need to be collected from several tables or by traversing paths of graph nodes of different types. In the present study, we compared the query performance of a graph-based database system (Neo4j) and relational database systems (MySQL and MariaDB). The effect of different efficiency issues (e.g., indexing and optimization) were included in the comparison in order to investigate the most efficient solutions for different query types. The outcome is that although Neo4j is more efficient for simple queries, MariaDB is essentially more efficient when the complexity of queries increases. The study also highlighted how dramatically the efficiency of relational database has grown during the last decade.

show abstract

About Ambiguities in Visual GIS Query Languages: a Taxonomy and Solutions

Favetta

Aufaure-Portier

2000

Lecture Notes in Computer Science

View full text Add to dashboard Cite

A Survey of Query Languages for Geographic Information Systems

Cited by 13 publications

References 25 publications

Evaluating the usability and acceptability of a geographical information system (GIS) prototype to visualise socio-economic and public health data

Evaluating the usability and acceptability of a geographical information system (GIS) prototype to visualise socio-economic and public health data

Performance of Graph and Relational Databases in Complex Queries

About Ambiguities in Visual GIS Query Languages: a Taxonomy and Solutions

Contact Info

Product

Resources

About